SELECT transaction_history.account_id,

           transaction_history.amount,

           transaction_history.amount_national,

           transaction_history.budget_code,

           transaction_history.currency,

           transaction_history.is_deleted,

           transaction_history.document_number,

           transaction_history.external_id,

           transaction_history.history_date,

           transaction_history.id,

           transaction_history.is_credit,

           ppc.name     payment_purpose_code_name,

           ppc.code     payment_purpose_code,

           transaction_history.operation_type,

           transaction_history.order_payer,

           transaction_history.order_receiver,

           transaction_history.payer,

           transaction_history.payer_account,

           transaction_history.payer_bank,

           transaction_history.payer_bank_bik,

           transaction_history.payer_bank_place,

           transaction_history.payer_bank_place_type,

           transaction_history.payer_bank_type,

           transaction_history.payer_bin,

           transaction_history.payer_corr_account,

           transaction_history.payer_property_type,

           transaction_history.payer_residency_code,

           transaction_history.payment_purpose,

           transaction_history.payment_purpose_code_id,

           transaction_history.receiver,

           transaction_history.receiver_account,

           transaction_history.receiver_account_bik,

           transaction_history.receiver_bank,

           transaction_history.receiver_bank_place,

           transaction_history.receiver_bank_place_type,

           transaction_history.receiver_bank_type,

           transaction_history.receiver_bin,

           transaction_history.receiver_corr_account,

           transaction_history.receiver_property_type,

           transaction_history.receiver_residency_code,

           transaction_history.value_date,

           accounts.account_number

      FROM transaction_history

           INNER JOIN accounts ON accounts.id = transaction_history.account_id

           LEFT JOIN payment_purpose_code ppc

               ON ppc.id = transaction_history.payment_purpose_code_id

     WHERE     (transaction_history.is_deleted = :1)

           AND (transaction_history.account_id = :2)

           AND (transaction_history.history_date BETWEEN TO_DATE ( :3,

                                                                  'YYYY.MM.DD')

                                                     AND TO_DATE ( :4,

                                                                  'YYYY.MM.DD'))

  ORDER BY history_date DESC, transaction_history.id DESC

    OFFSET 0 ROWS

FETCH NEXT 10 ROWS ONLY