Voci possibilmente categorizzate nelle categorie sbagliate

SQL

USE itwiki_p;

	SELECT
    	cl1.cl_to, 
        COUNT(cl1.cl_to), 
        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)
    FROM page, categorylinks AS cl1
    WHERE page_id = cl_from
      AND page_namespace = 2
    GROUP BY cl1.cl_to
    HAVING COUNT(cl1.cl_to) > (SELECT COUNT(*)
                           FROM page, categorylinks AS cl2
                           WHERE page_id = cl2.cl_from
                             AND cl2.cl_type <> 'subcat'
                             AND cl2.cl_to = cl1.cl_to
                                     AND page_namespace <> 2)

SQL

Checking query status...