Test 3 - Quarry

SQL

USE enwiki_p; -- Specify the database name

SELECT en_cl.cl_to AS Category, COUNT(DISTINCT ll.ll_lang) AS LanguageCount
FROM categorylinks en_cl
JOIN page en_p ON en_cl.cl_from = en_p.page_id
LEFT JOIN (
  SELECT ll_from, COUNT(*) AS ckb_count
  FROM langlinks
  WHERE ll_lang = 'ckb'
  GROUP BY ll_from
) ckb_counts ON en_p.page_id = ckb_counts.ll_from
LEFT JOIN langlinks ll ON en_p.page_id = ll.ll_from
WHERE en_p.page_namespace = 14 -- Limit to category namespace
  AND en_cl.cl_to NOT LIKE 'Hidden_categories'
  AND en_cl.cl_to NOT LIKE '%%_stub' -- Exclude stub categories
  AND (ckb_counts.ckb_count IS NULL OR ckb_counts.ckb_count = 0)
GROUP BY en_cl.cl_to
ORDER BY LanguageCount DESC
LIMIT 100;
SQL

Checking query status...
