ыйд

SELECT o.*, op.*, SUM(quantity * price) AS total
FROM order_variant ov
     INNER JOIN `order` o
         ON o.id = ov.order_id
    left join order_promotion op on o.id = op.order_id
where o.status < 5
GROUP BY ov.order_id;