SELECT
    CAST(IFNULL(spd.`name`, otcp.description) AS CHAR) AS fop
FROM yii_doc.orders o
LEFT JOIN yii_doc.orders_spd os ON o.id = os.order_id
-- ФОП-ы для новой почты
LEFT JOIN yii_doc.order_contact_person ocp
    ON o.order_delivery_id IN (
        :NOVA_POSHTA_DELIVERY_ID,
        :NOVA_POSHTA_DVERI_DELIVERY_ID
    )
    AND o.id = ocp.order_id
-- ФОП-ы для всех остальных (самовывоз, курьерка)
LEFT JOIN yii_doc.spd ON (
    (o.spd_id IS NOT NULL AND o.spd_id = spd.id)
    OR (o.spd_id IS NULL AND ocp.order_id IS NULL AND os.spd_id = spd.id)
)
LEFT JOIN yii_doc.order_ttn_contact_persons otcp ON ocp.contact_person_id = otcp.id
LEFT JOIN yii_doc.order_delivery od ON o.order_delivery_id = od.id
WHERE o.id = :ORDER_ID;