SELECT
       SB.UUID,
       SB.SUB_ID
FROM (
SELECT
       pc.UUID,
       pc.TXID,
       pc.SUB_ID,
       pc.SERVICE_KEY,
       pc.SERVICE_NAME,
       ss.STATUS
FROM
       MDM6.CLIENT c       INNER JOIN   TL_SASP.PPE_CHARGES pc ON  c.nls = pc.uuid
       INNER JOIN   MDM6.TECHSERVICE ts ON     pc.service_key = ts.LOCALSYSTEMID
       INNER JOIN   MDM6.SUBSCRIBERSERVICE ss ON      pc.sub_id = ss.LOCALSYSTEMID
       INNER JOIN   MDM6.SUBSCRIBER s ON       c.LOCALSYSTEMID = s.CLIENT_LOCALSYSTEMID
WHERE 1=1
       AND c.DELETED < 1
       AND s.DELETED < 1
       AND ss.DELETED < 1
       AND LENGTH (c.INN) > 9
       AND LENGTH (c.INN) < 13
       AND s.DTYPE = 'SubscriberEco'
       AND ss.STATUS IN ('active', 'test', 'lock_finance', 'lock_voluntary', 'deleted')
       AND c.VERSION = 0
       AND s.VERSION = 0
       AND ss.VERSION = 0
       AND ss.APP_PKID = 4001
       AND c.VERSION = s.CLIENT_VERSION
       AND c.APP_PKID = s.CLIENT_APP_PKID
       AND c.LOCALSYSTEMID = s.CLIENT_LOCALSYSTEMID
       AND s.VERSION = ss.SUBSCRIBER_VERSION
       AND s.APP_PKID = ss.SUBSCRIBER_APP_PKID
       AND s.LOCALSYSTEMID = ss.SUBSCRIBER_LOCALSYSTEMID
FETCH FIRST 500 ROWS ONLY
)
SB
GROUP BY SB.UUID, SB.SUB_ID