sql: = select top 6 cd.title, cd.content from channel c, channeldata cd where c.channelid=cd.channelid and c.channelid='E80B8BB5-77F0-4862-9A0E-4E1DB6731D31' and (c.status=1 and cd.status=1) and getdate() between isnull(publishstart,getdate()) and isnull(publishstop,getdate()+1) and cd.ItemId in (13799, 13655, 13464, 13509, 13769, 13768) order by NewID()