Test 3 - Quarry

SQL

-- USE the appropriate database
USE wikidatawiki_p;

-- Find categories that are available in most languages but not in ckbwiki
SELECT
  enwiki.ll_title AS category_title
FROM langlinks AS enwiki
WHERE
  -- Include only English titles in the Category namespace
  enwiki.ll_lang = 'en' AND
  enwiki.ll_title LIKE 'Category:%' AND
  -- Filter out categories in ckbwiki
  enwiki.ll_title NOT IN (
    SELECT
      ll_title
    FROM langlinks
    WHERE ll_lang = 'ckb' AND ll_title LIKE 'Category:%'
  )
GROUP BY enwiki.ll_title
HAVING COUNT(*) > 5 -- Adjust the threshold for the minimum number of languages as needed
LIMIT 100;
SQL

Checking query status...
