Untitled query #14440

SQL

 SELECT CONCAT( "[[:category:", nome, "|]]")
 FROM (
    SELECT cl_to AS nome, count( * ) AS numero
    FROM categorylinks WHERE cl_to IN (SELECT page_title FROM page WHERE page_namespace = 14) AND cl_to NOT LIKE "%0%" 
    AND cl_to NOT LIKE "%1%"
    AND cl_to NOT LIKE "%2%"
    AND cl_to NOT LIKE "%3%"
    AND cl_to NOT LIKE "%4%"
    AND cl_to NOT LIKE "%5%"
    AND cl_to NOT LIKE "%6%"
    AND cl_to NOT LIKE "%7%"
    AND cl_to NOT LIKE "%8%"
    AND cl_to NOT LIKE "%9%"
    AND cl_to NOT LIKE "%ll%"
    AND cl_to NOT LIKE "%rticles%"
    AND cl_to NOT LIKE "%ontain%"
    AND cl_to NOT LIKE "%iki%"
    AND cl_to NOT LIKE "%nf%"
    AND cl_to NOT LIKE "%ox%"
    AND cl_to NOT LIKE "%ag%"
    AND cl_to NOT LIKE "%se%"
    AND cl_to NOT LIKE "%at%"
    GROUP BY cl_to
 ) AS categorie
 WHERE numero = 1
 ORDER BY numero, nome LIMIT 100
SQL

Checking query status...
