Select distinct top 6 id,title,urlpath,moditime,color,tops From yb_cofeed_InfoList left join yb_cofeed_InfoCatalog on yb_cofeed_InfoList.id=yb_cofeed_InfoCatalog.infoid left join yb_cofeed_InfoChannels on yb_cofeed_InfoList.id=yb_cofeed_InfoChannels.infoid Where catalogid in(311,436,427,316) and channelsId in(135,331,332,333) and and encrpty=1 Order by moditime desc,id desc
