SQL
AخA
SELECT DISTINCT article.page_id, article.page_len, article.page_title, ll_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 langlinks ON article.page_id = ll_from AND ll_lang='tr'
WHERE
talk.page_namespace = 1 AND
article.page_namespace = 0 AND
article.page_id IN (SELECT DISTINCT ll_from FROM langlinks WHERE ll_lang='tr') AND
cl_to = "WikiProject_History_of_Science_articles";
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.