I think you could use the topic_views table to grab a count of the latest views for a topic, and group/sum that by category? The topic_views table counts one new view a day though, rather than ‘1-per-8-hours’ so it may give a smaller figure than you may be expecting when compared to the topics.views number.