Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
Fork of
GA/FA and GAN/FAC linked from July 31
by
Coffeeandcrumbs
This query is marked as a draft
This query has been published
by
Coffeeandcrumbs
.
GA/FA and GAN/FAC linked from August 1
Toggle Highlighting
SQL
SELECT page_title #Faster than just selecting the page title and id, but only those are needed FROM page pg1 WHERE pg1.page_namespace = 0 #Only care about articles AND pg1.page_title IN ( #Where page is linked from a specified other page SELECT pl_title FROM pagelinks WHERE pl_from = 1254 #August 1 AND pl_namespace = 0 #Only if the target is an article ) AND pg1.page_title NOT IN ( #Where page is not linked from a different specified other page SELECT pl_title FROM pagelinks WHERE pl_from = 492780 #Wikipedia:Selected anniversaries/August 1 AND pl_namespace = 0 #Only if the target is an article ) AND pg1.page_title NOT IN ( #Where page is not linked from a different specified other page SELECT pl_title FROM pagelinks WHERE pl_from = 61394792 #User:Coffeeandcrumbs/Selected anniversaries/August 1 AND pl_namespace = 0 #Only if the target is an article ) AND ( #AND either the page is in specified categories or the talk page is in a different set of specified categories ( pg1.page_id IN ( #Page is in specified categories SELECT cl_from FROM categorylinks WHERE cl_to IN ("Good_articles", "Featured_articles") #Categories specified for the article ) ) OR ( #Talk page is in specified categories pg1.page_title IN ( #Match article's title to talk page (corresponding talk page's page ID needed for categorylinks lookup) SELECT page_title FROM page pg2 WHERE pg1.page_title = pg2.page_title #Same title AND page_namespace = 1 #Page is a talk page AND page_id IN ( #Talk page is in categories SELECT cl_from FROM categorylinks WHERE cl_to IN ( "Wikipedia_featured_article_candidates", "Good_article_nominees" ) #Categories specified for the talk page ) ) ) ) #LIMIT 10
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...