SELECT EMAILSTORE.ISFORMEMAIL, EMAILSTORE.SENDDATE, EMAILSTORE.SUBJECT, EMAILSTORE.XFROM, EMAILSTORE.XTO, EMAILSTORE.HASATTACHMENTS, EMAILSTORE.GGUID 
FROM `svg`.EMAILSTORE0 AS EMAILSTORE 
INNER JOIN svg.tablerelation AS rel ON rel.GUID1 = EMAILSTORE.GGUID
INNER JOIN svg.todo0 AS TODOC7504C2A4C0C38BDBE403DA9CA19A0DF ON rel.GUID2 = TODOC7504C2A4C0C38BDBE403DA9CA19A0DF.GGUID
WHERE 
(TODOC7504C2A4C0C38BDBE403DA9CA19A0DF.KEYWORD LIKE '%antragsanforderung%' AND TODOC7504C2A4C0C38BDBE403DA9CA19A0DF.WORKINGPERCENT = '100') 
AND (TODOC7504C2A4C0C38BDBE403DA9CA19A0DF.GGUID IN (SELECT TABLEGUID FROM `svg`.TODOORel WHERE EIMRight >= 64 AND (OID IN (1014, -426, -396, -98, -305, -50, -215, -8, -100, -366, -88, -90, -279, -319, -314, -270, -99, -428, -92, -431, -317, -427, -430, -320, -95, -101, 0) OR (OID IN (4328, -314, -215, -159, -216, 4389, 4390, 4392, 4093, 4399, 4109, 4355, 4114, 4115, 1032, 1033, 1034, 3055, 1024, 1025, 1026, 1027, 1028, 1029, 1030, 1031, 3756, 3755, 4456, 4443, 4189, 3519, 3406, 3944, 3407, 3945, 3946, 3947, 3936, 3937, 3938, 3939, 3940, 3941, 3942, 3943, 4527, 4226, 3453, 3454, 3935, 3934, 1016, 3096, 1017, 1018, 4332, 1019, 1020, 1021, 1022, 1023, 3089, 1008, 1009, 3091, 1010, 3090, 3093, 1012, 1013, 3094, 1015, 1001, 1000, 1003, 1002, 1005, 1004, 1007, 1006, 997, 996, 999, 3616, 3613, 3855, 3615, 3852, 3609, 3850, 3608, 3848, 3610, 3849, 3846, 3847, 3607, 3844, 3606, 3845, 3842, 3843, 3840, 3841, 4550, 4400, 4401, 4402, 4403, 4464, 4404, 4465, 4461, 4460, 4463, 4462, 4457, 4459, 4458, 3600, 3596, 3597, 3598, 3599, 3592, 3593, 3594, 3595, 3588, 3589, 3590, 3591, -93, -101, -8, -99, -50, -95, -100, -98, -92, -161, -380, -217, -148, -307, -90, -323, -321, -110, -150, -103, -109, -107, -149, -218, -324, -88, -415, -319, -320, -305, -317, -427, -357, -270, -279, -428, -105, -366, -91, -102, -365, -306, -313, -311, -308, -309, -9) AND TODOC7504C2A4C0C38BDBE403DA9CA19A0DF.ForeignEditPermission = 65535)))) 
AND (TODOC7504C2A4C0C38BDBE403DA9CA19A0DF.ISDELETED = 0 AND TODOC7504C2A4C0C38BDBE403DA9CA19A0DF.ISTEMPLATE = 0)
AND (EMAILSTORE.GGUID IN (SELECT TABLEGUID FROM `svg`.EMAILSTOREORel WHERE EIMRight >= 64 AND (OID IN (1014, -426, -396, -98, -305, -50, -215, -8, -100, -366, -88, -90, -279, -319, -314, -270, -99, -428, -92, -431, -317, -427, -430, -320, -95, -101, 0) OR (OID IN (4328, -314, -215, -159, -216, 4389, 4390, 4392, 4093, 4399, 4109, 4355, 4114, 4115, 1032, 1033, 1034, 3055, 1024, 1025, 1026, 1027, 1028, 1029, 1030, 1031, 3756, 3755, 4456, 4443, 4189, 3519, 3406, 3944, 3407, 3945, 3946, 3947, 3936, 3937, 3938, 3939, 3940, 3941, 3942, 3943, 4527, 4226, 3453, 3454, 3935, 3934, 1016, 3096, 1017, 1018, 4332, 1019, 1020, 1021, 1022, 1023, 3089, 1008, 1009, 3091, 1010, 3090, 3093, 1012, 1013, 3094, 1015, 1001, 1000, 1003, 1002, 1005, 1004, 1007, 1006, 997, 996, 999, 3616, 3613, 3855, 3615, 3852, 3609, 3850, 3608, 3848, 3610, 3849, 3846, 3847, 3607, 3844, 3606, 3845, 3842, 3843, 3840, 3841, 4550, 4400, 4401, 4402, 4403, 4464, 4404, 4465, 4461, 4460, 4463, 4462, 4457, 4459, 4458, 3600, 3596, 3597, 3598, 3599, 3592, 3593, 3594, 3595, 3588, 3589, 3590, 3591, -93, -101, -8, -99, -50, -95, -100, -98, -92, -161, -380, -217, -148, -307, -90, -323, -321, -110, -150, -103, -109, -107, -149, -218, -324, -88, -415, -319, -320, -305, -317, -427, -357, -270, -279, -428, -105, -366, -91, -102, -365, -306, -313, -311, -308, -309, -9) AND EMAILSTORE.ForeignEditPermission = 65535)))) 
AND (EMAILSTORE.ISDELETED = 0 AND EMAILSTORE.ISTEMPLATE = 0) 
ORDER BY EMAILSTORE.SENDDATE DESC, EMAILSTORE.GGUID ASC 
LIMIT 0, 100{
  "steps": [
    {
      "join_preparation": {
        "select#": 1,
        "steps": [
          {
            "join_preparation": {
              "select#": 2,
              "steps": [
                {
                  "expanded_query": "/* select#2 */ select `todoorel`.`TableGUID` from `todoorel` where ((`todoorel`.`EIMRight` >= 64) and ((`todoorel`.`OID` in (1014,-(426),-(396),-(98),-(305),-(50),-(215),-(8),-(100),-(366),-(88),-(90),-(279),-(319),-(314),-(270),-(99),-(428),-(92),-(431),-(317),-(427),-(430),-(320),-(95),-(101),0)) or ((`todoorel`.`OID` in (4328,-(314),-(215),-(159),-(216),4389,4390,4392,4093,4399,4109,4355,4114,4115,1032,1033,1034,3055,1024,1025,1026,1027,1028,1029,1030,1031,3756,3755,4456,4443,4189,3519,3406,3944,3407,3945,3946,3947,3936,3937,3938,3939,3940,3941,3942,3943,4527,4226,3453,3454,3935,3934,1016,3096,1017,1018,4332,1019,1020,1021,1022,1023,3089,1008,1009,3091,1010,3090,3093,1012,1013,3094,1015,1001,1000,1003,1002,1005,1004,1007,1006,997,996,999,3616,3613,3855,3615,3852,3609,3850,3608,3848,3610,3849,3846,3847,3607,3844,3606,3845,3842,3843,3840,3841,4550,4400,4401,4402,4403,4464,4404,4465,4461,4460,4463,4462,4457,4459,4458,3600,3596,3597,3598,3599,3592,3593,3594,3595,3588,3589,3590,3591,-(93),-(101),-(8),-(99),-(50),-(95),-(100),-(98),-(92),-(161),-(380),-(217),-(148),-(307),-(90),-(323),-(321),-(110),-(150),-(103),-(109),-(107),-(149),-(218),-(324),-(88),-(415),-(319),-(320),-(305),-(317),-(427),-(357),-(270),-(279),-(428),-(105),-(366),-(91),-(102),-(365),-(306),-(313),-(311),-(308),-(309),-(9))) and (`todoc7504c2a4c0c38bdbe403da9ca19a0df`.`ForeignEditPermission` = 65535))))"
                },
                {
                  "transformation": {
                    "select#": 2,
                    "from": "IN (SELECT)",
                    "to": "semijoin",
                    "chosen": true
                  }
                }
              ]
            }
          },
          {
            "join_preparation": {
              "select#": 3,
              "steps": [
                {
                  "expanded_query": "/* select#3 */ select `emailstoreorel`.`TableGUID` from `emailstoreorel` where ((`emailstoreorel`.`EIMRight` >= 64) and ((`emailstoreorel`.`OID` in (1014,-(426),-(396),-(98),-(305),-(50),-(215),-(8),-(100),-(366),-(88),-(90),-(279),-(319),-(314),-(270),-(99),-(428),-(92),-(431),-(317),-(427),-(430),-(320),-(95),-(101),0)) or ((`emailstoreorel`.`OID` in (4328,-(314),-(215),-(159),-(216),4389,4390,4392,4093,4399,4109,4355,4114,4115,1032,1033,1034,3055,1024,1025,1026,1027,1028,1029,1030,1031,3756,3755,4456,4443,4189,3519,3406,3944,3407,3945,3946,3947,3936,3937,3938,3939,3940,3941,3942,3943,4527,4226,3453,3454,3935,3934,1016,3096,1017,1018,4332,1019,1020,1021,1022,1023,3089,1008,1009,3091,1010,3090,3093,1012,1013,3094,1015,1001,1000,1003,1002,1005,1004,1007,1006,997,996,999,3616,3613,3855,3615,3852,3609,3850,3608,3848,3610,3849,3846,3847,3607,3844,3606,3845,3842,3843,3840,3841,4550,4400,4401,4402,4403,4464,4404,4465,4461,4460,4463,4462,4457,4459,4458,3600,3596,3597,3598,3599,3592,3593,3594,3595,3588,3589,3590,3591,-(93),-(101),-(8),-(99),-(50),-(95),-(100),-(98),-(92),-(161),-(380),-(217),-(148),-(307),-(90),-(323),-(321),-(110),-(150),-(103),-(109),-(107),-(149),-(218),-(324),-(88),-(415),-(319),-(320),-(305),-(317),-(427),-(357),-(270),-(279),-(428),-(105),-(366),-(91),-(102),-(365),-(306),-(313),-(311),-(308),-(309),-(9))) and (`emailstore`.`ForeignEditPermission` = 65535))))"
                },
                {
                  "transformation": {
                    "select#": 3,
                    "from": "IN (SELECT)",
                    "to": "semijoin",
                    "chosen": true
                  }
                }
              ]
            }
          },
          {
            "expanded_query": "/* select#1 */ select `emailstore`.`IsFormEMail` AS `ISFORMEMAIL`,`emailstore`.`SendDate` AS `SENDDATE`,`emailstore`.`Subject` AS `SUBJECT`,`emailstore`.`XFrom` AS `XFROM`,`emailstore`.`XTo` AS `XTO`,`emailstore`.`HASATTACHMENTS` AS `HASATTACHMENTS`,`emailstore`.`GGUID` AS `GGUID` from ((`emailstore0` `emailstore` join `tablerelation` `rel` on((`rel`.`GUID1` = `emailstore`.`GGUID`))) join `todo0` `todoc7504c2a4c0c38bdbe403da9ca19a0df` on((`rel`.`GUID2` = `todoc7504c2a4c0c38bdbe403da9ca19a0df`.`GGUID`))) where ((`todoc7504c2a4c0c38bdbe403da9ca19a0df`.`KEYWORD` like '%antragsanforderung%') and (`todoc7504c2a4c0c38bdbe403da9ca19a0df`.`WORKINGPERCENT` = '100') and `todoc7504c2a4c0c38bdbe403da9ca19a0df`.`GGUID` in (/* select#2 */ select `todoorel`.`TableGUID` from `todoorel` where ((`todoorel`.`EIMRight` >= 64) and ((`todoorel`.`OID` in (1014,-(426),-(396),-(98),-(305),-(50),-(215),-(8),-(100),-(366),-(88),-(90),-(279),-(319),-(314),-(270),-(99),-(428),-(92),-(431),-(317),-(427),-(430),-(320),-(95),-(101),0)) or ((`todoorel`.`OID` in (4328,-(314),-(215),-(159),-(216),4389,4390,4392,4093,4399,4109,4355,4114,4115,1032,1033,1034,3055,1024,1025,1026,1027,1028,1029,1030,1031,3756,3755,4456,4443,4189,3519,3406,3944,3407,3945,3946,3947,3936,3937,3938,3939,3940,3941,3942,3943,4527,4226,3453,3454,3935,3934,1016,3096,1017,1018,4332,1019,1020,1021,1022,1023,3089,1008,1009,3091,1010,3090,3093,1012,1013,3094,1015,1001,1000,1003,1002,1005,1004,1007,1006,997,996,999,3616,3613,3855,3615,3852,3609,3850,3608,3848,3610,3849,3846,3847,3607,3844,3606,3845,3842,3843,3840,3841,4550,4400,4401,4402,4403,4464,4404,4465,4461,4460,4463,4462,4457,4459,4458,3600,3596,3597,3598,3599,3592,3593,3594,3595,3588,3589,3590,3591,-(93),-(101),-(8),-(99),-(50),-(95),-(100),-(98),-(92),-(161),-(380),-(217),-(148),-(307),-(90),-(323),-(321),-(110),-(150),-(103),-(109),-(107),-(149),-(218),-(324),-(88),-(415),-(319),-(320),-(305),-(317),-(427),-(357),-(270),-(279),-(428),-(105),-(366),-(91),-(102),-(365),-(306),-(313),-(311),-(308),-(309),-(9))) and (`todoc7504c2a4c0c38bdbe403da9ca19a0df`.`ForeignEditPermission` = 65535))))) and (`todoc7504c2a4c0c38bdbe403da9ca19a0df`.`IsDeleted` = 0) and (`todoc7504c2a4c0c38bdbe403da9ca19a0df`.`IsTemplate` = 0) and `emailstore`.`GGUID` in (/* select#3 */ select `emailstoreorel`.`TableGUID` from `emailstoreorel` where ((`emailstoreorel`.`EIMRight` >= 64) and ((`emailstoreorel`.`OID` in (1014,-(426),-(396),-(98),-(305),-(50),-(215),-(8),-(100),-(366),-(88),-(90),-(279),-(319),-(314),-(270),-(99),-(428),-(92),-(431),-(317),-(427),-(430),-(320),-(95),-(101),0)) or ((`emailstoreorel`.`OID` in (4328,-(314),-(215),-(159),-(216),4389,4390,4392,4093,4399,4109,4355,4114,4115,1032,1033,1034,3055,1024,1025,1026,1027,1028,1029,1030,1031,3756,3755,4456,4443,4189,3519,3406,3944,3407,3945,3946,3947,3936,3937,3938,3939,3940,3941,3942,3943,4527,4226,3453,3454,3935,3934,1016,3096,1017,1018,4332,1019,1020,1021,1022,1023,3089,1008,1009,3091,1010,3090,3093,1012,1013,3094,1015,1001,1000,1003,1002,1005,1004,1007,1006,997,996,999,3616,3613,3855,3615,3852,3609,3850,3608,3848,3610,3849,3846,3847,3607,3844,3606,3845,3842,3843,3840,3841,4550,4400,4401,4402,4403,4464,4404,4465,4461,4460,4463,4462,4457,4459,4458,3600,3596,3597,3598,3599,3592,3593,3594,3595,3588,3589,3590,3591,-(93),-(101),-(8),-(99),-(50),-(95),-(100),-(98),-(92),-(161),-(380),-(217),-(148),-(307),-(90),-(323),-(321),-(110),-(150),-(103),-(109),-(107),-(149),-(218),-(324),-(88),-(415),-(319),-(320),-(305),-(317),-(427),-(357),-(270),-(279),-(428),-(105),-(366),-(91),-(102),-(365),-(306),-(313),-(311),-(308),-(309),-(9))) and (`emailstore`.`ForeignEditPermission` = 65535))))) and (`emailstore`.`IsDeleted` = 0) and (`emailstore`.`IsTemplate` = 0)) order by `emailstore`.`SendDate` desc,`emailstore`.`GGUID` limit 0,100"
          }
        ]
      }
    },
    {
      "join_optimization": {
        "select#": 1,
        "steps": [
          {
            "transformation": {
              "select#": 2,
              "from": "IN (SELECT)",
              "to": "semijoin",
              "chosen": true,
              "evaluating_constant_semijoin_conditions": [
              ]
            }
          },
          {
            "transformation": {
              "select#": 3,
              "from": "IN (SELECT)",
              "to": "semijoin",
              "chosen": true,
              "evaluating_constant_semijoin_conditions": [
              ]
            }
          },
          {
            "transformations_to_nested_joins": {
              "transformations": [
                "semijoin",
                "JOIN_condition_to_WHERE",
                "parenthesis_removal"
              ],
              "expanded_query": "/* select#1 */ select `emailstore`.`IsFormEMail` AS `ISFORMEMAIL`,`emailstore`.`SendDate` AS `SENDDATE`,`emailstore`.`Subject` AS `SUBJECT`,`emailstore`.`XFrom` AS `XFROM`,`emailstore`.`XTo` AS `XTO`,`emailstore`.`HASATTACHMENTS` AS `HASATTACHMENTS`,`emailstore`.`GGUID` AS `GGUID` from `emailstore0` `emailstore` semi join (`todoorel`) semi join (`emailstoreorel`) join `tablerelation` `rel` join `todo0` `todoc7504c2a4c0c38bdbe403da9ca19a0df` where ((`todoc7504c2a4c0c38bdbe403da9ca19a0df`.`KEYWORD` like '%antragsanforderung%') and (`todoc7504c2a4c0c38bdbe403da9ca19a0df`.`WORKINGPERCENT` = '100') and 1 and (`todoc7504c2a4c0c38bdbe403da9ca19a0df`.`IsDeleted` = 0) and (`todoc7504c2a4c0c38bdbe403da9ca19a0df`.`IsTemplate` = 0) and 1 and (`emailstore`.`IsDeleted` = 0) and (`emailstore`.`IsTemplate` = 0) and (`todoorel`.`EIMRight` >= 64) and ((`todoorel`.`OID` in (1014,-(426),-(396),-(98),-(305),-(50),-(215),-(8),-(100),-(366),-(88),-(90),-(279),-(319),-(314),-(270),-(99),-(428),-(92),-(431),-(317),-(427),-(430),-(320),-(95),-(101),0)) or ((`todoorel`.`OID` in (4328,-(314),-(215),-(159),-(216),4389,4390,4392,4093,4399,4109,4355,4114,4115,1032,1033,1034,3055,1024,1025,1026,1027,1028,1029,1030,1031,3756,3755,4456,4443,4189,3519,3406,3944,3407,3945,3946,3947,3936,3937,3938,3939,3940,3941,3942,3943,4527,4226,3453,3454,3935,3934,1016,3096,1017,1018,4332,1019,1020,1021,1022,1023,3089,1008,1009,3091,1010,3090,3093,1012,1013,3094,1015,1001,1000,1003,1002,1005,1004,1007,1006,997,996,999,3616,3613,3855,3615,3852,3609,3850,3608,3848,3610,3849,3846,3847,3607,3844,3606,3845,3842,3843,3840,3841,4550,4400,4401,4402,4403,4464,4404,4465,4461,4460,4463,4462,4457,4459,4458,3600,3596,3597,3598,3599,3592,3593,3594,3595,3588,3589,3590,3591,-(93),-(101),-(8),-(99),-(50),-(95),-(100),-(98),-(92),-(161),-(380),-(217),-(148),-(307),-(90),-(323),-(321),-(110),-(150),-(103),-(109),-(107),-(149),-(218),-(324),-(88),-(415),-(319),-(320),-(305),-(317),-(427),-(357),-(270),-(279),-(428),-(105),-(366),-(91),-(102),-(365),-(306),-(313),-(311),-(308),-(309),-(9))) and (`todoc7504c2a4c0c38bdbe403da9ca19a0df`.`ForeignEditPermission` = 65535))) and (`todoc7504c2a4c0c38bdbe403da9ca19a0df`.`GGUID` = `todoorel`.`TableGUID`) and (`emailstoreorel`.`EIMRight` >= 64) and ((`emailstoreorel`.`OID` in (1014,-(426),-(396),-(98),-(305),-(50),-(215),-(8),-(100),-(366),-(88),-(90),-(279),-(319),-(314),-(270),-(99),-(428),-(92),-(431),-(317),-(427),-(430),-(320),-(95),-(101),0)) or ((`emailstoreorel`.`OID` in (4328,-(314),-(215),-(159),-(216),4389,4390,4392,4093,4399,4109,4355,4114,4115,1032,1033,1034,3055,1024,1025,1026,1027,1028,1029,1030,1031,3756,3755,4456,4443,4189,3519,3406,3944,3407,3945,3946,3947,3936,3937,3938,3939,3940,3941,3942,3943,4527,4226,3453,3454,3935,3934,1016,3096,1017,1018,4332,1019,1020,1021,1022,1023,3089,1008,1009,3091,1010,3090,3093,1012,1013,3094,1015,1001,1000,1003,1002,1005,1004,1007,1006,997,996,999,3616,3613,3855,3615,3852,3609,3850,3608,3848,3610,3849,3846,3847,3607,3844,3606,3845,3842,3843,3840,3841,4550,4400,4401,4402,4403,4464,4404,4465,4461,4460,4463,4462,4457,4459,4458,3600,3596,3597,3598,3599,3592,3593,3594,3595,3588,3589,3590,3591,-(93),-(101),-(8),-(99),-(50),-(95),-(100),-(98),-(92),-(161),-(380),-(217),-(148),-(307),-(90),-(323),-(321),-(110),-(150),-(103),-(109),-(107),-(149),-(218),-(324),-(88),-(415),-(319),-(320),-(305),-(317),-(427),-(357),-(270),-(279),-(428),-(105),-(366),-(91),-(102),-(365),-(306),-(313),-(311),-(308),-(309),-(9))) and (`emailstore`.`ForeignEditPermission` = 65535))) and (`emailstore`.`GGUID` = `emailstoreorel`.`TableGUID`) and (`rel`.`GUID2` = `todoc7504c2a4c0c38bdbe403da9ca19a0df`.`GGUID`) and (`rel`.`GUID1` = `emailstore`.`GGUID`)) order by `emailstore`.`SendDate` desc,`emailstore`.`GGUID` limit 0,100"
            }
          },
          {
            "condition_processing": {
              "condition": "WHERE",
              "original_condition": "((`todoc7504c2a4c0c38bdbe403da9ca19a0df`.`KEYWORD` like '%antragsanforderung%') and (`todoc7504c2a4c0c38bdbe403da9ca19a0df`.`WORKINGPERCENT` = '100') and 1 and (`todoc7504c2a4c0c38bdbe403da9ca19a0df`.`IsDeleted` = 0) and (`todoc7504c2a4c0c38bdbe403da9ca19a0df`.`IsTemplate` = 0) and 1 and (`emailstore`.`IsDeleted` = 0) and (`emailstore`.`IsTemplate` = 0) and (`todoorel`.`EIMRight` >= 64) and ((`todoorel`.`OID` in (1014,-(426),-(396),-(98),-(305),-(50),-(215),-(8),-(100),-(366),-(88),-(90),-(279),-(319),-(314),-(270),-(99),-(428),-(92),-(431),-(317),-(427),-(430),-(320),-(95),-(101),0)) or ((`todoorel`.`OID` in (4328,-(314),-(215),-(159),-(216),4389,4390,4392,4093,4399,4109,4355,4114,4115,1032,1033,1034,3055,1024,1025,1026,1027,1028,1029,1030,1031,3756,3755,4456,4443,4189,3519,3406,3944,3407,3945,3946,3947,3936,3937,3938,3939,3940,3941,3942,3943,4527,4226,3453,3454,3935,3934,1016,3096,1017,1018,4332,1019,1020,1021,1022,1023,3089,1008,1009,3091,1010,3090,3093,1012,1013,3094,1015,1001,1000,1003,1002,1005,1004,1007,1006,997,996,999,3616,3613,3855,3615,3852,3609,3850,3608,3848,3610,3849,3846,3847,3607,3844,3606,3845,3842,3843,3840,3841,4550,4400,4401,4402,4403,4464,4404,4465,4461,4460,4463,4462,4457,4459,4458,3600,3596,3597,3598,3599,3592,3593,3594,3595,3588,3589,3590,3591,-(93),-(101),-(8),-(99),-(50),-(95),-(100),-(98),-(92),-(161),-(380),-(217),-(148),-(307),-(90),-(323),-(321),-(110),-(150),-(103),-(109),-(107),-(149),-(218),-(324),-(88),-(415),-(319),-(320),-(305),-(317),-(427),-(357),-(270),-(279),-(428),-(105),-(366),-(91),-(102),-(365),-(306),-(313),-(311),-(308),-(309),-(9))) and (`todoc7504c2a4c0c38bdbe403da9ca19a0df`.`ForeignEditPermission` = 65535))) and (`todoc7504c2a4c0c38bdbe403da9ca19a0df`.`GGUID` = `todoorel`.`TableGUID`) and (`emailstoreorel`.`EIMRight` >= 64) and ((`emailstoreorel`.`OID` in (1014,-(426),-(396),-(98),-(305),-(50),-(215),-(8),-(100),-(366),-(88),-(90),-(279),-(319),-(314),-(270),-(99),-(428),-(92),-(431),-(317),-(427),-(430),-(320),-(95),-(101),0)) or ((`emailstoreorel`.`OID` in (4328,-(314),-(215),-(159),-(216),4389,4390,4392,4093,4399,4109,4355,4114,4115,1032,1033,1034,3055,1024,1025,1026,1027,1028,1029,1030,1031,3756,3755,4456,4443,4189,3519,3406,3944,3407,3945,3946,3947,3936,3937,3938,3939,3940,3941,3942,3943,4527,4226,3453,3454,3935,3934,1016,3096,1017,1018,4332,1019,1020,1021,1022,1023,3089,1008,1009,3091,1010,3090,3093,1012,1013,3094,1015,1001,1000,1003,1002,1005,1004,1007,1006,997,996,999,3616,3613,3855,3615,3852,3609,3850,3608,3848,3610,3849,3846,3847,3607,3844,3606,3845,3842,3843,3840,3841,4550,4400,4401,4402,4403,4464,4404,4465,4461,4460,4463,4462,4457,4459,4458,3600,3596,3597,3598,3599,3592,3593,3594,3595,3588,3589,3590,3591,-(93),-(101),-(8),-(99),-(50),-(95),-(100),-(98),-(92),-(161),-(380),-(217),-(148),-(307),-(90),-(323),-(321),-(110),-(150),-(103),-(109),-(107),-(149),-(218),-(324),-(88),-(415),-(319),-(320),-(305),-(317),-(427),-(357),-(270),-(279),-(428),-(105),-(366),-(91),-(102),-(365),-(306),-(313),-(311),-(308),-(309),-(9))) and (`emailstore`.`ForeignEditPermission` = 65535))) and (`emailstore`.`GGUID` = `emailstoreorel`.`TableGUID`) and (`rel`.`GUID2` = `todoc7504c2a4c0c38bdbe403da9ca19a0df`.`GGUID`) and (`rel`.`GUID1` = `emailstore`.`GGUID`))2456460