Possibly miscategorized user pages (skwiki)

SQL

USE skwiki_p;

SELECT
    page.page_id,
    REPLACE(page.page_title, '_', ' ') AS title,
    GROUP_CONCAT(cl_to) AS categories,
    GROUP_CONCAT(pp_propname) AS pp_names,
    GROUP_CONCAT(pp_value) AS pp_values
  FROM
    page,
    categorylinks,
    category 
      LEFT OUTER JOIN page cp ON cp.page_title = cat_title AND cp.page_namespace = 14
      LEFT OUTER JOIN page_props cpp ON cpp.pp_page = cp.page_id -- AND pp_propname = 'hiddencat'
  WHERE
    page_namespace = 2 AND
    cl_from = page_id AND
    cl_to = cat_title AND
    NOT cl_to REGEXP '^(Wikipédia:|User)'
  GROUP BY
    page_id
  ORDER BY
    page_title
  ;

SQL

Checking query status...