Casey Wise projects and web archive/sandbox

SELECT DISTINCT
	c.title,
	c.inode,
	c.text_area1 as 'overview'
FROM
	category a
	INNER JOIN tree b
		ON a.inode = b.parent
	INNER JOIN contentlet c
		ON b.child  = c.inode
		AND c.live=1
	INNER JOIN tree d
		ON c.inode = d.child
	INNER JOIN category e
		ON d.parent = e.inode
	INNER JOIN tree f
		ON d.parent = f.child
WHERE
	a.inode = $inode
	AND f.parent = 155153
	AND d.parent = $filterInode
ORDER BY
	c.title