Test 3 - Quarry

SQL

SELECT DISTINCT cl_to AS category,
       COUNT(DISTINCT langlinks.ll_lang) AS lang_link_count
FROM categorylinks
JOIN page ON cl_from = page_id
LEFT JOIN langlinks ON page_id = ll_from AND ll_lang = 'en'
WHERE page_namespace = 14
  AND ll_from IS NULL
  AND NOT EXISTS (
    SELECT 1
    FROM categorylinks AS hidden
    WHERE hidden.cl_from = page_id
      AND hidden.cl_to = 'Hidden_categories'
  )
  AND NOT EXISTS (
    SELECT 1
    FROM langlinks AS ckb
    WHERE ckb.ll_from = page_id
      AND ckb.ll_lang = 'ckb'
  )
GROUP BY cl_to
ORDER BY lang_link_count DESC, category
LIMIT 100;
SQL

Checking query status...
