select t.product_id
,count(*) as cnt
from product_info t
left join user_client_log t1 on t.product_id=t1.product_id
where t1.step='order'
group by t.product_id
limit 1