SELECT TOP 750 tblThread.Thread_ID, tblTopic.Topic_ID, tblTopic.Forum_ID, 1 As Unread FROM tblTopic WITH (NOLOCK) , tblThread WITH (NOLOCK) WHERE tblTopic.Topic_ID = tblThread.Topic_ID AND tblThread.Message_date > '20250404 12:06:22' AND tblTopic.Hide = 0 AND tblThread.Hide = 0 ORDER BY tblTopic.Last_Thread_ID DESC;
SELECT * FROM (SELECT TOP 504 tblTopic.Topic_ID, tblTopic.Poll_ID, tblTopic.Moved_ID, tblTopic.Subject, tblTopic.Icon, tblTopic.Start_Thread_ID, tblTopic.Last_Thread_ID, tblTopic.No_of_replies, tblTopic.No_of_views, tblTopic.Locked, tblTopic.Priority, tblTopic.Hide, tblThread.Message_date, tblThread.Message, tblThread.Author_ID, tblAuthor.Username, LastThread.Message_date AS LastMessageDate, LastThread.Author_ID AS LastTreadDate, LastAuthor.Username AS LastUsername, tblTopic.Event_date, tblTopic.Event_date_end, tblTopic.Rating, tblTopic.Rating_Votes , ROW_NUMBER() OVER (ORDER BY tblTopic.Priority DESC, tblTopic.Last_Thread_ID DESC) AS RowNum FROM tblTopic WITH (NOLOCK) , tblThread WITH (NOLOCK) , tblThread AS LastThread WITH (NOLOCK) , tblAuthor WITH (NOLOCK) , tblAuthor AS LastAuthor WITH (NOLOCK) WHERE ( tblThread.Author_ID = tblAuthor.Author_ID AND LastThread.Author_ID = LastAuthor.Author_ID AND tblTopic.Start_Thread_ID = tblThread.Thread_ID AND tblTopic.Last_Thread_ID = LastThread.Thread_ID AND (tblTopic.Priority = 3 OR tblTopic.Moved_ID = 8 OR tblTopic.Forum_ID = 8) ) AND (tblTopic.Hide = 0 ) ) AS PagingQuery WHERE RowNum BETWEEN 481 AND 504 ;
Chat Board - Top 40 Music on CD Forum
Top 40 Music on CD Homepage
Forum Home Forum Home > Top 40 Music On Compact Disc > Chat Board
  Forum Options Forum Options  New Posts New Posts RSS Feed: Chat Board
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

WE ARE EXPIENCING PROBLEMS WITH THE FORUM AND ARE WORKING TO GET THEM RESOLVED. THE SEARCHABLE DATABASE CAN STILL BE ACCESSED FROM THE HOME PAGE. THANK YOU FOR YOUR PATIENCE.

Chat Board

 New Topic Create New Topic Show Topics <1
 
Topics / Topic Starter
Rating 
 Replies Views Last Post Reverse Sort Order

There are no messages posted in this forum in the   'Any Date'

 New Topic Create New Topic <1

Forum Jump 		Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.07
Copyright ©2001-2024 Web Wiz Ltd.

This page was generated in 0.754 seconds.