会员登录  免费注册  招聘信息  第一智库微博  安邦咨询  ANBOUND 高格全球文化项目论坛

Select * from ( Select ID,Title,Convert(varchar(10),AddTime,120) as AddDate,Convert(varchar(8),AddTime,112) as PublishDateShort,Author,'ThinkTankArticleList' as InfoTBName From ThinkTankArticleList where IsShow=1 AND IsDeleted=0 AND DisplayLevel=0 AND Contains(*,'"CF"') union All Select ID,Title,Convert(varchar(10),AddTime,120) as AddDate,Convert(varchar(8),AddTime,112) as PublishDateShort,Author,'MediaCoversList' as InfoTBName From MediaCoversList where IsShow=1 AND IsDeleted=0 AND DisplayLevel=0 AND Contains(*,'"CF"') union All Select ID,Title,Convert(varchar(10),AddTime,120) as AddDate,Convert(varchar(8),AddTime,112) as PublishDateShort,Author,'ThinkTankTimeList' as InfoTBName From ThinkTankTimeList where IsShow=1 AND IsDeleted=0 AND DisplayLevel=0 AND Contains(*,'"CF"') )a order by adddate desc