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=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 REGEXP '^[0-9]'
GROUP BY page_title
LIMIT 500;
SQL

Checking query status...
