The following query return a list of forums and related info.
I need the query to return the number of threads in each forums and the total number of messages from all threads in that forum.
The table name for the threads is "sf_threads" and for the messages "sf_messages".
Thanks for the help. Hopefully I will learns from your answers.
B.name as conference,
B.sort_order as conference_order,
A.sort_order as forum_order,
E.title as group_title,
A.msgcount as messagecount,
inner join conferences B
on A.conferenceidfk = B.id)
left join usergroups E