select
        uid,
        count(if(step = 'order',1,null)) as cnt
from 
        user_client_log
group by
        uid
order by
        cnt desc,
        uid
limit 3