Untitled query #6030

SQL

USE enwiki_p;
SELECT p.page_title FROM page p
INNER JOIN categorylinks c1 ON p.page_id = c1.cl_from
LEFT JOIN imagelinks i ON p.page_title = i.il_to
LEFT JOIN categorylinks c2 ON p.page_id = c2.cl_from AND c2.cl_to = "Wikipedia_orphaned_files"
LEFT JOIN templatelinks t ON t.tl_from = p.page_id
                          AND t.tl_namespace = 10
                          AND t.tl_title IN ('Keep_local','Copy_to_Wikimedia_Commons','Orphan_image','Ffd', 'Puf', 'Deletable_file', 'Db-meta', 'Now_Commons', "NFUR_not_needed", "Wrong-license")
WHERE c1.cl_to = "All_free_media"
AND i.il_from IS NULL
AND c2.cl_from IS NULL
AND t.tl_from IS NULL
AND p.page_namespace = 6
SQL

Checking query status...
