Untitled query #89197

SQL

SELECT 
    CASE 
        WHEN draft.page_namespace = 118 THEN CONCAT('Draft:', draft.page_title)
        WHEN draft.page_namespace = 2 THEN CONCAT('User:', draft.page_title)
        ELSE draft.page_title 
    END 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'
WHERE draft.page_namespace IN (118, 2)
  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 NOT (
      draft.page_namespace = 2 AND 
      (BINARY cl_to LIKE '%User%' OR BINARY cl_to LIKE '%Wikipedians' OR BINARY cl_to LIKE 'Wikipedia%' OR BINARY cl_to LIKE 'WikiProject%' OR BINARY cl_to LIKE '%Task_Force%' OR BINARY cl_to LIKE '%task_force%')
  )
LIMIT 100;
SQL

Checking query status...
