Possibly miscategorized user pages (skwiki)

SQL

USE skwiki_p;

SELECT
    p.page_id,
    REPLACE(p.page_title, '_', ' ') AS title,
    GROUP_CONCAT(cl_to) AS categories
  FROM
    page p,
    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
    p.page_namespace = 2 AND
    cl_from = p.page_id AND
    cl_to = cat_title AND
    cpp.pp_value IS NULL AND
    NOT cl_to REGEXP '^(Wikipédia:|Portál:|User|Redaktori|Wikipediáni|Opera_users|Helix84)'
  GROUP BY
    p.page_id
  ORDER BY
    p.page_title
  ;

SQL

Checking query status...