Test 3 - Quarry

This query is marked as a draft This query has been published by Aram.

SQL

SELECT DISTINCT
  c1.cl_to AS category_title
FROM categorylinks AS c1
JOIN langlinks AS ll ON c1.cl_to = ll.ll_title
LEFT JOIN categorylinks AS c2 ON c1.cl_to = c2.cl_to AND c2.cl_to = 'Hidden_categories'
WHERE
  c1.cl_type = 'page'
  AND c1.cl_to NOT IN (
    SELECT DISTINCT
      cl_to
    FROM categorylinks
    WHERE cl_type = 'page'
  )
  AND c1.cl_to NOT IN (
    SELECT DISTINCT
      ll_title
    FROM langlinks
    WHERE ll_lang = 'ckb'
  )
  AND c2.cl_to IS NULL
LIMIT 100;

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...