Untitled query #59462

SQL

SELECT cl_to AS category, 
COUNT(*) AS count        
FROM thwiki_p.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
SQL

Checking query status...
