Forum Stats

  • 3,724,400 Users
  • 2,244,749 Discussions
  • 7,850,995 Comments

Discussions

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

How To resolve ORA-00913: too many values

Rajan Sw
Rajan Sw Member Posts: 344 Blue Ribbon
edited May 2017 in SQL & PL/SQL

Hi I have a sql stmt where I am using not in like the one attached .

While deleting I am encountering with this issue .

Any thoughts how to resolve this .

Thanks in Advance

Currently using Oracle 11g R2

John ThortonGaz in OzIgoroshkaBrunoVromanWilliam Robertsonjaramill

Answers

  • BrunoVroman
    BrunoVroman Member Posts: 1,848 Silver Crown
    edited May 2017

    Hello,

    what an awful statement! I have seen developers generating the same kind of things in one of our databases, with statements like

    SELECT ... FROM ... WHERE ... AND ( id IN ( 123, 456, ..., 3456 ) OR id IN ( 345, 7567, ... ) OR ( ... and so on with a total of more than 18000 values listed.

    The trick of the IN (...) OR IN ( ... ) OR ... is to workaround the limitation of 1000 elements maximum in a "IN-list". Awful.

    I guess -but I will not check- that in your statement there is at least one of the IN ( ... ) that contains more than 1000 elements.

    You might change your mind and for example insert all your values in another table, to delete the rows that are not in the other table (with a join). Alternatively if you delete a large portion of the rows you might also work in the opposite direction: create a table with the rows that you want to keep and replace "event" with this new version (then create indexes, constraints...)

    Best regards,

    Bruno Vroman.

  • John Thorton
    John Thorton Member Posts: 14,493 Silver Crown
    edited May 2017
    960593 wrote:Hi I have a sql stmt where I am using not in like the one attached .While deleting I am encountering with this issue .Any thoughts how to resolve this .Thanks in AdvanceCurrently using Oracle 11g R2

    Is COPY & Paste broken for you?

    Re: 2. How do I ask a question on the forums?

  • Rajan Sw
    Rajan Sw Member Posts: 344 Blue Ribbon
    edited May 2017

    Thanks Brunovroman  for the quick response .

    This particular sql is being called from the Java application and I have little authority to change it .

    As you advised this will be most effective if we insert in a GTT and delete but this has been working other envs and having issues in a particular env .

    Just want to identify the issue ..Why there are issues if we put this way

  • EdStevens
    EdStevens Member Posts: 27,993 Gold Crown
    edited May 2017
    960593 wrote:Thanks Brunovroman for the quick response .This particular sql is being called from the Java application and I have little authority to change it .As you advised this will be most effective if we insert in a GTT and delete but this has been working other envs and having issues in a particular env .Just want to identify the issue ..Why there are issues if we put this way 

    So what is different from "a particular env" from the "working other envs" ?

  • Rajan Sw
    Rajan Sw Member Posts: 344 Blue Ribbon
    edited May 2017

    This env has huge data to be deleted ..

    I think this is the only difference

  • John Thorton
    John Thorton Member Posts: 14,493 Silver Crown
    edited May 2017
    960593 wrote:This env has huge data to be deleted ..I think this is the only difference

    present implementation does NOT scale to infinity & beyond.

    IN Condition

    "You can specify up to 1000 expressions in expression_list."

  • Unknown
    edited May 2017
    This particular sql is being called from the Java application and I have little authority to change it .

    Then find someone that DOES HAVE the authority to change it and tell them to change it.

    As you advised this will be most effective if we insert in a GTT and delete but this has been working other envs and having issues in a particular env .

    But you also said those 'other envs' only have small amounts of data. So don't compare apples to oranges. It doesn't make any difference if it works fine in 'other envs' if those envs aren't the same as the one you have trouble with.

    Just want to identify the issue ..Why there are issues if we put this way 

    The exception ALREADY identified the issue. What part of 'too many values' don't you understand.

    As others have said, and as the docs say, you are limited to 1000 values. So what do you think 'too many' means in relation to 1000?

    The way you are doing it will NOT WORK at all with 'too many values' and won't be efficient even for fewer values.

    Your choices are:

    1. do it the way you are doing it and have problems

    2. change the way you are doing it to do it right

    Please choose one of the above and let us know which one you choose.

    John Thorton
  • Rajan Sw
    Rajan Sw Member Posts: 344 Blue Ribbon
    edited May 2017

    I can ensure there are not condition with more than 1000 values as the same sql is working fine other envs .

    Still not clear why this is not working when I am not providing more than 1000 values ..I can implement other methods that is fine for me but at the same time I need to understand what is the issue with the current approach

  • Unknown
    edited May 2017
    I can ensure there are not condition with more than 1000 values as the same sql is working fine other envs .

    So you say

    But this is what Oracle says:

    ORA-00913: too many values

    We know NOTHING about you. But we have PLENTY of experience with Oracle.

    So based ONLY on what you have posted (which does NOT include the actual query that Oracle dealt with) if you are asking us to choose between believing you and believing Oracle:

    Our answer is: we believe Oracle.

    We will continue to believe Oracle until you provide PROOF that Oracle is wrong.

    John Thorton
  • Rajan Sw
    Rajan Sw Member Posts: 344 Blue Ribbon
    edited May 2017

    Hi ..  I am not asking you to believe .

    Would you please check the real delete stmt attached in the original question then we can confirm we have conditions more than 1000 values or not .

  • John Thorton
    John Thorton Member Posts: 14,493 Silver Crown
    edited May 2017
    960593 wrote:Hi .. I am not asking you to believe .Would you please check the real delete stmt attached in the original question then we can confirm we have conditions more than 1000 values or not .

    posted statement is meaningless since we can't know for sure that it actually produced the error you report.

    You have mystery & we have no confirmable clues.

    How can we reproduce what you report?

    COPY & PASTE the whole session so we can see what you do & how Oracle responds.

    I know Oracle better reports reality than you.

  • jaramill
    jaramill Member Posts: 4,299 Gold Trophy
    edited May 2017

    I know the majority of people will NOT download and open up a zip file posted by someone anonymous online.  Just stupid to risk viruses, malware, ransomware, etc....you get the point right?

    And since you CONTINUE to ignore everyone's post about "COPY & PASTING" the ACTUAL query instead of putting it in a zip file, then we'll continue to ignore your pleas for help.

    Oracle says TOO MANY VALUES, just like it says TOO_MANY_ROWS when running a select into statement in a PL/SQL block that returns more than 1 row, TOO MANY VALUES means just that.  TOO MANY past 1000.

  • Rajan Sw
    Rajan Sw Member Posts: 344 Blue Ribbon
    edited May 2017

    Hi .. Here is the sql

    DELETE FROM event WHERE

    event_id NOT IN ( 1,2,3,4,21,22,24,25,26,27,28,31,33,34,35,36,37,38,39,40,41,42,43,44,45,46,55,56,57,58,59,60,62,63,65,66,67,68,69,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,100,101,102,104,105,106,107,108,109,110,111,112,113,115,116,117,118,119,120,126,128,129,130,131,132,133,134,135,137,138,139,140,141,142,143,145,146,147,149,150,151,152,154,162,164,166,167,171,183,185,186,187,188,190,192,193,194,195,196,197,198,199,200,201,202,204,205,206,208,209,210,211,212,213,214,215,216,217,218,219,220,221,222,223,224,225,226,227,228,229,230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,267,268,269,2000,2002,20000,20001,20002,20003,20004,20005,20006,20007,20008,20009,20010,20011,20012,20014,20015,20017,20018,20019,20020,20021,20022,20023,20024,20025,20026,20027,20028,20029,20030,20031,20032,20033,20034,20035,20037,20038,20039,20040,20041,20042,20043,20045,20046,20047,20048,20049,20050,20051,20052,20053,20054,20055,20056,20057,20058,20059,20060,20061,20062,20063,20064,20065,20066,20067,20068,20069,20070,20071,20072,20073,20074,20075,20076,20077,20078,20079,20080,20081,20082,20083,20084,20085,20086,20088,20089,20090,20091,20092,20093,20094,20095,20096,20097,20098,20099,20100,20101,20102,20103,20104,20106,20107,20108,20109,20110,20111,20112,20113,20114,20116,20117,20119,20120,20122,20123,20125,20127,20128,20129,20130,20131,20133,20134,20135,20136,20137,50015,50071,50073,50074,50159,50166,50264,50283,50314,50439,50494,50700,50701,50720,50833,51043,51049,51117,51283,51314,51459,51531,51568,51614,51750,51783,51897,51958,51985,52070,52152,52198,52230,52251,52254,52268,52347,52392,52535,52605,52860,52916,53086,53137,53161,53187,53226,53272,53395,53413,53429,53447,53524,53634,53698,53764,53785,53862,53966,54015,54271,54296,54329,54345,54420,54463,54571,54606,54653,54730,55147,55206,55370,55516,55565,55657,55717,55779,55829,55906,55914,55935,56018,56046,56163,56192,56194,56248,56276,56305,56351,56466,56583,56595,56735,56793,56860,56968,56983,57061,57070,57093,57176,57243,57260,57332,57340,57372,57473,57527,57583,57666,57730,57776,57817,57889,57967,57973,58061,58123,58152,58170,58194,58201,58251,58464,58515,58542,58566,58684,58700,58742,58745,58826,58964,58985,58988,59106,59109,59118,59126,59159,59470,59483,59495,59601,59734,59737,59781,59834,59866,59877,60144,60170,60191,60204,60601,60629,60651,60680,60684,60720,60725,60860,60897,60914,60965,61028,61147,61184,61197,61277,61286,61439,61495,61601,61604,61609,61614,61635,61813,61866,61906,61959,62067,62103,62215,62291,62358,62456,62462,62472,62558,62614,62711,62737,62789,62845,62847,62958,63035,63181,63494,63543,63624,63674,63710,63780,63809,63828,63839,63947,63971,64060,64066,64157,64185,64209,64227,64300,64311,64368,64435,64498,64564,64581,64588,64620,64669,64758,64855,64892,64985,65230,65292,65346,65363,65365,65396,65399,65670,65828,65839,65849,65868,65890,65973,66011,66114,66183,66192,66273,66400,66485,66492,66606,66656,66663,66666,66908,67014,67028,67032,67042,67057,67074,67088,67161,67167,67319,67335,67378,67524,67572,67583,67588,67609,67615,67629,67673,67724,67760,67765,67787,67932,67933,68065,68112,68222,68259,68334,68382,68430,68457,68468,68469,68473,68558,68635,68774,68805,68833,68914,68938,68951,68965,68976,69004,69016,69070,69176,69193,69256,69293,69320,69411,69440,69477,69481,69531,69540,69608,69631,69744,69794,69832,69836,69880,69962,69988,70058,70275,70318,70362,70552,70555,70750,70797,70897,71177,71198,71337,71473,71495,71681,71748,71971,72023,72027,72045,72109,72237,72291,72304,72354,72395,72431,72529,72686,72749,72800,72817,72914,72987,73025,73061,73216,73253,73379,73485,73553,73603,73679,73809,73860,73901,73909,73956,74042,74058,74180,74234,74328,74354,74436,74453,74577,74691,74800,74805,74857,74869,74931,74985,75090,75114,75158,75202,75206,75214,75324,75346,75427,75432,75453,75553,75596,75700,75796,75824,75845,75902,75921,75994,76012,76130,76158,76232,76264,76292,76320,76346,76416,76418,76427,76579,76849,76853,76891,76927,77100,77103,77124,77198,77201,77337,77370,77418,77560,77649,77707,77713,77794,77818,78009,78099,78185,78534,78555,78736,78800,78816,78872,78971,79006,79041,79081,79326,79392,79506,79543,79743,79979,80035,80171,80173,80226,80230,80260,80316,80355,80387,80425,80434,80494,80584,80691,80792,80802,80879,80929,80996,81049,81066,81072,81154,81187,81214,81550,81615,81713,81836,81855,81862,81921,82014,82158,82182,82280,82341,82385,82477,82531,82596,82736,82854,82923,83041,83056,83145,83225,83380,83433,83463,83555,83739,83796,83799,83917,83977,83989,84112,84184,84218,84222,84251,84310,84368,84409,84501,84511,84551,84553,84700,84877,85000,85091,85117,85123,85237,85247,85271,85536,85544,85568,85619,85704,85743,85916,85964,86090,86149,86155,86226,86245,86253,86396,86462,86579,86586,86830,86839,86867,86971,87097,87253,87256,87257,87327,87560,87618,87636,87652,87668,87700,87759,87760,87893,87911,87966,87967,88016,88099,88209,88302,88365,88521,88549,88642,88647,88656,88891,88894,88954,89168,89213,89247,89300,89319,89408,89423,89428,89473,89585,89595,89689,89697,89806,89966,90010,90012,90041,90096,90127,90160,90213,90221,90253,90461,90491,90497,90622,90651,90742,90789,90852,91076) AND

    event_id NOT IN (91180,91188,91388,91457,91532,91567,91642,91712,91788,91874,91899,91918,91982,91994,92179,92187,92326,92339,92378,92396,92579,92731,92871,92895,92992,93003,93008,93009,93115,93161,93274,93294,93386,93411,93493,93496,93552,93559,93850,93869,93938,94095,94127,94189,94230,94309,94390,94393,94398,94413,94449,94469,94542,94703,94745,94869,94956,95010,95014,95093,95166,95311,95420,95495,95503,95574,95690,95717,95739,96047,96117,96161,96326,96399,96441,96475,96674,96688,96697,96733,96743,96814,96839,97030,97271,97352,97382,97496,97498,97530,97539,97558,97612,97625,97771,97823,97915,98047,98069,98090,98167,98289,98306,98340,98565,98587,98608,98612,98651,98704,98751,98900,98917,98994,99050,99160,99170,99195,99203,99223,99235,99243,99244,99333,99495,99504,99640,99831,99915,100099,100107,100212,100330,100417,100540,100567,100718,100964,101075,101170,101189,101190,101396,101638,101659,101706,101787,101924,101948,102137,102343,102545,102614,102811,102861,102888,102899,102948,103049,103095,103114,103177,103339,103346,103401,103454,103456,103760,103808,103823,103832,103905,103971,103996,104008,104061,104100,104289,104393,104429,104523,104663,104679,104801,104881,104948,104950,105080,105232,105288,105362,105373,105589,105597,105638,105656,105663,105897,105917,105946,106073,106080,106092,106122,106153,106188,106253,106257,106313,106314,106375,106387,106400,106405,106419,106695,106752,106783,106794,106928,106929,107042,107061,107063,107236,107319,107374,107498,107597,107691,107846,107869,107991,107994,108055,108130,108216,108220,108358,108511,108529,108543,108586,108658,108894,108990,109037,109059,109126,109154,109253,109265,109286,109384,109397,109549,109560,109565,109621,109630,109778,109780,109828,109875,109933,109954,109964,109966,110005,110099,110133,110220,110239,110271,110276,110278,110287,110289,110293,110295,110334,110407,110415,110470,110512,110654,110674,110778,110856,110933,110937,110955,111016,111080,111115,111117,111222,111255,111267,111280,111320,111388,111476,111530,111558,111602,111741,111773,111786,111807,111911,111935,111955,111964,112043,112226,112239,112253,112427,112465,112591,112660,112675,112714,112760,112771,112863,113122,113184,113212,113319,113337,113452,113478,113505,113581,113658,113772,113890,113951,114032,114132,114190,114208,114241,114262,114371,114435,114562,114569,114592,114619,114633,114674,114690,114697,114778,114814,114838,114883,115062,115073,115078,115089,115196,115198,115271,115277,115298,115330,115421,115452,115482,115509,115724,115787,115796,115956,116088,116096,116194,116383,116436,116628,116665,116676,116688,116773,116794,116840,116883,116933,116953,117056,117163,117280,117294,117354,117392,117497,117569,117601,117638,117770,117796,117802,117958,117970,118032,118101,118222,118285,118358,118421,118437,118550,118602,118719,118750,118756,118777,118864,118870,118905,118966,119058,119263,119520,119606,119775,119859,119868,119891,119912,119958,120008,120067,120211,120223,120254,120348,120379,120533,120551,120757,120887,120946,121034,121068,121083,121273,121279,121294,121402,121445,121519,121550,121628,121656,121662,121683,121768,121808,121889,121936,121987,122064,122121,122122,122316,122395,122410,122420,122547,122548,122569,122619,122631,122694,122762,123138,123187,123201,123225,123311,123330,123523,123587,123672,123775,123807,123878,123917,123947,123973,124073,124078,124167,124178,124265,124302,124304,124371,124403,124446,124568,124587,124682,124750,124802,124917,124930,124931,125063,125073,125120,125346,125398,125423,125589,125601,125625,125705,125716,125775,125890,125918,125927,126166,126189,126239,126324,126340,126643,126665,126667,126677,126733,126767,126848,126958,126985,127066,127085,127120,127163,127213,127253,127283,127351,127396,127405,127563,127618,127692,127747,127819,127892,128024,128081,128118,128123,128139,128361,128610,128657,128664,128762,128831,128832,129065,129066,129104,129112,129227,129261,129272,129304,129547,129578,129679,129772,129830,129889,129896,129949,130014,130040,130124,130440,130464,130508,130517,130541,130554,130571,130619,130692,130695,130754,130775,130918,130964,131006,131030,131222,131321,131579,131592,131753,131806,131830,131866,131942,131948,131971,132143,132315,132348,132373,132447,132469,132521,132582,132658,132682,132709,132763,132764,132929,133153,133161,133260,133308,133342,133364,133425,133473,133556,133725,133741,133802,133867,133951,133998,134067,134074,134142,134177,134222,134353,134382,134385,134587,134632,134637,134642,134773,134800,135078,135121,135129,135199,135207,135228,135261,135308,135371,135442,135510,135532,135564,135600,135708,135734,135780,135783,135793,135823,135928,136003,136034,136035,136084,136177,136276,136281,136337,136360,136373,136378,136386,136499,136575,136578,136616,136617,136623,136701,136906,136918,136949,137024,137139,137329,137334,137430,137439,137476,137557,137620,137621,137658,137796,137837,137866,137903,137956,138045,138081,138096,138113,138142,138172,138231,138270,138278,138432,138457,138504,138535,138540,138586,138695,138862,138934,138945,138946,138961,139064,139181,139200,139234,139334,139345,139352,139356,139365,139416,139487,139600,139923,139966,140031,140135,140152,140198,140225,140252,140330,140367,140368,140374,140408,140472,140513,140624,140792,140807,140825,141027,141075,141134,141362,141427,141488,141544,141558,141669,141734,141747,141754,141967,141968,141995,142043,142081,142202,142240,142358,142512,142537,142700,142775,142790,142801,142807,142960,143014,143036,143061,143113,143213,143313,143360,143369,143417,143473,143924,144107,144390,144409,144476,144499,144508,144550,144637,144648,144731,144828,144847,144856,144909,144910,144971,145058,145077,145282,145707,145807,145890,145919,145928,145976,145983,145996,146017,146025,146037,146102,146214,146259,146330,146475,146568,146590,146725,146751,146902,147069,147102,147150,147165,147241,147282,147341,147363,147445,147493,147546,147592,147646,147662,147836,147915,147992,148011,148131,148166,148241,148293,148334,148413,148414,148441,148517,148634,148764,148816,148825,148914,148915,149041,149052,149297,149314,149416,149464,149487,149527,149607,149619,149676,149745,149805,149826,149829,149910,149970,150039,150142,150166,150214,150222,150381,150442,150467,150481,150494,150573,150692,150709,150743,150750,150832,150840,150957,151005,151107,151164,151243,151299,151375,151403,151482,151582,151594,151661,151755,151823,151850,151901,151907,152040,152051,152068,152075,152081,152381,152408,152418,152419,152472,152698,152825,152826,152877,153016,153103,153231) AND

    event_id NOT IN (153314,153321,153368,153514,153567,153672,153820,153872,153974,154185,154240,154244,154277,154327,154330,154355,154425,154518,154643,154677,155117,155148,155229,155278,155286,155319,155358,155399,155438,155463,155465,155469,155697,155737,155790,155820,155907,155926,155965,156013,156016,156068,156166,156229,156294,156299,156305,156582,156612,156656,156712,156776,156823,156898,156938,156988,157122,157132,157225,157241,157263,157292,157327,157368,157617,157634,157702,157707,157718,157942,158108,158119,158248,158287,158289,158469,158521,158559,158585,158654,158965,158972,159015,159032,159068,159081,159099,159141,159261,159354,159400,159406,159572,159604,159713,159801,159812,159909,160037,160114,160153,160206,160217,160287,160371,160557,160601,160620,160663,160823,160868,160883,160906,160937,160982,161109,161368,161383,161431,161438,161456,161495,161525,161627,161640,161649,161846,161876,161914,161978,161985,162084,162125,162314,162342,162344,162529,162619,162648,162722,162845,162887,162967,163010,163048,163096,163249,163330,163333,163351,163509,163588,163694,163878,163886,163942,163995,164151,164175,164189,164302,164328,164329,164574,164660,164935,165114,165248,165508,165510,165586,165614,165640,165724,165769,165833,165842,165918,166104,166181,166206,166329,166539,166647,166664,166688,166754,166839,166879,166891,166970,167061,167115,167119,167292,167934,167935,168037,168203,168257,168294,168306,168322,168528,168560,168562,168598,168897,168957,168981,168987,169001,169098,169119,169149,169389,169449,169463,169592,169617,169734,169780,169922,169978,169999,170086,170135,170154,170296,170346,170418,170507,170621,170675,170818,170894,170912,170927,170952,170973,171042,171118,171134,171149,171152,171161,171174,171210,171231,171343,171361,171435,171447,171454,171515,171581,171767,171795,171820,171838,171853,172003,172018,172054,172073,172082,172172,172465,172586,172628,172743,172803,172846,172997,173058,173087,173275,173280,173292,173303,173360,173378,173406,173493,173509,173541,173562,173588,173738,173837,173852,173897,173926,173980,174010,174122,174127,174192,174337,174361,174387,174433,174479,174497,174609,174870,174927,174974,175003,175077,175110,175114,175146,175249,175269,175278,175290,175326,175446,175534,175550,175696,175710,175744,175778,175781,175790,176184,176317,176350,176413,176439,176476,176480,176508,176523,176595,176712,176817,176852,176928,177094,177154,177206,177336,177351,177369,177435,177497,177501,177551,177576,177685,177719,177827,177864,177875,178027,178108,178233,178282,178323,178419,178512,178525,178737,178798,178802,178812,178884,178979,179118,179144,179159,179179,179192,179236,179286,179323,179351,179380,179385,179508,179629,179705,179723,179747,179849,179850,179875,179963,180193,180204,180223,180259,180391,180406,180436,180586,180641,180744,180745,180904,180945,181093,181094,181210,181217,181311,181322,181411,181499,181630,181857,181914,181931,182052,182230,182232,182395,182520,182577,182642,182769,182812,182816,182910,182986,183015,183121,183161,183225,183291,183325,183434,183442,183447,183524,183525,183577,183654,183746,183754,183915,183935,184002,184065,184097,184107,184201,184218,184285,184361,184362,184475,184561,184766,184774,184780,184876,184901,185145,185189,185301,185360,185484,185629,185646,185729,185761,185775,185816,185821,185905,186023,186027,186041,186334,186347,186393,186420,186428,186431,186451,186497,186604,186633,186699,186710,186761,186800,186820,186892,186900,187017,187190,187251,187292,187312,187317,187420,187502,187535,187572,187605,187618,187628,187717,187788,187836,188134,188201,188220,188247,188248,188324,188414,188433,188558,188649,188664,188667,188761,188857,188910,188960,188970,189035,189053,189325,189348,189376,189406,189524,189631,189639,189762,190031,190382,190564,190602,190674,190724,190769,190827,190959,191116,191154,191182,191226,191347,191493,191529,191578,191671,191701,191770,191884,191947,191956,191975,191981,192091,192099,192182,192216,192321,192322,192331,192342,192477,192488,192515,192730,192812,192883,192917,192985,193084,193200,193255,193266,193349,193382,193442,193526,193704,193738,193804,193853,193895,194222,194366,194405,194444,194467,194500,194564,194716,194737,194742,195167,195203,195257,195286,195304,195349,195529,195530,195551,195564,195606,195623,195630,195778,195965,196062,196146,196180,196261,196292,196491,196504,196704,196742,196857,196885,196966,196973,197102,197133,197193,197249,197322,197437,197480,197487,197492,197536,197615,197657,197697,197716,197750,197814,197991,198162,198200,198243,198262,198265,198299,198368,198480,198606,198610,198659,198669,198697,198746,198879,198968,198970,199180,199272,199467,199546,199572,199579,199590,199658,199705,199800,199834,199906,200055,200168,200173,200174,200227,200399,200406,200438,200453,200460,200523,200588,200590,200612,200644,200721,200756,200769,200780,200915,200918,200978,201001,201045,201074,201075,201179,201245,201422,201435,201572,201593,201808,201922,201925,201929,201992,202112,202271,202330,202352,202353,202374,202396,202410,202426,202463,202490,202508,202676,202688,202775,202931,202963,202971,203001,203029,203154,203170,203231,203300,203305,203355,203393,203464,203619,203643,203665,203712,203736,203838,203851,203982,204035,204044,204076,204085,204107,204112,204427,204495,204661,204686,204728,204739,204810,204888,205078,205148,205181,205251,205278,205355,205424,205545,205632,205755,205763,205807,205873,205946,205971,205998,206034,206098,206141,206545,206648,206676,206707,206745,206762,206831,206965,206986,207066,207159,207257,207271,207311,207390,207449,207513,207649,207771,207812,207871,207960,207992,207998,208029,208177,208246,208261,208329,208402,208510,208564,208811,208829,208839,208883,209173,209779,209904,209999,210091,210197,210200,210217,210243,210264,210309,210545,210602,210631,210657,210765,210775,210928,211006,211104,211336,211605,211659,211674,211734,211988,212054,212074,212170,212315,212322,212466,212535,212678,212689,212701,212714,212738,212764,212956,213138,213184,213194,213239,213291,213303,213325,213396,213476,213600,213745,213897,213898,213914,213979,214017,214186,214239,214295,214355,214537,214572,214616,214680,214739,214767,214813,214872,214985,214989,215115,215160,215172,215244,215458,215492,215538,215650,215670,215783,215931,216015,216110,216231,216257,216298,216410,216473,216576,216641,216682,216738,216768,216771,216849,217058,217060,217147,217150,217407,217536,217615,217712,217744,217781,217828,217841,217847,217937,217958,218013,218237,218271,218335,218447,218459,218520,218536,218557,218904,218939,219170,219256,219283,219439,219494,219531,219546,219628,219771,219773,219800,219854) AND

    event_id NOT IN (219873,219888,219921,220013,220233,220623,220648,220802,220867,220877,220887,221163,221201,221260,221321,221375,221428,221435,221502,221506,221532,221536,221558,221564,221596,221643,221661,221686,221688,221689,221696,221770,221870,221897,221926,221935,221940,221967,222068,222199,222268,222332,222347,222565,222615,222923,222962,223045,223053,223148,223181,223204,223223,223237,223250,223389,223427,223452,223476,223522,223559,223730,223798,223867,223873,223931,223987,224044,224171,224469,224494,224729,224786,224808,224945,225066,225074,225090,225102,225163,225166,225176,225179,225197,225674,225679,225853,225878,225904,226003,226132,226256,226362,226547,226618,226674,226707,226779,226788,226888,226925,227041,227129,227211,227247,227280,227327,227436,227682,227709,227739,227746,227773,227973,228005,228027,228092,228097,228124,228184,228221,228271,228305,228372,228376,228385,228553,228572,228581,228647,228659,228666,228752,228865,228901,229054,229330,229356,229448,229513,229597,229645,229861,229952,230102,230107,230113,230139,230197,230218,230220,230381,230425,230437,230458,230469,230512,230573,230669,230691,230723,230724,231189,231256,231357,231408,231506,231582,231651,231669,231764,231925,232078,232095,232105,232141,232193,232288,232311,232382,232426,232477,232480,232588,232704,232783,232821,232886,232936,232988,233067,233098,233158,233186,233278,233310,233315,233443,233826,234001,234095,234117,234120,234382,234433,234530,234618,234677,234718,234741,234838,234910,234963,235017,235081,235135,235220,235225,235257,235313,235323,235351,235356,235403,235427,235449,235574,235655,235805,235917,235988,236012,236042,236289,236296,236306,236385,236461,236463,236483,236498,236507,236543,236552,236620,236654,236750,236752,236848,236956,237042,237060,237112,237121,237125,237244,237262,237298,237432,237460,237495,237541,237571,237664,237686,237729,237761,237813,237868,237919,237974,237988,238079,238109,238111,238149,238151,238194,238237,238295,238322,238554,238580,238628,238642,238824,238859,238943,239080,239180,239202,239215,239260,239279,239281,239305,239649,239717,239732,239860,239915,239925,239927,239933,239950,240028,240085,240097,240386,240513,240596,240651,240786,240824,240825,240834,240878,240915,240925,241026,241145,241255,241280,241304,241341,241360,241437,241462,241618,241670,241698,241775,241787,241823,241841,241862,241880,241971,242043,242135,242162,242404,242452,242470,242510,242630,242702,242726,242898,242986,242991,243065,243134,243148,243204,243327,243417,243462,243475,243505,243558,243585,243620,243631,243643,243788,243856,243866,243867,243898,244106,244212,244335,244556,244558,244637,244692,244723,244736,244759,244774,244805,244816,245026,245065,245142,245220,245243,245244,245323,245357,245574,245604,245774,245812,245829,245970,246034,246049,246056,246211,246291,246342,246345,246416,246779,246884,246894,246920,247046,247090,247095,247124,247135,247204,247387,247463,247537,247603,247690,247692,247798,247799,247880,247974,248012,248068,248076,248089,248198,248223,248275,248301,248308,248330,248331,248347,248524,248628,248779,248853,248912,248949,249013,249025,249076,249160,249384,249544,249602,249649,249708,249794,249876,249902,249910,249924,250044,250055,250068,250141,250176,250177,250240,250417,250544,250556,250599,250633,250656,250833,250955,251025,251030,251116,251188,251225,251327,251352,251625,251707,251720,251722,251772,251784,251857,251902,251977,252001,252193,252204,252228,252256,252276,252431,252480,252547,252680,252709,252844,252858,252893,252965,252991,252996,253013,253057,253151,253173,253178,253256,253283,253392,253410,253431,253501,253567,253595,253608,253615,253626,253711,253858,253881,253942,253988,254034,254058,254157,254221,254228,254263,254356,254403,254438,254573,254582,254639,254691,254741,254753,254835,254876,255049,255114,255193,255282,255426,255514,255526,255601,255808,255833,255901,255948,255979,256001,256048,256058,256069,256129,256137,256196,256197,256211,256304,256347,256482,256488,256494,256498,256567,256682,256899,257184,257205,257286,257338,257463,257543,257552,257557,257579,257688,257795,258066,258106,258155,258188,258315,258376,258397,258562,258739,258742,258844,258873,258919,259097,259127,259168,259238,259247,259258,259353,259452,259553,259566,259593,259678,259734,259736,259769,259876,259914,260063,260139,260369,260536,260672,260886,260990,260999,261015,261202,261328,261380,261411,261443,261532,261549,261735,261798,261843,261926,261947,261958,261959,262021,262085,262271,262334,262461,262520,262704,262754,262769,262865,262895,262998,263039,263079,263094,263137,263435,263599,263636,263722,263864,263868,263976,264008,264110,264137,264162,264246,264340,264374,264420,264455,264489,264534,264592,264671,264768,264791,265035,265180,265241,265396,265495,265546,265580,265600,265620,265650,265668,265736,265885,265958,266108,266121,266172,266208,266254,266281,266336,266345,266595,266727,266756,266799,266812,266887,266901,267160,267217,267302,267304,267317,267338,267353,267403,267444,267484,267731,267733,267774,267833,267879,267925,267946,268015,268068,268152,268180,268327,268364,268440,268590,268683,268684,268714,268754,268826,268878,268926,268939,268991,269001,269057,269064,269114,269183,269215,269277,269343,269352,269410,269478,269502,269516,269614,269619,269698,269701,269855,269943,269951,269958,270101,270202,270218,270435,270470,270527,270538,270543,270578,270673,270693,270743,270772,270779,270798,270925,270966,271007,271145,271191,271202,271261,271378,271379,271497,271535,271605,271640,271642,271711,271748,271827,271907,271997,271998,272009,272036,272055,272117,272126,272162,272176,272227,272267,272457,272585,272739,272743,272807,272809,272931,272976,273090,273100,273181,273208,273224,273305,273344,273390,273402,273438,273533,273726,273757,273850,273958,273978,274053,274196,274351,274355,274508,274618,274755,274797,274885,274967,274972,274977,275006,275026,275050,275075,275136,275153,275178,275199,275211,275364,275401,275466,275534,275543,275550,275616,275785,275818,275828,275859,275883,275963,276067,276073,276119,276123,276257,276259,276433,276589,276775,276796,276849,276884,276901,276926,276937,277164,277247,277270,277383,277469,277581,277589,277688,277719,277804,277815,277853,277921,277943,277982,278031,278036,278038,278065,278242,278321,278336,278412,278428,278526,278611,278724,278874,278950,279105,279234,279242,279274,279396,279397,279407,279438,279606,279701,279832,279896,279979,280112,280206,280248,280269,280280,280320,280368,280483,280521,280547,280562,280570,280621,280624,280632,280667,280680,280697,280757,280803,280870,281168,281169,281228,281241,281307,281355,281383,281482,281494,281497) AND

    event_id NOT IN (281584,281604,281684,281882,281989,282120,282372,282389,282454,282466,282480,282492,282662,282736,282758,282845,282919,283016,283051,283129,283149,283159,283175,283261,283370,283426,283770,283872,283895,283986,284033,284060,284185,284192,284250,284281,284487,284509,284530,284688,284692,284733,284800,284804,284806,284835,284925,284942,284949,284961,285104,285185,285237,285336,285373,285394,285458,285472,285481,285494,285505,285637,285692,285784,285956,285995,286084,286112,286134,286199,286360,286435,286465,286481,286528,286544,286568,286990,287010,287074,287150,287272,287298,287366,287382,287405,287525,287640,287697,287885,287898,287999,288109,288184,288289,288318,288333,288363,288375,288562,288639,288678,288684,288741,288844,288848,288888,288905,289002,289003,289047,289056,289152,289427,289506,289574,289631,289666,289734,289755,289892,289996,290039,290054,290120,290192,290307,290411,290418,290433,290540,290578,290666,290757,290786,290972,291007,291041,291243,291393,291550,291771,291775,291834,291877,291959,292113,292180,292215,292244,292299,292548,292563,292581,292648,292695,292707,292709,292773,292814,292870,292905,292923,292971,292985,293021,293029,293032,293138,293201,293256,293266,293277,293298,293349,293352,293381,293519,293632,293728,293746,293769,293787,293817,294008,294020,294029,294066,294296,294311,294428,294455,294456,294521,294563,294625,294696,294727,294735,294899,295004,295258,295291,295374,295404,295568,295809,295914,296017,296087,296109,296166,296247,296312,296331,296433,296439,296492,296520,296551,296582,296669,296670,296761,296772,296801,296821,296866,296881,296957,296994,297029,297113,297138,297270,297307,297318,297389,297421,297498,297529,297542,297604,297637,297709,297741,297807,297833,297853,297889,297996,298075,298186,298290,298340,298344,298369,298392,298479,298535,298537,298586,298600,298604,298622,298704,298724,298878,298911,298916,298964,299027,299062,299177,299290,299348,299406,299488,299495,299526,299624,299707,299764,299817,299932,300084,300116,300152,300191,300294,300335,300473,300516,300630,300703,300759,300862,300886,300995,300996,301005,301012,301034,301040,301272,301301,301340,301483,301590,301600,301852,301913,301962,301977,302016,302087,302124,302147,302158,302381,302480,302589,302625,302647,302666,302714,302724,302744,302813,302890,302939,303054,303060,303150,303256,303314,303328,303484,303557,303680,303847,303848,303917,304025,304065,304075,304082,304135,304184,304257,304574,304622,304861,304952,304993,304998,305002,305112,305168,305377,305386,305509,305521,305562,305592,305741,305766,305898,305900,305952,305955,306110,306139,306188,306383,306399,306452,306506,306544,306682,306745,306752,306758,306913,306927,307000,307072,307125,307419,307530,307604,307677,307823,308004,308070,308083,308099,308135,308150,308161,308308,308479,308548,308636,308659,308724,308730,308805,308821,308824,308837,309061,309173,309246,309258,309291,309412,309510,309566,309632,309710,309786,309802,309826,309966,310048,310278,310283,310309,310387,310502,310531,310544,310586,310671,310676,310706,310763,310783,310811,310824,310944,310977,310978,311168,311276,311284,311354,311393,311592,311676,311711,311777,311780,311812,311815,311877,311922,312221,312309,312344,312378,312498,312582,312594,312625,312642,312884,312886,312933,312970,312975,313041,313268,313342,313516,313666,313785,313841,313853,313933,314082,314270,314291,314365,314382,314438,314456,314492,314673,314697,314754,314759,314859,314901,315323,315337,315565,315638,315705,315791,315827,315852,315868,315896,315959,316040,316232,316254,316292,316303,316318,316342,316376,316401,316465,316472,316501,316649,316675,316685,316763,316769,316803,316848,316884,316986,317004,317049,317138,317216,317300,317311,317324,317336,317424,317655,317778,317799,317804,317866,317954,317997,318037,318070,318221,318229,318292,318299,318304,318309,318428,318485,318614,318731,318907,318941,318948,318999,319074,319111,319208,319330,319335,319658,319704,319711,319724,319853,320031,320085,320106,320168,320250,320329,320371,320460,320490,320500,320520,320556,320594,320664,320724,320742,320810,320832,321118,321153,321190,321237,321484,321521,321540,321576,321593,321623,321646,321664,321745,321752,321758,321803,321816,321892,321917,321946,321961,322213,322217,322223,322232,322270,322313,322360,322371,322374,322386,322464,322470,322506,322699,322720,322721,322808,322819,322820,322881,322894,322902,322922,322955,323069,323095,323146,323157,323217,323228,323294,323328,323355,323381,323583,323587,323641,323735,323783,323845,323940,323942,324236,324253,324300,324327,324352,324419,324448,324533,324561,324583,324640,324724,324785,324844,324924,324955,324990,325074,325144,325294,325386,325415,325433,325444,325445,325491,325515,325598,325610,325643,325787,325869,325879,325939,325947,325978,326087,326184,326249,326308,326513,326527,326559,326564,326582,326764,326783,326810,326818,326827,326983,327161,327190,327217,327254,327265,327406,327407,327409,327450,327463,327493,327509,327641,327842,327879,327913,327952,327976,328012,328023,328118,328171,328215,328220,328293,328361,328459,328528,328659,328863,328891,329007,329155,329207,329331,329426,329469,329479,329587,329613,329628,329635,329663,329681,329751,329753,329763,329783,329804,329990,330074,330091,330201,330294,330313,330405,330496,330687,330701,330758,330761,330772,330829,330862,330894,331277,331296,331312,331328,331338,331448,331605,331641,331741,331812,331833,331847,331849,332184,332225,332269,332317,332393,332447,332451,332556,332570,332607,332644,332656,332677,332682,332686,332768,332852,332915,332942,332964,333167,333242,333330,333344,333481,333495,333549,333568,333609,333617,333620,333672,333795,334141,334159,334171,334213,334282,334331,334358,334359,334427,334523,334763,334795,334888,335158,335266,335304,335430,335437,335551,335608,335700,335902,335907,335944,336051,336091,336136,336258,336263,336307,336361,336381,336399,336406,336481,336571,336750,336780,336904,337115,337373,337502,337532,337546,337563,337658,337695,337740,337863,337875,337910,337970,338060,338153,338172,338338,338379,338464,338467,338555,338969,339097,339134,339166,339182,339191,339227,339237,339276,339323,339525,339546,339560,339575,339662,339708,339844,339922,339927,340061,340114,340152,340260,340294,340295,340396,340483,340541,340590,340691,340811,340828,340845,340999,341100,341111,341136,341150,341157,341226,341282,341330,341334,341348,341350,341373,341417,341503,341511,341541,341550,341607,341700,341740,341815,341909,341937,341978,342241,342312,342336,342396,342430,342465,342468,342469,342496,342633,342719,342873,342894,342902,342955,342980,342988,343023,343129,343161) AND

    event_id NOT IN (343199,343240,343252,343349,343436,343467,343554,343639,343659,343871,343872,343983,344193,344260,344300,344316,344428,344628,344788,344803,344833,344928,345125,345146,345205,345256,345355,345418,345457,345499,345608,345618,345677,345741,345744,345785,345814,345818,345843,345865,345949,345966,345999,346008,346103,346290,346293,346316,346336,346431,346459,346468,346492,346531,346652,346694,346696,346722,346846,346895,346912,346953,346982,347063,347214,347299,347469,347819,347840,347901,347911,347922,347948,347988,348028,348048,348119,348171,348189,348221,348240,348329,348355,348424,348522,348575,348590,348612,348630,348760,348776,348832,348894,348979,349039,349056,349086,349111,349227,349253,349267,349311,349314,349356,349499,349511,349563,349603,349610,349619,349889,349901,349916,349993,350067,350183,350200,350342,350608,350770,350812,350876,350892,350940,350993,351022,351065,351073,351233,351254,351324,351331,351364,351379,351500,351587,351619,351986,352018,352036,352103,352110,352423,352470,352485,352616,352649,352684,352697,352785,352968,352983,352989,353123,353137,353141,353272,353444,353488,353578,353783,353822,353830,353900,353910,353927,353977,354037,354114,354126,354180,354218,354319,354328,354333,354383,354417,354430,354452,354465,354479,354505,354564,354576,354600,354615,354640,354670,354737,354841,354924,354963,355090,355135,355167,355205,355300,355331,355342,355446,355483,355582,355639,355754,355839,355986,356067,356176,356195,356232,356277,356332,356374,356495,356496,356581,356640,356931,356968,357263,357423,357445,357541,357589,357724,357764,357785,357812,357875,357961,357989,358005,358015,358101,358157,358318,358381,358485,358602,358738,358925,358982,359168,359169,359364,359411,359463,359520,359609,359944,359950,359987,359997,360038,360183,360190,360325,360339,360450,360474,360754,360767,360802,360953,360976,361042,361065,361070,361086,361097,361223,361270,361291,361465,361546,361558,361612,361642,361655,361703,361739,361745,361791,361883,361951,361965,361990,362074,362077,362082,362294,362384,362408,362415,362489,362716,362925,363024,363048,363077,363085,363126,363132,363255,363281,363353,363417,363425,363541,363655,363697,364014,364064,364272,364306,364430,364456,364463,364558,364953,365014,365040,365094,365173,365270,365302,365315,365508,365532,365568,365662,365783,365946,365951,365979,366002,366037,366098,366179,366198,366382,366439,366664,366762,366918,366939,367141,367208,367230,367269,367668,367686,367818,367888,368079,368298,368323,368326,368402,368469,368494,368509,368513,368527,368659,368667,368668,368710,369241,369269,369390,369395,369424,369455,369468,369558,369559,369572,369639,369690,369703,369777,369799,369887,369892,369895,369907,369932,369937,370065,370395,370488,370574,370601,370745,370758,370861,370901,370917,370988,371134,371232,371243,371360,371445,371497,371587,371676,371752,371817,371884,371892,371917,372179,372201,372554,372693,372765,372823,372876,372983,373061,373137,373140,373305,373464,373529,373575,373623,373631,373687,373696,373713,373855,373931,373934,373996,374105,374170,374255,374256,374378,374381,374422,374568,374723,374751,374765,374869,374910,375006,375153,375299,375315,375599,375673,375679,375745,375850,375912,375925,375937,376163,376210,376245,376410,376583,376634,376758,376845,376880,376934,376955,377024,377090,377093,377110,377417,377420,377481,377494,377545,377551,377568,377577,377741,377746,377892,377909,377920,378121,378154,378167,378206,378252,378272,378275,378297,378379,378382,378487,378508,378526,378569,378605,378612,378661,378743,378836,378942,379040,379060,379128,379143,379288,379403,379554,379561,379628,379880,379989,380085,380195,380219,380297,380322,380544,380557,380638,380828,380840,380850,380859,380864,381001,381019,381104,381122,381173,381182,381271,381336,381524,381532,381634,381907,381936,382069,382301,382457,382762,382783,382799,382846,382890,382918,382924,382990,383041,383060,383105,383124,383254,383457,383480,383626,383635,383764,384126,384268,384324,384339,384387,384575,384726,384737,384746,384903,384911,384997,385166,385300,385375,385388,385462,385529,385588,385676,385716,385837,385908,386075,386089,386098,386237,386308,386381,386440,386517,386546,386557,386761,386795,386826,387056,387100,387139,387141,387366,387446,387573,387574,387602,387653,387669,387739,387840,387954,388156,388270,388271,388321,388325,388334,388488,388525,388710,388736,388791,388792,388797,388996,389097,389105,389301,389513,389535,389559,389587,389594,389602,389692,389721,389723,389733,389769,390021,390263,390440,390568,390606,390626,390646,390671,390692,391106,391148,391334,391353,391439,391526,391621,391648,391883,391902,392057,392133,392144,392248,392249,392302,392306,392421,392500,392673,392726,392852,393010,393108,393153,393189,393345,393369,393399,393467,393499,393510,393548,393564,393647,393845,393977,394065,394067,394081,394087,394138,394140,394224,394246,394305,394403,394447,394469,394487,394544,394620,394645,394687,394706,394905,395033,395135,395221,395296,395389,395461,395469,395520,395549,395655,395679,395755,395760,395916,395992,396045,396075,396132,396220,396576,396602,396625,396657,396683,396731,396804,396858,396888,396990,397005,397035,397042,397113,397144,397196,397235,397279,397363,397400,397488,397504,397531,397671,397683,397688,397699,397813,397838,398012,398090,398156,398213,398330,398364,398382,398407,398454,398502,398663,398688,398701,398861,398862,398945,398988,399002,399083,399156,399172,399232,399252,399358,399452,399474,399578,399582,399696,399813,399835,399847,399895,400051,400079,400082,400149,400283,400284,400298,400524,400591,400600,400627,400740,400773,400811,401015,401034,401035,401117,401349,401376,401410,401452,401587,401649,401660,401792,401857,401876,401926,401991,402099,402185,402190,402323,402355,402366,402442,402480,402502,402784,402898,402909,403000,403006,403113,403119,403210,403244,403257,403273,403330,403433,403439,403443,403595,403678,403725,403768,403814,403861,403887,403892,403913,404041,404057,404366,404510,404512,404531,404569,404622,404647,404865,404873,405004,405008,405167,405179,405261,405317,405362,405411,405588,405635,405723,405783,405954,405979,406000,406016,406029,406038,406161,406164,406255,406288,406340,406350,406415,406670,406695,406717,406718,406750,406754,406826,406869,406918,406949,406988,407035,407077,407117,407229,407243,407272,407362,407380,407640,407655,407714,407742,407813,407880,407956,407973,407989,408218,408223,408405,408423,408612,408613,408625,408628,408693,408764,408769,408833,408900,408934,408949,408979,409028,409148,409150,409188,409356,409386,409489,409542,409646,409744,409865,409901,409966,409980,410039) AND

    event_id NOT IN (410092,410435,410504,410510,410567,410606,410681,410718,410763,410766,410948,410953,410958,411065,411168,411237,411262,411356,411437,411502,411531,411632,411655,411709,411969,411985,411987,411992,412000,412227,412275,412305,412437,412458,412465,412467,412492,412565,412786,412863,413074,413177,413260,413297,413322,413392,413561,413648,413663,413708,413818,413862,413988,414124,414229,414252,414299,414483,414578,414681,414705,414733,414785,414803,414909,414962,415091,415122,415162,415190,415193,415252,415261,415366,415376,415377,415393,415443,415500,415509,415556,415561,415653,415745,415854,415903,415916,415956,416053,416196,416202,416233,416458,416459,416675,416755,416897,416904,416939,416950,417011,417085,417086,417129,417188,417211,417271,417328,417445,417504,417518,417659,417806,417890,417948,418001,418071,418180,418207,418248,418333,418635,418661,418666,418683,418695,418737,418768,418844,419022,419046,419066,419098,419294,419382,419398,419412,419422,419554,419607,419726,419833,419879,420095,420162,420243,420272,420293,420332,420339,420430,420512,420541,420585,420630,420749,420811,420893,420940,420984,421040,421093,421166,421194,421349,421378,421387,421563,421737,421748,421828,421983,422006,422041,422076,422118,422148,422252,422296,422415,422465,422560,422582,422662,422781,422860,422956,423008,423042,423062,423119,423159,423183,423262,423338,423390,423392,423433,423454,423505,423521,423571,423641,423809,423816,423852,423877,423904,423932,423969,424040,424054,424084,424264,424287,424309,424317,424424,424430,424586,424710,424740,424844,424866,424881,424955,425003,425087,425132,425133,425208,425209,425217,425284,425317,425323,425432,425451,425457,425479,425515,425792,425821,425848,425907,426035,426100,426160,426230,426311,426316,426428,426545,426558,426587,426591,426705,426784,426877,426889,426956,427052,427062,427115,427674,427743,427822,427841,427874,427988,428022,428158,428220,428221,428310,428393,428482,428568,428585,428697,428707,429073,429122,429191,429228,429407,429440,429452,429602,429620,429675,429785,429807,429871,429975,429982,430024,430025,430185,430261,430278,430325,430390,430395,430493,430497,430522,430539,430576,430664,430697,430723,430810,430870,430888,430959,430998,431110,431135,431137,431272,431357,431557,431621,431637,431658,431710,431784,431916,431968,432239,432368,432590,432620,432631,432709,432741,432772,432867,432926,432943,433233,433278,433348,433503,433554,433634,433639,433648,433687,433724,433772,433774,433868,433872,433882,434105,434115,434118,434140,434149,434161,434192,434265,434311,434331,434401,434454,434507,434678,434808,434857,434864,434964,434976,434987,435170,435228,435285,435291,435363,435418,435584,435884,435885,435987,436122,436214,436227,436261,436290,436398,436405,436437,436471,436483,436493,436609,436695,436742,436764,436809,436880,436988,436995,436998,437237,437247,437250,437643,437673,437678,437797,437802,437853,437909,438081,438102,438108,438133,438138,438212,438216,438237,438372,438412,438545,438556,438582,438615,438687,438694,438799,438886,438995,439069,439119,439255,439270,439328,439423,439461,439502,439507,439560,439836,439862,439879,439894,440046,440104,440161,440233,440237,440268,440288,440487,440515,440642,440705,440935,441001,441019,441034,441062,441194,441347,441370,441450,441464,441481,441549,441572,441656,441777,441815,441852,441853,441873,441972,442084,442185,442212,442294,442301,442320,442332,442351,442393,442415,442487,442747,442770,442822,442937,442938,442940,442975,442987,443003,443112,443336,443338,443400,443401,443491,443534,443573,443718,443830,443836,443906,444008,444028,444054,444061,444079,444102,444134,444249,444380,444421,444444,444482,444488,444525,444764,444999,445006,445048,445098,445099,445220,445231,445267,445271,445301,445378,445545,445727,445775,445792,445836,445918,445963,446028,446063,446077,446122,446208,446280,446319,446414,446486,446499,446570,446584,446624,446646,446651,446795,446836,446902,446928,446993,447021,447155,447181,447198,447248,447428,447441,447609,447646,447695,447732,447789,447855,447857,447860,447932,448020,448072,448105,448122,448214,448262,448276,448299,448377,448385,448449,448698,448840,448846,448905,448950,449082,449153,449185,449259,449318,449379,449403,449593,449614,449658,449768,449776,449794,449816,450124,450174,450227,450327,450392,450518,450553,450669,450706,450906,450913,451025,451043,451065,451325,451716,451772,451809,451900,451907,452017,452051,452112,452126,452171,452184,452190,452252,452512,452945,452964,452992,453035,453110,453269,453328,453505,453527,453602,453611,453623,453649,453655,453685,453699,453732,453805,454068,454086,454131,454168,454211,454227,454235,454261,454343,454432,454438,454510,454766,454822,454850,454855,454939,454998,455034,455070,455109,455203,455205,455238,455254,455323,455423,455440,455452,455457,455463,455753,455774,455854,455988,455989,456119,456127,456175,456182,456235,456236,456242,456247,456291,456453,456490,456652,456695,456784,456807,456896,456935,456963,456980,456981,456995,457068,457262,457304,457311,457323,457358,457570,457687,457739,457763,457818,457860,458003,458023,458089,458134,458218,458225,458238,458263,458321,458328,458332,458339,458377,458406,458470,458512,458551,458577,458599,458869,458870,458904,458954,458976,459055,459113,459114,459119,459122,459263,459315,459319,459391,459395,459453,459506,459520,459542,459637,459739,459805,460048,460049,460057,460092,460155,460157,460204,460282,460465,460477,460490,460533,460547,460703,460716,460718,460728,460804,460806,460953,461043,461113,461168,461186,461197,461206,461234,461245,461255,461342,461494,461689,461708,461858,461859,462041,462111,462128,462145,462148,462224,462240,462298,462349,462364,462392,462409,462479,462494,462765,462876,463102,463118,463283,463303,463570,463740,463743,463844,463858,464027,464042,464343,464368,464422,464485,464564,464666,465110,465114,465200,465384,465541,465864,465935,466040,466046,466123,466162,466305,466326,466345,466370,466394,466491,466523,466535,466541,466593,466667,466807,466838,466971,467061,467066,467094,467134,467157,467196,467235,467251,467279,467282,467308,467360,467434,467451,467636,467665,467678,467724,467820,467857,467874,467878,467922,467979,468073,468125,468293,468390,468415,468473,468493,468571,468608,468658,468727,468729,468891,468959,468975,468987,469004,469189,469218,469241,469317,469339,469388,469576,469771,469796,469851,469915,469971,470044,470056,470248,470376,470403,470439,470453,470457,470487,470519,470575,470647,470799,470954,471038,471061,471107,471191,471235,471405,471443,471862,471865,471894,471929,472120,472123,472173,472189,472283,472535,472662,472716,472771,472831,472890) AND

    event_id NOT IN (472972,473051,473080,473196,473255,473269,473272,473326,473443,473492,473500,473680,473705,473744,473747,473832,473925,473939,473986,474154,474225,474229,474237,474331,474369,474393,474493,474499,474592,474633,474707,474715,474729,474833,474974,475049,475086,475115,475136,475160,475230,475245,475349,475385,475427,475430,475530,475545,475594,475740,475814,475902,476004,476056,476135,476172,476183,476194,476209,476240,476339,476382,476453,476463,476486,476528,476570,476638,476643,476749,476862,476879,476910,476972,476980,477023,477185,477374,477397,477407,477479,477493,477498,477675,477717,477778,477873,477923,477992,478013,478167,478195,478240,478309,478337,478522,478555,478585,478595,478883,478892,478900,478926,478947,479345,479370,479381,479420,479503,479581,479629,479686,479698,479873,479958,480066,480216,480446,480471,480533,480534,480539,480720,480819,481111,481115,481155,481384,481386,481431,481479,481693,481706,481761,481817,481972,481983,482041,482126,482161,482176,482247,482310,482345,482383,482398,482463,482544,482550,482619,482639,482687,482804,482908,482974,482996,483013,483014,483090,483152,483307,483572,483588,483712,483769,483773,484034,484054,484249,484409,484461,484542,484574,484593,484765,484794,484822,484840,485065,485161,485192,485264,485289,485369,485451,485607,485623,485662,485739,485740,485754,485812,485822,485930,486144,486160,486289,486309,486446,486496,486501,486507,486691,486741,486823,486824,486825,486865,486983,487308,487509,487676,487766,487794,487835,487845,487868,487896,488126,488142,488158,488200,488232,488268,488317,488348,488427,488474,488654,488753,488930,489066,489117,489182,489206,489285,489290,489309,489343,489361,489364,489410,489450,489518,489607,489801,489816,489827,489922,489936,490055,490106,490202,490386,490537,490544,490562,490602,490642,490667,490676,490725,490796,490829,490894,490912,490917,491010,491041,491208,491219,491287,491387,491415,491424,491453,491570,491691,491785,491816,491967,491992,492040,492095,492219,492240,492298,492406,492635,492729,492737,492813,493004,493043,493045,493111,493213,493246,493254,493263,493580,493636,493676,493708,493822,493844,493888,493895,493949,493954,494062,494140,494298,494339,494341,494348,494390,494484,494629,494658,494821,494882,494890,494937,494966,494982,495022,495415,495463,495487,495510,495604,495686,495781,495804,495810,495827,495920,495924,495925,495941,495962,495963,495992,496003,496005,496031,496093,496105,496354,496407,496434,496474,496507,496588,496639,496653,496765,496775,496801,496888,496953,497065,497067,497086,497217,497305,497393,497413,497702,497709,497731,497755,497789,497803,497879,497893,498025,498074,498208,498365,498382,498519,498577,498592,498645,498745,498780,498793,498807,498906,498936,498969,499100,499107,499315,499394,499404,499420,499582,499645,499663,499679,499715,499720,499733,499846,500031,500103,500157,500161,500280,500309,500399,500469,500485,500564,500571,500630,500633,500649,500684,500864,500891,500931,500933,501015,501019,501025,501052,501088,501191,501458,501475,501505,501544,501607,501612,501700,501734,501821,502014,502077,502171,502175,502267,502285,502324,502325,502343,502421,502494,502497,502640,502749,502852,502947,502950,503012,503121,503136,503237,503258,503469,503691,503772,503804,503825,503898,503982,504048,504108,504128,504129,504329,504443,504489,504564,504642,504645,504656,504689,504764,504874,504876,504905,504911,504934,504938,505060,505133,505151,505157,505221,505308,505335,505360,505459,505514,505538,505588,505651,505765,505793,505855,505935,505973,506051,506095,506110,506164,506183,506194,506437,506557,506698,506715,506747,506771,506963,507024,507066,507183,507248,507301,507442,507446,507491,507564,507568,507663,507677,507791,507917,507954,508005,508064,508070,508190,508296,508395,508403,508415,508422,508508,508520,508577,508586,508612,508686,508725,508819,508908,508919,509118,509245,509246,509261,509332,509383,509416,509457,509461,509586,509615,509618,509714,509759,509840,509848,510207,510211,510214,510248,510266,510314,510331,510380,510429,510457,510517,510848,510876,510887,510943,510959,510988,510997,511054,511100,511107,511197,511591,511646,511744,511769,511845,511888,511986,512055,512103,512115,512161,512246,512270,512411,512573,512811,512851,512870,512913,512962,513060,513148,513247,513253,513303,513387,513410,513416,513536,513620,513621,513691,513837,513854,513983,513987,514035,514077,514102,514208,514349,514477,514500,514513,514532,514572,514588,514621,514650,514680,514688,514708,514747,514750,515018,515023,515041,515117,515147,515375,515433,515466,515511,515565,515570,515745,515829,515850,515952,515983,516017,516042,516045,516193,516209,516232,516311,516344,516389,516425,516492,516503,516505,516559,516570,516617,516641,516736,516773,516839,516843,516846,516879,516938,517013,517060,517092,517220,517345,517393,517410,517459,517497,517688,517880,517955,518012,518034,518048,518061,518083,518241,518301,518363,518519,518683,518693,518945,519035,519072,519145,519171,519295,519521,519537,519614,519643,519689,519698,519984,520019,520157,520248,520291,520408,520431,520459,520474,520478,520494,520500,520510,520540,520599,520606,520775,520844,520845,520874,520875,520956,521001,521018,521165,521241,521273,521303,521365,521397,521404,521427,521430,521437,521469,521558,521630,521640,521659,521666,521856,521892,521983,522136,522162,522246,522284,522298,522366,522369,522553,522614,522634,522653,523114,523183,523507,523516,523599,523604,523616,523666,523674,523728,523808,523864,523870,523981,523993,524052,524096,524122,524148,524247,524317,524413,524416,524425,524471,524505,524616,524669,524692,524807,524825,524836,524884,524978,524984,524991,525073,525196,525221,525254,525262,525272,525389,525560,525636,525707,525710,525786,525791,525863,525895,525924,525928,526003,526063,526079,526085,526311,526335,526360,526368,526371,526514,526553,526739,526750,526857,526975,526984,527051,527124,527197,527256,527257,527317,527318,527359,527398,527414,527434,527527,527610,527740,527747,527785,527791,527794,527803,527804,527867,527876,527970,528041,528267,528289,528331,528527,528569,528618,528686,528700,528804,528869,528938,528973,529124,529446,529563,529568,529808,529897,529959,530010,530026,530065,530202,530228,530331,530390,530461,530496,530647,530682,530883,530906,531087,531143,531378,531519,531605,531732,531763,531766,531814,531828,531884,531925,532089,532215,532488,532503,532525,532625,532728,532746,532817,532833,532867,532955,532973,532990,533005,533154,533163,533187,533207,533304,533334,533346,533389,533396,533424,533460,533810,533827,533853,533859,534044,534315,534354,534397,534423,534427,534605,534614) AND

    event_id NOT IN (534882,534919,534968,535069,535175,535296,535496,535559,535625,535690,535691,535718,535919,535968,536005,536050,536079,536098,536155,536172,536236,536281,536284,536366,536398,536408,536456,536495,536640,536990,537180,537468,537477,537520,537792,537946,537967,538037,538086,538126,538253,538470,538479,538534,538550,538555,538801,538905,538957,539004,539135,539297,539414,539458,539554,539599,539635,539660,539676,539718,539724,539767,539793,539815,539836,540018,540041,540114,540554,540584,540591,540610,540685,540861,540869,540908,540921,541061,541189,541265,541275,541869,541966,542019,542034,542069,542109,542118,542163,542212,542226,542240,542279,542424,542463,542607,542608,542623,542664,542778,542891,543047,543231,543305,543355,543400,543429,543465,543489,543545,543647,543676,543694,543729,543750,543790,543973,544033,544063,544077,544115,544128,544383,544421,544439,544496,544498,544625,544698,544833,544878,544913,545049,545231,545237,545279,545381,545505,545507,545510,545588,545599,545687,545722,545807,545812,545895,545905,545919,545987,546052,546176,546639,546759,546807,546820,546825,546831,547018,547038,547061,547131,547247,547275,547370,547412,547472,547488,547571,547677,547806,547857,547862,547873,547904,548011,548037,548101,548201,548405,548484,548559,548581,548647,548654,548701,548761,548780,548844,548854,548962,549020,549118,549123,549151,549196,549232,549314,549398,549567,549577,549638,549745,549764,549824,550098,550135,550140,550189,550192,550319,550327,550339,550350,550368,550398,550605,550650,550716,550753,550761,550866,550876,550961,550993,551044,551054,551131,551204,551231,551250,551353,551520,551630,551718,551805,551810,551892,551899,551940,551989,552015,552060,552068,552153,552243,552339,552349,552364,552399,552451,552473,552531,552608,552638,552674,552709,552787,552809,552969,553088,553139,553151,553236,553246,553261,553266,553286,553294,553334,553432,553499,553559,553576,553750,553881,553899,553917,554108,554237,554436,554473,554488,554533,554549,554558,554579,554633,554695,554858,554884,554991,555056,555111,555180,555296,555487,555535,555564,555567,555603,555652,555695,555723,555748,555823,555965,555988,556023,556073,556245,556397,556409,556559,556703,556713,556719,556728,556794,556868,556941,557008,557104,557254,557344,557347,557412,557584,557650,557899,557961,558006,558048,558205,558237,558286,558322,558323,558347,558461,558527,558734,559186,559202,559209,559369,559454,559455,559568,559775,559815,559991,560163,560203,560219,560290,560470,560476,560578,560922,561028,561032,561055,561453,561478,561516,561701,561710,561712,561722,561884,562011,562027,562122,562248,562360,562369,562398,562423,562521,562613,562693,562874,563089,563091,563095,563158,563214,563215,563363,563456,563482,563493,563585,563652,563690,563699,563719,563736,563756,563816,563876,563878,563909,563921,563951,564026,564059,564186,564439,564499,564529,564531,564566,564614,564628,564740,564783,564985,565072,565074,565094,565214,565219,565226,565243,565320,565361,565383,565470,565481,565689,565722,566026,566051,566053,566102,566124,566158,566204,566268,566350,566382,566508,566604,566614,566761,566770,566826,566868,566892,566901,567160,567207,567311,567335,567348,567359,567441,567532,567912,567969,568154,568164,568176,568185,568227,568290,568404,568488,568817,568822,568838,568860,568960,569061,569068,569088,569278,569435,569453,569492,569589,569843,569869,569919,569930,570086,570194,570256,570297,570374,570455,570502,570546,570573,570638,570718,570851,570861,570871,570890,570913,570930,571032,571263,571334,571447,571473,571505,571669,571793,571889,572052,572149,572155,572335,572336,572356,572585,572602,572885,572894,572895,572918,572979,573062,573071,573080,573500,573563,573621,573661,573716,573974,573998,574012,574019,574039,574146,574167,574219,574246,574290,574376,574396,574489,574491,574502,574569,574674,574710,574784,574809,574863,574888,574963,575084,575087,575145,575343,575381,575411,575449,575534,575603,575656,575759,575797,575806,575823,575850,575857,575860,575865,575867,575897,575950,576036,576149,576177,576340,576371,576473,576498,576585,576589,576591,576600,576892,576931,577034,577043,577072,577122,577242,577292,577406,577440,577529,577548,577597,577652,577690,577749,577810,577835,577864,577876,577933,578050,578052,578169,578183,578254,578341,578454,578477,578577,578767,578799,578840,578843,578889,578972,579010,579088,579129,579212,579293,579297,579387,579431,579606,579644,579777,579802,579825,579973,580017,580030,580100,580115,580179,580180,580229,580266,580536,580684,580753,580858,580929,580967,580986,581171,581246,581511,581641,581911,581935,582106,582141,582149,582163,582214,582223,582306,582367,582563,582565,582575,582599,582699,582724,582886,583110,583351,583352,583391,583432,583489,583527,583542,583551,583630,583641,583767,583795,583966,584004,584042,584132,584148,584159,584258,584288,584330,584478,584491,584792,584855,584864,584890,584914,584988,585015,585022,585062,585327,585340,585436,585615,585626,585630,585634,585678,585904,586025,586254,586299,586438,586504,586521,586593,586610,586645,586671,586808,586897,586995,587009,587160,587193,587244,587293,587305,587366,587393,587551,587651,587740,587807,587841,587873,587957,587970,588087,588103,588164,588274,588300,588364,588427,588433,588585,588593,588699,588741,588864,589113,589161,589443,589658,589733,589838,589936,589952,589967,590047,590080,590113,590141,590144,590168,590447,590566,590599,590643,590653,590682,590776,590806,590829,590865,590935,591037,591042,591114,591153,591158,591189,591313,591511,591522,591596,591694,591769,591810,591846,591883,591909,591930,592110,592117,592184,592503,592580,592604,592641,592655,592665,592686,592699,592754,593012,593051,593234,593259,593302,593563,593577,593636,593709,593722,593843,594192,594225,594243,594270,594313,594442,594498,594590,594774,595004,595069,595139,595189,595237,595240,595434,595473,595555,595592,595687,595699,595761,595809,595982,596100,596133,596210,596284,596328,596355,596356,596363,596477,596546,596549,596659,596697,596713,596823,596836,596940,597010,597145,597169,597181,597249,597252,597271,597272,597276,597317,597321,597362,597416,597526,597585,597616,597732,597908,597916,598026,598162,598211,598388,598395,598407,598467,598493,598628,598632,598636,598797,599011,599050,599163,599490,599533,599612,599616,599618,599665,599754,599782,599797,599804,599891,600147,600148,600186,600306,600356,600365,600425,600455,600470,600547,600580,600616,600836,600839,600843,600976,600995,601044,601120,601146,601166,601214,601243,601290,601307,601374,601387,601445,601464,601550,601770,601829,601898,602022,602110,602327,602398,602428,602441) AND

    event_id NOT IN (602460,602492,602497,602904,602973,602975,603188,603194,603354,603551,603559,603634,603671,603733,603764,603775,603802,603903,603940,603978,604096,604136,604165,604238,604362,604376,604440,604531,604559,604566,604678,604718,604722,604771,604909,605023,605127,605228,605314,605344,605351,605360,605420,605441,605490,605491,605518,605519,605580,605685,605691,605707,605800,605908,605942,605948,606046,606083,606109,606187,606202,606397,606470,606488,606529,606599,606646,607094,607097,607111,607251,607261,607280,607315,607335,607453,607548,607645,607649,607741,607841,607843,607981,608071,608079,608117,608223,608239,608464,608483,608538,608565,608604,608702,608707,608876,608882,608997,609264,609294,609377,609391,609399,609428,609439,609610,609621,609796,609879,609881,609985,610030,610235,610340,610379,610421,610720,610803,610834,610926,610951,610974,610980,611089,611414,611543,611560,611563,611607,611635,611675,611685,611710,611838,611906,611933,612001,612131,612155,612158,612159,612164,612307,612386,612468,612520,612556,612569,612574,612633,612809,612932,612990,613045,613055,613062,613149,613203,613226,613260,613277,613278,613296,613299,613342,613372,613381,613390,613421,613594,613713,613736,613846,613982,614222,614330,614440,614581,614707,614854,614862,615156,615206,615209,615292,615347,615350,615442,615583,615600,615630,615650,615711,615854,615858,615956,615963,616004,616053,616340,616423,616560,616714,616753,616808,616861,616884,617180,617324,617553,617559,617648,617670,617681,617893,617930,618271,618281,618419,618438,618538,618624,618673,618731,618839,619171,619205,619247,619483,619549,619638,619644,619797,620010,620057,620064,620066,620152,620164,620173,620220,620283,620309,620407,620459,620605,620619,620728,620814,620917,620932,621100,621394,621430,621533,621634,621660,621687,621752,621767,621795,621922,621924,621983,621992,622086,622115,622375,622381,622494,622496,622614,622675,622758,622782,622825,622898,622921,622941,622973,623092,623262,623316,623456,623534,623555,623566,623582,623597,623604,623805,623820,623964,623965,623999,624041,624045,624229,624302,624419,624576,625243,625316,625345,625502,625669,625702,625796,625855,625887,626163,626236,626250,626252,626314,626343,626368,626450,626465,626496,626509,626634,626686,626795,626850,626945,626986,627000,627063,627183,627495,627591,627601,627681,627735,627794,627804,627824,627846,627873,627889,627914,627915,627968,627991,628144,628146,628169,628319,628589,628653,628816,629001,629103,629112,629252,629364,629372,629443,629463,629503,629533,629681,629719,629817,629853,629957,629991,630019,630051,630113,630139,630204,630230,630440,630442,630469,630532,630577,630847,630869,630897,630927,630958,630985,630996,631099,631140,631210,631276,631525,631545,631618,631658,631743,631744,631757,631808,631935,631941,631962,632072,632152,632158,632234,632251,632275,632371,632473,632545,632587,632646,632706,632723,632782,632956,633023,633094,633095,633162,633269,633286,633302,633332,633386,633536,633590,633907,634131,634221,634334,634376,634438,634605,634762,634951,634957,634971,635163,635177,635214,635226,635246,635281,635313,635366,635378,635462,635473,635531,635585,635652,635667,635680,635844,635887,636025,636045,636106,636177,636266,636323,636349,636353,636365,636383,636426,636449,636472,636486,636543,636595,636605,636675,636750,636917,636979,636994,637266,637274,637289,637333,637420,637487,637490,637531,637676,637766,637806,637814,637817,637879,638015,638046,638222,638264,638315,638375,638448,638498,638593,638600,638613,638639,638667,638677,638903,638934,638936,638940,638957,639017,639023,639131,639149,639215,639349,639382,639449,639629,639684,639766,639915,639964,640027,640087,640092,640115,640196,640253,640284,640321,640358,640384,640416,640526,640571,640657,640688,640785,640829,640851,640855,640920,640950,640975,640985,641087,641234,641375,641418,641448,641596,641609,641610,641774,641877,641898,641954,642262,642266,642267,642441,642447,642453,642468,642534,642538,642573,642587,642807,642871,642957,643044,643058,643205,643237,643258,643265,643594,643621,643652,643678,643793,643879,643886,643935,643943,643993,643994,644125,644306,644413,644419,644441,644506,644527,644598,644642,644743,644839,644879,644923,644963,644997,645052,645094,645101,645118,645194,645224,645292,645295,645423,645538,645622,645850,646036,646058,646240,646314,646400,646483,646582,646740,646833,646933,647014,647080,647081,647111,647395,647470,647509,647702,647741,647760,647858,648000,648076,648173,648180,648268,648282,648300,648304,648516,648549,648591,648673,648677,648779,648827,648834,648855,648934,649034,649037,649057,649083,649096,649164,649190,649249,649266,649312,649374,649559,649573,649807,649988,650099,650137,650172,650180,650199,650210,650216,650289,650476,650521,650541,650553,650740,650748,650768,650883,650964,651021,651330,651338,651356,651385,651393,651401,651543,651662,651672,651729,651762,651774,651794,651844,651999,652007,652016,652058,652063,652089,652143,652238,652279,652297,652308,652310,652369,652453,652538,652584,652602,652662,652718,652755,652815,652832,652893,653033,653160,653166,653185,653202,653269,653316,653340,653420,653451,653463,653606,653732,653794,653816,653854,653893,653899,653944,654029,654067,654124,654220,654234,654291,654327,654417,654452,654474,654492,654626,654633,654676,654689,654722,654739,654833,654877,654906,654940,654953,655021,655028,655056,655133,655150,655170,655179,655237,655297,655302,655380,655548,655557,655579,655591,655609,655624,655757,655760,655880,655958,655982,655983,656034,656206,656229,656234,656253,656296,656503,656525,656531,656681,656728,656833,657033,657059,657172,657179,657349,657354,657380,657475,657493,657517,657559,657580,657640,657653,657664,657740,657805,658051,658064,658069,658100,658264,658295,658298,658366,658413,658503,658629,658695,659093,659178,659212,659325,659461,659563,659596,659704,659838,660028,660082,660154,660167,660355,660534,660578,660579,660581,660701,660720,660797,660852,660866,660926,660947,660950,660964,661050,661101,661255,661422,661434,661484,661499,661542,661636,661659,661695,661744,661777,661909,661921,662008,662023,662052,662102,662183,662218,662389,662405,662451,662670,662996,663007,663087,663198,663254,663391,663399,663441,663446,663466,663484,663582,663619,663671,663891,663943,663952,663953,663969,663970,663974,664038,664158,664243,664287,664325,664425,664490,664552,664646,664758,664845,664890,664929,664942,664964,664967,665066,665079,665186,665204,665479,665521,665524,665542,665738,665964,665981,666030,666102,666148,666172,666231,666268,666370,666496,666502,666523,666529,666607,666717,666912,666964,666975,667010,667080,667137) AND

    event_id NOT IN (667169,667306,667438,667658,667809,667979,668012,668014,668048,668133,668200,668211,668289,668358,668443,668618,668737,668797,668897,668917,668930,669011,669041,669082,669107,669329,669355,66946

  • Unknown
    edited May 2017
    event_id NOT IN ( 1,2,3,4,21,22,24,25,26,27,28,31,33,34,35,36,37,38,39,40,41,42,43,44,45,46,55,56,57,58,59,60,62,63,65,66,67,68,69,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,100,101,102,104,105,106,107,108,109,110,111,112,113,115,116,117,118,119,120,126,128,129,130,131,132,133,134,135,137,138,139,140,141,142,143,145,146,147,149,150,151,152,154,162,164,166,167,171,183,185,186,187,188,190,192,193,194,195,196,197,198,199,200,201,202,204,205,206,208,209,210,211,212,213,214,215,216,217,218,219,220,221,222,223,224,225,226,227,228,229,230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,267,268,269,2000,2002,20000,20001,20002,20003,20004,20005,20006,20007,20008,20009,20010,20011,20012,20014,20015,20017,20018,20019,20020,20021,20022,20023,20024,20025,20026,20027,20028,20029,20030,20031,20032,20033,20034,20035,20037,20038,20039,20040,20041,20042,20043,20045,20046,20047,20048,20049,20050,20051,20052,20053,20054,20055,20056,20057,20058,20059,20060,20061,20062,20063,20064,20065,20066,20067,20068,20069,20070,20071,20072,20073,20074,20075,20076,20077,20078,20079,20080,20081,20082,20083,20084,20085,20086,20088,20089,20090,20091,20092,20093,20094,20095,20096,20097,20098,20099,20100,20101,20102,20103,20104,20106,20107,20108,20109,20110,20111,20112,20113,20114,20116,20117,20119,20120,20122,20123,20125,20127,20128,20129,20130,20131,20133,20134,20135,20136,20137,50015,50071,50073,50074,50159,50166,50264,50283,50314,50439,50494,50700,50701,50720,50833,51043,51049,51117,51283,51314,51459,51531,51568,51614,51750,51783,51897,51958,51985,52070,52152,52198,52230,52251,52254,52268,52347,52392,52535,52605,52860,52916,53086,53137,53161,53187,53226,53272,53395,53413,53429,53447,53524,53634,53698,53764,53785,53862,53966,54015,54271,54296,54329,54345,54420,54463,54571,54606,54653,54730,55147,55206,55370,55516,55565,55657,55717,55779,55829,55906,55914,55935,56018,56046,56163,56192,56194,56248,56276,56305,56351,56466,56583,56595,56735,56793,56860,56968,56983,57061,57070,57093,57176,57243,57260,57332,57340,57372,57473,57527,57583,57666,57730,57776,57817,57889,57967,57973,58061,58123,58152,58170,58194,58201,58251,58464,58515,58542,58566,58684,58700,58742,58745,58826,58964,58985,58988,59106,59109,59118,59126,59159,59470,59483,59495,59601,59734,59737,59781,59834,59866,59877,60144,60170,60191,60204,60601,60629,60651,60680,60684,60720,60725,60860,60897,60914,60965,61028,61147,61184,61197,61277,61286,61439,61495,61601,61604,61609,61614,61635,61813,61866,61906,61959,62067,62103,62215,62291,62358,62456,62462,62472,62558,62614,62711,62737,62789,62845,62847,62958,63035,63181,63494,63543,63624,63674,63710,63780,63809,63828,63839,63947,63971,64060,64066,64157,64185,64209,64227,64300,64311,64368,64435,64498,64564,64581,64588,64620,64669,64758,64855,64892,64985,65230,65292,65346,65363,65365,65396,65399,65670,65828,65839,65849,65868,65890,65973,66011,66114,66183,66192,66273,66400,66485,66492,66606,66656,66663,66666,66908,67014,67028,67032,67042,67057,67074,67088,67161,67167,67319,67335,67378,67524,67572,67583,67588,67609,67615,67629,67673,67724,67760,67765,67787,67932,67933,68065,68112,68222,68259,68334,68382,68430,68457,68468,68469,68473,68558,68635,68774,68805,68833,68914,68938,68951,68965,68976,69004,69016,69070,69176,69193,69256,69293,69320,69411,69440,69477,69481,69531,69540,69608,69631,69744,69794,69832,69836,69880,69962,69988,70058,70275,70318,70362,70552,70555,70750,70797,70897,71177,71198,71337,71473,71495,71681,71748,71971,72023,72027,72045,72109,72237,72291,72304,72354,72395,72431,72529,72686,72749,72800,72817,72914,72987,73025,73061,73216,73253,73379,73485,73553,73603,73679,73809,73860,73901,73909,73956,74042,74058,74180,74234,74328,74354,74436,74453,74577,74691,74800,74805,74857,74869,74931,74985,75090,75114,75158,75202,75206,75214,75324,75346,75427,75432,75453,75553,75596,75700,75796,75824,75845,75902,75921,75994,76012,76130,76158,76232,76264,76292,76320,76346,76416,76418,76427,76579,76849,76853,76891,76927,77100,77103,77124,77198,77201,77337,77370,77418,77560,77649,77707,77713,77794,77818,78009,78099,78185,78534,78555,78736,78800,78816,78872,78971,79006,79041,79081,79326,79392,79506,79543,79743,79979,80035,80171,80173,80226,80230,80260,80316,80355,80387,80425,80434,80494,80584,80691,80792,80802,80879,80929,80996,81049,81066,81072,81154,81187,81214,81550,81615,81713,81836,81855,81862,81921,82014,82158,82182,82280,82341,82385,82477,82531,82596,82736,82854,82923,83041,83056,83145,83225,83380,83433,83463,83555,83739,83796,83799,83917,83977,83989,84112,84184,84218,84222,84251,84310,84368,84409,84501,84511,84551,84553,84700,84877,85000,85091,85117,85123,85237,85247,85271,85536,85544,85568,85619,85704,85743,85916,85964,86090,86149,86155,86226,86245,86253,86396,86462,86579,86586,86830,86839,86867,86971,87097,87253,87256,87257,87327,87560,87618,87636,87652,87668,87700,87759,87760,87893,87911,87966,87967,88016,88099,88209,88302,88365,88521,88549,88642,88647,88656,88891,88894,88954,89168,89213,89247,89300,89319,89408,89423,89428,89473,89585,89595,89689,89697,89806,89966,90010,90012,90041,90096,90127,90160,90213,90221,90253,90461,90491,90497,90622,90651,90742,90789,90852,91076) AND event_id NOT IN (91180,91188,91388,91457,91532,91567,91642,91712,91788,91874,91899,91918,91982,91994,92179,92187,92326,92339,92378,92396,92579,92731,92871,92895,92992,93003,93008,93009,93115,93161,93274,93294,93386,93411,93493,93496,93552,93559,93850,93869,93938,94095,94127,94189,94230,94309,94390,94393,94398,94413,94449,94469,94542,94703,94745,94869,94956,95010,95014,95093,95166,95311,95420,95495,95503,95574,95690,95717,95739,96047,96117,96161,96326,96399,96441,96475,96674,96688,96697,96733,96743,96814,96839,97030,97271,97352,97382,97496,97498,97530,97539,97558,97612,97625,97771,97823,97915,98047,98069,98090,98167,98289,98306,98340,98565,98587,98608,98612,98651,98704,98751,98900,98917,98994,99050,99160,99170,99195,99203,99223,99235,99243,99244,99333,99495,99504,99640,99831,99915,100099,100107,100212,100330,100417,100540,100567,100718,100964,101075,101170,101189,101190,101396,101638,101659,101706,101787,101924,101948,102137,102343,102545,102614,102811,102861,102888,102899,102948,103049,103095,103114,103177,103339,103346,103401,103454,103456,103760,103808,103823,103832,103905,103971,103996,104008,104061,104100,104289,104393,104429,104523,104663,104679,104801,104881,104948,104950,105080,105232,105288,105362,105373,105589,105597,105638,105656,105663,105897,105917,105946,106073,106080,106092,106122,106153,106188,106253,106257,106313,106314,106375,106387,106400,106405,106419,106695,106752,106783,106794,106928,106929,107042,107061,107063,107236,107319,107374,107498,107597,107691,107846,107869,107991,107994,108055,108130,108216,108220,108358,108511,108529,108543,108586,108658,108894,108990,109037,109059,109126,109154,109253,109265,109286,109384,109397,109549,109560,109565,109621,109630,109778,109780,109828,109875,109933,109954,109964,109966,110005,110099,110133,110220,110239,110271,110276,110278,110287,110289,110293,110295,110334,110407,110415,110470,110512,110654,110674,110778,110856,110933,110937,110955,111016,111080,111115,111117,111222,111255,111267,111280,111320,111388,111476,111530,111558,111602,111741,111773,111786,111807,111911,111935,111955,111964,112043,112226,112239,112253,112427,112465,112591,112660,112675,112714,112760,112771,112863,113122,113184,113212,113319,113337,113452,113478,113505,113581,113658,113772,113890,113951,114032,114132,114190,114208,114241,114262,114371,114435,114562,114569,114592,114619,114633,114674,114690,114697,114778,114814,114838,114883,115062,115073,115078,115089,115196,115198,115271,115277,115298,115330,115421,115452,115482,115509,115724,115787,115796,115956,116088,116096,116194,116383,116436,116628,116665,116676,116688,116773,116794,116840,116883,116933,116953,117056,117163,117280,117294,117354,117392,117497,117569,117601,117638,117770,117796,117802,117958,117970,118032,118101,118222,118285,118358,118421,118437,118550,118602,118719,118750,118756,118777,118864,118870,118905,118966,119058,119263,119520,119606,119775,119859,119868,119891,119912,119958,120008,120067,120211,120223,120254,120348,120379,120533,120551,120757,120887,120946,121034,121068,121083,121273,121279,121294,121402,121445,121519,121550,121628,121656,121662,121683,121768,121808,121889,121936,121987,122064,122121,122122,122316,122395,122410,122420,122547,122548,122569,122619,122631,122694,122762,123138,123187,123201,123225,123311,123330,123523,123587,123672,123775,123807,123878,123917,123947,123973,124073,124078,124167,124178,124265,124302,124304,124371,124403,124446,124568,124587,124682,124750,124802,124917,124930,124931,125063,125073,125120,125346,125398,125423,125589,125601,125625,125705,125716,125775,125890,125918,125927,126166,126189,126239,126324,126340,126643,126665,126667,126677,126733,126767,126848,126958,126985,127066,127085,127120,127163,127213,127253,127283,127351,127396,127405,127563,127618,127692,127747,127819,127892,128024,128081,128118,128123,128139,128361,128610,128657,128664,128762,128831,128832,129065,129066,129104,129112,129227,129261,129272,129304,129547,129578,129679,129772,129830,129889,129896,129949,130014,130040,130124,130440,130464,130508,130517,130541,130554,130571,130619,130692,130695,130754,130775,130918,130964,131006,131030,131222,131321,131579,131592,131753,131806,131830,131866,131942,131948,131971,132143,132315,132348,132373,132447,132469,132521,132582,132658,132682,132709,132763,132764,132929,133153,133161,133260,133308,133342,133364,133425,133473,133556,133725,133741,133802,133867,133951,133998,134067,134074,134142,134177,134222,134353,134382,134385,134587,134632,134637,134642,134773,134800,135078,135121,135129,135199,135207,135228,135261,135308,135371,135442,135510,135532,135564,135600,135708,135734,135780,135783,135793,135823,135928,136003,136034,136035,136084,136177,136276,136281,136337,136360,136373,136378,136386,136499,136575,136578,136616,136617,136623,136701,136906,136918,136949,137024,137139,137329,137334,137430,137439,137476,137557,137620,137621,137658,137796,137837,137866,137903,137956,138045,138081,138096,138113,138142,138172,138231,138270,138278,138432,138457,138504,138535,138540,138586,138695,138862,138934,138945,138946,138961,139064,139181,139200,139234,139334,139345,139352,139356,139365,139416,139487,139600,139923,139966,140031,140135,140152,140198,140225,140252,140330,140367,140368,140374,140408,140472,140513,140624,140792,140807,140825,141027,141075,141134,141362,141427,141488,141544,141558,141669,141734,141747,141754,141967,141968,141995,142043,142081,142202,142240,142358,142512,142537,142700,142775,142790,142801,142807,142960,143014,143036,143061,143113,143213,143313,143360,143369,143417,143473,143924,144107,144390,144409,144476,144499,144508,144550,144637,144648,144731,144828,144847,144856,144909,144910,144971,145058,145077,145282,145707,145807,145890,145919,145928,145976,145983,145996,146017,146025,146037,146102,146214,146259,146330,146475,146568,146590,146725,146751,146902,147069,147102,147150,147165,147241,147282,147341,147363,147445,147493,147546,147592,147646,147662,147836,147915,147992,148011,148131,148166,148241,148293,148334,148413,148414,148441,148517,148634,148764,148816,148825,148914,148915,149041,149052,149297,149314,149416,149464,149487,149527,149607,149619,149676,149745,149805,149826,149829,149910,149970,150039,150142,150166,150214,150222,150381,150442,150467,150481,150494,150573,150692,150709,150743,150750,150832,150840,150957,151005,151107,151164,151243,151299,151375,151403,151482,151582,151594,151661,151755,151823,151850,151901,151907,152040,152051,152068,152075,152081,152381,152408,152418,152419,152472,152698,152825,152826,152877,153016,153103,153231) AND 

    Your list contains 75692 values.

    What would you expect the result to be if Oracle rewrites the query to create ONE GIANT LIST OF VALUES?

    Gaz in OzIgoroshka
  • AndrewSayer
    AndrewSayer Member Posts: 12,998 Gold Crown
    edited May 2017

    This is quite frankly one of the ugliest things I've ever seen.

    You say you have no authority to change it, so what do you want to achieve? Oracle is erroring saying you can't do that, so you have to stop doing that...

    What is the goal of this java process?

    Why is it using literals instead of binds? Do you really want a massive sql to be parsed every time it's run?

    Does it even do what's required of it when it doesn't error? Think about how those not in lists would be built up, what happens when another session inserts and commits some rows between the building of that list and the delete statement being run?

    I bet there's a much simpler, safer, faster way to achieve the real business requirement here.

  • John Spencer
    John Spencer Member Posts: 8,567
    edited May 2017

    Are you sure that that is the query that is getting ORA-00913?  Typically the 913 error comes when there is a mismatch between the number of items in one list compared to another like:

    SQL> desc t
    Name                                      Null?    Type
    ----------------------------------------- -------- ----------------------------
    ID                                        NOT NULL NUMBER
    DESCR                                              VARCHAR2(10) SQL> insert into t values (2, 'Two', 42);
    insert into t values (2, 'Two', 42)
                *
    ERROR at line 1:
    ORA-00913: too many values

    If there were more than 1000 items in one of your in-lists, I would expect it to throw:

    ORA-01795: maximum number of expressions in a list is 1000Cause: Number of expressions in the query exceeded than 1000. Note that unused column/expressions are also counted Maximum number of expressions that are allowed are 1000.Action: Reduce the number of expressions in the list and resubmit.

    Combining multiple in-lists as you have done is perfectly valid, and should work unless you blow out the process memory.

    John

    BrunoVromanWilliam Robertsonjaramill
  • vijayrsehgal
    vijayrsehgal Member Posts: 138 Silver Badge
    edited May 2017

    you should not be using the approach in the first place, others have already suggested you on the approach you should be taking. As you have the table and access to database just execute the query and see what error you get.

  • jaramill
    jaramill Member Posts: 4,299 Gold Trophy
    edited May 2017

    Good point John, you're right.  I got caught up with the TOO MANY VALUES like the others.

This discussion has been closed.