Blog Post

SELECT * FROM BizListingWebsiteSettings
	WHERE BIZLWS_RCS_DomainName = ?

SELECT * FROM BizListingWebsiteSettings2
        WHERE BIZLWS2_BIZLWS_ID = ?

SELECT TOP 1 * FROM BizListingWebsiteFrameworks
            WHERE id = 10

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

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

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

SELECT   dbo.BizNews.BIZ_NEWS_ID
        FROM         dbo.seoURLs RIGHT OUTER JOIN
                              dbo.BizNews ON dbo.seoURLs.seoURL_input_id = dbo.BizNews.BIZ_NEWS_ID
        WHERE     (dbo.seoURLs.seoURL_type = 'article')
        AND		seoURL_BIZLWS_ID = 2261
        AND     seoURL_output_string = ?
        ORDER BY BIZ_NEWS_ID desc

SELECT	* FROM	BizNews
		WHERE	BIZ_NEWS_ID = ?

SELECT * FROM BizListingWebsiteSettings2
	WHERE BIZLWS2_BIZLWS_ID = ?
    AND (BizListingWebsiteSettings2.BIZLWS2_Catalog IS NULL or 		 
         BizListingWebsiteSettings2.BIZLWS2_Catalog = 0)

SELECT    BizNews.*
        FROM      BizNews 
        WHERE     (BizNews.BIZ_NEWS_BIZL_ID = ?) 
        AND 	  (BizNews.BIZ_NEWS_ID = ?) 
        AND 	  (BizNews.BIZ_NEWS_Active = 1)

SELECT     dbo.BizListingUnlimitedPages.BIZ_UNL_Title, dbo.BizListingUnlimitedPages.BIZ_UNL_ID, dbo.seoURLs.seoURL_output_string, dbo.seoURLs.seoURL_type
            FROM         dbo.seoURLs INNER JOIN
                      dbo.BizNews ON dbo.seoURLs.seoURL_BIZLWS_ID = dbo.BizNews.BIZ_NEWS_BIZLWS_ID RIGHT OUTER JOIN
                      dbo.BizListingUnlimitedPages ON dbo.seoURLs.seoURL_input_id = dbo.BizListingUnlimitedPages.BIZ_UNL_ID AND 
                      dbo.BizNews.BIZ_NEWS_BIZ_UNL_ID = dbo.BizListingUnlimitedPages.BIZ_UNL_ID   
            WHERE  dbo.BizNews.BIZ_NEWS_BIZL_ID = ?
            AND dbo.BizNews.BIZ_NEWS_ID = ?
            AND dbo.BizNews.BIZ_NEWS_Active = 1
            AND (dbo.seoURLs.seoURL_type = 'page')

SELECT  TOP 100 PERCENT 
            dbo.BizListingUnlimitedPages.BIZ_UNL_ID
            ,dbo.BizListingUnlimitedPages.BIZ_UNL_Name
            ,COUNT(dbo.BizNews.BIZ_NEWS_BIZ_UNL_ID) AS ItemCount
            ,dbo.BizListingUnlimitedPages.BIZ_UNL_Sort
            ,dbo.BizListingUnlimitedPages.BIZ_UNL_menulevel
    FROM  	dbo.BizListingUnlimitedPages LEFT OUTER JOIN 
            dbo.BizNews ON dbo.BizListingUnlimitedPages.BIZ_UNL_ID = dbo.BizNews.BIZ_NEWS_BIZ_UNL_ID
    WHERE 	dbo.BizListingUnlimitedPages.BIZ_UNL_BIZL_ID = ?
    		AND dbo.BizListingUnlimitedPages.BIZ_UNL_Active = 1
			AND dbo.BizNews.BIZ_NEWS_Active = 1
            AND dbo.BizNews.BIZ_NEWS_PostedDate <{ts '2024-04-25 17:17:31'}
            AND dbo.BizListingUnlimitedPages.BIZ_UNL_SLCP_ID IS NULL
    GROUP BY dbo.BizListingUnlimitedPages.BIZ_UNL_ID, 
            dbo.BizListingUnlimitedPages.BIZ_UNL_Name, 
            dbo.BizListingUnlimitedPages.BIZ_UNL_Sort, 
            dbo.BizListingUnlimitedPages.BIZ_UNL_menulevel
    
    ORDER BY dbo.BizListingUnlimitedPages.BIZ_UNL_Name

SELECT TOP 100 PERCENT COUNT(BIZ_NEWS_PostedDate) AS blogcount
, DATENAME(Month, BIZ_NEWS_PostedDate) AS monthName
, MONTH(BIZ_NEWS_PostedDate) AS monthNum1
, YEAR(BIZ_NEWS_PostedDate) AS yearNum1
FROM dbo.BizNews BIZ_NEWS_PostedDate
WHERE BIZ_NEWS_BIZL_ID = ?
AND BIZ_NEWS_Active = 1
AND BIZ_NEWS_PostedDate <{ts '2024-04-25 17:17:31'}   
GROUP BY DATENAME(Month, BIZ_NEWS_PostedDate), MONTH(BIZ_NEWS_PostedDate), YEAR(BIZ_NEWS_PostedDate)
ORDER BY yearNum1 Desc, monthNum1 Desc

SELECT    BizNews.*
        FROM      BizNews 
        WHERE     (BizNews.BIZ_NEWS_BIZL_ID = ?) 
        AND 	  (BizNews.BIZ_NEWS_ID = ?) 
        AND 	  (BizNews.BIZ_NEWS_Active = 1)

SELECT     dbo.BizListingUnlimitedPages.BIZ_UNL_Title, dbo.BizListingUnlimitedPages.BIZ_UNL_ID, dbo.seoURLs.seoURL_output_string, dbo.seoURLs.seoURL_type
            FROM         dbo.seoURLs INNER JOIN
                      dbo.BizNews ON dbo.seoURLs.seoURL_BIZLWS_ID = dbo.BizNews.BIZ_NEWS_BIZLWS_ID RIGHT OUTER JOIN
                      dbo.BizListingUnlimitedPages ON dbo.seoURLs.seoURL_input_id = dbo.BizListingUnlimitedPages.BIZ_UNL_ID AND 
                      dbo.BizNews.BIZ_NEWS_BIZ_UNL_ID = dbo.BizListingUnlimitedPages.BIZ_UNL_ID   
            WHERE  dbo.BizNews.BIZ_NEWS_BIZL_ID = ?
            AND dbo.BizNews.BIZ_NEWS_ID = ?
            AND dbo.BizNews.BIZ_NEWS_Active = 1
            AND (dbo.seoURLs.seoURL_type = 'page')

SELECT *
        FROM customTag
        WHERE bizlws_id = ?
        AND tag <> ''
        AND tag IS NOT NULL
        AND (
        	category = 'snippet'
        	OR category = 'form'
        	OR category = 'template'
        )

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

SELECT *
        FROM customTag
        WHERE id = ?
        AND bizlws_id = 2261

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

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

SELECT     *, BIZLWM_BIZLTM_Name as Name, BIZLWM_BIZLTM_FileName as URL
        FROM         BizListingWebsiteMenu
        WHERE     (BIZLWM_BIZLWS_ID = 2261) 
        
        	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 = 2261) 
        
        	AND parent_id = 76415 
            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 = 2261) 
        
        	AND parent_id = 76420 
            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 = 2261) 
        
        	AND parent_id = 76421 
            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 = 2261) 
        
        	AND parent_id = 76422 
            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 = 2261) 
        
        	AND parent_id = 76423 
            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 = 2261) 
        
        	AND parent_id = 76424 
            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 = 2261) 
        
        	AND parent_id = 76425 
            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 = 2261) 
        
        	AND parent_id = 76426 
            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 = 2261) 
        
        	AND parent_id = 76427 
            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 = 2261) 
        
        	AND parent_id = 76428 
            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 = 2261) 
        
        	AND parent_id = 76429 
            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 = 2261) 
        
        	AND parent_id = 76416 
            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 = 2261) 
        
        	AND parent_id = 76430 
            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 = 2261) 
        
        	AND parent_id = 76431 
            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 = 2261) 
        
        	AND parent_id = 76432 
            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 = 2261) 
        
        	AND parent_id = 76433 
            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 = 2261) 
        
        	AND parent_id = 76434 
            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 = 2261) 
        
        	AND parent_id = 76417 
            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 = 2261) 
        
        	AND parent_id = 76435 
            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 = 2261) 
        
        	AND parent_id = 76436 
            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 = 2261) 
        
        	AND parent_id = 76437 
            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 = 2261) 
        
        	AND parent_id = 76438 
            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 = 2261) 
        
        	AND parent_id = 76418 
            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 = 2261) 
        
        	AND parent_id = 76792 
            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 = 2261) 
        
        	AND parent_id = 76440 
            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 = 2261) 
        
        	AND parent_id = 76441 
            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 = 2261) 
        
        	AND parent_id = 76439 
            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 = 2261) 
        
        	AND parent_id = 76443 
            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 = 2261) 
        
        	AND parent_id = 76444 
            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 = 2261) 
        
        	AND parent_id = 76445 
            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 = 2261) 
        
        	AND parent_id = 76446 
            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 = 2261) 
        
        	AND parent_id = 76447 
            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 = 2261) 
        
        	AND parent_id = 76448 
            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 = 2261) 
        
        	AND parent_id = 76419 
            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 = 2261) 
        
        	AND parent_id = 76415 
            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 = 2261) 
        
        	AND parent_id = 76420 
            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 = 2261) 
        
        	AND parent_id = 76421 
            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 = 2261) 
        
        	AND parent_id = 76422 
            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 = 2261) 
        
        	AND parent_id = 76423 
            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 = 2261) 
        
        	AND parent_id = 76424 
            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 = 2261) 
        
        	AND parent_id = 76425 
            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 = 2261) 
        
        	AND parent_id = 76426 
            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 = 2261) 
        
        	AND parent_id = 76427 
            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 = 2261) 
        
        	AND parent_id = 76428 
            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 = 2261) 
        
        	AND parent_id = 76429 
            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 = 2261) 
        
        	AND parent_id = 76416 
            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 = 2261) 
        
        	AND parent_id = 76430 
            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 = 2261) 
        
        	AND parent_id = 76431 
            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 = 2261) 
        
        	AND parent_id = 76432 
            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 = 2261) 
        
        	AND parent_id = 76433 
            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 = 2261) 
        
        	AND parent_id = 76434 
            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 = 2261) 
        
        	AND parent_id = 76417 
            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 = 2261) 
        
        	AND parent_id = 76435 
            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 = 2261) 
        
        	AND parent_id = 76436 
            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 = 2261) 
        
        	AND parent_id = 76437 
            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 = 2261) 
        
        	AND parent_id = 76438 
            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 = 2261) 
        
        	AND parent_id = 76418 
            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 = 2261) 
        
        	AND parent_id = 76792 
            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 = 2261) 
        
        	AND parent_id = 76440 
            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 = 2261) 
        
        	AND parent_id = 76441 
            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 = 2261) 
        
        	AND parent_id = 76439 
            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 = 2261) 
        
        	AND parent_id = 76443 
            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 = 2261) 
        
        	AND parent_id = 76444 
            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 = 2261) 
        
        	AND parent_id = 76445 
            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 = 2261) 
        
        	AND parent_id = 76446 
            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 = 2261) 
        
        	AND parent_id = 76447 
            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 = 2261) 
        
        	AND parent_id = 76448 
            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 = 2261) 
        
        	AND parent_id = 76419 
            AND (BIZLWM_TopActive = 1) AND (BIZLWM_TopMenu = 1)
            ORDER BY BIZLWM_TopSort, BIZLWM_BIZLTM_Name

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

Application Variables:
applicationname=www.1stcalldisasterservices.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=4096
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=C=US, O=Let's Encrypt, CN=R3
CERT_SERVER_SUBJECT=CN=www.1stcalldisasterservices.com
CERT_SUBJECT=
CF_TEMPLATE_PATH=D:\Inetpub\vhosts\1stcalldisasterservices.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.1stcalldisasterservices.com
HTTP_ACCEPT=*/*
HTTP_ACCEPT_ENCODING=gzip, br
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=close
HTTP_COOKIE=
HTTP_HOST=www.1stcalldisasterservices.com
HTTP_REFERER=
HTTP_URL=/rewrite.cfm/article/water-damage-tips-what-to-do-after-a-water-pipe-bursts
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=/article/water-damage-tips-what-to-do-after-a-water-pipe-bursts
PATH_TRANSLATED=D:\Inetpub\vhosts\1stcalldisasterservices.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.1stcalldisasterservices.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=101606364
cftoken=5dfabe8e81889876-E950AAC2-FBE1-A19D-8116BC2A0A5E6CE5
hitcount=1
lastvisit={ts '2024-04-25 17:17:31'}
timecreated={ts '2024-04-25 17:17:31'}
urltoken=CFID=101606364&CFTOKEN=5dfabe8e81889876-E950AAC2-FBE1-A19D-8116BC2A0A5E6CE5&jsessionid=8827D368ABD198B2CE095A9EF4D365F4.cfusion

Cookie Variables:
CFID=101606364
CFTOKEN=5dfabe8e81889876-E950AAC2-FBE1-A19D-8116BC2A0A5E6CE5

Form Fields:
fieldnames=

Request Parameters:
samesite_value=

Session Variables:
errormsg=
loginattempt=0
mobileview=1
registeredcustomer=Struct (2)
sessionid=8827D368ABD198B2CE095A9EF4D365F4.cfusion
urltoken=CFID=101606364&CFTOKEN=5dfabe8e81889876-E950AAC2-FBE1-A19D-8116BC2A0A5E6CE5&jsessionid=8827D368ABD198B2CE095A9EF4D365F4.cfusion

URL Parameters:
ARTICLE=589683
BIZ_NEWS_ID=0
MOBILEVIEW=1