Test 3 - Quarry

SQL

USE enwiki_p;

-- Find the categories available on most languages but not in ckbwiki
SELECT
    ll_title AS Category,
    COUNT(DISTINCT ll_lang) AS LanguageCount
FROM
    langlinks
WHERE
    ll_from IN (SELECT page_id FROM page WHERE page_namespace = 14)  -- Limit to category pages
GROUP BY
    ll_title
HAVING
    LanguageCount > 1  -- Categories available in more than one language
    AND NOT EXISTS (
        SELECT 1
        FROM
            langlinks AS ckb
        WHERE
            ckb.ll_from = langlinks.ll_from
            AND ckb.ll_lang = 'ckb'  -- Exclude categories available in ckbwiki
    )
ORDER BY
    LanguageCount DESC
LIMIT 100;
SQL

Checking query status...
