{
  "query_block": {
    "select_id": 1,
    "ordering_operation": {
      "using_temporary_table": true,
      "using_filesort": true,
      "nested_loop": [
        {
          "duplicates_removal": {
            "using_temporary_table": true,
            "nested_loop": [
              {
                "table": {
                  "table_name": "EMAILSTOREORel",
                  "access_type": "range",
                  "possible_keys": [
                    "IDX_EMAILSTOREOREL_OID_EIMRole",
                    "IDX_EMORELTableGUID10",
                    "IDX_EMVORELOID9",
                    "IX_MIXOREL_V517",
                    "IDX_EMAILSTOREORel_Role",
                    "IDX_EMAILSTOREORel_Permission"
                  ] /* possible_keys */,
                  "key": "IDX_EMAILSTOREORel_Permission",
                  "used_key_parts": [
                    "EIMRight"
                  ] /* used_key_parts */,
                  "key_length": "8",
                  "rows": 59465,
                  "filtered": 100,
                  "using_index": true,
                  "attached_condition": "((`svg`.`emailstoreorel`.`EIMRight` >= 64) and ((`svg`.`emailstoreorel`.`OID` in (1014,<cache>(-(426)),<cache>(-(396)),<cache>(-(98)),<cache>(-(305)),<cache>(-(50)),<cache>(-(215)),<cache>(-(8)),<cache>(-(100)),<cache>(-(366)),<cache>(-(88)),<cache>(-(90)),<cache>(-(279)),<cache>(-(319)),<cache>(-(314)),<cache>(-(270)),<cache>(-(99)),<cache>(-(428)),<cache>(-(92)),<cache>(-(431)),<cache>(-(317)),<cache>(-(427)),<cache>(-(430)),<cache>(-(320)),<cache>(-(95)),<cache>(-(101)),0)) or (`svg`.`emailstoreorel`.`OID` in (4328,<cache>(-(314)),<cache>(-(215)),<cache>(-(159)),<cache>(-(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,<cache>(-(93)),<cache>(-(101)),<cache>(-(8)),<cache>(-(99)),<cache>(-(50)),<cache>(-(95)),<cache>(-(100)),<cache>(-(98)),<cache>(-(92)),<cache>(-(161)),<cache>(-(380)),<cache>(-(217)),<cache>(-(148)),<cache>(-(307)),<cache>(-(90)),<cache>(-(323)),<cache>(-(321)),<cache>(-(110)),<cache>(-(150)),<cache>(-(103)),<cache>(-(109)),<cache>(-(107)),<cache>(-(149)),<cache>(-(218)),<cache>(-(324)),<cache>(-(88)),<cache>(-(415)),<cache>(-(319)),<cache>(-(320)),<cache>(-(305)),<cache>(-(317)),<cache>(-(427)),<cache>(-(357)),<cache>(-(270)),<cache>(-(279)),<cache>(-(428)),<cache>(-(105)),<cache>(-(366)),<cache>(-(91)),<cache>(-(102)),<cache>(-(365)),<cache>(-(306)),<cache>(-(313)),<cache>(-(311)),<cache>(-(308)),<cache>(-(309)),<cache>(-(9))))))"
                } /* table */
              },
              {
                "table": {
                  "table_name": "EMAILSTORE",
                  "access_type": "eq_ref",
                  "possible_keys": [
                    "PRIMARY",
                    "IDX_GGUID_UNIQUE"
                  ] /* possible_keys */,
                  "key": "PRIMARY",
                  "used_key_parts": [
                    "GGUID"
                  ] /* used_key_parts */,
                  "key_length": "16",
                  "ref": [
                    "svg.EMAILSTOREORel.TableGUID"
                  ] /* ref */,
                  "rows": 1,
                  "filtered": 100,
                  "attached_condition": "((`svg`.`emailstore`.`IsTemplate` = 0) and (`svg`.`emailstore`.`IsDeleted` = 0) and ((`svg`.`emailstoreorel`.`OID` in (1014,<cache>(-(426)),<cache>(-(396)),<cache>(-(98)),<cache>(-(305)),<cache>(-(50)),<cache>(-(215)),<cache>(-(8)),<cache>(-(100)),<cache>(-(366)),<cache>(-(88)),<cache>(-(90)),<cache>(-(279)),<cache>(-(319)),<cache>(-(314)),<cache>(-(270)),<cache>(-(99)),<cache>(-(428)),<cache>(-(92)),<cache>(-(431)),<cache>(-(317)),<cache>(-(427)),<cache>(-(430)),<cache>(-(320)),<cache>(-(95)),<cache>(-(101)),0)) or ((`svg`.`emailstore`.`ForeignEditPermission` = 65535) and (`svg`.`emailstoreorel`.`OID` in (4328,<cache>(-(314)),<cache>(-(215)),<cache>(-(159)),<cache>(-(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,<cache>(-(93)),<cache>(-(101)),<cache>(-(8)),<cache>(-(99)),<cache>(-(50)),<cache>(-(95)),<cache>(-(100)),<cache>(-(98)),<cache>(-(92)),<cache>(-(161)),<cache>(-(380)),<cache>(-(217)),<cache>(-(148)),<cache>(-(307)),<cache>(-(90)),<cache>(-(323)),<cache>(-(321)),<cache>(-(110)),<cache>(-(150)),<cache>(-(103)),<cache>(-(109)),<cache>(-(107)),<cache>(-(149)),<cache>(-(218)),<cache>(-(324)),<cache>(-(88)),<cache>(-(415)),<cache>(-(319)),<cache>(-(320)),<cache>(-(305)),<cache>(-(317)),<cache>(-(427)),<cache>(-(357)),<cache>(-(270)),<cache>(-(279)),<cache>(-(428)),<cache>(-(105)),<cache>(-(366)),<cache>(-(91)),<cache>(-(102)),<cache>(-(365)),<cache>(-(306)),<cache>(-(313)),<cache>(-(311)),<cache>(-(308)),<cache>(-(309)),<cache>(-(9)))))))"
                } /* table */
              }
            ] /* nested_loop */
          } /* duplicates_removal */
        },
        {
          "table": {
            "table_name": "rel",
            "access_type": "ref",
            "possible_keys": [
              "IDX_GUID1296",
              "IDX_GUID2297",
              "IX_MIDX_V5_1",
              "IX_MIDX_V5_2"
            ] /* possible_keys */,
            "key": "IDX_GUID1296",
            "used_key_parts": [
              "GUID1"
            ] /* used_key_parts */,
            "key_length": "17",
            "ref": [
              "svg.EMAILSTOREORel.TableGUID"
            ] /* ref */,
            "rows": 1,
            "filtered": 100,
            "attached_condition": "(`svg`.`rel`.`GUID2` is not null)"
          } /* table */
        },
        {
          "table": {
            "table_name": "TODOORel",
            "access_type": "ref",
            "possible_keys": [
              "IDX_OID254",
              "IDX_TableGUID255",
              "IDX_TODOOREL_OID_EIMRole",
              "IX_MIXOREL_V510",
              "IDX_TODOORel_Role",
              "IDX_TODOORel_Permission"
            ] /* possible_keys */,
            "key": "IDX_TableGUID255",
            "used_key_parts": [
              "TableGUID"
            ] /* used_key_parts */,
            "key_length": "16",
            "ref": [
              "svg.rel.GUID2"
            ] /* ref */,
            "rows": 1,
            "filtered": 100,
            "attached_condition": "((`svg`.`todoorel`.`EIMRight` >= 64) and ((`svg`.`todoorel`.`OID` in (1014,<cache>(-(426)),<cache>(-(396)),<cache>(-(98)),<cache>(-(305)),<cache>(-(50)),<cache>(-(215)),<cache>(-(8)),<cache>(-(100)),<cache>(-(366)),<cache>(-(88)),<cache>(-(90)),<cache>(-(279)),<cache>(-(319)),<cache>(-(314)),<cache>(-(270)),<cache>(-(99)),<cache>(-(428)),<cache>(-(92)),<cache>(-(431)),<cache>(-(317)),<cache>(-(427)),<cache>(-(430)),<cache>(-(320)),<cache>(-(95)),<cache>(-(101)),0)) or (`svg`.`todoorel`.`OID` in (4328,<cache>(-(314)),<cache>(-(215)),<cache>(-(159)),<cache>(-(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,<cache>(-(93)),<cache>(-(101)),<cache>(-(8)),<cache>(-(99)),<cache>(-(50)),<cache>(-(95)),<cache>(-(100)),<cache>(-(98)),<cache>(-(92)),<cache>(-(161)),<cache>(-(380)),<cache>(-(217)),<cache>(-(148)),<cache>(-(307)),<cache>(-(90)),<cache>(-(323)),<cache>(-(321)),<cache>(-(110)),<cache>(-(150)),<cache>(-(103)),<cache>(-(109)),<cache>(-(107)),<cache>(-(149)),<cache>(-(218)),<cache>(-(324)),<cache>(-(88)),<cache>(-(415)),<cache>(-(319)),<cache>(-(320)),<cache>(-(305)),<cache>(-(317)),<cache>(-(427)),<cache>(-(357)),<cache>(-(270)),<cache>(-(279)),<cache>(-(428)),<cache>(-(105)),<cache>(-(366)),<cache>(-(91)),<cache>(-(102)),<cache>(-(365)),<cache>(-(306)),<cache>(-(313)),<cache>(-(311)),<cache>(-(308)),<cache>(-(309)),<cache>(-(9))))))"
          } /* table */
        },
        {
          "table": {
            "table_name": "TODOC7504C2A4C0C38BDBE403DA9CA19A0DF",
            "access_type": "ALL",
            "possible_keys": [
              "PRIMARY",
              "IDX_GGUID_UNIQUE"
            ] /* possible_keys */,
            "rows": 91822,
            "filtered": 75.001,
            "first_match": "EMAILSTORE",
            "attached_condition": "((`svg`.`todoc7504c2a4c0c38bdbe403da9ca19a0df`.`GGUID` = `svg`.`rel`.`GUID2`) and (`svg`.`todoc7504c2a4c0c38bdbe403da9ca19a0df`.`IsTemplate` = 0) and (`svg`.`todoc7504c2a4c0c38bdbe403da9ca19a0df`.`IsDeleted` = 0) and (`svg`.`todoc7504c2a4c0c38bdbe403da9ca19a0df`.`KEYWORD` like '%antragsanforderung%') and (`svg`.`todoc7504c2a4c0c38bdbe403da9ca19a0df`.`WORKINGPERCENT` = '100') and ((`svg`.`todoorel`.`OID` in (1014,<cache>(-(426)),<cache>(-(396)),<cache>(-(98)),<cache>(-(305)),<cache>(-(50)),<cache>(-(215)),<cache>(-(8)),<cache>(-(100)),<cache>(-(366)),<cache>(-(88)),<cache>(-(90)),<cache>(-(279)),<cache>(-(319)),<cache>(-(314)),<cache>(-(270)),<cache>(-(99)),<cache>(-(428)),<cache>(-(92)),<cache>(-(431)),<cache>(-(317)),<cache>(-(427)),<cache>(-(430)),<cache>(-(320)),<cache>(-(95)),<cache>(-(101)),0)) or ((`svg`.`todoc7504c2a4c0c38bdbe403da9ca19a0df`.`ForeignEditPermission` = 65535) and (`svg`.`todoorel`.`OID` in (4328,<cache>(-(314)),<cache>(-(215)),<cache>(-(159)),<cache>(-(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,<cache>(-(93)),<cache>(-(101)),<cache>(-(8)),<cache>(-(99)),<cache>(-(50)),<cache>(-(95)),<cache>(-(100)),<cache>(-(98)),<cache>(-(92)),<cache>(-(161)),<cache>(-(380)),<cache>(-(217)),<cache>(-(148)),<cache>(-(307)),<cache>(-(90)),<cache>(-(323)),<cache>(-(321)),<cache>(-(110)),<cache>(-(150)),<cache>(-(103)),<cache>(-(109)),<cache>(-(107)),<cache>(-(149)),<cache>(-(218)),<cache>(-(324)),<cache>(-(88)),<cache>(-(415)),<cache>(-(319)),<cache>(-(320)),<cache>(-(305)),<cache>(-(317)),<cache>(-(427)),<cache>(-(357)),<cache>(-(270)),<cache>(-(279)),<cache>(-(428)),<cache>(-(105)),<cache>(-(366)),<cache>(-(91)),<cache>(-(102)),<cache>(-(365)),<cache>(-(306)),<cache>(-(313)),<cache>(-(311)),<cache>(-(308)),<cache>(-(309)),<cache>(-(9)))))))"
          } /* table */
        }
      ] /* nested_loop */
    } /* ordering_operation */
  } /* query_block */
}


Warnings:
======================================

| Note  | 1276 | Field or reference 'svg.TODOC7504C2A4C0C38BDBE403DA9CA19A0DF.ForeignEditPermission' of SELECT #3 was resolved in SELECT #2|
| Note  | 1276 | Field or reference 'svg.EMAILSTORE.ForeignEditPermission' of SELECT #4 was resolved in SELECT #1|
| Note  | 1003 | /* select#1 */ select `svg`.`emailstore`.`IsFormEMail` AS `ISFORMEMAIL`,`svg`.`emailstore`.`SendDate` AS `SENDDATE`,`svg`.`emailstore`.`Subject` AS `SUBJECT`,`svg`.`emailstore`.`XFrom` AS `XFROM`,`svg`.`emailstore`.`XTo` AS `XTO`,`svg`.`emailstore`.`HASATTACHMENTS` AS `HASATTACHMENTS`,`svg`.`emailstore`.`GGUID` AS `GGUID` from `svg`.`emailstore0` `emailstore` semi join (`svg`.`emailstoreorel`) semi join (`svg`.`todoorel` join `svg`.`tablerelation` `rel` join `svg`.`todo0` `todoc7504c2a4c0c38bdbe403da9ca19a0df`) where ((`svg`.`todoorel`.`TableGUID` = `svg`.`rel`.`GUID2`) and (`svg`.`todoc7504c2a4c0c38bdbe403da9ca19a0df`.`GGUID` = `svg`.`rel`.`GUID2`) and (`svg`.`todoc7504c2a4c0c38bdbe403da9ca19a0df`.`IsTemplate` = 0) and (`svg`.`todoc7504c2a4c0c38bdbe403da9ca19a0df`.`IsDeleted` = 0) and (`svg`.`emailstore`.`GGUID` = `svg`.`emailstoreorel`.`TableGUID`) and (`svg`.`rel`.`GUID1` = `svg`.`emailstoreorel`.`TableGUID`) and (`svg`.`emailstore`.`IsTemplate` = 0) and (`svg`.`emailstore`.`IsDeleted` = 0) and (`svg`.`emailstoreorel`.`EIMRight` >= 64) and ((`svg`.`emailstoreorel`.`OID` in (1014,<cache>(-(426)),<cache>(-(396)),<cache>(-(98)),<cache>(-(305)),<cache>(-(50)),<cache>(-(215)),<cache>(-(8)),<cache>(-(100)),<cache>(-(366)),<cache>(-(88)),<cache>(-(90)),<cache>(-(279)),<cache>(-(319)),<cache>(-(314)),<cache>(-(270)),<cache>(-(99)),<cache>(-(428)),<cache>(-(92)),<cache>(-(431)),<cache>(-(317)),<cache>(-(427)),<cache>(-(430)),<cache>(-(320)),<cache>(-(95)),<cache>(-(101)),0)) or ((`svg`.`emailstore`.`ForeignEditPermission` = 65535) and (`svg`.`emailstoreorel`.`OID` in (4328,<cache>(-(314)),<cache>(-(215)),<cache>(-(159)),<cache>(-(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,<cache>(-(93)),<cache>(-(101)),<cache>(-(8)),<cache>(-(99)),<cache>(-(50)),<cache>(-(95)),<cache>(-(100)),<cache>(-(98)),<cache>(-(92)),<cache>(-(161)),<cache>(-(380)),<cache>(-(217)),<cache>(-(148)),<cache>(-(307)),<cache>(-(90)),<cache>(-(323)),<cache>(-(321)),<cache>(-(110)),<cache>(-(150)),<cache>(-(103)),<cache>(-(109)),<cache>(-(107)),<cache>(-(149)),<cache>(-(218)),<cache>(-(324)),<cache>(-(88)),<cache>(-(415)),<cache>(-(319)),<cache>(-(320)),<cache>(-(305)),<cache>(-(317)),<cache>(-(427)),<cache>(-(357)),<cache>(-(270)),<cache>(-(279)),<cache>(-(428)),<cache>(-(105)),<cache>(-(366)),<cache>(-(91)),<cache>(-(102)),<cache>(-(365)),<cache>(-(306)),<cache>(-(313)),<cache>(-(311)),<cache>(-(308)),<cache>(-(309)),<cache>(-(9)))))) and (`svg`.`todoc7504c2a4c0c38bdbe403da9ca19a0df`.`KEYWORD` like '%antragsanforderung%') and (`svg`.`todoc7504c2a4c0c38bdbe403da9ca19a0df`.`WORKINGPERCENT` = '100') and (`svg`.`todoorel`.`EIMRight` >= 64) and ((`svg`.`todoorel`.`OID` in (1014,<cache>(-(426)),<cache>(-(396)),<cache>(-(98)),<cache>(-(305)),<cache>(-(50)),<cache>(-(215)),<cache>(-(8)),<cache>(-(100)),<cache>(-(366)),<cache>(-(88)),<cache>(-(90)),<cache>(-(279)),<cache>(-(319)),<cache>(-(314)),<cache>(-(270)),<cache>(-(99)),<cache>(-(428)),<cache>(-(92)),<cache>(-(431)),<cache>(-(317)),<cache>(-(427)),<cache>(-(430)),<cache>(-(320)),<cache>(-(95)),<cache>(-(101)),0)) or ((`svg`.`todoc7504c2a4c0c38bdbe403da9ca19a0df`.`ForeignEditPermission` = 65535) and (`svg`.`todoorel`.`OID` in (4328,<cache>(-(314)),<cache>(-(215)),<cache>(-(159)),<cache>(-(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,<cache>(-(93)),<cache>(-(101)),<cache>(-(8)),<cache>(-(99)),<cache>(-(50)),<cache>(-(95)),<cache>(-(100)),<cache>(-(98)),<cache>(-(92)),<cache>(-(161)),<cache>(-(380)),<cache>(-(217)),<cache>(-(148)),<cache>(-(307)),<cache>(-(90)),<cache>(-(323)),<cache>(-(321)),<cache>(-(110)),<cache>(-(150)),<cache>(-(103)),<cache>(-(109)),<cache>(-(107)),<cache>(-(149)),<cache>(-(218)),<cache>(-(324)),<cache>(-(88)),<cache>(-(415)),<cache>(-(319)),<cache>(-(320)),<cache>(-(305)),<cache>(-(317)),<cache>(-(427)),<cache>(-(357)),<cache>(-(270)),<cache>(-(279)),<cache>(-(428)),<cache>(-(105)),<cache>(-(366)),<cache>(-(91)),<cache>(-(102)),<cache>(-(365)),<cache>(-(306)),<cache>(-(313)),<cache>(-(311)),<cache>(-(308)),<cache>(-(309)),<cache>(-(9))))))) order by `svg`.`emailstore`.`SendDate` desc,`svg`.`emailstore`.`GGUID` limit 0,100