select pay_method,
 count(*) as  cnt
 from(
    select if(pay_method ='','error',pay_method)pay_method
    from user_client_log
    join product_info using(product_id)
    where step = 'select'
    and pay_method is not null
    and product_name = 'anta'
 )a
 group by pay_method
 order by cnt desc