| 标题 |
日期 |
作者 |
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(*,'"DC" and "BD" and "DC"')
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(*,'"DC" and "BD" and "DC"')
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(*,'"DC" and "BD" and "DC"')
)a order by adddate desc
| 新兴大国气候政治群体化的形成机制——集体身份理论视角 | 2014年05月20日 | 赵斌 武汉大学政治与公共管理学院国际关系学系博士研究生,研究方向:国家战 略与外交政策、全球气候政治 |