SELECT Threads.Thread_ID, Threads.Name, Messages.ThreadUserName, Messages.Body, Messages.Posted
FROM Messages Messages INNER JOIN Threads Threads ON Messages.Thread_ID = Threads.Thread_ID
WHERE (Messages.Parent_message_ID = 0)
ORDER BY Threads.Thread_ID DESC
One Hit Wonder Central - Recent Posts
http://www.onehitwondercentral.com/forum/
<![CDATA[#Name#]]>
http://www.onehitwondercentral.com/forum/thread.cfm?threadid=#Thread_ID#
General Discussionhttp://www.onehitwondercentral.com/forum/thread.cfm?threadid=#Thread_ID##DateFormat(Posted, 'ddd, dd mmm yyyy hh:mm:ss')# CSThttp://www.onehitwondercentral.com/forum/thread.cfm?threadid=#Thread_ID#