SELECT
  DISTINCT o.id
FROM
  orders o
    INNER JOIN
  (SELECT order_id, SUM(line_total) as total FROM order_lines GROUP BY order_id) s
    ON o.id = s.order_id
WHERE
  o.order_total < s.total