Untitled query #80746

SQL

SELECT
    ll.ll_title AS ku_page_title
FROM
    page
INNER JOIN page_assessments as1 ON as1.pa_page_id = page.page_id 
    AND as1.pa_project_id IN (SELECT pap_project_id FROM page_assessments_projects WHERE pap_project_title = 'Mythology')
INNER JOIN page_assessments as2 ON as2.pa_page_id = page.page_id
INNER JOIN langlinks AS ll ON ll.ll_from = page.page_id AND ll.ll_lang = 'ku'
WHERE 
    page.page_namespace IN (0, 14, 10)
GROUP BY
    ku_page_title
ORDER BY
    FIELD(
        (CASE 
            WHEN as2.pa_importance = "Top" THEN "Herî zêde"
            WHEN as2.pa_importance = "High" THEN "Zêde"
            WHEN as2.pa_importance = "Mid" THEN "Navîn"
            WHEN as2.pa_importance = "Low" THEN "Kêm"
            WHEN as2.pa_importance = "NA" THEN "NA"
            WHEN as2.pa_importance = "Unknown" THEN "Nayê zanîn"
         END),
        "Herî zêde", "Zêde", "Navîn", "Kêm", "Nayê zanîn"
    ), ku_page_title;
SQL

Checking query status...
