Test 3 - Quarry

SQL

SELECT en_cats.cl_to AS category_title, COUNT(ll.ll_lang) AS language_links_count
FROM categorylinks en_cats
JOIN page en_p ON en_cats.cl_from = en_p.page_id
LEFT JOIN langlinks ll ON en_p.page_id = ll.ll_from AND ll.ll_lang = 'ckbwiki'
WHERE
  NOT EXISTS (
    SELECT 1
    FROM categorylinks hidden_cats
    WHERE hidden_cats.cl_to = 'Hidden_categories' AND hidden_cats.cl_from = en_cats.cl_from
  )
  AND en_p.page_namespace = 14 -- Filter for category namespace
GROUP BY category_title
HAVING language_links_count > 0
ORDER BY language_links_count DESC
LIMIT 100;
SQL

Checking query status...
