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 '%Hefei%') UNION select top 1000 iRecord,1 as ord from tblBoardRecord_1800000121_37 Where idCorp=1800000121 and iProject=37 and (field2 like '%Hefei%')) a where irecord<>42695 group by iRecord,ord order by ord asc,iRecord desc
中国投资指南网
Hefei to Build Provincial-Level Big Data Industrial Park
The 9th Hefei Agricultural Fair to Kick Off
Hefei's Foreign Trade up 40% in H1
Hefei Approved as Model Pilot City for “Made in China 2025”
Hefei to Build Intelligent Energy Innovation Platform