Test 3 - Quarry

SQL

USE ckbwiki_p;

WITH CategoryCounts AS (
  SELECT
    ll_title AS category_title,
    COUNT(DISTINCT ll_lang) AS lang_count
  FROM
    langlinks
  WHERE
    ll_title NOT IN (
      SELECT
        page_title
      FROM
        page
      WHERE
        page_namespace = 14 -- Category namespace
        AND page_title = 'Hidden_categories'
    )
  GROUP BY
    ll_title
  HAVING
    lang_count >= 100 -- Adjust this number as needed
)

SELECT
  c.category_title
FROM
  CategoryCounts AS c
LEFT JOIN
  langlinks AS l
ON
  c.category_title = l.ll_title
  AND l.ll_lang = 'ckb' -- Change 'ckb' to the language code of ckbwiki
WHERE
  l.ll_title IS NULL
LIMIT 100; -- You can adjust the limit as needed
SQL

Checking query status...
