Test 3 - Quarry

SQL

SELECT DISTINCT en_cats.page_title
FROM (
  SELECT en_p.page_title
  FROM categorylinks en_cl
  JOIN page en_p ON en_cl.cl_from = en_p.page_id
  LEFT JOIN categorylinks hidden_cl ON en_p.page_id = hidden_cl.cl_from
  LEFT JOIN langlinks ll ON en_p.page_id = ll.ll_from
  WHERE
    ll.ll_lang IS NULL OR ll.ll_lang != 'ckbwiki'
    AND hidden_cl.cl_to = 'Hidden_categories'
    AND en_cl.cl_to NOT LIKE 'Hidden%'
    AND en_cl.cl_to NOT LIKE 'All_articles%'
    AND en_cl.cl_to NOT LIKE 'CS1%'
    AND en_cl.cl_to NOT LIKE 'Use%'
  GROUP BY en_p.page_title
  HAVING COUNT(DISTINCT ll.ll_lang) >= 2
  LIMIT 100
) en_cats;
SQL

Checking query status...
