Web Wiz Forums - What page would generate this SQL?

Print Page | Close Window

What page would generate this SQL?

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=20816
Printed Date: 09 April 2026 at 8:57am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: What page would generate this SQL?

Posted By: Ozbboy
Subject: What page would generate this SQL?
Date Posted: 26 July 2006 at 1:09am

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"

-------------
"http://www.ozbboy.com - www.ozbboy.com

Replies:

Posted By: WebWiz-Bruce
Date Posted: 26 July 2006 at 9:19am

This could be from a number of different pages as very similar SQL queries to this are used on about 10 different pages and as they are created on the fly they are often slightly different.

If you can tell me which page it is that you are looking at I should be able to tell you what code is used to create this SQL Query on the fly.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting