SELECT MarketerCustomerID
		FROM MarketerCustomer
		WHERE AgHostCustID = ?
			AND status = 1

SELECT TOP 1 *, ISNULL(WebSiteZip, Zip) AS Customer_Zip, WebSiteWeatherStationID as DefaultWXStation,
			(select top 1 ccp.useProducerAgreement
			from [CustCashBidPref] ccp
			WHERE ccp.CustID = cs.CustID
			AND ccp.SiteID = cs.SiteID) as ProducerAgreementForce,
			(select top 1 ccp.ProducerAgreementDTstamp
			from [CustCashBidPref] ccp
			WHERE ccp.CustID = cs.CustID
			AND ccp.SiteID = cs.SiteID) as ProducerAgreementDTstamp
		FROM CustSite cs
		WHERE cs.CustID = ?
			AND cs.SiteID = ?

SELECT dbo.getServiceCodes(
			  ?
			, ?
			, getDate()
			, getDate()
		) AS theServiceCodes

SELECT ExchangeId, [Name]
			FROM Exchange
			WHERE Premium = 1

SELECT CodeValue
			FROM CustServices
			WHERE CustID = ?
				AND SiteID = ?
				AND ServiceCode = 'FULLQUOTES'

SELECT dtnMenuID
		FROM custDtnMenuSecure
		WHERE custID = ?
			AND siteID = ?

SELECT TOP 1 *
		FROM CustTemplate
		WHERE CustID = ?
			AND SiteID = ?

SELECT m.[id] AS DtnMenuID, m.[name], m.agCatID, m.[action] AS StandardAction, o.[Action] AS OverridingAction, adx.AdSlotID
				FROM DTNMenu m
					LEFT OUTER JOIN DTNMenuActionOverride o ON m.[ID] = o.DTNMenuID
						AND o.ServiceCode IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
					LEFT OUTER JOIN adSlotMenuXRef adx ON m.[ID] = adx.dtnMenuID
						AND adx.CustID = ?
						AND adx.SiteID = ?
				WHERE m.[ID] IN (?,?,?,?,?,?,?,?)
				
				ORDER BY CHARINDEX(',' + CONVERT(varchar(50),m.[id]) + ',',?),
					ISNULL(o.Priority,0)

SELECT m.[id] AS DtnMenuID, m.[name], m.agCatID, m.[action] AS StandardAction, o.[Action] AS OverridingAction, adx.AdSlotID
				FROM DTNMenu m
					LEFT OUTER JOIN DTNMenuActionOverride o ON m.[ID] = o.DTNMenuID
						AND o.ServiceCode IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
					LEFT OUTER JOIN adSlotMenuXRef adx ON m.[ID] = adx.dtnMenuID
						AND adx.CustID = ?
						AND adx.SiteID = ?
				WHERE m.[ID] IN (?,?)
				
				ORDER BY CHARINDEX(',' + CONVERT(varchar(50),m.[id]) + ',',?),
					ISNULL(o.Priority,0)

SELECT TOP 1 [name], image
		FROM TemplateImages
		WHERE ImageID = ?

SELECT TOP 1 *
		FROM templates
		WHERE templateID = ?

SELECT TOP 1 *
		FROM ColorScheme
		WHERE CSID = ?

SELECT *
		FROM CustSiteAugmentingSiteXref
		WHERE CustID = ?
		  AND SiteID = ?

SELECT cm2.MenuName, x.*
		FROM CustMenu cm
		  INNER JOIN RSSPageXref x ON cm.CustID=x.CustID AND cm.SiteID=x.SiteID AND cm.MenuID=x.MenuID
		  INNER JOIN CustMenu cm2 ON cm2.CustID=x.CustID AND cm2.SiteID=x.SiteID AND cm2.MenuID=x.SourceMenuID
		WHERE cm.CustID = ?
		  AND cm.SiteID = ?
		  AND cm.MenuType = 42

SELECT menuName
                        FROM custMenu
                        WHERE custID = 3261
                            AND siteID = 1
                            AND menuID = 5

SELECT COUNT(*) AS LoginCnt
	FROM CustMenu
	WHERE custid = ?
		AND siteID = ?
		AND visible = 'C'

SELECT CASE TypeAction
				WHEN 0 THEN menuURL	
				WHEN 1 THEN MenuHRef + '&mid=' + LTRIM(STR(menuID))		
				WHEN 2 THEN menuURL									
				WHEN 3 THEN MenuHRef + '&mid=' + LTRIM(STR(menuID))		
				WHEN 4 THEN MenuHRef + '&mid=' + LTRIM(STR(menuID))		
				WHEN 5 THEN MenuHRef + '&mid=' + LTRIM(STR(menuID))		
				WHEN 6 THEN MenuHRef + '&mid=' + LTRIM(STR(menuID))		
				WHEN 7 THEN MenuHRef + '&mid=' + LTRIM(STR(menuID))		
				ELSE 'index.cfm'		
			END AS useThisHref, *
		FROM CustMenu c
			INNER JOIN MenuTypes m ON c.MenuType = m.TypeID
		WHERE c.CustID = ?
			AND c.SiteID = ?
			AND c.Visible = ?
		ORDER BY menusort

SELECT [Name], Rank, Depth
					FROM TemplateMenu
					WHERE TemplateID = ?
					ORDER BY Rank

SELECT DTNMenu, InvisibleDtnMenu
	FROM CustTemplate
	WHERE CustID = ?
		AND SiteID = ?

SELECT i.SiteMenuItemID
					,i.MenuID
					,i.NodeType
					,i.ParentNodeID
					,i.NodeDesc
					,i.NodeAliasName
					,i.SortOrder
					,i.MenuRank
					,CASE i.NodeType
						WHEN 1 THEN 
							CASE WHEN mt.TypeAction IN (0,2) THEN cm.MenuURL
							ELSE mt.MenuHRef + '&mid=' + LTRIM(STR(cm.menuID)) END
						ELSE NULL 
					END AS URL
					,cm.MenuTarget
					,mt.TypeAction
					,cm.MenuType
					,cm.PageOrder
					,cm.windowSize
					,CASE i.NodeType
						When 1 Then
							CASE 
								When cm.visible = 'N' Then 'N'
								When cm.visible = 'C' Then 'C'
								ELSE 'Y' 
							END
						WHEN 0 THEN
							CASE 
								WHEN CHARINDEX(','+CONVERT(varchar(10),i.MenuID)+',',?) > 0 THEN 'Y'
								ELSE 'N' 
							END
						WHEN 2 THEN 'Y'
						WHEN 3 THEN 'N'
						ELSE NULL
					END AS Visible,
					CASE i.NodeType
						WHEN 1 THEN cm.MenuSecurity
						ELSE NULL
					END AS MenuSecurity
			FROM SiteMenuItem i
				LEFT OUTER JOIN CustMenu cm ON i.CustID = cm.CustID AND i.SiteID = cm.SiteID AND i.MenuID = cm.MenuID AND i.NodeType = 1
				LEFT OUTER JOIN MenuTypes mt ON cm.MenuType = mt.TypeID
			WHERE i.CustID = ?
				AND i.SiteID = ?
				AND i.MenuRank = ?
				AND i.NodeType IN (1,2,0)
			ORDER BY SortOrder

SELECT DTNMenu, InvisibleDtnMenu
	FROM CustTemplate
	WHERE CustID = ?
		AND SiteID = ?

SELECT i.SiteMenuItemID
					,i.MenuID
					,i.NodeType
					,i.ParentNodeID
					,i.NodeDesc
					,i.NodeAliasName
					,i.SortOrder
					,i.MenuRank
					,CASE i.NodeType
						WHEN 1 THEN 
							CASE WHEN mt.TypeAction IN (0,2) THEN cm.MenuURL
							ELSE mt.MenuHRef + '&mid=' + LTRIM(STR(cm.menuID)) END
						ELSE NULL 
					END AS URL
					,cm.MenuTarget
					,mt.TypeAction
					,cm.MenuType
					,cm.PageOrder
					,cm.windowSize
					,CASE i.NodeType
						When 1 Then
							CASE 
								When cm.visible = 'N' Then 'N'
								When cm.visible = 'C' Then 'C'
								ELSE 'Y' 
							END
						WHEN 0 THEN
							CASE 
								WHEN CHARINDEX(','+CONVERT(varchar(10),i.MenuID)+',',?) > 0 THEN 'Y'
								ELSE 'N' 
							END
						WHEN 2 THEN 'Y'
						WHEN 3 THEN 'N'
						ELSE NULL
					END AS Visible,
					CASE i.NodeType
						WHEN 1 THEN cm.MenuSecurity
						ELSE NULL
					END AS MenuSecurity
			FROM SiteMenuItem i
				LEFT OUTER JOIN CustMenu cm ON i.CustID = cm.CustID AND i.SiteID = cm.SiteID AND i.MenuID = cm.MenuID AND i.NodeType = 1
				LEFT OUTER JOIN MenuTypes mt ON cm.MenuType = mt.TypeID
			WHERE i.CustID = ?
				AND i.SiteID = ?
				AND i.MenuRank = ?
				AND i.NodeType IN (1,2,0)
			ORDER BY SortOrder

SELECT DTNMenu, InvisibleDtnMenu
	FROM CustTemplate
	WHERE CustID = ?
		AND SiteID = ?

SELECT i.SiteMenuItemID
					,i.MenuID
					,i.NodeType
					,i.ParentNodeID
					,i.NodeDesc
					,i.NodeAliasName
					,i.SortOrder
					,i.MenuRank
					,CASE i.NodeType
						WHEN 1 THEN 
							CASE WHEN mt.TypeAction IN (0,2) THEN cm.MenuURL
							ELSE mt.MenuHRef + '&mid=' + LTRIM(STR(cm.menuID)) END
						ELSE NULL 
					END AS URL
					,cm.MenuTarget
					,mt.TypeAction
					,cm.MenuType
					,cm.PageOrder
					,cm.windowSize
					,CASE i.NodeType
						When 1 Then
							CASE 
								When cm.visible = 'N' Then 'N'
								When cm.visible = 'C' Then 'C'
								ELSE 'Y' 
							END
						WHEN 0 THEN
							CASE 
								WHEN CHARINDEX(','+CONVERT(varchar(10),i.MenuID)+',',?) > 0 THEN 'Y'
								ELSE 'N' 
							END
						WHEN 2 THEN 'Y'
						WHEN 3 THEN 'N'
						ELSE NULL
					END AS Visible,
					CASE i.NodeType
						WHEN 1 THEN cm.MenuSecurity
						ELSE NULL
					END AS MenuSecurity
			FROM SiteMenuItem i
				LEFT OUTER JOIN CustMenu cm ON i.CustID = cm.CustID AND i.SiteID = cm.SiteID AND i.MenuID = cm.MenuID AND i.NodeType = 1
				LEFT OUTER JOIN MenuTypes mt ON cm.MenuType = mt.TypeID
			WHERE i.CustID = ?
				AND i.SiteID = ?
				AND i.MenuRank = ?
				AND i.NodeType IN (1,2,0)
			ORDER BY SortOrder

SELECT WxDomain, WxHour, WxKey
		FROM   AgWxKey
		WHERE  Id = 1

SELECT adSlotID, menuID, menuName
			FROM custMenu
			WHERE custID = ?
				AND siteID = ?
				AND menuID = ?

SELECT menuTarget
	FROM custMenu
	WHERE custID = ?
	  AND siteID = ?
	  AND menuId = ? --WE ARE ON JAVASCRIPT

SELECT *
    	FROM custMenu
    	WHERE custID = ?
    		AND siteID = ?
    		AND menuID = ?

SELECT menuTarget
	FROM custMenu
	WHERE menuid = 5
	  AND custID = ?
      AND siteID = ?
	  -- calendarQuieries.cfm

SELECT *
		FROM siteCalendarPrefs
		WHERE custID = ?
			AND siteID = ?
			
	        AND CalendarID = ?

SELECT *
	FROM calendarEvent
	WHERE   ( custID = ? 
              OR custID IS NULL )
		AND ( siteID = ?
              OR siteID IS NULL )
		AND ( calendarID = ? OR calendarID IS NULL ) 
        AND status = 'A'
		AND calEventTypeID IN (	SELECT calEventTypeID
								FROM siteCalEventTypes
								WHERE custID = ?
									AND siteID = ?
									
									AND CalendarID = ?
							)
		AND startDate <= {ts '2026-10-31 23:59:59'} AND endDate >= {ts '2026-10-01 00:00:00'} 
		AND (
				(	calendarEventID NOT IN	(	SELECT calendarEventID
												FROM custUserGrpEventXRef
												WHERE custID = ?
													AND siteID = ?
													
													AND CalendarID = ?
											)
				)
				
			)
	ORDER BY startDate

SELECT calendarEventID
			FROM custUserGrpEventXRef
			WHERE custID = ?
				AND siteID = ?
				AND calendarID = ?

SELECT pl.*
			FROM CustMenu cm INNER JOIN pageLayout pl
	            ON pl.pageLayoutID = cm.pageDefaultLayout
		    WHERE CustID = ?  
				AND SiteID = ?
				AND menuID = ?
				AND menuType IN ( 	SELECT typeID 
									FROM menuTypes
									WHERE typeName = 'Calendar' 
								)

SELECT *
	FROM calendarEvent
	WHERE   ( custID = ? 
              OR custID IS NULL )
		AND ( siteID = ?
              OR siteID IS NULL )
		AND ( calendarID = ? OR calendarID IS NULL ) 
        AND status = 'A'
		AND calEventTypeID IN (	SELECT calEventTypeID
								FROM siteCalEventTypes
								WHERE custID = ?
									AND siteID = ?
									
									AND CalendarID = ?
							)
		AND startDate <= {ts '2026-10-31 23:59:59'} AND endDate >= {ts '2026-10-01 00:00:00'} 
		AND (
				(	calendarEventID NOT IN	(	SELECT calendarEventID
												FROM custUserGrpEventXRef
												WHERE custID = ?
													AND siteID = ?
													
													AND CalendarID = ?
											)
				)
				
			)
	ORDER BY startDate

SELECT *
		FROM custMenu
		WHERE custID = ?
			AND siteID = ?
			AND menuID = ? 
			AND menuType IN (	SELECT typeID FROM menuTypes WHERE typeName = 'Calendar' )

SELECT *
		FROM calendarQuip

SELECT *
	FROM calendarEvent
	WHERE   ( custID = ? 
              OR custID IS NULL )
		AND ( siteID = ?
              OR siteID IS NULL )
		AND ( calendarID = ? OR calendarID IS NULL ) 
        AND status = 'A'
		AND calEventTypeID IN (	SELECT calEventTypeID
								FROM siteCalEventTypes
								WHERE custID = ?
									AND siteID = ?
									
									AND CalendarID = ?
							)
		AND startDate <= {ts '2026-07-31 23:59:59'} AND endDate >= {ts '2026-07-01 00:00:00'} 
		AND (
				(	calendarEventID NOT IN	(	SELECT calendarEventID
												FROM custUserGrpEventXRef
												WHERE custID = ?
													AND siteID = ?
													
													AND CalendarID = ?
											)
				)
				
			)
	ORDER BY startDate

SELECT CalendarEventID,CustID,SiteID,CalEventTypeID,StartDate,EndDate,TimeRange,EventTitle,EventText,MenuID,Status,UserID,CalendarID
					FROM getCalendarEvents
					WHERE StartDate = ?