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 = ?