Possibly miscategorized user pages (skwiki)

SQL

USE skwiki_p;

SELECT
    -- p.page_id,
    CONCAT('Redaktor:', REPLACE(p.page_title, '_', ' ')) AS page_title,
    REPLACE(GROUP_CONCAT(cl_to SEPARATOR ';'), '_', ' ') 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
      -- excluding hidden cats
    NOT cl_to REGEXP '^(Wikipédia:|Portál:|Redaktor:|User|Redaktori|Wikipediáni|Opera_users|Helix84)'
      -- excluding common non-content cats, routinely containing user pages
  GROUP BY
    p.page_id
  ORDER BY
    p.page_title
  ;
SQL

Checking query status...
