| 标题 |
日期 |
作者 |
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(*,'"FD" and "FA"')
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(*,'"FD" and "FA"')
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(*,'"FD" and "FA"')
)a order by adddate desc
| 先行先试，推进经贸活动自由化 | 2014年11月10日 | 陈明森 福建省委党校产业与企业研究院院长 唐永红 厦门大学台湾研究院经济研究所所长 张天潘 《南方都市报》记者 |