(internal) - Quarry

SQL

USE commonswiki_p;
(SELECT CONCAT('# [[:File:', REPLACE (page_title,'_',' '), ']]') AS p
FROM pagelinks pl1
INNER JOIN page
 ON page_title = pl1.pl_title
 AND page_is_redirect = 1
 AND page_namespace = 6
JOIN pagelinks pl2
 ON pl2.pl_title = page_title
 AND pl2.pl_namespace = 6
 AND pl2.pl_from NOT IN (51755049, 61119540, 63412574, 64032037)
 AND pl2.pl_from NOT IN (SELECT ogre.page_id FROM page ogre WHERE ogre.page_namespace = 2 AND ogre.page_title LIKE 'OgreBot%')
 AND pl2.pl_from_namespace % 2 = 0
WHERE pl1.pl_from = 64032037
AND pl1.pl_namespace = 6
)
UNION
(SELECT CONCAT('# [[:File:', REPLACE (page_title,'_',' '), ']]') AS p
FROM pagelinks pl1
INNER JOIN page ON page_title = pl1.pl_title AND page_is_redirect = 1 AND page_namespace = 6
INNER JOIN globalimagelinks ON gil_to = page_title
WHERE pl1.pl_from = 64032037
AND pl1.pl_namespace = 6
)
ORDER BY p
LIMIT 1000;
SQL

Checking query status...
