Untitled query #4909

SQL

USE arwiki_p;
SELECT concat("*[[:File:",p.page_title,"]]") FROM page p
INNER JOIN (image e JOIN commonswiki_p.image c ON c.img_sha1 = e.img_sha1) ON e.img_name = p.page_title
LEFT JOIN categorylinks c1 ON c1.cl_from = p.page_id AND c1.cl_to = 'All_Wikipedia_files_with_a_different_name_on_Wikimedia_Commons'
LEFT JOIN categorylinks c2 ON c2.cl_from = p.page_id AND c2.cl_to = 'All_Wikipedia_files_with_the_same_name_on_Wikimedia_Commons'
LEFT JOIN categorylinks c3 ON c3.cl_from = p.page_id AND c3.cl_to = 'Wikipedia_files_on_Wikimedia_Commons_for_which_a_local_copy_has_been_requested_to_be_kept'
WHERE p.page_namespace = 6
AND c1.cl_from IS NULL
AND c2.cl_from IS NULL
AND c3.cl_from IS NULL limit 50;
SQL

Checking query status...
