Stuff
public text v1 · immutable 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