Test 3 - Quarry

SQL

-- Specify the database to use
USE enwiki_p;

-- Retrieve the top 100 categories available in most languages/wikipedias but not in ckbwiki
SELECT
  DISTINCT ll_title AS category_title
FROM
  langlinks
WHERE
  ll_from IN (SELECT page_id FROM page WHERE page_namespace = 14) -- Filter for category pages
  AND ll_lang = 'en' -- Include only English category titles
  AND ll_title NOT IN (SELECT ll_title FROM langlinks WHERE ll_lang = 'ckb') -- Exclude categories in ckbwiki
GROUP BY
  ll_title
HAVING
  COUNT(DISTINCT ll_lang) > 1 -- Categories available in more than one language
LIMIT 100;
SQL

Checking query status...
