SELECT
    FLDEXTERNALNUMBER AS VSP_NUMBER,
    FLDORGANIZATIONUNID AS CLIENT_ID,
    LOCALSYSTEMID AS ORDER_ID,
    FLDORDERNUMBER AS ORDER_NUMBER,
    FLDWFSTATUS AS ORDER_STATUS,
    PERSISTDATE AS ORDER_DATE
FROM
    esb.ORDERCMS
WHERE 1=1
    AND VERSION = 0
    AND DELETED = 0
    AND FLDORDERNUMBER IS NOT NULL
    AND FLDWFSTATUS IN ('Услуга эксплуатируется', 'Тестирование услуги', 'Выполняется отключение', 'Экстренное включение', 'Приемка клиентом')
    AND FLDORGANIZATIONUNID IS NOT NULL
    AND LOCALSYSTEMID IS NOT NULL
    AND ENDDATE > CURRENT_TIMESTAMP
    AND FLDEXTERNALNUMBER =
    (
    SELECT
        FLDEXTERNALNUMBER
    FROM
        (
        SELECT
            FLDEXTERNALNUMBER,
            COUNT(*)
        FROM
            ESB.ORDERCMS sample (0.1) o
        WHERE 1=1
            AND VERSION = 0
            AND DELETED = 0
            AND FLDORDERNUMBER IS NOT NULL
            AND FLDEXTERNALNUMBER IS NOT NULL
            AND FLDEXTERNALNUMBER != '0000-00000'
            AND FLDWFSTATUS IN ('Услуга эксплуатируется', 'Тестирование услуги', 'Выполняется отключение', 'Экстренное включение', 'Приемка клиентом')
            AND FLDORGANIZATIONUNID IS NOT NULL
            AND LOCALSYSTEMID IS NOT NULL
            AND ENDDATE < CURRENT_TIMESTAMP
            AND rownum <= 1
        GROUP BY FLDEXTERNALNUMBER
        HAVING COUNT(*) < 2
        )
    )
ORDER BY PERSISTDATE DESC
FETCH FIRST 1 ROWS ONLY