Test 3 - Quarry

SQL

USE wikidatawiki_p;

-- Query to fetch categories linked to most Wikipedias but not ckbwiki, prioritizing by the number of languages
SELECT DISTINCT
  cl_to AS CategoryName,
  COUNT(wbt_id) AS LanguageCount
FROM categorylinks
LEFT JOIN wb_items_per_site ON CONCAT('Category:', ips_site_page) = cl_to
LEFT JOIN wb_terms ON ips_item_id = wbt_item_id AND wbt_entity_id = ips_item_id
WHERE
  cl_to NOT IN (
    SELECT CONCAT('Category:', ips_site_page)
    FROM wb_items_per_site
    WHERE ips_site_id = 'ckbwiki'
  )
  AND wbt_term_in_lang IS NOT NULL
GROUP BY cl_to
HAVING LanguageCount > 1  -- Adjust the minimum language count as needed
ORDER BY LanguageCount DESC
LIMIT 100;
SQL

Checking query status...
