Untitled query #8047

SQL

USE rowiki_p;
SELECT DISTINCT p.page_title FROM page p
INNER JOIN categorylinks c ON c.cl_from = p.page_id
INNER JOIN oldimage o ON o.oi_name = p.page_title
LEFT JOIN categorylinks c1 ON p.page_id = c1.cl_from AND c1.cl_to = 'Non-free_files_with_orphaned_versions_more_than_7_days_old'
LEFT JOIN categorylinks c2 ON p.page_id = c2.cl_from AND c2.cl_to = 'Non-free_files_with_orphaned_versions'
WHERE p.page_namespace = 6
AND c.cl_to = 'All_non-free_media'
AND o.oi_deleted = 0
AND c1.cl_from IS NULL
AND c2.cl_from IS NULL
SQL

Checking query status...
