enwiki:Templates in WikiProject History of Science

SQL

SELECT DISTINCT article.page_id, article.page_title, 
(CASE WHEN article.page_id IN 
 (SELECT DISTINCT page_id FROM page INNER JOIN langlinks ON page_id = ll_from WHERE ll_lang='tr') AND ll_title='tr' THEN ll_title END) as links
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
WHERE
  talk.page_namespace = 11 AND
  article.page_namespace = 10 AND
  cl_to = "Template-Class_history_of_science_articles"
GROUP BY links;

SQL

Checking query status...