select count(*) as MyCount from (select * from sl_news where cid1='2' order by  sort desc ) MyTempTable