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

Select * from ( Select ID,Title,Convert(varchar(10),AddTime,121) AddDate,Convert(varchar(8),AddTime,112) PublishDateShort,Author,'ThinkTankArticleList' as InfoTBName From ThinkTankArticleList where IsShow=1 AND IsDeleted=0 AND DisplayLevel=0 AND Contains(*,'"CB" and "AD" and "FA" and "BC" and "CA" and "BE" and "AD" and "BC" and "BE" and "BF" and "CB"') union Select ID,Title,Convert(varchar(10),AddTime,121) AddDate,Convert(varchar(8),AddTime,112) PublishDateShort,Author,'MediaCoversList' as InfoTBName From MediaCoversList where IsShow=1 AND IsDeleted=0 AND DisplayLevel=0 AND Contains(*,'"CB" and "AD" and "FA" and "BC" and "CA" and "BE" and "AD" and "BC" and "BE" and "BF" and "CB"') union Select ID,Title,Convert(varchar(10),AddTime,121) AddDate,Convert(varchar(8),AddTime,112) PublishDateShort,Author,'ThinkTankTimeList' as InfoTBName From ThinkTankTimeList where IsShow=1 AND IsDeleted=0 AND DisplayLevel=0 AND Contains(*,'"CB" and "AD" and "FA" and "BC" and "CA" and "BE" and "AD" and "BC" and "BE" and "BF" and "CB"') )a order by adddate desc