enwiki:Pages in WikiProject History of Science and WikiProject_Biography without trwiki interwikis

SQL

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_Biography_articles" count 10;
  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" count 10;

SQL

Checking query status...