Test 3 - Quarry

SQL

SELECT DISTINCT
  en_cats.page_title AS en_category,
  COUNT(*) AS num_languages
FROM
  categorylinks AS en_cats
  -- Join with langlinks to get the corresponding category in other languages
  JOIN langlinks AS ll
    ON en_cats.cl_from = ll.ll_from
    AND ll.ll_lang != 'ckb' -- Exclude ckbwiki
WHERE
  en_cats.cl_to = 'Hidden_categories' -- Exclude "Category:Hidden_categories" on enwiki
  AND en_cats.page_namespace = 14 -- Check only the Category namespace
GROUP BY
  en_cats.page_title
HAVING
  COUNT(*) > 1 -- Categories available in more than one language
ORDER BY
  num_languages DESC
LIMIT 100;
SQL

Checking query status...
