---

-- Какие типы платежей вообще есть в incoming_order?
SELECT 
    opt.id,
    opt.name,
    COUNT(io.id) AS cnt
FROM back_office.order_payment_type opt
LEFT JOIN back_office.incoming_order io 
    ON io.order_payment_type_id = opt.id
GROUP BY opt.id, opt.name
HAVING COUNT(io.id) > 0
ORDER BY cnt DESC