SHOW:
|
|
- or go back to the newest paste.
| 1 | - | 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) |
| 1 | + | SELECT GGUID |
| 2 | FROM DATABASE.ADDRESS0 AS ADDRESS | |
| 3 | WHERE ( | |
| 4 | ( | |
| 5 | ADDRESS.GGUID IN ( | |
| 6 | SELECT rel.GUID1 | |
| 7 | FROM DATABASE.TableRelation AS rel | |
| 8 | INNER JOIN DATABASE.ADDRESS0 AS ADDRESS ON rel.GUID2 = ADDRESS.GGUID | |
| 9 | AND (rel.RelationName LIKE 'ADD_PENSION') | |
| 10 | WHERE ( | |
| 11 | (ADDRESS.GGUID = 0xA3443B6122463EB4921531E14D8D5142) | |
| 12 | AND ( | |
| 13 | ADDRESS.GGUID IN ( | |
| 14 | SELECT TABLEGUID | |
| 15 | FROM DATABASE.ADDRESSORel | |
| 16 | WHERE EIMRight >= 64 | |
| 17 | AND ( | |
| 18 | OID IN ( | |
| 19 | 1 | |
| 20 | ,- 8 | |
| 21 | ,0 | |
| 22 | ) | |
| 23 | ) | |
| 24 | ) | |
| 25 | ) | |
| 26 | ) | |
| 27 | AND ( | |
| 28 | ADDRESS.ISDELETED = 0 | |
| 29 | AND ADDRESS.ISTEMPLATE = 0 | |
| 30 | ) | |
| 31 | ||
| 32 | UNION ALL | |
| 33 | ||
| 34 | SELECT rel.GUID2 | |
| 35 | FROM DATABASE.TableRelation AS rel | |
| 36 | INNER JOIN DATABASE.ADDRESS0 AS ADDRESS ON rel.GUID1 = ADDRESS.GGUID | |
| 37 | AND (rel.RelationName LIKE 'ADD_PENSION') | |
| 38 | WHERE ( | |
| 39 | ( | |
| 40 | (ADDRESS.GGUID = 0xA3443B6122463EB4921531E14D8D5142) | |
| 41 | AND ( | |
| 42 | ADDRESS.GGUID IN ( | |
| 43 | SELECT TABLEGUID | |
| 44 | FROM DATABASE.ADDRESSORel | |
| 45 | WHERE EIMRight >= 64 | |
| 46 | AND ( | |
| 47 | OID IN ( | |
| 48 | 1 | |
| 49 | ,- 8 | |
| 50 | ,0 | |
| 51 | ) | |
| 52 | ) | |
| 53 | ) | |
| 54 | ) | |
| 55 | ) | |
| 56 | AND ( | |
| 57 | ADDRESS.GGUID IN ( | |
| 58 | SELECT TABLEGUID | |
| 59 | FROM DATABASE.ADDRESSORel | |
| 60 | WHERE EIMRight >= 64 | |
| 61 | AND ( | |
| 62 | OID IN ( | |
| 63 | 1 | |
| 64 | ,- 8 | |
| 65 | ,0 | |
| 66 | ) | |
| 67 | ) | |
| 68 | ) | |
| 69 | ) | |
| 70 | ) | |
| 71 | AND ( | |
| 72 | ADDRESS.ISDELETED = 0 | |
| 73 | AND ADDRESS.ISTEMPLATE = 0 | |
| 74 | ) | |
| 75 | ) | |
| 76 | ) | |
| 77 | AND ( | |
| 78 | ADDRESS.GGUID IN ( | |
| 79 | SELECT TABLEGUID | |
| 80 | FROM DATABASE.ADDRESSORel | |
| 81 | WHERE EIMRight >= 64 | |
| 82 | AND ( | |
| 83 | OID IN ( | |
| 84 | 1 | |
| 85 | ,- 8 | |
| 86 | ,0 | |
| 87 | ) | |
| 88 | ) | |
| 89 | ) | |
| 90 | ) | |
| 91 | ) | |
| 92 | AND ( | |
| 93 | ADDRESS.ISDELETED = 0 | |
| 94 | AND ADDRESS.ISTEMPLATE = 0 | |
| 95 | ) |
