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

​

​

​