Indeed, quite why I didn't just do something like this:
SELECT
t.ID,
t.Title,
(SELECT count(l.log_id) FROM #logs l WHERE l.id = t.id) as AllTime,
(SELECT count(l.log_id) FROM #logs l WHERE l.id = t.id and l.log_date >= DATEADD(mm, -3, getdate()))as Mnth
FROM #Items t
GROUP BY t.id, t.title
Is beyond me, it's only Monday too!