renamed sale.id to sale.sale_id