Test 3 - Quarry

SQL

-- Use ckbwiki_p, enwiki_p, or wikidatawiki_p
USE enwiki_p;

-- Find the top 100 categories available in most languages but not in ckbwiki
SELECT ll_title AS category_title, COUNT(ll_from) AS language_count
FROM langlinks
WHERE ll_from IN (SELECT DISTINCT cl_from FROM categorylinks WHERE cl_to = 'Wikipedia_categories')
  AND ll_from NOT IN (SELECT DISTINCT cl_from FROM categorylinks WHERE cl_to = 'Wikipedia_categories' AND cl_to = 'ckbwiki')
GROUP BY ll_title
ORDER BY language_count DESC
LIMIT 100;
SQL

Checking query status...
