select TOP 4 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}','{9779BADC-92F4-444A-97D9-35B1062DBC7A}')) AND cd.ChannelID = c.ChannelID AND cd.Status IN (1) AND (GetDate() BETWEEN IsNull(PublishStart,GetDate()) AND IsNull(PublishStop,GetDate()+1)) AND ( CharIndex(', Student Programming,',', ' + Category + ',') > 0 ) AND ( isnull(stopdatetime,startdatetime) >= left(getdate(),11) and startdatetime <= dateadd(day, 30, getdate()) ) ORDER BY StartDateTime,ListPosition