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



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net