Test 3 - Quarry

SQL

USE ckbwiki_p;

SELECT
  DISTINCT en.ll_title AS category_title
FROM
  (
    SELECT
      ll_title
    FROM
      langlinks
    WHERE
      ll_lang IN ('en', 'wikidata')  -- Filter for English Wikipedia and Wikidata
  ) en

LEFT JOIN
  (
    SELECT
      ll_title
    FROM
      langlinks
    WHERE
      ll_lang = 'ckb'  -- Filter for ckbwiki
  ) ckb
ON
  en.ll_title = ckb.ll_title

LEFT JOIN
  (
    SELECT
      cl_to
    FROM
      categorylinks
    WHERE
      cl_to = 'Hidden_categories' AND cl_type = 'page'
  ) hidden
ON
  en.ll_title = hidden.cl_to

WHERE
  ckb.ll_title IS NULL  -- Categories not available in ckbwiki
  AND hidden.cl_to IS NULL  -- Categories not in "Category:Hidden categories"

LIMIT 100;
SQL

Checking query status...
