Saviynt Solutions

 select entitlement_valuekey as entitlement_values__Primarykey ,(select entitlement_valuekey from entitlement_values r where r.entitlementid=ev.entitlementid and r.ENTITLEMENTTYPEKEY =147) entitlement_values__REFERENCED_ENTITLEMENT from entitlement_values ev where ev.ENTITLEMENTTYPEKEY in (select et.ENTITLEMENTTYPEKEY from entitlement_types et where ENDPOINTKEY in (select ENDPOINTKEY from endpoints where PARENTENDPOINTKEY=7)) and REFERENCED_ENTITLEMENT is null and entitlementid not like '%old%' and (select entitlement_valuekey from entitlement_values r where r.entitlementid=ev.entitlementid and r.ENTITLEMENTTYPEKEY =147) != ''

  SELECT  'Google' AS securitysystems__systemname , 'Google' AS securitysystems__displayname , systemkey as  securitysystems__PRIMARYKEY  FROM securitysystems  where systemkey=70 limit 1;  

  SELECT  'Google' AS ENDPOINTS__endpointname , 'Google' AS ENDPOINTS__displayname , ep.endpointkey as  ENDPOINTS__PRIMARYKEY  FROM ENDPOINTS  ep where ep.endpointkey=51 limit 1;