SELECT r.id AS r__id
FROM recording r
WHERE (r.id NOT IN
	(
		SELECT r2.id AS r2__id
		FROM recording r2
		LEFT JOIN stats s2 ON r2.id = s2.recording_id
		WHERE (s2.timestamp >= '2008-01-01 00:00:00')
		GROUP BY r2.id
	)
)

SELECT rec.id as rout_id
FROM recording rec
WHERE rec.id NOT IN
(
	SELECT id FROM (
		SELECT recs.id as rec_id
		FROM recording recs
		LEFT JOIN stats s ON (recs.id = s.recording_id)
		WHERE (s.timestamp >= '2008-01-01 00:00:00')
		GROUP BY recs.id
	) as X
)