Test 3 - Quarry

SQL

USE enwiki_p; -- Set the English Wikipedia database

SELECT
  en_p.page_title AS CategoryTitle,
  COUNT(DISTINCT CASE WHEN ll.ll_lang LIKE '%wiki' THEN ll.ll_lang ELSE NULL END) AS LanguageLinkCount
FROM page AS en_p
JOIN categorylinks AS en_cl ON en_p.page_id = en_cl.cl_from
LEFT JOIN langlinks AS ll ON en_p.page_id = ll.ll_from
WHERE
  en_cl.cl_to NOT LIKE 'Hidden_categories'
  AND en_p.page_namespace = 14 -- Namespace for categories
  AND (ll.ll_lang IS NULL OR ll.ll_lang != 'ckbwiki')
GROUP BY en_p.page_title
ORDER BY LanguageLinkCount DESC
LIMIT 100;
SQL

Checking query status...
