SELECT
    ui.channel,
    COUNT(*) cnt
FROM order_log ol
RIGHT JOIN user_info ui ON ol.uid = ui.uid
WHERE ol.order_id IS NULL
GROUP BY ui.channel
ORDER BY cnt DESC, ui.channel
LIMIT 1