Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - What page would generate this SQL?
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

What page would generate this SQL?

 Post Reply Post Reply
Author
Ozbboy View Drop Down
Newbie
Newbie
Avatar

Joined: 30 April 2005
Location: Australia
Status: Offline
Points: 5
Post Options Post Options   Thanks (0) Thanks(0)   Quote Ozbboy Quote  Post ReplyReply Direct Link To This Post Topic: What page would generate this SQL?
    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"
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.


Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.