Test 3 - Quarry

SQL

USE wikidatawiki_p;

WITH category_counts AS (
  SELECT
    ll_title AS category_title,
    COUNT(DISTINCT ll_lang) AS language_count
  FROM
    langlinks
  WHERE
    ll_title NOT IN (
      SELECT
        page_title
      FROM
        enwiki.page
      WHERE
        page_namespace = 14 -- Namespace for categories
    )
    AND ll_from IN (
      SELECT
        DISTINCT l1.ll_from
      FROM
        langlinks l1
        LEFT JOIN langlinks l2 ON l1.ll_from = l2.ll_from
          AND l2.ll_lang = 'ckb' -- Exclude ckbwiki
      WHERE
        l2.ll_from IS NULL
    )
  GROUP BY
    ll_title
)

SELECT
  category_title
FROM
  category_counts
ORDER BY
  language_count DESC
LIMIT 100;
SQL

Checking query status...
