标题 |
日期 |
作者 |
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(*,'"Chen" and "Gong"')
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(*,'"Chen" and "Gong"')
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(*,'"Chen" and "Gong"')
)a order by adddate desc
Chen Gong: China's SOEs Reform is Full of Obstacles | 2014年02月18日 | Chen Gong Chief Researcher, Anbound Think Tank |
Chen Gong: China's Products Enter Dilemma Price Range | 2014年02月17日 | Chen Gong Chief Researcher, Anbound Think Tank |
Chen Gong: Dissymmetric Appreciation of RMB is a Lost to China | 2014年02月12日 | Chen Gong Chief Researcher, Anbound Think Tank |
Chen Gong: China's Fundamental Farmland Amount Will Retrigger Attention | 2014年01月29日 | Chen Gong Chief Researcher, Anbound Think Tank |
Chen Gong: System Analysis on the "Shock" of Global Emerging Markets | 2014年01月28日 | Chen Gong Chief Researcher, Anbound Think Tank |
Chen Gong: Vanity Projects and Government Waste are The Real"Risk Exposures" | 2014年01月23日 | Chen Gong Chief Researcher, Anbound Think Tank |
Chen Gong: China's Economic Growth Rate Will Gradually Decline to 7%, 6% and 5% over next 30 Years | 2014年01月22日 | Chen Gong Chief Researcher, Anbound Think Tank |
Chen Gong: China Should Expand Its Stock Market Openness | 2014年01月17日 | Chen Gong Chief Researcher, Anbound Think Tank |
Chen Gong: China Suddenly Modifies Several Important Haze Data | 2014年01月16日 | Chen Gong Chief Researcher, Anbound Think Tank |
Chen Gong: Do Not Misinterpret "Mixed Ownership" | 2014年01月03日 | Chen Gong Chief Researcher, Anbound Think Tank |
CHEN GONG: How Big Is the Impact of Fed's QE Withdrawal on China? | 2013年12月25日 | Chen Gong Chief Researcher, Anbound Think Tank |
CHEN GONG: What Is The Implication of China's Mineral Demand? | 2013年12月23日 | Chen Gong Chief Researcher, Anbound Think Tank |
Chen Gong: Greater Risks of Nuclear Power Accidents | 2013年12月23日 | Chen Gong Chief Researcher, Anbound Think Tank |
CHEN GONG:Original Eco-Industrial Zone in China | 2013年12月17日 | Chen Gong Chief Researcher, Anbound Think Tank |
Chen Gong: Local Governments Pays More Attention To Starbucks Than Bookstore | 2013年12月16日 | Chen Gong Chief Researcher, Anbound Think Tank |
Chen Gong: Stable Housing Price Equals To Stable Economy | 2013年12月13日 | Chen Gong Chief Researcher, Anbound Think Tank |
Chen Gong: China's "Separation of Powers" | 2013年12月11日 | Chen Gong Chief Researcher, Anbound Think Tank |
Chen Gong:China's Housing Prices are Stabilizing | 2013年12月06日 | Chen Gong Chief Researcher, Anbound Think Tank |
Chen Gong: Foreign Investment Should Be a Balanced Systematic Project | 2013年11月20日 | Chen Gong Chief Researcher, Anbound Think Tank |
Chen Gong:China Needs Steady Reform | 2013年11月19日 | Chen Gong Chief Researcher, Anbound Think Tank |
Chen Gong: China's Property Market Affects Social Safety Net | 2013年11月14日 | Chen Gong Chief Researcher, Anbound Think Tank |
Chen Gong Cautions on the SOEs | 2013年11月04日 | Chen Gong Chief Researcher, Anbound Think Tank |
Chen Gong: Polluted Asset Is Not Collateral for Compensation | 2013年11月01日 | Chen Gong Chief Researcher, Anbound Think Tank |
Chen Gong's View on Social Elite Metabolism | 2013年07月22日 | Chen Gong Chief Researcher, Anbound Think Tank |
Chen Gong: Chinese Society is Moving towards Risky Confrontation | 2013年04月16日 | Chen Gong Chief Researcher, Anbound Think Tank |