Spree::Order.complete.where('spree_orders.payment_state = :payment_state
  and spree_state_changes.previous_state = :previous_state
  and spree_state_changes.next_state = :payment_state
  and (spree_state_changes.updated_at >= :begins_at
    and spree_state_changes.updated_at < :ends_at)
  and not exists (select id from spree_state_changes where spree_orders.id = spree_state_changes.stateful_id',
  {
    payment_state: 'paid',
    previous_state: 'balance_due',
    begins_at: @begins_at,
    ends_at: @ends_at
  }).includes(:adjustments, :state_changes, line_items: :variant)