Test 3 - Quarry

SQL

-- Get the top 100 categories available in most languages except ckbwiki and not in Category:Hidden_categories
SELECT
  page.page_title AS Category,
  COUNT(DISTINCT ll_lang) AS LanguageCount
FROM
  langlinks
  JOIN page ON page.page_id = langlinks.ll_from
  LEFT JOIN categorylinks ON categorylinks.cl_from = page.page_id
  LEFT JOIN category AS hidden_categories ON hidden_categories.cat_title = 'Hidden_categories'
WHERE
  page.page_namespace = 14 -- Category namespace
  AND page.page_title NOT LIKE 'Hidden_categories/%'
  AND page.page_title NOT LIKE 'Category:Hidden_categories/%'
  AND page.page_title NOT IN (SELECT ll_title FROM langlinks WHERE ll_lang = 'ckbwiki')
  AND hidden_categories.cat_title IS NULL
GROUP BY
  page.page_title
HAVING
  COUNT(DISTINCT ll_lang) > 1
ORDER BY
  LanguageCount DESC
LIMIT 100;
SQL

Checking query status...
