SELECT	P.unqPageID,
			P.unqPageTypeID,
			P.vchFileName,
			P.vchLink,
			P.vchLinkTarget,
			C.vchPageName,
			C.unqNavTypeID,
			C.vchLiveNavContent,
			C.unqNavStoreWareInstanceId,
			C.unqNavMediaGalleryId,
			C.unqNavCalendarId,
			C.unqNavNewsID,
			C.unqNavFAQID,
			C.vchNavIncludeFile
	FROM	tblWebsitePages P
		INNER JOIN tblWebsitePageContent C ON (P.unqPageID = C.unqPageID AND C.unqLanguageID = '385E8678-FFDC-4169-A1B5-2D5A2F248D64')
		INNER JOIN tblPageContentTypes T ON (C.unqPageContentTypeID = T.unqPageContentTypeID AND T.vchPageContentType = 'Desktop')
	WHERE	P.unqCustomerID = '3751BCB4-1301-4D3A-8B05-3EAB862C1CE0'
	
	AND		P.bitActive = 1
	
	AND		P.bitShowOnNav = 1
	
	AND		P.unqParentPageID IS NULL
	ORDER BY P.intSortId

 
	SELECT	P.unqPageTypeID,
			P.unqParentPageId,
			P.unqStoreWareInstanceId,
			P.unqPhotoGalleryId,
			P.unqCalendarId,
			P.unqNewsCategoryID,
			P.unqPageTurnId,
			P.unqFAQCategoryID,
			P.vchFileName,
			C.vchPageName,
			C.vchPageSubtitle,
			C.txtLivePageContent,
			C.vchLiveUnsecuredContent,
			C.vchTitle,
			C.txtDescription,
			C.txtKeywords,
			P.vchLink,
			P.vchLinkTarget,
			P.vchIncludeFile,
			P.xmlPageVariables,
			P.vchEmail,
			hasSecurity = (SELECT COUNT(unqPageGroupID) FROM tblWebsitePageGroup WHERE unqPageID = P.unqPageID)
	FROM	tblWebsitePages P
		INNER JOIN tblWebsitePageContent C ON (P.unqPageID = C.unqPageID AND C.unqLanguageID = '385E8678-FFDC-4169-A1B5-2D5A2F248D64')
		INNER JOIN tblPageContentTypes T ON (C.unqPageContentTypeID = T.unqPageContentTypeID AND T.vchPageContentType = 'Desktop')
	WHERE	P.unqCustomerID = '3751BCB4-1301-4D3A-8B05-3EAB862C1CE0'
	AND		P.unqPageID = 'c757c2b8-f70e-468f-837c-ae2f7886d3e0'
	
		AND		P.bitActive = 1
		

			SELECT 	unqMediaGalleryId
			FROM 	tblWebsitePageMediaGalleries
			WHERE 	unqWebsitePageId = ? 

    SELECT	TOP 6 CEL.*,
            CE.datStartDate,
            CE.datEndDate,
            CL.vchCalendarName
    FROM	SysApp_v2_CalendarEvents CE
        INNER JOIN SysApp_v2_CalendarEventLocalizations CEL ON (CE.unqCalendarEventId = CEL.unqCalendarEventId)
        INNER JOIN SysApp_v2_CalendarLocalizations CL ON (CE.unqCalendarId = CL.unqCalendarId)
    AND		CE.unqCalendarId IN (SELECT unqCalendarId FROM SysApp_v2_Calendars WHERE unqCustomerID = ?)
    ORDER BY CE.datStartDate

    SELECT	TOP 6 NAL.*,
            NA.vchAuthor,
            NCL.vchCategoryName,
            COALESCE(NA.datArticleDate, CAST((STR( YEAR( GETDATE() ) ) + '/' + STR( MONTH( GETDATE() ) ) + '/' + STR( DAY( GETDATE()))) AS DATETIME)) AS datArticleDate
    FROM	SysApp_v2_NewsArticles NA
        INNER JOIN SysApp_v2_NewsArticleLocalizations NAL ON (NA.unqNewsArticleId = NAL.unqNewsArticleId
        	AND NAL.unqLanguageId = ?)
        INNER JOIN SysApp_v2_NewsCategories NC ON (NA.unqNewsCategoryId = NC.unqNewsCategoryId)
        INNER JOIN SysApp_v2_NewsCategoryLocalizations NCL ON (NC.unqNewsCategoryId = NCL.unqNewsCategoryId
        	AND NCL.unqLanguageId = ?)
    WHERE	NA.unqNewsCategoryId IN (SELECT unqNewsCategoryId FROM SysApp_v2_NewsCategories WHERE unqCustomerID = ?)
    AND		NA.bitFeatured = 1
    AND 	NAL.bitActive = ?
    AND		(NA.datDisplayStartDate IS NULL OR NA.datDisplayStartDate <= {ts '2020-07-07 06:25:45'})
    AND		(NA.datDisplayEndDate IS NULL OR NA.datDisplayEndDate >= {ts '2020-07-07 06:25:45'})
    ORDER BY NA.datArticleDate DESC, NAL.vchArticleTitle

        SELECT	TOP 8 *
        FROM	CMSDemo_HomeSlideshow		
        WHERE	bitActive = 1
        ORDER BY intSortOrder
    

	SELECT	unqPageID,
			vchFilename
	FROM	tblWebSitePages
	WHERE	unqCustomerID = '3751BCB4-1301-4D3A-8B05-3EAB862C1CE0'
	AND		unqPageID = dbo.GetRoot('3751BCB4-1301-4D3A-8B05-3EAB862C1CE0','c757c2b8-f70e-468f-837c-ae2f7886d3e0')

	SELECT	P.unqPageID,
			P.unqPageTypeID,
			P.vchFileName,
			C.vchPageName
	FROM	tblWebsitePages P
		INNER JOIN tblWebsitePageContent C ON (P.unqPageID = C.unqPageID AND C.unqLanguageID = '385E8678-FFDC-4169-A1B5-2D5A2F248D64')
	WHERE	P.unqCustomerID = '3751BCB4-1301-4D3A-8B05-3EAB862C1CE0'
	AND		P.bitActive = 1
	AND		P.unqParentPageID = ?
	ORDER BY P.intSortID

                            SELECT	unqPageID,
                                    vchFilename
                            FROM	tblWebSitePages
                            WHERE	unqCustomerID = '3751BCB4-1301-4D3A-8B05-3EAB862C1CE0'
                            AND		unqPageID = dbo.GetRoot('3751BCB4-1301-4D3A-8B05-3EAB862C1CE0','c757c2b8-f70e-468f-837c-ae2f7886d3e0')
                        

                            SELECT	P.unqPageID, unqParentPageID, vchPageName, vchFileName
                            FROM	tblWebsitePages P
                                INNER JOIN tblWebsitePageContent C ON (P.unqPageID = C.unqPageID)
                            WHERE	P.unqCustomerID = '3751BCB4-1301-4D3A-8B05-3EAB862C1CE0'
                            AND		P.bitActive  = 1
                            AND 	c.unqPageContentTypeId = 'e26018f9-e9f8-4dce-ad95-543c83c77ffe'
                            AND		P.unqPageID = 'C757C2B8-F70E-468F-837C-AE2F7886D3E0'
                            ORDER BY intSortID
                        

                            SELECT	P.*,
                                    C.vchPageName
                            FROM	tblWebsitePages P
                                INNER JOIN tblWebsitePageContent C ON (P.unqPageID = C.unqPageID AND C.unqLanguageID = '385E8678-FFDC-4169-A1B5-2D5A2F248D64')
                            WHERE	P.unqCustomerID = '3751BCB4-1301-4D3A-8B05-3EAB862C1CE0'
                            AND		P.bitActive = 1
                            AND 	c.unqPageContentTypeId = 'e26018f9-e9f8-4dce-ad95-543c83c77ffe'
                            AND		P.unqParentPageID = ?
                            ORDER BY P.intSortID
                        

	SELECT 	MGIS.*
	FROM 	SysApp_v2_MediaGallerySettings MGIS
	WHERE 	MGIS.unqCustomerId = ?
	AND 	MGIS.unqPageId = ? 

	WITH Items AS (
		SELECT 	MG.*,
				MGL.vchMediaGalleryName,
				MGL.vchMediaGalleryArtifact,
				MGL.vchMediaGallerySummary,
				MGL.vchMediaGalleryDescription,
				MGL.vchMetaTitle,
				MGL.vchMetaDescription,
				ROW_NUMBER() OVER (ORDER BY MG.intSortOrder) AS RowNumber
		FROM 	SysApp_v2_MediaGalleries MG
		JOIN	SysApp_v2_MediaGalleryLocalizations MGL
			ON 	(MG.unqMediaGalleryId = MGL.unqMediaGalleryId)
		WHERE 	MGL.unqLanguageId = ?
		AND 	MG.unqCustomerId = ?
		AND 	MGL.bitActive = ? 
		AND 	MGL.unqMediaGalleryId IN (?,?)
		
	)
	SELECT 	*,
			TotalRecords = (SELECT COUNT(*) FROM Items)
	FROM 	Items
	
	WHERE	RowNumber BETWEEN 1 AND 4 

	WITH Items AS (
		SELECT 	MGIL.*,
				MGI.datItemDate,
				MT.vchMediaTypeName,
				WebsitePage = (
								SELECT	TOP 1 vchFilename
								FROM	tblWebsitePages WP
								LEFT JOIN  tblWebsitePageMediaGalleries WPMG
									ON 	WP.unqPageId = WPMG.unqWebsitePageId
								WHERE	WP.unqCustomerID = ?
								AND		WP.unqPageTypeId = 'a5ac8a7c-7023-499a-91b1-dfda5b5454cf'
								AND		WP.bitActive = 1
								AND		(WPMG.unqMediaGalleryId = MGI.unqMediaGalleryId
								OR		WPMG.unqMediaGalleryId IS NULL)
								ORDER BY unqMediaGalleryId DESC
								),
				ROW_NUMBER() OVER (ORDER BY MGI.bitFeatured DESC, MGI.intSortOrder) AS RowNumber
		FROM 	SysApp_v2_MediaGalleryItems MGI
		JOIN 	SysApp_v2_MediaGalleryItemLocalizations MGIL
			ON 	(MGI.unqMediaGalleryItemId = MGIL.unqMediaGalleryItemId
				AND MGIL.unqLanguageId = ? 				
				)
		JOIN 	SysApp_v2_MediaTypes MT
			ON 	(MGI.unqMediaTypeId = MT.unqMediaTypeId)
		WHERE 	1 = 1
		
		AND 	MGI.unqMediaGalleryId = ? 
	)
	SELECT 	*
	FROM 	Items
	
	WHERE 	RowNumber BETWEEN 1 AND 2 

	WITH Items AS (
		SELECT 	MGIL.*,
				MGI.datItemDate,
				MT.vchMediaTypeName,
				WebsitePage = (
								SELECT	TOP 1 vchFilename
								FROM	tblWebsitePages WP
								LEFT JOIN  tblWebsitePageMediaGalleries WPMG
									ON 	WP.unqPageId = WPMG.unqWebsitePageId
								WHERE	WP.unqCustomerID = ?
								AND		WP.unqPageTypeId = 'a5ac8a7c-7023-499a-91b1-dfda5b5454cf'
								AND		WP.bitActive = 1
								AND		(WPMG.unqMediaGalleryId = MGI.unqMediaGalleryId
								OR		WPMG.unqMediaGalleryId IS NULL)
								ORDER BY unqMediaGalleryId DESC
								),
				ROW_NUMBER() OVER (ORDER BY MGI.bitFeatured DESC, MGI.intSortOrder) AS RowNumber
		FROM 	SysApp_v2_MediaGalleryItems MGI
		JOIN 	SysApp_v2_MediaGalleryItemLocalizations MGIL
			ON 	(MGI.unqMediaGalleryItemId = MGIL.unqMediaGalleryItemId
				AND MGIL.unqLanguageId = ? 				
				)
		JOIN 	SysApp_v2_MediaTypes MT
			ON 	(MGI.unqMediaTypeId = MT.unqMediaTypeId)
		WHERE 	1 = 1
		
		AND 	MGI.unqMediaGalleryId = ? 
	)
	SELECT 	*
	FROM 	Items
	
	WHERE 	RowNumber BETWEEN 1 AND 2 

CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=
CERT_SECRETKEYSIZE=
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=
CERT_SERVER_SUBJECT=
CERT_SUBJECT=
CF_TEMPLATE_PATH=d:\sites\cmsdemo\html\media-gallery.cfm
CONTENT_LENGTH=0
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=off
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
HTTP_ACCEPT=text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
HTTP_ACCEPT_ENCODING=br,gzip
HTTP_ACCEPT_LANGUAGE=en-US,en;q=0.5
HTTP_CONNECTION=Keep-Alive
HTTP_COOKIE=
HTTP_HOST=demo.devwebware.com
HTTP_REFERER=
HTTP_URL=/media-gallery.cfm
HTTP_USER_AGENT=CCBot/2.0 (https://commoncrawl.org/faq/)
LOCAL_ADDR=10.0.0.13
PATH_INFO=
PATH_TRANSLATED=d:\sites\cmsdemo\html\media-gallery.cfm
QUERY_STRING=
REMOTE_ADDR=3.236.97.49
REMOTE_HOST=3.236.97.49
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/media-gallery.cfm
SERVER_NAME=demo.devwebware.com
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/10.0
WEB_SERVER_API=

Client Variables:
cfid=35817
cftoken=a27998cd0d91ce4f-9A360625-CE94-C712-662CB88D3CB572DB
hitcount=1
lastvisit={ts '2020-07-07 06:25:45'}
timecreated={ts '2020-07-07 06:25:45'}
urltoken=CFID=35817&CFTOKEN=a27998cd0d91ce4f-9A360625-CE94-C712-662CB88D3CB572DB

URL Parameters:
ACTION=Galleries
PAGE=0