| 标题 |
日期 |
作者 |
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(*,'"AA" and "BA"')
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(*,'"AA" and "BA"')
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(*,'"AA" and "BA"')
)a order by adddate desc
| 社会组织与亲属制度研究 | 2017年04月13日 | 张岩 北京市艺术研究所研究员,著有《简论汉代以来诗经学中的误解》等 |