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(1043, 1, getDate(), getDate()) AS theServiceCodes

SELECT weatherMenuID, title, map, imageMap
	FROM DTNWeatherMenu
	WHERE weatherMenuID = ?

SELECT TOP 1 City, State, Latitude, Longitude, Station_ID, Zip, TimeZone, DST
					, 'US' AS Country
				FROM   Zip
				WHERE  Zip = ?

SELECT DISTINCT  f.ValidDateTime
				                ,f.MinTemperature
				                ,f.MaxTemperature
				                ,f.AverageWSPD
				                ,f.AverageRelativeHumidity
				                ,f.POP24Hour
				                ,f.SnowPOP
				                ,f.FrzPrecipPop
				                ,f.MixPrecipPop
				                ,f.TstmPop24
				                ,f.Evapotranspiration
				                ,f.WeatherCode
				                ,f.Sunrise
				                ,f.Sunset
				                ,f.DewPoint
				                ,f.QOS24Hour
				                ,f.QOI24Hour
				                ,f.QOP24HourValue
				                ,f.MaxFeelsLikeTemperature
				                ,f.MinFeelsLikeTemperature
				                ,f.SunshineMinutes
				                ,f.SoilTemp
				                ,f.CornHeatUnits
				                ,f.GrowingDegreeDay
				                ,DateDiff(d, getUTCDate(),f.ValidDateTime)+1 AS theDay
				                ,s.IconFilename AS SkyIcon
				                ,s.Description AS SkyDesc
				                ,s.CharacterCode AS SkyCode
				                ,w.IconFilename AS WxIcon
				                ,w.Description AS WxDesc
				                ,w.CharacterCode AS WxCode
				FROM             mx_fc_clean f WITH (NOLOCK)
				INNER JOIN       (
				                  	SELECT StationID, ValidDateTime, MAX(PublishDTStamp) AS PublishDTStamp
				                  	FROM mx_fc_clean WITH (NOLOCK)
				                  	WHERE StationID = ?
				                  		AND DateDiff(d, getUTCDate(),ValidDateTime) BETWEEN 0 AND ?
				                  		AND MinTemperature IS NOT NULL
				                  		AND MaxTemperature IS NOT NULL
				                  	GROUP BY StationID, ValidDateTime
				                 ) t ON t.StationID = f.StationID AND t.ValidDateTime = f.ValidDateTime AND t.PublishDTStamp = f.PublishDTStamp
				LEFT OUTER JOIN  DTNSkyCode s ON LEFT(f.WeatherCode,2)=s.SkyCode
				LEFT OUTER JOIN  DTNWeatherCode w ON RIGHT(f.WeatherCode,2)=w.WeatherCode
				ORDER BY         f.ValidDateTime

SELECT DISTINCT TOP 1
				                  o.Temperature
				                 ,o.DewPoint
				                 ,o.HeatIndex
				                 ,o.RelativeHumidity
				                 ,o.WindChillTemp
				                 ,o.Winddirection
				                 ,(o.WindSpeed * 1.15077944802) AS WindSpeedMPH
				                 ,(o.WindGusts * 1.15077944802) AS WindGustsMPH
				                 ,(o.SeaLevelPressure * 0.029529987508 ) AS BarominHg
				                 ,o.CurrentWeather
				                 ,o.PublishDTStamp
				                 ,CASE o.SkyCover1
				                 	WHEN 'CLEAR' THEN 'Clear'
				                 	WHEN 'SCT' THEN 'Scattered'
				                 	WHEN 'BKN' THEN 'Broken'
				                 	WHEN 'OVC' THEN 'Overcast'
				                 	ELSE ''
				                 END AS SkyCover
				                 ,o.ValidDateTime
				                 ,DATEADD(hh,st.GMTOffset+ CASE WHEN st.ObservesDaylightTime = 'Y' THEN 1 ELSE 0 END,o.ValidDateTime) AS LocalValidDateTime
				                 ,o.FeelsLikeTemperature
				                 ,do.SoilTemp AS SoilTemperature
				
					             --,CASE WHEN o.ValidDateTime NOT BETWEEN sun.sunrise AND sun.sunset THEN 'n' ELSE 'd' END + COALESCE(owc.IconFilename,'missing') AS icon
								 ,CASE WHEN 
								 	CONVERT(TIME, DATEADD(hh, st.GMTOffset+ CASE WHEN st.ObservesDaylightTime = 'Y' THEN 1 ELSE 0 END, o.ValidDateTime)) 
									 	BETWEEN CONVERT(TIME, DATEADD(hh, st.GMTOffset+ CASE WHEN st.ObservesDaylightTime = 'Y' THEN 1 ELSE 0 END, sun.sunrise)) 
										AND 	CONVERT(TIME, DATEADD(hh, st.GMTOffset+ CASE WHEN st.ObservesDaylightTime = 'Y' THEN 1 ELSE 0 END, sun.sunset)) 
										THEN 'd' ELSE 'n' END + COALESCE(owc.IconFilename,'missing') 
								  AS icon
					             ,COALESCE(owc.Description,'No Report') AS ObsDescription
				FROM              mx_obs_clean o WITH (NOLOCK) 
				LEFT OUTER JOIN   DTNObsWeatherCode owc ON CurrentWeather = owc.ObsWeatherCode
				LEFT OUTER JOIN (
					SELECT ValidDateTime, MIN(Sunrise) AS Sunrise, MAX(Sunset) AS Sunset
					FROM mx_fc_clean WITH (NOLOCK)
					WHERE StationID = ?
					GROUP BY ValidDateTime
				) sun ON DATEDIFF(dd,sun.ValidDateTime,o.ValidDateTime) = 0

				
				INNER JOIN        mx_stations st ON st.StationID = o.StationID
				LEFT OUTER JOIN  (
				                  	SELECT TOP 1 CurrentSoilTemp AS SoilTemp
				                  	FROM mx_daily_obs_clean WITH (NOLOCK)
				                  	WHERE StationID = ?
				                  	ORDER BY ValidDateTime DESC
				                 ) do ON 1=1
				INNER JOIN       (
				                  	SELECT StationID, ValidDateTime, MAX(PublishDTStamp) AS PublishDTStamp
				                  	FROM mx_obs_clean WITH (NOLOCK)
				                  	WHERE StationID = ?
				                  	GROUP BY StationID, ValidDateTime
				                 ) t ON t.StationID = o.StationID AND t.ValidDateTime = o.ValidDateTime AND t.PublishDTStamp = o.PublishDTStamp
				WHERE             o.StationID = ?
				ORDER BY          o.ValidDateTime DESC, o.PublishDTStamp DESC

SELECT * 
			FROM   mx_Stations
			WHERE  StationID = ?

SELECT DISTINCT wm.title, wm.weatherMenuID, wm.externalLink, wm.target, wm.usSeq
	FROM DTNWeatherMenu wm
		INNER JOIN DTNWeatherMenuXRef x ON wm.weatherMenuID = x.weatherMenuID
	WHERE wm.parentID = 0
		AND wm.usSeq > 0
		AND x.serviceCode IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
	ORDER BY wm.usSeq,
	wm.title

SELECT   PublishDate, StorySummary, Content, Title, SubTitle
			FROM     AgOnlineNewsStory
			WHERE    Page = ?
			ORDER BY PublishDate DESC

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