Test 3 - Quarry

SQL

-- USE the appropriate database
USE wikidatawiki_p;

-- Find categories that are available in most languages but not in ckbwiki, and count the number of languages
SELECT
  enwiki.ll_title AS category_title,
  COUNT(DISTINCT other_languages.ll_lang) AS language_count
FROM
  (
    SELECT
      ll_title
    FROM
      langlinks
    WHERE
      -- Filter by namespace (Category)
      ll_title LIKE 'Category:%'
  ) AS other_languages
  LEFT JOIN langlinks AS enwiki ON enwiki.ll_title = other_languages.ll_title AND enwiki.ll_lang = 'en'
WHERE
  enwiki.ll_title IS NOT NULL
  AND 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 language_count > 5 -- Adjust the threshold for the minimum number of languages as needed
LIMIT 100;
SQL

Checking query status...
