Casey Wise projects and web archive/sandbox

SELECT DISTINCT
	b.category_name AS 'subject_cluster',
	b.inode as 'clusterInode'
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