enwiki:List all pages in WikiProject with kuwiki interwikis (page_assessments table)

SQL

SELECT
    ll.ll_title AS ku_page_title,
    page.page_len,
    MAX(as2.pa_project_id) AS pa_project_id
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 = 'France')
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 = 0
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...