Planning a Corporate Trip to Augusta for Tournament Week
If you’re planning a corporate retreat to Augusta for Tournament Week in April, Major Sports Augusta has you covered!
Continue Reading →
Posted in
trip to augusta
Read Our Blog
Posts in Category: trip-to-augustaShow All Posts »
Recent Posts
Most Used Categories
Monthly Archive
| query | ||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| RESULTSET |
|
|||||||||||||||||||||||||||
| CACHED | false | |||||||||||||||||||||||||||
| EXECUTIONTIME | 1 | |||||||||||||||||||||||||||
| SQL | DECLARE @SiteID int, @PageID int, @NavID int, @Link varchar(100); SET @SiteID = ?; SET @PageID = ?; SET @NavID = ?; SET @Link = ?; SELECT '1' AS metaRank, tblStaticPages.txtPageName, tblStaticPages.txtFilename, tblStaticPages.txtMetaTitle, tblStaticPages.txtMetaDescription, tblStaticPages.txtMetaKeywords, tblStaticPages.ysnActive, 0 AS ysnPrimary FROM tblStaticPages WHERE tblStaticPages.PK_autStaticPageID = @PageID AND tblStaticPages.ysnActive = 1 AND tblStaticPages.FK_lngSiteID = @SiteID UNION ALL SELECT '2' AS metaRank, tblNavigation.txtNavigationName, tblNavigation.txtNavigationLink, tblNavigation.txtMetaTitle, tblNavigation.txtMetaDescription, tblNavigation.txtMetaKeywords, tblNavigation.ysnActive, tblNavigation.ysnPrimary FROM tblNavigation WHERE tblNavigation.PK_autNavigationID = @NavID AND tblNavigation.ysnDeleted = 0 AND tblNavigation.FK_lngSiteID = @SiteID UNION ALL SELECT '2' AS metaRank, tblNavigation.txtNavigationName, tblNavigation.txtNavigationLink, tblNavigation.txtMetaTitle, tblNavigation.txtMetaDescription, tblNavigation.txtMetaKeywords, tblNavigation.ysnActive, tblNavigation.ysnPrimary FROM tblNavigation WHERE ( tblNavigation.txtNavigationLink = @Link OR tblNavigation.txtNavigationLink LIKE '%blog%' ) AND tblNavigation.ysnDeleted = 0 AND tblNavigation.FK_lngSiteID = @SiteID ORDER BY metaRank, ysnActive DESC, ysnPrimary DESC | |||||||||||||||||||||||||||
| SQLPARAMETERS |
|
|||||||||||||||||||||||||||