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=3;

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

  UNION

  SELECT p2.page_title,
         CONCAT(deepcat.route, ' > ', p2.page_title),
         deepcat.`depth` + 1 AS `depth`
  FROM categorylinks AS cl2
  JOIN page AS p2 ON p2.page_id = cl2.cl_from AND p2.page_namespace = 14
  JOIN deepcat ON cl2.cl_to = deepcat.subcat
)
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...