enwiki:Pages in WikiProject Women Scientists without trwiki interwikis

SQL

SELECT DISTINCT article.page_id, REPLACE(article.page_title,'_',' '), article.page_len, 
				(CASE 
                	WHEN cl_to="Top-importance_Women_scientists_articles" THEN "En"
                    WHEN cl_to="High-importance_Women_scientists_articles" THEN "Çok"
                    WHEN cl_to="Mid-importance_Women_scientists_articles" THEN "Orta"
                    WHEN cl_to="Low-importance_Women_scientists_articles" THEN "Az"
                    WHEN cl_to="Unknown-importance_Women_scientists_articles" THEN "Bilinmeyen"
                    WHEN cl_to="NA-importance_Women_scientists_articles" THEN "Bilinmeyen"
                 END) as oenem
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 LIKE "%-importance_Women_scientists_articles" AND
  article.page_id NOT IN (SELECT DISTINCT ll_from FROM langlinks WHERE ll_lang='tr') ORDER BY FIELD(oenem,"En","Çok","Orta","Az","Bilinmeyen"), article.page_title;
SQL

Checking query status...
