Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT GGUID FROM DATABASE.ADDRESS0 AS ADDRESS WHERE ((ADDRESS.GGUID IN (SELECT rel.GUID1 FROM DATABASE.TableRelation AS rel INNER JOIN DATABASE.ADDRESS0 AS ADDRESS ON rel.GUID2 = ADDRESS.GGUID AND (rel.RelationName LIKE 'ADD_PENSION') WHERE ((ADDRESS.GGUID = 0xA3443B6122463EB4921531E14D8D5142) AND (ADDRESS.GGUID IN (SELECT TABLEGUID FROM DATABASE.ADDRESSORel WHERE EIMRight >= 64 AND (OID IN (1, -8, 0))))) AND (ADDRESS.ISDELETED = 0 AND ADDRESS.ISTEMPLATE = 0) UNION ALL SELECT rel.GUID2 FROM DATABASE.TableRelation AS rel INNER JOIN DATABASE.ADDRESS0 AS ADDRESS ON rel.GUID1 = ADDRESS.GGUID AND (rel.RelationName LIKE 'ADD_PENSION') WHERE (((ADDRESS.GGUID = 0xA3443B6122463EB4921531E14D8D5142) AND (ADDRESS.GGUID IN (SELECT TABLEGUID FROM DATABASE.ADDRESSORel WHERE EIMRight >= 64 AND (OID IN (1, -8, 0))))) AND (ADDRESS.GGUID IN (SELECT TABLEGUID FROM DATABASE.ADDRESSORel WHERE EIMRight >= 64 AND (OID IN (1, -8, 0))))) AND (ADDRESS.ISDELETED = 0 AND ADDRESS.ISTEMPLATE = 0))) AND (ADDRESS.GGUID IN (SELECT TABLEGUID FROM DATABASE.ADDRESSORel WHERE EIMRight >= 64 AND (OID IN (1, -8, 0))))) AND (ADDRESS.ISDELETED = 0 AND ADDRESS.ISTEMPLATE = 0)
Advertisement
Add Comment
Please, Sign In to add comment
