SQL
x
#DESCRIBE categorylinks;
SELECT CONCAT([[Template:",page_title,"]]"), COUNT(pl_title) from categorylinks
JOIN page ON cl_from = page_id
JOIN pagelinks ON pl_from = page_id
WHERE cl_to = "Artist_(painter)_navigational_boxes"
AND page_namespace = 10
AND pl_namespace = 0
#AND page_title = "Thomas_Eakins"
AND ( NOT EXISTS( SELECT 1 FROM enwiki_p.page WHERE page_title = pl_title AND page_namespace = 0))
GROUP BY page_title
ORDER BY COUNT(pl_title) DESC;
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.