Test 3 - Quarry

SQL

USE wikidata_p; -- Use the Wikidata database

-- Query to fetch categories available in most Wikipedias but not in ckbwiki
SELECT DISTINCT
  item_id AS WikidataItem,
  term_full_entity_id AS CategoryEntityId
FROM wb_items_per_site
WHERE
  site = 'enwiki' AND
  term_entity_type = 'mediacounts-category' AND
  NOT EXISTS (
    SELECT 1
    FROM wb_items_per_site AS ckbwiki
    WHERE
      ckbwiki.site = 'ckbwiki' AND
      ckbwiki.term_entity_type = 'mediacounts-category' AND
      ckbwiki.item_id = wb_items_per_site.item_id
  )
LIMIT 100;
SQL

Checking query status...
