| 标题 |
日期 |
作者 |
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(*,'"DF" and "CE"')
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(*,'"DF" and "CE"')
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(*,'"DF" and "CE"')
)a order by adddate desc
| 大数据在应急管理中的应用 | 2015年12月31日 | 马奔 山东大学政治学与公共管理学院副教授、副院长,研究领域:协商民主、公共治理、风险和公共危机管理等,著有《协商民主-民主理论的变迁与实践》等 毛庆铎 山东大学政治学与公共管理学院硕士研究生 |