Untitled query #42965

SQL

WITH RECURSIVE subcategories(sbc_title, sbc_depth, sbc_id) AS (
  SELECT 'Informatyka', 0, 0 FROM DUAL
  UNION ALL
  SELECT page_title, sbc_depth+1, page_id FROM subcategories
  JOIN categorylinks ON cl_to = sbc_title
  JOIN page ON cl_from = page_id
  WHERE cl_type = "page"
  AND sbc_depth <= 3
)

         SELECT p.page_title
         FROM page p
         LEFT JOIN pagelinks l ON (l.pl_namespace = 0 AND l.pl_title = p.page_title)
         LEFT JOIN page_props prop ON (prop.pp_propname AND prop.pp_page = p.page_id)

         WHERE
                 p.page_namespace = 0
                 AND page_is_redirect = 0
                 AND l.pl_namespace IS NULL
                 AND prop.prop_value IS NULL
                 AND p.page_id = subcategories.sbc_id
         ORDER BY p.page_title ASC
LIMIT 10
SQL

Checking query status...
