Test 3 - Quarry

SQL

-- Specify the database to use (replace 'enwiki_p' with the appropriate database)
USE enwiki_p;

-- Fetch the top 100 categories that are available on most languages/wikipedias, not available in ckbwiki, and not in "Category:Hidden categories"
WITH CategoryCounts AS (
  SELECT
    cl_to AS Category,
    COUNT(DISTINCT ll_from) AS LangCount
  FROM categorylinks
  LEFT JOIN langlinks ON ll_from = cl_from
  WHERE cl_to NOT LIKE 'Hidden%'
    AND ll_from IS NULL
    AND cl_to NOT IN (SELECT page_title FROM page WHERE page_namespace = 14)
  GROUP BY cl_to
)

SELECT
  Category
FROM CategoryCounts
ORDER BY LangCount DESC
LIMIT 100;
SQL

Checking query status...
