Test 3 - Quarry

SQL

-- USE the appropriate database
USE wikidatawiki_p;

-- Find categories that are available in most languages but not in ckbwiki
SELECT
  cl_to AS category_title
FROM
  categorylinks AS c
WHERE
  -- Filter by namespace (Category)
  c.cl_to LIKE 'Category:%' AND
  -- Exclude categories in ckbwiki
  NOT EXISTS (
    SELECT 1
    FROM categorylinks AS c2
    WHERE c2.cl_to = c.cl_to AND c2.cl_from = (SELECT page_id FROM page WHERE page_title = 'ckbwiki' AND page_namespace = 14)
  )
GROUP BY c.cl_to
HAVING COUNT(DISTINCT c.cl_lang) > 5 -- Adjust the threshold for the minimum number of languages as needed
LIMIT 100;
SQL

Checking query status...
