Fork of
enwiki:Pages in WikiProject History of Science without trwiki interwikis title like "%mass_destruction%"
by Evolutionoftheuniverse
This query is marked as a draft
This query has been published
by Evolutionoftheuniverse.
SQL
AخA
SELECT DISTINCT article.page_id, article.page_title, article.page_len
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 langlinks ON article.page_id = ll_from AND ll_lang!='tr'
WHERE
talk.page_namespace = 1 AND
article.page_namespace = 0 AND
cl_to = "WikiProject_History_of_Science_articles" AND
article.page_id NOT IN (SELECT DISTINCT ll_from FROM langlinks WHERE ll_lang='tr') ORDER BY article.page_title AND
article.page_title like "Science_and_technology_in%";
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.