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 = "subcat"
  AND sbc_depth <= 5
)

         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)
		 LEFT JOIN categorylinks ON (cl_from = page_id)
		 LEFT JOIN subcategories ON (sbc_title = cl_to)
         WHERE
                 p.page_namespace = 0
                 AND page_is_redirect = 0
                 AND l.pl_namespace IS NULL
                 AND prop.pp_value IS NULL
                 AND subcategories.sbc_id IS NOT NULL
         ORDER BY p.page_title ASC limit 10
SQL

Checking query status...
