SQL
AخA
SELECT cl_to AS category, COUNT(*) AS count
FROM categorylinks
WHERE cl_from IN (
SELECT page_id
FROM page
WHERE page_namespace = 118
)
AND cl_to NOT LIKE '%AfC%'
AND cl_to NOT LIKE '%raft%'
AND cl_to NOT LIKE '%Pages%'
AND cl_to NOT LIKE '%pages%'
AND cl_to NOT LIKE '%edirect%'
AND cl_to NOT LIKE '%CS1%'
AND cl_to NOT LIKE '%deletion%'
AND cl_to NOT LIKE '%rticles%'
AND cl_to NOT LIKE '%emplate%'
AND cl_to NOT LIKE '%with%'
AND cl_to NOT LIKE '%tracking%'
AND cl_to NOT LIKE '%nfobox%'
GROUP BY cl_to
ORDER BY COUNT(*) DESC, cl_to ASC;
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.