Casey Wise projects and web archive/sandbox

SELECT DISTINCT
	d.category_name,
	d.inode
FROM
	tree a
	INNER JOIN category b
		ON a.child = b.inode
	INNER JOIN tree c
		ON a.child = c.parent
	INNER JOIN category d
		ON c.child = d.inode
	INNER JOIN tree e
		ON c.child = e.parent
	INNER JOIN category f
		ON e.child = f.inode
		AND f.active = 1
WHERE
	a.parent = 155228
	AND c.parent = "+$parentInode