[lSeverl]

Нет, я думаю должно быть как-то так:
SELECT * FROM Recipients WHERE id in (SELECT id FROM Recipients GROUP BY status WHERE COUNT(*) > 2 AND status='error')