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=58201
WHERE 
page_namespace = 0 
ORDER BY FIELD(imp,"En","Çok","Orta","Az","Bilinmeyen"), page_title;
SQL

Checking query status...
