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 '%Spain%') UNION select top 1000 iRecord,1 as ord from tblBoardRecord_1800000121_37 Where idCorp=1800000121 and iProject=37 and (field2 like '%Spain%')) a where irecord<>49121 group by iRecord,ord order by ord asc,iRecord desc
中国投资指南网
Spain's economic growth to slow down: OECD
OECD revises up Spain's economic growth for 2017
Spain's consumer confidence rises by 0.5 points in August
Spain's inflation remains steady at 1.5 percent in July
Spain's economy grows by 0.9 pct in Q2