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

SQL

SELECT
    ll.ll_title AS ku_page_title,
    page.page_title AS en_page_title,
    page.page_len,
    MAX(as2.pa_project_id) AS pa_project_id, -- Use an aggregate function
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, en_page_title
ORDER BY
    ku_page_title;

SQL

Checking query status...