Uncategorized pages with categories

SQL

SELECT cl_from,
	   COUNT(*) AS '# Categories',
       page.page_title
FROM categorylinks
LEFT JOIN
	page 
   	ON cl_from = page.page_id
WHERE cl_from IN (SELECT cl_from
                  FROM categorylinks
                  WHERE cl_to = 'All_uncategorized_pages')
AND cl_to NOT LIKE 'All_%'
AND cl_to NOT LIKE 'Pages_%'
AND cl_to NOT LIKE '%rticles%'
AND cl_to NOT LIKE '%_stubs'
AND cl_to NOT LIKE '%deletion%'
AND cl_to NOT LIKE '%_Wikidata'
AND cl_to NOT LIKE '%category%'
AND cl_to NOT LIKE '%missing%'
AND cl_to NOT LIKE '%_from_%'
AND cl_to NOT LIKE 'CS1_%'
AND cl_to NOT LIKE '%template%'
AND page_namespace = 0
GROUP BY cl_from
SQL

Checking query status...
