Have you ever wondered how to obtain tickets for the Masters Golf Tournament? Continue reading for full details. Getting to Augusta is easier than you think!
Continue Reading →
The sport of golf is a global phenomenon, and many courses and tournaments on the PGA tour boast strong attendance and prestige, but the Masters' green jacket stands alone as one of the most coveted awards in the sport. When it comes to professional golf, the Masters is truly the kingmaker of the sport. Today we are taking a closer look at the Masters and why you should be excited about the upcoming tournament.
Continue Reading →
Stay updated with Major Sports Augusta's blog. Dive into expert insights, local sports highlights, and the latest news on Augusta’s biggest golf events.
Major Sports Augusta, Masters, Masters Tickets, Masters Hospitality, Masters Golf, The Masters, Corporate sports travel, Sporting events, Travel Packages,
Read Our Blog | Major Sports Augusta
BLOG
1
1
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