SELECT
    `sale_internals_payment`.`ID` AS `ID`,
    `sale_internals_payment`.`ORDER_ID` AS `ORDER_ID`,
    `sale_internals_payment`.`ACCOUNT_NUMBER` AS `ACCOUNT_NUMBER`,
    `sale_internals_payment`.`PAID` AS `PAID`,
    `sale_internals_payment`.`DATE_PAID` AS `DATE_PAID`,
    `sale_internals_payment`.`EMP_PAID_ID` AS `EMP_PAID_ID`,
    `sale_internals_payment`.`PAY_SYSTEM_ID` AS `PAY_SYSTEM_ID`,
    `sale_internals_payment`.`PS_STATUS` AS `PS_STATUS`,
    `sale_internals_payment`.`PS_STATUS_CODE` AS `PS_STATUS_CODE`,
    `sale_internals_payment`.`PS_INVOICE_ID` AS `PS_INVOICE_ID`,
    `sale_internals_payment`.`PS_STATUS_DESCRIPTION` AS `PS_STATUS_DESCRIPTION`,
    `sale_internals_payment`.`PS_STATUS_MESSAGE` AS `PS_STATUS_MESSAGE`,
    `sale_internals_payment`.`PS_SUM` AS `PS_SUM`,
    `sale_internals_payment`.`PS_CURRENCY` AS `PS_CURRexpElNCY`,
    `sale_internals_payment`.`PS_RESPONSE_DATE` AS `PS_RESPONSE_DATE`,
    `sale_internals_payment`.`PAY_VOUCHER_NUM` AS `PAY_VOUCHER_NUM`,
    `sale_internals_payment`.`PAY_VOUCHER_DATE` AS `PAY_VOUCHER_DATE`,
    `sale_internals_payment`.`DATE_PAY_BEFORE` AS `DATE_PAY_BEFORE`,
    `sale_internals_payment`.`DATE_BILL` AS `DATE_BILL`,
    `sale_internals_payment`.`XML_ID` AS `XML_ID`,
    `sale_internals_payment`.`SUM` AS `SUM`,
    `sale_internals_payment`.`PRICE_COD` AS `PRICE_COD`,
    `sale_internals_payment`.`CURRENCY` AS `CURRENCY`,
    `sale_internals_payment`.`PAY_SYSTEM_NAME` AS `PAY_SYSTEM_NAME`,
    `sale_internals_payment`.`RESPONSIBLE_ID` AS `RESPONSIBLE_ID`,
    `sale_internals_payment`.`EMP_RESPONSIBLE_ID` AS `EMP_RESPONSIBLE_ID`,
    `sale_internals_payment`.`DATE_RESPONSIBLE_ID` AS `DATE_RESPONSIBLE_ID`,
    `sale_internals_payment`.`COMMENTS` AS `COMMENTS`,
    `sale_internals_payment`.`COMPANY_ID` AS `COMPANY_ID`,
    `sale_internals_payment`.`PAY_RETURN_NUM` AS `PAY_RETURN_NUM`,
    `sale_internals_payment`.`PAY_RETURN_DATE` AS `PAY_RETURN_DATE`,
    `sale_internals_payment`.`EMP_RETURN_ID` AS `EMP_RETURN_ID`,
    `sale_internals_payment`.`PAY_RETURN_COMMENT` AS `PAY_RETURN_COMMENT`,
    `sale_internals_payment`.`IS_RETURN` AS `IS_RETURN`,
    `sale_internals_payment`.`UPDATED_1C` AS `UPDATED_1C`,
    `sale_internals_payment`.`ID_1C` AS `ID_1C`,
    `sale_internals_payment`.`VERSION_1C` AS `VERSION_1C`,
    `sale_internals_payment`.`EXTERNAL_PAYMENT` AS `EXTERNAL_PAYMENT`,
    `sale_internals_payment_company_by`.`NAME` AS `COMPANY_BY_NAME`,
    `sale_internals_payment_responsible_by`.`NAME` AS `RESPONSIBLE_BY_NAME`,
    `sale_internals_payment_responsible_by`.`LAST_NAME` AS `RESPONSIBLE_BY_LAST_NAME`,
    `sale_internals_payment_order`.`ACCOUNT_NUMBER` AS `ORDER_ACCOUNT_NUMBER`,
    `sale_internals_payment_order`.`USER_ID` AS `ORDER_USER_ID`
FROM `b_sale_order_payment` `sale_internals_payment`
LEFT JOIN `b_sale_company` `sale_internals_payment_company_by` ON `sale_internals_payment`.`COMPANY_ID` = `sale_internals_payment_company_by`.`ID`
LEFT JOIN `b_user` `sale_internals_payment_responsible_by` ON `sale_internals_payment`.`RESPONSIBLE_ID` = `sale_internals_payment_responsible_by`.`ID`
LEFT JOIN `b_sale_order` `sale_internals_payment_order` ON `sale_internals_payment`.`ORDER_ID` = `sale_internals_payment_order`.`ID`
ORDER BY `sale_internals_payment`.`ORDER_ID` DESC
LIMIT 0, 20