Skip to content

Hardcoded replacements

Jump to bottom
Hk-tang edited this page Jan 19, 2021 · 2 revisions

This wiki page provides the replacements for the get_data method of the main.py file, for the 100 ground truth answers, and the 1,910 comment-edit pairs, that were used in the paper. If you want to run the project on specific Stack Overflow answers or comments then you need to do something similar to this, i.e., hardcode the IDs you want to analyze.

  • PostId represents the Answer Ids (it also represents Question Ids, but for the purposes of this project you do not need to select Question Ids)
  • EventId represents the Comment Ids (it also is used for other Ids, such as Edit Ids, but is used here to select a single comment for analysis)

Ground truth replacement (100 answers, 20 each from Java, JavaScript, Python, Php, Android)

def get_data(conn):
    df_answers = pd.read_sql_query(
        "SELECT * FROM EditHistory_Code WHERE Event = 'InitialBody' AND PostId IN (211161,240165,7416218,8949391,10209691,12609830,15182578,16184827,25776305,26147953,28650939,29052353,31170733,40142454,42895780,49516025,50130390,52347606,53559269,53574609,276739,389793,2204253,10276157,10971756,12110466,22459325,28434849,34459380,36957365,39807014,42207218,43163333,43210935,50817638,52609908,53879119,54574479,55781177,55801335,40189,151940,4009133,4233898,9749510,12903280,18289746,24548749,25860071,29380845,31786638,32050571,33110852,37294534,39806193,40029073,43212125,43673662,45294926,46913880,62680,273206,9890599,15593865,24823645,29684940,29998062,30254825,30933006,34767888,36487361,40551277,40891043,44765572,48484562,51211968,52736206,53243923,54301780,54547101,281433,327384,4356295,14854568,17549972,20177965,20865855,21700067,30461539,32772686,32823117,34866541,37760452,45055491,47482066,48703608,49878150,54444184,55026068,55224131);",
        conn, parse_dates={"CreationDate": "%Y-%m-%d %H:%M:%S"})
    df_comments = pd.read_sql_query(
        "SELECT * FROM EditHistory_Code WHERE Event = 'Comment' AND PostId IN (211161,240165,7416218,8949391,10209691,12609830,15182578,16184827,25776305,26147953,28650939,29052353,31170733,40142454,42895780,49516025,50130390,52347606,53559269,53574609,276739,389793,2204253,10276157,10971756,12110466,22459325,28434849,34459380,36957365,39807014,42207218,43163333,43210935,50817638,52609908,53879119,54574479,55781177,55801335,40189,151940,4009133,4233898,9749510,12903280,18289746,24548749,25860071,29380845,31786638,32050571,33110852,37294534,39806193,40029073,43212125,43673662,45294926,46913880,62680,273206,9890599,15593865,24823645,29684940,29998062,30254825,30933006,34767888,36487361,40551277,40891043,44765572,48484562,51211968,52736206,53243923,54301780,54547101,281433,327384,4356295,14854568,17549972,20177965,20865855,21700067,30461539,32772686,32823117,34866541,37760452,45055491,47482066,48703608,49878150,54444184,55026068,55224131);",
        conn, parse_dates={"CreationDate": "%Y-%m-%d %H:%M:%S"})
    df_edits = pd.read_sql_query(
        "SELECT * FROM EditHistory_Code WHERE Event = 'BodyEdit' AND PostId IN (211161,240165,7416218,8949391,10209691,12609830,15182578,16184827,25776305,26147953,28650939,29052353,31170733,40142454,42895780,49516025,50130390,52347606,53559269,53574609,276739,389793,2204253,10276157,10971756,12110466,22459325,28434849,34459380,36957365,39807014,42207218,43163333,43210935,50817638,52609908,53879119,54574479,55781177,55801335,40189,151940,4009133,4233898,9749510,12903280,18289746,24548749,25860071,29380845,31786638,32050571,33110852,37294534,39806193,40029073,43212125,43673662,45294926,46913880,62680,273206,9890599,15593865,24823645,29684940,29998062,30254825,30933006,34767888,36487361,40551277,40891043,44765572,48484562,51211968,52736206,53243923,54301780,54547101,281433,327384,4356295,14854568,17549972,20177965,20865855,21700067,30461539,32772686,32823117,34866541,37760452,45055491,47482066,48703608,49878150,54444184,55026068,55224131);",
        conn, parse_dates={"CreationDate": "%Y-%m-%d %H:%M:%S"})
    df_questions = pd.read_sql_query(
        "SELECT * FROM EditHistory_Code WHERE Event = 'InitialBody' AND PostId IN (SELECT DISTINCT ParentId FROM EditHistory_Code WHERE PostId IN (211161,240165,7416218,8949391,10209691,12609830,15182578,16184827,25776305,26147953,28650939,29052353,31170733,40142454,42895780,49516025,50130390,52347606,53559269,53574609,276739,389793,2204253,10276157,10971756,12110466,22459325,28434849,34459380,36957365,39807014,42207218,43163333,43210935,50817638,52609908,53879119,54574479,55781177,55801335,40189,151940,4009133,4233898,9749510,12903280,18289746,24548749,25860071,29380845,31786638,32050571,33110852,37294534,39806193,40029073,43212125,43673662,45294926,46913880,62680,273206,9890599,15593865,24823645,29684940,29998062,30254825,30933006,34767888,36487361,40551277,40891043,44765572,48484562,51211968,52736206,53243923,54301780,54547101,281433,327384,4356295,14854568,17549972,20177965,20865855,21700067,30461539,32772686,32823117,34866541,37760452,45055491,47482066,48703608,49878150,54444184,55026068,55224131));",
        conn, parse_dates={"CreationDate": "%Y-%m-%d %H:%M:%S"})

    return df_questions, df_answers, df_comments, df_edits

General Precision replacement (the 1,910 comment-edit pairs in the paper)

def get_data(conn):
    df_answers = pd.read_sql_query(
        "SELECT * FROM EditHistory_Code WHERE Event = 'InitialBody' AND PostId IN (7875,361158,514517,560006,818313,939060,1276894,1318955,1417254,1460531,1582903,1606967,1721911,1727150,1757843,1804490,1938319,1947343,2015329,2061144,2116999,2182488,2206432,2256556,2486471,2494473,2543357,2550109,2563426,2604454,2859362,2861345,2901136,2923021,2931250,3086406,3180655,3272126,3275379,3347598,3359695,3360387,3366318,3383237,3439495,3490999,3498816,3517919,3654309,3835837,3941993,3998810,4002998,4040641,4067488,4126533,4132683,4168659,4209637,4217452,4221530,4291761,4315367,4323607,4324452,4325585,4357318,4379154,4430047,4528579,4531464,4556879,4605982,4608989,4645552,4684900,4694816,4769473,4777541,4812456,4903603,4941028,4942094,4988445,5013708,5112457,5115995,5135509,5147430,5169321,5239735,5299411,5326382,5370006,5453261,5518611,5553947,5586896,5616616,5731533,5761842,5763969,5767092,5866205,5889651,6010680,6049311,6148209,6254602,6296603,6330456,6342311,6632209,6667403,6722434,6870575,6872517,6908115,6954573,7008045,7078376,7080110,7126108,7168985,7234654,7235584,7258784,7271326,7460596,7493521,7498411,7499793,7544391,7643008,7891698,7896397,7936715,7947296,7967539,8037122,8037909,8048636,8136851,8142097,8155443,8166211,8197624,8203073,8218524,8253636,8261392,8273826,8279939,8283470,8299499,8329078,8365193,8525234,8537652,8577641,8615751,8620362,8623341,8696030,8717383,8717759,8832616,8946209,8961590,8974368,9043462,9113266,9148954,9196192,9236878,9239808,9247380,9254988,9262981,9267268,9397206,9509032,9556452,9570292,9575427,9584654,9603211,9630432,9660168,9671062,9686046,9733686,9756189,9765719,9798430,9818245,9842690,9920124,9925196,9946432,9967906,10002805,10002834,10055551,10059880,10060390,10087552,10138018,10150458,10158545,10160317,10246492,10261872,10270526,10270684,10273530,10280163,10284119,10341595,10343816,10352231,10374564,10405545,10457243,10474157,10498341,10547344,10575359,10663878,10675391,10844889,10853256,10869600,10879118,10895018,10985461,10986507,10994146,11013401,11020094,11061143,11069963,11100438,11131801,11152781,11158889,11183232,11217492,11261905,11266091,11267066,11310902,11369081,11384073,11402943,11456310,11468529,11523531,11530571,11545703,11617389,11620982,11623633,11649404,11682656,11697562,11709155,11725088,11727032,11732184,11741915,11801725,11814973,11815880,11826470,11830636,11834538,11847167,11884184,11938690,11992159,12002701,12011946,12024009,12065201,12084655,12085902,12113136,12154831,12180861,12219643,12242834,12285644,12330345,12341744,12372494,12376115,12414939,12444134,12452881,12509737,12559448,12575319,12586471,12597907,12612197,12631280,12638451,12656440,12760132,12775631,12836218,12892964,12911772,12926968,12952985,12956052,12960000,12973748,13039557,13050303,13168163,13202590,13310791,13316398,13363666,13386360,13401681,13412270,13479302,13490333,13490879,13510414,13548302,13594807,13607810,13608535,13636838,13646997,13667934,13673381,13673381,13675924,13703279,13744466,13773615,13794975,13797038,13821778,13823883,13899297,13938724,13955260,13988109,13988418,14027481,14062168,14090649,14110654,14146919,14148205,14176330,14183099,14183626,14246712,14274978,14295201,14299498,14319623,14330893,14336386,14358801,14377232,14384225,14385245,14395504,14435255,14499028,14505065,14534000,14540400,14558540,14625227,14656445,14671329,14716556,14778058,14833921,14861957,14902902,14951869,15013259,15030050,15040541,15062297,15127813,15200344,15226559,15244655,15247892,15262932,15275622,15310530,15376996,15498722,15555250,15559352,15563455,15595034,15616641,15617490,15618861,15639564,15640688,15678836,15762726,15795118,15795612,15801490,15831048,15836989,15840470,15849329,15883604,15901591,15913821,15915111,15957975,15976303,15984885,16058967,16063924,16148101,16152352,16184706,16223058,16251905,16273678,16346563,16356199,16384427,16433740,16464249,16523245,16575426,16578216,16587759,16588794,16605563,16621809,16623428,16675998,16696265,16708675,16708712,16726135,16849913,16912368,16939962,16952627,17031532,17057187,17065946,17135768,17191396,17212266,17249470,17253665,17268172,17319638,17374352,17387979,17403187,17422278,17533368,17534943,17544435,17558331,17596672,17599402,17659899,17750618,17761938,17799399,17808106,17823100,17829520,17831915,17861364,17867875,17890507,17892107,17913039,17944769,17955511,17994028,18048949,18054342,18078475,18114286,18140785,18176414,18194951,18243157,18266011,18277576,18344018,18365444,18374687,18382681,18403272,18443074,18443615,18493467,18505187,18518457,18601061,18635859,18653838,18670979,18756993,18787645,18874276,18894906,18931196,19045774,19097179,19098833,19120443,19170570,19175086,19200180,19263216,19269519,19345640,19383046,19443594,19457772,19503164,19533315,19533769,19557345,19558303,19613767,19694159,19700238,19700790,19732758,19760247,19782902,19941171,19947286,20041558,20051167,20067797,20226848,20248588,20281502,20283372,20299372,20355839,20387055,20389922,20398666,20413155,20416228,20424188,20517410,20522648,20542629,20552569,20564980,20578963,20587235,20597704,20617878,20643356,20658703,20662767,20682670,20692655,20815209,20830515,20835681,20841187,20901037,20923857,20934707,20965305,20979166,20982407,21051450,21160142,21162679,21195919,21221088,21232710,21249586,21260669,21281413,21368011,21384042,21396800,21397451,21415825,21435581,21459305,21467987,21496496,21505671,21508484,21546112,21563424,21574754,21616835,21642984,21661883,21663663,21743445,21751376,21756392,21757928,21761849,21810409,21892282,21900743,21928787,21945515,21963319,21963433,21970805,22013847,22030553,22070320,22089094,22119882,22155631,22244318,22268246,22303390,22335133,22392071,22395788,22430939,22443141,22453634,22507973,22519985,22540389,22542942,22547276,22555650,22558242,22584238,22598814,22628009,22632211,22648500,22666420,22682946,22691984,22701950,22719774,22729235,22739509,22755610,22763803,22790433,22801381,22809006,22815825,22840483,22979262,23005376,23047291,23087549,23094548,23125714,23152151,23184349,23221007,23292037,23341180,23397767,23406739,23428647,23429229,23445771,23457635,23462834,23475753,23485518,23520357,23571630,23596935,23607026,23618258,23627409,23660859,23675576,23679600,23746834,23789009,23836513,23845349,23857995,23929136,23930639,23966454,23966579,23986040,24031643,24032220,24053116,24062304,24082528,24097089,24097395,24112752,24136031,24150475,24160444,24164199,24222260,24261239,24261462,24321596,24339850,24354619,24374760,24403148,24445163,24466679,24487545,24527796,24534339,24617748,24703200,24704262,24711801,24714459,24741513,24788996,24861566,24964658,24973371,24994747,25048956,25084373,25115125,25118473,25192607,25210874,25211347,25213188,25265847,25283650,25297013,25346470,25360511,25363478,25371794,25447101,25478667,25517475,25547280,25548715,25566304,25567294,25570082,25618303,25633751,25722877,25941522,25949661,25957993,26037257,26051940,26113084,26128045,26131972,26133705,26166810,26175327,26183490,26227896,26254861,26266467,26275516,26278551,26299482,26304744,26321860,26334185,26341492,26351539,26359016,26374342,26410127,26422593,26464722,26534852,26548074,26575292,26607409,26612264,26651951,26670820,26684874,26703817,26706398,26707401,26742187,26743196,26783818,26797049,26797389,26798022,26807873,26875502,26895625,26908353,26923279,26933338,26954938,26963815,26996935,27048844,27088557,27129527,27141186,27149731,27173320,27173543,27221870,27236117,27240944,27249942,27251625,27297618,27300544,27366112,27396031,27417444,27460666,27467436,27506104,27532110,27536719,27537995,27538754,27553766,27559665,27577280,27595376,27598202,27616741,27620077,27646170,27651724,27667930,27682935,27692016,27729621,27765983,27816725,28002960,28015389,28050921,28072526,28080459,28131480,28161001,28231279,28246170,28250239,28259162,28335740,28347534,28357108,28362194,28372662,28382894,28453744,28456193,28467274,28486803,28543628,28561949,28566489,28567081,28726502,28759071,28786403,28806923,28824504,28895316,28972885,28977351,29019131,29019668,29050054,29059351,29065976,29067911,29139345,29149361,29169171,29175115,29203801,29208158,29214653,29220691,29236493,29308493,29313135,29411594,29497063,29504539,29507856,29534808,29545290,29590346,29597612,29625108,29643329,29668832,29690325,29716191,29720760,29723153,29730724,29749514,29787277,29788591,29790728,29795883,29805223,29805588,29810469,29811000,29818178,29842091,29873578,29893244,29929794,29942398,29990543,30006033,30006383,30007770,30030466,30040186,30045992,30065760,30136118,30199210,30224730,30253998,30279363,30305493,30352849,30416453,30446432,30458638,30465037,30477785,30511497,30551522,30566591,30613660,30649339,30686992,30693676,30832210,30840682,30850186,30866171,30881191,30955983,30960635,30963999,30994088,31011581,31014364,31028728,31104351,31126573,31212242,31240497,31243894,31248225,31251788,31392227,31427338,31449102,31494182,31545286,31570036,31609446,31650184,31653048,31653245,31676282,31708000,31714336,31745480,31745553,31766828,31786814,31799561,31804269,31809481,31826470,31863695,31874400,31962949,31976242,31984465,32080037,32167419,32178820,32204414,32207358,32209194,32236521,32248981,32269519,32275512,32285180,32319331,32324152,32353429,32393698,32427093,32446063,32452510,32502630,32522692,32534927,32541239,32545385,32617585,32642851,32672253,32675997,32710344,32714867,32749983,32754922,32770815,32771266,32805259,32843260,32918963,32935102,32942720,33064890,33072851,33075045,33093774,33098354,33114312,33143268,33148867,33176109,33187247,33191611,33191679,33219006,33256288,33366449,33437366,33444867,33476734,33494987,33506602,33529736,33552216,33586638,33590305,33591961,33602297,33605139,33618191,33627839,33641677,33643311,33657815,33666531,33681376,33721002,33743060,33747984,33770290,33776967,33792425,33832748,33838178,33851640,33919877,33971929,34037428,34060235,34069130,34073927,34112810,34120216,34181379,34195196,34220750,34241421,34249550,34266530,34376447,34408681,34423517,34445236,34455384,34466982,34510608,34557712,34558760,34574477,34575648,34589083,34598078,34621690,34629675,34643059,34648570,34702666,34708387,34759591,34868195,34938619,34966098,35004710,35020809,35138755,35216133,35219474,35249783,35252575,35308527,35332020,35372103,35403389,35497946,35497964,35510889,35549533,35560225,35560590,35590767,35590767,35599495,35612690,35648172,35693264,35693578,35739045,35743682,35746396,35811456,35823736,35842942,35889474,35890604,35914650,35921671,35926129,35932904,35971935,35976603,35995971,36022198,36053385,36073686,36092565,36163352,36171692,36188657,36205392,36264688,36269980,36301610,36320155,36323513,36338432,36373533,36373663,36405138,36432392,36432553,36440703,36486897,36512049,36523132,36564434,36565615,36601166,36608850,36735910,36846085,36868781,36900249,36924731,36956622,37012089,37012846,37015421,37044830,37066827,37086470,37092024,37092427,37118651,37136990,37173859,37187703,37264012,37278168,37285008,37318859,37339594,37368674,37370249,37386443,37453268,37483528,37508304,37540031,37617173,37641990,37666061,37684436,37697179,37702078,37704902,37714318,37727402,37762134,37765135,37769932,37776174,37816976,37901571,37965678,37992391,38024945,38037269,38049902,38063143,38086081,38110852,38236739,38238363,38246557,38251855,38257253,38300115,38313839,38327251,38334528,38334747,38400960,38504255,38518129,38536173,38547346,38587221,38651536,38667012,38671182,38672135,38681418,38699205,38723725,38763036,38783706,38820880,38824811,38843217,38891160,38895360,38904362,38904362,38934148,39026239,39037928,39040543,39075574,39120587,39139491,39151637,39167699,39183501,39208329,39220959,39233138,39237587,39249372,39268432,39281965,39395659,39402720,39427521,39439365,39455641,39462048,39509953,39551445,39562935,39566876,39569666,39599651,39657730,39671852,39697649,39706712,39763827,39766730,39784610,39796059,39813738,39856353,39864295,39910967,39951997,39977973,39997099,40001644,40015644,40024330,40033661,40040701,40050521,40096675,40125057,40132610,40164633,40171820,40201740,40217754,40235863,40235904,40237594,40247568,40267509,40310563,40313481,40335689,40345985,40367309,40372658,40425316,40440530,40454158,40471235,40474532,40519783,40526356,40542626,40605034,40611808,40623299,40704077,40736514,40813524,40825464,40828270,40855794,40883247,40960619,40963516,40977348,41048353,41048965,41063137,41067576,41078076,41083139,41114471,41115444,41271166,41286761,41302883,41313003,41373257,41462630,41481803,41555552,41563895,41563897,41568370,41609515,41629983,41662470,41737893,41761656,41770767,41806935,41809552,41812258,41817966,41821924,41843713,41865284,41916833,42060276,42078133,42136728,42187180,42247551,42250978,42253098,42285669,42301905,42306581,42316411,42374536,42416986,42464221,42464496,42469760,42505230,42525241,42577798,42611016,42650360,42666184,42722091,42745270,42745733,42753376,42754141,42771800,42815555,42822777,42842593,42880771,42957683,42976849,42981575,43017368,43100605,43112609,43123967,43126362,43127565,43136269,43169475,43174426,43190378,43196972,43254482,43258005,43279035,43280212,43301459,43311175,43352765,43359649,43361112,43414677,43416996,43427889,43461724,43511213,43518846,43589836,43628193,43642366,43662415,43724721,43770851,43835126,43866704,43875064,43887920,43964137,44005916,44017971,44037321,44066476,44082117,44118825,44139492,44157398,44216536,44231990,44232400,44245787,44259757,44282517,44328262,44364052,44398934,44405921,44439069,44460065,44470955,44478159,44506576,44573866,44587005,44628721,44629671,44677700,44679028,44699412,44787113,44810010,44811535,44890983,44911113,44915114,44922210,44950878,45007179,45075646,45111288,45118268,45125055,45192155,45195931,45197334,45199500,45240804,45250051,45258819,45337346,45379089,45432641,45473920,45488299,45503027,45538009,45540503,45542574,45545901,45565196,45610309,45667987,45667987,45702529,45720860,45726250,45732890,45736085,45760861,45772224,45781647,45789765,45837544,45857726,45872547,45893780,45907214,45910474,45964421,45972454,46025406,46055324,46094215,46127745,46207138,46215793,46260542,46277144,46300143,46343211,46393474,46428741,46453711,46520070,46531352,46582357,46588323,46594126,46649922,46651492,46671750,46674148,46675245,46680080,46704641,46716815,46770584,46787348,46802702,46870164,46911175,46916086,46987326,47046198,47052559,47091110,47092339,47100316,47104641,47141031,47141669,47146119,47197865,47242304,47242896,47259470,47271897,47307533,47368258,47406508,47415643,47460589,47473010,47478820,47539689,47545712,47550143,47570669,47582363,47657146,47660583,47667333,47732187,47738713,47743840,47771377,47818939,47845637,47869082,47902521,47930656,47955507,47991819,48006836,48019234,48023108,48023926,48050732,48132069,48149583,48161594,48201601,48210898,48253529,48277470,48391112,48417942,48424108,48430421,48445377,48445377,48448588,48488955,48498763,48530763,48539665,48562953,48568006,48597015,48608229,48784646,48849217,48863574,48899229,48909781,48982124,49001465,49042192,49054649,49060906,49063612,49072401,49137865,49194724,49205358,49222391,49230344,49239091,49324753,49331559,49477991,49488361,49556258,49572152,49587665,49588583,49594320,49605667,49611325,49612466,49624362,49643201,49657185,49712373,49767831,49777371,49801154,49803385,49806413,49807694,49808459,49808855,49829237,49876892,49879709,49994300,50000804,50032469,50037914,50064265,50072344,50079226,50085689,50107889,50153682,50196591,50198000,50252930,50273502,50319225,50328445,50383046,50396724,50401250,50416883,50468424,50508946,50516856,50523918,50543293,50547398,50643390,50665718,50805185,50808175,50823355,50828912,50912438,50923433,50942446,50942905,50959129,50976737,51023803,51045526,51064565,51087761,51092254,51191109,51199783,51217365,51319585,51368086,51406614,51440674,51448369,51514862,51523332,51537352,51645541,51664465,51692602,51750300,51788805,51846665,51851722,51936077,51971005,51980772,52022412,52038658,52095287,52098233,52100343,52127982,52137676,52143991,52153588,52172471,52175721,52241107,52268202,52288027,52306255,52324512,52329084,52333556,52338027,52341611,52385326,52413499,52454084,52464631,52466191,52467937,52517618,52524114,52560553,52607832,52615771,52671874,52751945,52753839,52791021,52809388,52829505,52879125,52900023,52941625,52942822,52962433,52970381,52975797,52980017,52988925,53062115,53142133,53162961,53175054,53216022,53227287,53312361,53354155,53420325,53456077,53474179,53530646,53540698,53568218,53569543,53580299,53587489,53634984,53644456,53692842,53708081,53803910,53806369,53830302,53852343,53927692,53986971,53993132,54033878,54117000,54129165,54178741,54269031,54303414,54323332,54355276,54365760,54384445,54409153,54491356,54615947,54618631,54808259,54886614,54892387,54901809,54918427,54975729,54996120,55005854,55008623,55010830,55053845,55063368,55069962,55110864,55117356,55165291,55327050,55352817,55475988,55528673,55553167,55553620,55601087,55652916,55682960,55688314,55708604,55756492,55788001,55792385,55820395,55843569,55844698,55845564,55855047,55865385,55868868,55879567,55884358,55944669,55957419,55981574,55988793,56169081,56341879,56378053,56403974);",
        conn, parse_dates={"CreationDate": "%Y-%m-%d %H:%M:%S"})
    df_comments = pd.read_sql_query(
        "SELECT * FROM EditHistory_Code WHERE Event = 'Comment' AND PostId IN (7875,361158,514517,560006,818313,939060,1276894,1318955,1417254,1460531,1582903,1606967,1721911,1727150,1757843,1804490,1938319,1947343,2015329,2061144,2116999,2182488,2206432,2256556,2486471,2494473,2543357,2550109,2563426,2604454,2859362,2861345,2901136,2923021,2931250,3086406,3180655,3272126,3275379,3347598,3359695,3360387,3366318,3383237,3439495,3490999,3498816,3517919,3654309,3835837,3941993,3998810,4002998,4040641,4067488,4126533,4132683,4168659,4209637,4217452,4221530,4291761,4315367,4323607,4324452,4325585,4357318,4379154,4430047,4528579,4531464,4556879,4605982,4608989,4645552,4684900,4694816,4769473,4777541,4812456,4903603,4941028,4942094,4988445,5013708,5112457,5115995,5135509,5147430,5169321,5239735,5299411,5326382,5370006,5453261,5518611,5553947,5586896,5616616,5731533,5761842,5763969,5767092,5866205,5889651,6010680,6049311,6148209,6254602,6296603,6330456,6342311,6632209,6667403,6722434,6870575,6872517,6908115,6954573,7008045,7078376,7080110,7126108,7168985,7234654,7235584,7258784,7271326,7460596,7493521,7498411,7499793,7544391,7643008,7891698,7896397,7936715,7947296,7967539,8037122,8037909,8048636,8136851,8142097,8155443,8166211,8197624,8203073,8218524,8253636,8261392,8273826,8279939,8283470,8299499,8329078,8365193,8525234,8537652,8577641,8615751,8620362,8623341,8696030,8717383,8717759,8832616,8946209,8961590,8974368,9043462,9113266,9148954,9196192,9236878,9239808,9247380,9254988,9262981,9267268,9397206,9509032,9556452,9570292,9575427,9584654,9603211,9630432,9660168,9671062,9686046,9733686,9756189,9765719,9798430,9818245,9842690,9920124,9925196,9946432,9967906,10002805,10002834,10055551,10059880,10060390,10087552,10138018,10150458,10158545,10160317,10246492,10261872,10270526,10270684,10273530,10280163,10284119,10341595,10343816,10352231,10374564,10405545,10457243,10474157,10498341,10547344,10575359,10663878,10675391,10844889,10853256,10869600,10879118,10895018,10985461,10986507,10994146,11013401,11020094,11061143,11069963,11100438,11131801,11152781,11158889,11183232,11217492,11261905,11266091,11267066,11310902,11369081,11384073,11402943,11456310,11468529,11523531,11530571,11545703,11617389,11620982,11623633,11649404,11682656,11697562,11709155,11725088,11727032,11732184,11741915,11801725,11814973,11815880,11826470,11830636,11834538,11847167,11884184,11938690,11992159,12002701,12011946,12024009,12065201,12084655,12085902,12113136,12154831,12180861,12219643,12242834,12285644,12330345,12341744,12372494,12376115,12414939,12444134,12452881,12509737,12559448,12575319,12586471,12597907,12612197,12631280,12638451,12656440,12760132,12775631,12836218,12892964,12911772,12926968,12952985,12956052,12960000,12973748,13039557,13050303,13168163,13202590,13310791,13316398,13363666,13386360,13401681,13412270,13479302,13490333,13490879,13510414,13548302,13594807,13607810,13608535,13636838,13646997,13667934,13673381,13673381,13675924,13703279,13744466,13773615,13794975,13797038,13821778,13823883,13899297,13938724,13955260,13988109,13988418,14027481,14062168,14090649,14110654,14146919,14148205,14176330,14183099,14183626,14246712,14274978,14295201,14299498,14319623,14330893,14336386,14358801,14377232,14384225,14385245,14395504,14435255,14499028,14505065,14534000,14540400,14558540,14625227,14656445,14671329,14716556,14778058,14833921,14861957,14902902,14951869,15013259,15030050,15040541,15062297,15127813,15200344,15226559,15244655,15247892,15262932,15275622,15310530,15376996,15498722,15555250,15559352,15563455,15595034,15616641,15617490,15618861,15639564,15640688,15678836,15762726,15795118,15795612,15801490,15831048,15836989,15840470,15849329,15883604,15901591,15913821,15915111,15957975,15976303,15984885,16058967,16063924,16148101,16152352,16184706,16223058,16251905,16273678,16346563,16356199,16384427,16433740,16464249,16523245,16575426,16578216,16587759,16588794,16605563,16621809,16623428,16675998,16696265,16708675,16708712,16726135,16849913,16912368,16939962,16952627,17031532,17057187,17065946,17135768,17191396,17212266,17249470,17253665,17268172,17319638,17374352,17387979,17403187,17422278,17533368,17534943,17544435,17558331,17596672,17599402,17659899,17750618,17761938,17799399,17808106,17823100,17829520,17831915,17861364,17867875,17890507,17892107,17913039,17944769,17955511,17994028,18048949,18054342,18078475,18114286,18140785,18176414,18194951,18243157,18266011,18277576,18344018,18365444,18374687,18382681,18403272,18443074,18443615,18493467,18505187,18518457,18601061,18635859,18653838,18670979,18756993,18787645,18874276,18894906,18931196,19045774,19097179,19098833,19120443,19170570,19175086,19200180,19263216,19269519,19345640,19383046,19443594,19457772,19503164,19533315,19533769,19557345,19558303,19613767,19694159,19700238,19700790,19732758,19760247,19782902,19941171,19947286,20041558,20051167,20067797,20226848,20248588,20281502,20283372,20299372,20355839,20387055,20389922,20398666,20413155,20416228,20424188,20517410,20522648,20542629,20552569,20564980,20578963,20587235,20597704,20617878,20643356,20658703,20662767,20682670,20692655,20815209,20830515,20835681,20841187,20901037,20923857,20934707,20965305,20979166,20982407,21051450,21160142,21162679,21195919,21221088,21232710,21249586,21260669,21281413,21368011,21384042,21396800,21397451,21415825,21435581,21459305,21467987,21496496,21505671,21508484,21546112,21563424,21574754,21616835,21642984,21661883,21663663,21743445,21751376,21756392,21757928,21761849,21810409,21892282,21900743,21928787,21945515,21963319,21963433,21970805,22013847,22030553,22070320,22089094,22119882,22155631,22244318,22268246,22303390,22335133,22392071,22395788,22430939,22443141,22453634,22507973,22519985,22540389,22542942,22547276,22555650,22558242,22584238,22598814,22628009,22632211,22648500,22666420,22682946,22691984,22701950,22719774,22729235,22739509,22755610,22763803,22790433,22801381,22809006,22815825,22840483,22979262,23005376,23047291,23087549,23094548,23125714,23152151,23184349,23221007,23292037,23341180,23397767,23406739,23428647,23429229,23445771,23457635,23462834,23475753,23485518,23520357,23571630,23596935,23607026,23618258,23627409,23660859,23675576,23679600,23746834,23789009,23836513,23845349,23857995,23929136,23930639,23966454,23966579,23986040,24031643,24032220,24053116,24062304,24082528,24097089,24097395,24112752,24136031,24150475,24160444,24164199,24222260,24261239,24261462,24321596,24339850,24354619,24374760,24403148,24445163,24466679,24487545,24527796,24534339,24617748,24703200,24704262,24711801,24714459,24741513,24788996,24861566,24964658,24973371,24994747,25048956,25084373,25115125,25118473,25192607,25210874,25211347,25213188,25265847,25283650,25297013,25346470,25360511,25363478,25371794,25447101,25478667,25517475,25547280,25548715,25566304,25567294,25570082,25618303,25633751,25722877,25941522,25949661,25957993,26037257,26051940,26113084,26128045,26131972,26133705,26166810,26175327,26183490,26227896,26254861,26266467,26275516,26278551,26299482,26304744,26321860,26334185,26341492,26351539,26359016,26374342,26410127,26422593,26464722,26534852,26548074,26575292,26607409,26612264,26651951,26670820,26684874,26703817,26706398,26707401,26742187,26743196,26783818,26797049,26797389,26798022,26807873,26875502,26895625,26908353,26923279,26933338,26954938,26963815,26996935,27048844,27088557,27129527,27141186,27149731,27173320,27173543,27221870,27236117,27240944,27249942,27251625,27297618,27300544,27366112,27396031,27417444,27460666,27467436,27506104,27532110,27536719,27537995,27538754,27553766,27559665,27577280,27595376,27598202,27616741,27620077,27646170,27651724,27667930,27682935,27692016,27729621,27765983,27816725,28002960,28015389,28050921,28072526,28080459,28131480,28161001,28231279,28246170,28250239,28259162,28335740,28347534,28357108,28362194,28372662,28382894,28453744,28456193,28467274,28486803,28543628,28561949,28566489,28567081,28726502,28759071,28786403,28806923,28824504,28895316,28972885,28977351,29019131,29019668,29050054,29059351,29065976,29067911,29139345,29149361,29169171,29175115,29203801,29208158,29214653,29220691,29236493,29308493,29313135,29411594,29497063,29504539,29507856,29534808,29545290,29590346,29597612,29625108,29643329,29668832,29690325,29716191,29720760,29723153,29730724,29749514,29787277,29788591,29790728,29795883,29805223,29805588,29810469,29811000,29818178,29842091,29873578,29893244,29929794,29942398,29990543,30006033,30006383,30007770,30030466,30040186,30045992,30065760,30136118,30199210,30224730,30253998,30279363,30305493,30352849,30416453,30446432,30458638,30465037,30477785,30511497,30551522,30566591,30613660,30649339,30686992,30693676,30832210,30840682,30850186,30866171,30881191,30955983,30960635,30963999,30994088,31011581,31014364,31028728,31104351,31126573,31212242,31240497,31243894,31248225,31251788,31392227,31427338,31449102,31494182,31545286,31570036,31609446,31650184,31653048,31653245,31676282,31708000,31714336,31745480,31745553,31766828,31786814,31799561,31804269,31809481,31826470,31863695,31874400,31962949,31976242,31984465,32080037,32167419,32178820,32204414,32207358,32209194,32236521,32248981,32269519,32275512,32285180,32319331,32324152,32353429,32393698,32427093,32446063,32452510,32502630,32522692,32534927,32541239,32545385,32617585,32642851,32672253,32675997,32710344,32714867,32749983,32754922,32770815,32771266,32805259,32843260,32918963,32935102,32942720,33064890,33072851,33075045,33093774,33098354,33114312,33143268,33148867,33176109,33187247,33191611,33191679,33219006,33256288,33366449,33437366,33444867,33476734,33494987,33506602,33529736,33552216,33586638,33590305,33591961,33602297,33605139,33618191,33627839,33641677,33643311,33657815,33666531,33681376,33721002,33743060,33747984,33770290,33776967,33792425,33832748,33838178,33851640,33919877,33971929,34037428,34060235,34069130,34073927,34112810,34120216,34181379,34195196,34220750,34241421,34249550,34266530,34376447,34408681,34423517,34445236,34455384,34466982,34510608,34557712,34558760,34574477,34575648,34589083,34598078,34621690,34629675,34643059,34648570,34702666,34708387,34759591,34868195,34938619,34966098,35004710,35020809,35138755,35216133,35219474,35249783,35252575,35308527,35332020,35372103,35403389,35497946,35497964,35510889,35549533,35560225,35560590,35590767,35590767,35599495,35612690,35648172,35693264,35693578,35739045,35743682,35746396,35811456,35823736,35842942,35889474,35890604,35914650,35921671,35926129,35932904,35971935,35976603,35995971,36022198,36053385,36073686,36092565,36163352,36171692,36188657,36205392,36264688,36269980,36301610,36320155,36323513,36338432,36373533,36373663,36405138,36432392,36432553,36440703,36486897,36512049,36523132,36564434,36565615,36601166,36608850,36735910,36846085,36868781,36900249,36924731,36956622,37012089,37012846,37015421,37044830,37066827,37086470,37092024,37092427,37118651,37136990,37173859,37187703,37264012,37278168,37285008,37318859,37339594,37368674,37370249,37386443,37453268,37483528,37508304,37540031,37617173,37641990,37666061,37684436,37697179,37702078,37704902,37714318,37727402,37762134,37765135,37769932,37776174,37816976,37901571,37965678,37992391,38024945,38037269,38049902,38063143,38086081,38110852,38236739,38238363,38246557,38251855,38257253,38300115,38313839,38327251,38334528,38334747,38400960,38504255,38518129,38536173,38547346,38587221,38651536,38667012,38671182,38672135,38681418,38699205,38723725,38763036,38783706,38820880,38824811,38843217,38891160,38895360,38904362,38904362,38934148,39026239,39037928,39040543,39075574,39120587,39139491,39151637,39167699,39183501,39208329,39220959,39233138,39237587,39249372,39268432,39281965,39395659,39402720,39427521,39439365,39455641,39462048,39509953,39551445,39562935,39566876,39569666,39599651,39657730,39671852,39697649,39706712,39763827,39766730,39784610,39796059,39813738,39856353,39864295,39910967,39951997,39977973,39997099,40001644,40015644,40024330,40033661,40040701,40050521,40096675,40125057,40132610,40164633,40171820,40201740,40217754,40235863,40235904,40237594,40247568,40267509,40310563,40313481,40335689,40345985,40367309,40372658,40425316,40440530,40454158,40471235,40474532,40519783,40526356,40542626,40605034,40611808,40623299,40704077,40736514,40813524,40825464,40828270,40855794,40883247,40960619,40963516,40977348,41048353,41048965,41063137,41067576,41078076,41083139,41114471,41115444,41271166,41286761,41302883,41313003,41373257,41462630,41481803,41555552,41563895,41563897,41568370,41609515,41629983,41662470,41737893,41761656,41770767,41806935,41809552,41812258,41817966,41821924,41843713,41865284,41916833,42060276,42078133,42136728,42187180,42247551,42250978,42253098,42285669,42301905,42306581,42316411,42374536,42416986,42464221,42464496,42469760,42505230,42525241,42577798,42611016,42650360,42666184,42722091,42745270,42745733,42753376,42754141,42771800,42815555,42822777,42842593,42880771,42957683,42976849,42981575,43017368,43100605,43112609,43123967,43126362,43127565,43136269,43169475,43174426,43190378,43196972,43254482,43258005,43279035,43280212,43301459,43311175,43352765,43359649,43361112,43414677,43416996,43427889,43461724,43511213,43518846,43589836,43628193,43642366,43662415,43724721,43770851,43835126,43866704,43875064,43887920,43964137,44005916,44017971,44037321,44066476,44082117,44118825,44139492,44157398,44216536,44231990,44232400,44245787,44259757,44282517,44328262,44364052,44398934,44405921,44439069,44460065,44470955,44478159,44506576,44573866,44587005,44628721,44629671,44677700,44679028,44699412,44787113,44810010,44811535,44890983,44911113,44915114,44922210,44950878,45007179,45075646,45111288,45118268,45125055,45192155,45195931,45197334,45199500,45240804,45250051,45258819,45337346,45379089,45432641,45473920,45488299,45503027,45538009,45540503,45542574,45545901,45565196,45610309,45667987,45667987,45702529,45720860,45726250,45732890,45736085,45760861,45772224,45781647,45789765,45837544,45857726,45872547,45893780,45907214,45910474,45964421,45972454,46025406,46055324,46094215,46127745,46207138,46215793,46260542,46277144,46300143,46343211,46393474,46428741,46453711,46520070,46531352,46582357,46588323,46594126,46649922,46651492,46671750,46674148,46675245,46680080,46704641,46716815,46770584,46787348,46802702,46870164,46911175,46916086,46987326,47046198,47052559,47091110,47092339,47100316,47104641,47141031,47141669,47146119,47197865,47242304,47242896,47259470,47271897,47307533,47368258,47406508,47415643,47460589,47473010,47478820,47539689,47545712,47550143,47570669,47582363,47657146,47660583,47667333,47732187,47738713,47743840,47771377,47818939,47845637,47869082,47902521,47930656,47955507,47991819,48006836,48019234,48023108,48023926,48050732,48132069,48149583,48161594,48201601,48210898,48253529,48277470,48391112,48417942,48424108,48430421,48445377,48445377,48448588,48488955,48498763,48530763,48539665,48562953,48568006,48597015,48608229,48784646,48849217,48863574,48899229,48909781,48982124,49001465,49042192,49054649,49060906,49063612,49072401,49137865,49194724,49205358,49222391,49230344,49239091,49324753,49331559,49477991,49488361,49556258,49572152,49587665,49588583,49594320,49605667,49611325,49612466,49624362,49643201,49657185,49712373,49767831,49777371,49801154,49803385,49806413,49807694,49808459,49808855,49829237,49876892,49879709,49994300,50000804,50032469,50037914,50064265,50072344,50079226,50085689,50107889,50153682,50196591,50198000,50252930,50273502,50319225,50328445,50383046,50396724,50401250,50416883,50468424,50508946,50516856,50523918,50543293,50547398,50643390,50665718,50805185,50808175,50823355,50828912,50912438,50923433,50942446,50942905,50959129,50976737,51023803,51045526,51064565,51087761,51092254,51191109,51199783,51217365,51319585,51368086,51406614,51440674,51448369,51514862,51523332,51537352,51645541,51664465,51692602,51750300,51788805,51846665,51851722,51936077,51971005,51980772,52022412,52038658,52095287,52098233,52100343,52127982,52137676,52143991,52153588,52172471,52175721,52241107,52268202,52288027,52306255,52324512,52329084,52333556,52338027,52341611,52385326,52413499,52454084,52464631,52466191,52467937,52517618,52524114,52560553,52607832,52615771,52671874,52751945,52753839,52791021,52809388,52829505,52879125,52900023,52941625,52942822,52962433,52970381,52975797,52980017,52988925,53062115,53142133,53162961,53175054,53216022,53227287,53312361,53354155,53420325,53456077,53474179,53530646,53540698,53568218,53569543,53580299,53587489,53634984,53644456,53692842,53708081,53803910,53806369,53830302,53852343,53927692,53986971,53993132,54033878,54117000,54129165,54178741,54269031,54303414,54323332,54355276,54365760,54384445,54409153,54491356,54615947,54618631,54808259,54886614,54892387,54901809,54918427,54975729,54996120,55005854,55008623,55010830,55053845,55063368,55069962,55110864,55117356,55165291,55327050,55352817,55475988,55528673,55553167,55553620,55601087,55652916,55682960,55688314,55708604,55756492,55788001,55792385,55820395,55843569,55844698,55845564,55855047,55865385,55868868,55879567,55884358,55944669,55957419,55981574,55988793,56169081,56341879,56378053,56403974)"
        " AND EventId IN (9548003,192604,328945,376307,629038,747103,1364746,1153485,1260803,1312801,1445150,1472984,1600740,1615890,1645650,1692820,1847981,1858170,1937214,1993421,2053530,2129829,13202829,2216384,2479219,2488339,2545574,2552784,2567213,2614288,2903396,2908551,32914543,2975790,2985133,3163772,3275190,3385187,3389037,3507264,3495277,3490143,3497007,3517579,3584052,3646932,3677400,3678442,35659652,4073862,4208576,4283587,4288191,4337220,19131137,24784617,4455406,4501520,4553253,13754715,4567882,4658532,4687160,4697511,4698830,4699945,4741468,4769784,4836023,4961098,4964693,4997106,5062026,5066277,11600914,5166380,14459276,5283242,5289930,5335620,47064460,5509718,5511031,5573195,13164606,5732506,5736923,5767360,37819402,5807384,5950314,5983425,6011524,6068769,6179249,17931983,6315836,13740923,6399283,6555815,6598366,31947857,6608491,6743771,6775960,6946183,6999720,7140577,7294684,16340219,7405141,7494437,7833445,70220242,7961877,8173818,8176161,9458331,8291241,8367987,8473314,24001101,8540733,8604474,8699798,8701471,25587083,8753363,9025924,9072798,9078717,9080119,9146669,9283815,9645937,9639791,9699683,9715066,9744585,9839930,9841290,9857100,9985043,9992354,10011820,10027520,10074214,10081925,10104930,10156364,10169546,13417467,10195307,12407410,10225403,10267922,10321169,10557256,10575169,10636882,10724031,10705811,10706397,10821027,10851510,10852320,11027815,11199108,11222896,11242234,11345274,11587904,30152969,11594148,11635180,11638775,11655774,11664242,11676720,11684951,11875394,12042603,12132644,12134124,12141392,12154528,12181831,12286322,12270998,12285094,12311835,12386919,12412399,12427095,12477430,12509622,12543562,12685301,12668181,12700315,12733667,12802999,12787357,12867680,12874201,12875510,12918069,34359662,13017469,13041154,49013582,13170435,13194159,13208851,13208338,13213202,13232347,13230558,13320278,13323761,22036392,13372998,13423230,13504419,13532673,13570544,13647993,13692969,13833764,13851611,14123352,14136299,14162422,14177400,48717677,14350271,14351893,51758143,42697950,14405910,14474005,14488414,14664721,14589329,14623735,15347006,14675578,14731417,14804270,68226410,14817430,65016183,14979580,47618904,15035413,15121052,15141249,15230990,15243113,15267872,15382797,29913880,15485316,15434603,15488901,15547987,33594063,15557005,36581595,15569328,15584410,15682056,15704333,15706182,15724177,15730252,15736066,15755362,15814085,15902954,15994943,16009068,16025828,16046242,16114716,16146020,16148291,16193512,16394546,16307036,16526928,16409709,16478733,17511929,16569141,16655450,16626424,16687206,16741019,16746794,16836775,16917591,16943119,16960978,16981436,17003801,17033293,17044353,17074011,17278334,17268132,17366893,17461121,17492376,17517709,17559533,17564254,17570793,17593667,17704259,17721195,17922728,17975384,18154770,18164659,18243843,49887251,18341232,18327648,18441596,18460347,38099067,18492774,18556151,18636342,18658503,18660956,18707009,18724148,18759659,18768476,18768512,18773069,18846721,18886741,18937094,18973832,18977508,19019991,19022976,19152550,19220000,19247887,19304666,19307051,19374843,19436020,19488361,19530114,19597641,19595091,19645215,19657959,27858463,19768888,19818109,20007997,19862479,19897082,19917290,19925892,31306489,19995432,20008007,20009399,20027366,20098277,20207656,20218000,20277989,20283035,20312761,20446063,34744110,20522537,20585931,20689860,20785368,20833388,20903946,20987338,21093056,21126589,21140385,21178552,21292546,21420603,21465169,21532912,21502170,21533957,21550819,21616193,21731811,21944636,22044576,22051353,22058461,22113603,22157741,22151465,22177055,22192863,22192604,22260180,22473369,22459729,22460760,22471115,22522250,22597688,22539428,22554919,22614283,22647608,22666422,22693014,22742623,22773943,22789486,22945172,22926293,23073170,23079579,23137632,23203204,23252950,23289397,23417310,23440479,23482627,23569529,23621254,23725324,23818499,23823278,23839396,23841454,23990696,23902220,23905756,23995878,24030924,24052878,37380598,24084550,24569237,24411876,47771243,24480719,24618786,24663952,24681437,24798860,24899702,24934729,24998888,25005492,25033756,25120882,25219264,25242508,25270955,25303047,48679936,25533939,25517652,25579705,25609198,25616480,25720915,25882175,25902461,27710218,25984749,70931866,26022008,26026353,26077542,26089334,26128112,26131150,26172616,72012017,26242251,26309577,26431661,26416188,48018541,30114741,26568982,26633316,26664140,26749305,26819528,26811169,26928044,26965764,27211890,26995010,27055164,27099462,27182703,27187912,27209610,27299553,27377616,27436848,27468100,27498870,27649198,85429872,27853989,27889858,27954509,28147060,28233890,28236793,28274371,28386877,28368822,28411174,28518461,28528231,28661319,28729273,28831263,28998416,28931326,28981025,28998850,29021455,29023819,29115814,29253118,29263313,29264678,29318301,34006823,29405561,29677679,29687628,29848307,29864266,29892823,30164079,30201205,30257865,30260301,30289000,30386938,30474226,30445906,30462476,30491452,30492063,30513445,30673633,30683052,30717636,30735755,30760714,30802082,30799250,30818904,30856025,30905277,30928303,30936224,30971874,30990874,31213055,31240397,31261720,31259539,31388104,31415850,31437594,31497637,31521035,31526789,31658242,31851319,31856279,31916704,31961738,32014074,32012451,32053143,32105992,32222321,32251659,32275576,32275255,32353407,32341512,55438838,32400455,32449937,32473719,32471470,32642690,32572727,32589005,32666260,32708971,38114489,32744809,32886596,32906408,32909274,46701348,32918991,33005712,33152301,33167166,33216119,33246323,33278290,33278478,67866319,33407358,53603678,33470047,33502588,33558099,33623085,33781487,33826422,33892902,33943547,34045864,34049412,34111041,34133457,34151272,34244766,34267006,34303629,34321732,34315695,34460487,34414959,34396236,34426605,34459442,34467218,34495770,37984049,34562045,34599945,34592011,34624069,34640458,52654982,34687866,34809652,34750666,34770806,34784359,34797106,41730165,35093481,45479292,35214332,35286919,35300226,35355599,35402640,35458724,35524589,35654686,35743085,35848195,35867282,35905739,35907353,35939451,45555841,35970166,35993341,36012113,36076613,36173388,36220245,36239561,60296194,36278252,36343850,36372121,36379880,36508793,36590892,36677639,36949898,36719648,36854119,36857673,36924464,36926216,36962994,37048161,37047751,37085918,59769883,37142791,37167925,37168651,37198632,37242411,37269263,39250863,37298969,37405562,37478717,37479563,37595374,37628101,37657120,37722102,37748906,37826018,37877115,37905518,37979079,37992086,38151026,38309990,38871817,38347124,38331017,38382815,38472559,38610159,70200461,38820321,38863173,38963072,39029526,39087141,39099186,39231482,39266537,39265710,39270178,39369280,39404195,39426987,39532092,39543009,39548001,39564731,39705319,39763694,39875098,39889851,39892470,39927477,39927939,39933432,40022036,40050818,40215844,40613481,63914880,40641187,40785534,40812839,40924594,40954292,40994811,40962594,41023529,41039220,41162270,41138221,41185786,41207770,41241993,41229904,41269014,41277744,41309517,41331689,41345234,41363271,41376603,41405337,51013430,41534788,41567517,41696170,41719051,41768294,41830925,41836419,41908569,41943848,41968241,42001165,42007854,42007716,42070231,42072150,80713643,42168173,42168800,42176334,42189323,42309494,42345310,42366825,42396470,42412215,42459373,42465510,42524799,42615384,42685842,42760059,42780107,42794569,85536628,42838675,42922510,42949007,42987853,42974719,42977761,43064370,43065572,43184931,43239183,43280430,43357966,43370469,74480341,43492780,43528208,43504360,43506202,43533980,43545735,43580513,43618016,43620826,43655023,43665305,43710372,43720487,43750783,43780465,85390443,43870906,43949491,44069779,44394998,44418494,44484707,44525205,44540146,44695039,44693487,44826048,44853150,44860130,44876152,45017690,45039874,45057585,45066604,45086570,45106280,45234695,45239432,45260082,45295448,45402257,45434785,45460015,45444896,45743787,45799173,45964709,45887872,45921173,75034530,46236947,46205818,46283375,46283439,46338360,46355462,46385510,49631585,46504247,60267982,46556967,56890973,46619006,46626678,46639267,46713991,46692710,46811357,46834203,47000069,47178520,47166706,47175048,47222359,56966132,47327864,47341919,47395187,47430311,47476044,47517541,47580716,47725374,47595316,47774935,47632480,47704104,47706406,47711327,47720463,47738241,47754448,48166451,47750249,47763215,47810318,47872182,47909493,47982251,48005865,48100630,48131027,48131455,48133993,48177242,48197081,48207413,48246540,48382034,48504158,48553507,48608922,48657274,48736119,48800322,48919003,48975553,49032250,49013266,49035027,49099579,49196970,49204446,49294930,49364292,73048781,49449474,65608496,49729890,49744177,49775891,49803918,49944939,49953911,49961450,50018070,50052583,50055787,50085222,50224012,50265637,50426800,50479458,50485722,50493756,52091890,50761861,50827234,50868130,50952052,51050770,51095005,51168810,51247219,55164953,51251847,51327154,51382187,51367360,51425504,51430773,51465624,51503493,51528198,51534799,51544636,59968634,51646768,51766891,51834752,51866847,51873895,52056437,52225650,52243537,52293225,52299046,52302745,52562838,52379307,52417702,52451048,52448201,52514628,52535088,52580781,62598696,52769122,52755794,52767698,52865871,52904513,52927801,52940188,52947770,59115271,53134348,53191263,53197169,53266609,53273630,53340656,53349619,53382063,53409969,53474422,53520629,53665664,53695922,53710795,53952112,53964888,53967874,54027915,54023374,54042953,54101396,54107641,54159841,54180735,54189263,54189872,54251235,54324574,54529400,64908027,54679895,54738494,55317609,54796798,54841035,54884284,54949977,54956491,55020583,54980034,54984985,55011281,55029977,55058510,55066731,55089921,55106345,55135960,55213997,55257915,55267232,55308869,55320524,55381945,55438924,55441925,55468668,55600989,55701247,55832232,55874518,55893905,55901026,55975741,55993369,56273058,56136513,56187509,56226802,56240883,56275840,56494838,56559149,56588776,56632448,56652659,56675968,56765035,56859679,56861047,56894128,57045851,56924477,56949503,56997458,57005139,57032408,57043002,57151357,57163285,57264502,57475712,57609684,57662654,57737889,57773235,58001417,58149081,64988318,73512259,58218411,58337751,58372423,58450625,58509053,58710076,58688637,58712936,58790620,58809683,58809781,58880584,58887160,58883772,58919107,58977160,59065183,59615109,59151911,59161770,59166182,59301445,59320331,59351416,87284861,59442505,59488464,59501643,59510774,59525299,59598160,59607544,59644578,59699105,59754589,59793555,59829673,59963968,59980700,60012679,60045599,60158574,60169483,60265712,60264254,60271516,60299762,60367527,60370661,60428467,60479758,60484576,60496165,60583622,60630543,60669541,60729987,60730994,60800411,60814629,61061997,62155823,61305252,61365088,61703359,71609820,61576471,61577884,61588076,61639460,61679573,61717242,61730044,61728745,61781853,61812715,61882399,62404271,62055038,62086628,62095045,62285323,62196425,62254891,62252773,62282701,62407585,62467974,62510625,62571542,62717819,62768555,62811272,62846409,62880586,62878220,62888231,62902395,62951376,62993102,62999418,63016127,63021756,65713201,63256194,63404640,63429469,63509257,63514304,63539033,63566210,63609307,63698265,63895939,63898956,63915333,63925159,63935674,64357754,64048838,64069118,64091896,64085984,64211937,64407192,64432341,64466007,76896874,64568698,64685358,64714912,64722883,64724843,90124931,64776227,64863516,64904411,64938603,65008441,65016329,65051638,65142333,65149906,65192900,65247009,65224826,65403395,65425461,65431166,65499193,65587441,65623695,65650236,65678994,65710761,65755572,65807821,65827440,65839332,65836218,65872035,65898482,66118402,66131382,66178945,66202642,66232610,66244827,66336470,66415089,66436482,66444589,66450111,66508392,66622025,66645013,66694450,66721507,66822863,66828060,66863441,66939268,66918340,67001042,77587706,67106601,67218830,67235893,67272813,67281145,67309698,67326110,67344367,67363494,67377226,67466118,67520267,67545412,67598718,67612105,67675237,70764719,67761437,67734625,67782945,67757560,67795776,67878533,67890291,67927015,67952360,67987948,67998936,68102677,68128102,68154387,68187097,68199341,68280971,68294951,68324281,68445402,68458412,68480596,69942041,68727760,68847519,68870146,68877147,71057143,68980664,69130540,69138217,69182940,69306461,69305554,69478780,69342686,69362607,69372273,69433784,69435138,69743851,69775534,69809004,69829431,69948433,70141643,70169727,70316474,70334875,70335060,70374797,70424296,71974521,70531508,70669549,70718615,70733012,70805846,70808137,70812716,70826016,70834568,70875108,70914186,71071179,71293195,71328024,71439620,71536704,71654609,71659806,71664663,71728324,71758742,71768473,83551724,71901035,71980165,72070512,72070940,72080715,72148290,72186513,72288453,72351213,72447685,72457433,72564738,72607727,72609763,72622969,72624574,72667551,72743352,72832993,72794212,72865141,73010492,73045727,95003715,73123185,73283139,73305489,73327392,73343275,73334116,73351770,73412787,73466979,73454118,78917175,73578046,73585544,73627256,73628573,73669883,73688536,73768827,73781980,73784365,73888254,73893223,73914260,73979386,74076638,74091410,74232634,74305009,74334311,74372729,74494195,74594538,74724229,74769198,74785525,74810282,74958567,75040863,75063132,75101241,75158410,75195983,75257327,75302636,75332099,75466009,75474030,75475441,75500343,75612623,75571579,75660707,75729914,75800659,75811563,75877523,75917589,75937786,75951569,76047400,76169076,76162039,76243206,76248586,76341184,76344826,76383542,76559555,76605834,76603738,76760184,76800488,76881569,76820415,76877501,76990069,77124063,77195717,77207624,77237362,77351795,77361545,77372182,77366543,77447714,77464955,77485337,77646238,77719664,77853422,77908589,77940032,77966801,78053917,78041093,78045464,78051554,78089276,78181429,78293490,78293784,78364080,78747511,78453965,78423639,78430463,79733952,78506710,78520720,78539831,78633074,78697090,78703876,78770355,78772903,78779977,78887732,78904173,79010429,93212995,79150591,79217972,79378215,79394202,79490994,79517073,79563750,79647843,79751438,80015972,79863188,79994098,80023911,80118451,80130812,80141640,80249232,80260041,80292847,80298033,80299685,80324042,80359753,80380001,80486473,80522514,80592045,80691358,80769518,80780455,80921672,81039678,81052460,81199316,81136143,81165447,81160058,81233500,81233494,81244447,81344418,81436116,81436600,81470775,81497453,81565787,81689009,81766859,81789368,81876256,81903380,81912839,82038327,82048461,82077160,82122976,82122416,82272644,82320578,82298517,82427866,82437844,82448188,82503993,82606060,82655471,86268992,82772164,82847094,82880909,82952281,82983822,83007398,83015774,83028592,83073340,83241829,83278425,83302914,83385211,83403199,83528835,83538300,83793464,83841486,83838058,83851934,83906257,83884745,83893152,83971008,83991433,84057315,84077505,84121630,84132396,84191010,84212765,84570691,84705422,84754364,84807587,84839410,84971819,85008011,85089723,85122936,85127208,85135455,85177310,85281156,85396677,85416141,85448870,85464040,85483851,85660998,85665196,85958522,85979405,86120019,86152602,86183196,86184861,86196691,86219038,86236031,86231554,86257454,86296190,86324948,86438379,86554527,86570203,86617093,86642646,86634709,86633800,86636604,86632549,86673839,86857405,86775322,87005551,87018905,87108096,87093553,87145630,87161464,87615591,87208642,87233250,87326193,87421847,87412959,87523887,87564083,87655099,87678853,87782005,87810172,87853045,87849728,87949958,88030110,88046517,88062459,88098410,88109175,88297418,88341489,88632804,88622350,88658716,88662175,88825019,88846537,88885702,88883937,88919174,88949583,89040326,89082655,89121000,89176171,89172776,89364517,89381301,89416025,89619183,89721706,89784555,89851576,89898483,90052331,90138996,90043483,90365043,90292399,90347782,90461306,90534870,90646684,90686470,90823392,90894165,90912932,91004994,91033049,91140805,91147005,91151692,91206336,91236632,91498090,91257402,91295795,91302109,91431041,91484168,91524670,91560094,91596126,91606350,91614453,91624373,91630266,91749471,91770815,91851256,91871629,91906763,91901097,91975332,92096289,92061619,92149764,92166190,92274287,92429644,92431748,92515912,92611403,92576514,92671996,92727387,92792691,92797910,92832395,92860830,92880476,92866587,92883353,93022808,93179500,93224280,93240901,93319961,93341278,93505681,93589632,93715397,93787470,93819612,93930213,93969548,94002776,94004052,94024096,94038269,94130678,94147881,94241279,94270869,94456318,94461408,94512943,94560695,94696994,94811293,94829019,94903852,95066738,95089620,95186244,95396301,95501140,95465466,95526064,95545322,95582001,95629106,95810172,96040685,96060560,96406229,96580872,96554132,96571139,96602780,96813919,96748950,96767867,96772570,96776986,96860992,96875271,96890326,96964702,96976441,97072457,97380503,97432085,97701190,97761351,97807644,97819478,97898645,97995437,98117613,98059713,98098230,98188966,98249706,98254152,98307265,98349840,98351974,98354696,98401427,98391354,98455472,98418128,98427000,98554551,98566617,98612890,98626916,98990837,99290301,99359400,99412114);",
        conn, parse_dates={"CreationDate": "%Y-%m-%d %H:%M:%S"})
    df_edits = pd.read_sql_query(
        "SELECT * FROM EditHistory_Code WHERE Event = 'BodyEdit' AND PostId IN (7875,361158,514517,560006,818313,939060,1276894,1318955,1417254,1460531,1582903,1606967,1721911,1727150,1757843,1804490,1938319,1947343,2015329,2061144,2116999,2182488,2206432,2256556,2486471,2494473,2543357,2550109,2563426,2604454,2859362,2861345,2901136,2923021,2931250,3086406,3180655,3272126,3275379,3347598,3359695,3360387,3366318,3383237,3439495,3490999,3498816,3517919,3654309,3835837,3941993,3998810,4002998,4040641,4067488,4126533,4132683,4168659,4209637,4217452,4221530,4291761,4315367,4323607,4324452,4325585,4357318,4379154,4430047,4528579,4531464,4556879,4605982,4608989,4645552,4684900,4694816,4769473,4777541,4812456,4903603,4941028,4942094,4988445,5013708,5112457,5115995,5135509,5147430,5169321,5239735,5299411,5326382,5370006,5453261,5518611,5553947,5586896,5616616,5731533,5761842,5763969,5767092,5866205,5889651,6010680,6049311,6148209,6254602,6296603,6330456,6342311,6632209,6667403,6722434,6870575,6872517,6908115,6954573,7008045,7078376,7080110,7126108,7168985,7234654,7235584,7258784,7271326,7460596,7493521,7498411,7499793,7544391,7643008,7891698,7896397,7936715,7947296,7967539,8037122,8037909,8048636,8136851,8142097,8155443,8166211,8197624,8203073,8218524,8253636,8261392,8273826,8279939,8283470,8299499,8329078,8365193,8525234,8537652,8577641,8615751,8620362,8623341,8696030,8717383,8717759,8832616,8946209,8961590,8974368,9043462,9113266,9148954,9196192,9236878,9239808,9247380,9254988,9262981,9267268,9397206,9509032,9556452,9570292,9575427,9584654,9603211,9630432,9660168,9671062,9686046,9733686,9756189,9765719,9798430,9818245,9842690,9920124,9925196,9946432,9967906,10002805,10002834,10055551,10059880,10060390,10087552,10138018,10150458,10158545,10160317,10246492,10261872,10270526,10270684,10273530,10280163,10284119,10341595,10343816,10352231,10374564,10405545,10457243,10474157,10498341,10547344,10575359,10663878,10675391,10844889,10853256,10869600,10879118,10895018,10985461,10986507,10994146,11013401,11020094,11061143,11069963,11100438,11131801,11152781,11158889,11183232,11217492,11261905,11266091,11267066,11310902,11369081,11384073,11402943,11456310,11468529,11523531,11530571,11545703,11617389,11620982,11623633,11649404,11682656,11697562,11709155,11725088,11727032,11732184,11741915,11801725,11814973,11815880,11826470,11830636,11834538,11847167,11884184,11938690,11992159,12002701,12011946,12024009,12065201,12084655,12085902,12113136,12154831,12180861,12219643,12242834,12285644,12330345,12341744,12372494,12376115,12414939,12444134,12452881,12509737,12559448,12575319,12586471,12597907,12612197,12631280,12638451,12656440,12760132,12775631,12836218,12892964,12911772,12926968,12952985,12956052,12960000,12973748,13039557,13050303,13168163,13202590,13310791,13316398,13363666,13386360,13401681,13412270,13479302,13490333,13490879,13510414,13548302,13594807,13607810,13608535,13636838,13646997,13667934,13673381,13673381,13675924,13703279,13744466,13773615,13794975,13797038,13821778,13823883,13899297,13938724,13955260,13988109,13988418,14027481,14062168,14090649,14110654,14146919,14148205,14176330,14183099,14183626,14246712,14274978,14295201,14299498,14319623,14330893,14336386,14358801,14377232,14384225,14385245,14395504,14435255,14499028,14505065,14534000,14540400,14558540,14625227,14656445,14671329,14716556,14778058,14833921,14861957,14902902,14951869,15013259,15030050,15040541,15062297,15127813,15200344,15226559,15244655,15247892,15262932,15275622,15310530,15376996,15498722,15555250,15559352,15563455,15595034,15616641,15617490,15618861,15639564,15640688,15678836,15762726,15795118,15795612,15801490,15831048,15836989,15840470,15849329,15883604,15901591,15913821,15915111,15957975,15976303,15984885,16058967,16063924,16148101,16152352,16184706,16223058,16251905,16273678,16346563,16356199,16384427,16433740,16464249,16523245,16575426,16578216,16587759,16588794,16605563,16621809,16623428,16675998,16696265,16708675,16708712,16726135,16849913,16912368,16939962,16952627,17031532,17057187,17065946,17135768,17191396,17212266,17249470,17253665,17268172,17319638,17374352,17387979,17403187,17422278,17533368,17534943,17544435,17558331,17596672,17599402,17659899,17750618,17761938,17799399,17808106,17823100,17829520,17831915,17861364,17867875,17890507,17892107,17913039,17944769,17955511,17994028,18048949,18054342,18078475,18114286,18140785,18176414,18194951,18243157,18266011,18277576,18344018,18365444,18374687,18382681,18403272,18443074,18443615,18493467,18505187,18518457,18601061,18635859,18653838,18670979,18756993,18787645,18874276,18894906,18931196,19045774,19097179,19098833,19120443,19170570,19175086,19200180,19263216,19269519,19345640,19383046,19443594,19457772,19503164,19533315,19533769,19557345,19558303,19613767,19694159,19700238,19700790,19732758,19760247,19782902,19941171,19947286,20041558,20051167,20067797,20226848,20248588,20281502,20283372,20299372,20355839,20387055,20389922,20398666,20413155,20416228,20424188,20517410,20522648,20542629,20552569,20564980,20578963,20587235,20597704,20617878,20643356,20658703,20662767,20682670,20692655,20815209,20830515,20835681,20841187,20901037,20923857,20934707,20965305,20979166,20982407,21051450,21160142,21162679,21195919,21221088,21232710,21249586,21260669,21281413,21368011,21384042,21396800,21397451,21415825,21435581,21459305,21467987,21496496,21505671,21508484,21546112,21563424,21574754,21616835,21642984,21661883,21663663,21743445,21751376,21756392,21757928,21761849,21810409,21892282,21900743,21928787,21945515,21963319,21963433,21970805,22013847,22030553,22070320,22089094,22119882,22155631,22244318,22268246,22303390,22335133,22392071,22395788,22430939,22443141,22453634,22507973,22519985,22540389,22542942,22547276,22555650,22558242,22584238,22598814,22628009,22632211,22648500,22666420,22682946,22691984,22701950,22719774,22729235,22739509,22755610,22763803,22790433,22801381,22809006,22815825,22840483,22979262,23005376,23047291,23087549,23094548,23125714,23152151,23184349,23221007,23292037,23341180,23397767,23406739,23428647,23429229,23445771,23457635,23462834,23475753,23485518,23520357,23571630,23596935,23607026,23618258,23627409,23660859,23675576,23679600,23746834,23789009,23836513,23845349,23857995,23929136,23930639,23966454,23966579,23986040,24031643,24032220,24053116,24062304,24082528,24097089,24097395,24112752,24136031,24150475,24160444,24164199,24222260,24261239,24261462,24321596,24339850,24354619,24374760,24403148,24445163,24466679,24487545,24527796,24534339,24617748,24703200,24704262,24711801,24714459,24741513,24788996,24861566,24964658,24973371,24994747,25048956,25084373,25115125,25118473,25192607,25210874,25211347,25213188,25265847,25283650,25297013,25346470,25360511,25363478,25371794,25447101,25478667,25517475,25547280,25548715,25566304,25567294,25570082,25618303,25633751,25722877,25941522,25949661,25957993,26037257,26051940,26113084,26128045,26131972,26133705,26166810,26175327,26183490,26227896,26254861,26266467,26275516,26278551,26299482,26304744,26321860,26334185,26341492,26351539,26359016,26374342,26410127,26422593,26464722,26534852,26548074,26575292,26607409,26612264,26651951,26670820,26684874,26703817,26706398,26707401,26742187,26743196,26783818,26797049,26797389,26798022,26807873,26875502,26895625,26908353,26923279,26933338,26954938,26963815,26996935,27048844,27088557,27129527,27141186,27149731,27173320,27173543,27221870,27236117,27240944,27249942,27251625,27297618,27300544,27366112,27396031,27417444,27460666,27467436,27506104,27532110,27536719,27537995,27538754,27553766,27559665,27577280,27595376,27598202,27616741,27620077,27646170,27651724,27667930,27682935,27692016,27729621,27765983,27816725,28002960,28015389,28050921,28072526,28080459,28131480,28161001,28231279,28246170,28250239,28259162,28335740,28347534,28357108,28362194,28372662,28382894,28453744,28456193,28467274,28486803,28543628,28561949,28566489,28567081,28726502,28759071,28786403,28806923,28824504,28895316,28972885,28977351,29019131,29019668,29050054,29059351,29065976,29067911,29139345,29149361,29169171,29175115,29203801,29208158,29214653,29220691,29236493,29308493,29313135,29411594,29497063,29504539,29507856,29534808,29545290,29590346,29597612,29625108,29643329,29668832,29690325,29716191,29720760,29723153,29730724,29749514,29787277,29788591,29790728,29795883,29805223,29805588,29810469,29811000,29818178,29842091,29873578,29893244,29929794,29942398,29990543,30006033,30006383,30007770,30030466,30040186,30045992,30065760,30136118,30199210,30224730,30253998,30279363,30305493,30352849,30416453,30446432,30458638,30465037,30477785,30511497,30551522,30566591,30613660,30649339,30686992,30693676,30832210,30840682,30850186,30866171,30881191,30955983,30960635,30963999,30994088,31011581,31014364,31028728,31104351,31126573,31212242,31240497,31243894,31248225,31251788,31392227,31427338,31449102,31494182,31545286,31570036,31609446,31650184,31653048,31653245,31676282,31708000,31714336,31745480,31745553,31766828,31786814,31799561,31804269,31809481,31826470,31863695,31874400,31962949,31976242,31984465,32080037,32167419,32178820,32204414,32207358,32209194,32236521,32248981,32269519,32275512,32285180,32319331,32324152,32353429,32393698,32427093,32446063,32452510,32502630,32522692,32534927,32541239,32545385,32617585,32642851,32672253,32675997,32710344,32714867,32749983,32754922,32770815,32771266,32805259,32843260,32918963,32935102,32942720,33064890,33072851,33075045,33093774,33098354,33114312,33143268,33148867,33176109,33187247,33191611,33191679,33219006,33256288,33366449,33437366,33444867,33476734,33494987,33506602,33529736,33552216,33586638,33590305,33591961,33602297,33605139,33618191,33627839,33641677,33643311,33657815,33666531,33681376,33721002,33743060,33747984,33770290,33776967,33792425,33832748,33838178,33851640,33919877,33971929,34037428,34060235,34069130,34073927,34112810,34120216,34181379,34195196,34220750,34241421,34249550,34266530,34376447,34408681,34423517,34445236,34455384,34466982,34510608,34557712,34558760,34574477,34575648,34589083,34598078,34621690,34629675,34643059,34648570,34702666,34708387,34759591,34868195,34938619,34966098,35004710,35020809,35138755,35216133,35219474,35249783,35252575,35308527,35332020,35372103,35403389,35497946,35497964,35510889,35549533,35560225,35560590,35590767,35590767,35599495,35612690,35648172,35693264,35693578,35739045,35743682,35746396,35811456,35823736,35842942,35889474,35890604,35914650,35921671,35926129,35932904,35971935,35976603,35995971,36022198,36053385,36073686,36092565,36163352,36171692,36188657,36205392,36264688,36269980,36301610,36320155,36323513,36338432,36373533,36373663,36405138,36432392,36432553,36440703,36486897,36512049,36523132,36564434,36565615,36601166,36608850,36735910,36846085,36868781,36900249,36924731,36956622,37012089,37012846,37015421,37044830,37066827,37086470,37092024,37092427,37118651,37136990,37173859,37187703,37264012,37278168,37285008,37318859,37339594,37368674,37370249,37386443,37453268,37483528,37508304,37540031,37617173,37641990,37666061,37684436,37697179,37702078,37704902,37714318,37727402,37762134,37765135,37769932,37776174,37816976,37901571,37965678,37992391,38024945,38037269,38049902,38063143,38086081,38110852,38236739,38238363,38246557,38251855,38257253,38300115,38313839,38327251,38334528,38334747,38400960,38504255,38518129,38536173,38547346,38587221,38651536,38667012,38671182,38672135,38681418,38699205,38723725,38763036,38783706,38820880,38824811,38843217,38891160,38895360,38904362,38904362,38934148,39026239,39037928,39040543,39075574,39120587,39139491,39151637,39167699,39183501,39208329,39220959,39233138,39237587,39249372,39268432,39281965,39395659,39402720,39427521,39439365,39455641,39462048,39509953,39551445,39562935,39566876,39569666,39599651,39657730,39671852,39697649,39706712,39763827,39766730,39784610,39796059,39813738,39856353,39864295,39910967,39951997,39977973,39997099,40001644,40015644,40024330,40033661,40040701,40050521,40096675,40125057,40132610,40164633,40171820,40201740,40217754,40235863,40235904,40237594,40247568,40267509,40310563,40313481,40335689,40345985,40367309,40372658,40425316,40440530,40454158,40471235,40474532,40519783,40526356,40542626,40605034,40611808,40623299,40704077,40736514,40813524,40825464,40828270,40855794,40883247,40960619,40963516,40977348,41048353,41048965,41063137,41067576,41078076,41083139,41114471,41115444,41271166,41286761,41302883,41313003,41373257,41462630,41481803,41555552,41563895,41563897,41568370,41609515,41629983,41662470,41737893,41761656,41770767,41806935,41809552,41812258,41817966,41821924,41843713,41865284,41916833,42060276,42078133,42136728,42187180,42247551,42250978,42253098,42285669,42301905,42306581,42316411,42374536,42416986,42464221,42464496,42469760,42505230,42525241,42577798,42611016,42650360,42666184,42722091,42745270,42745733,42753376,42754141,42771800,42815555,42822777,42842593,42880771,42957683,42976849,42981575,43017368,43100605,43112609,43123967,43126362,43127565,43136269,43169475,43174426,43190378,43196972,43254482,43258005,43279035,43280212,43301459,43311175,43352765,43359649,43361112,43414677,43416996,43427889,43461724,43511213,43518846,43589836,43628193,43642366,43662415,43724721,43770851,43835126,43866704,43875064,43887920,43964137,44005916,44017971,44037321,44066476,44082117,44118825,44139492,44157398,44216536,44231990,44232400,44245787,44259757,44282517,44328262,44364052,44398934,44405921,44439069,44460065,44470955,44478159,44506576,44573866,44587005,44628721,44629671,44677700,44679028,44699412,44787113,44810010,44811535,44890983,44911113,44915114,44922210,44950878,45007179,45075646,45111288,45118268,45125055,45192155,45195931,45197334,45199500,45240804,45250051,45258819,45337346,45379089,45432641,45473920,45488299,45503027,45538009,45540503,45542574,45545901,45565196,45610309,45667987,45667987,45702529,45720860,45726250,45732890,45736085,45760861,45772224,45781647,45789765,45837544,45857726,45872547,45893780,45907214,45910474,45964421,45972454,46025406,46055324,46094215,46127745,46207138,46215793,46260542,46277144,46300143,46343211,46393474,46428741,46453711,46520070,46531352,46582357,46588323,46594126,46649922,46651492,46671750,46674148,46675245,46680080,46704641,46716815,46770584,46787348,46802702,46870164,46911175,46916086,46987326,47046198,47052559,47091110,47092339,47100316,47104641,47141031,47141669,47146119,47197865,47242304,47242896,47259470,47271897,47307533,47368258,47406508,47415643,47460589,47473010,47478820,47539689,47545712,47550143,47570669,47582363,47657146,47660583,47667333,47732187,47738713,47743840,47771377,47818939,47845637,47869082,47902521,47930656,47955507,47991819,48006836,48019234,48023108,48023926,48050732,48132069,48149583,48161594,48201601,48210898,48253529,48277470,48391112,48417942,48424108,48430421,48445377,48445377,48448588,48488955,48498763,48530763,48539665,48562953,48568006,48597015,48608229,48784646,48849217,48863574,48899229,48909781,48982124,49001465,49042192,49054649,49060906,49063612,49072401,49137865,49194724,49205358,49222391,49230344,49239091,49324753,49331559,49477991,49488361,49556258,49572152,49587665,49588583,49594320,49605667,49611325,49612466,49624362,49643201,49657185,49712373,49767831,49777371,49801154,49803385,49806413,49807694,49808459,49808855,49829237,49876892,49879709,49994300,50000804,50032469,50037914,50064265,50072344,50079226,50085689,50107889,50153682,50196591,50198000,50252930,50273502,50319225,50328445,50383046,50396724,50401250,50416883,50468424,50508946,50516856,50523918,50543293,50547398,50643390,50665718,50805185,50808175,50823355,50828912,50912438,50923433,50942446,50942905,50959129,50976737,51023803,51045526,51064565,51087761,51092254,51191109,51199783,51217365,51319585,51368086,51406614,51440674,51448369,51514862,51523332,51537352,51645541,51664465,51692602,51750300,51788805,51846665,51851722,51936077,51971005,51980772,52022412,52038658,52095287,52098233,52100343,52127982,52137676,52143991,52153588,52172471,52175721,52241107,52268202,52288027,52306255,52324512,52329084,52333556,52338027,52341611,52385326,52413499,52454084,52464631,52466191,52467937,52517618,52524114,52560553,52607832,52615771,52671874,52751945,52753839,52791021,52809388,52829505,52879125,52900023,52941625,52942822,52962433,52970381,52975797,52980017,52988925,53062115,53142133,53162961,53175054,53216022,53227287,53312361,53354155,53420325,53456077,53474179,53530646,53540698,53568218,53569543,53580299,53587489,53634984,53644456,53692842,53708081,53803910,53806369,53830302,53852343,53927692,53986971,53993132,54033878,54117000,54129165,54178741,54269031,54303414,54323332,54355276,54365760,54384445,54409153,54491356,54615947,54618631,54808259,54886614,54892387,54901809,54918427,54975729,54996120,55005854,55008623,55010830,55053845,55063368,55069962,55110864,55117356,55165291,55327050,55352817,55475988,55528673,55553167,55553620,55601087,55652916,55682960,55688314,55708604,55756492,55788001,55792385,55820395,55843569,55844698,55845564,55855047,55865385,55868868,55879567,55884358,55944669,55957419,55981574,55988793,56169081,56341879,56378053,56403974);",
        conn, parse_dates={"CreationDate": "%Y-%m-%d %H:%M:%S"})
    df_questions = pd.read_sql_query(
        "SELECT * FROM EditHistory_Code WHERE Event = 'InitialBody' AND PostId IN (SELECT DISTINCT ParentId FROM EditHistory_Code WHERE PostId IN (7875,361158,514517,560006,818313,939060,1276894,1318955,1417254,1460531,1582903,1606967,1721911,1727150,1757843,1804490,1938319,1947343,2015329,2061144,2116999,2182488,2206432,2256556,2486471,2494473,2543357,2550109,2563426,2604454,2859362,2861345,2901136,2923021,2931250,3086406,3180655,3272126,3275379,3347598,3359695,3360387,3366318,3383237,3439495,3490999,3498816,3517919,3654309,3835837,3941993,3998810,4002998,4040641,4067488,4126533,4132683,4168659,4209637,4217452,4221530,4291761,4315367,4323607,4324452,4325585,4357318,4379154,4430047,4528579,4531464,4556879,4605982,4608989,4645552,4684900,4694816,4769473,4777541,4812456,4903603,4941028,4942094,4988445,5013708,5112457,5115995,5135509,5147430,5169321,5239735,5299411,5326382,5370006,5453261,5518611,5553947,5586896,5616616,5731533,5761842,5763969,5767092,5866205,5889651,6010680,6049311,6148209,6254602,6296603,6330456,6342311,6632209,6667403,6722434,6870575,6872517,6908115,6954573,7008045,7078376,7080110,7126108,7168985,7234654,7235584,7258784,7271326,7460596,7493521,7498411,7499793,7544391,7643008,7891698,7896397,7936715,7947296,7967539,8037122,8037909,8048636,8136851,8142097,8155443,8166211,8197624,8203073,8218524,8253636,8261392,8273826,8279939,8283470,8299499,8329078,8365193,8525234,8537652,8577641,8615751,8620362,8623341,8696030,8717383,8717759,8832616,8946209,8961590,8974368,9043462,9113266,9148954,9196192,9236878,9239808,9247380,9254988,9262981,9267268,9397206,9509032,9556452,9570292,9575427,9584654,9603211,9630432,9660168,9671062,9686046,9733686,9756189,9765719,9798430,9818245,9842690,9920124,9925196,9946432,9967906,10002805,10002834,10055551,10059880,10060390,10087552,10138018,10150458,10158545,10160317,10246492,10261872,10270526,10270684,10273530,10280163,10284119,10341595,10343816,10352231,10374564,10405545,10457243,10474157,10498341,10547344,10575359,10663878,10675391,10844889,10853256,10869600,10879118,10895018,10985461,10986507,10994146,11013401,11020094,11061143,11069963,11100438,11131801,11152781,11158889,11183232,11217492,11261905,11266091,11267066,11310902,11369081,11384073,11402943,11456310,11468529,11523531,11530571,11545703,11617389,11620982,11623633,11649404,11682656,11697562,11709155,11725088,11727032,11732184,11741915,11801725,11814973,11815880,11826470,11830636,11834538,11847167,11884184,11938690,11992159,12002701,12011946,12024009,12065201,12084655,12085902,12113136,12154831,12180861,12219643,12242834,12285644,12330345,12341744,12372494,12376115,12414939,12444134,12452881,12509737,12559448,12575319,12586471,12597907,12612197,12631280,12638451,12656440,12760132,12775631,12836218,12892964,12911772,12926968,12952985,12956052,12960000,12973748,13039557,13050303,13168163,13202590,13310791,13316398,13363666,13386360,13401681,13412270,13479302,13490333,13490879,13510414,13548302,13594807,13607810,13608535,13636838,13646997,13667934,13673381,13673381,13675924,13703279,13744466,13773615,13794975,13797038,13821778,13823883,13899297,13938724,13955260,13988109,13988418,14027481,14062168,14090649,14110654,14146919,14148205,14176330,14183099,14183626,14246712,14274978,14295201,14299498,14319623,14330893,14336386,14358801,14377232,14384225,14385245,14395504,14435255,14499028,14505065,14534000,14540400,14558540,14625227,14656445,14671329,14716556,14778058,14833921,14861957,14902902,14951869,15013259,15030050,15040541,15062297,15127813,15200344,15226559,15244655,15247892,15262932,15275622,15310530,15376996,15498722,15555250,15559352,15563455,15595034,15616641,15617490,15618861,15639564,15640688,15678836,15762726,15795118,15795612,15801490,15831048,15836989,15840470,15849329,15883604,15901591,15913821,15915111,15957975,15976303,15984885,16058967,16063924,16148101,16152352,16184706,16223058,16251905,16273678,16346563,16356199,16384427,16433740,16464249,16523245,16575426,16578216,16587759,16588794,16605563,16621809,16623428,16675998,16696265,16708675,16708712,16726135,16849913,16912368,16939962,16952627,17031532,17057187,17065946,17135768,17191396,17212266,17249470,17253665,17268172,17319638,17374352,17387979,17403187,17422278,17533368,17534943,17544435,17558331,17596672,17599402,17659899,17750618,17761938,17799399,17808106,17823100,17829520,17831915,17861364,17867875,17890507,17892107,17913039,17944769,17955511,17994028,18048949,18054342,18078475,18114286,18140785,18176414,18194951,18243157,18266011,18277576,18344018,18365444,18374687,18382681,18403272,18443074,18443615,18493467,18505187,18518457,18601061,18635859,18653838,18670979,18756993,18787645,18874276,18894906,18931196,19045774,19097179,19098833,19120443,19170570,19175086,19200180,19263216,19269519,19345640,19383046,19443594,19457772,19503164,19533315,19533769,19557345,19558303,19613767,19694159,19700238,19700790,19732758,19760247,19782902,19941171,19947286,20041558,20051167,20067797,20226848,20248588,20281502,20283372,20299372,20355839,20387055,20389922,20398666,20413155,20416228,20424188,20517410,20522648,20542629,20552569,20564980,20578963,20587235,20597704,20617878,20643356,20658703,20662767,20682670,20692655,20815209,20830515,20835681,20841187,20901037,20923857,20934707,20965305,20979166,20982407,21051450,21160142,21162679,21195919,21221088,21232710,21249586,21260669,21281413,21368011,21384042,21396800,21397451,21415825,21435581,21459305,21467987,21496496,21505671,21508484,21546112,21563424,21574754,21616835,21642984,21661883,21663663,21743445,21751376,21756392,21757928,21761849,21810409,21892282,21900743,21928787,21945515,21963319,21963433,21970805,22013847,22030553,22070320,22089094,22119882,22155631,22244318,22268246,22303390,22335133,22392071,22395788,22430939,22443141,22453634,22507973,22519985,22540389,22542942,22547276,22555650,22558242,22584238,22598814,22628009,22632211,22648500,22666420,22682946,22691984,22701950,22719774,22729235,22739509,22755610,22763803,22790433,22801381,22809006,22815825,22840483,22979262,23005376,23047291,23087549,23094548,23125714,23152151,23184349,23221007,23292037,23341180,23397767,23406739,23428647,23429229,23445771,23457635,23462834,23475753,23485518,23520357,23571630,23596935,23607026,23618258,23627409,23660859,23675576,23679600,23746834,23789009,23836513,23845349,23857995,23929136,23930639,23966454,23966579,23986040,24031643,24032220,24053116,24062304,24082528,24097089,24097395,24112752,24136031,24150475,24160444,24164199,24222260,24261239,24261462,24321596,24339850,24354619,24374760,24403148,24445163,24466679,24487545,24527796,24534339,24617748,24703200,24704262,24711801,24714459,24741513,24788996,24861566,24964658,24973371,24994747,25048956,25084373,25115125,25118473,25192607,25210874,25211347,25213188,25265847,25283650,25297013,25346470,25360511,25363478,25371794,25447101,25478667,25517475,25547280,25548715,25566304,25567294,25570082,25618303,25633751,25722877,25941522,25949661,25957993,26037257,26051940,26113084,26128045,26131972,26133705,26166810,26175327,26183490,26227896,26254861,26266467,26275516,26278551,26299482,26304744,26321860,26334185,26341492,26351539,26359016,26374342,26410127,26422593,26464722,26534852,26548074,26575292,26607409,26612264,26651951,26670820,26684874,26703817,26706398,26707401,26742187,26743196,26783818,26797049,26797389,26798022,26807873,26875502,26895625,26908353,26923279,26933338,26954938,26963815,26996935,27048844,27088557,27129527,27141186,27149731,27173320,27173543,27221870,27236117,27240944,27249942,27251625,27297618,27300544,27366112,27396031,27417444,27460666,27467436,27506104,27532110,27536719,27537995,27538754,27553766,27559665,27577280,27595376,27598202,27616741,27620077,27646170,27651724,27667930,27682935,27692016,27729621,27765983,27816725,28002960,28015389,28050921,28072526,28080459,28131480,28161001,28231279,28246170,28250239,28259162,28335740,28347534,28357108,28362194,28372662,28382894,28453744,28456193,28467274,28486803,28543628,28561949,28566489,28567081,28726502,28759071,28786403,28806923,28824504,28895316,28972885,28977351,29019131,29019668,29050054,29059351,29065976,29067911,29139345,29149361,29169171,29175115,29203801,29208158,29214653,29220691,29236493,29308493,29313135,29411594,29497063,29504539,29507856,29534808,29545290,29590346,29597612,29625108,29643329,29668832,29690325,29716191,29720760,29723153,29730724,29749514,29787277,29788591,29790728,29795883,29805223,29805588,29810469,29811000,29818178,29842091,29873578,29893244,29929794,29942398,29990543,30006033,30006383,30007770,30030466,30040186,30045992,30065760,30136118,30199210,30224730,30253998,30279363,30305493,30352849,30416453,30446432,30458638,30465037,30477785,30511497,30551522,30566591,30613660,30649339,30686992,30693676,30832210,30840682,30850186,30866171,30881191,30955983,30960635,30963999,30994088,31011581,31014364,31028728,31104351,31126573,31212242,31240497,31243894,31248225,31251788,31392227,31427338,31449102,31494182,31545286,31570036,31609446,31650184,31653048,31653245,31676282,31708000,31714336,31745480,31745553,31766828,31786814,31799561,31804269,31809481,31826470,31863695,31874400,31962949,31976242,31984465,32080037,32167419,32178820,32204414,32207358,32209194,32236521,32248981,32269519,32275512,32285180,32319331,32324152,32353429,32393698,32427093,32446063,32452510,32502630,32522692,32534927,32541239,32545385,32617585,32642851,32672253,32675997,32710344,32714867,32749983,32754922,32770815,32771266,32805259,32843260,32918963,32935102,32942720,33064890,33072851,33075045,33093774,33098354,33114312,33143268,33148867,33176109,33187247,33191611,33191679,33219006,33256288,33366449,33437366,33444867,33476734,33494987,33506602,33529736,33552216,33586638,33590305,33591961,33602297,33605139,33618191,33627839,33641677,33643311,33657815,33666531,33681376,33721002,33743060,33747984,33770290,33776967,33792425,33832748,33838178,33851640,33919877,33971929,34037428,34060235,34069130,34073927,34112810,34120216,34181379,34195196,34220750,34241421,34249550,34266530,34376447,34408681,34423517,34445236,34455384,34466982,34510608,34557712,34558760,34574477,34575648,34589083,34598078,34621690,34629675,34643059,34648570,34702666,34708387,34759591,34868195,34938619,34966098,35004710,35020809,35138755,35216133,35219474,35249783,35252575,35308527,35332020,35372103,35403389,35497946,35497964,35510889,35549533,35560225,35560590,35590767,35590767,35599495,35612690,35648172,35693264,35693578,35739045,35743682,35746396,35811456,35823736,35842942,35889474,35890604,35914650,35921671,35926129,35932904,35971935,35976603,35995971,36022198,36053385,36073686,36092565,36163352,36171692,36188657,36205392,36264688,36269980,36301610,36320155,36323513,36338432,36373533,36373663,36405138,36432392,36432553,36440703,36486897,36512049,36523132,36564434,36565615,36601166,36608850,36735910,36846085,36868781,36900249,36924731,36956622,37012089,37012846,37015421,37044830,37066827,37086470,37092024,37092427,37118651,37136990,37173859,37187703,37264012,37278168,37285008,37318859,37339594,37368674,37370249,37386443,37453268,37483528,37508304,37540031,37617173,37641990,37666061,37684436,37697179,37702078,37704902,37714318,37727402,37762134,37765135,37769932,37776174,37816976,37901571,37965678,37992391,38024945,38037269,38049902,38063143,38086081,38110852,38236739,38238363,38246557,38251855,38257253,38300115,38313839,38327251,38334528,38334747,38400960,38504255,38518129,38536173,38547346,38587221,38651536,38667012,38671182,38672135,38681418,38699205,38723725,38763036,38783706,38820880,38824811,38843217,38891160,38895360,38904362,38904362,38934148,39026239,39037928,39040543,39075574,39120587,39139491,39151637,39167699,39183501,39208329,39220959,39233138,39237587,39249372,39268432,39281965,39395659,39402720,39427521,39439365,39455641,39462048,39509953,39551445,39562935,39566876,39569666,39599651,39657730,39671852,39697649,39706712,39763827,39766730,39784610,39796059,39813738,39856353,39864295,39910967,39951997,39977973,39997099,40001644,40015644,40024330,40033661,40040701,40050521,40096675,40125057,40132610,40164633,40171820,40201740,40217754,40235863,40235904,40237594,40247568,40267509,40310563,40313481,40335689,40345985,40367309,40372658,40425316,40440530,40454158,40471235,40474532,40519783,40526356,40542626,40605034,40611808,40623299,40704077,40736514,40813524,40825464,40828270,40855794,40883247,40960619,40963516,40977348,41048353,41048965,41063137,41067576,41078076,41083139,41114471,41115444,41271166,41286761,41302883,41313003,41373257,41462630,41481803,41555552,41563895,41563897,41568370,41609515,41629983,41662470,41737893,41761656,41770767,41806935,41809552,41812258,41817966,41821924,41843713,41865284,41916833,42060276,42078133,42136728,42187180,42247551,42250978,42253098,42285669,42301905,42306581,42316411,42374536,42416986,42464221,42464496,42469760,42505230,42525241,42577798,42611016,42650360,42666184,42722091,42745270,42745733,42753376,42754141,42771800,42815555,42822777,42842593,42880771,42957683,42976849,42981575,43017368,43100605,43112609,43123967,43126362,43127565,43136269,43169475,43174426,43190378,43196972,43254482,43258005,43279035,43280212,43301459,43311175,43352765,43359649,43361112,43414677,43416996,43427889,43461724,43511213,43518846,43589836,43628193,43642366,43662415,43724721,43770851,43835126,43866704,43875064,43887920,43964137,44005916,44017971,44037321,44066476,44082117,44118825,44139492,44157398,44216536,44231990,44232400,44245787,44259757,44282517,44328262,44364052,44398934,44405921,44439069,44460065,44470955,44478159,44506576,44573866,44587005,44628721,44629671,44677700,44679028,44699412,44787113,44810010,44811535,44890983,44911113,44915114,44922210,44950878,45007179,45075646,45111288,45118268,45125055,45192155,45195931,45197334,45199500,45240804,45250051,45258819,45337346,45379089,45432641,45473920,45488299,45503027,45538009,45540503,45542574,45545901,45565196,45610309,45667987,45667987,45702529,45720860,45726250,45732890,45736085,45760861,45772224,45781647,45789765,45837544,45857726,45872547,45893780,45907214,45910474,45964421,45972454,46025406,46055324,46094215,46127745,46207138,46215793,46260542,46277144,46300143,46343211,46393474,46428741,46453711,46520070,46531352,46582357,46588323,46594126,46649922,46651492,46671750,46674148,46675245,46680080,46704641,46716815,46770584,46787348,46802702,46870164,46911175,46916086,46987326,47046198,47052559,47091110,47092339,47100316,47104641,47141031,47141669,47146119,47197865,47242304,47242896,47259470,47271897,47307533,47368258,47406508,47415643,47460589,47473010,47478820,47539689,47545712,47550143,47570669,47582363,47657146,47660583,47667333,47732187,47738713,47743840,47771377,47818939,47845637,47869082,47902521,47930656,47955507,47991819,48006836,48019234,48023108,48023926,48050732,48132069,48149583,48161594,48201601,48210898,48253529,48277470,48391112,48417942,48424108,48430421,48445377,48445377,48448588,48488955,48498763,48530763,48539665,48562953,48568006,48597015,48608229,48784646,48849217,48863574,48899229,48909781,48982124,49001465,49042192,49054649,49060906,49063612,49072401,49137865,49194724,49205358,49222391,49230344,49239091,49324753,49331559,49477991,49488361,49556258,49572152,49587665,49588583,49594320,49605667,49611325,49612466,49624362,49643201,49657185,49712373,49767831,49777371,49801154,49803385,49806413,49807694,49808459,49808855,49829237,49876892,49879709,49994300,50000804,50032469,50037914,50064265,50072344,50079226,50085689,50107889,50153682,50196591,50198000,50252930,50273502,50319225,50328445,50383046,50396724,50401250,50416883,50468424,50508946,50516856,50523918,50543293,50547398,50643390,50665718,50805185,50808175,50823355,50828912,50912438,50923433,50942446,50942905,50959129,50976737,51023803,51045526,51064565,51087761,51092254,51191109,51199783,51217365,51319585,51368086,51406614,51440674,51448369,51514862,51523332,51537352,51645541,51664465,51692602,51750300,51788805,51846665,51851722,51936077,51971005,51980772,52022412,52038658,52095287,52098233,52100343,52127982,52137676,52143991,52153588,52172471,52175721,52241107,52268202,52288027,52306255,52324512,52329084,52333556,52338027,52341611,52385326,52413499,52454084,52464631,52466191,52467937,52517618,52524114,52560553,52607832,52615771,52671874,52751945,52753839,52791021,52809388,52829505,52879125,52900023,52941625,52942822,52962433,52970381,52975797,52980017,52988925,53062115,53142133,53162961,53175054,53216022,53227287,53312361,53354155,53420325,53456077,53474179,53530646,53540698,53568218,53569543,53580299,53587489,53634984,53644456,53692842,53708081,53803910,53806369,53830302,53852343,53927692,53986971,53993132,54033878,54117000,54129165,54178741,54269031,54303414,54323332,54355276,54365760,54384445,54409153,54491356,54615947,54618631,54808259,54886614,54892387,54901809,54918427,54975729,54996120,55005854,55008623,55010830,55053845,55063368,55069962,55110864,55117356,55165291,55327050,55352817,55475988,55528673,55553167,55553620,55601087,55652916,55682960,55688314,55708604,55756492,55788001,55792385,55820395,55843569,55844698,55845564,55855047,55865385,55868868,55879567,55884358,55944669,55957419,55981574,55988793,56169081,56341879,56378053,56403974));",
        conn, parse_dates={"CreationDate": "%Y-%m-%d %H:%M:%S"})

    return df_questions, df_answers, df_comments, df_edits
Clone this wiki locally