Untitled query #78437

SQL

SET @basecat = 'Stereo cards';
SET max_recursive_iterations = 3; -- current maximum depth for this tree; 2504 categories, 8883596 pages

SET @basecat = REPLACE(@basecat, ' ', '_');
WITH RECURSIVE deepcat (subcat) AS
(
  SELECT @basecat

  UNION DISTINCT

  SELECT page_title
  FROM categorylinks
  JOIN page ON page_id = cl_from AND page_namespace = 14
  JOIN deepcat ON cl_to = subcat
)
SELECT DISTINCT page_title
FROM page
JOIN categorylinks ON cl_from = page_id
JOIN deepcat ON cl_to = subcat
LEFT JOIN ns ON ns_n = page_namespace
SQL

Checking query status...
