SELECT SecurityLevel,locked,avatars FROM tblForums WHERE ForumID = SELECT dbo.tblMessages.ThreadID, dbo.tblThreads.ThreadTitle, dbo.tblThreads.ForumID, dbo.tblThreads.Locked, dbo.tblUsers.UserName, dbo.tblUsers.HomeEmail, dbo.tblUsers.WorkEmail, dbo.tblMessages.MessageDateTime, dbo.tblMessages.MessageText, dbo.tblUsers.TotalPosts, dbo.tblUsers.avatarID, dbo.tblUsers.JoinedDate, dbo.tblUsers.UserID, dbo.tblUsers.SecurityLevel, dbo.tblMessages.MessageID, dbo.tblForums.ForumName, dbo.tblMessages.EditedBy, dbo.tblMessages.EditedDate, dbo.tblUsers.UserTitle, dbo.tblImages.fileName AS imgName, dbo.tblThreads.announcement, dbo.tblThreads.hotTopic, dbo.tblUsers.firstname, dbo.tblUsers.lastname, dbo.tblUsers.jobTitle, dbo.tblUsers.company FROM dbo.tblThreads INNER JOIN dbo.tblMessages INNER JOIN dbo.tblUsers ON dbo.tblMessages.UserID = dbo.tblUsers.UserID ON dbo.tblThreads.ThreadID = dbo.tblMessages.ThreadID INNER JOIN dbo.tblForums ON dbo.tblThreads.ForumID = dbo.tblForums.ForumID LEFT OUTER JOIN dbo.tblImages ON dbo.tblUsers.avatarID = dbo.tblImages.imageID LEFT JOIN tblSecurityLevels ON tblUsers.securityLevel = tblSecurityLevels.securityID WHERE tblForums.ForumID = AND tblMessages.ThreadID = ORDER BY tblMessages.MessageDateTime #session.defaultMessageOrder#

Forum Home \ #messages.ForumName# \ #messages.ThreadTitle#	Add New Reply
There are multiple pages of messages: #i# #i#

SELECT ForumID, ForumName FROM dbo.tblForums WHERE (SecurityLevel & ) > 0 ORDER BY ForumName

Messages currently ordered by date addedMessages currently ordered by reverse date order

Topic: #messages.ThreadTitle# [This threadforum has been locked by a moderator]

MOD ACTIONS:

#firstname# #lastname#

#UserTitle# #jobTitle#
#company#

Posts: #TotalPosts#
Joined: #dateformat(JoinedDate,"dd mmm yy")#

#dateformat(MessageDateTime,"dd mmmm yyyy")# #Timeformat(MessageDateTime,"HH:mm")# Edited by #EditedBy# on #dateformat(EditedDate)# at #timeformat(EditedDate,"HH:mm")#

Edit Message Delete Message Reply

#MessageText#

#repeatstring(" ", 150)#

Page [ #i# #i# ]

#messages.ThreadTitle# [This threadforum has been locked by a moderator.]