Test 3 - Quarry

SQL

SELECT DISTINCT cl_to AS category
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 -- 14 is the namespace for categories
  AND ll_from IS NULL -- Exclude categories with no interlanguage links in English
  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'
  )
ORDER BY page_title
LIMIT 100;
SQL

Checking query status...
