Water Damage Repair Gallery

SELECT * FROM BizListingWebsiteSettings
	WHERE BIZLWS_RCS_DomainName = ?

SELECT * FROM BizListingWebsiteSettings2
        WHERE BIZLWS2_BIZLWS_ID = ?

SELECT TOP 1 * FROM BizListingWebsiteFrameworks
            WHERE id = 1

SELECT     dbo.BizListingAppStore.bizAppStore_Title, dbo.BizListingApps.bizApps_AppStore_App_ID
    FROM         dbo.BizListingApps INNER JOIN
                          dbo.BizListingAppStore ON dbo.BizListingApps.bizApps_AppStore_App_ID = dbo.BizListingAppStore.bizAppStore_App_ID
    WHERE	bizApps_BIZLWS_ID = ?
    AND 	bizApps_activated = 1

SELECT  *
        FROM    BizCustomerPermissions
        WHERE   bizlws_id = 2177
        AND     seo_url = '*'

SELECT *
        FROM BizCustomerPermissions 
        WHERE bizlws_id = 2177 
        AND (seo_url = ? 
            )

SELECT * FROM BizListing
        WHERE BIZL_ID = ?

SELECT * FROM State
        WHERE StateID = ?

SELECT * FROM Country
        WHERE CountryID = ?

SELECT county_name FROM County
        WHERE County_ID = ?

SELECT *
    FROM customTag
    WHERE bizlws_id = 2177
    AND category = 'global'
    ORDER BY name

SELECT *
    FROM customTag
    WHERE bizlws_id = 2177
    AND category = 'scripts'
    AND (     position <> 'beginning of file' 
    	  AND position <> 'end of file'
        )
    ORDER BY name

SELECT * FROM BizListingTemplateButtons
        WHERE BIZLTBUT_ID = ?

SELECT companyid, unsecurepage, domainname, companyname, PICTUREDIR
    FROM MyCompanyInformation2View
	Where companyid = ?

SELECT     id, BIZLWS_ID, url, redirect, type
        FROM         Biz301Redirects
        WHERE     (BIZLWS_ID = 2177)
        AND (
        	url = ? 
	        OR 
            url = ? 
        )

SELECT     *, '/' + seoURL_type + '/' + seoURL_output_string AS url
            FROM         dbo.BizListingUnlimitedPages LEFT OUTER JOIN
                                  dbo.seoURLs ON dbo.BizListingUnlimitedPages.BIZ_UNL_ID = dbo.seoURLs.seoURL_input_id
            WHERE     (dbo.seoURLs.seoURL_type = 'page')
            AND		seoURL_BIZLWS_ID = 2177
            AND     seoURL_output_string = ?

SELECT     *, '/' + seoURL_type + '/' + seoURL_output_string AS url
            FROM         dbo.BizListingUnlimitedPages LEFT OUTER JOIN
                                dbo.seoURLs ON dbo.BizListingUnlimitedPages.BIZ_UNL_ID = dbo.seoURLs.seoURL_input_id
            WHERE     (dbo.seoURLs.seoURL_type = 'page')
            AND		seoURL_BIZLWS_ID = 2177
            AND     seoURL_output_string = ?

SELECT  *
				FROM customSearch
				WHERE seo_url = ?
				AND bizlws_id = 2177

SELECT *
						FROM         dbo.customSearchPage LEFT OUTER JOIN
								  dbo.customSearchPicture ON dbo.customSearchPage.id = dbo.customSearchPicture.customSearchPageId
						WHERE bizlws_id = 2177 
						AND customSearchId = 2380
						AND seo_url = ?
						AND dbo.customSearchPage.active = 1
						AND (mainPicture = 1 OR mainPicture IS NULL)

SELECT *
            FROM         dbo.customSearchPage LEFT OUTER JOIN
                      dbo.customSearchPicture ON dbo.customSearchPage.id = dbo.customSearchPicture.customSearchPageId
            WHERE bizlws_id = 2177 
            AND customSearchId = 2380
            AND seo_url = ?
            AND dbo.customSearchPage.active = 1
            AND (mainPicture = 1 OR mainPicture IS NULL)

SELECT     *,
                          LEAD(customSearchPage.seo_url) OVER (ORDER BY customSearchPage.name ) NextPage, 
                          LAG(customSearchPage.seo_url) OVER (ORDER BY customSearchPage.name ) PreviousPage,
                          LEAD(customSearchPage.id) OVER (ORDER BY customSearchPage.name ) NextPageId, 
                          LAG(customSearchPage.id) OVER (ORDER BY customSearchPage.name ) PreviousPageId
            FROM         customSearchPage LEFT OUTER JOIN
                                  customSearchPicture ON customSearchPage.id = customSearchPicture.customSearchPageId
            WHERE  customSearchId = 1214
            AND dbo.customSearchPage.active = 1
            AND (mainPicture = 1 OR mainPicture IS NULL)
            
            AND bizlws_id = 2177 
            
            ORDER BY customSearchPage.name

SELECT * 
            FROM getPagingPages
            WHERE NextPageId = 40947 
            OR PreviousPageId = 40947
            ORDER BY name

SELECT *
        FROM  customSearchPicture
        WHERE customSearchPageId = 40947
        AND active = 1
        ORDER BY sortOrder, id desc

SELECT *
        FROM customTag
        WHERE bizlws_id = ?
        AND tag <> ''
        AND tag IS NOT NULL
        AND (
        	category = 'snippet'
        	OR category = 'form'
        	OR category = 'template'
        )

SELECT *
		FROM customTag
		WHERE bizlws_id = ?
        AND tag IN (
        	
                'headerTag' 
        )
		ORDER BY CASE 
			
                WHEN tag = 'headerTag' THEN 1 
			ELSE 2 
		END

SELECT top 2 *
            FROM      seoURLsView
            WHERE    BIZ_UNL_Active = 1   
            
            AND BIZ_UNL_BIZL_ID = 12475
            AND (seoURL_type = 'page')

SELECT *
		FROM customTag
		WHERE bizlws_id = ?
        AND tag IN (
        	
                'mobilesidebar' 
        )
		ORDER BY CASE 
			
                WHEN tag = 'mobilesidebar' THEN 1 
			ELSE 2 
		END

SELECT *
		FROM customTag
		WHERE bizlws_id = ?
        AND tag IN (
        	
                'menu' 
        )
		ORDER BY CASE 
			
                WHEN tag = 'menu' THEN 1 
			ELSE 2 
		END

SELECT *
			FROM customTag
			WHERE bizlws_id = 2177
			AND tag = 'fancyGallery'

SELECT *
    FROM BizCustomerSettings
    WHERE bizlws_id = 2177

SELECT * FROM BizListingWebsiteMenu
	Where BIZLWM_BIZLWS_ID  = 2177
	and BIZLWM_BottomActive = 1
	and BIZLWM_BottomMenu = 1 
	Order by BIZLWM_BottomSort, BIZLWM_BIZLTM_Name

SELECT * FROM BizListingWebsiteMenuP7PMM
        WHERE BIZLWM_p7pmm_Menu = 3
        AND BIZLWM_p7pmm_BIZLWS_ID = ?

SELECT *
		FROM customTag
		WHERE bizlws_id = ?
        AND tag IN (
        	
                'footer' 
        )
		ORDER BY CASE 
			
                WHEN tag = 'footer' THEN 1 
			ELSE 2 
		END

Application Variables:
applicationname=www.jrcconline.com
configured=1
currentsessions=0
datetimeconfigured=02:54 AM  01.10.2024
serverip=172.16.1.2

CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=256
CERT_SECRETKEYSIZE=4096
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=C=US, O=Let's Encrypt, CN=R3
CERT_SERVER_SUBJECT=CN=www.jrcconline.com
CERT_SUBJECT=
CF_TEMPLATE_PATH=D:\Inetpub\vhosts\jrcconline.com\httpdocs\rewrite.cfm
CONTENT_LENGTH=0
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=on
HTTPS_KEYSIZE=256
HTTPS_SECRETKEYSIZE=4096
HTTPS_SERVER_ISSUER=C=US, O=Let's Encrypt, CN=R3
HTTPS_SERVER_SUBJECT=CN=www.jrcconline.com
HTTP_ACCEPT=text/html,*/*;q=0.8
HTTP_ACCEPT_ENCODING=gzip, deflate, br
HTTP_ACCEPT_LANGUAGE=en-US,en;q=0.9
HTTP_CONNECTION=close
HTTP_COOKIE=CFGLOBALS=urltoken%3DCFID%23%3D96381057%26CFTOKEN%23%3D2742695928f0c8e8%2D2DF9FFAC%2DB0E8%2DE9EE%2DE95D970FA1E920B9%26jsessionid%23%3D5E5EDE3E5914AEAD65A7801F14039EF9%2Ecfusion%23lastvisit%3D%7Bts%20%272024%2D02%2D12%2010%3A45%3A31%27%7D%23hitcount%3D372%23timecreated%3D%7Bts%20%272024%2D02%2D12%2010%3A44%3A29%27%7D%23cftoken%3D2742695928f0c8e8%2D2DF9FFAC%2DB0E8%2DE9EE%2DE95D970FA1E920B9%23cfid%3D96381057%23; CFID=Z18jx3w7gsjb8wfwswi09506byr1rkwqazncjndaavimxbl31hb-96381057; CFTOKEN=Z18jx3w7gsjb8wfwswi09506byr1rkwqazncjndaavimxbl31hb-2742695928f0c8e8-2DF9FFAC-B0E8-E9EE-E95D970FA1E920B9; JSESSIONID=5E5EDE3E5914AEAD65A7801F14039EF9.cfusion
HTTP_HOST=www.jrcconline.com
HTTP_REFERER=https://www.jrcconline.com/page/photo-gallery
HTTP_URL=/rewrite.cfm/photo-gallery/water-damage-repair
HTTP_USER_AGENT=SiteSucker for macOS/5.3
LOCAL_ADDR=172.16.1.2
PATH_INFO=/photo-gallery/water-damage-repair
PATH_TRANSLATED=D:\Inetpub\vhosts\jrcconline.com\httpdocs\rewrite.cfm
QUERY_STRING=
REMOTE_ADDR=147.219.19.36
REMOTE_HOST=147.219.19.36
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/rewrite.cfm
SERVER_NAME=www.jrcconline.com
SERVER_PORT=443
SERVER_PORT_SECURE=1
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/10.0
WEB_SERVER_API=

Client Variables:
cfid=96381057
cftoken=2742695928f0c8e8-2DF9FFAC-B0E8-E9EE-E95D970FA1E920B9
hitcount=376
lastvisit={ts '2024-02-12 10:45:32'}
timecreated={ts '2024-02-12 10:44:29'}
urltoken=CFID=96381057&CFTOKEN=2742695928f0c8e8-2DF9FFAC-B0E8-E9EE-E95D970FA1E920B9&jsessionid=5E5EDE3E5914AEAD65A7801F14039EF9.cfusion

Cookie Variables:
CFGLOBALS=urltoken=CFID#=96381057&CFTOKEN#=2742695928f0c8e8-2DF9FFAC-B0E8-E9EE-E95D970FA1E920B9&jsessionid#=5E5EDE3E5914AEAD65A7801F14039EF9.cfusion#lastvisit={ts '2024-02-12 10:45:31'}#hitcount=372#timecreated={ts '2024-02-12 10:44:29'}#cftoken=2742695928f0c8e8-2DF9FFAC-B0E8-E9EE-E95D970FA1E920B9#cfid=96381057#
CFID=96381057
CFTOKEN=2742695928f0c8e8-2DF9FFAC-B0E8-E9EE-E95D970FA1E920B9
JSESSIONID=5E5EDE3E5914AEAD65A7801F14039EF9.cfusion

Form Fields:
fieldnames=

Request Parameters:
samesite_value=

Session Variables:
customsearch=0
errormsg=
flash=Struct (0)
loginattempt=0
mobileview=1
params=Array (0)
params2=Array (0)
registeredcustomer=Struct (2)
searchstring=Array (1)
sessionid=5E5EDE3E5914AEAD65A7801F14039EF9.cfusion
urltoken=CFID=96381057&CFTOKEN=2742695928f0c8e8-2DF9FFAC-B0E8-E9EE-E95D970FA1E920B9&jsessionid=5E5EDE3E5914AEAD65A7801F14039EF9.cfusion

URL Parameters:
CP=photo-gallery
CPID=water-damage-repair
MOBILEVIEW=1