Fork of Oldest 500 Mainspace articles without a talk page by MPGuy2824
This query is marked as a draft This query has been published by MPGuy2824.

SQL

AخA
 
SELECT  article.page_title, articleC.*
FROM    page AS article
join    revision on page_id=rev_page
join    page as talk on talk.page_namespace=1 and talk.page_title=article.page_title
join    categorylinks as articleC on articleC.cl_from=article.page_id
WHERE   article.page_is_redirect=0
        AND article.page_namespace=0
        and articleC.cl_to="Constituencies_of_the_Lok_Sabha"
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.
All SQL code is licensed under CC0 License.

Checking query status...