Untitled query #89197

SQL

SELECT draft.page_title AS draftname, cl_to AS categoryname
FROM categorylinks
JOIN page AS draft ON draft.page_id = cl_from
LEFT JOIN page AS catpage ON catpage.page_namespace = 14 AND catpage.page_title = cl_to
LEFT JOIN page_props ON pp_page = catpage.page_id AND pp_propname = 'hiddencat'
LEFT JOIN templatelinks ON tl_from = catpage.page_id
LEFT JOIN linktarget ON lt_id = tl_target_id AND lt_namespace = 10 AND lt_title = 'Maintenance_category'
JOIN categorylinks AS mainspace_categories ON cl_to = mainspace_categories.cl_to
JOIN page AS mainspace_page ON mainspace_page.page_id = mainspace_categories.cl_from
WHERE draft.page_namespace = 118
  AND pp_page IS NULL
  AND tl_from IS NULL
  AND cl_to NOT LIKE 'Drafts\_about\_%'
  AND cl_to NOT LIKE '%\_drafts'
  AND cl_to != 'Namespace_example_pages'
  AND mainspace_page.page_namespace = 0
LIMIT 100;
SQL

Checking query status...
