{
"query_block": {
"select_id": 1,
"table": {
"table_name": "b",
"access_type": "index",
"possible_keys": ["PRIMARY", "c_status"],
"key": "c_status",
"key_length": "6",
"used_key_parts": ["destination_id", "status"],
"rows": 3,
"filtered": 100,
"attached_condition": "b.`status` = 'A'",
"using_index": true
},
"table": {
"table_name": "a",
"access_type": "ref",
"possible_keys": ["c_status"],
"key": "c_status",
"key_length": "3",
"used_key_parts": ["destination_id"],
"ref": ["staging2_wesave_com.b.destination_id"],
"rows": 49,
"filtered": 100
}
}
}
element_id | destination_id | element | element_type |
---|---|---|---|
466 | 7 | 13 | S |
467 | 7 | 12 | S |
468 | 7 | 11 | S |
469 | 7 | 10 | S |
470 | 7 | 15 | S |
471 | 7 | 16 | S |
472 | 7 | 17 | S |
473 | 7 | 18 | S |
474 | 7 | 19 | S |
475 | 7 | 20 | S |
476 | 7 | 21 | S |
477 | 7 | 22 | S |
478 | 7 | 23 | S |
479 | 7 | 24 | S |
480 | 7 | 25 | S |
481 | 7 | 26 | S |
482 | 7 | 27 | S |
483 | 7 | 28 | S |
484 | 7 | 29 | S |
485 | 7 | 30 | S |
486 | 7 | 31 | S |
487 | 7 | 32 | S |
488 | 7 | 33 | S |
489 | 7 | 34 | S |
490 | 7 | 35 | S |
491 | 7 | 36 | S |
492 | 7 | 37 | S |
493 | 7 | 38 | S |
494 | 7 | 39 | S |
495 | 7 | 40 | S |
496 | 7 | 41 | S |
497 | 7 | 42 | S |
498 | 7 | 43 | S |
499 | 7 | 44 | S |
500 | 7 | 45 | S |
501 | 7 | 46 | S |
502 | 7 | 47 | S |
503 | 7 | 48 | S |
504 | 7 | 49 | S |
505 | 7 | 50 | S |
506 | 7 | 51 | S |
507 | 7 | 52 | S |
508 | 7 | 53 | S |
509 | 7 | 54 | S |
510 | 7 | 55 | S |
511 | 7 | 56 | S |
512 | 7 | 57 | S |
513 | 7 | 58 | S |
514 | 7 | 59 | S |
515 | 7 | 60 | S |
516 | 7 | 61 | S |
517 | 7 | 62 | S |
518 | 7 | 63 | S |
519 | 7 | 64 | S |
520 | 7 | US | C |
521 | 7 | * | Z |
522 | 7 | * | T |
523 | 7 | * | A |
351 | 8 | CA | C |