Test 3 - Quarry

SQL

USE enwiki_p;

WITH CategoryCounts AS (
  SELECT
    cl_to AS category_title,
    COUNT(DISTINCT cl_lang) AS lang_count
  FROM categorylinks
  WHERE cl_to NOT IN (
    SELECT page_title
    FROM page
    WHERE page_namespace = 14
      AND page_title = 'Hidden_categories'
  )
  GROUP BY cl_to
  HAVING lang_count >= (SELECT COUNT(DISTINCT ll_lang) FROM langlinks WHERE ll_from_namespace = 14)
  AND cl_to NOT IN (
    SELECT ll_title
    FROM langlinks
    WHERE ll_lang = 'ckb'
  )
)
SELECT
  category_title
FROM CategoryCounts
ORDER BY lang_count DESC
LIMIT 100;
SQL

Checking query status...
