Events

select TOP 8 ItemID,Title,SourceURL,SourceURLPopWin,SubTitle,TeaserText,RelatedURL,RelatedURLPopWin,c.DetailURL, Subtitle,StartDateTime,StopDateTime FROM ChannelData cd, Channel c WHERE (cd.ChannelID IN ('{DDB81D32-43CA-4FC1-AB6D-9EE7E4427BEE}')) AND cd.ChannelID = c.ChannelID AND cd.Status IN (1) AND (GetDate() BETWEEN IsNull(PublishStart,GetDate()) AND IsNull(PublishStop,GetDate()+1)) AND ( CharIndex(', Doheny Events,',', ' + Category + ',') > 0 ) AND ( isnull(stopdatetime,startdatetime) >= left(getdate(),11) and startdatetime <= dateadd(day, 30, getdate()) ) ORDER BY StartDateTime,ListPosition