Untitled query #42965

SQL

SET @category := 'Internet';
WITH RECURSIVE subcategories(sbc_title, sbc_depth, sbc_id) AS (
  SELECT @category, 0, 0
  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 <= 3
)

         SELECT p.page_title, categorylinks.cl_to
         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 = '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_id IS NOT NULL
                 
         ORDER BY p.page_title ASC limit 10
SQL

Checking query status...
