SELECT
    IF(LENGTH(ucl.pay_method) = 0, 'error', ucl.pay_method),
    COUNT(*) cnt
FROM user_client_log ucl
JOIN product_info pi ON pi.product_id = ucl.product_id
WHERE ucl.step = 'select' AND pi.product_name = 'anta'
GROUP BY ucl.pay_method
ORDER BY cnt DESC