Untitled query #42965

SQL

SET @category := 'Domeny_internetowe';
WITH RECURSIVE subcategories(sbc_title, sbc_depth) AS (
  SELECT @category, 0 FROM DUAL
  UNION ALL
  SELECT page_title, sbc_depth+1 FROM subcategories
  JOIN categorylinks ON cl_to = sbc_title
  JOIN page ON cl_from = page_id
  WHERE cl_type = "subcat"
  AND sbc_depth <= 3
)

         SELECT p.page_title
         FROM page p
         LEFT JOIN pagelinks l ON (l.pl_namespace = 0 AND pl_from_namespace = 0 AND l.pl_title = p.page_title)
         LEFT JOIN page_props prop ON (prop.pp_propname = 'disambiguation' AND prop.pp_page = p.page_id)
		 LEFT JOIN categorylinks ON (cl_from = p.page_id)
         LEFT JOIN subcategories s ON (s.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 s.sbc_depth IS NOT NULL
         GROUP BY p.page_title        
         ORDER BY p.page_title ASC
         limit 30
SQL

Checking query status...
