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