Test 3 - Quarry

SQL

USE wikidatawiki_p;

WITH CategoryLanguageCounts AS (
  SELECT
    cl_to AS category,
    COUNT(DISTINCT ll_lang) AS language_count
  FROM
    categorylinks
  LEFT JOIN
    langlinks ON ll_title = cl_to
  GROUP BY
    cl_to
  HAVING
    language_count > 1
  ORDER BY
    language_count DESC
  LIMIT 100
)

-- Now, we need to exclude the categories available in "ckbwiki" (Kurdish Wikipedia).

SELECT
  cl.category AS category_name,
  cl.language_count
FROM
  CategoryLanguageCounts AS cl
LEFT JOIN
  langlinks AS ll ON ll_title = cl.category AND ll_lang = 'ckbwiki'
WHERE
  ll.ll_title IS NULL
LIMIT 100;
SQL

Checking query status...
