select uid,sum(totalcoin+total_livecoin) as totalcoin from cmf_users_coinrecord where type='expend' group by uid order by totalcoin desc limit 0,10