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

SQL

SELECT DISTINCT CONCAT("# [[",REPLACE(article.page_title,"_"," "),"]] [[en:",REPLACE(article.page_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
  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
                      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_title NOT IN (SELECT DISTINCT tr.page_title FROM trwiki_p.page tr) AND
  article.page_id NOT IN (SELECT DISTINCT ll_from FROM langlinks WHERE ll_lang='tr') ORDER BY article.page_title;
SQL

Checking query status...
