Voci possibilmente categorizzate nelle categorie sbagliate

SQL

USE itwiki_p;

	SELECT
    	cl1.cl_to, 
        COUNT(cl1.cl_to), 
        CASE
        	WHEN COUNT(cl1.cl_to) = (SELECT COUNT(*) 
         FROM page, categorylinks AS cl2
         WHERE page_id = cl_from
           AND cl_type <> 'subcat'
           AND cl2.cl_to = cl1.cl_to
                                  AND page_namespace <> 2) THEN
                                  'True' END
    FROM page, categorylinks AS cl1
    WHERE page_id = cl_from
      AND page_namespace = 2
    GROUP BY cl1.cl_to
    HAVING (1 > (SELECT COUNT(cl2.cl_to)
                           FROM page AS p2, categorylinks AS cl2
                           WHERE p2.page_id = cl2.cl_from
                             AND cl2.cl_type <> 'subcat'
                             AND cl2.cl_to = cl1.cl_to
                                AND p2.page_namespace <> 2))
SQL

Checking query status...
