SELECT
    COUNT(s.IDENTIFITIER) AS COUNT_IDENTIFITIER
FROM
    MDM6.CLIENT c
        INNER JOIN
    MDM6.SUBSCRIBER s
        ON s.CLIENT_LOCALSYSTEMID = c.LOCALSYSTEMID
        AND s.CLIENT_APP_PKID = c.APP_PKID
        AND s.CLIENT_VERSION = c.VERSION
        INNER JOIN
    MDM6.SUBSCRIBERSERVICE ss
        ON ss.SUBSCRIBER_LOCALSYSTEMID = s.LOCALSYSTEMID
        AND ss.SUBSCRIBER_APP_PKID = s.APP_PKID
        AND ss.SUBSCRIBER_VERSION = s.VERSION
        INNER JOIN
    MDM6.TECHSERVICE t
        ON ss.TECHSERVICE_LOCALSYSTEMID = t.LOCALSYSTEMID
        AND ss.TECHSERVICE_APP_PKID = t.APP_PKID
        AND ss.TECHSERVICE_VERSION = t.VERSION
WHERE 1=1
    AND c.DELETED = 0
    AND ss.DELETED = 0
    AND s.DELETED = 0
    AND c.version = 0
    AND ss.VERSION = 0
    AND s.VERSION = 0
    AND ss.STATUS = 1
    AND c.ENDDATE > sysdate
    AND s.ENDDATE > sysdate
    AND ss.ENDDATE > sysdate
    AND s.SUBSCRIBERSTATUS_LOCALSYSTEMID = '1'
    AND ss.TECHSERVICE_LOCALSYSTEMID = '369300148' -- ядиск100 для волги
    AND c.APP_PKID = 44 -- отсеять по волге киров