select uid
,count(step) as cnt 
from user_client_log 
where step = "order"
group by uid
order by uid,cnt desc
limit 3 offset 0