Test 3 - Quarry

SQL

-- USE ckbwiki_p, enwiki_p, or wikidatawiki_p

SELECT DISTINCT en.ll_title AS category_title, COUNT(DISTINCT en2.ll_lang) AS language_count
FROM langlinks AS en
JOIN categorylinks AS cl ON en.ll_from = cl.cl_from
LEFT JOIN langlinks AS en2 ON cl.cl_to = en2.ll_title
WHERE
  en.ll_lang = 'en' AND -- English Wikipedia
  NOT EXISTS (
    SELECT 1
    FROM langlinks AS ckb
    WHERE
      ckb.ll_title = en.ll_title AND
      ckb.ll_lang = 'ckb' -- Kurdish Wikipedia
  )
GROUP BY en.ll_title
ORDER BY language_count DESC, category_title
LIMIT 100;
SQL

Checking query status...
