select iRecord,ord,count(DISTINCT iRecord) from(select top 1000 iRecord,0 as ord from tblBoardRecord_1800000121_37 Where idCorp=1800000121 and iProject=37 and (field7 like '%Guangdong%') UNION select top 1000 iRecord,1 as ord from tblBoardRecord_1800000121_37 Where idCorp=1800000121 and iProject=37 and (field2 like '%Guangdong%')) a where irecord<>52357 group by iRecord,ord order by ord asc,iRecord desc
中国投资指南网
South China's Guangdong sets new target for economic growth this year
Guangdong reports robust foreign trade growth
Singapore, China's Guangdong enhance cooperation
Guangdong Province registers most social financing
Guangdong SOEs acquires HK bank