Search Results

	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 = 'eb1b57f5-6bc2-4d59-932f-02aaa3065c8a'
	
		AND		P.bitActive = 1
		

    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 07:00:14'})
    AND		(NA.datDisplayEndDate IS NULL OR NA.datDisplayEndDate >= {ts '2020-07-07 07:00:14'})
    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','eb1b57f5-6bc2-4d59-932f-02aaa3065c8a')

	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','eb1b57f5-6bc2-4d59-932f-02aaa3065c8a')
                        

                            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 = 'EB1B57F5-6BC2-4D59-932F-02AAA3065C8A'
                            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 	SS.intItemsPerPage,
			SS.vchDefaultTab,
			SS.bitShowPages,
			SS.bitShowNews,
			SS.bitShowEvents,
			SS.bitShowMedia,
			SS.bitShowLibrary,
			SS.bitShowFAQs
	FROM 	SysApp_v2_SearchSettings SS
	WHERE 	SS.unqCustomerId = ? 

	WITH	Pages AS (
		SELECT	ROW_NUMBER() OVER (ORDER BY PC.vchPageName) AS RowNumber,
				P.vchFileName AS URL,
				CASE
					WHEN PC.vchTitle IS NULL THEN PC.vchPageName
					WHEN PC.vchTitle = '' THEN PC.vchPageName
					ELSE PC.vchTitle
				END AS Title,
				PC.txtDescription AS Description
		FROM	tblWebsitePages P
			INNER JOIN tblWebsitePageContent PC ON (P.unqPageID = PC.unqPageID AND PC.unqLanguageID = '385E8678-FFDC-4169-A1B5-2D5A2F248D64')
		WHERE	P.unqCustomerID = '3751BCB4-1301-4D3A-8B05-3EAB862C1CE0'
		AND		P.bitActive = 1
		AND		P.bitShowInSiteMap = 1
		AND		PC.unqLanguageID = '385E8678-FFDC-4169-A1B5-2D5A2F248D64'
		
		AND		PC.unqPageContentTypeID = 'e26018f9-e9f8-4dce-ad95-543c83c77ffe'
		
			)
	SELECT	*,
			TotalRecords = (SELECT COUNT(*) FROM Pages)
	FROM	Pages
	
	WHERE	RowNumber BETWEEN 1 AND 11 

	WITH	InternalArticles AS (
		SELECT	NAL.vchArticleTitle AS Title,
				NAL.vchArticleSummary AS Description,
				NAL.vchArticleLink AS URL,
				COALESCE(NA.datArticleDate, CAST((STR( YEAR( GETDATE() ) ) + '/' + STR( MONTH( GETDATE() ) ) + '/' + STR( DAY( GETDATE()))) AS DATETIME)) AS datArticleDate,
				NC.unqNewsCategoryId,
				NCL.vchCategoryName,
				NAL.unqNewsArticleTypeId,
				WebsitePage = (
								SELECT	TOP 1 vchFilename
								FROM	tblWebsitePages WP
								LEFT OUTER JOIN tblWebsitePageNewsCategories WPNC ON (WP.unqPageId = WPNC.unqWebsitePageId)
								WHERE	WP.unqCustomerID = ?
								AND		WP.unqPageTypeId = '6661a8d6-eaaf-475c-9883-b6a3ffa316e8'
								AND		WP.bitActive = 1
								AND		(
											WPNC.unqNewsCategoryID = NC.unqNewsCategoryId
											OR WPNC.unqNewsCategoryID IS NULL
										)
								ORDER BY WP.unqNewsCategoryID DESC
								)
		FROM	SysApp_v2_NewsArticles NA
		JOIN SysApp_v2_NewsArticleLocalizations NAL
				ON (NA.unqNewsArticleId = NAL.unqNewsArticleId AND NAL.unqLanguageId = ? AND NAL.bitActive = ?)
		JOIN SysApp_v2_NewsCategories NC
				ON (NA.unqNewsCategoryId = NC.unqNewsCategoryId AND NC.unqCustomerID = ?)
		JOIN SysApp_v2_NewsCategoryLocalizations NCL
				ON (NC.unqNewsCategoryId = NCL.unqNewsCategoryId AND NCL.bitActive = ?)
		WHERE	(NA.datDisplayStartDate IS NULL OR NA.datDisplayStartDate <= {d '2020-07-07'})
		AND		(NA.datDisplayEndDate IS NULL OR NA.datDisplayEndDate >= {d '2020-07-07'})
		
		),
		Articles AS (
		SELECT	*, 
				ROW_NUMBER() OVER (ORDER BY datArticleDate DESC, Title) AS RowNumber
		FROM 	InternalArticles
		WHERE	WebsitePage IS NOT NULL
		)
	SELECT	TOP 1 *,
			TotalRecords = (SELECT COUNT(*) FROM Articles)
	FROM	Articles
	

	WITH	Events AS (
		SELECT	Title = '',
				RowNumber = 0
		FROM	SysApp_v2_Calendars
		WHERE	1=0
		)
	SELECT	TOP 1 *,
			TotalRecords = (SELECT COUNT(*) FROM Events)
	FROM	Events
	

	WITH	Media AS (
		SELECT 	MGIL.vchTitle As Title,
				MGIL.vchCaption As Description,
				MGIL.vchAuthor,
				MGIL.vchPrimaryParameter,
				MGIL.vchSecondaryParameter,
				MGIL.bitSecondaryParameter,
				MGIL.unqMediaGalleryItemLocalizationId,
				MGI.intSortOrder,
				MGI.datItemDate,
				MT.vchMediaTypeName,
				MGL.vchMediaGalleryName,
				MG.intMaxItemsPerPage,
				URL = (
								SELECT	TOP 1 WP.vchFilename
								FROM	tblWebsitePages WP
								WHERE	WP.unqCustomerID = ?
								AND		WP.unqPageTypeId = 'a5ac8a7c-7023-499a-91b1-dfda5b5454cf'
								AND		WP.bitActive = 1
								AND		(WP.unqPhotoGalleryId = MGI.unqMediaGalleryId
								OR		WP.unqPhotoGalleryId IS NULL)
								ORDER BY WP.unqPhotoGalleryId 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)
		JOIN 	SysApp_v2_MediaTypes MT
			ON 	(MGI.unqMediaTypeId = MT.unqMediaTypeId)
		JOIN 	SysApp_v2_MediaGalleries MG
			ON 	(MGI.unqMediaGalleryId = MG.unqMediaGalleryId AND MG.unqCustomerID = ?)
		JOIN 	SysApp_v2_MediaGalleryLocalizations MGL
			ON 	(MG.unqMediaGalleryId = MGL.unqMediaGalleryId AND MGL.unqLanguageId = ?)
		WHERE 	1 = 1
		AND 	MGL.bitActive = ?
		AND 	MGIL.unqLanguageId = ? 
		)
	SELECT	TOP 1 *,
			TotalRecords = (SELECT COUNT(*) FROM Media)
	FROM	Media
	

	WITH	FAQs AS (
		SELECT	Title = '',
				RowNumber = 0
		FROM	SysApp_v2_Calendars
		WHERE	1=0
		)
	SELECT	TOP 1 *,
			TotalRecords = (SELECT COUNT(*) FROM FAQs)
	FROM	FAQs
	

	WITH	Pages AS (
		SELECT	ROW_NUMBER() OVER (ORDER BY R.vchResourceName) AS RowNumber,
				'library/' + R.vchResourceName AS URL,
				R.vchResourceTitle AS Title,
				R.vchFileName,
				R.vchCustomField1,
				R.vchCustomField2,
				R.vchCustomField3,
				R.vchCustomField4,
				R.vchCustomField5,
				R.vchCustomField6,
				R.vchCustomField7,
				R.vchCustomField8,
				R.vchCustomField9,
				R.vchCustomField10,
				vchDescription Description
		FROM	SysApp_v2_LibraryResources R
		-- LEFT OUTER JOIN 	SysApp_v2_LibraryResourceCategories LRC ON (R.unqResourceID = LRC.unqResourceID)
		-- LEFT OUTER JOIN 	SysApp_v2_LibraryCategories LC ON (LC.unqResourceCategoryID = LRC.unqResourceCategoryID)
		-- LEFT OUTER JOIN		SysApp_v2_LibraryCategoryGroups LCG ON (LC.unqResourceCategoryID = LCG.unqResourceCategoryID)
		WHERE	R.unqCustomerID = '3751BCB4-1301-4D3A-8B05-3EAB862C1CE0'
		-- AND		R.bitActive = 1
		-- AND		LCG.unqGroupID IS NULL
		
			)
	SELECT	TOP 1 *,
			TotalRecords = (SELECT COUNT(*) FROM Pages)
	FROM	Pages
	

	SELECT 	vchCustomFieldNames
	FROM	SysApp_v2_LibrarySettings
	WHERE	unqCustomerID = ? 

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\search.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=/search.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\search.cfm
QUERY_STRING=
REMOTE_ADDR=3.236.97.49
REMOTE_HOST=3.236.97.49
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/search.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=35821
cftoken=c372921423996a62-9B71A57C-AEEF-B3BC-B184089E0F954FE8
hitcount=1
lastvisit={ts '2020-07-07 07:00:13'}
timecreated={ts '2020-07-07 07:00:13'}
urltoken=CFID=35821&CFTOKEN=c372921423996a62-9B71A57C-AEEF-B3BC-B184089E0F954FE8

URL Parameters:
ACTION=Pages
PAGE=0
SEARCH=