SELECT * FROM BizListingWebsiteSettings
	WHERE BIZLWS_RCS_DomainName = ?

SELECT * FROM BizListingWebsiteSettings2
        WHERE BIZLWS2_BIZLWS_ID = ?

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 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 = 2132
    AND category = 'global'
    ORDER BY name

SELECT *
    FROM customTag
    WHERE bizlws_id = 2132
    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 = 2132)
        AND (
        	url = ? 
	        OR 
            url = ? 
        )

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
    AND     bizApps_AppStore_App_ID = ?

SELECT * FROM SEO_KCD
    WHERE SEO_KCD_BIZLWS_ID = ?
    AND SEO_KCD_Keyword_Phrase = ?

SELECT * FROM SEO_ADWORDS
	WHERE 
      
    	SEO_ADWORDS_SEO_KCD_ID = ?

SELECT * FROM getSeoTargetArea
    WHERE 
    
      
	    SEOC_SEO_KCD_ID = 4518 
    
    AND State = ? 
    AND county_name = ? 
    ORDER BY county_name

SELECT *
    FROM         getSettlements
    WHERE     
    
      
	    (SEO_KCD_ID = 4518) 
	    
    AND (settlement_name = ?)
    AND (settlement_type = ?)
    AND (stateID = 49) AND county_ID = 140

SELECT    COUNT(*) as duplicates
        FROM      getKcdArea 
        WHERE     (State = ?) 
        AND       (settlement_Name like ?)
        AND       (SEO_KCD_ID = 4518)

SELECT    TOP 1 SEO_KCD_ID, BIZLWS_ID, Keyword_Phrase, State, county_name, settlement_Type, settlement_Name, phrase
            FROM      getKcdArea 
            WHERE     (State = ?) 
            AND       (settlement_Name like ?)
            AND       (SEO_KCD_ID = 4518)
            ORDER BY settlement_name

SELECT     TOP (200) SEO_ADWORDS_ID, SEO_ADWORDS_SEO_KCD_ID, SEO_ADWORDS_Keyword_Phrase
	FROM         SEO_ADWORDS
	WHERE     (SEO_ADWORDS_SEO_KCD_ID = 4518)

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 = 9855
            AND (seoURL_type = 'page')

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

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

SELECT     BIZLWM_ID, BIZLWM_BIZLTM_Name, BIZLWM_BIZLTM_FileName, BIZLWM_TopMenu_Target, BIZLWM_TopSort, BIZLWM_TopIndent,  
    		   lead(BIZLWM_TopIndent, 1, 0) OVER (ORDER BY BIZLWM_TopSort, BIZLWM_BIZLTM_Name) AS nextItem
    FROM         BizListingWebsiteMenu
	Where BIZLWM_BIZLWS_ID  = 2132
	and BIZLWM_TopActive = 1
	and BIZLWM_TopMenu = 1 
	Order by BIZLWM_TopSort, BIZLWM_BIZLTM_Name

SELECT BIZLWS2_bootstrapMenuWDDX FROM BizListingWebsiteSettings2
    WHERE BIZLWS2_BIZLWS_ID = 2132

SELECT * FROM SEO_KCD
    WHERE SEO_KCD_BIZLWS_ID = ?
    AND SEO_KCD_Adword_App = 1

SELECT * FROM SEO_ADWORDS
	WHERE 
      
    	SEO_ADWORDS_SEO_KCD_ID = ?

SELECT SEO_KCD_ID FROM getKcdState
    WHERE BIZLWS_ID = ?
    AND Keyword_Phrase = ?

SELECT SEO_KCD_ID FROM getKcdCounty
    WHERE BIZLWS_ID = ?
    AND Keyword_Phrase = ?

SELECT SEO_KCD_ID FROM getKcdArea
    WHERE BIZLWS_ID = ?
    AND Keyword_Phrase = ?

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

SELECT * FROM BizListingWebsiteMenu
	Where BIZLWM_BIZLWS_ID  = 2132
	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 = ?

Application Variables:
applicationname=www.stoneinnovations.net
configured=1
currentsessions=0
datetimeconfigured=02:56 AM  04.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.stoneinnovations.net
CERT_SUBJECT=
CF_TEMPLATE_PATH=D:\Inetpub\vhosts\stoneinnovations.net\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.stoneinnovations.net
HTTP_ACCEPT=*/*
HTTP_ACCEPT_ENCODING=gzip, br
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=close
HTTP_COOKIE=
HTTP_HOST=www.stoneinnovations.net
HTTP_REFERER=
HTTP_URL=/rewrite.cfm/top-phrases/cambria-countertops/cambria-countertops/wisconsin/dane-county/town-of-montrose
HTTP_USER_AGENT=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; [email protected])
LOCAL_ADDR=172.16.1.2
PATH_INFO=/top-phrases/cambria-countertops/cambria-countertops/wisconsin/dane-county/town-of-montrose
PATH_TRANSLATED=D:\Inetpub\vhosts\stoneinnovations.net\httpdocs\rewrite.cfm
QUERY_STRING=
REMOTE_ADDR=172.70.130.226
REMOTE_HOST=172.70.130.226
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/rewrite.cfm
SERVER_NAME=www.stoneinnovations.net
SERVER_PORT=443
SERVER_PORT_SECURE=1
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/10.0
WEB_SERVER_API=

Client Variables:
cfid=100949882
cftoken=2b7b53fa672bddca-9BD2EEB7-D370-B1C8-13DB04CBC2E91288
hitcount=1
lastvisit={ts '2024-04-19 05:52:01'}
timecreated={ts '2024-04-19 05:52:01'}
urltoken=CFID=100949882&CFTOKEN=2b7b53fa672bddca-9BD2EEB7-D370-B1C8-13DB04CBC2E91288&jsessionid=0D138628E90BCF20919C325FB6B3909F.cfusion

Cookie Variables:
CFID=100949882
CFTOKEN=2b7b53fa672bddca-9BD2EEB7-D370-B1C8-13DB04CBC2E91288

Form Fields:
fieldnames=

Request Parameters:
samesite_value=

Session Variables:
errormsg=
loginattempt=0
mobileview=1
registeredcustomer=Struct (2)
sessionid=0D138628E90BCF20919C325FB6B3909F.cfusion
urltoken=CFID=100949882&CFTOKEN=2b7b53fa672bddca-9BD2EEB7-D370-B1C8-13DB04CBC2E91288&jsessionid=0D138628E90BCF20919C325FB6B3909F.cfusion

URL Parameters:
MOBILEVIEW=1
adword=cambria-countertops
area=montrose
county=dane-county
state=wisconsin
target=cambria-countertops
type=town