| 标题 |
日期 |
作者 |
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(*,'"BC" and "AD" and "ED" and "AD"')
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(*,'"BC" and "AD" and "ED" and "AD"')
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(*,'"BC" and "AD" and "ED" and "AD"')
)a order by adddate desc
| 传统中的变革与变革中的传统 | 2017年06月30日 | 郑戈 上海交通大学凯原法学院教授,研究领域:法理学、宪法、行政法和刑事司法,著有《西方法律思想史》等 |