Test 3 - Quarry

SQL

-- Find the top 100 categories available in most languages, excluding "ckbwiki," and not members of "Category:Hidden_categories" on "enwiki"

SELECT DISTINCT
  cl_to AS category_title
FROM categorylinks AS c1
JOIN langlinks AS ll ON c1.cl_to = ll.ll_title
LEFT JOIN categorylinks AS c2 ON c1.cl_to = c2.cl_to AND c2.cl_to = 'Hidden_categories'
WHERE
  c1.cl_type = 'page'
  AND c1.cl_to NOT IN (
    SELECT DISTINCT
      cl_to
    FROM categorylinks
    WHERE cl_type = 'page'
  )
  AND c1.cl_to NOT IN (
    SELECT DISTINCT
      ll_title
    FROM langlinks
    WHERE ll_lang = 'ckbwiki'
  )
  AND c2.cl_to IS NULL
LIMIT 100;
SQL

Checking query status...
