Drafts in non-maintenance categories

This query is marked as a draft This query has been published by Cryptic.

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 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'
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'
LIMIT 1000;

​x
 
SELECT draft.page_title AS draftname, cl_to AS categorynameFROM categorylinksJOIN page AS draft ON draft.page_id = cl_fromLEFT JOIN page AS catpage ON catpage.page_namespace = 14 AND catpage.page_title = cl_toLEFT JOIN page_props ON pp_page = catpage.page_id AND pp_propname = 'hiddencat'LEFT JOIN templatelinks ON tl_from = catpage.page_idLEFT 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\_%'  AND cl_to NOT LIKE '%\_drafts'  AND cl_to != 'Namespace_example_pages'LIMIT 1000;​

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...