https://cjhaas.com/2019/10/25/mysql-recursive-cte/
mySQL Recursive CTE - cjhaas blog
Oct 25, 2019 - Almost 10 years ago I asked this question on Stack Overflow about how to find the deepest nodes in a recursive table using a Common Table Expression (CTE)....
recursive ctemysqlblog