Stuff

			SELECT
			`Forum`.`ID`,
			`Forum`.`title`,
			`Forum`.`description`,
			`Forum`.`threads`,
			`Forum`.`posts`,
			`Forum`.`lastpost_time`,
			`Forum`.`lastpost_user_id`,
			`Forum`.`lft`,
			`Forum`.`rgt`,
			`parent`.`lft`,
			`parent`.`rgt`,
			COUNT(`Forum`.`ID`) -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