Untitled query #66931

SQL

SELECT DISTINCT page_title, page_len, (CASE 
                	WHEN as2.pa_importance="Top" THEN "En"
                    WHEN as2.pa_importance="High" THEN "Çok"
                    WHEN as2.pa_importance="Mid" THEN "Orta"
                    WHEN as2.pa_importance="Low" THEN "Az"
                    WHEN as2.pa_importance="NA" THEN "Bilinmeyen"
                    WHEN as2.pa_importance="Unknown" THEN "Bilinmeyen"
                 END) as imp FROM page
INNER JOIN page_assessments as1 ON as1.pa_page_id=page_id AND as1.pa_project_id IN 
	(SELECT pap_project_id FROM page_assessments_projects 
     WHERE pap_project_title LIKE "السعودية")
INNER JOIN page_assessments as2 ON as2.pa_page_id=page_id AND as2.pa_project_id=327
WHERE 
page_namespace = 0 AND
/*page_title NOT IN (SELECT DISTINCT tr.page_title FROM trwiki_p.page tr) AND*/
page_id NOT IN (SELECT DISTINCT ll_from FROM langlinks WHERE ll_lang='ar')
ORDER BY FIELD(imp,"En","Çok","Orta","Az","Bilinmeyen"), page_title;
SQL

Checking query status...
