Test 3 - Quarry

SQL

USE wikidatawiki;

-- Query to fetch categories linked to most Wikipedias but not ckbwiki
SELECT DISTINCT cl_to AS CategoryName
FROM categorylinks
WHERE
  cl_to IN (
    SELECT CONCAT('Category:', ips_site_page)
    FROM wb_items_per_site
    WHERE ips_site_id = 'enwiki' -- Replace 'enwiki' with the site ID for the English Wikipedia
  )
  AND cl_to NOT IN (
    SELECT CONCAT('Category:', ips_site_page)
    FROM wb_items_per_site
    WHERE ips_site_id = 'ckbwiki' -- Replace 'ckbwiki' with the site ID for ckbwiki
  )
LIMIT 100;
SQL

Checking query status...
