SELECT
    *
FROM
    (
    SELECT
/*+ FIRST_ROWS(50) */
        SITE_CODE,
        ( SELECT UNIT || ' ' || NAME FROM SITE WHERE SITE_CODE_EXIST = A.SITE_CODE AND SITE_TYPE_ID = 5 ) SITE_NAME,
        METER_CODE,
        METER_TYPE_BRAND,
        LOCATION_CODE,
        LOCATION_NAME,
        TARIFF,
        POWER,
        SUSPECT_CATEGORY,
        ROUND( VOLTAGE_L1, 2 ),
        ROUND( VOLTAGE_L2, 2 ),
        ROUND( VOLTAGE_L3, 2 ),
        ROUND( VOLTAGE_ANGLE_L1, 2 ),
        ROUND( VOLTAGE_ANGLE_L2, 2 ),
        ROUND( VOLTAGE_ANGLE_L3, 2 ),
        ROUND( CURRENT_L1, 2 ),
        ROUND( CURRENT_L2, 2 ),
        ROUND( CURRENT_L3, 2 ),
        CURRENT_N,
        ROUND( CURRENT_ANGLE_L1, 2 ),
        ROUND( CURRENT_ANGLE_L2, 2 ),
        ROUND( CURRENT_ANGLE_L3, 2 ),
        ROUND( POWER_FACTOR_L1, 2 ),
        ROUND( POWER_FACTOR_L2, 2 ),
        ROUND( POWER_FACTOR_L3, 2 ),
        ROUND( ACTIVE_POWER_L1, 2 ),
        ROUND( ACTIVE_POWER_L2, 2 ),
        ROUND( ACTIVE_POWER_L3, 2 ),
        (( READ_DATE - TO_DATE( '19700101', 'YYYYMMDD' )) * 24 * 60 * 60 * 1000 ) READ_DATE,
        ROW_NUMBER () OVER ( ORDER BY READ_DATE ASC ) RN,
        MAX( ROWNUM ) OVER ( ORDER BY NULL ) CNT,
        (( SERVER_TIME - TO_DATE( '19700101', 'YYYYMMDD' )) * 24 * 60 * 60 * 1000 ) SERVER_TIME,
        (( METER_TIME - TO_DATE( '19700101', 'YYYYMMDD' )) * 24 * 60 * 60 * 1000 ) METER_TIME
    FROM
        (
        SELECT
            A.SITE_CODE,
            A.METER_CODE,
            A.METER_TYPE_BRAND,
            A.LOCATION_CODE,
            A.LOCATION_NAME,
            A.TARIFF,
            A.POWER,
            A.SUSPECT_CATEGORY,
            A.VOLTAGE_L1,
            A.VOLTAGE_L2,
            A.VOLTAGE_L3,
            A.VOLTAGE_ANGLE_L1,
            A.VOLTAGE_ANGLE_L2,
            A.VOLTAGE_ANGLE_L3,
            A.CURRENT_L1,
            A.CURRENT_L2,
            A.CURRENT_L3,
            A.CURRENT_N,
            A.CURRENT_ANGLE_L1,
            A.CURRENT_ANGLE_L2,
            A.CURRENT_ANGLE_L3,
            A.POWER_FACTOR_L1,
            A.POWER_FACTOR_L2,
            A.POWER_FACTOR_L3,
            A.ACTIVE_POWER_L1,
            A.ACTIVE_POWER_L2,
            A.ACTIVE_POWER_L3,
            A.READ_DATE,
            B.SERVER_TIME,
            B.METER_TIME
        FROM
            SUSPECT_INSTANTS A
            LEFT JOIN TRANS_INSTANT B ON A.LOCATION_CODE = B.LOCATION_CODE AND A.READ_DATE = B.READ_DATE
        WHERE
            A.SUSPECT_CATEGORY = '10'
            AND A.DATE_READ BETWEEN '20190801'
            AND '20190830'
        ) A
    WHERE
        LOCATION_CODE = '539411280648'
    )
-- WHERE
--  RN BETWEEN ((( 1-1 ) * 1000 ) + 1 )
--  AND ( 1 * 1000 )
-- ORDER BY
--  RN;