select id, name from #application.galleon.settings.tableprefix#conferences select id, name, conferenceidfk from #application.galleon.settings.tableprefix#forums

Number of Forums Per Conference
select count(id) as total from forums where conferenceidfk = '#id#'

Number of Threads Per Forum
select count(id) as total from threads where forumidfk = '#id#'

select * from threads order by messagecount desc

Top 10 Threads by Message Count
Thread Name Message Count
#name# #messagecount#

select * from users order by postcount desc

Top 10 Users by Post Count
User Name Post Count
#username# #postcount#