enwiki:Pages in WikiProject History of Science with trwiki interwikis and not in trwiki Vikiproje Bilim tarihi (page_assessments table)

SQL

SELECT DISTINCT article.page_id, article.page_len, article.page_title, ll_title, concat('[https://tr.wikipedia.org/w/index.php?title=Tartışma:', replace(ll_title,' ','_'),'&action=edit&preload=Şablon:VikiProje_Bilim_Tarihi/Önyükleme]') as discuss
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'
WHERE
  talk.page_namespace = 1 AND
  article.page_namespace = 0 AND
  ll_title NOT IN (SELECT DISTINCT trarticle.page_title
                   FROM trwiki_p.page trtalk
                   INNER JOIN trwiki_p.page trarticle ON 
                   trtalk.page_title = trarticle.page_title
                   INNER JOIN trwiki_p.categorylinks trcl ON
                   trcl.cl_from = talk.page_id
                   WHERE
                   trtalk.page_namespace = 1 AND
                   trarticle.page_namespace = 0 AND
                   trcl.cl_to  LIKE "Vikiproje_Bilim_tarihi%")
  cl.cl_to = "WikiProject_History_of_Science_articles";

SQL

Checking query status...