enwiki:Wikiproject Kurdistan articles which doesnt have kuwiki sitelinks

SQL

SELECT
    page.page_title AS page_title,
    CASE 
        WHEN as1.pa_importance = "Top" THEN "Herî zêde"
        WHEN as1.pa_importance = "High" THEN "Zêde"
        WHEN as1.pa_importance = "Mid" THEN "Navîn"
        WHEN as1.pa_importance = "Low" THEN "Kêm"
        WHEN as1.pa_importance = "Unknown" THEN "Nayê zanîn"
    END AS importance
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 = 'Kurdistan')
LEFT JOIN langlinks AS ll ON ll.ll_from = page.page_id AND ll.ll_lang = 'ku'
WHERE 
    page.page_namespace IN (0)  -- Only article pages (namespace 0)
    AND ll.ll_from IS NULL  -- This filters out pages that have a Kurdish language link
    AND as1.pa_importance != "NA"  -- Exclude pages with "NA" importance
GROUP BY
    page.page_title, importance
ORDER BY
    FIELD(
        importance,
        "Herî zêde", "Zêde", "Navîn", "Kêm", "Nayê zanîn"
    ), page.page_title;
SQL

Checking query status...
