Test 3 - Quarry

SQL

-- USE the appropriate database (enwiki_p, ckbwiki_p, etc.)
USE enwiki_p;

-- Fetch the top 100 categories available in most languages but not in ckbwiki
SELECT
  page.page_title AS category_title
FROM
  categorylinks
  JOIN page ON categorylinks.cl_from = page.page_id
WHERE
  NOT EXISTS (
    SELECT 1
    FROM
      langlinks
    WHERE
      langlinks.ll_from = categorylinks.cl_from
      AND langlinks.ll_lang = 'ckb' -- Change 'ckb' to the language code of ckbwiki
  )
GROUP BY
  page.page_title
HAVING
  COUNT(DISTINCT categorylinks.cl_to) >= 10 -- Adjust the threshold as needed
LIMIT 100;
SQL

Checking query status...
