Auto Repair, Tires, Brakes and Oil Changes
Weston, Wausau, Green Bay, Appleton, Neenah, Shawano and Stevens Point Locations!

SELECT * FROM BizListingWebsiteSettings
	WHERE BIZLWS_RCS_DomainName = ?

SELECT * FROM BizListingWebsiteSettings
        WHERE BIZLWS_RCS_DomainName = ?
        AND BIZLWS_RCS_CNAME = ?

SELECT * FROM BizListingWebsiteSettings2
        WHERE BIZLWS2_BIZLWS_ID = ?

SELECT TOP 1 * FROM BizListingWebsiteFrameworks
            WHERE id = 5

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

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

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

SELECT *
		FROM customTag
		WHERE bizlws_id = ?
        AND tag IN (
        	
                'socIcons', 
                'company', 
                'navbar' 
        )
		ORDER BY CASE 
			
                WHEN tag = 'socIcons' THEN 1 
                WHEN tag = 'company' THEN 2 
                WHEN tag = 'navbar' THEN 3 
			ELSE 4 
		END

SELECT *
		FROM customTag
		WHERE bizlws_id = ?
        AND tag IN (
        	
                'company', 
                'LLflip', 
                'couponsCarousel', 
                'videoModal', 
                'recentNews' 
        )
		ORDER BY CASE 
			
                WHEN tag = 'company' THEN 1 
                WHEN tag = 'LLflip' THEN 2 
                WHEN tag = 'couponsCarousel' THEN 3 
                WHEN tag = 'videoModal' THEN 4 
                WHEN tag = 'recentNews' THEN 5 
			ELSE 6 
		END

SELECT   *
        FROM customSearch
        WHERE bizlws_id = 1604 
        AND name = ?

SELECT TOP 100 PERCENT *
            
            FROM         dbo.customSearchPage LEFT OUTER JOIN
                      dbo.customSearchPicture ON dbo.customSearchPage.id = dbo.customSearchPicture.customSearchPageId
            WHERE bizlws_id = 1604 
            AND customSearchId = 2134 
            AND dbo.customSearchPage.active = 1
            
            AND (mainPicture = 1 OR mainPicture IS NULL)
            
            
                AND CAST(value1 AS DATETIME) >= '2024/04/19'
            
            ORDER BY 
            
            
            
                dbo.customSearchPage.name

SELECT TOP 3  *
            FROM         (
                SELECT *
                FROM BizNews
                WHERE     (dbo.BizNews.BIZ_NEWS_BIZL_ID = ?)
                AND (dbo.BizNews.BIZ_NEWS_Active = 1)
                AND (dbo.BizNews.BIZ_NEWS_PostedDate <= { fn NOW() })
            
            ) BizNews LEFT OUTER JOIN
                        dbo.seoURLs ON BizNews.BIZ_NEWS_ID = dbo.seoURLs.seoURL_input_id
            WHERE 

            
                (dbo.seoURLs.seoURL_type = 'article') 
            
            ORDER BY BIZ_NEWS_PostedDate DESC
            -- hasPageTopic 
            -- pageIdsList

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

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

SELECT *
        FROM customTag 
        WHERE bizlws_id = 1604
        AND tag = ?

SELECT   *
        FROM customSearch
        WHERE bizlws_id = 1604 
        AND name = ?

SELECT TOP 100 PERCENT *
            
            FROM         dbo.customSearchPage LEFT OUTER JOIN
                      dbo.customSearchPicture ON dbo.customSearchPage.id = dbo.customSearchPicture.customSearchPageId
            WHERE bizlws_id = 1604 
            AND customSearchId = 2124 
            AND dbo.customSearchPage.active = 1
            
            AND (mainPicture = 1 OR mainPicture IS NULL)
            
            
            ORDER BY 
            
            
            
                dbo.customSearchPage.name

SELECT *
        FROM customTag 
        WHERE bizlws_id = 1604
        AND tag = ?

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

Application Variables:
applicationname=www.autoselectonline.com
configured=1
currentsessions=0
datetimeconfigured=02:55 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=2048
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=C=US, O=Let's Encrypt, CN=R3
CERT_SERVER_SUBJECT=CN=www.autoselectonline.com
CERT_SUBJECT=
CF_TEMPLATE_PATH=D:\Inetpub\vhosts\autoselectonline.com\httpdocs\rewrite.cfm
CONTENT_LENGTH=0
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=on
HTTPS_KEYSIZE=256
HTTPS_SECRETKEYSIZE=2048
HTTPS_SERVER_ISSUER=C=US, O=Let's Encrypt, CN=R3
HTTPS_SERVER_SUBJECT=CN=www.autoselectonline.com
HTTP_ACCEPT=*/*
HTTP_ACCEPT_ENCODING=gzip, br
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=close
HTTP_COOKIE=
HTTP_HOST=www.autoselectonline.com
HTTP_REFERER=http://www.autoselectonline.com/
HTTP_URL=/rewrite.cfm/
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\autoselectonline.com\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.autoselectonline.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=100953152
cftoken=7fb1a4d208a60807-9D107945-9ACD-4F92-E2891E212C4B4153
hitcount=1
lastvisit={ts '2024-04-19 06:26:42'}
timecreated={ts '2024-04-19 06:26:42'}
urltoken=CFID=100953152&CFTOKEN=7fb1a4d208a60807-9D107945-9ACD-4F92-E2891E212C4B4153&jsessionid=0E25120324BA73E2634786667364D7B5.cfusion

Cookie Variables:
CFID=100953152
CFTOKEN=7fb1a4d208a60807-9D107945-9ACD-4F92-E2891E212C4B4153

Form Fields:
fieldnames=

Request Parameters:
samesite_value=

Session Variables:
errormsg=
loginattempt=0
mobileview=1
registeredcustomer=Struct (2)
sessionid=0E25120324BA73E2634786667364D7B5.cfusion
urltoken=CFID=100953152&CFTOKEN=7fb1a4d208a60807-9D107945-9ACD-4F92-E2891E212C4B4153&jsessionid=0E25120324BA73E2634786667364D7B5.cfusion

URL Parameters:
MOBILEVIEW=1