Web Wiz Support and Community Forums : What page would generate this SQL? https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Thu, 09 Apr 2026 09:00:18 +0000 Wed, 26 Jul 2006 09:19:49 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=20816 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[What page would generate this SQL? : This could be from a number of...]]> https://forums.webwiz.net/what-page-would-generate-this-sql_topic20816_post111493.html#111493 Author: WebWiz-Bruce
Subject: 20816
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.
]]> Wed, 26 Jul 2006 09:19:49 +0000 https://forums.webwiz.net/what-page-would-generate-this-sql_topic20816_post111493.html#111493 <![CDATA[What page would generate this SQL? : Hi everyone,I&#039;m trying to...]]> https://forums.webwiz.net/what-page-would-generate-this-sql_topic20816_post111472.html#111472 Author: Ozbboy
Subject: 20816
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"
]]> Wed, 26 Jul 2006 01:09:27 +0000 https://forums.webwiz.net/what-page-would-generate-this-sql_topic20816_post111472.html#111472