Untitled query #89200

SQL

SELECT 
    CONCAT('User page: ', REPLACE(upage.page_title, '_', ' ')) AS userpage,
    CONCAT('Category: ', REPLACE(cl.cl_to, '_', ' ')) AS categoryname,
    CASE 
        WHEN upage.page_namespace = 1 THEN 'talk page'
        ELSE 'mainpage'
    END AS page_type,
    CASE 
        WHEN upage.page_is_redirect = 1 THEN 'redirect'
        ELSE 'ppage'
    END AS page_redirect_status
FROM categorylinks cl
JOIN page AS upage ON upage.page_id = cl.cl_from AND upage.page_namespace = 2
JOIN page AS mainpage ON mainpage.page_title = cl.cl_to AND mainpage.page_namespace = 0
WHERE cl.cl_to NOT LIKE 'Drafts\_about\_%' 
  AND cl.cl_to NOT LIKE '%\_drafts'
  AND upage.page_id IN (
      SELECT cl_from
      FROM categorylinks
      JOIN page AS main ON main.page_id = cl_from
      WHERE cl.cl_to = cl.cl_to
      AND main.page_namespace = 0 
  )
GROUP BY userpage, categoryname
LIMIT 100;
SQL

Checking query status...
