Quill compiled Query with .sortBy

//////////////////////////////////////////////////////QUERY////////////////////////////////////////////////////
val forQuery = quote {
        (
          for {
            (exp, com) <- expenses.join(companies).on((expense, company) => expense.providerId.contains(company.id.getOrElse(0L))) if exp.app == 15450 && exp.draft == false && myFunction(exp.dateRegistry) == lift(year.toInt)
            lines <- expenseLines.join(_.compra.contains(exp.id.getOrElse(0L))) if lines.baseAmount != 0 && myFunction2(lines.tipoGasto,"699%") && myFunction2(lines.tipoGasto,"475%")
          } yield ((exp, com), lines)
        ).sortBy(item => (item._1._1.dateRegistry, item._1._1.id))(Ord(Ord.asc, Ord.asc))
      }



//////////////////////////////////////////////////////ERROR////////////////////////////////////////////////////////////
[error] - application - Unknown column 'expense.total_expense' in 'field list'


//////////////////////////////////////////////////////COMPILED QUERY/////////////////////////////////////////////////////
SELECT x14.app, x14.id, x14.draft, x14.provider_id, x14.date, x14.date_registry, x14.document_type, x14.document_number, x14.cash_criterion, x14.annotations, x14.total_base, x14.total_tax, x14.total_retention, x14.total_surcharge, x14.total_expense, x14.total_paid, x14.total_left, x14.attachment_name, x14.attachment_url, x14.attachment_key, x14.created_on, x14.updated_on, x14.id, x14.address, x14.town, x14.postal_code, x14.bank_accounts, x14.cif, x14.tradename, x14.company_type, x14.country_code, x14.business_name, x14.created_on, x14.updated_on, x14.default_payment_method, x14.default_expense_type, x14.default_invoice_language, x14.default_surcharge, x14.personal_comment, x14.default_retention, x14.fax, x14.phone, x14.web, x14.region, x14.email, x14.contact_person, x14.initial_balance, x14.business_type, x14.name, x14.surname, x14.surname2, x14.normalized_cif, x14.app, x14.id, x14.is_draft, x14.is_investment, x14.concept, x14.base_amount, x14.tax, x14.tax_amount, x14.surcharge, x14.surcharge_amount, x14.retention, x14.imputation, x14.tipo_gasto, x14.investment_type, x14.investment_start_date, x14.investment_end_date, x14.investment_duration, x14.investment_used, x14.investment_base_amount, x14.investment_sell_amount, x14.investment_lost, x14.investment_lost_date, x14.compra, x14.provider_id, x14.date, x14.registration_date, x14.app FROM (SELECT expense.created_on created_on, expense.total_expense total_expense, expense.updated_on updated_on, expense.total_tax total_tax, expense.document_number document_number, expense.total_base total_base, expense.app app, expense.total_paid total_paid, expense.document_type document_type, expense.total_surcharge total_surcharge, expense.attachment_url attachment_url, expense.provider_id provider_id, expense.date date, expense.draft draft, expense.annotations annotations, expense.id id, expense.attachment_name attachment_name, expense.total_left total_left, expense.total_retention total_retention, expense.attachment_key attachment_key, expense.cash_criterion cash_criterion, expense.date_registry date_registry, company.cif cif, company.town town, company.bank_accounts bank_accounts, company.address address, company.region region, company.fax fax, company.default_expense_type default_expense_type, company.default_surcharge default_surcharge, company.updated_on updated_on, company.default_retention default_retention, company.surname2 surname2, company.phone phone, company.created_on created_on, company.default_invoice_language default_invoice_language, company.contact_person contact_person, company.email email, company.country_code country_code, company.postal_code postal_code, company.surname surname, company.normalized_cif normalized_cif, company.company_type company_type, company.web web, company.business_type business_type, company.initial_balance initial_balance, company.id id, company.business_name business_name, company.name name, company.personal_comment personal_comment, company.app app, company.tradename tradename, company.default_payment_method default_payment_method, x14.investment_sell_amount investment_sell_amount, x14.surcharge_amount surcharge_amount, x14.tax_amount tax_amount, x14.base_amount base_amount, x14.app app, x14.investment_lost_date investment_lost_date, x14.investment_end_date investment_end_date, x14.registration_date registration_date, x14.investment_type investment_type, x14.investment_used investment_used, x14.surcharge surcharge, x14.is_draft is_draft, x14.concept concept, x14.retention retention, x14.investment_duration investment_duration, x14.investment_lost investment_lost, x14.compra compra, x14.tax tax, x14.id id, x14.is_investment is_investment, x14.investment_start_date investment_start_date, x14.investment_base_amount investment_base_amount, x14.date date, x14.provider_id provider_id, x14.imputation imputation, x14.tipo_gasto tipo_gasto FROM app_compras expense INNER JOIN app_empresas company ON expense.proveedor = CASE WHEN company.id IS NOT NULL THEN company.id ELSE 0 END INNER JOIN app_lineas_compra x14 ON x14.compra = CASE WHEN expense.id IS NOT NULL THEN expense.id ELSE 0 END WHERE expense.app = 15450 AND expense.borrador = false AND YEAR(expense.fecha_registro) = ? AND x14.base_imponible <> 0 AND x14.tipo_gasto not like '699%' AND x14.tipo_gasto not like '475%') x14 ORDER BY x14.date_registry ASC, x14.id ASC