Test 3 - Quarry

SQL

USE enwiki_p;

SELECT en_p.page_title AS Category, COUNT(DISTINCT ll.ll_lang) AS LanguageLinks
FROM page AS en_p
LEFT JOIN categorylinks AS en_cl ON en_p.page_id = en_cl.cl_from
LEFT JOIN langlinks AS ll ON en_p.page_id = ll.ll_from
WHERE
  en_cl.cl_to != 'Hidden_categories' -- Exclude 'Category:Hidden_categories' on enwiki
  AND en_cl.cl_to IS NULL -- Ensure the page is not in the Hidden_categories category
  AND ll.ll_lang != 'ckb' -- Exclude ckbwiki
  AND en_p.page_namespace = 14 -- Limit to category namespace
GROUP BY en_p.page_title
HAVING LanguageLinks = 0
ORDER BY LanguageLinks DESC
LIMIT 100;
SQL

Checking query status...
