WITH RECURSIVE mylist(id,parent_id,title,created,last_modified) AS (SELECT id,parent_id,title,created,last_modified FROM Content WHERE id=73 UNION SELECT child.id,child.parent_id,child.title,child.created,child.last_modified FROM Content AS child, mylist AS parentMyList WHERE child.parent_id=parentMyList.id) SELECT * FROM mylist ORDER BY created DESC;
It selects a flat view of a list of threaded posts. Looking through the docs, I think maybe the same thing can be achieved with CActiveFinder, but I'm not sure. My goal is to produce a single list of threaded data, sorted chronologically, including all descendents in a tree.
Any suggestions on the best way to do this properly with Yii?
As usual, thanks for the kind help!