(posting this here now because it's in my head but i have to go and do something else right now)
db todo:
- use rcte for forum parent breadcrumbs
- create views for most recent activity (per forum and for subforums), then simplify the big query for viewing a forum