SELECT 
    product_id,
    sum(if(step='order',1,0)) AS cnt
FROM user_client_log
GROUP BY product_id
ORDER BY sum(if(step='order',1,0)) DESC 
LIMIT 1;