test2 - Quarry

SQL

#USE stopthisrun;
USE commonswiki_p;
SELECT CONCAT('* [[:File:', REPLACE (page_title,'_',' '), ']]') AS p, CONCAT('→ ', el_to) AS l
FROM pagelinks
INNER JOIN page ON pl_from = 52439727
AND pl_title = page_title
AND page_title NOT LIKE '%.webm'
AND page_title NOT LIKE '%.webp'
AND page_title NOT LIKE '%.xcf'
AND page_title NOT LIKE 'Bundesarchiv%'
INNER JOIN externallinks ON el_from = page_id
AND page_namespace = 6
#do not filter flickr
AND el_to NOT LIKE '%britishmuseum.org%'
AND el_to NOT LIKE '%copyright.gov%'
AND el_to NOT LIKE '%creativecommons.org%'
AND el_to NOT LIKE '%culture.gouv.fr%'
AND el_to NOT LIKE '%cultureelerfgoed.nl%'
AND el_to NOT LIKE '%d-nb.info%'
AND el_to NOT LIKE '%.eea.europa.eu%'
AND el_to NOT LIKE '%.getty.edu/page/ulan/%'
AND el_to NOT LIKE '%historicengland.org.uk%'
AND el_to NOT LIKE '%historicplaces.ca%'
AND el_to NOT LIKE '%.kulturnoe-nasledie.ru%'
AND el_to NOT LIKE '%.loc.gov%'
AND el_to NOT LIKE '%naturvardsverket.se%'
AND el_to NOT LIKE '%nla.gov.au%'
AND el_to NOT LIKE '%.nps.gov%'
AND el_to NOT LIKE '%openstreetmap.org%'
AND el_to NOT LIKE '%wikimediaitalia.owncube.com%'
AND el_to NOT LIKE '%usmint.gov%'
AND el_to NOT LIKE '%viaf.org%'
AND el_to NOT LIKE '%.w3.org%'
AND el_to NOT LIKE '%wellcomeimages.org%'
AND el_to NOT LIKE '%wikimedia.org%'
AND el_to NOT LIKE '%wikipedia.org%'
AND el_to NOT LIKE '%.wmflabs.org%'
AND el_to NOT LIKE '%worldcat.org%'
LIMIT 2000;
SQL

Checking query status...
