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 14:25:45' AND tblTopic.Hide = 0 AND tblThread.Hide = 0 ORDER BY tblTopic.Last_Thread_ID DESC;
SELECT * FROM (SELECT TOP 24 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.Rating ASC) 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 1 AND 24 ;
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
 
Topics / Topic Starter
Rating Reverse Sort Order 
 Replies Views Last Post

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

 New Topic Create New Topic

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.863 seconds.