Replicas browser and optimizer
This query is marked as a draft
This query has been published
Linked from a specified page, but not from another
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 #Other page's page ID (faster to check manually than to need to query) 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 #Other page's page ID 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
and you irrevocably agree to release your SQL under
All SQL code is licensed under
Checking query status...
Report a bug!
Wikimedia Cloud VPS
, written in