Test 3 - Quarry

SQL

USE ckbwiki_p;

WITH CategoryCounts AS (
  SELECT
    ll_title AS category_title,
    COUNT(ll_lang) AS language_count
  FROM
    langlinks
  WHERE
    ll_title LIKE 'Category:%' -- Select only category pages
  GROUP BY
    ll_title
  HAVING
    language_count > 1 -- Categories available in more than one language
)

SELECT
  cc.category_title
FROM
  CategoryCounts AS cc
LEFT JOIN
  (SELECT
    ll_title AS category_title
  FROM
    langlinks
  WHERE
    ll_lang = 'ckb' -- Central Kurdish Wikipedia
  GROUP BY
    ll_title) AS ckb_categories
ON
  cc.category_title = ckb_categories.category_title
WHERE
  ckb_categories.category_title IS NULL
ORDER BY
  cc.language_count DESC
LIMIT 100;
SQL

Checking query status...
