Drafts in non-maintenance categories

Draft pages in categories that are either redlinks, or that aren't hidden and don't transclude {{Maintenance category}}.

Also heuristically excludes categories that start with "Drafts about " or end with " drafts", such as [[Category:Draft articles about horror films]] and [[Category:The CW drafts]]; there are 28 of the former and 132 of the latter, none transclude {{Maintenance category}}, and none of the former and only ten of the latter are hidden.  Probably they should all be fixed, but it seems like more of a hassle than just filtering them out.

Also doesn't consider [[Category:Namespace example pages]], so that [[Draft:Example]] doesn't show up.

For [[WP:VPT#Drafts with categories]] circa 4 November 2022.

SQL

SELECT cl_to AS categoryname, draft.page_title AS draftname
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 = 118
  AND pp_page IS NULL
  AND tl_from IS NULL
  AND cl_to NOT LIKE 'Drafts\_about\_%' -- e.g. [[Category:Draft articles about horror films]] - there's very many of these not transcluding {{Maintenance category}}
  AND cl_to NOT LIKE '%\_drafts' -- e.g. [[Category:The CW drafts]] - there's, again, very many of these not transcluding {{Maintenance category}}
  AND cl_to != 'Namespace_example_pages' -- I can sort of understand why this one doesn't transclude {{Maintenance category}}, but it's very much the odd man out
LIMIT 1000;

SQL

Checking query status...