Hi everyone,
I'm trying to find out where this sql is generated??
Can anyone help me out here?
"SELECT TOP 500 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,
LastThread.Author_ID, LastAuthor.Username, tblTopic.Event_date 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 = 2
OR tblTopic.Forum_ID = 2) ) AND (tblTopic.Hide = 0 OR tblThread.Author_ID = 146) ORDER BY
tblTopic.Priority DESC, LastThread.Message_date DESC"