Carpet Cleaning Technician

SELECT * FROM BizListingWebsiteSettings
	WHERE BIZLWS_RCS_DomainName = ?

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

SELECT *
    FROM customTag
    WHERE bizlws_id = 2441
    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 = 2441)
        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 = 2441
            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 = 2441
            AND     seoURL_output_string = ?

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

SELECT *
						FROM         dbo.customSearchPage LEFT OUTER JOIN
								  dbo.customSearchPicture ON dbo.customSearchPage.id = dbo.customSearchPicture.customSearchPageId
						WHERE bizlws_id = 2441 
						AND customSearchId = 3831
						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 = 2441 
            AND customSearchId = 3831
            AND seo_url = ?
            AND dbo.customSearchPage.active = 1
            AND (mainPicture = 1 OR mainPicture IS NULL)

SELECT *
        FROM  customSearchPicture
        WHERE customSearchPageId = 72528
        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 = 15171
            AND (seoURL_type = 'page')

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

SELECT     *, BIZLWM_BIZLTM_Name as Name, BIZLWM_BIZLTM_FileName as URL
        FROM         BizListingWebsiteMenu
        WHERE     (BIZLWM_BIZLWS_ID = 2441) 
        
        	AND parent_id = 0 
            AND (BIZLWM_TopActive = 1) AND (BIZLWM_TopMenu = 1)
            ORDER BY BIZLWM_TopSort, BIZLWM_BIZLTM_Name

SELECT     *, BIZLWM_BIZLTM_Name as Name, BIZLWM_BIZLTM_FileName as URL
        FROM         BizListingWebsiteMenu
        WHERE     (BIZLWM_BIZLWS_ID = 2441) 
        
        	AND parent_id = 64274 
            AND (BIZLWM_TopActive = 1) AND (BIZLWM_TopMenu = 1)
            ORDER BY BIZLWM_TopSort, BIZLWM_BIZLTM_Name

SELECT     *, BIZLWM_BIZLTM_Name as Name, BIZLWM_BIZLTM_FileName as URL
        FROM         BizListingWebsiteMenu
        WHERE     (BIZLWM_BIZLWS_ID = 2441) 
        
        	AND parent_id = 64275 
            AND (BIZLWM_TopActive = 1) AND (BIZLWM_TopMenu = 1)
            ORDER BY BIZLWM_TopSort, BIZLWM_BIZLTM_Name

SELECT     *, BIZLWM_BIZLTM_Name as Name, BIZLWM_BIZLTM_FileName as URL
        FROM         BizListingWebsiteMenu
        WHERE     (BIZLWM_BIZLWS_ID = 2441) 
        
        	AND parent_id = 76334 
            AND (BIZLWM_TopActive = 1) AND (BIZLWM_TopMenu = 1)
            ORDER BY BIZLWM_TopSort, BIZLWM_BIZLTM_Name

SELECT     *, BIZLWM_BIZLTM_Name as Name, BIZLWM_BIZLTM_FileName as URL
        FROM         BizListingWebsiteMenu
        WHERE     (BIZLWM_BIZLWS_ID = 2441) 
        
        	AND parent_id = 76332 
            AND (BIZLWM_TopActive = 1) AND (BIZLWM_TopMenu = 1)
            ORDER BY BIZLWM_TopSort, BIZLWM_BIZLTM_Name

SELECT     *, BIZLWM_BIZLTM_Name as Name, BIZLWM_BIZLTM_FileName as URL
        FROM         BizListingWebsiteMenu
        WHERE     (BIZLWM_BIZLWS_ID = 2441) 
        
        	AND parent_id = 76333 
            AND (BIZLWM_TopActive = 1) AND (BIZLWM_TopMenu = 1)
            ORDER BY BIZLWM_TopSort, BIZLWM_BIZLTM_Name

SELECT     *, BIZLWM_BIZLTM_Name as Name, BIZLWM_BIZLTM_FileName as URL
        FROM         BizListingWebsiteMenu
        WHERE     (BIZLWM_BIZLWS_ID = 2441) 
        
        	AND parent_id = 78234 
            AND (BIZLWM_TopActive = 1) AND (BIZLWM_TopMenu = 1)
            ORDER BY BIZLWM_TopSort, BIZLWM_BIZLTM_Name

SELECT     *, BIZLWM_BIZLTM_Name as Name, BIZLWM_BIZLTM_FileName as URL
        FROM         BizListingWebsiteMenu
        WHERE     (BIZLWM_BIZLWS_ID = 2441) 
        
        	AND parent_id = 78723 
            AND (BIZLWM_TopActive = 1) AND (BIZLWM_TopMenu = 1)
            ORDER BY BIZLWM_TopSort, BIZLWM_BIZLTM_Name

SELECT     *, BIZLWM_BIZLTM_Name as Name, BIZLWM_BIZLTM_FileName as URL
        FROM         BizListingWebsiteMenu
        WHERE     (BIZLWM_BIZLWS_ID = 2441) 
        
        	AND parent_id = 64281 
            AND (BIZLWM_TopActive = 1) AND (BIZLWM_TopMenu = 1)
            ORDER BY BIZLWM_TopSort, BIZLWM_BIZLTM_Name

SELECT     *, BIZLWM_BIZLTM_Name as Name, BIZLWM_BIZLTM_FileName as URL
        FROM         BizListingWebsiteMenu
        WHERE     (BIZLWM_BIZLWS_ID = 2441) 
        
        	AND parent_id = 64282 
            AND (BIZLWM_TopActive = 1) AND (BIZLWM_TopMenu = 1)
            ORDER BY BIZLWM_TopSort, BIZLWM_BIZLTM_Name

SELECT     *, BIZLWM_BIZLTM_Name as Name, BIZLWM_BIZLTM_FileName as URL
        FROM         BizListingWebsiteMenu
        WHERE     (BIZLWM_BIZLWS_ID = 2441) 
        
        	AND parent_id = 64283 
            AND (BIZLWM_TopActive = 1) AND (BIZLWM_TopMenu = 1)
            ORDER BY BIZLWM_TopSort, BIZLWM_BIZLTM_Name

SELECT     *, BIZLWM_BIZLTM_Name as Name, BIZLWM_BIZLTM_FileName as URL
        FROM         BizListingWebsiteMenu
        WHERE     (BIZLWM_BIZLWS_ID = 2441) 
        
        	AND parent_id = 64284 
            AND (BIZLWM_TopActive = 1) AND (BIZLWM_TopMenu = 1)
            ORDER BY BIZLWM_TopSort, BIZLWM_BIZLTM_Name

SELECT     *, BIZLWM_BIZLTM_Name as Name, BIZLWM_BIZLTM_FileName as URL
        FROM         BizListingWebsiteMenu
        WHERE     (BIZLWM_BIZLWS_ID = 2441) 
        
        	AND parent_id = 64285 
            AND (BIZLWM_TopActive = 1) AND (BIZLWM_TopMenu = 1)
            ORDER BY BIZLWM_TopSort, BIZLWM_BIZLTM_Name

SELECT     *, BIZLWM_BIZLTM_Name as Name, BIZLWM_BIZLTM_FileName as URL
        FROM         BizListingWebsiteMenu
        WHERE     (BIZLWM_BIZLWS_ID = 2441) 
        
        	AND parent_id = 64286 
            AND (BIZLWM_TopActive = 1) AND (BIZLWM_TopMenu = 1)
            ORDER BY BIZLWM_TopSort, BIZLWM_BIZLTM_Name

SELECT     *, BIZLWM_BIZLTM_Name as Name, BIZLWM_BIZLTM_FileName as URL
        FROM         BizListingWebsiteMenu
        WHERE     (BIZLWM_BIZLWS_ID = 2441) 
        
        	AND parent_id = 64287 
            AND (BIZLWM_TopActive = 1) AND (BIZLWM_TopMenu = 1)
            ORDER BY BIZLWM_TopSort, BIZLWM_BIZLTM_Name

SELECT     *, BIZLWM_BIZLTM_Name as Name, BIZLWM_BIZLTM_FileName as URL
        FROM         BizListingWebsiteMenu
        WHERE     (BIZLWM_BIZLWS_ID = 2441) 
        
        	AND parent_id = 64288 
            AND (BIZLWM_TopActive = 1) AND (BIZLWM_TopMenu = 1)
            ORDER BY BIZLWM_TopSort, BIZLWM_BIZLTM_Name

SELECT     *, BIZLWM_BIZLTM_Name as Name, BIZLWM_BIZLTM_FileName as URL
        FROM         BizListingWebsiteMenu
        WHERE     (BIZLWM_BIZLWS_ID = 2441) 
        
        	AND parent_id = 64289 
            AND (BIZLWM_TopActive = 1) AND (BIZLWM_TopMenu = 1)
            ORDER BY BIZLWM_TopSort, BIZLWM_BIZLTM_Name

SELECT     *, BIZLWM_BIZLTM_Name as Name, BIZLWM_BIZLTM_FileName as URL
        FROM         BizListingWebsiteMenu
        WHERE     (BIZLWM_BIZLWS_ID = 2441) 
        
        	AND parent_id = 66467 
            AND (BIZLWM_TopActive = 1) AND (BIZLWM_TopMenu = 1)
            ORDER BY BIZLWM_TopSort, BIZLWM_BIZLTM_Name

SELECT     *, BIZLWM_BIZLTM_Name as Name, BIZLWM_BIZLTM_FileName as URL
        FROM         BizListingWebsiteMenu
        WHERE     (BIZLWM_BIZLWS_ID = 2441) 
        
        	AND parent_id = 76336 
            AND (BIZLWM_TopActive = 1) AND (BIZLWM_TopMenu = 1)
            ORDER BY BIZLWM_TopSort, BIZLWM_BIZLTM_Name

SELECT     *, BIZLWM_BIZLTM_Name as Name, BIZLWM_BIZLTM_FileName as URL
        FROM         BizListingWebsiteMenu
        WHERE     (BIZLWM_BIZLWS_ID = 2441) 
        
        	AND parent_id = 76337 
            AND (BIZLWM_TopActive = 1) AND (BIZLWM_TopMenu = 1)
            ORDER BY BIZLWM_TopSort, BIZLWM_BIZLTM_Name

SELECT     *, BIZLWM_BIZLTM_Name as Name, BIZLWM_BIZLTM_FileName as URL
        FROM         BizListingWebsiteMenu
        WHERE     (BIZLWM_BIZLWS_ID = 2441) 
        
        	AND parent_id = 76338 
            AND (BIZLWM_TopActive = 1) AND (BIZLWM_TopMenu = 1)
            ORDER BY BIZLWM_TopSort, BIZLWM_BIZLTM_Name

SELECT     *, BIZLWM_BIZLTM_Name as Name, BIZLWM_BIZLTM_FileName as URL
        FROM         BizListingWebsiteMenu
        WHERE     (BIZLWM_BIZLWS_ID = 2441) 
        
        	AND parent_id = 76339 
            AND (BIZLWM_TopActive = 1) AND (BIZLWM_TopMenu = 1)
            ORDER BY BIZLWM_TopSort, BIZLWM_BIZLTM_Name

SELECT     *, BIZLWM_BIZLTM_Name as Name, BIZLWM_BIZLTM_FileName as URL
        FROM         BizListingWebsiteMenu
        WHERE     (BIZLWM_BIZLWS_ID = 2441) 
        
        	AND parent_id = 76340 
            AND (BIZLWM_TopActive = 1) AND (BIZLWM_TopMenu = 1)
            ORDER BY BIZLWM_TopSort, BIZLWM_BIZLTM_Name

SELECT     *, BIZLWM_BIZLTM_Name as Name, BIZLWM_BIZLTM_FileName as URL
        FROM         BizListingWebsiteMenu
        WHERE     (BIZLWM_BIZLWS_ID = 2441) 
        
        	AND parent_id = 76341 
            AND (BIZLWM_TopActive = 1) AND (BIZLWM_TopMenu = 1)
            ORDER BY BIZLWM_TopSort, BIZLWM_BIZLTM_Name

SELECT     *, BIZLWM_BIZLTM_Name as Name, BIZLWM_BIZLTM_FileName as URL
        FROM         BizListingWebsiteMenu
        WHERE     (BIZLWM_BIZLWS_ID = 2441) 
        
        	AND parent_id = 64276 
            AND (BIZLWM_TopActive = 1) AND (BIZLWM_TopMenu = 1)
            ORDER BY BIZLWM_TopSort, BIZLWM_BIZLTM_Name

SELECT     *, BIZLWM_BIZLTM_Name as Name, BIZLWM_BIZLTM_FileName as URL
        FROM         BizListingWebsiteMenu
        WHERE     (BIZLWM_BIZLWS_ID = 2441) 
        
        	AND parent_id = 64277 
            AND (BIZLWM_TopActive = 1) AND (BIZLWM_TopMenu = 1)
            ORDER BY BIZLWM_TopSort, BIZLWM_BIZLTM_Name

SELECT     *, BIZLWM_BIZLTM_Name as Name, BIZLWM_BIZLTM_FileName as URL
        FROM         BizListingWebsiteMenu
        WHERE     (BIZLWM_BIZLWS_ID = 2441) 
        
        	AND parent_id = 64278 
            AND (BIZLWM_TopActive = 1) AND (BIZLWM_TopMenu = 1)
            ORDER BY BIZLWM_TopSort, BIZLWM_BIZLTM_Name

SELECT     *, BIZLWM_BIZLTM_Name as Name, BIZLWM_BIZLTM_FileName as URL
        FROM         BizListingWebsiteMenu
        WHERE     (BIZLWM_BIZLWS_ID = 2441) 
        
        	AND parent_id = 64280 
            AND (BIZLWM_TopActive = 1) AND (BIZLWM_TopMenu = 1)
            ORDER BY BIZLWM_TopSort, BIZLWM_BIZLTM_Name

SELECT     *, BIZLWM_BIZLTM_Name as Name, BIZLWM_BIZLTM_FileName as URL
        FROM         BizListingWebsiteMenu
        WHERE     (BIZLWM_BIZLWS_ID = 2441) 
        
        	AND parent_id = 64290 
            AND (BIZLWM_TopActive = 1) AND (BIZLWM_TopMenu = 1)
            ORDER BY BIZLWM_TopSort, BIZLWM_BIZLTM_Name

SELECT     *, BIZLWM_BIZLTM_Name as Name, BIZLWM_BIZLTM_FileName as URL
        FROM         BizListingWebsiteMenu
        WHERE     (BIZLWM_BIZLWS_ID = 2441) 
        
        	AND parent_id = 64291 
            AND (BIZLWM_TopActive = 1) AND (BIZLWM_TopMenu = 1)
            ORDER BY BIZLWM_TopSort, BIZLWM_BIZLTM_Name

SELECT     *, BIZLWM_BIZLTM_Name as Name, BIZLWM_BIZLTM_FileName as URL
        FROM         BizListingWebsiteMenu
        WHERE     (BIZLWM_BIZLWS_ID = 2441) 
        
        	AND parent_id = 64292 
            AND (BIZLWM_TopActive = 1) AND (BIZLWM_TopMenu = 1)
            ORDER BY BIZLWM_TopSort, BIZLWM_BIZLTM_Name

SELECT     *, BIZLWM_BIZLTM_Name as Name, BIZLWM_BIZLTM_FileName as URL
        FROM         BizListingWebsiteMenu
        WHERE     (BIZLWM_BIZLWS_ID = 2441) 
        
        	AND parent_id = 64293 
            AND (BIZLWM_TopActive = 1) AND (BIZLWM_TopMenu = 1)
            ORDER BY BIZLWM_TopSort, BIZLWM_BIZLTM_Name

SELECT     *, BIZLWM_BIZLTM_Name as Name, BIZLWM_BIZLTM_FileName as URL
        FROM         BizListingWebsiteMenu
        WHERE     (BIZLWM_BIZLWS_ID = 2441) 
        
        	AND parent_id = 64294 
            AND (BIZLWM_TopActive = 1) AND (BIZLWM_TopMenu = 1)
            ORDER BY BIZLWM_TopSort, BIZLWM_BIZLTM_Name

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

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

SELECT     *, BIZLWM_BIZLTM_Name as Name, BIZLWM_BIZLTM_FileName as URL
        FROM         BizListingWebsiteMenu
        WHERE     (BIZLWM_BIZLWS_ID = 2441) 
        
        	AND parent_id = 0 
            AND BIZLWM_Active = 1 AND BIZLWM_SideMenu = 1 
            Order by BIZLWM_BIZLTM_Sort, BIZLWM_BIZLTM_Name

SELECT     *, BIZLWM_BIZLTM_Name as Name, BIZLWM_BIZLTM_FileName as URL
        FROM         BizListingWebsiteMenu
        WHERE     (BIZLWM_BIZLWS_ID = 2441) 
        
        	AND parent_id = 64312 
            AND BIZLWM_Active = 1 AND BIZLWM_SideMenu = 1 
            Order by BIZLWM_BIZLTM_Sort, BIZLWM_BIZLTM_Name

SELECT     *, BIZLWM_BIZLTM_Name as Name, BIZLWM_BIZLTM_FileName as URL
        FROM         BizListingWebsiteMenu
        WHERE     (BIZLWM_BIZLWS_ID = 2441) 
        
        	AND parent_id = 64300 
            AND BIZLWM_Active = 1 AND BIZLWM_SideMenu = 1 
            Order by BIZLWM_BIZLTM_Sort, BIZLWM_BIZLTM_Name

SELECT     *, BIZLWM_BIZLTM_Name as Name, BIZLWM_BIZLTM_FileName as URL
        FROM         BizListingWebsiteMenu
        WHERE     (BIZLWM_BIZLWS_ID = 2441) 
        
        	AND parent_id = 64301 
            AND BIZLWM_Active = 1 AND BIZLWM_SideMenu = 1 
            Order by BIZLWM_BIZLTM_Sort, BIZLWM_BIZLTM_Name

SELECT     *, BIZLWM_BIZLTM_Name as Name, BIZLWM_BIZLTM_FileName as URL
        FROM         BizListingWebsiteMenu
        WHERE     (BIZLWM_BIZLWS_ID = 2441) 
        
        	AND parent_id = 64303 
            AND BIZLWM_Active = 1 AND BIZLWM_SideMenu = 1 
            Order by BIZLWM_BIZLTM_Sort, BIZLWM_BIZLTM_Name

SELECT     *, BIZLWM_BIZLTM_Name as Name, BIZLWM_BIZLTM_FileName as URL
        FROM         BizListingWebsiteMenu
        WHERE     (BIZLWM_BIZLWS_ID = 2441) 
        
        	AND parent_id = 64313 
            AND BIZLWM_Active = 1 AND BIZLWM_SideMenu = 1 
            Order by BIZLWM_BIZLTM_Sort, BIZLWM_BIZLTM_Name

SELECT     *, BIZLWM_BIZLTM_Name as Name, BIZLWM_BIZLTM_FileName as URL
        FROM         BizListingWebsiteMenu
        WHERE     (BIZLWM_BIZLWS_ID = 2441) 
        
        	AND parent_id = 64304 
            AND BIZLWM_Active = 1 AND BIZLWM_SideMenu = 1 
            Order by BIZLWM_BIZLTM_Sort, BIZLWM_BIZLTM_Name

SELECT     *, BIZLWM_BIZLTM_Name as Name, BIZLWM_BIZLTM_FileName as URL
        FROM         BizListingWebsiteMenu
        WHERE     (BIZLWM_BIZLWS_ID = 2441) 
        
        	AND parent_id = 64305 
            AND BIZLWM_Active = 1 AND BIZLWM_SideMenu = 1 
            Order by BIZLWM_BIZLTM_Sort, BIZLWM_BIZLTM_Name

SELECT     *, BIZLWM_BIZLTM_Name as Name, BIZLWM_BIZLTM_FileName as URL
        FROM         BizListingWebsiteMenu
        WHERE     (BIZLWM_BIZLWS_ID = 2441) 
        
        	AND parent_id = 64306 
            AND BIZLWM_Active = 1 AND BIZLWM_SideMenu = 1 
            Order by BIZLWM_BIZLTM_Sort, BIZLWM_BIZLTM_Name

SELECT     *, BIZLWM_BIZLTM_Name as Name, BIZLWM_BIZLTM_FileName as URL
        FROM         BizListingWebsiteMenu
        WHERE     (BIZLWM_BIZLWS_ID = 2441) 
        
        	AND parent_id = 64307 
            AND BIZLWM_Active = 1 AND BIZLWM_SideMenu = 1 
            Order by BIZLWM_BIZLTM_Sort, BIZLWM_BIZLTM_Name

SELECT     *, BIZLWM_BIZLTM_Name as Name, BIZLWM_BIZLTM_FileName as URL
        FROM         BizListingWebsiteMenu
        WHERE     (BIZLWM_BIZLWS_ID = 2441) 
        
        	AND parent_id = 64308 
            AND BIZLWM_Active = 1 AND BIZLWM_SideMenu = 1 
            Order by BIZLWM_BIZLTM_Sort, BIZLWM_BIZLTM_Name

SELECT     *, BIZLWM_BIZLTM_Name as Name, BIZLWM_BIZLTM_FileName as URL
        FROM         BizListingWebsiteMenu
        WHERE     (BIZLWM_BIZLWS_ID = 2441) 
        
        	AND parent_id = 64309 
            AND BIZLWM_Active = 1 AND BIZLWM_SideMenu = 1 
            Order by BIZLWM_BIZLTM_Sort, BIZLWM_BIZLTM_Name

SELECT     *, BIZLWM_BIZLTM_Name as Name, BIZLWM_BIZLTM_FileName as URL
        FROM         BizListingWebsiteMenu
        WHERE     (BIZLWM_BIZLWS_ID = 2441) 
        
        	AND parent_id = 64310 
            AND BIZLWM_Active = 1 AND BIZLWM_SideMenu = 1 
            Order by BIZLWM_BIZLTM_Sort, BIZLWM_BIZLTM_Name

SELECT     *, BIZLWM_BIZLTM_Name as Name, BIZLWM_BIZLTM_FileName as URL
        FROM         BizListingWebsiteMenu
        WHERE     (BIZLWM_BIZLWS_ID = 2441) 
        
        	AND parent_id = 64311 
            AND BIZLWM_Active = 1 AND BIZLWM_SideMenu = 1 
            Order by BIZLWM_BIZLTM_Sort, BIZLWM_BIZLTM_Name

SELECT     *, BIZLWM_BIZLTM_Name as Name, BIZLWM_BIZLTM_FileName as URL
        FROM         BizListingWebsiteMenu
        WHERE     (BIZLWM_BIZLWS_ID = 2441) 
        
        	AND parent_id = 76342 
            AND BIZLWM_Active = 1 AND BIZLWM_SideMenu = 1 
            Order by BIZLWM_BIZLTM_Sort, BIZLWM_BIZLTM_Name

SELECT     *, BIZLWM_BIZLTM_Name as Name, BIZLWM_BIZLTM_FileName as URL
        FROM         BizListingWebsiteMenu
        WHERE     (BIZLWM_BIZLWS_ID = 2441) 
        
        	AND parent_id = 76343 
            AND BIZLWM_Active = 1 AND BIZLWM_SideMenu = 1 
            Order by BIZLWM_BIZLTM_Sort, BIZLWM_BIZLTM_Name

SELECT     *, BIZLWM_BIZLTM_Name as Name, BIZLWM_BIZLTM_FileName as URL
        FROM         BizListingWebsiteMenu
        WHERE     (BIZLWM_BIZLWS_ID = 2441) 
        
        	AND parent_id = 76345 
            AND BIZLWM_Active = 1 AND BIZLWM_SideMenu = 1 
            Order by BIZLWM_BIZLTM_Sort, BIZLWM_BIZLTM_Name

SELECT     *, BIZLWM_BIZLTM_Name as Name, BIZLWM_BIZLTM_FileName as URL
        FROM         BizListingWebsiteMenu
        WHERE     (BIZLWM_BIZLWS_ID = 2441) 
        
        	AND parent_id = 76346 
            AND BIZLWM_Active = 1 AND BIZLWM_SideMenu = 1 
            Order by BIZLWM_BIZLTM_Sort, BIZLWM_BIZLTM_Name

SELECT     *, BIZLWM_BIZLTM_Name as Name, BIZLWM_BIZLTM_FileName as URL
        FROM         BizListingWebsiteMenu
        WHERE     (BIZLWM_BIZLWS_ID = 2441) 
        
        	AND parent_id = 76347 
            AND BIZLWM_Active = 1 AND BIZLWM_SideMenu = 1 
            Order by BIZLWM_BIZLTM_Sort, BIZLWM_BIZLTM_Name

SELECT     *, BIZLWM_BIZLTM_Name as Name, BIZLWM_BIZLTM_FileName as URL
        FROM         BizListingWebsiteMenu
        WHERE     (BIZLWM_BIZLWS_ID = 2441) 
        
        	AND parent_id = 76348 
            AND BIZLWM_Active = 1 AND BIZLWM_SideMenu = 1 
            Order by BIZLWM_BIZLTM_Sort, BIZLWM_BIZLTM_Name

SELECT     *, BIZLWM_BIZLTM_Name as Name, BIZLWM_BIZLTM_FileName as URL
        FROM         BizListingWebsiteMenu
        WHERE     (BIZLWM_BIZLWS_ID = 2441) 
        
        	AND parent_id = 76349 
            AND BIZLWM_Active = 1 AND BIZLWM_SideMenu = 1 
            Order by BIZLWM_BIZLTM_Sort, BIZLWM_BIZLTM_Name

SELECT     *, BIZLWM_BIZLTM_Name as Name, BIZLWM_BIZLTM_FileName as URL
        FROM         BizListingWebsiteMenu
        WHERE     (BIZLWM_BIZLWS_ID = 2441) 
        
        	AND parent_id = 64314 
            AND BIZLWM_Active = 1 AND BIZLWM_SideMenu = 1 
            Order by BIZLWM_BIZLTM_Sort, BIZLWM_BIZLTM_Name

SELECT     *, BIZLWM_BIZLTM_Name as Name, BIZLWM_BIZLTM_FileName as URL
        FROM         BizListingWebsiteMenu
        WHERE     (BIZLWM_BIZLWS_ID = 2441) 
        
        	AND parent_id = 64317 
            AND BIZLWM_Active = 1 AND BIZLWM_SideMenu = 1 
            Order by BIZLWM_BIZLTM_Sort, BIZLWM_BIZLTM_Name

SELECT     *, BIZLWM_BIZLTM_Name as Name, BIZLWM_BIZLTM_FileName as URL
        FROM         BizListingWebsiteMenu
        WHERE     (BIZLWM_BIZLWS_ID = 2441) 
        
        	AND parent_id = 64318 
            AND BIZLWM_Active = 1 AND BIZLWM_SideMenu = 1 
            Order by BIZLWM_BIZLTM_Sort, BIZLWM_BIZLTM_Name

SELECT     *, BIZLWM_BIZLTM_Name as Name, BIZLWM_BIZLTM_FileName as URL
        FROM         BizListingWebsiteMenu
        WHERE     (BIZLWM_BIZLWS_ID = 2441) 
        
        	AND parent_id = 64315 
            AND BIZLWM_Active = 1 AND BIZLWM_SideMenu = 1 
            Order by BIZLWM_BIZLTM_Sort, BIZLWM_BIZLTM_Name

SELECT     *, BIZLWM_BIZLTM_Name as Name, BIZLWM_BIZLTM_FileName as URL
        FROM         BizListingWebsiteMenu
        WHERE     (BIZLWM_BIZLWS_ID = 2441) 
        
        	AND parent_id = 64316 
            AND BIZLWM_Active = 1 AND BIZLWM_SideMenu = 1 
            Order by BIZLWM_BIZLTM_Sort, BIZLWM_BIZLTM_Name

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

SELECT * FROM      seoURLsView
            WHERE biz_unl_bizl_id = 15171 
            	AND biz_unl_name = ? 
            AND (seoURL_type = 'page')

SELECT    *
            FROM      seoURLsView
            WHERE     (BIZ_UNL_BIZL_ID = 15171) 
            AND (parent_id = ?) 
            
            AND BIZ_UNL_Active = 1
			
            AND (seoURL_type = 'page')
            ORDER BY BIZ_UNL_Sort

SELECT    *
		FROM      seoURLsView
		WHERE     (BIZ_UNL_BIZL_ID = 15171) 
		AND (seoURL_type = 'page')
        
            AND (BIZ_UNL_SLCP_ID = 0 OR BIZ_UNL_SLCP_ID IS NULL)
        
        	AND biz_unl_id IN (
        		213080, 213081, 213083 
			)
		
   		ORDER BY BIZ_UNL_Sort

SELECT * FROM      seoURLsView
            WHERE biz_unl_bizl_id = 15171 
            	AND biz_unl_name = ? 
            AND (seoURL_type = 'page')

SELECT    *
            FROM      seoURLsView
            WHERE     (BIZ_UNL_BIZL_ID = 15171) 
            AND (parent_id = ?) 
            
            AND BIZ_UNL_Active = 1
			
            AND (seoURL_type = 'page')
            ORDER BY BIZ_UNL_Sort

SELECT    *
		FROM      seoURLsView
		WHERE     (BIZ_UNL_BIZL_ID = 15171) 
		AND (seoURL_type = 'page')
        
            AND (BIZ_UNL_SLCP_ID = 0 OR BIZ_UNL_SLCP_ID IS NULL)
        
        	AND biz_unl_id IN (
        		213071, 213072, 213073, 213074, 213075, 213076, 213077, 213078, 256275, 463362, 463363, 463364, 463365, 463382, 463383 
			)
		
   		ORDER BY BIZ_UNL_Sort

Application Variables:
applicationname=www.chemmasterrestoration.com
configured=1
currentsessions=0
datetimeconfigured=04:00 PM  05.02.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.chemmasterrestoration.com
CERT_SUBJECT=
CF_TEMPLATE_PATH=D:\Inetpub\vhosts\chemmasterrestoration.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.chemmasterrestoration.com
HTTP_ACCEPT=*/*
HTTP_ACCEPT_ENCODING=gzip, br
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=close
HTTP_COOKIE=
HTTP_HOST=www.chemmasterrestoration.com
HTTP_REFERER=http://www.chemmasterrestoration.com/careers/carpet-cleaning-technician
HTTP_URL=/rewrite.cfm/careers/carpet-cleaning-technician
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=/careers/carpet-cleaning-technician
PATH_TRANSLATED=D:\Inetpub\vhosts\chemmasterrestoration.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.chemmasterrestoration.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=102728593
cftoken=90e69341c02c7471-B392447F-0209-929E-2DB08DB4CB459543
hitcount=1
lastvisit={ts '2024-05-09 14:08:51'}
timecreated={ts '2024-05-09 14:08:51'}
urltoken=CFID=102728593&CFTOKEN=90e69341c02c7471-B392447F-0209-929E-2DB08DB4CB459543&jsessionid=0CE67EDD1F8F858681939D5D939B544A.cfusion

Cookie Variables:
CFID=102728593
CFTOKEN=90e69341c02c7471-B392447F-0209-929E-2DB08DB4CB459543

Form Fields:
fieldnames=

Request Parameters:
samesite_value=

Session Variables:
errormsg=
loginattempt=0
mobileview=1
registeredcustomer=Struct (2)
sessionid=0CE67EDD1F8F858681939D5D939B544A.cfusion
urltoken=CFID=102728593&CFTOKEN=90e69341c02c7471-B392447F-0209-929E-2DB08DB4CB459543&jsessionid=0CE67EDD1F8F858681939D5D939B544A.cfusion

URL Parameters:
CP=careers
CPID=carpet-cleaning-technician
MOBILEVIEW=1