Untitled query #81444

SQL

SELECT
    ll.ll_title AS ku_page_title
FROM
    page
INNER JOIN categorylinks AS cl ON cl.cl_from = page.page_id
INNER JOIN page AS subpage ON subpage.page_id = cl.cl_to
INNER JOIN langlinks AS ll ON ll.ll_from = subpage.page_id AND ll.ll_lang = 'ku'
WHERE 
    page.page_namespace IN (0,10)
    AND (
        cl.cl_to = 'States_and_territories_by_millennium_of_establishment'
        OR cl.cl_to IN (
            SELECT DISTINCT
                cl_from
            FROM
                categorylinks
            WHERE
                cl_to = 'States_and_territories_by_millennium_of_establishment'
        )
    )
GROUP BY
    ku_page_title
ORDER BY
    ku_page_title;
SQL

Checking query status...
