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;