Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
Fork of
Articles with talk pages but not assigned to WikiProjects
by
The Anome
This query is marked as a draft
This query has been published
by
Qwerfjkl
.
Detects articles with talk pages that are not assigned to any Wikiprojects; Note: deliberately ignores the special case of non-redirect pages with talk page redirects; these will be dealt with at the target talk page anyway March 2023 execution time: 1226 seconds, resultset 68670 rows
Toggle Highlighting
SQL
SELECT article.page_namespace, article.page_title FROM page AS article LEFT JOIN page_props ON pp_page = article.page_id AND pp_propname = 'disambiguation' INNER JOIN page AS talk ON talk.page_title = article.page_title WHERE article.page_namespace = 0 AND talk.page_namespace = 1 AND pp_page IS NULL AND article.page_is_redirect = 0 AND talk.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 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...