Packages that passed the previous PkgEval report and not the latest

Custom SQL query returning 207 rows (hide)

WITH latest AS (SELECT r.id, r.date FROM pkgeval_reports r WHERE r.kind = 'daily' AND EXISTS (SELECT 1 FROM pkgeval_results x WHERE x.report_id = r.id) ORDER BY r.date DESC LIMIT 2)
SELECT k.name, new.status, new.reason
FROM pkgeval_results new JOIN pkgeval_results old ON old.package_id = new.package_id JOIN packages k ON k.id = new.package_id
WHERE new.report_id = (SELECT id FROM latest ORDER BY date DESC LIMIT 1)
  AND old.report_id = (SELECT id FROM latest ORDER BY date ASC LIMIT 1)
  AND old.status = 'ok' AND new.status != 'ok' ORDER BY k.name

Edit SQL