frwiki:Pages in projet Histoire des sciences in frwiki with trwiki interwiki but not in VikiProje Bilim Tarihi (page table)

SQL

USE frwiki_p;
SELECT DISTINCT CONCAT("# [[",ll_title,"]] ([[:fr:",REPLACE(article.page_title,"_"," "),"|fr]])")  #, trtalk.page_title
FROM page talk
INNER JOIN page article ON
  talk.page_title = article.page_title
INNER JOIN categorylinks cl ON
  cl.cl_from = talk.page_id
INNER JOIN langlinks ON article.page_id = ll_from AND ll_lang='tr'
/*INNER JOIN trwiki_p.page trarticle ON replace(ll_title," ","_") = trarticle.page_title AND trarticle.page_namespace=0
INNER JOIN trwiki_p.page trtalk ON trarticle.page_title=trtalk.page_title AND trarticle.page_namespace=1
INNER JOIN trwiki_p.categorylinks trcl ON trcl.cl_from = trtalk.page_id*/
WHERE
  talk.page_namespace = 1 AND
  article.page_namespace = 0 AND
  cl.cl_to LIKE "Article_du_projet_Histoire_des_sciences_d'importance_%" AND
  /*trcl.cl_to!="VikiProje_Bilim_Tarihi_maddeleri"*/
  replace(ll_title," ","_") NOT IN(SELECT DISTINCT article.page_title
FROM trwiki_p.page talk
INNER JOIN trwiki_p.page article ON
  talk.page_title = article.page_title
INNER JOIN trwiki_p.categorylinks ON
  cl_from = talk.page_id
WHERE
  talk.page_namespace = 1 AND
  article.page_namespace = 0 AND
  cl_to  LIKE "Vikiproje_Bilim_tarihi%") AND
  article.page_id IN (SELECT DISTINCT ll_from FROM langlinks WHERE ll_lang='tr');

SQL

Checking query status...