select
    product_id,
    sum(
        case
            when step = 'order' then 1
            else 0
        end
    ) cnt
from
    user_client_log
group by
    product_id
order by
    product_id
limit
    1