Test 3 - Quarry

SQL

USE enwiki_p;

WITH TopCategories AS (
  SELECT
    COUNT(*) AS category_count,
    ll_title AS category_title
  FROM
    langlinks
  WHERE
    ll_from IN (SELECT page_id FROM categorylinks WHERE cl_to = 'Hidden_categories')
  GROUP BY
    ll_title
  HAVING
    category_count > 2
  ORDER BY
    category_count DESC
  LIMIT 100
)

SELECT
  TOP 100
  category_title
FROM
  TopCategories
LEFT JOIN
  langlinks ON TopCategories.category_title = langlinks.ll_title
WHERE
  ll_lang = 'en'
  AND ll_from NOT IN (SELECT page_id FROM categorylinks WHERE cl_to = 'Hidden_categories')
  AND ll_title NOT IN ('Category:Hidden categories');
SQL

Checking query status...
