LA Cultural Events

select TOP 20 ItemID,Title,SourceURL,SourceURLPopWin,SubTitle,TeaserText,RelatedURL,RelatedURLPopWin,c.DetailURL, Subtitle,StartDateTime,StopDateTime FROM ChannelData cd, Channel c WHERE (cd.ChannelID IN ('{E7891C88-43CB-4690-8B83-7EC41942ACC6}')) AND cd.ChannelID = c.ChannelID AND cd.Status IN (1) AND (GetDate() BETWEEN IsNull(PublishStart,GetDate()) AND IsNull(PublishStop,GetDate()+1)) AND ( CharIndex(', CCF,',', ' + Category + ',') > 0 ) AND ( IsNull(StopDateTime,StartDateTime) >= LEFT(GETDATE(),11) AND StartDateTime <= DATEADD(day, 120, GETDATE()) ) ORDER BY StartDateTime,ListPosition