--- найти необходимую услугу
SELECT DISTINCT * FROM MDM6.TECHSERVICE t WHERE TITLE LIKE 'ТНГ%'

--- найти связанных с этой услугой абонентов
SELECT
    t.TITLE,
    c.LOCALSYSTEMID ,
    c.nls
FROM
    MDM6.TECHSERVICE t
    INNER JOIN MDM6.SUBSCRIBERSERVICE ss ON t.LOCALSYSTEMID = ss.TECHSERVICE_LOCALSYSTEMID
    AND t.APP_PKID = ss.TECHSERVICE_APP_PKID
    AND t.VERSION = ss.TECHSERVICE_VERSION
    INNER JOIN MDM6.SUBSCRIBER s ON ss.SUBSCRIBER_LOCALSYSTEMID = s.LOCALSYSTEMID
    AND ss.SUBSCRIBER_APP_PKID = s.APP_PKID
    AND ss.SUBSCRIBER_VERSION = s.VERSION
    INNER JOIN MDM6.CLIENT c ON s.CLIENT_LOCALSYSTEMID = c.LOCALSYSTEMID
    AND s.CLIENT_APP_PKID = c.APP_PKID
    AND s.CLIENT_VERSION = c.VERSION
WHERE 1=1
    AND t.TITLE = 'ТНГ_опция_ЛИЦЕЙ ПЛЮС'
    AND c.DTYPE = 'PhysicalClient'
    AND c.deleted = 0
    AND s.DELETED = 0
    AND ss.DELETED = 0
    AND c.OWNER_LOGIN = 'volga_kirov'