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.