Untitled query #43789

SQL

USE commonswiki_p; #altes_Bild|neues_Bild|reason=Begründung}}
SELECT CONCAT('{{universal replace|', REPLACE (page_title,'_',' '), '|', REPLACE (pl_title,'_',' '), '|reason=file renamed or replaced on Commons}}') AS files
FROM globalimagelinks
INNER JOIN page ON page_title = gil_to AND page_is_redirect = 1 AND page_namespace = 6
INNER JOIN pagelinks ON pl_from = page_id AND pl_namespace = 6
WHERE (gil_page_namespace_id % 2) = 0
#AND gil_page_namespace != 2
#AND page_title LIKE 'C%'
#AND page_title NOT IN (SELECT pl_title FROM pagelinks WHERE pl_from = 52439727 AND pl_namespace = 6)
AND page_title IN (SELECT REPLACE (iwl_title,'File:','') FROM dewiki_p.iwlinks WHERE iwl_from = 11386945)
GROUP BY page_title
LIMIT 500;
SQL

Checking query status...
