Test 3 - Quarry

SQL

USE wikidatawiki_p;

SELECT
    enwiki.ll_title AS category_title
FROM
    (SELECT
        ll_title,
        COUNT(DISTINCT ll_lang) AS language_count
    FROM
        langlinks
    WHERE
        ll_title NOT IN (
            SELECT
                page_title
            FROM
                page
            WHERE
                page_namespace = 14
            AND
                page_title = "Hidden_categories"
        )
    GROUP BY
        ll_title
    HAVING
        language_count > 1
    ) AS multi_language_categories
LEFT JOIN
    langlinks AS enwiki
ON
    multi_language_categories.ll_title = enwiki.ll_title
AND
    enwiki.ll_lang = "en"
LEFT JOIN
    langlinks AS ckbwiki
ON
    multi_language_categories.ll_title = ckbwiki.ll_title
AND
    ckbwiki.ll_lang = "ckb"
WHERE
    ckbwiki.ll_title IS NULL
LIMIT 100;
SQL

Checking query status...
