SELECT DISTINCT
    uid,
    COUNT(*) cnt
FROM user_client_log ucl
WHERE step = 'order'
GROUP BY uid
ORDER BY cnt DESC, uid
LIMIT 3