Test 3 - Quarry

SQL

USE wikidatawiki_p;

WITH CategoryCounts AS (
  SELECT
    ll_title AS category_title,
    COUNT(DISTINCT ll_lang) AS language_count
  FROM langlinks
  WHERE
    ll_namespace = 14  -- Filter for namespace 14 (Category namespace)
  GROUP BY ll_title
),
CategoryExclusion AS (
  SELECT
    'Hidden_categories' AS category_title
)
SELECT
  cc.category_title AS category
FROM CategoryCounts cc
LEFT JOIN CategoryExclusion ce ON cc.category_title = ce.category_title
WHERE
  ce.category_title IS NULL
ORDER BY cc.language_count DESC
LIMIT 100;
SQL

Checking query status...
