Anonymous

		$data							= $this->Forum->query("SELECT `Forum`.*,
																`parent`.*,
																COUNT( * ) -1 AS level,
																`User`.`username`
																FROM `forums` AS `Forum`,
																`forums` AS `parent`
																LEFT JOIN `users` AS `User` ON (`Forum`.`lastpost_user_id` = `User`.`ID`)
																WHERE Forum.lft BETWEEN parent.lft AND parent.rgt
																GROUP BY Forum.lft
																ORDER BY Forum.lft");