Whole route from [[Category:Auto racing]] to [[Category:Formula One]]

Fork of Route from [[Category:Auto racing]] to [[Category:Formula One]] by Cryptic

This query is marked as a draft This query has been published by Cryptic.

Depth and route to [[Category:Formula One]] in the [[Category:Auto racing]] tree.

For [[WP:VPT#Petscan depth]] circa 23 October 2022.

SQL

SET @basecat = 'Auto_racing';
SET max_recursive_iterations = 7;

WITH RECURSIVE deepcat (subcat, route, depth) AS
(
  SELECT @basecat,
         @basecat,
         0

  UNION

  SELECT page_title,
         CONCAT(route, ' > ', page_title),
         depth + 1
  FROM categorylinks
  JOIN page ON page_id = cl_from AND page_namespace = 14
  JOIN deepcat ON subcat = cl_to
)
SELECT * FROM deepcat WHERE subcat = 'Formula_One';

​x
 
SET @basecat = 'Auto_racing';SET max_recursive_iterations = 7;​WITH RECURSIVE deepcat (subcat, route, depth) AS(  SELECT @basecat,         @basecat,         0​  UNION​  SELECT page_title,         CONCAT(route, ' > ', page_title),         depth + 1  FROM categorylinks  JOIN page ON page_id = cl_from AND page_namespace = 14  JOIN deepcat ON subcat = cl_to)SELECT * FROM deepcat WHERE subcat = 'Formula_One';

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...