Test 3 - Quarry

SQL

-- Top 100 categories available in most languages except ckbwiki
SELECT
    ll_title,
    COUNT(DISTINCT ll_lang) AS lang_count
FROM
    langlinks
WHERE
    ll_from IN (
        SELECT
            cl_from
        FROM
            categorylinks
        WHERE
            cl_to = "Hidden_categories"  -- Excluding hidden categories
    )
    AND ll_from NOT IN (
        SELECT
            page_id
        FROM
            page
        WHERE
            page_title = "Category:Hidden_categories"
    )
    AND ll_lang != "ckb"  -- Excluding ckbwiki
GROUP BY
    ll_title
HAVING
    lang_count > 1  -- Available in more than one language
ORDER BY
    lang_count DESC
LIMIT 100;
SQL

Checking query status...
