Test 3 - Quarry

SQL

-- USE the appropriate database
USE wikidatawiki_p;

-- Find categories that are available in most languages but not in ckbwiki
SELECT
  ll_title AS category_title
FROM
  langlinks
WHERE
  -- Exclude categories from ckbwiki
  ll_lang != 'ckb' AND
  -- Filter by namespace (Category)
  ll_title LIKE 'Category:%' AND
  -- Subquery to count languages where the category is available
  (SELECT COUNT(DISTINCT ll_lang)
   FROM langlinks AS sublanglinks
   WHERE sublanglinks.ll_title = langlinks.ll_title
   ) > 5 -- Adjust the threshold for the minimum number of languages as needed
LIMIT 100;
SQL

Checking query status...
