select
    if(pay_method='' , 'error',pay_method),
    count(*) as ranks
from
    user_client_log
    left join product_info using (product_id)
where
    product_name = 'anta' and step='select' 
group by 
    pay_method
order by
    ranks desc;