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 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 WxDomain, WxHour, WxKey
		FROM   AgWxKey
		WHERE  Id = 1

SELECT dbo.getServiceCodes(2023, 1, getDate(), getDate()) AS theServiceCodes

SELECT commid, f.[Name], Exchange, RTRIM(commid) + '0' as symbolForList
			FROM Futures f
				INNER JOIN FuturesGroupTypeXref x ON x.FuturesID = f.FuturesID
				INNER JOIN Exchange e ON f.Market = e.ExchangeId
			WHERE x.FuturesGroupTypeID = ?
				AND f.valid = 1
   			AND (
					e.Premium = 0 
					
				)
			ORDER BY x.SeqID, f.[Name]

SELECT e.realtimeonly, commid
			FROM Futures f
			LEFT JOIN Exchange e on e.name = f.exchange  
			WHERE e.realtimeonly = 1

SELECT realtimeonly, commid
				FROM checkRealtimeOnlyPrimer
				WHERE commid = ?

SELECT realtimeonly, commid
				FROM checkRealtimeOnlyPrimer
				WHERE commid = ?

SELECT realtimeonly, commid
				FROM checkRealtimeOnlyPrimer
				WHERE commid = ?

SELECT PrefValue
	FROM CustSitePreferences
	WHERE CustID = ?
		AND SiteID = ?
		AND PrefName = ?

SELECT e.realtimeonly, commid
			FROM Futures f
			LEFT JOIN Exchange e on e.name = f.exchange  
			WHERE e.realtimeonly = 1

SELECT realtimeonly, commid
				FROM checkRealtimeOnlyPrimer
				WHERE commid = ?

SELECT TOP 1 e.Title, e.Link, e.PublishDate, e.BlogHandle, b.AuthorName, b.AuthorTitle, b.AuthorID, b.DTNAuthorPageId
		FROM DTNBlogEntry e
		INNER JOIN DTNBlog b
			ON e.BlogHandle = b.BlogHandle
		WHERE e.BlogHandle = 'grainmarkets'
			AND b.Active = 1
		ORDER BY e.SeqID

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

SELECT TOP 1 PromoHtml
			FROM AgInfoCategoryPromo
			WHERE (ShowValue = ? OR ShowValue IS NULL)
				AND Type = ? 
			ORDER BY Exclusive DESC, newID()

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