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(DISTINCT ll_lang) AS LanguageCount
FROM categorylinks
LEFT JOIN langlinks ON cl_to = ll_title
WHERE
  cl_to IS NOT NULL  -- Filter out categories with no interlanguage links
  AND ll_lang IS NOT NULL  -- Filter out interlanguage links with no language information
  AND ll_lang != 'ckb'  -- Exclude ckbwiki
GROUP BY cl_to
HAVING LanguageCount > 1  -- Adjust the minimum language count as needed
ORDER BY LanguageCount DESC
LIMIT 100;
SQL

Checking query status...
