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 '%substantial%') UNION select top 1000 iRecord,1 as ord from tblBoardRecord_1800000121_37 Where idCorp=1800000121 and iProject=37 and (field2 like '%substantial%')) a where irecord<>52387 group by iRecord,ord order by ord asc,iRecord desc
中国投资指南网
China and Georgia Concludes FTA Negotiation Substantially
Substantial Increase in Job Applicants of Suzhou Industrial Park
Changshu ETDZ achieved substantial growth in foreign investment
Chengdu’s Actual Utilized Foreign Capital in Q1 Shows Substantial Increase
60% of Chinese Enterprises Plan to Make a Substantial Adjustment in Business St