Untitled query #10833

SQL

USE skwiki_p;
SELECT concat("* [[:File:",REPLACE(REPLACE(p.page_title, '"', '**DOUBLEQUOTE**'), '_', ' '),"]] |", 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
SQL

Checking query status...
