select id, name from #application.settings.tableprefix#conferences select id, name, conferenceidfk from #application.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 messages desc

Top 10 Threads by Message Count

Thread Name

Message Count

#name#

#messages#

select * from users order by postcount desc