Test 3 - Quarry

SQL

USE enwiki_p;

-- Subquery to identify categories that are members of "Category:Hidden categories"
WITH hidden_categories AS (
    SELECT cl_from
    FROM categorylinks
    WHERE cl_to = 'Hidden_categories'
)

-- Main query to retrieve the top 100 categories
SELECT
    ll_title AS category_title
FROM langlinks
WHERE
    -- Exclude categories from "ckbwiki"
    ll_lang != 'ckb' AND
    -- Exclude categories that are members of "Category:Hidden categories"
    ll_from NOT IN (SELECT cl_from FROM hidden_categories)
GROUP BY category_title
ORDER BY COUNT(*) DESC
LIMIT 100;
SQL

Checking query status...
