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

SQL

SELECT DISTINCT article.page_id, CONCAT("[[",REPLACE(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" AND
  article.page_id IN (SELECT DISTINCT article.page_id
                      FROM page talk
                      INNER JOIN page article ON
                      talk.page_title = article.page_title
                      INNER JOIN categorylinks ON
                      cl_from = talk.page_id
                      WHERE
                      talk.page_namespace = 1 AND
                      article.page_namespace = 0 AND
                      cl_to = "WikiProject_History_of_Science_articles") AND
  article.page_title NOT IN (SELECT DISTINCT tr.page_title FROM trwiki_p.page tr);

SQL

Checking query status...