USE enwiki_p;

SELECT CONCAT('File:', p.page_title), min(particle.page_title), count(*) 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)

LEFT JOIN page particle ON particle.page_id = il_from

INNER JOIN image ON img_name = p.page_title

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 (particle.page_title LIKE '%stadium%' or particle.page_title LIKE '%Stadium%' and particle.page_title LIKE '%field%' or particle.page_title LIKE '%Field%')

GROUP BY p.page_title having count(*) < 5

ORDER BY p.page_id DESC

​