Test 3 - Quarry

SQL

-- Select the top 100 categories available in most languages except ckbwiki
SELECT
  DISTINCT cl_to
FROM
  categorylinks
WHERE
  cl_from IN (SELECT ll_from FROM langlinks WHERE ll_lang = 'en') -- English pages
  AND cl_to NOT IN (
    SELECT
      DISTINCT cl_to
    FROM
      categorylinks
    WHERE
      cl_from IN (SELECT ll_from FROM langlinks WHERE ll_lang = 'ckb') -- Exclude ckbwiki
  )
  AND cl_to NOT IN (
    SELECT
      DISTINCT page_title
    FROM
      page
    WHERE
      page_title = 'Hidden_categories' AND page_namespace = 14 -- Exclude "Category:Hidden_categories"
  )
ORDER BY
  cl_to
LIMIT 100;
SQL

Checking query status...
