Test 3 - Quarry

SQL

-- USE ckbwiki_p, enwiki_p, or wikidatawiki_p

SELECT en.ll_title AS category_title, COUNT(DISTINCT en2.ll_lang) AS language_count
FROM langlinks AS en
JOIN page AS p ON en.ll_from = p.page_id
LEFT JOIN langlinks AS en2 ON p.page_id = en2.ll_from
WHERE
  p.page_namespace = 14 AND -- Filter only categories
  en.ll_lang = 'en' AND -- English Wikipedia
  NOT EXISTS (
    SELECT 1
    FROM langlinks AS ckb
    WHERE
      ckb.ll_from = p.page_id AND
      ckb.ll_lang = 'ckb' -- Kurdish Wikipedia
  )
  AND p.page_title NOT LIKE 'Category:%' -- Exclude categories with "Category:" in the title
GROUP BY en.ll_title
ORDER BY language_count DESC, p.page_id
LIMIT 100;
SQL

Checking query status...
