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 -- отсеять по волге киров