Untitled query #89200

SQL

SELECT 
    CONCAT('User page: ', REPLACE(upage.page_title, '_', ' ')) AS userpage,
    CONCAT('Category: ', REPLACE(cl.cl_to, '_', ' ')) AS categoryname
FROM categorylinks cl
JOIN page AS upage ON upage.page_id = cl.cl_from
JOIN page AS mainpage ON mainpage.page_title = cl.cl_to AND mainpage.page_namespace = 0
WHERE upage.page_namespace = 2
  AND cl.cl_to NOT LIKE 'Drafts\_about\_%' 
  AND cl.cl_to NOT LIKE '%\_drafts'
  AND upage.page_id IN (
      SELECT cl_from
      FROM categorylinks
      WHERE cl_to = cl.cl_to
      AND page_namespace = 0e
  )
GROUP BY userpage, categoryname
LIMIT 100;
SQL

Checking query status...
