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, redirect linked from other project}}') 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 'A%'
GROUP BY page_title
LIMIT 5000;
SQL

Checking query status...
