Top-Rated Fire And Smoke Damage Cleanup in Hilliard, OH

SELECT * FROM BizListingWebsiteSettings
	WHERE BIZLWS_RCS_DomainName = ?

SELECT * FROM BizListingWebsiteSettings2
        WHERE BIZLWS2_BIZLWS_ID = ?

SELECT TOP 1 * FROM BizListingWebsiteFrameworks
            WHERE id = 6

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

SELECT *
    FROM customTag
    WHERE bizlws_id = 2516
    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 = 2516)
        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 = 2516
            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 = 2516
                    AND     BIZ_UNL_ID = 287542
                    AND     seoURL_output_string <> 'slcp'

SELECT     BIZLWM_BIZLTM_Name AS Title
FROM         BizListingWebsiteMenu
WHERE     (BIZLWM_BIZLWS_ID = 2516) 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 = 15941

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 = 15941
        ORDER BY BIZ_UNL_Title, BIZ_UNL_Name

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

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

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

SELECT     *, BIZLWM_BIZLTM_Name as Name, BIZLWM_BIZLTM_FileName as URL
        FROM         BizListingWebsiteMenu
        WHERE     (BIZLWM_BIZLWS_ID = 2516) 
        
        	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 = 2516) 
        
        	AND parent_id = 67398 
            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 = 2516) 
        
        	AND parent_id = 67399 
            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 = 2516) 
        
        	AND parent_id = 67430 
            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 = 2516) 
        
        	AND parent_id = 67400 
            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 = 2516) 
        
        	AND parent_id = 67401 
            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 = 2516) 
        
        	AND parent_id = 67402 
            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 = 2516) 
        
        	AND parent_id = 67403 
            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 = 2516) 
        
        	AND parent_id = 67404 
            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 = 2516) 
        
        	AND parent_id = 67405 
            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 = 2516) 
        
        	AND parent_id = 67406 
            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 = 2516) 
        
        	AND parent_id = 67407 
            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 = 2516) 
        
        	AND parent_id = 67408 
            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 = 2516) 
        
        	AND parent_id = 67409 
            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 = 2516) 
        
        	AND parent_id = 67410 
            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 = 2516) 
        
        	AND parent_id = 67411 
            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 = 2516) 
        
        	AND parent_id = 67412 
            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 = 2516) 
        
        	AND parent_id = 67413 
            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 = 2516) 
        
        	AND parent_id = 67414 
            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 = 2516) 
        
        	AND parent_id = 67415 
            AND (BIZLWM_TopActive = 1) AND (BIZLWM_TopMenu = 1)
            ORDER BY BIZLWM_TopSort, BIZLWM_BIZLTM_Name

SELECT * FROM BizListingUnlimitedPages
		WHERE BIZ_UNL_ID = ?

SELECT   TOP 5   BIZ_NEWS_ID
		FROM         BizNews
		WHERE     (BIZ_NEWS_BIZL_ID = ?)
        
        AND (BIZ_NEWS_BIZ_UNL_ID = ?) 
        
        AND (BIZ_NEWS_Active = 1) AND BIZ_NEWS_PostedDate <= {ts '2024-05-13 13:22:25'}
		ORDER BY BIZ_NEWS_PostedDate DESC

SELECT	* FROM	BizListingUnlimitedPagesPhotos
    WHERE	BIZ_UNL_PHO_BIZ_UNL_ID = ?
    AND BIZ_UNL_PHO_Active = 1
    ORDER BY BIZ_UNL_PHO_Sort_Order, BIZ_UNL_PHO_ID DESC

SELECT     *
					FROM       GlobalVariable
					WHERE ID = 1137

SELECT     *
					FROM       GlobalVariable
					WHERE ID = 1130

SELECT     *
					FROM       GlobalVariable
					WHERE ID = 1118

SELECT     *
					FROM       GlobalVariable
					WHERE ID = 126

SELECT     *
					FROM       GlobalVariable
					WHERE ID = 122

SELECT     *
					FROM       GlobalVariable
					WHERE ID = 3903

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

SELECT    *
		FROM      seoURLsView
		WHERE     (BIZ_UNL_BIZL_ID = 15941) 
		AND (seoURL_type = 'page')
        
            AND (BIZ_UNL_SLCP_ID = 0 OR BIZ_UNL_SLCP_ID IS NULL)
        
			AND (
			
				biz_unl_name = ? 
			)
		
   			ORDER BY CASE 
				
					WHEN biz_unl_name = ? THEN 1 
				ELSE 2
			END

SELECT *
			FROM SLCP_OA_AreaBridge
			WHERE slcp_id = 642
			AND BIZLWS_ID = 2516 
			AND slcp_area IN (
				? 
			)

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() })
					AND (
						BIZ_News_OA_AIO_Blog_Marketing = 1
					)
				) BizNews LEFT OUTER JOIN
							  dbo.seoURLs ON BizNews.BIZ_NEWS_ID = dbo.seoURLs.seoURL_input_id
				WHERE (dbo.seoURLs.seoURL_type = 'article')
				
					AND Biz_News_OA_Area IN (
						
							'Hilliard, OH'
							
					)
				
					AND BIZ_News_OA_ID IN (1993)
				
				ORDER BY BizNews.BIZ_NEWS_PostedDate DESC

SELECT    *
		FROM      seoURLsView
		WHERE     (BIZ_UNL_BIZL_ID = 15941) 
		AND (seoURL_type = 'page')
        
            AND (BIZ_UNL_SLCP_ID = 0 OR BIZ_UNL_SLCP_ID IS NULL)
        
			AND (
			
				biz_unl_name = ? 
			)
		
   			ORDER BY CASE 
				
					WHEN biz_unl_name = ? THEN 1 
				ELSE 2
			END

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() })
            
                AND BIZ_NEWS_BIZ_UNL_ID IN (287543)
            
            ) 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 287543

SELECT    *
		FROM      seoURLsView
		WHERE     (BIZ_UNL_BIZL_ID = 15941) 
		AND (seoURL_type = 'page')
        
            AND (BIZ_UNL_SLCP_ID = 0 OR BIZ_UNL_SLCP_ID IS NULL)
        
			AND (
			
				biz_unl_name = ? 
			)
		
   			ORDER BY CASE 
				
					WHEN biz_unl_name = ? THEN 1 
				ELSE 2
			END

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() })
            
                AND BIZ_NEWS_BIZ_UNL_ID IN (287544)
            
            ) 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 287544

SELECT    *
		FROM      seoURLsView
		WHERE     (BIZ_UNL_BIZL_ID = 15941) 
		AND (seoURL_type = 'page')
        
            AND (BIZ_UNL_SLCP_ID = 0 OR BIZ_UNL_SLCP_ID IS NULL)
        
			AND (
			
				biz_unl_name = ? 
			)
		
   			ORDER BY CASE 
				
					WHEN biz_unl_name = ? THEN 1 
				ELSE 2
			END

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() })
            
                AND BIZ_NEWS_BIZ_UNL_ID IN (279673)
            
            ) BizNews LEFT OUTER JOIN
                        dbo.seoURLs ON BizNews.BIZ_NEWS_ID = dbo.seoURLs.seoURL_input_id
            WHERE 

            
            (
                (dbo.seoURLs.seoURL_type = 'article') 
                AND (
                    
                            BIZ_NEWS_Headline LIKE ? OR 
                            BIZ_NEWS_Headline LIKE ? OR 
                            BIZ_NEWS_Headline LIKE ? 
                )
            )
            
            ORDER BY BIZ_NEWS_PostedDate DESC
            -- hasPageTopic 
            -- pageIdsList 279673

SELECT    *
		FROM      seoURLsView
		WHERE     (BIZ_UNL_BIZL_ID = 15941) 
		AND (seoURL_type = 'page')
        
            AND (BIZ_UNL_SLCP_ID = 0 OR BIZ_UNL_SLCP_ID IS NULL)
        
			AND (
			
				biz_unl_name = ? 
			)
		
   			ORDER BY CASE 
				
					WHEN biz_unl_name = ? THEN 1 
				ELSE 2
			END

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() })
            
                AND BIZ_NEWS_BIZ_UNL_ID IN (287546)
            
            ) 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 287546

SELECT    *
		FROM      seoURLsView
		WHERE     (BIZ_UNL_BIZL_ID = 15941) 
		AND (seoURL_type = 'page')
        
            AND (BIZ_UNL_SLCP_ID = 0 OR BIZ_UNL_SLCP_ID IS NULL)
        
			AND (
			
				biz_unl_name = ? 
			)
		
   			ORDER BY CASE 
				
					WHEN biz_unl_name = ? THEN 1 
				ELSE 2
			END

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() })
            
                AND BIZ_NEWS_BIZ_UNL_ID IN (292872)
            
            ) BizNews LEFT OUTER JOIN
                        dbo.seoURLs ON BizNews.BIZ_NEWS_ID = dbo.seoURLs.seoURL_input_id
            WHERE 

            
            (
                (dbo.seoURLs.seoURL_type = 'article') 
                AND (
                    
                            BIZ_NEWS_Headline LIKE ? OR 
                            BIZ_NEWS_Headline LIKE ? OR 
                            BIZ_NEWS_Headline LIKE ? 
                )
            )
            
            ORDER BY BIZ_NEWS_PostedDate DESC
            -- hasPageTopic 
            -- pageIdsList 292872

SELECT    *
		FROM      seoURLsView
		WHERE     (BIZ_UNL_BIZL_ID = 15941) 
		AND (seoURL_type = 'page')
        
            AND (BIZ_UNL_SLCP_ID = 0 OR BIZ_UNL_SLCP_ID IS NULL)
        
			AND (
			
				biz_unl_name = ? 
			)
		
   			ORDER BY CASE 
				
					WHEN biz_unl_name = ? THEN 1 
				ELSE 2
			END

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() })
            
                AND BIZ_NEWS_BIZ_UNL_ID IN (279675)
            
            ) BizNews LEFT OUTER JOIN
                        dbo.seoURLs ON BizNews.BIZ_NEWS_ID = dbo.seoURLs.seoURL_input_id
            WHERE 

            
            (
                (dbo.seoURLs.seoURL_type = 'article') 
                AND (
                    
                            BIZ_NEWS_Headline LIKE ? OR 
                            BIZ_NEWS_Headline LIKE ? OR 
                            BIZ_NEWS_Headline LIKE ? 
                )
            )
            
            ORDER BY BIZ_NEWS_PostedDate DESC
            -- hasPageTopic 
            -- pageIdsList 279675

SELECT * FROM BizListingWebsiteMenu
	Where BIZLWM_BIZLWS_ID  = 2516
	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 = 15941 
            	AND biz_unl_name = ? 
            AND (seoURL_type = 'page')

SELECT    *
            FROM      seoURLsView
            WHERE     (BIZ_UNL_BIZL_ID = 15941) 
            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 = 15941) 
		AND (seoURL_type = 'page')
        
            AND (BIZ_UNL_SLCP_ID = 0 OR BIZ_UNL_SLCP_ID IS NULL)
        
        	AND biz_unl_id IN (
        		279678, 279679, 279680, 279681, 279682, 279683, 279684, 279685, 279686 
			)
		
   		ORDER BY BIZ_UNL_Sort

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

SELECT TOP 4  *
            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() })
            
                AND (
                    BIZ_News_OA_AIO_Blog_Marketing = 0
                    OR BIZ_News_OA_AIO_Blog_Marketing IS NULL
                )
                AND (
                    BIZ_News_OA_Social_Media_Marketing = 0
                    OR BIZ_News_OA_Social_Media_Marketing IS NULL
                )
            
            ) 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

Application Variables:
applicationname=www.thompsonbuilding.com
configured=1
currentsessions=0
datetimeconfigured=04:06 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.thompsonbuilding.com
CERT_SUBJECT=
CF_TEMPLATE_PATH=D:\Inetpub\vhosts\thompsonbuilding.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.thompsonbuilding.com
HTTP_ACCEPT=*/*
HTTP_ACCEPT_ENCODING=gzip, br
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=close
HTTP_COOKIE=
HTTP_HOST=www.thompsonbuilding.com
HTTP_REFERER=http://www.thompsonbuilding.com/fire-and-smoke-damage-cleanup-in-hilliard-oh
HTTP_URL=/rewrite.cfm/fire-and-smoke-damage-cleanup-in-hilliard-oh
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=/fire-and-smoke-damage-cleanup-in-hilliard-oh
PATH_TRANSLATED=D:\Inetpub\vhosts\thompsonbuilding.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.thompsonbuilding.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=102988525
cftoken=500ecf5c63fc74a7-7FE5C198-F830-295D-53A6218B8C735F3A
hitcount=1
lastvisit={ts '2024-05-13 13:22:24'}
timecreated={ts '2024-05-13 13:22:24'}
urltoken=CFID=102988525&CFTOKEN=500ecf5c63fc74a7-7FE5C198-F830-295D-53A6218B8C735F3A&jsessionid=A88FF1B847EBA09EFF897BEF80DDAD7E.cfusion

Cookie Variables:
CFID=102988525
CFTOKEN=500ecf5c63fc74a7-7FE5C198-F830-295D-53A6218B8C735F3A

Form Fields:
fieldnames=

Request Parameters:
samesite_value=

Session Variables:
errormsg=
loginattempt=0
mobileview=1
registeredcustomer=Struct (2)
sessionid=A88FF1B847EBA09EFF897BEF80DDAD7E.cfusion
urltoken=CFID=102988525&CFTOKEN=500ecf5c63fc74a7-7FE5C198-F830-295D-53A6218B8C735F3A&jsessionid=A88FF1B847EBA09EFF897BEF80DDAD7E.cfusion

URL Parameters:
BIZ_UNL_ID=446540
MOBILEVIEW=1