enwiki:Pages in WikiProject Autism with trwiki interwikis

SQL

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

Checking query status...
