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 '%manufacturing%') UNION select top 1000 iRecord,1 as ord from tblBoardRecord_1800000121_37 Where idCorp=1800000121 and iProject=37 and (field2 like '%manufacturing%')) a where irecord<>52416 group by iRecord,ord order by ord asc,iRecord desc
中国投资指南网
China's electronic information manufacturing sees revenue growth in Jan.-Aug.
Argentine manufacturing sector shrinks 9.4 pct in H1
U.S. manufacturing sector shows soft expansion in March
U.S. manufacturing activity growth slower in February: survey
Singapore's manufacturing output decreases 3.1 pct in January