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 '%Egypt%') UNION select top 1000 iRecord,1 as ord from tblBoardRecord_1800000121_37 Where idCorp=1800000121 and iProject=37 and (field2 like '%Egypt%')) a where irecord<>52109 group by iRecord,ord order by ord asc,iRecord desc
中国投资指南网
Egypt's forex reserves rise to 44.46 bln USD
Egypt's annual core inflation declines to 8.5 pct in July: central bank
Egypt's growth rate hits 5.3 pct, highest in 10 years
Egypt's 4.1-pct economic growth exceeds gov't expectations
Egypt's annual inflation rises to 29.6 pct, highest since pound float