MySQL Closure Table hierarchical database – How to pull information out in the correct order
SELECT d.`iD`, d.`subsectionOf`, CONCAT(REPEAT(‘-‘, p.`len`), d.`name`) as hier, p.`len`, p.`ancestor`, p.`descendant`, GROUP_CONCAT(crumbs.`ancestor`) AS breadcrumbs FROM `TreeData` AS d JOIN `TreePaths` AS p ON d.`iD` = p.`descendant` JOIN `TreePaths` AS crumbs ON crumbs.`descendant` = p.`descendant` WHERE p.`ancestor` = 1 GROUP BY d.`iD` ORDER BY breadcrumbs; +—-+————–+———————+—–+———-+————+————-+ | iD | subsectionOf | hier | len | ancestor … Read more