Test 3 - Quarry

SQL

USE wikidata; -- Use the Wikidata database

-- Query to fetch categories linked to most Wikipedias but not ckbwiki
SELECT DISTINCT cl_to AS CategoryName
FROM categorylinks
WHERE
  EXISTS (
    SELECT 1
    FROM page
    WHERE
      page_namespace = 14
      AND page_title = cl_to
      AND page_id IN (
        SELECT page_id
        FROM page
        WHERE page_namespace = 0
      )
  )
  AND NOT EXISTS (
    SELECT 1
    FROM categorylinks AS ckb
    WHERE
      ckb.cl_to = cl_to
      AND ckb.cl_from IN (
        SELECT page_id
        FROM page
        WHERE page_namespace = 14
          AND page_title = 'ckbwiki'
      )
  )
LIMIT 100;
SQL

Checking query status...
