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(*,'"锟斤拷锟斤拷锟斤拷询" and "ANBOUND"')
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(*,'"锟斤拷锟斤拷锟斤拷询" and "ANBOUND"')
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(*,'"锟斤拷锟斤拷锟斤拷询" and "ANBOUND"')
)a order by adddate desc
凡本网站转载的文章,均由原载媒体审核后发表,仅反映原作者自己的观点,不代表“第一智库”网站的观点。
中国-东盟基金·安邦合作项目 中信信睿·安邦合作项目
(安邦集团)北京安邦世纪国际咨询有限公司版权所有 | Copyright © 1993-2013 Anbound