Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
Fork of
Year-title articles not assigned to WikiProjects
by
The Anome
This query is marked as a draft
This query has been published
by
The Anome
.
Detects articles WITH NUMBER-LIKE TITLES that are not assigned to any Wikiprojects, regardless of whether or not they have talk pages.
Toggle Highlighting
SQL
SELECT article.page_title, article.page_id, talk.page_id AS talk_id FROM page AS article LEFT JOIN page_props ON pp_page = article.page_id AND pp_propname = 'disambiguation' LEFT JOIN page AS talk ON talk.page_title = article.page_title AND talk.page_namespace = 1 AND talk.page_is_redirect = 0 WHERE article.page_namespace = 0 AND article.page_title RLIKE "^[-+0-9_]+$" AND pp_page IS NULL AND article.page_is_redirect = 0 AND NOT (article.page_title LIKE "List_of_%") AND NOT (article.page_title LIKE "Lists_of_%") AND NOT EXISTS ( SELECT 1 FROM categorylinks WHERE article.page_id = cl_from AND ( cl_to IN ( "Temporary_maintenance_holdings", "Candidates_for_speedy_deletion", "Requested_RD1_redactions" ) OR cl_to LIKE "%_names" OR cl_to LIKE "%_surnames" OR cl_to LIKE "Lists_of_%" ) ) AND NOT EXISTS ( SELECT 1 FROM templatelinks JOIN linktarget ON lt_id = tl_target_id WHERE tl_from = article.page_id AND lt_namespace = 10 AND ( lt_title IN ( "Wi", "Surname", "Given_name", "Animal_common_name", "Plant_common_name", "Nickname", "Dmbox" ) OR lt_title LIKE "%index%" OR lt_title LIKE "%redirect%" ) ) AND ( (talk.page_id IS NULL) OR ( (talk.page_id IS NOT NULL) AND NOT EXISTS ( SELECT 1 FROM categorylinks WHERE talk.page_id = cl_from AND ( cl_to LIKE "%WikiProject_%" OR cl_to LIKE "%-Class_%_articles" OR cl_to LIKE "%-importance_%_articles" OR cl_to LIKE "%-priority_%_articles" OR cl_to LIKE "Unassessed_%_articles" ) ) AND NOT EXISTS ( SELECT 1 FROM templatelinks JOIN linktarget ON lt_id = tl_target_id WHERE tl_from = talk.page_id AND lt_namespace = 10 AND (lt_title LIKE "%WikiProject_%") ) ) ) ORDER BY article.page_title
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
.
Checking query status...