Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- s.IDENTIFITIER AS 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 = '496822457' -- лицей для волги
- AND c.APP_PKID = 44 -- отсеять по волге киров
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement