enwiki:Pages in WikiProject Women% and WikiProject History of Science without trwiki interwikis (page_assessments table)

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 = "WikiProject France")
INNER JOIN page_assessments as2 ON as2.pa_page_id=page_id AND as2.pa_project_id=327
WHERE 
    page_namespace = 0 AND
    page_id IN (SELECT DISTINCT ll_from FROM langlinks WHERE ll_lang='ku' AND ll_title IN (SELECT page_title FROM page WHERE page_namespace = 0 AND page_id IN (SELECT ll_from FROM langlinks WHERE ll_lang='ku')))
ORDER BY FIELD(imp,"En","Çok","Orta","Az","Bilinmeyen"), page_title;

SQL

Checking query status...