Test 3 - Quarry

SQL

-- Get 100 categories that exist in most Wikipedias (including English) but not in ckbwiki
SELECT DISTINCT
  category
FROM categorylinks
WHERE cl_to NOT IN (
  -- Subquery to find categories in ckbwiki
  SELECT DISTINCT cl_to
  FROM categorylinks
  WHERE cl_from_namespace = 0
    AND cl_from = page_id
    AND cl_to NOT LIKE 'All articles%'
  )
  AND cl_to NOT LIKE 'All articles%'
  AND cl_to NOT LIKE 'All stubs%'
  AND cl_to NOT LIKE 'Main topic%'
  AND cl_to NOT LIKE 'Wikipedia%'
  AND cl_to NOT LIKE 'Wikipedians%'
  AND cl_to NOT LIKE 'Articles%'
LIMIT 100;
SQL

Checking query status...
