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
  (
    SELECT
      ll_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
  ) AS other_languages
  LEFT JOIN (
    SELECT
      ll_title
    FROM
      langlinks
    WHERE
      ll_lang = 'en' -- English Wikipedia
  ) AS enwiki ON enwiki.ll_title = other_languages.ll_title
WHERE
  enwiki.ll_title IS NULL
LIMIT 100;
SQL

Checking query status...
