SQL
AخA
#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'
INNER JOIN externallinks ON el_from = page_id
AND page_namespace = 6
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 '%d-nb.info%'
AND el_to NOT LIKE '%.eea.europa.eu%'
AND el_to NOT LIKE '%historicengland.org.uk%'
AND el_to NOT LIKE '%.loc.gov%'
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;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.