Test 3 - Quarry

SQL

SELECT en_cl.cl_to AS Category,
       COUNT(DISTINCT ll.ll_lang) AS LanguageLinksCount
FROM categorylinks en_cl
JOIN page en_p ON en_cl.cl_from = en_p.page_id
LEFT JOIN langlinks ll ON en_p.page_id = ll.ll_from
LEFT JOIN page hidden_en_p ON hidden_en_p.page_title = 'Hidden_categories'
LEFT JOIN categorylinks hidden_en_cl ON hidden_en_p.page_id = hidden_en_cl.cl_from AND hidden_en_cl.cl_to = 'Hidden_categories'
WHERE
  ll.ll_lang IS NULL OR ll.ll_lang != 'ckbwiki' -- Exclude ckbwiki
  AND hidden_en_cl.cl_to IS NULL -- Exclude 'Category:Hidden_categories' on enwiki
  AND en_cl.cl_to LIKE 'Category:%' -- Only include category pages
GROUP BY en_cl.cl_to
ORDER BY LanguageLinksCount DESC
LIMIT 100;
SQL

Checking query status...
