Ad Widget

**vso** · 15-05-2018, 13:58

it should be safe to delete problems that cannot exist, as per foreign key constraint:

Code:

delete from problem where eventid=9775;
delete from problem where eventid=17661;

Something gone wrong during backup. Did you stop zabbix server when performing backup ?

**lukisec** · 15-05-2018, 14:16

i think that yes. ok but can i delete all this problems where evenetid=xxx ? Because there is a lot of this numbers

**vso** · 15-05-2018, 14:27

You need to ensure that this foreign key is respected:

Code:

CONSTRAINT `c_problem_1` FOREIGN KEY (`eventid`) REFERENCES `events` (`eventid`) ON DELETE CASCADE,

Did you disable foreign key checks when importing database ?

**lukisec** · 15-05-2018, 14:32

Thank you for your help,
no i dont disable this.

when i try:

MariaDB [zabbix]> CONSTRAINT `c_problem_1` FOREIGN KEY (`eventid`) REFERENCES `events` (`eventid`) ON DELETE CASCADE;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'CONSTRAINT `c_problem_1` FOREIGN KEY (`eventid`) REFERENCES `events` (`eventid`)' at line 1

**lukisec** · 16-05-2018, 13:17

Could you tell me, it is possible to delete all ?

**vso** · 16-05-2018, 14:31

Can you please show output of following query ?

Code:

select eventid from problem p where not exists (select null from events e where e.eventid=p.eventid);

**lukisec** · 16-05-2018, 14:37

Code:

select eventid from problem p where not exists (select null from events e where e.eventid=p.eventid);
+---------+
| eventid |
+---------+
|       1 |
|       2 |
|      17 |
|      18 |
|      20 |
|      21 |
|      22 |
|      24 |
|      25 |
|      42 |
|      45 |
|      46 |
|      47 |
|      48 |
|      49 |
|      50 |
|      51 |
|      52 |
|      53 |
|      54 |
|      55 |
|      56 |
|      57 |
|      58 |
|      59 |
|      60 |
|      61 |
|      62 |
|      63 |
|      64 |
|      65 |
|      66 |
|      67 |
|      69 |
|      71 |
|      72 |
|      73 |
|      74 |
|      76 |
|      77 |
|      78 |
|      79 |
|      80 |
|      81 |
|      83 |
|      84 |
|      85 |
|      86 |
|      87 |
|      89 |
|      90 |
|      91 |
|      92 |
|      93 |
|      94 |
|      95 |
|      96 |
|      97 |
|      98 |
|      99 |
|     100 |
|     101 |
|     102 |
|     103 |
|     104 |
|     105 |
|     108 |
|     109 |
|     110 |
|     111 |
|     112 |
|     113 |
|     116 |
|     129 |
|     130 |
|     131 |
|     132 |
|     136 |
|     137 |
|     139 |
|     140 |
|     141 |
|     142 |
|     143 |
|     144 |
|     145 |
|     146 |
|     147 |
|     148 |
|     149 |
|     150 |
|     151 |
|     152 |
|     153 |
|     155 |
|     156 |
|     157 |
|     158 |
|     159 |
|     183 |
|     209 |
|     210 |
|     221 |
|     222 |
|     233 |
|     234 |
|     235 |
|     236 |
|     237 |
|     252 |
|     253 |
|     258 |
|     259 |
|     261 |
|     262 |
|     263 |
|     267 |
|     269 |
|     270 |
|     271 |
|     272 |
|     273 |
|     274 |
|     275 |
|     277 |
|     278 |
|     279 |
|     280 |
|     282 |
|     285 |
|     286 |
|     287 |
|     292 |
|     295 |
|     302 |
|     303 |
|     305 |
|     318 |
|     321 |
|     323 |
|     324 |
|     325 |
|     360 |
|     369 |
|     370 |
|     372 |
|     378 |
|     380 |
|     382 |
|     383 |
|     386 |
|     388 |
|     393 |
|     401 |
|     406 |
|     424 |
|     439 |
|     441 |
|     527 |
|     528 |
|     529 |
|     530 |
|     531 |
|     532 |
|     533 |
|     534 |
|     535 |
|     536 |
|     537 |
|     538 |
|     539 |
|     540 |
|     541 |
|     542 |
|     543 |
|     544 |
|     546 |
|     547 |
|     548 |
|     549 |
|     550 |
|     551 |
|     577 |
|     578 |
|     629 |
|     631 |
|     649 |
|     650 |
|     655 |
|     656 |
|     657 |
|     661 |
|     662 |
|     665 |
|     687 |
|     688 |
|     722 |
|     769 |
|     771 |
|     824 |
|     826 |
|     835 |
|     839 |
|    1071 |
|    1072 |
|    1133 |
|    1135 |
|    1137 |
|    1190 |
|    1214 |
|    1306 |
|    1326 |
|    1329 |
|    1386 |
|    1387 |
|    1398 |
|    1418 |
|    1447 |
|    1454 |
|    1456 |
|    1463 |
|    1474 |
|    1496 |
|    1506 |
|    1508 |
|    1509 |
|    1512 |
|    1513 |
|    1514 |
|    1516 |
|    1517 |
|    1610 |
|    1611 |
|    1632 |
|    1633 |
|    1639 |
|    1640 |
|    1657 |
|    1658 |
|    1659 |
|    1660 |
|    1666 |
|    1745 |
|    1758 |
|    1760 |
|    1767 |
|    1778 |
|    1816 |
|    1840 |
|    1841 |
|    1842 |
|    1857 |
|    1903 |
|    1904 |
|    1970 |
|    1996 |
|    1997 |
|    2020 |
|    2065 |
|    2080 |
|    2081 |
|    2091 |
|    2136 |
|    2137 |
|    2194 |
|    2228 |
|    2334 |
|    2385 |
|    2386 |
|    2387 |
|    2388 |
|    2389 |
|    2390 |
|    2415 |
|    2470 |
|    2475 |
|    2476 |
|    2477 |
|    2478 |
|    2479 |
|    2480 |
|    2481 |
|    2482 |
|    2483 |
|    2488 |
|    2492 |
|    2520 |
|    2596 |
|    2638 |
|    2685 |
|    2767 |
|    2768 |
|    2769 |
|    2770 |
|    2771 |
|    2772 |
|    2796 |
|    2909 |
|    2960 |
|    3020 |
|    3056 |
|    3087 |
|    3098 |
|    3099 |
|    3106 |
|    3107 |
|    3136 |
|    3160 |
|    3161 |
|    3163 |
|    3207 |
|    3208 |
|    3218 |
|    3263 |
|    3314 |
|    3378 |
|    3428 |
|    3433 |
|    3434 |
|    3435 |
|    3436 |
|    3437 |
|    3438 |
|    3481 |
|    3583 |
|    3622 |
|    3653 |
|    3745 |
|    3778 |
|    3779 |
|    3796 |
|    3800 |
|    3815 |
|    3816 |
|    3820 |
|    3852 |
|    3853 |
|    3904 |
|    4143 |
|    4237 |
|    4342 |
|    4389 |
|    4404 |
|    4412 |
|    4442 |
|    4652 |
|    4806 |
|    4952 |
|    4953 |
|    4971 |
|    4975 |
|    4976 |
|    5002 |
|    5151 |
|    5304 |
|    5388 |
|    5434 |
|    5539 |
|    5542 |
|    5544 |
|    5570 |
|    5571 |
|    5619 |
|    5766 |
|    5872 |
|    5873 |
|    5876 |
|    5898 |
|    5905 |
|    5943 |
|    5944 |
|    5951 |
|    5972 |
|    5974 |
|    6047 |
|    6066 |
|    6095 |
|    6113 |
|    6118 |
|    6122 |
|    6146 |
|    6147 |
|    6321 |
|    6390 |
|    6434 |
|    6438 |
|    6462 |
|    6467 |
|    6504 |
|    6556 |
|    6641 |
|    6643 |
|    6658 |
|    6663 |
|    6690 |
|    6691 |
|    6692 |
|    6699 |
|    6744 |
|    6783 |
|    6788 |
|    6818 |
|    6828 |
|    6831 |
|    6867 |
|    6942 |
|    6943 |
|    6965 |
|    6967 |
|    6969 |
|    6977 |
|    7000 |
|    7037 |
|    7079 |
|    7116 |
|    7117 |
|    7118 |
|    7164 |
|    7202 |
|    7239 |
|    7240 |
|    7244 |
|    7251 |
|    7274 |
|    7275 |
|    7285 |
|    7320 |
|    7384 |
|    7396 |
|    7402 |
|    7436 |
|    7445 |
|    7452 |
|    7531 |
|    7547 |
|    7552 |
|    7569 |
|    7592 |
|    7593 |
|    7617 |
|    7666 |
|    7680 |
|    7695 |
|    7719 |
|    7729 |
|    7756 |
|    7791 |
|    7795 |
|    7796 |
|    7819 |
|    7831 |
|    7833 |
|    7885 |
|    7905 |
|    8039 |
|    8063 |
|    8082 |
|    8100 |
|    8105 |
|    8115 |
|    8134 |
|    8193 |
|    8201 |
|    8227 |
|    8264 |
|    8326 |
|    8335 |
|    8337 |
|    8340 |
|    8364 |
|    8365 |
|    8378 |
|    8410 |
|    8412 |
|    8423 |
|    8495 |
|    8520 |
|    8551 |
|    8561 |
|    8598 |
|    8613 |
|    8637 |
|    8653 |
|    8657 |
|    8681 |
|    8682 |
|    8700 |
|    8720 |
|    8752 |
|    8793 |
|    8832 |
|    8833 |
|    8904 |
|    8909 |
|    8930 |
|    8936 |
|    8952 |
|    8973 |
|    8980 |
|    9059 |
|    9075 |
|    9118 |
|    9126 |
|    9159 |
|    9165 |
|    9210 |
|    9230 |
|    9231 |
|    9234 |
|    9261 |
|    9264 |
|    9279 |
|    9281 |
|    9297 |
|    9317 |
|    9326 |
|    9365 |
|    9393 |
|    9430 |
|    9461 |
|    9468 |
|    9496 |
|    9523 |
|    9539 |
|    9547 |
|    9577 |
|    9628 |
|    9669 |
|    9676 |
|    9704 |
|    9716 |
|    9721 |
|    9735 |
|    9743 |
|    9773 |
|    9788 |
|    9790 |
|    9803 |
|    9804 |
|    9808 |
|    9825 |
|    9838 |
|    9839 |
|    9840 |
|    9841 |
|    9869 |
|    9873 |
|    9885 |
|    9896 |
|    9987 |
|    9994 |
|    9995 |
|   10013 |
|   10030 |
|   10031 |
|   10035 |
|   10054 |
|   10062 |
|   10090 |
|   10104 |
|   10112 |
|   10113 |
|   10150 |
|   10153 |
|   10173 |
|   10185 |
|   10192 |
|   10228 |
|   10236 |
|   10245 |
|   10246 |
|   10247 |
|   10276 |
|   10277 |
|   10281 |
|   10283 |
|   10314 |
|   10316 |
|   10317 |
|   10326 |
|   10336 |
|   10390 |
|   10394 |
|   10416 |
|   10420 |
|   10426 |
|   10427 |
|   10461 |
|   10526 |
|   10560 |
|   10564 |
|   10601 |
|   10609 |
|   10612 |
|   10617 |
|   10618 |
|   10630 |
|   10631 |
|   10633 |
|   10635 |
|   10665 |
|   10702 |
|   10710 |
|   10738 |
|   10763 |
|   10764 |
|   10770 |
|   10799 |
|   10804 |
|   10826 |
|   10909 |
|   10925 |
|   10933 |
|   10970 |
|   10973 |
|   10977 |
|   11005 |
|   11012 |
|   11047 |
|   11048 |
|   11052 |
|   11053 |
|   11068 |
|   11069 |
|   11109 |
|   11139 |
|   11181 |
|   11186 |
|   11189 |
|   11209 |
|   11216 |
|   11259 |
|   11260 |
|   11269 |
|   11282 |
|   11287 |
|   11321 |
|   11349 |
|   11458 |
|   11484 |
|   11496 |
|   11507 |
|   11526 |
|   11530 |
|   11543 |
|   11560 |
|   11561 |
|   11638 |
|   11750 |
|   11756 |
|   11784 |
|   11787 |
|   11788 |
|   11799 |
|   11854 |
|   11934 |
|   11941 |
|   11950 |
|   11992 |
|   12042 |
|   12071 |
|   12082 |
|   12089 |
|   12096 |
|   12131 |
|   12138 |
|   12173 |
|   12223 |
|   12230 |
|   12231 |
|   12276 |
|   12280 |
|   12281 |
|   12283 |
|   12285 |
|   12315 |
|   12324 |
|   12325 |
|   12353 |
|   12413 |
|   12431 |
|   12482 |
|   12492 |
|   12522 |
|   12549 |
|   12570 |
|   12587 |
|   12598 |
|   12646 |
|   12649 |
|   12655 |
|   12663 |
|   12668 |
|   12674 |
|   12705 |
|   12706 |
|   12764 |
|   12791 |
|   12806 |
|   12817 |
|   12834 |
|   12838 |
|   12859 |
|   12860 |
|   12865 |
|   12866 |
|   12870 |
|   12896 |
|   12906 |
|   12911 |
|   12915 |
|   12938 |
|   12959 |
|   12977 |
|   13094 |
|   13101 |
|   13131 |
|   13169 |
|   13204 |
|   13208 |
|   13216 |
|   13232 |
|   13239 |
|   13251 |
|   13255 |
|   13263 |
|   13264 |
|   13269 |
|   13287 |
|   13291 |
|   13327 |
|   13332 |
|   13377 |
|   13383 |
|   13425 |
|   13443 |
|   13464 |
|   13469 |
|   13472 |
|   13474 |
|   13489 |
|   13494 |
|   13499 |
|   13500 |
|   13504 |
|   13525 |
|   13539 |
|   13547 |
|   13576 |
|   13592 |
|   13595 |
|   13617 |
|   13618 |
|   13632 |
|   13671 |
|   13696 |
|   13698 |
|   13699 |
|   13725 |
|   13728 |
|   13739 |
|   13740 |
|   13751 |
|   13812 |
|   13825 |
|   13835 |
|   13858 |
|   13862 |
|   13892 |
|   13893 |
|   13919 |
|   13934 |
|   14028 |
|   14034 |
|   14040 |
|   14043 |
|   14068 |
|   14128 |
|   14130 |
|   14140 |
|   14165 |
|   14173 |
|   14204 |
|   14231 |
|   14287 |
|   14302 |
|   14311 |
|   14401 |
|   14422 |
|   14426 |
|   14428 |
|   14435 |
|   14449 |
|   14455 |
|   14476 |
|   14492 |
|   14506 |
|   14517 |
|   14518 |
|   14541 |
|   14542 |
|   14560 |
|   14566 |
|   14569 |
|   14597 |
|   14598 |
|   14628 |
|   14641 |
|   14659 |
|   14673 |
|   14683 |
|   14687 |
|   14688 |
|   14689 |
|   14690 |
|   14691 |
|   14692 |
|   14693 |
|   14727 |
|   14729 |
|   14763 |
|   14768 |
|   14769 |
|   14786 |
|   14806 |
|   14811 |
|   14824 |
|   14875 |
|   14882 |
|   14883 |
|   14912 |
|   14939 |
|   14940 |
|   14962 |
|   14997 |
|   15018 |
|   15032 |
|   15033 |
|   15042 |
|   15046 |
|   15069 |
|   15071 |
|   15093 |
|   15105 |
|   15107 |
|   15114 |
|   15152 |
|   15173 |
|   15174 |
|   15203 |
|   15216 |
|   15221 |
|   15222 |
|   15235 |
|   15240 |
|   15270 |
|   15277 |
|   15278 |
|   15309 |
|   15311 |
|   15333 |
|   15334 |
|   15361 |
|   15383 |
|   15386 |
|   15393 |
|   15416 |
|   15424 |
|   15434 |
|   15457 |
|   15458 |
|   15480 |
|   15490 |
|   15493 |
|   15520 |
|   15540 |
|   15543 |
|   15547 |
|   15569 |
|   15582 |
|   15614 |
|   15632 |
|   15648 |
|   15654 |
|   15685 |
|   15686 |
|   15689 |
|   15724 |
|   15732 |
|   15748 |
|   15749 |
|   15753 |
|   15778 |
|   15781 |
|   15783 |
|   15845 |
|   15875 |
|   15903 |
|   16176 |
|   16200 |
|   16204 |
|   16231 |
|   16277 |
|   16278 |
|   16287 |
|   16378 |
|   16418 |
|   16430 |
|   16534 |
|   16535 |
|   16611 |
|   16710 |
|   16748 |
|   16771 |
|   16777 |
|   16808 |
|   16809 |
|   16853 |
|   16887 |
|   16930 |
|   16977 |
|   17004 |
|   17011 |
|   17071 |
|   17119 |
|   17258 |
|   17314 |
|   17315 |
|   17317 |
|   17319 |
|   17344 |
|   17345 |
|   17400 |
|   17406 |
|   17451 |
|   17505 |
|   17548 |
|   17562 |
|   17563 |
|   17564 |
|   17567 |
|   17602 |
|   17631 |
|   17719 |
|   17720 |
|   17736 |
|   17772 |
|   17787 |
|   17812 |
|   17822 |
|   17845 |
|   17846 |
|   17869 |
|   17876 |
|   17887 |
|   17894 |
|   17898 |
|   17910 |
|   17923 |
|   17924 |
|   17925 |
|   17926 |
|   17934 |
|   17962 |
|   17963 |
|   17974 |
|   17990 |
|   18000 |
|   18029 |
|   18042 |
|   18089 |
|   18151 |
|   18183 |
|   18196 |
|   18260 |
|   18288 |
|   18304 |
|   18309 |
|   18349 |
|   18379 |
|   18404 |
|   18417 |
|   18462 |
|   18463 |
|   18484 |
|   18487 |
|   18524 |
|   18525 |
|   18564 |
|   18600 |
|   18646 |
|   18653 |
|   18686 |
|   18700 |
|   18738 |
|   18739 |
|   18784 |
|   18785 |
|   18788 |
|   18843 |
|   18865 |
|   18905 |
|   18912 |
|   18921 |
|   18953 |
|   19009 |
|   19028 |
|   19059 |
|   19102 |
|   19142 |
|   19150 |
|   19159 |
|   19195 |
|   19246 |
|   19345 |
|   19429 |
|   19471 |
|   19480 |
|   19495 |
|   19496 |
|   19525 |
|   19534 |
|   19586 |
|   19591 |
|   19617 |
|   19618 |
|   19626 |
|   19636 |
|   19637 |
|   19640 |
|   19665 |
|   19668 |
|   19711 |
|   19712 |
|   19753 |
|   19865 |
|   19940 |
|   20074 |
|   20076 |
|   20077 |
|   20078 |
|   20079 |
|   20080 |
|   20081 |
|   20082 |
|   20083 |
|   20084 |
|   20095 |
|   20099 |
|   20100 |
|   20101 |
|   20102 |
|   20103 |
|   20104 |
|   20105 |
|   20106 |
|   20107 |
|   20108 |
|   20109 |
|   20110 |
|   20111 |
|   20112 |
|   20113 |
|   20114 |
|   20115 |
|   20116 |
|   20117 |
|   20118 |
|   20119 |
|   20120 |
|   20121 |
|   20122 |
|   20145 |
|   20161 |
|   20165 |
|   20197 |
|   20198 |
|   20238 |
|   20244 |
|   20307 |
|   20322 |
|   20372 |
|   20380 |
|   20431 |
|   20468 |
|   20516 |
|   20602 |
|   20708 |
|   23554 |
|   24107 |
|   24963 |
|   24964 |
|   25252 |
|   25377 |
|   25384 |
|   25886 |
|   26636 |
|   26766 |
|   27098 |
|   27896 |
|   27902 |
|   28688 |
|   28887 |
|   29075 |
|   30066 |
|   30110 |
|   30429 |
|   30796 |
|   30990 |
|   31130 |
|   31544 |
|   31692 |
|   31693 |
|   31768 |
|   31935 |
|   31993 |
|   32550 |
|   32854 |
|   33663 |
|   35378 |
|   36076 |
|   36410 |
|   37095 |
|   39374 |
|   39837 |
|   40918 |
|   41936 |
|   42212 |
|   42214 |
|   42215 |
|   43106 |
|   43344 |
|   44987 |
|   45094 |
|   45242 |
|   45258 |
|   45309 |
|   45313 |
|   46214 |
|   46382 |
|   46842 |
|   46906 |
|   46996 |
|   47219 |
|   47716 |
|   48094 |
|   48344 |
|   49203 |
|   49244 |
|   49530 |
|   49925 |
|   50751 |
|   51498 |
|   53093 |
|   53341 |
|   53792 |
|   54363 |
|   54739 |
|   55244 |
|   56612 |
|   59155 |
|   59515 |
|   59764 |
|   60322 |
|   60901 |
|   61454 |
|   61987 |
|   62837 |
|   63690 |
|   64241 |
|   64242 |
|   64474 |
|   64796 |
|   64797 |
|   66195 |
|   67018 |
|   67282 |
|   67566 |
|   67846 |
|   68119 |
|   68683 |
|   69292 |
|   69780 |
|   69788 |
|   70477 |
|   70887 |
|   72039 |
|   72998 |
|   74176 |
|   74675 |
|   74777 |
|   76148 |
|   76191 |
|   76698 |
|   77015 |
|   77846 |
|   79246 |
|   79400 |
|   79754 |
|   80260 |
|   80327 |
|   80337 |
|   80362 |
|   80682 |
|   81851 |
|   82556 |
|   83668 |
|   84073 |
|   87413 |
|   88597 |
|   88732 |
|   89302 |
|   89878 |
|   90389 |
|   91503 |
|   92858 |
|   92870 |
|   93188 |
|   93629 |
|   93757 |
|   93769 |
|   94295 |
|   94568 |
|   94855 |
|   96624 |
|   96625 |
|   97551 |
|   98013 |
|   98795 |
|   98825 |
|   98849 |
|   98903 |
|   98940 |
|   99479 |
|  100039 |
|  100167 |
|  100954 |
|  102316 |
|  103169 |
|  103623 |
|  103903 |
|  104550 |
|  104551 |
|  105632 |
|  106211 |
|  107278 |
|  107279 |
|  107850 |
|  108416 |
|  108417 |
|  108418 |
|  108909 |
|  109277 |
|  109477 |
|  109478 |
|  109515 |
|  109550 |
|  109551 |
|  110630 |
|  110760 |
|  111720 |
|  111834 |
|  112341 |
|  112368 |
|  112744 |
|  112922 |
|  112923 |
|  112925 |
|  112961 |
|  114323 |
|  114355 |
|  114378 |
|  114406 |
|  114427 |
|  114520 |
|  114572 |
|  114589 |
|  114611 |
|  114616 |
|  114646 |
|  114648 |
|  114693 |
|  114712 |
|  114742 |
|  114839 |
|  114840 |
|  114842 |
|  114873 |
|  114874 |
|  114901 |
|  114922 |
|  114923 |
|  114972 |
|  114973 |
|  115002 |
|  115011 |
|  115012 |
|  115053 |
|  115074 |
|  115075 |
|  115124 |
|  115159 |
|  115190 |
|  115199 |
|  115209 |
|  115223 |
|  115224 |
|  115228 |
|  115229 |
|  115251 |
|  115255 |
|  115256 |
|  115301 |
|  115304 |
|  115314 |
|  115325 |
|  115330 |
|  115331 |
|  115355 |
|  115356 |
|  115383 |
|  115395 |
|  115396 |
|  115461 |
|  115462 |
|  115463 |
|  115507 |
|  115522 |
|  115558 |
|  115560 |
|  115562 |
|  115605 |
|  115625 |
|  115626 |
|  115643 |
|  115656 |
|  115696 |
|  115770 |
|  115771 |
|  115795 |
|  115819 |
|  115822 |
|  115824 |
|  115859 |
|  115860 |
|  115874 |
|  115875 |
|  115911 |
|  115932 |
|  115959 |
|  116042 |
|  116059 |
|  116153 |
|  116169 |
|  116175 |
|  116203 |
|  116219 |
|  116221 |
|  116238 |
|  116245 |
|  116246 |
|  116278 |
|  116298 |
|  116299 |
|  116339 |
|  116340 |
|  116389 |
|  116406 |
|  116407 |
|  116410 |
|  116441 |
|  116442 |
|  116459 |
|  116460 |
|  116504 |
|  116514 |
|  116515 |
|  116547 |
|  116590 |
|  116643 |
|  116683 |
|  116686 |
|  116687 |
|  116718 |
|  116798 |
|  116799 |
|  116817 |
|  116850 |
|  116851 |
|  116887 |
|  116891 |
|  116899 |
|  116927 |
|  116935 |
|  116989 |
|  117000 |
|  117001 |
|  117005 |
|  117013 |
|  117014 |
|  117033 |
|  117036 |
|  117063 |
|  117066 |
|  117124 |
|  117136 |
|  117145 |
|  117177 |
|  117178 |
|  117204 |
|  117277 |
|  117286 |
|  117318 |
|  117319 |
|  117376 |
|  117377 |
|  117406 |
|  117493 |
|  117558 |
|  117559 |
|  117560 |
|  117564 |
|  117592 |
|  117594 |
|  117597 |
|  117622 |
|  117640 |
|  117673 |
|  117702 |
|  117810 |
|  117811 |
|  117852 |
|  117853 |
|  117884 |
|  117920 |
|  117921 |
|  117922 |
|  117950 |
|  117952 |
|  118048 |
|  118112 |
|  118127 |
|  118132 |
|  118160 |
|  118161 |
|  118200 |
|  118216 |
|  118337 |
|  118382 |
|  118522 |
|  118572 |
|  118666 |
|  118682 |
|  118683 |
|  118688 |
|  118711 |
|  118760 |
|  118797 |
|  118841 |
|  118883 |
|  118885 |
|  118990 |
|  119027 |
|  119068 |
|  119155 |
|  119226 |
|  119229 |
|  119230 |
|  119260 |
|  119272 |
|  119273 |
|  119316 |
|  119363 |
|  119457 |
|  119549 |
|  119588 |
|  119670 |
|  119773 |
|  119794 |
|  119798 |
|  119802 |
|  119828 |
|  119829 |
|  119864 |
|  119880 |
|  119904 |
|  120021 |
|  120073 |
|  120085 |
|  120183 |
|  120263 |
|  120270 |
|  120319 |
|  120329 |
|  120341 |
|  120342 |
|  120346 |
|  120379 |
|  120380 |
|  120426 |
|  120460 |
|  120602 |
|  120614 |
|  120652 |
|  120692 |
|  120793 |
|  120808 |
|  120842 |
|  120859 |
|  120863 |
|  120872 |
|  120904 |
|  120958 |
|  121093 |
|  121142 |
|  121187 |
|  121316 |
|  121359 |
|  121374 |
|  121424 |
|  121444 |
|  121447 |
|  121449 |
|  121475 |
|  121476 |
|  121540 |
|  121641 |
|  121650 |
|  121726 |
|  121829 |
|  121870 |
|  121917 |
|  121989 |
|  121992 |
|  121994 |
|  122020 |
|  122095 |
|  122155 |
|  122192 |
|  122202 |
|  122283 |
|  122325 |
|  122342 |
|  122390 |
|  122398 |
|  122429 |
|  122496 |
|  122516 |
|  122534 |
|  122537 |
|  122538 |
|  122565 |
|  122575 |
|  122577 |
|  122621 |
|  122651 |
|  122669 |
|  122857 |
|  122864 |
|  122907 |
|  122993 |
|  123055 |
|  123097 |
|  123123 |
|  123126 |
|  123127 |
|  123153 |
|  123154 |
|  123219 |
|  123241 |
|  123328 |
|  123416 |
|  123457 |
|  123477 |
|  123542 |
|  123544 |
|  123545 |
|  123582 |
|  123583 |
|  123620 |
|  123674 |
|  123678 |
|  123710 |
|  123751 |
|  123940 |
|  123986 |
|  123994 |
|  124006 |
|  124035 |
|  124054 |
|  124077 |
|  124126 |
|  124210 |
|  124220 |
|  124222 |
|  124239 |
|  124240 |
|  124244 |
|  124273 |
|  124316 |
|  124440 |
|  124532 |
|  124588 |
|  124632 |
|  124639 |
|  124720 |
|  124772 |
|  124800 |
|  124804 |
|  124805 |
|  124846 |
|  124847 |
|  124874 |
|  124885 |
|  124913 |
|  124916 |
|  124940 |
|  124980 |
|  124986 |
|  125019 |
|  125071 |
|  125106 |
|  125205 |
|  125244 |
|  125298 |
|  125299 |
|  125356 |
|  125358 |
|  125359 |
|  125361 |
|  125384 |
|  125396 |
|  125427 |
|  125449 |
|  125533 |
|  125573 |
|  125622 |
|  125684 |
|  125738 |
|  125779 |
|  125799 |
|  125920 |
|  125923 |
|  125924 |
|  125951 |
|  125952 |
|  126051 |
|  126071 |
|  126098 |
|  126139 |
|  126177 |
|  126220 |
|  126312 |
|  126352 |
|  126397 |
|  126404 |
|  126411 |
|  126450 |
|  126487 |
|  126492 |
|  126504 |
|  126533 |
|  126556 |
|  126600 |
|  126730 |
|  126758 |
|  126847 |
|  126896 |
|  126943 |
|  126974 |
|  126986 |
|  127025 |
|  127038 |
|  127048 |
|  127051 |
|  127077 |
|  127154 |
|  127246 |
|  127292 |
|  127359 |
|  127396 |
|  127441 |
|  127588 |
|  127591 |
|  127592 |
|  127618 |
|  127681 |
|  127700 |
|  127777 |
|  127821 |
|  127834 |
|  127857 |
|  127864 |
|  127912 |
|  127941 |
|  127975 |
|  127979 |
|  128013 |
|  128063 |
|  128129 |
|  128135 |
|  128182 |
|  128223 |
|  128240 |
|  128303 |
|  128311 |
|  128353 |
|  128366 |
|  128400 |
|  128443 |
|  128537 |
|  128588 |
|  128629 |
|  128658 |
|  128698 |
|  128700 |
|  128705 |
|  128735 |
|  128810 |
|  128849 |
|  128889 |
|  129006 |
|  129089 |
|  129120 |
|  129134 |
|  129222 |
|  129238 |
|  129241 |
|  129243 |
|  129276 |
|  129295 |
|  129463 |
|  129497 |
|  129509 |
|  129650 |
|  129670 |
|  129675 |
|  129709 |
|  129724 |
|  129748 |
|  129762 |
|  129766 |
|  129768 |
|  129800 |
|  129803 |
|  129823 |
|  129826 |
|  129881 |
|  129888 |
|  129898 |
|  129903 |
|  130050 |
|  130094 |
|  130175 |
|  130216 |
|  130288 |
|  130352 |
|  130355 |
|  130357 |
|  130388 |
|  130472 |
|  130533 |
|  130545 |
|  130582 |
|  130876 |
|  130879 |
|  130882 |
|  130883 |
|  130910 |
|  130911 |
|  130962 |
|  131104 |
|  131197 |
|  131252 |
|  131282 |
|  131325 |
|  131396 |
|  131411 |
|  131412 |
|  131414 |
|  131416 |
|  131459 |
|  131520 |
|  131545 |
|  131601 |
|  131727 |
|  131776 |
|  131897 |
|  131917 |
|  131964 |
|  131982 |
|  131987 |
|  132019 |
|  132020 |
|  132030 |
|  132059 |
|  132072 |
|  132122 |
|  132157 |
|  132439 |
|  132464 |
|  132514 |
|  132518 |
|  132520 |
|  132521 |
|  132550 |
|  132553 |
|  132606 |
|  132641 |
|  132793 |
|  132846 |
|  132921 |
|  132935 |
|  132966 |
|  133006 |
|  133021 |
|  133057 |
|  133072 |
|  133073 |
|  133077 |
|  133113 |
|  133179 |
|  133202 |
|  133237 |
|  133279 |
|  133330 |
|  133371 |
|  133514 |
|  133533 |
|  133559 |
|  133627 |
|  133628 |
|  133634 |
|  133667 |
|  133671 |
|  133751 |
|  133795 |
|  133842 |
|  133936 |
|  134034 |
|  134097 |
|  134152 |
|  134153 |
|  134155 |
|  134195 |
|  134243 |
|  134269 |
|  134286 |
|  134345 |
|  134419 |
|  134432 |
|  134535 |
|  134651 |
|  134704 |
|  134708 |
|  134709 |
|  134737 |
|  134741 |
|  134807 |
|  134828 |
|  134851 |
|  134964 |
|  134982 |
|  135147 |
|  135198 |
|  135251 |
|  135259 |
|  135262 |
|  135264 |
|  135292 |
|  135445 |
|  135473 |
|  135644 |
|  135740 |
|  135784 |
|  135794 |
|  135799 |
|  135823 |
|  135909 |
|  135970 |
|  136017 |
|  136102 |
|  136163 |
|  136192 |
|  136237 |
|  136238 |
|  136242 |
|  136251 |
|  136257 |
|  136348 |
|  136351 |
|  136352 |
|  136364 |
|  136379 |
|  136466 |
|  136491 |
|  136607 |
|  136608 |
|  136651 |
|  136698 |
|  136727 |
|  136744 |
|  136785 |
|  136834 |
|  136857 |
|  136898 |
|  136916 |
|  136919 |
|  136921 |
|  136955 |
|  136956 |
|  136984 |
|  137007 |
|  137041 |
|  137042 |
|  137050 |
|  137096 |
|  137136 |
|  137184 |
|  137219 |
|  137229 |
|  137373 |
|  137408 |
|  137477 |
|  137480 |
|  137482 |
|  137506 |
|  137578 |
|  137631 |
|  137678 |
|  137761 |
|  137828 |
|  137938 |
|  137951 |
|  137999 |
|  138014 |
|  138017 |
|  138052 |
|  138138 |
|  138245 |
|  138284 |
|  138371 |
|  138383 |
|  138527 |
|  138544 |
|  138546 |
|  138563 |
|  138564 |
|  138612 |
|  138613 |
|  138706 |
|  138733 |
|  138750 |
|  138755 |
|  138791 |
|  138830 |
|  138873 |
|  139024 |
|  139096 |
|  139114 |
|  139129 |
|  139158 |
|  139195 |
|  139298 |
|  139325 |
|  139402 |
|  139455 |
|  139523 |
|  139562 |
|  139572 |
|  139645 |
|  139660 |
|  139661 |
|  139662 |
|  139665 |
|  139691 |
|  139692 |
|  139755 |
|  139783 |
|  139896 |
|  139939 |
|  139982 |
|  140021 |
|  140160 |
|  140217 |
|  140220 |
|  140222 |
|  140248 |
|  140249 |
|  140272 |
|  140296 |
|  140358 |
|  140390 |
|  140433 |
|  140478 |
|  140537 |
|  140642 |
|  140670 |
|  140716 |
|  140763 |
|  140778 |
|  140779 |
|  140780 |
|  140784 |
|  140810 |
|  140855 |
|  141034 |
|  141061 |
|  141077 |
|  141094 |
|  141158 |
|  141166 |
|  141246 |
|  141286 |
|  141305 |
|  141306 |
|  141308 |
|  141310 |
|  141341 |
|  141354 |
|  141423 |
|  141481 |
|  141493 |
|  141533 |
|  141540 |
|  141592 |
|  141611 |
|  141674 |
|  141785 |
|  141864 |
|  141877 |
|  141880 |
|  141881 |
|  141909 |
|  141910 |
|  141955 |
|  141992 |
|  142066 |
|  142087 |
|  142153 |
|  142163 |
|  142220 |
|  142251 |
|  142279 |
|  142386 |
|  142429 |
|  142430 |
|  142434 |
|  142467 |
|  142468 |
|  142597 |
|  142646 |
|  142652 |
|  142728 |
|  142741 |
|  142742 |
|  142785 |
|  142827 |
|  142931 |
|  142932 |
|  142938 |
|  142953 |
|  142958 |
|  143000 |
|  143001 |
|  143006 |
|  143079 |
|  143157 |
|  143196 |
|  143280 |
|  143374 |
|  143467 |
|  143529 |
|  143533 |
|  143562 |
|  143611 |
|  143659 |
|  143820 |
|  143861 |
|  143921 |
|  144003 |
|  144048 |
|  144067 |
|  144069 |
|  144070 |
|  144071 |
|  144096 |
|  144135 |
|  144139 |
|  144171 |
|  144195 |
|  144290 |
|  144338 |
|  144513 |
|  144547 |
|  144583 |
|  144600 |
|  144603 |
|  144604 |
|  144629 |
|  144630 |
|  144697 |
|  144736 |
|  144790 |
|  144874 |
|  144955 |
|  144997 |
|  145149 |
|  145164 |
|  145167 |
|  145169 |
|  145197 |
|  145198 |
|  145210 |
|  145249 |
|  145335 |
|  145376 |
|  145447 |
|  145487 |
|  145532 |
|  345632 |
|  349894 |
|  351961 |
|  351971 |
|  363466 |
|  365705 |
|  365707 |
|  365718 |
|  365719 |
|  365720 |
|  365755 |
|  365756 |
|  365761 |
|  365762 |
|  365765 |
|  365766 |
|  365767 |
|  365768 |
|  365771 |
|  365772 |
|  365773 |
|  365774 |
|  365775 |
|  365777 |
|  365778 |
|  365779 |
|  365780 |
|  365781 |
|  365788 |
|  365789 |
|  365790 |
|  365791 |
|  365792 |
|  365794 |
|  365804 |
|  365805 |
|  365810 |
|  365811 |
|  365812 |
|  365813 |
|  365815 |
|  365816 |
|  365817 |
|  365818 |
|  365819 |
|  365820 |
|  365824 |
|  365825 |
|  365826 |
|  365827 |
|  365832 |
|  365833 |
|  365834 |
|  365835 |
|  365836 |
|  365838 |
|  365839 |
|  365840 |
|  365841 |
|  365842 |
|  365843 |
|  365848 |
|  365853 |
|  365854 |
|  365855 |
|  365863 |
|  365864 |
|  365865 |
|  365866 |
|  365867 |
|  365868 |
|  365869 |
|  365870 |
|  365871 |
|  365872 |
|  365873 |
|  365874 |
|  365875 |
|  365876 |
|  365877 |
|  365878 |
|  365879 |
|  365880 |
|  365881 |
|  365891 |
|  365892 |
|  365893 |
|  365894 |
|  365895 |
|  365897 |
|  365898 |
|  365899 |
|  365900 |
|  365901 |
|  365902 |
|  365903 |
|  365904 |
|  365905 |
|  365906 |
|  365907 |
|  365908 |
|  365909 |
|  365910 |
|  365911 |
|  365912 |
|  365913 |
|  365914 |
|  365915 |
|  365916 |
|  365917 |
|  365921 |
|  365922 |
|  365924 |
|  365930 |
|  365931 |
|  365932 |
|  365933 |
|  365934 |
|  365935 |
|  365936 |
|  365941 |
|  365942 |
|  365945 |
|  365946 |
|  365947 |
|  365948 |
|  365950 |
|  365951 |
|  365954 |
|  365955 |
|  365956 |
|  365958 |
|  365959 |
|  365960 |
|  365961 |
|  365966 |
|  365967 |
|  365968 |
|  365969 |
|  365970 |
|  365971 |
|  365972 |
|  365973 |
|  365974 |
|  365975 |
|  365976 |
|  365977 |
|  365978 |
|  365979 |
|  365980 |
|  365981 |
|  365982 |
|  365987 |
|  365988 |
|  365989 |
|  365990 |
|  365995 |
|  365996 |
|  366001 |
|  366002 |
|  366003 |
|  366004 |
|  366005 |
|  366006 |
|  366011 |
|  366012 |
|  366013 |
|  366014 |
|  366015 |
|  366016 |
|  366017 |
|  366018 |
|  366019 |
|  366020 |
|  366021 |
|  366032 |
|  366040 |
|  366048 |
|  366050 |
|  366539 |
|  366540 |
|  366543 |
|  366544 |
|  366549 |
|  366550 |
|  366555 |
|  366556 |
|  366559 |
|  366560 |
|  366563 |
|  366564 |
|  366566 |
|  366567 |
|  366568 |
|  366569 |
|  366570 |
|  366574 |
|  366575 |
|  366578 |
|  366579 |
|  366580 |
|  366581 |
|  366582 |
|  366583 |
|  366584 |
|  366585 |
|  366587 |
|  366588 |
|  366589 |
|  366590 |
|  366591 |
|  366592 |
|  366595 |
|  366596 |
|  366598 |
|  366599 |
|  366600 |
|  366601 |
|  366602 |
|  366603 |
|  366604 |
|  366605 |
|  366606 |
|  366607 |
|  366608 |
|  366610 |
|  366624 |
|  366627 |
|  366648 |
|  366649 |
|  366650 |
|  366651 |
|  366658 |
|  366659 |
|  366679 |
|  366680 |
|  367352 |
|  448456 |
|  448524 |
|  468837 |
|  481669 |
|  481916 |
|  497332 |
|  497481 |
|  497482 |
|  497487 |
|  497488 |
|  497891 |
|  497983 |
|  498767 |
|  498768 |
|  499139 |
|  499140 |
|  553086 |
|  614595 |
|  614596 |
|  614597 |
|  614598 |
|  614599 |
|  614600 |
|  614601 |
|  614602 |
|  614606 |
|  614608 |
|  614609 |
|  614610 |
|  614613 |
|  614614 |
|  614617 |
|  614618 |
|  614700 |
|  614702 |
|  614704 |
|  614706 |
|  614708 |
|  614710 |
|  614711 |
|  614712 |
|  614713 |
|  614714 |
|  614716 |
|  614718 |
|  614719 |
|  614720 |
|  614721 |
|  614722 |
|  614749 |
|  614750 |
|  614751 |
|  614752 |
|  614753 |
|  614754 |
|  614755 |
|  614756 |
|  614757 |
|  614758 |
|  614759 |
|  614760 |
|  614761 |
|  614762 |
|  614763 |
|  614764 |
|  614765 |
|  614766 |
|  614849 |
|  614854 |
|  614857 |
|  614860 |
|  614865 |
|  614868 |
|  614871 |
|  616216 |
|  616490 |
|  616546 |
|  616654 |
|  616805 |
|  616981 |
|  616985 |
|  616992 |
|  617015 |
|  617030 |
|  666544 |
|  666547 |
|  666842 |
|  666844 |
|  915385 |
|  946994 |
|  947011 |
|  947077 |
|  967387 |
|  967388 |
|  967910 |
|  967911 |
|  967912 |
|  967913 |
|  967914 |
|  981578 |
|  981579 |
|  981580 |
|  981583 |
|  981585 |
|  981587 |
|  981591 |
|  981592 |
|  981593 |
|  981596 |
|  981597 |
|  981598 |
|  981600 |
|  981601 |
|  981602 |
|  981603 |
|  981604 |
|  981605 |
|  981606 |
|  981609 |
|  981610 |
|  981611 |
|  981612 |
|  981613 |
|  981614 |
|  981615 |
|  991620 |
| 1049057 |
| 1049058 |
| 1049059 |
| 1049074 |
| 1049134 |
| 1049138 |
| 1049141 |
| 1049142 |
| 1065811 |
| 1107474 |
| 1108770 |
| 1175483 |
| 1224461 |
| 1224462 |
| 1224463 |
| 1224464 |
| 1224465 |
| 1224466 |
| 1224467 |
| 1224468 |
| 1224469 |
| 1224561 |
| 1224562 |
| 1275522 |
| 1275523 |
| 1275524 |
| 1275525 |
| 1275526 |
| 1275527 |
| 1275528 |
| 1275529 |
| 1275530 |
| 1275531 |
| 1275532 |
| 1275533 |
| 1275534 |
| 1275535 |
| 1275536 |
| 1275537 |
| 1275538 |
| 1275539 |
| 1275540 |
| 1275541 |
| 1275542 |
| 1288043 |
| 1302794 |
| 1302795 |
| 1302796 |
| 1302797 |
| 1302798 |
| 1302799 |
| 1302800 |
| 1302801 |
| 1302802 |
| 1302803 |
| 1302804 |
| 1302805 |
| 1302806 |
| 1302807 |
| 1302808 |
| 1302815 |
| 1302816 |
| 1302817 |
| 1302881 |
| 1302882 |
| 1302883 |
| 1302884 |
| 1302885 |
| 1302886 |
| 1302887 |
| 1302888 |
| 1302889 |
| 1302890 |
| 1302891 |
| 1302892 |
| 1302893 |
| 1302894 |
| 1302895 |
| 1302899 |
| 1302900 |
| 1302901 |
| 1302972 |
| 1303080 |
| 1303120 |
| 1303121 |
| 1303122 |
| 1303123 |
| 1303124 |
| 1303125 |
| 1303126 |
| 1303127 |
| 1303128 |
| 1303129 |
| 1303130 |
| 1303131 |
| 1303132 |
| 1303133 |
| 1303134 |
| 1303137 |
| 1303138 |
| 1303139 |
| 1303183 |
| 1303184 |
| 1303185 |
| 1303186 |
| 1303187 |
| 1303188 |
| 1303189 |
| 1303190 |
| 1303191 |
| 1303192 |
| 1303193 |
| 1303194 |
| 1303195 |
| 1303196 |
| 1303197 |
| 1303204 |
| 1303205 |
| 1303206 |
| 1303257 |
| 1303258 |
| 1303259 |
| 1303260 |
| 1303261 |
| 1303262 |
| 1303263 |
| 1303264 |
| 1303265 |
| 1303266 |
| 1303267 |
| 1303268 |
| 1303269 |
| 1303270 |
| 1303271 |
| 1303274 |
| 1303275 |
| 1303276 |
| 1303303 |
| 1303304 |
| 1303305 |
| 1303306 |
| 1303307 |
| 1303308 |
| 1303309 |
| 1303310 |
| 1303311 |
| 1303312 |
| 1303313 |
| 1303314 |
| 1303315 |
| 1303316 |
| 1303317 |
| 1303320 |
| 1303321 |
| 1303322 |
| 1303376 |
| 1303377 |
| 1303378 |
| 1303379 |
| 1303380 |
| 1303381 |
| 1303382 |
| 1303383 |
| 1303384 |
| 1303385 |
| 1303386 |
| 1303387 |
| 1303388 |
| 1303389 |
| 1303390 |
| 1303392 |
| 1303393 |
| 1303394 |
| 1303444 |
| 1303445 |
| 1303446 |
| 1303447 |
| 1303448 |
| 1303449 |
| 1303450 |
| 1303451 |
| 1303452 |
| 1303453 |
| 1303454 |
| 1303455 |
| 1303456 |
| 1303457 |
| 1303458 |
| 1303462 |
| 1303463 |
| 1303464 |
| 1303544 |
| 1303545 |
| 1303546 |
| 1303547 |
| 1303548 |
| 1303549 |
| 1303550 |
| 1303551 |
| 1303552 |
| 1303553 |
| 1303554 |
| 1303555 |
| 1303556 |
| 1303557 |
| 1303558 |
| 1303568 |
| 1303569 |
| 1303570 |
| 1303675 |
| 1303686 |
| 1303710 |
| 1303711 |
| 1303712 |
| 1303713 |
| 1303714 |
| 1303715 |
| 1303716 |
| 1303717 |
| 1303718 |
| 1303719 |
| 1303720 |
| 1303721 |
| 1303722 |
| 1303723 |
| 1303724 |
| 1303725 |
| 1303726 |
| 1303727 |
| 1303728 |
| 1303729 |
| 1303730 |
| 1303922 |
| 1303923 |
| 1303924 |
| 1303925 |
| 1303926 |
| 1303927 |
| 1303928 |
| 1303929 |
| 1303930 |
| 1303931 |
| 1303932 |
| 1303933 |
| 1303934 |
| 1303935 |
| 1303936 |
| 1303937 |
| 1303938 |
| 1303939 |
| 1304054 |
| 1304055 |
| 1304056 |
| 1304057 |
| 1304058 |
| 1304059 |
| 1304060 |
| 1304061 |
| 1304062 |
| 1304063 |
| 1304064 |
| 1304065 |
| 1304066 |
| 1304067 |
| 1304068 |
| 1304069 |
| 1304070 |
| 1304071 |
| 1304091 |
| 1304092 |
| 1304093 |
| 1304094 |
| 1304095 |
| 1304096 |
| 1304097 |
| 1304098 |
| 1304099 |
| 1304100 |
| 1304101 |
| 1304102 |
| 1304103 |
| 1304104 |
| 1304105 |
| 1304106 |
| 1304107 |
| 1304108 |
| 1304181 |
| 1304182 |
| 1304183 |
| 1304184 |
| 1304185 |
| 1304186 |
| 1304187 |
| 1304188 |
| 1304189 |
| 1304190 |
| 1304191 |
| 1304192 |
| 1304193 |
| 1304194 |
| 1304195 |
| 1304196 |
| 1304197 |
| 1304198 |
| 1304301 |
| 1304302 |
| 1304303 |
| 1304304 |
| 1304305 |
| 1304318 |
| 1304319 |
| 1304400 |
| 1304401 |
| 1304402 |
| 1304403 |
| 1304404 |
| 1304593 |
| 1304594 |
| 1304595 |
| 1304763 |
| 1304764 |
| 1304765 |
| 1304766 |
| 1304767 |
| 1304768 |
| 1304769 |
| 1304770 |
| 1304771 |
| 1304772 |
| 1304773 |
| 1304774 |
| 1304775 |
| 1304776 |
| 1304777 |
| 1304778 |
| 1304779 |
| 1304780 |
| 1304786 |
| 1304787 |
| 1304788 |
| 1304832 |
| 1304841 |
| 1304883 |
| 1304884 |
| 1304937 |
| 1304938 |
| 1305046 |
| 1305047 |
| 1305657 |
| 1305658 |
| 1305659 |
| 1305660 |
| 1305661 |
| 1305662 |
| 1305663 |
| 1305664 |
| 1305673 |
| 1305674 |
| 1305675 |
| 1305676 |
| 1305677 |
| 1305678 |
| 1305679 |
| 1305680 |
| 1305860 |
| 1305861 |
| 1305870 |
| 1305871 |
| 1317222 |
| 1317223 |
| 1320262 |
| 1320263 |
| 1407990 |
| 1407991 |
| 1436551 |
| 1436556 |
| 1436557 |
| 1436558 |
| 1436559 |
| 1436560 |
| 1436561 |
| 1436562 |
| 1436563 |
| 1436564 |
| 1436565 |
| 1436566 |
| 1436567 |
| 1436568 |
| 1436569 |
| 1436570 |
| 1436571 |
| 1436572 |
| 1446715 |
| 1499597 |
| 1499604 |
| 1499605 |
| 1499606 |
| 1499607 |
| 1499608 |
| 1499609 |
| 1499610 |
| 1499611 |
| 1499612 |
| 1499613 |
| 1499614 |
| 1499615 |
| 1499616 |
| 1499617 |
| 1499618 |
| 1499619 |
| 1499620 |
| 1508400 |
| 1510683 |
| 1522612 |
| 1522616 |
| 1539056 |
| 1580296 |
| 1611888 |
| 1611889 |
| 1632009 |
| 1634200 |
| 1634201 |
| 1651389 |
| 1651400 |
| 1651401 |
| 1651402 |
| 1651403 |
| 1651404 |
| 1651405 |
| 1651406 |
| 1651407 |
| 1651408 |
| 1651409 |
| 1651410 |
| 1651411 |
| 1651412 |
| 1651413 |
| 1651414 |
| 1651415 |
| 1651416 |
| 1670753 |
| 1711916 |
| 1711917 |
| 1711924 |
| 1711925 |
| 1711926 |
| 1711927 |
| 1711928 |
| 1711930 |
| 1711931 |
| 1719744 |
| 1719745 |
| 1719746 |
| 1719747 |
| 1719748 |
| 1719749 |
| 1726069 |
| 1726070 |
| 1739623 |
| 1739626 |
| 1740763 |
| 1740764 |
| 1788371 |
| 1793281 |
| 1793282 |
| 1819642 |
| 1819680 |
| 1819700 |
| 1819738 |
| 1819952 |
| 1819989 |
| 1820022 |
| 1820036 |
| 1820051 |
| 1820073 |
| 1820552 |
| 1820691 |
| 1830904 |
| 1830905 |
| 1834027 |
| 1837771 |
| 1837772 |
| 1838955 |
| 1838956 |
+---------+

**vso** · 16-05-2018, 19:28

You could do a backup and try query below, but no guarantees:

Code:

delete from problem where not exists (select null from events where events.eventid=problem.eventid);

**lukisec** · 18-05-2018, 10:02

Hi!
SOLVED! That works!
Thank you very much for your help!
BR

**lukisec** · 27-07-2018, 14:46

Hi, again, can someone can help mi with:

2289:20180727:144058.831 [Z3005] query failed: [1062] Duplicate entry '199718' for key 'PRIMARY' [insert into event_recovery (eventid,r_eventid,correlationid, c_eventid,userid) values (199470,227423,null,null,null),(197966,227423,null ,null ,null),(199718,227423,null,null,null),(196898,2274 23,null,null,null),(197801,227 423,null,null,null),(197088,227423,null,null,null) ,(209889,227423,null,null,null ),(210468,227423,null,null,null),(198748,227423,nu ll,null,null),(196920,227423,n ull,null,null),(197146,227423,null,null,null),(202 113,227423,null,null,null),(19 7660,227423,null,null,null),(202180,227423,null,nu ll,null),(211480,227423,null,n ull,null),(198944,227423,null,null,null),(197391,2 27423,null,null,null),(210437, 227423,null,null,null),(199932,227423,null,null,nu ll),(202066,227423,null,null,n ull),(227422,227423,null,null,null),(197868,227423 ,null,null,null),(199749,22742 3,null,null,null),(197030,227423,null,null,null),( 199360,227423,null,null,null), (210915,227423,null,null,null),(196965,227423,null ,null,null),(200014,227423,nul l,null,null),(199196,227423,null,null,null),(19984 4,227423,null,null,null),(2114 09,227423,null,null,null),(198971,227423,null,null ,null),(202220,227423,null,nul l,null),(197431,227423,null,null,null),(198634,227 423,null,null,null),(198833,22 7423,null,null,null),(199976,227423,null,null,null ),(197207,227423,null,null,nul l),(199910,227423,null,null,null),(211745,227423,n ull,null,null),(199416,227423, null,null,null),(211281,227423,null,null,null),(20 2045,227423,null,null,null),(2 27006,227423,null,null,null),(199956,227423,null,n ull,null),(198791,227423,null, null,null),(210057,227423,null,null,null),(211701, 227423,null,null,null),(196860 ,227423,null,null,null),(227358,227423,null,null,n ull),(197634,227423,null,null, null),(199562,227423,null,null,null),(201986,22742 3,null,null,null),(210576,2274 23,null,null,null),(199668,227423,null,null,null), (197707,227423,null,null,null) ,(199150,227423,null,null,null),(198866,227423,nul l,null,null),(202287,227423,nu ll,null,null),(200054,227423,null,null,null),(1992 49,227423,null,null,null),(210 677,227423,null,null,null),(198061,227423,null,nul l,null),(201954,227423,null,nu ll,null),(197172,227423,null,null,null),(199489,22 7423,null,null,null),(211514,2 27423,null,null,null),(211432,227423,null,null,nul l),(211884,227423,null,null,nu ll),(199060,227423,null,null,null),(199875,227423, null,null,null),(211122,227423 ,null,null,null),(198695,227423,null,null,null),(1 96819,227423,null,null,null),( 198928,227423,null,null,null),(200498,227423,null, null,null),(210735,227423,null ,null,null),(198181,227423,null,null,null),(210806 ,227423,null,null,null),(21034 7,227423,null,null,null),(199625,227423,null,null, null),(210403,227423,null,null

**dferrari** · 05-07-2022, 20:14

Originally posted by vso

You could do a backup and try query below, but no guarantees:

Code:

delete from problem where not exists (select null from events where events.eventid=problem.eventid);

Perfect for me !!
Thanks

Ad Widget

Trgiger status Problem - after restore database

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment