Local images in articles about stadiums

SQL

USE enwiki_p;
SELECT CONCAT('File:', p.page_title) FROM page p
LEFT JOIN categorylinks c1 ON p.page_id = c1.cl_from AND c1.cl_to = "All_non-free_media"
LEFT JOIN redirect on rd_from = p.page_id
LEFT JOIN imagelinks i ON p.page_title = i.il_to AND (i.il_from_namespace = 0)
WHERE p.page_namespace = 6
AND c1.cl_to IS NULL -- Exclude fair use - other processes will handle those
AND rd_title IS NULL -- Exclude redirects
AND (il_from LIKE '%stadium%' or il_from LIKE '%Stadium%' and il_from LIKE '%field%' or il_from LIKE '%Field%')
ORDER BY page_id DESC
LIMIT 20000

SQL

Checking query status...