{
"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": 11,
"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": ["ymonline_livedata.b.destination_id"],
"rows": 60,
"filtered": 100
}
}
}
element_id | destination_id | element | element_type |
---|---|---|---|
1011 | 1 | 753 | S |
1010 | 1 | 853 | S |
1009 | 1 | 840 | S |
1008 | 1 | 842 | S |
1007 | 1 | 843 | S |
1006 | 1 | 844 | S |
1005 | 1 | 845 | S |
1004 | 1 | 846 | S |
1003 | 1 | 852 | S |
1002 | 1 | 849 | S |
1001 | 1 | 850 | S |
1012 | 1 | 754 | S |
1013 | 1 | 755 | S |
1014 | 1 | 757 | S |
1015 | 1 | 758 | S |
1016 | 1 | 759 | S |
1017 | 1 | 762 | S |
1018 | 1 | 760 | S |
1019 | 1 | 761 | S |
1020 | 1 | 756 | S |
1021 | 1 | 763 | S |
1022 | 1 | 149 | S |
1023 | 1 | 150 | S |
1024 | 1 | 151 | S |
1025 | 1 | 152 | S |
1026 | 1 | 153 | S |
1027 | 1 | 154 | S |
1028 | 1 | 155 | S |
1029 | 1 | 156 | S |
1030 | 1 | 764 | S |
1031 | 1 | 769 | S |
1032 | 1 | 765 | S |
1033 | 1 | 766 | S |
1034 | 1 | 768 | S |
1035 | 1 | 767 | S |
1036 | 1 | 770 | S |
1037 | 1 | 688 | S |
1038 | 1 | 136 | S |
1039 | 1 | 137 | S |
1040 | 1 | 138 | S |
1041 | 1 | 139 | S |
1042 | 1 | 140 | S |
1043 | 1 | 141 | S |
1044 | 1 | 142 | S |
1045 | 1 | 143 | S |
1046 | 1 | 144 | S |
1047 | 1 | 145 | S |
1048 | 1 | 146 | S |
1049 | 1 | 147 | S |
1050 | 1 | 148 | S |
1051 | 1 | 74 | S |
1052 | 1 | 66 | S |
1053 | 1 | 67 | S |
1054 | 1 | 68 | S |
1055 | 1 | 69 | S |
1056 | 1 | 70 | S |
1057 | 1 | 71 | S |
1058 | 1 | 72 | S |
1059 | 1 | 73 | S |
1060 | 1 | 75 | S |
1061 | 1 | 76 | S |
1062 | 1 | 624 | S |
1063 | 1 | 77 | S |
1064 | 1 | 78 | S |
1065 | 1 | 79 | S |
1066 | 1 | 80 | S |
1067 | 1 | 81 | S |
1068 | 1 | 82 | S |
1069 | 1 | 83 | S |
1070 | 1 | 84 | S |
1071 | 1 | 85 | S |
1072 | 1 | 86 | S |
1073 | 1 | 87 | S |
1074 | 1 | 635 | S |
1075 | 1 | 88 | S |
1076 | 1 | 89 | S |
1077 | 1 | 90 | S |
1078 | 1 | 91 | S |
1079 | 1 | 92 | S |
1080 | 1 | 93 | S |
1081 | 1 | 94 | S |
1082 | 1 | 95 | S |
1083 | 1 | 96 | S |
1084 | 1 | 97 | S |
1085 | 1 | 625 | S |
1086 | 1 | 98 | S |
1087 | 1 | 99 | S |
1088 | 1 | 100 | S |
1089 | 1 | 101 | S |
1090 | 1 | 627 | S |
1091 | 1 | 631 | S |
1092 | 1 | 102 | S |
1093 | 1 | 103 | S |
1094 | 1 | 622 | S |
1095 | 1 | 104 | S |
1096 | 1 | 105 | S |
1097 | 1 | 106 | S |
1098 | 1 | 107 | S |
1099 | 1 | 108 | S |
1100 | 1 | 109 | S |
1101 | 1 | 110 | S |
1102 | 1 | 111 | S |
1103 | 1 | 112 | S |
1104 | 1 | 113 | S |
1105 | 1 | 114 | S |
1106 | 1 | 115 | S |
1107 | 1 | 116 | S |
1108 | 1 | 117 | S |
1109 | 1 | 118 | S |
1110 | 1 | 119 | S |
1111 | 1 | 120 | S |
1112 | 1 | 121 | S |
1113 | 1 | 610 | S |
1114 | 1 | 611 | S |
1115 | 1 | 612 | S |
1116 | 1 | 613 | S |
1117 | 1 | 614 | S |
1118 | 1 | 615 | S |
1119 | 1 | 616 | S |
1120 | 1 | 617 | S |
1121 | 1 | 618 | S |
1122 | 1 | 122 | S |
1123 | 1 | 619 | S |
1124 | 1 | 620 | S |
1125 | 1 | 621 | S |
1126 | 1 | 623 | S |
1127 | 1 | 626 | S |
1128 | 1 | 628 | S |
1129 | 1 | 629 | S |
1130 | 1 | 630 | S |
1131 | 1 | 633 | S |
1132 | 1 | 632 | S |
1133 | 1 | 123 | S |
1134 | 1 | 124 | S |
1135 | 1 | 125 | S |
1136 | 1 | 126 | S |
1137 | 1 | 127 | S |
1138 | 1 | 128 | S |
1139 | 1 | 129 | S |
1140 | 1 | 130 | S |
1141 | 1 | 131 | S |
1142 | 1 | 132 | S |
1143 | 1 | 133 | S |
1144 | 1 | 134 | S |
1145 | 1 | 135 | S |
1146 | 1 | 634 | S |
1147 | 1 | 169 | S |
1148 | 1 | 170 | S |
1149 | 1 | 171 | S |
1150 | 1 | 172 | S |
1151 | 1 | 173 | S |
1152 | 1 | 174 | S |
1153 | 1 | 175 | S |
1154 | 1 | 176 | S |
1155 | 1 | 177 | S |
1156 | 1 | 178 | S |
1157 | 1 | 179 | S |
1158 | 1 | 180 | S |
1159 | 1 | 181 | S |
1160 | 1 | 182 | S |
1161 | 1 | 183 | S |
1162 | 1 | 184 | S |
1163 | 1 | 706 | S |
1164 | 1 | 702 | S |
1165 | 1 | 704 | S |
1166 | 1 | 703 | S |
1167 | 1 | 705 | S |
1168 | 1 | 707 | S |
1169 | 1 | 708 | S |
1170 | 1 | 726 | S |
1171 | 1 | 750 | S |
1172 | 1 | 751 | S |
1173 | 1 | 752 | S |
1174 | 1 | 725 | S |
1175 | 1 | 729 | S |
1176 | 1 | 730 | S |
1177 | 1 | 711 | S |
1178 | 1 | 710 | S |
1179 | 1 | 716 | S |
1180 | 1 | 713 | S |
1181 | 1 | 712 | S |
1182 | 1 | 714 | S |
1183 | 1 | 748 | S |
1184 | 1 | 709 | S |
1185 | 1 | 718 | S |
1186 | 1 | 717 | S |
1187 | 1 | 721 | S |
1188 | 1 | 723 | S |
1189 | 1 | 724 | S |
1190 | 1 | 722 | S |
1191 | 1 | 727 | S |
1192 | 1 | 728 | S |
1193 | 1 | 731 | S |
1194 | 1 | 732 | S |
1195 | 1 | 733 | S |
1196 | 1 | 735 | S |
1197 | 1 | 734 | S |
1198 | 1 | 736 | S |
1199 | 1 | 737 | S |
1200 | 1 | 739 | S |
1201 | 1 | 749 | S |
1202 | 1 | 747 | S |
1203 | 1 | 740 | S |
1204 | 1 | 741 | S |
1205 | 1 | 742 | S |
1206 | 1 | 743 | S |
1207 | 1 | 744 | S |
1208 | 1 | 745 | S |
1209 | 1 | 719 | S |
1210 | 1 | 720 | S |
1211 | 1 | 746 | S |
1212 | 1 | 738 | S |
1213 | 1 | 715 | S |
1214 | 1 | 820 | S |
1215 | 1 | 839 | S |
1216 | 1 | 831 | S |
1217 | 1 | 821 | S |
1218 | 1 | 822 | S |
1219 | 1 | 823 | S |
1220 | 1 | 824 | S |
1221 | 1 | 835 | S |
1222 | 1 | 825 | S |
1223 | 1 | 826 | S |
1224 | 1 | 827 | S |
1225 | 1 | 828 | S |
1226 | 1 | 829 | S |
1227 | 1 | 830 | S |
1228 | 1 | 836 | S |
1229 | 1 | 837 | S |
1230 | 1 | 838 | S |
1231 | 1 | 832 | S |
1232 | 1 | 833 | S |
1233 | 1 | 834 | S |
1234 | 1 | 782 | S |
1235 | 1 | 783 | S |
1236 | 1 | 781 | S |
1237 | 1 | 779 | S |
1238 | 1 | 780 | S |
1239 | 1 | 784 | S |
1240 | 1 | 788 | S |
1241 | 1 | 789 | S |
1242 | 1 | 790 | S |
1243 | 1 | 791 | S |
1244 | 1 | 792 | S |
1245 | 1 | 793 | S |
1246 | 1 | 785 | S |
1247 | 1 | 794 | S |
1248 | 1 | 787 | S |
1249 | 1 | 786 | S |
1250 | 1 | 771 | S |
1251 | 1 | 775 | S |
1252 | 1 | 773 | S |
1253 | 1 | 777 | S |
1254 | 1 | 778 | S |
1255 | 1 | 772 | S |
1256 | 1 | 774 | S |
1257 | 1 | 776 | S |
1258 | 1 | 157 | S |
1259 | 1 | 158 | S |
1260 | 1 | 159 | S |
1261 | 1 | 160 | S |
1262 | 1 | 161 | S |
1263 | 1 | 162 | S |
1264 | 1 | 163 | S |
1265 | 1 | 164 | S |
1266 | 1 | 165 | S |
1267 | 1 | 166 | S |
1268 | 1 | 167 | S |
1269 | 1 | 168 | S |
1270 | 1 | 543 | S |
1271 | 1 | 550 | S |
1272 | 1 | 551 | S |
1273 | 1 | 552 | S |
1274 | 1 | 553 | S |
1275 | 1 | 554 | S |
1276 | 1 | 541 | S |
1277 | 1 | 595 | S |
1278 | 1 | 606 | S |
1279 | 1 | 542 | S |
1280 | 1 | 600 | S |
1281 | 1 | 549 | S |
1282 | 1 | 605 | S |
1283 | 1 | 560 | S |
1284 | 1 | 559 | S |
1285 | 1 | 607 | S |
1286 | 1 | 597 | S |
1287 | 1 | 528 | S |
1288 | 1 | 561 | S |
1289 | 1 | 562 | S |
1290 | 1 | 609 | S |
1291 | 1 | 530 | S |
1292 | 1 | 564 | S |
1293 | 1 | 565 | S |
1294 | 1 | 566 | S |
1295 | 1 | 544 | S |
1296 | 1 | 545 | S |
1297 | 1 | 567 | S |
1298 | 1 | 568 | S |
1299 | 1 | 569 | S |
1300 | 1 | 570 | S |
1301 | 1 | 571 | S |
1302 | 1 | 572 | S |
1303 | 1 | 598 | S |
1304 | 1 | 573 | S |
1305 | 1 | 603 | S |
1306 | 1 | 574 | S |
1307 | 1 | 575 | S |
1308 | 1 | 576 | S |
1309 | 1 | 577 | S |
1310 | 1 | 578 | S |
1311 | 1 | 579 | S |
1312 | 1 | 580 | S |
1313 | 1 | 546 | S |
1314 | 1 | 547 | S |
1315 | 1 | 581 | S |
1316 | 1 | 522 | S |
1317 | 1 | 523 | S |
1318 | 1 | 524 | S |
1319 | 1 | 525 | S |
1320 | 1 | 526 | S |
1321 | 1 | 540 | S |
1322 | 1 | 527 | S |
1323 | 1 | 529 | S |
1324 | 1 | 531 | S |
1325 | 1 | 532 | S |
1326 | 1 | 533 | S |
1327 | 1 | 534 | S |
1328 | 1 | 535 | S |
1329 | 1 | 536 | S |
1330 | 1 | 537 | S |
1331 | 1 | 538 | S |
1332 | 1 | 583 | S |
1333 | 1 | 582 | S |
1334 | 1 | 586 | S |
1335 | 1 | 584 | S |
1336 | 1 | 599 | S |
1337 | 1 | 585 | S |
1338 | 1 | 588 | S |
1339 | 1 | 548 | S |
1340 | 1 | 587 | S |
1341 | 1 | 589 | S |
1342 | 1 | 593 | S |
1343 | 1 | 591 | S |
1344 | 1 | 592 | S |
1345 | 1 | 590 | S |
1346 | 1 | 539 | S |
1347 | 1 | 594 | S |
1348 | 1 | 555 | S |
1349 | 1 | 556 | S |
1350 | 1 | 557 | S |
1351 | 1 | 558 | S |
1352 | 1 | 608 | S |
1353 | 1 | 636 | S |
1354 | 1 | 637 | S |
1355 | 1 | 638 | S |
1356 | 1 | 639 | S |
1357 | 1 | 640 | S |
1358 | 1 | 641 | S |
1359 | 1 | 642 | S |
1360 | 1 | 643 | S |
1361 | 1 | 644 | S |
1362 | 1 | 645 | S |
1363 | 1 | 646 | S |
1364 | 1 | 647 | S |
1365 | 1 | 648 | S |
1366 | 1 | 649 | S |
1367 | 1 | 650 | S |
1368 | 1 | 651 | S |
1369 | 1 | 652 | S |
1370 | 1 | 653 | S |
1371 | 1 | 654 | S |
1372 | 1 | 655 | S |
1373 | 1 | 656 | S |
1374 | 1 | 657 | S |
1375 | 1 | 658 | S |
1376 | 1 | 659 | S |
1377 | 1 | 660 | S |
1378 | 1 | 661 | S |
1379 | 1 | 662 | S |
1380 | 1 | 663 | S |
1381 | 1 | 664 | S |
1382 | 1 | 665 | S |
1383 | 1 | 666 | S |
1384 | 1 | 667 | S |
1385 | 1 | 668 | S |
1386 | 1 | 669 | S |
1387 | 1 | 670 | S |
1388 | 1 | 671 | S |
1389 | 1 | 672 | S |
1390 | 1 | 673 | S |
1391 | 1 | 674 | S |
1392 | 1 | 675 | S |
1393 | 1 | 676 | S |
1394 | 1 | 677 | S |
1395 | 1 | 678 | S |
1396 | 1 | 679 | S |
1397 | 1 | 680 | S |
1398 | 1 | 681 | S |
1399 | 1 | 682 | S |
1400 | 1 | 683 | S |
1401 | 1 | 684 | S |
1402 | 1 | 685 | S |
1403 | 1 | 686 | S |
1404 | 1 | 687 | S |
1405 | 1 | 307 | S |
1406 | 1 | 309 | S |
1407 | 1 | 294 | S |
1408 | 1 | 302 | S |
1409 | 1 | 310 | S |
1410 | 1 | 286 | S |
1411 | 1 | 292 | S |
1412 | 1 | 305 | S |
1413 | 1 | 301 | S |
1414 | 1 | 285 | S |
1415 | 1 | 298 | S |
1416 | 1 | 293 | S |
1417 | 1 | 299 | S |
1418 | 1 | 306 | S |
1419 | 1 | 303 | S |
1420 | 1 | 290 | S |
1421 | 1 | 304 | S |
1422 | 1 | 297 | S |
1423 | 1 | 300 | S |
1424 | 1 | 289 | S |
1425 | 1 | 296 | S |
1426 | 1 | 295 | S |
1427 | 1 | 287 | S |
1428 | 1 | 288 | S |
1429 | 1 | 308 | S |
1430 | 1 | 291 | S |
1431 | 1 | 817 | S |
1432 | 1 | 818 | S |
1433 | 1 | 819 | S |
1434 | 1 | 798 | S |
1435 | 1 | 799 | S |
1436 | 1 | 804 | S |
1437 | 1 | 814 | S |
1438 | 1 | 815 | S |
1439 | 1 | 816 | S |
1440 | 1 | 807 | S |
1441 | 1 | 805 | S |
1442 | 1 | 806 | S |
1443 | 1 | 797 | S |
1444 | 1 | 808 | S |
1445 | 1 | 809 | S |
1446 | 1 | 810 | S |
1447 | 1 | 811 | S |
1448 | 1 | 801 | S |
1449 | 1 | 812 | S |
1450 | 1 | 813 | S |
1451 | 1 | 795 | S |
1452 | 1 | 796 | S |
1453 | 1 | 802 | S |
1454 | 1 | 803 | S |
1455 | 1 | 800 | S |
1456 | 1 | 185 | S |
1457 | 1 | 186 | S |
1458 | 1 | 187 | S |
1459 | 1 | 188 | S |
1460 | 1 | 189 | S |
1461 | 1 | 499 | S |
1462 | 1 | 506 | S |
1463 | 1 | 190 | S |
1464 | 1 | 191 | S |
1465 | 1 | 507 | S |
1466 | 1 | 192 | S |
1467 | 1 | 193 | S |
1468 | 1 | 194 | S |
1469 | 1 | 195 | S |
1470 | 1 | 196 | S |
1471 | 1 | 508 | S |
1472 | 1 | 197 | S |
1473 | 1 | 198 | S |
1474 | 1 | 199 | S |
1475 | 1 | 200 | S |
1476 | 1 | 201 | S |
1477 | 1 | 202 | S |
1478 | 1 | 500 | S |
1479 | 1 | 519 | S |
1480 | 1 | 203 | S |
1481 | 1 | 204 | S |
1482 | 1 | 492 | S |
1483 | 1 | 493 | S |
1484 | 1 | 494 | S |
1485 | 1 | 495 | S |
1486 | 1 | 496 | S |
1487 | 1 | 497 | S |
1488 | 1 | 501 | S |
1489 | 1 | 205 | S |
1490 | 1 | 206 | S |
1491 | 1 | 207 | S |
1492 | 1 | 208 | S |
1493 | 1 | 209 | S |
1494 | 1 | 509 | S |
1495 | 1 | 210 | S |
1496 | 1 | 211 | S |
1497 | 1 | 520 | S |
1498 | 1 | 212 | S |
1499 | 1 | 213 | S |
1500 | 1 | 214 | S |
1501 | 1 | 215 | S |
1502 | 1 | 216 | S |
1503 | 1 | 217 | S |
1504 | 1 | 218 | S |
1505 | 1 | 219 | S |
1506 | 1 | 220 | S |
1507 | 1 | 221 | S |
1508 | 1 | 222 | S |
1509 | 1 | 223 | S |
1510 | 1 | 224 | S |
1511 | 1 | 225 | S |
1512 | 1 | 226 | S |
1513 | 1 | 227 | S |
1514 | 1 | 228 | S |
1515 | 1 | 229 | S |
1516 | 1 | 230 | S |
1517 | 1 | 231 | S |
1518 | 1 | 504 | S |
1519 | 1 | 232 | S |
1520 | 1 | 510 | S |
1521 | 1 | 233 | S |
1522 | 1 | 503 | S |
1523 | 1 | 234 | S |
1524 | 1 | 511 | S |
1525 | 1 | 235 | S |
1526 | 1 | 236 | S |
1527 | 1 | 237 | S |
1528 | 1 | 521 | S |
1529 | 1 | 238 | S |
1530 | 1 | 239 | S |
1531 | 1 | 502 | S |
1532 | 1 | 240 | S |
1533 | 1 | 241 | S |
1534 | 1 | 242 | S |
1535 | 1 | 512 | S |
1536 | 1 | 243 | S |
1537 | 1 | 244 | S |
1538 | 1 | 245 | S |
1539 | 1 | 246 | S |
1540 | 1 | 247 | S |
1541 | 1 | 248 | S |
1542 | 1 | 249 | S |
1543 | 1 | 250 | S |
1544 | 1 | 251 | S |
1545 | 1 | 252 | S |
1546 | 1 | 253 | S |
1547 | 1 | 513 | S |
1548 | 1 | 254 | S |
1549 | 1 | 255 | S |
1550 | 1 | 256 | S |
1551 | 1 | 257 | S |
1552 | 1 | 258 | S |
1553 | 1 | 514 | S |
1554 | 1 | 259 | S |
1555 | 1 | 260 | S |
1556 | 1 | 515 | S |
1557 | 1 | 261 | S |
1558 | 1 | 262 | S |
1559 | 1 | 263 | S |
1560 | 1 | 264 | S |
1561 | 1 | 265 | S |
1562 | 1 | 505 | S |
1563 | 1 | 267 | S |
1564 | 1 | 268 | S |
1565 | 1 | 516 | S |
1566 | 1 | 269 | S |
1567 | 1 | 270 | S |
1568 | 1 | 517 | S |
1569 | 1 | 271 | S |
1570 | 1 | 272 | S |
1571 | 1 | 273 | S |
1572 | 1 | 274 | S |
1573 | 1 | 275 | S |
1574 | 1 | 276 | S |
1575 | 1 | 277 | S |
1576 | 1 | 278 | S |
1577 | 1 | 279 | S |
1578 | 1 | 280 | S |
1579 | 1 | 281 | S |
1580 | 1 | 518 | S |
1581 | 1 | 282 | S |
1582 | 1 | 283 | S |
1583 | 1 | 284 | S |
1584 | 1 | 266 | S |
1585 | 1 | 10 | S |
1586 | 1 | 11 | S |
1587 | 1 | 12 | S |
1588 | 1 | 13 | S |
1589 | 1 | 15 | S |
1590 | 1 | 16 | S |
1591 | 1 | 17 | S |
1592 | 1 | 18 | S |
1593 | 1 | 19 | S |
1594 | 1 | 20 | S |
1595 | 1 | 21 | S |
1596 | 1 | 22 | S |
1597 | 1 | 23 | S |
1598 | 1 | 24 | S |
1599 | 1 | 25 | S |
1600 | 1 | 26 | S |
1601 | 1 | 27 | S |
1602 | 1 | 28 | S |
1603 | 1 | 29 | S |
1604 | 1 | 30 | S |
1605 | 1 | 31 | S |
1606 | 1 | 32 | S |
1607 | 1 | 33 | S |
1608 | 1 | 34 | S |
1609 | 1 | 35 | S |
1610 | 1 | 36 | S |
1611 | 1 | 37 | S |
1612 | 1 | 38 | S |
1613 | 1 | 39 | S |
1614 | 1 | 40 | S |
1615 | 1 | 41 | S |
1616 | 1 | 42 | S |
1617 | 1 | 43 | S |
1618 | 1 | 44 | S |
1619 | 1 | 45 | S |
1620 | 1 | 46 | S |
1621 | 1 | 498 | S |
1622 | 1 | 47 | S |
1623 | 1 | 48 | S |
1624 | 1 | 49 | S |
1625 | 1 | 50 | S |
1626 | 1 | 51 | S |
1627 | 1 | 52 | S |
1628 | 1 | 53 | S |
1629 | 1 | 54 | S |
1630 | 1 | 55 | S |
1631 | 1 | 56 | S |
1632 | 1 | 57 | S |
1633 | 1 | 58 | S |
1634 | 1 | 59 | S |
1635 | 1 | 60 | S |
1636 | 1 | 61 | S |
1637 | 1 | 62 | S |
1638 | 1 | 63 | S |
1639 | 1 | 64 | S |
1640 | 1 | BW | C |
1641 | 1 | NA | C |
1642 | 1 | ZA | C |
1643 | 1 | ZW | C |
1659 | 11 | BW | C |
1658 | 11 | 853 | S |
900 | 12 | BW | C |
899 | 12 | 849 | S |
884 | 13 | BW | C |
883 | 13 | 840 | S |
896 | 14 | BW | C |
895 | 14 | 852 | S |
888 | 15 | BW | C |
887 | 15 | 843 | S |
890 | 16 | BW | C |
889 | 16 | 844 | S |
894 | 17 | BW | C |
893 | 17 | 846 | S |
892 | 18 | BW | C |
891 | 18 | 845 | S |
902 | 19 | BW | C |
901 | 19 | 850 | S |
886 | 20 | BW | C |
885 | 20 | 842 | S |