SELECT Forums.FID AS FFID, Forums.Forum, Forums.Description, Forums.TCount, Forums.MCount, Forums.LastPost, Moderators.FID, Moderators.UID, Users.UID, Users.UserName, Forums.GID, Groups.GroupName FROM ((Forums LEFT JOIN Groups ON Forums.GID = Groups.GID) LEFT JOIN Moderators ON Forums.FID = Moderators.FID) LEFT JOIN Users ON Moderators.UID = Users.UID WHERE Forums.GID = #GID# ORDER BY Forums.GID, Forums.FID, Users.UID SELECT COUNT(*) AS TotalUsers FROM Users WHERE ActDate IS NOT NULL #L_Available_Forums#   #GetForumUsers.TotalUsers# #L_RegisteredUsers#    (#L_ViewToday#)  #L_Forum#   #L_Threads#   #L_Messages#   #L_LastMessage#   #L_Moderator#  #GroupName# #Icon_New#  #TRIM(Forum)#
#TRIM(Description)# #TCount# #MCount# #L_Today##L_Yesterday##DateFormat(LastPost, '#DateMask#')#
#TimeFormat(LastPost, '#TimeMask#')#  #UserName#')> #TRIM(Mods)#  #L_NoForums#