Welcome — We Are Boson

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

SELECT *
    FROM customTag
    WHERE bizlws_id = 1612
    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     BIZLWM_BIZLTM_Name AS Title
FROM         BizListingWebsiteMenu
WHERE     (BIZLWM_BIZLWS_ID = 1612) AND (BIZLWM_TopActive = 1) AND (BIZLWM_TopMenu = 1) AND (BIZLWM_BIZLTM_FileName = 'webpages.cfm')

SELECT	* FROM	BizListingUnlimitedPages
		WHERE	BIZ_UNL_ID = ?
        AND     BIZ_UNL_BIZL_ID = 706

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		BIZ_UNL_ID = 105840

SELECT	* FROM	BizListingUnlimitedPagesPDFs
		WHERE	BIZ_UNL_PDF_BIZ_UNL_ID = ?

SELECT * FROM BizListingUnlimitedPagesSettings
    WHERE	BIZ_UNLSettings_BIZLWS_ID = ?

SELECT	*
        FROM	BizListingUnlimitedPages
        WHERE BIZ_UNL_ID = ?
        
        
        AND   BIZ_UNL_BIZL_ID = 706
        ORDER BY BIZ_UNL_Title, BIZ_UNL_Name

SELECT    *
	FROM      seoURLsView
    WHERE     (parent_id = ?) 
    AND (seoURL_type = 'page')
    AND BIZ_UNL_BIZL_ID = 706
    AND BIZ_UNL_SLCP_ID = 0
    
    ORDER BY BIZ_UNL_Sort, BIZ_UNL_Name

SELECT	* FROM	BizListingUnlimitedPagesPhotos
    WHERE	BIZ_UNL_PHO_BIZ_UNL_ID = ?
    ORDER BY BIZ_UNL_PHO_Sort_Order

SELECT *
        FROM customTag
        WHERE id = ?

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 runAsHTML = 0
        AND tag IN (
        	
				'header', 
				'homepage', 
				'footer' 
        )
		ORDER BY CASE 
			
				WHEN tag = 'header' THEN 1 
				WHEN tag = 'homepage' THEN 2 
				WHEN tag = 'footer' THEN 3 
			ELSE 4 
		END

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

SELECT    *
	FROM      seoURLsView
    WHERE     (parent_id = ?) 
    AND (seoURL_type = 'page')
    AND BIZ_UNL_BIZL_ID = 706
    AND BIZ_UNL_SLCP_ID = 0
    
    ORDER BY BIZ_UNL_Sort, BIZ_UNL_Name

SELECT *
		FROM getChildren
		WHERE BIZ_UNL_FeaturedPic <> '' AND BIZ_UNL_FeaturedPic IS NOT NULL

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

SELECT *
		FROM customTag
		WHERE bizlws_id = ?
        AND tag IN (
        	
                'headerTag' 
        )
		ORDER BY CASE 
			
                WHEN tag = 'headerTag' THEN 1 
			ELSE 2 
		END
		
		
			-- ran inside of [homepage]

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

SELECT * FROM BizListingUnlimitedPages
	WHERE  BIZ_UNL_BIZL_ID = ?
	AND BIZ_UNL_MCI_ID = ?
    AND (BIZ_UNL_SLCP_ID = 0)
	ORDER BY BIZ_UNL_Sort, BIZ_UNL_Name

SELECT     TOP (1000) *
            FROM         seoURLsView
            WHERE     (BIZ_UNL_BIZL_ID = ?) 
            AND (BIZ_UNL_Active = 1)
            AND 	seoURL_BIZLWS_ID = 1612
            AND (BIZ_UNL_SLCP_ID = 0)
            ORDER BY BIZ_UNL_Sort, BIZ_UNL_Name

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

Application Variables:
applicationname=www.bosonco.com
configured=1
currentsessions=0
datetimeconfigured=03:05 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.bosonco.com
CERT_SUBJECT=
CF_TEMPLATE_PATH=D:\Inetpub\vhosts\bosonco.com\httpdocs\home.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.bosonco.com
HTTP_ACCEPT=*/*
HTTP_ACCEPT_ENCODING=gzip, br
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=close
HTTP_COOKIE=
HTTP_HOST=www.bosonco.com
HTTP_REFERER=https://www.bosonco.com/kcd/spray-in-bedliners/wisconsin/eau-claire-county
HTTP_URL=/home.cfm?404=
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=
PATH_TRANSLATED=D:\Inetpub\vhosts\bosonco.com\httpdocs\home.cfm
QUERY_STRING=404=
REMOTE_ADDR=172.70.130.226
REMOTE_HOST=172.70.130.226
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/home.cfm
SERVER_NAME=www.bosonco.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=100917420
cftoken=c04706045821ef5e-8E39BF11-99D3-AC36-2F78F18F7B9E1A67
hitcount=1
lastvisit={ts '2024-04-18 23:31:45'}
timecreated={ts '2024-04-18 23:31:45'}
urltoken=CFID=100917420&CFTOKEN=c04706045821ef5e-8E39BF11-99D3-AC36-2F78F18F7B9E1A67&jsessionid=C3A8CBA368190C2341A8A7D5E30CECEB.cfusion

Cookie Variables:
CFID=100917420
CFTOKEN=c04706045821ef5e-8E39BF11-99D3-AC36-2F78F18F7B9E1A67

Form Fields:
fieldnames=

Request Parameters:
samesite_value=

Session Variables:
errormsg=
loginattempt=0
mobileview=1
registeredcustomer=Struct (2)
sessionid=C3A8CBA368190C2341A8A7D5E30CECEB.cfusion
urltoken=CFID=100917420&CFTOKEN=c04706045821ef5e-8E39BF11-99D3-AC36-2F78F18F7B9E1A67&jsessionid=C3A8CBA368190C2341A8A7D5E30CECEB.cfusion

URL Parameters:
404=