Fork of
All WP Medicine articles in EN
by Mssemantics
This query is marked as a draft
This query has been published
by FShbib.
SQL
AخA
SELECT DISTINCT article.page_id, article.page_title
FROM page talk
INNER JOIN page article ON
talk.page_title = article.page_title
INNER JOIN categorylinks ON
cl_from = talk.page_id
INNER JOIN page d on d.ll_from = d.page_id
AND article.page_id NOT EXISTS (SELECT *
FROM langlinks as t
WHERE t.ll_lang="ar"
and t.ll_from = langlinks.ll_from)
WHERE
talk.page_namespace = 1 AND
article.page_namespace = 0 AND
cl_to = "All_WikiProject_Medicine_articles"
LIMIT 100;
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.