SELECT * FROM (SELECT TOP 96 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 73 AND 96 ;
Chat Board - Top 40 Music on CD Forum

Forum Home > Top 40 Music On Compact Disc > Chat Board

Forum Options

Create New Topic

New Posts

FAQ

PLEASE COME BACK LATER. WE ARE HAVING DATABASE PROBLEMS. THANK YOU FOR YOUR PATIENCE.

Chat Board

New Topic

Show Topics

	Topics / Topic Starter Rating	Replies	Views	Last Post
There are no messages posted in this forum in the 'Any Date'

New Topic

Forum Jump

Forum Permissions View Drop Down

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum