Ghust

Thanks I have documented the process, so it's fairly trivial to reapply the workaround should an update remove it

Hi @Marc just FYI, even after updating to the most recent release I still had to recreate this new index. My MYSQL slow query log was instantly exploding again. I also notice a really funky query there, which pretty is pretty slow consistently. Could you forward this to R&D? Or is this simply the way it is? 2024-11-19 08:25:24.445569 forumrsca[forumrsca] @ [172.19.0.8] 00:00:08.958842 00:00:00.000258 11776 11776 forum 00 1 /*forum::forumname::IPS\\Content\\_Item::_comments:2166*/ SELECT core_reputation_index.type_id, core_reputation_index.member_id, core_reputation_index.reaction FROM `core_reputation_index` WHERE core_reputation_index.rep_class='IPS\\\\forums\\\\Topic\\\\Post' AND core_reputation_index.type='pid' AND ( core_reputation_index.type_id IN(2409050,2409306,2411084,2411085,2411116,2431571,2440289,2472113,2483384,2483389,2483395,2486692,2493483,2493695,2493698,2493744,2493758,2493759,2493763,2493765,2493961,2494767,2494775,2494841,2494881,2494947,2494956,2495018,2495179,2495321,2495664,2495677,2495814,2495842,2496040,2496050,2496053,2496092,2496100,2496103,2496159,2496184,2496186,2496191,2496198,2496199,2496206,2496224,2496273,2496291,2496297,2496616,2496633,2496695,2496831,2497022,2497195,2497793,2497801,2497804,2497806,2497809,2497814,2497816,2497818,2497819,2497820,2497824,2497825,2497826,2497829,2497830,2497831,2497832,2497834,2497836,2497838,2497839,2497840,2497841,2497844,2497848,2497849,2497855,2497856,2497861,2497862,2497865,2497867,2497872,2497879,2497882,2497888,2497894,2497898,2497917,2497932,2497935,2497940,2497944,2497946,2497962,2497970,2497971,2497975,2497976,2497977,2497981,2497985,2497996,2498017,2498024,2498025,2498026,2498027,2498029,2498056,2498059,2498062,2498063,2498067,2498070,2498079,2498090,2498098,2498099,2498122,2498123,2498147,2498155,2498158,2498179,2498199,2498210,2498221,2498224,2498229,2498234,2498242,2498249,2498251,2498264,2498267,2498303,2498349,2498781,2498853,2498861,2499137,2499352,2499404,2499428,2499433,2499486,2499510,2499512,2499612,2499844,2500112,2500121,2500131,2500170,2500389,2500393,2500399,2500401,2500484,2500811,2500837,2500847,2500848,2500858,2500942,2500976,2501003,2501031,2501039,2501088,2501104,2501130,2501226,2501305,2501306,2501356,2501440,2501459,2501699,2501844,2501950,2501962,2501963,2502003,2502019,2502021,2502037,2502048,2502062,2502065,2502070,2502076,2502083,2502099,2502120,2502129,2502150,2502158,2502192,2502490,2502598,2502606,2502784,2502832,2502848,2502866,2503148,2503312,2503346,2503358,2503359,2503360,2503361,2503368,2503375,2503383,2503386,2503432,2503468,2503469,2503504,2503505,2503564,2503572,2503594,2503718,2503824,2503847,2503877,2503880,2503894,2503935,2503974,2503985,2503992,2504000,2504005,2504006,2504022,2504052,2504121,2504176,2504178,2504195,2504205,2504206,2504211,2504322,2504577,2504592,2504712,2504749,2504780,2504792,2504828,2505401,2505408,2505559,2505644,2505650,2505666,2505672,2505674,2505677,2505688,2505699,2505700,2505703,2505721,2505730,2505739,2505743,2505747,2505748,2505767,2505811,2505818,2505834,2505933,2505970,2506093,2506099,2506146,2506154,2506270,2506303,2506327,2506529,2506544,2506553,2506557,2506559,2506563,2506575,2506578,2506579,2506620,2506628,2506656,2506664,2506718,2506732,2507540,2507639,2507714,2507751,2507777,2507898,2507925,2507967,2508739,2508756,2508771,2508855,2508875,2508891,2508911,2509007,2509047,2509052,2509055,2509061,2509065,2509112,2509292,2510118,2510213,2510221,2510276,2510304,2510349,2510402,2510527,2511149,2511154,2511156,2511157,2511174,2511204,2511221,2511250,2511300,2511325,2511359,2511383,2511385,2511388,2511402,2511413,2511583,2511616,2511638,2511667,2511669,2511681,2511721,2511729,2511734,2511736,2511740,2511741,2511752,2511754,2511764,2511794,2511839,2511868,2511910,2511922,2511925,2511934,2511940,2511943,2511949,2511950,2511951,2511952,2511954,2511959,2511968,2511971,2511990,2512015,2512038,2512068,2512070,2512097,2512105,2512114,2512123,2512128,2512141,2512142,2512154,2512173,2512183,2512226,2512230,2512238,2512253,2512272,2512273,2512305,2512313,2512323,2512335,2512343,2512344,2512347,2512351,2512362,2512476,2512480,2512481,2512489,2512537,2512540,2512612,2512613,2512630,2512668,2512679,2512726,2512727,2512730,2512736,2512737,2512747,2512769,2512771,2512789,2512792,2512864,2512915,2512918,2513012,2513013,2513026,2513036,2513043,2513307,2513369,2513495,2513666,2513668,2513800,2513810,2513812,2513821,2513826,2513865,2513866,2513885,2513886,2513887,2513890,2513903,2513913,2513914,2513919,2513922,2513923,2513944,2513958,2513977,2514093,2514103,2514309,2514327,2514337,2514459,2514460,2514464,2514502,2514506,2514518,2514520,2514541,2514543,2514547,2514562,2514632,2514633,2514649,2514657,2514756,2514834,2514844,2514854,2514908,2514916,2514922,2514931,2514950,2514974,2514994,2515012,2515015,2515019,2515031,2515050,2515054,2515062,2515065,2515072,2515075,2515090,2515124,2515139,2515365,2515391,2515443,2515452,2515456,2515459,2515483,2515494,2515496,2515523,2515533,2515540,2515545,2515574,2515615,2515652,2515668,2515676,2515680,2515694,2515697,2515706,2515726,2515769,2515774,2515781,2515820,2515822,2515844,2515852,2515857,2515860,2515861,2515866,2515867,2515868,2515869,2515881,2515999,2516004,2516005,2516008,2516010,2516013,2516015,2516019,2516020,2516022,2516032,2516061,2516374,2516384,2516387,2516393,2516400,2516413,2517121,2517123,2517181,2517187,2517261,2517331,2517378,2517389,2517402,2517404,2517418,2517492,2517564,2517641,2518028,2518039,2518048,2518051,2518063,2518067,2518195,2518204,2518211,2518218,2518542,2518623,2518627,2518634,2518887,2518924,2518947,2518969,2518972,2518976,2519009,2519028,2519053,2519076,2519367,2519398,2519999,2520006,2520174,2520179,2520193,2520241,2520243,2520271,2520317,2520318,2520320,2520326,2520338,2520416,2520541,2520551,2520557,2520559,2520560,2520589,2520593,2520594,2520620,2520621,2520623,2520638,2520660,2520681,2520704,2520712,2520758,2520815,2520816,2520838,2520891,2520958,2520974,2520978,2520990,2521070,2521075,2521081,2521093,2521117,2521125,2521155,2521157,2521160,2521170,2521397,2521412,2521418,2521675,2521678,2521712,2521743,2521767,2521795,2521805,2521812,2521813,2521817,2521833,2521860,2521939,2521999,2522007,2522012,2522500,2522589,2522602,2522698,2522803,2522851,2522857,2522885,2522901,2522975,2523031,2523089,2523141,2523329,2523404,2523535,2523617,2523652,2523663,2523665,2523668,2523671,2523683,2523687,2523724,2523725,2523736,2523739,2523818,2523828,2524050,2524108,2524114,2524116,2524121,2524122,2524123,2524135,2524180,2524201,2524211,2524237,2524241,2524247,2524348,2524350,2524371,2524374,2524383,2524437,2524470,2524655,2524972,2524997,2525041,2525066,2525112,2525122,2525132,2525147,2525201,2525426,2525469,2525476,2525481,2525493,2525543,2525582,2525623,2525624,2525626,2525632,2525633,2525635,2525642,2525656,2525669,2525718,2525738,2525859,2525890,2525953,2526178,2526204,2526210,2526213,2526221,2526222,2526229,2526230,2526236,2526245,2526249,2526278,2526309,2526327,2526414,2526426,2526441,2526446,2526464,2526525,2526626,2526640,2526647,2526660,2526663,2526673,2526711,2526720,2526726,2526730,2526732,2526735,2526744,2526747,2526749,2526752,2526759,2526783,2526801,2526812,2526856,2526872,2526878,2526890,2526894,2526930,2526978,2527000,2527023,2527025,2527061,2527064,2527072,2527089,2527115,2527132,2527133,2527138,2527160,2527228,2527240,2527244,2527247,2527248,2527260,2527264,2527269,2527310,2527373,2527383,2527423,2527433,2527437,2527441,2527445,2527475,2527502,2527575,2527587,2527599,2527625,2527667,2527681,2527690,2527697,2527726,2527790,2527793,2527805,2528146,2528156,2528185,2528215,2528346,2528377,2528444,2528921,2528953,2528955,2528959,2528961,2528962,2528964,2528966,2528967,2528969,2528970,2528972,2528973,2528975,2528976,2528983,2528988,2528990,2528991,2528992,2528993,2528994,2528995,2528999,2529003,2529006,2529007,2529009,2529010,2529012,2529016,2529018,2529019,2529023,2529027,2529028,2529029,2529031,2529032,2529033,2529039,2529048,2529050,2529053,2529055,2529058,2529064,2529065,2529066,2529073,2529074,2529077,2529081,2529082,2529084,2529090,2529094,2529095,2529097,2529122,2529127,2529134,2529138,2529140,2529145,2529148,2529149,2529163,2529165,2529167,2529175,2529179,2529180,2529190,2529196,2529207,2529210,2529529,2529615,2529618,2529698,2529707,2529708,2529712,2529716,2529927,2530060,2530093,2530115,2530123,2530138,2530174,2530179,2530192,2530197,2530206,2530211,2530213,2530223,2530242,2530247,2530250,2530253,2530254,2530265,2530266,2530268,2530280,2530286,2530287,2530305,2530312,2530319,2530349,2530485,2530504,2530660,2530827,2530859,2530861,2530868,2530876,2530894,2530898,2530899,2530978,2530992,2530997,2531003,2531006,2531017,2531029,2531048,2531057,2531857,2531874,2532048,2532050,2532084,2532101,2532107,2532109,2532111,2532114,2532126,2532136,2532151,2532154,2532158,2532167,2532173,2532275,2532283,2532571,2532817,2532910,2533165,2533169,2533224,2533862,2534415,2535858,2536094,2536099,2536101,2536111,2536112,2536188,2536204,2536244,2536263,2536267,2536292,2536480,2536491,2536584,2536617,2536674,2536766,2536769,2536772,2536790,2536793,2536795,2536797,2536802,2536804,2536805,2536807,2536809,2536817,2536823,2536824,2536825,2536831,2536898,2536907,2536920,2536963,2536982,2536984,2537001,2537015,2537032,2537034,2537058,2537075,2537212,2537213,2537346,2537357,2537391,2537399,2537434,2537547,2539557,2539584,2539593,2539596,2539614,2540674,2540850,2541183,2541343,2541346,2541441,2541446,2541955,2541957,2541982,2542092,2542237,2543034,2547048,2547073,2547075,2547077,2547078,2547086,2547090,2547132,2547372,2547457,2547466,2547469,2547475,2547479,2547489,2547501,2547502,2547508,2547511,2547512,2547521,2547593,2547599,2547608,2547610,2547857,2548150,2548156,2548187,2548339,2548341,2548350,2548362,2548369,2548372,2548373,2548375,2548379,2548383,2548390,2548394,2548407,2548451,2548465,2548468,2548472,2548474,2548496,2548572,2548608,2548610,2548819,2548840,2548950,2548959,2550848,2550899,2552906,2552945,2552952,2553101,2555162,2555219,2556302,2556311,2556375,2556442,2556702,2556749,2556754,2556756,2556758,2556795,2556810,2556813,2556820,2556833,2556846,2556847,2556899,2556928,2557015,2557148,2557348,2557415,2557556,2557558,2557597,2557604,2557605,2557610,2557626,2557631,2557644,2557667,2557670,2557702,2559611,2559644,2559646,2559652,2559725,2559726,2559827,2559831,2559837,2559840,2559852,2559854,2559891,2559893,2559894,2559977,2560493,2560500,2560567,2560572,2560577,2562426,2562427,2562482,2562504,2562508,2562706,2563091,2563221,2563361,2563364,2563375,2563380,2563381,2563389,2563391,2563392,2563401,2563405,2563411,2563413,2563425,2563430,2563431,2563555,2563580,2563614,2563677,2563692,2563698,2563716,2563960,2564304,2564335,2564561,2564572,2564597,2564603,2564621,2564689,2564703,2564963,2565065,2565080,2565126,2565206,2565225,2565245,2565247,2565248,2565263,2565272,2565282,2565284,2565300,2565308,2565312,2565383,2565433,2565440,2565501,2565554,2565555,2565659,2565667,2565673,2565694,2565765,2565776,2565804,2565814,2565821,2565823,2565835,2565837,2565886,2565890,2565910,2565912,2565979,2565987,2565994,2565996,2566005,2566017,2566019,2566031,2566036,2566039,2566040,2566053,2566062,2566069,2566075,2566286,2566370,2566454,2567502,2567598,2567686,2567752,2567762,2567940,2567945,2567979,2568047,2568129,2568397,2568539,2568555,2568560,2568689,2568699,2568701,2568706,2568711,2568715,2568725,2568741,2568745,2568752,2568753,2568757,2568761,2568764,2568765,2568768,2568779,2568795,2568798,2568810,2568821,2568824,2568831,2568832,2568840,2568848,2568854,2568855,2568858,2568867,2568871,2568886,2568893,2568910,2568912,2568916,2568921,2568933,2568942,2568944,2568953,2568957,2568958,2568963,2568966,2568967,2568970,2568990,2569007,2569025,2569062,2569085,2569088,2569132,2569150,2569184,2569297,2569434,2569472,2569475,2569490,2569492,2569526,2569531,2569708,2571248,2571254,2571267,2571306,2571308,2571312,2571313,2571317,2571332,2571350,2571387,2571426,2571432,2571433,2571435,2571468,2571474,2571486,2571493,2571503,2571509,2571803,2571817,2571837,2571848,2571865,2571867,2571870,2571872,2571880,2571924,2571998,2572099,2572134,2572138,2572157,2572158,2572169,2572171,2572178,2572190,2572194,2572204,2572246,2572248,2572293,2572315,2572323,2572327,2572337,2572340,2572342,2572343,2572344,2572345,2572346,2572347,2572351,2572356,2572360,2572362,2572365,2572403,2572424,2572431,2572439,2572492,2572518,2572530,2572533,2572534,2572551,2572555,2572565,2572570,2572571,2572580,2572581,2572658,2572851,2572886,2572913,2572950,2572959,2572997,2573046,2573157,2573172,2573178,2573180,2573185,2573192,2573394,2573445,2573472,2573501,2573622,2573650,2573651,2573653,2573655,2573664,2573677,2573680,2573686,2573694,2573695,2573706,2573711,2573712,2573717,2573719,2573723,2573727,2573728,2573730,2573731,2573733,2573739,2573747,2573748,2573761,2573764,2573767,2573772,2573777,2573778,2573779,2573783,2573785,2573790,2573800,2573802,2573804,2573809,2573836,2573841,2573845,2573859,2573869,2573874,2573881,2573886,2573888,2573927,2573930,2573933,2573944,2573951,2573955,2573959,2573960,2573963,2573965,2573966,2573970,2573973,2573978,2573983,2573996,2573997,2574000,2574001,2574003,2574032,2574033,2574113,2574139,2574140,2574142,2574144,2574149,2574150,2574152,2574158,2574160,2574165,2574174,2574179,2574183,2574185,2574186,2574189,2574219,2574278,2574364,2574426,2574428,2574430,2574431,2574433,2574436,2574441,2574461,2574477,2574488,2574489,2574492,2574504,2574506,2574508,2574516,2574521,2574525,2574526,2574538,2574539,2574548,2574549,2574553,2574564,2574569,2574579,2574584,2574589,2574605,2574608,2574617,2574623,2574644,2574645,2575000,2575042,2575073,2575120,2575736,2575892,2575904,2575913,2575926,2575935,2575942,2575943,2575982,2575999,2576010,2576013,2576014,2576168,2576262,2576294,2576300,2576321,2576324,2576344,2576407,2576422,2576426,2576435,2576453,2576470,2576478,2576495,2576500,2576503,2576509,2576511,2576514,2576516,2576534,2576540,2576542,2576548,2576553,2576557,2576558,2576567,2576572,2576573,2576575,2576577,2576579,2576582,2576585,2576589,2576593,2576599,2576602,2576607,2576610,2576614,2576615,2576622,2576627,2576630,2576653,2576675,2576738,2576742,2576770,2576818,2576873,2576889,2576893,2576897,2576898,2576911,2576913,2577007,2577028,2577082,2577105,2577107,2577145,2577146,2577155,2577166,2577176,2577185,2577206,2577214,2577225,2577233,2577352,2577363,2577364,2577369,2577372,2577379,2577383,2577397,2577402,2577404,2577424,2577768,2578048,2578052,2578058,2578069,2578084,2578113,2578245,2578615,2578657,2579386,2579422,2579425,2579431,2579432,2579435,2579451,2579453,2579459,2579533,2579539,2579557,2579572,2579645,2579651,2579779,2579786,2579791,2580001,2580016,2580026,2580052,2580150,2580154,2580163,2580191,2580371,2580376,2580391,2580398,2580416,2580419,2580465,2580549,2580618,2580625,2580638,2580642,2580652,2580663,2580672,2580831,2580834,2580835,2580837,2580841,2580847,2580879,2580900,2580924,2580935,2580937,2580940,2580965,2580976,2580979,2580992,2581010,2581070,2581076,2581082,2581089,2581093,2581108,2581119,2581120,2581122,2581123,2581124,2581125,2581126,2581137,2581144,2581640,2581682,2581758,2581775,2581787,2581820,2581825,2581828,2581830,2581831,2581844,2581846,2581848,2581857,2581866,2581884,2581886,2581888,2581904,2581910,2581911,2581930,2581933,2581940,2581948,2581950,2581955,2581967,2581970,2581973,2581982,2581985,2581992,2581995,2582000,2582034,2582052,2582053,2582058,2582067,2582092,2582099,2582106,2582110,2582113,2582116,2582119,2582120,2582121,2582125,2582141,2582151,2582156,2582159,2582164,2582183,2582218,2582232,2582252,2582255,2582267,2582272,2582277,2582280,2582282,2582283,2582296,2582298,2582382,2582391,2582400,2582403,2582430,2582480,2582488,2582493,2582494,2582522,2582524,2582560,2582654,2582658,2582736,2582787,2582788,2582858,2582935,2583022,2583109,2583155,2583163,2583692,2583967,2583971,2584336,2584657,2584719,2584722,2584727,2584731,2584749,2584758,2584767,2584779,2584784,2584797,2584798,2584811,2584816,2584821,2584822,2584824,2584827,2584864,2584890,2584926,2584973,2584994,2585005,2585014,2585021,2585027,2585037,2585106,2585109,2585259,2585270,2585271,2585291,2585299,2585304,2585344,2585368,2585370,2585378,2585387,2585396,2585398,2585465,2585480,2585483,2585633,2585641,2585679,2585680,2585686,2585688,2585691,2585702,2585711,2585728,2585734,2585750,2585826,2585827,2585835,2585858,2585872,2585881,2585885,2585889,2585897,2585904,2585929,2585937,2585941,2585962,2586025,2586027,2586043,2586084,2586207,2586325,2586331,2586334,2586356,2586368,2586381,2586500,2586518,2586523,2586549,2586551,2586553,2586592,2586653,2586798,2587290,2587407,2587435,2587437,2587459,2587505,2587507,2587515,2587539,2587565,2587568,2587578,2587626,2587697,2587702,2587740,2587747,2587820,2587829,2587835,2587851,2587894,2588015,2588915,2588920,2588951,2588967,2588979,2588980,2589050,2589119,2589132,2589149,2589153,2589155,2589159,2589181,2589196,2589198,2589199,2589231,2589248,2589257,2589263,2589275,2589280,2589316,2589318,2589320,2589327,2589351,2589404,2589434,2589459,2589497,2589535,2589552,2589564,2589572,2589589,2589591,2589598,2589600,2589840,2590071,2590078,2590111,2590142,2590150,2590214,2590228,2590229,2590233,2590242,2590245,2590338,2590354,2590424,2590466,2590471,2590495,2590496,2590559,2590567,2590568,2590573,2590583,2590594,2590597,2590604,2590701,2590703,2590706,2590720,2590727,2590729,2590735,2590738,2590740,2590744,2590745,2590746,2590749,2590750,2590766,2590775,2590785,2590786,2590804,2590818,2590821,2590823,2590868,2590872,2590880,2590881,2590882,2590885,2590888,2590895,2590899,2590900,2590905,2590906,2590919,2590930,2590934,2590935,2590938,2590939,2590943,2590947,2590986,2590987,2590990,2590991,2590994,2590996,2591007,2591015,2591038,2591070,2591071,2591078,2591085,2591088,2591091,2591134,2591136,2591137,2591143,2591145,2591156,2591161,2591177,2591179,2591214,2591229,2591230,2591231,2591233,2591236,2591243,2591244,2591257,2591261,2591264,2591269,2591271,2591275,2591280,2591287,2591290,2591291,2591300,2591312,2591315,2591318,2591322,2591323,2591325,2591328,2591338,2591353,2591372,2591384,2591387,2591391,2591407,2591414,2591416,2591417,2591432,2591433,2591435,2591436,2591438,2591440,2591441,2591443,2591446,2591447,2591450,2591451,2591452,2591454,2591457,2591458,2591462,2591466,2591467,2591468,2591469,2591504,2591505,2591506,2591509,2591512,2591514,2591516,2591517,2591518,2591520,2591521,2591523,2591525,2591526,2591530,2591534,2591535,2591538,2591549,2591564,2591566,2591581,2591584,2591592,2591595,2591597,2591598,2591600,2591626,2591667,2591731,2591739,2591746,2591752,2591753,2591754,2591755,2591760,2591762,2591776,2591784,2591799,2591805,2591806,2591808,2591811,2591813,2591814,2591836,2591838,2591841,2591847,2591860,2591871,2591875,2591883,2591897,2591899,2591907,2591911,2592010,2592015,2592077,2592078,2592083,2592101,2592106,2592117,2592127,2592131,2592134,2592135,2592138,2592139,2592140,2592166,2592169,2592170,2592174,2592181,2592184,2592236,2592253,2592259,2592264,2592270,2592280,2592285,2592288,2592291,2592375,2592382,2592390,2592392,2592395,2592401,2592413,2592414,2592419,2592427,2592435,2592450,2592530,2592537,2592544,2592558,2592581,2592594,2592598,2592608,2592612,2592624,2592653,2592664,2592666,2592673,2592681,2592686,2592722,2592733,2592737,2592776,2592782,2592788,2592796,2592804,2592837,2592853,2592872,2592949,2592950,2593087,2593095,2593099,2593111,2593125,2593161,2593174,2593223,2593276,2593283,2593287,2593290,2593295,2593297,2593306,2593323,2593325,2593329,2593331,2593333,2593335,2593346,2593347,2593348,2593350,2593361,2593367,2593371,2593375,2593376,2593377,2593378,2593380,2593381,2593384,2593385,2593387,2593389,2593390,2593392,2593393,2593397,2593399,2593406,2593415,2593421,2593423,2593424,2593425,2593428,2593430,2593432,2593445,2593448,2593453,2593454,2593463,2593465,2593467,2593468,2593469,2593471,2593474,2593475,2593479,2593480,2593482,2593492,2593496,2593500,2593503,2593504,2593505,2593510,2593514,2593521,2593524,2593525,2593527,2593540,2593544,2593546,2593595,2593610,2593627,2593633,2593638,2593640,2593641,2593643,2593644,2593645,2593646,2593654,2593656,2593676,2593681,2593691,2593704,2593708,2593715,2593721,2593724,2593728,2593731,2593733,2593738,2593745,2593751,2593756,2593757,2593759,2593765,2593780,2593781,2593785,2593788,2593790,2593813,2593823,2593903,2593968,2593972,2593987,2594023,2594026,2594031,2594034,2594035,2594037,2594040,2594052,2594092,2594197,2594204,2594252,2594267,2594273,2594274,2594281,2594288,2594292,2594304,2594309,2594318,2594319,2594323,2594389,2594395,2594423,2594451,2594454,2594466,2594474,2594506,2594509,2594576,2594597,2594613,2594645,2594679,2594686,2594822,2594828,2594843,2594861,2594901,2594925,2594937,2594940,2594956,2594980,2595007,2595010,2595018,2595027,2595034,2595039,2595050,2595059,2595075,2595107,2595139,2595204,2595209,2595228,2595233,2595249,2596028,2596357,2596366,2596635,2596650,2596657,2596663,2596731,2596771,2596775,2596779,2596803,2596804,2596809,2596816,2596865,2596878,2596928,2597107,2597119,2597128,2597132,2597143,2597170,2597172,2597173,2597204,2597209,2597266,2597427,2599178,2599185,2599186,2599191,2599683,2599732,2600188,2601004,2601005,2601008,2601009,2601016,2601026,2601027,2601028,2601037,2601042,2601049,2601050,2601052,2601064,2601065,2601066,2601067,2601068,2601077,2601092,2601093,2601143,2601165,2601166,2601239,2601245,2601250,2601252,2601265,2601271,2601280,2601318,2601421,2601442,2601457,2601721,2601738,2601744,2601756,2601758,2601760,2601765,2601788,2601818,2601856,2601867,2601907,2601990,2602011,2602035,2602038,2602047,2602058,2602067,2602125,2602169,2602241,2602251,2602252,2602254,2602255,2602343,2602458,2602561,2602700,2602737,2602786,2602793,2602796,2602797,2602809,2602853,2603065,2603093,2603108,2603237,2603316,2603318,2603365,2603404,2604049,2604334,2604430,2604435,2604436,2604437,2604438,2604440,2604458,2604466,2604473,2604478,2604624,2604642,2604697,2623074,2623114,2626772,2630712,2631229,2631638,2636291,2636743,2636746,2637007,2637143,2637188,2637198,2637967,2656157,2656161,2656167,2656210,2657310,2657612,2657654,2657791,2657870,2657989,2657994,2658306,2658561,2660959,2660998,2661079,2661085,2661430,2665046,2665073,2666310,2666341,2667626,2667648,2667764,2668299,2668307,2668322,2669072,2669694,2669698,2669761,2669887,2669902,2670097,2670138,2670148,2670269,2670345,2670380,2670414,2670601,2671389,2671398,2671451,2672372,2672868,2672887,2672899,2672903,2672918,2672930,2672931,2672933,2672935,2673024,2673125,2673613,2674220,2674253,2674379,2674446,2674563,2674701,2677094,2677502,2677749,2677866,2677875,2677876,2678213,2678555,2681744,2682264,2682332,2690233,2692512,2693270,2693391,2693402,2695380,2695448,2695587,2696486,2696494,2696549,2697650,2697664,2697673,2697679,2697877,2697888,2697892,2697916,2697959,2697964,2698135,2698141,2698253,2698379,2698796,2698802,2698803,2698804,2698825,2698941,2698945,2698991,2699069,2699074,2699156,2699160,2699162,2699163,2699187,2699992,2700318,2700333,2700337,2700402,2700405,2700418,2700967,2700971,2701008,2701019,2701239,2701311,2702339,2702917,2702921,2702923,2702943,2702991,2703023,2703024,2703058,2703092,2703097,2703120,2703127,2703129,2703189,2703203,2703206,2703208,2703214,2703303,2703318,2703320,2703331,2703332,2703344,2703372,2703386,2703388,2703453,2703494,2703511,2703528,2703537,2703542,2703543,2703557,2703756,2703775,2703780,2703793,2705228,2705410,2705414,2705468,2705475,2705494,2705505,2705511,2705526,2705544,2705616,2705669,2705725,2705731,2705756,2705878,2705891,2706131,2706181,2706189,2706267,2706361,2707086,2707402,2707407,2707551,2707553,2707558,2707570,2707575,2707577,2707584,2707615,2707624,2707628,2707630,2707631,2707659,2707661,2707728,2707746,2707747,2707899,2707940,2708005,2708077,2708284,2708375,2708393,2709133,2709374,2709378,2709386,2709388,2709389,2709397,2709399,2709401,2709404,2709408,2709411,2709419,2709420,2709421,2709436,2709438,2709448,2709462,2709516,2709517,2709519,2709523,2709525,2709526,2709562,2709563,2709601,2709626,2709635,2709649,2709653,2709656,2709663,2709696,2709701,2709718,2709736,2709751,2709902,2709913,2710271,2710576,2710890,2710897,2711288,2711591,2711633,2711674,2712203,2713422,2713542,2713704,2713796,2713811,2713813,2713814,2713818,2713827,2713829,2713831,2713851,2713876,2713886,2713888,2713889,2713894,2713928,2713929,2713933,2713971,2713974,2713982,2713987,2714064,2714086,2714100,2714155,2714199,2714209,2714212,2714236,2714928,2714970,2715077,2715159,2715165,2715253,2715270,2715354,2715612,2715621,2715664,2715680,2715687,2715688,2715898,2715904,2715912,2715928,2715933,2715935,2715937,2715940,2715944,2715952,2716039,2716052,2716096,2716107,2716222,2716223,2716224,2716225,2716227,2716228,2716229,2716230,2716232,2716234,2716236,2716238,2716240,2716243,2716249,2716255,2716256,2716258,2716259,2716260,2716262,2716263,2716267,2716270,2716272,2716277,2716278,2716279,2716281,2716286,2716287,2716290,2716295,2716296,2716298,2716301,2716302,2716303,2716304,2716306,2716307,2716310,2716311,2716312,2716313,2716323,2716336,2716337,2716348,2716355,2716375,2716376,2716378,2716417,2716438,2716450,2716461,2716462,2716475,2716488,2716492,2716495,2716502,2716517,2716522,2716526,2716534,2716537,2716538,2716562,2716582,2716584,2716588,2716592,2716593,2716595,2716616,2716700,2716703,2716723,2716747,2716756,2716793,2716860,2716870,2716872,2716874,2716875,2716877,2716879,2716880,2716884,2716912,2716913,2716927,2716957,2717041,2717045,2717052,2717063,2717157,2717162,2717184,2717187,2717205,2717206,2717289,2717291,2717336,2717405,2717417,2717418,2717419,2717450,2717490,2717514,2717617,2717662,2717676,2717688,2717694,2717704,2717717,2717802,2717823,2717859,2717873,2718030,2718198,2718235,2718239,2718246,2718339,2718357,2719500,2719501,2719504,2719508,2719775,2719827,2719866,2719906,2719913,2720054,2720056,2720063,2720066,2720188,2720194,2720195,2720201,2720204,2720222,2720228,2720233,2720239,2720256,2720261,2720353,2720459,2720462,2720607,2720673,2721077,2721086,2721108,2721126,2721284,2721297,2721351,2721357,2721374,2721393,2721468,2721606,2721672,2721674,2721829,2721847,2721855,2721871,2721905,2721912,2721918,2721919,2721925,2721927,2721928,2721929,2721931,2721934,2721935,2721943,2721945,2721946,2721947,2721948,2721951,2721952,2721953,2721954,2721957,2721964,2721970,2721974,2721978,2721980,2721989,2721992,2721995,2721997,2722049,2722052,2722053,2722058,2722071,2722079,2722095,2722103,2722104,2722110,2722112,2722113,2722122,2722123,2722125,2722146,2722179,2722190,2722196,2722199,2722214,2722218,2722225,2722244,2722646,2722659,2722663,2722707,2722770,2722777,2722845,2723079,2723092,2723123,2723286,2723356,2723367,2723388,2723437,2723497,2723528,2723537,2723545,2723627,2723635,2723638,2723651,2723666,2723693,2723697,2723705,2723710,2723730,2723758,2723804,2723816,2723827,2723828,2723829,2723830,2723831,2723865,2723869,2723896,2723908,2723918,2723920,2723966,2724021,2724023,2724188,2724195,2724201,2724205,2724215,2724218,2724246,2724247,2724257,2724279,2724399,2724410,2724430,2724432,2724438,2724449,2724453,2724455,2724457,2724460,2724461,2724474,2724477,2724478,2724480,2724481,2724485,2724487,2724490,2724491,2724497,2724501,2724503,2724504,2724532,2724535,2724542,2724543,2724548,2724549,2724551,2724568,2724576,2724613,2724614,2724616,2724620,2724626,2724629,2724642,2724662,2724668,2724670,2724675,2724679,2724680,2724682,2724715,2724718,2724738,2724749,2724754,2724760,2724772,2724774,2724776,2724782,2724783,2724785,2724786,2724787,2724788,2724790,2724795,2724799,2724808,2724814,2724816,2724823,2724825,2724826,2724828,2724829,2724831,2724832,2724835,2724838,2724841,2724847,2724849,2724879,2724896,2724898,2724915,2724927,2724931,2724933,2724935,2724947,2724965,2725078,2725122,2725123,2725127,2725167,2725171,2725256,2725265,2725267,2725270,2725328,2725418,2725433,2725687,2725694,2725760,2725761,2725767,2725769,2725772,2725778,2725779,2725826,2725832,2725865,2725869,2725916,2726027,2726032,2726068,2726100,2726247,2726813,2726820,2726863,2726873,2726874,2726956,2727002,2727005,2727009,2727019,2727022,2727168,2727172,2727197,2727198,2727199,2727223,2727224,2727230,2727235,2727255,2727302,2727323,2727329,2727333,2727348,2727394,2727404,2727405,2727419,2727435,2727436,2727442,2727463,2727464,2727498,2727499,2727541,2727571,2727575,2727596,2727600,2727601,2727602,2727603,2727607,2727608,2727623,2727628,2727629,2727630,2727632,2727633,2727634,2727640,2727641,2727643,2727653,2727715,2727772,2727782,2727798,2727817,2727821,2727839,2727841,2727844,2727849,2727871,2727875,2727883,2727889,2727919,2727926,2727928,2727945,2727946,2727947,2727950,2727974,2728014,2728028,2728042,2728113,2728119,2728121,2728122,2728234,2728269,2728435,2728437,2728443,2728481,2728482,2728483,2728489,2728506,2728516,2728576,2728586,2728612,2728639,2728650,2728689,2728702,2728737,2728795,2728796,2728814,2728817,2728847,2728850,2728855,2728856,2728858,2728867,2728871,2728875,2728880,2728938,2728945,2728952,2728961,2729148,2729225,2729231,2729238,2729243,2729246,2729251,2729252,2729269,2729271,2729278,2729283,2729329,2729344,2729352,2729409,2729429,2729434,2729542,2729552,2729556,2729606,2729621,2729623,2729643,2729671,2729681,2729683,2729767,2729991,2730002,2730014,2730025,2730047,2730074,2730084,2730233,2730234,2730235,2730243,2730254,2730256,2730261,2730263,2730275,2730279,2730281,2730283,2730286,2730289,2730291,2730350,2730357,2730364,2730389,2730399,2730421,2730430,2730480,2730493,2730735,2730742,2730745,2730747,2730749,2730760,2730764,2730768,2730769,2730779,2730781,2730784,2730791,2730792,2730800,2730806,2730817,2730818,2730820,2730824,2730829,2730830,2730831,2730832,2730838,2730843,2730844,2730847,2730848,2730851,2730854,2730862,2730864,2730868,2730871,2730872,2730873,2730874,2730876,2730878,2730879,2730880,2730882,2730887,2730888,2730893,2730894,2730899,2730901,2730902,2730903,2730904,2730905,2730906,2730909,2730910,2730911,2730913,2730914,2730915,2730916,2730918,2730921,2730925,2730935,2730936,2730940,2730943,2730945,2730946,2730951,2730954,2730962,2730979,2731036,2731074,2731075,2731087,2731099,2731108,2731110,2731112,2731113,2731114,2731118,2731121,2731129,2731150,2731161,2731165,2731169,2731177,2731179,2731183,2731185,2731187,2731189,2731190,2731195,2731197,2731200,2731203,2731213,2731221,2731225,2731248,2731255,2731376,2731382,2731390,2731456,2731458,2731487,2731489,2731493,2731494,2731495,2731496,2731497,2731503,2731531,2731532,2731533,2731536,2731578,2731580,2731584,2731585,2731587,2731588,2731592,2731595,2731602,2731605,2731606,2731607,2731611,2731614,2731620,2731623,2731625,2731637,2731642,2731653,2731655,2731688,2731703,2731713,2731714,2731733,2731736,2731739,2731802,2731810,2731833,2731859,2731880,2731890,2731931,2731939,2731960,2731969,2731970,2731973,2732579,2732627,2732640,2732660,2732681,2732725,2732742,2732763,2732774,2732801,2732843,2732846,2732847,2732848,2732881,2732886,2732903,2732905,2732915,2732937,2732972,2732974,2732982,2732985,2732995,2732998,2733011,2733015,2733023,2733024,2733047,2733050,2733053,2733067,2733077,2733114,2733139,2733140,2733151,2733162,2733187,2733200,2733205,2733231,2733237,2733263,2733283,2733284,2733294,2733319,2733331,2733335,2733338,2733361,2733368,2733371,2733372,2733373,2733376,2733377,2733382,2733387,2733396,2733398,2733400,2733404,2733405,2733438,2733443,2733466,2733467,2733511,2733561,2733565,2733569,2733595,2733597,2733600,2733617,2733663,2733678,2733720,2733721,2733723,2733725,2733726,2733728,2733732,2733738,2733747,2733750,2733752,2733764,2733768,2733771,2733781,2733805,2733816,2733818,2733827,2733848,2733866,2733871,2733879,2733898,2733910,2733916,2733921,2733929,2733931,2733955,2733958,2733959,2733962,2733963,2733964,2733965,2733974,2733977,2733979,2733980,2733998,2734000,2734006,2734008,2734011,2734018,2734020,2734021,2734022,2734026,2734027,2734028,2734029,2734030,2734031,2734038,2734040,2734041,2734043,2734044,2734045,2734046,2734050,2734086,2734090,2734092,2734098,2734099,2734101,2734111,2734116,2734119,2734120,2734121,2734122,2734124,2734126,2734132,2734135,2734141,2734146,2734154,2734155,2734156,2734159,2734174,2734176,2734184,2734198,2734206,2734208,2734211,2734214,2734216,2734219,2734224,2734234,2734235,2734236,2734239,2734241,2734242,2734243,2734245,2734248,2734249,2734252,2734253,2734257,2734260,2734265,2734289,2734290,2734307,2734310,2734312,2734313,2734321,2734326,2734328,2734330,2734333,2734358,2734395,2734421,2734423,2734424,2734429,2734440,2734445,2734456,2734457,2734458,2734462,2734463,2734465,2734471,2734473,2734475,2734479,2734481,2734482,2734490,2734492,2734493,2734494,2734495,2734496,2734498,2734499,2734504,2734556,2734558,2734672,2734704,2734705,2734718,2734723,2734724,2734726,2734727,2734732,2734739,2734748,2734749,2734752,2734759,2734762,2734764,2734777,2734778,2734781,2734783,2734791,2734805,2734814,2734826,2734827,2734828,2734829,2734832,2734833,2734834,2734836,2734843,2734844,2734848,2734849,2734852,2734854,2734855,2734856,2734860,2734861,2734864,2734866,2734868,2734869,2734870,2734871,2734873,2734875,2734876,2734877,2734882,2734883,2734885,2734886,2734889,2734890,2734891,2734893,2734894,2734900,2734905,2734906,2734907,2734909,2734910,2734918,2734919,2734931,2734933,2734947,2734948,2734950,2734952,2734954,2734956,2734958,2734959,2734960,2734961,2734964,2734965,2734966,2734974,2734975,2734977,2734978,2734980,2734982,2734983,2734988,2734992,2734994,2734995,2735001,2735004,2735005,2735014,2735024,2735027,2735028,2735038,2735041,2735043,2735044,2735046,2735050,2735051,2735052,2735053,2735055,2735056,2735059,2735060,2735062,2735065,2735068,2735070,2735073,2735074,2735075,2735079,2735082,2735083,2735085,2735088,2735095,2735099,2735101,2735104,2735111,2735112,2735113,2735114,2735117,2735118,2735120,2735123,2735124,2735127,2735130,2735132,2735135,2735138,2735143,2735150,2735153,2735154,2735155,2735156,2735157,2735158,2735162,2735165,2735168,2735169,2735171,2735172,2735175,2735177,2735185,2735186,2735192,2735197,2735198,2735199,2735200,2735202,2735204,2735206,2735208,2735212,2735215,2735216,2735217,2735218,2735219,2735220,2735221,2735222,2735223,2735226,2735227,2735231,2735232,2735234,2735236,2735238,2735239,2735240,2735241,2735243,2735246,2735250,2735252,2735254,2735256,2735259,2735261,2735263,2735264,2735265,2735266,2735268,2735269,2735270,2735274,2735277,2735278,2735281,2735282,2735283,2735284,2735285,2735289,2735295,2735297,2735300,2735311,2735312,2735316,2735317,2735318,2735320,2735322,2735324,2735326,2735328,2735331,2735334,2735335,2735338,2735343,2735344,2735347,2735351,2735352,2735353,2735354,2735355,2735356,2735357,2735359,2735361,2735364,2735365,2735366,2735367,2735368,2735369,2735371,2735372,2735373,2735374,2735376,2735377,2735379,2735380,2735381,2735382,2735383,2735384,2735387,2735388,2735389,2735390,2735393,2735396,2735400,2735402,2735404,2735406,2735408,2735409,2735410,2735412,2735414,2735415,2735419,2735420,2735421,2735422,2735426,2735427,2735430,2735432,2735435,2735437,2735446,2735450,2735452,2735456,2735461,2735462,2735464,2735466,2735468,2735473,2735480,2735482,2735484,2735485,2735486,2735488,2735492,2735494,2735496,2735499,2735500,2735502,2735503,2735504,2735505,2735506,2735507,2735509,2735510,2735511,2735512,2735513,2735515,2735516,2735520,2735521,2735523,2735524,2735527,2735529,2735531,2735532,2735533,2735534,2735535,2735536,2735537,2735540,2735542,2735543,2735545,2735548,2735549,2735550,2735551,2735553,2735555,2735556,2735558,2735559,2735560,2735561,2735562,2735566,2735578,2735580,2735582,2735585,2735586,2735587,2735592,2735595,2735596,2735599,2735600,2735602,2735603,2735606,2735608,2735611,2735619,2735622,2735626,2735630,2735631,2735632,2735637,2735640,2735648,2735650,2735656,2735657,2735659,2735660,2735662,2735663,2735666,2735672,2735679,2735683,2735686,2735687,2735690,2735692,2735694,2735698,2735703,2735707,2735718,2735775,2735782,2735797,2735800,2735804,2735806,2735812,2735814,2735905,2735912,2735913,2735933,2735946,2735949,2735962,2735968,2736049,2736108,2736116,2736120,2736150,2736156,2736160,2736163,2736174,2736186,2736190,2736227,2736240,2736249,2736251,2736256,2736262,2736267,2736322,2736349,2736573,2736634,2736638,2736681,2736684,2736764,2736783,2736813,2736860,2736869,2736886,2736899,2736962,2736975,2737012,2737025,2737026,2737027,2737052,2737065,2737150,2737156,2737157,2737216,2737220,2737221,2737294,2737533,2737539,2737574,2737581,2737587,2737670,2740625,2740630,2742714,2742781,2743063,2743154,2743165,2743511,2744023,2744085,2744086,2744137,2744224,2744315,2744333,2744510,2747126,2747508,2754037,2754038,2755565,2755667,2755669,2755872,2755881,2755947,2756224,2756293,2756299,2756306,2756315,2756318,2759185,2759207,2759231,2760355,2761167,2764583,2764691,2764825,2765733,2765900,2765910,2765918,2765923,2767923,2768047,2768168,2770681,2773380,2773451,2773469,2773474,2773593,2774356,2774375,2774390,2774557,2774958,2778304,2778305,2782755,2782805,2782829,2783059,2783069,2783074,2783156,2783160,2783263,2783264,2784008,2784009,2784644,2784676,2784697,2784704,2785608,2785609,2786099,2786100,2786186,2786782,2786797,2787058,2787143,2788438,2789810,2789842,2790716,2795007,2795150,2796338,2796368,2796380,2796610,2796912,2801508,2801516,2801521,2801531,2801550,2801587,2801640,2801650,2801687,2801814,2802649,2802759,2802844,2802855,2802874,2802882,2802892,2802901,2802912,2802939,2803002,2803025,2803100,2803432,2803444,2803458,2803470,2803482,2803488,2803498,2803504,2803523,2803526,2803529,2803535,2803539,2803540,2803586,2803598,2803615,2803631,2803651,2803668,2803677,2803863,2804137,2804402,2804447,2805873,2806871,2806876,2806889,2807122,2807147,2807213,2807863,2808459,2808685,2808742,2808748,2808773,2808778,2808871,2808899,2808936,2809358,2809370,2809398,2809417,2809419,2809422,2809477,2809534,2809539,2809546,2809586,2809595,2809611,2809631,2809704,2809999,2810135,2810267,2810269,2810301,2810399,2810401,2810404,2810413,2810423,2810432,2810434,2810435,2810436,2810440,2810454,2810466,2810467,2810498,2810499,2810805,2810808,2810832,2810842,2810853,2810854,2810856,2810893,2810905,2810907,2810918,2810923,2810930,2810934,2810940,2811123,2811152,2811175,2811196,2811208,2811239,2811372,2811453,2811492,2811498,2811980,2811991,2812028,2812036,2812055,2812075,2812210,2812288,2812297,2812298,2812737,2814038,2814050,2814065,2814083,2814122,2814213,2814351,2814384,2815886,2815888,2817456,2817473,2817505,2817550,2817617,2818302,2818338,2818611,2819538,2819577,2819595,2819676,2819706,2819769,2819790,2819798,2819865,2819944,2820192,2820206,2820214,2820289,2820464,2820475,2820518,2820524,2820533,2820573,2820673,2820853,2821126,2821194,2821197,2821198,2821208,2821342,2821345,2821363,2821440,2821670,2821786,2821791,2821798,2821817,2821824,2821851,2821866,2821898,2821903,2821911,2821913,2821918,2822044,2822069,2822114,2822178,2822188,2822192,2822254,2822358,2822391,2822394,2822438,2822483,2822486,2822494,2822501,2822503,2822988,2822996,2823057,2823059,2823069,2823074,2823096,2823120,2823134,2823135,2823198,2823199,2823201,2823334,2823582,2823698,2823699,2823703,2823711,2823713,2823717,2823730,2823748,2823761,2823786,2823810,2823836,2823914,2823916,2823920,2823931,2823938,2823941,2823979,2823990,2823991,2824009,2824011,2824031,2824075,2824077,2824161,2824337,2824345,2824355,2824361,2824366,2824368,2824504,2824512,2824525,2824582,2826114,2826122,2826144,2826180,2826188,2826192,2826194,2826198,2826247,2826249,2826253,2826262,2826276,2826295,2826394,2826421,2826467,2826494,2826499,2826524,2826528,2826593,2826612,2826646,2826671,2826863,2826892,2827172,2827173,2827213,2827219,2827221,2827249,2827261,2827293,2827347,2827359,2827445,2827650,2827659,2827676,2827709,2827710,2827734,2827755,2827764,2827942,2827960,2827979,2827980,2828042,2828046,2828050,2828055,2828071,2828075,2828094,2828097,2828106,2828111,2828119,2828120,2828123,2828127,2828162,2828166,2828167,2828169,2828172,2828177,2828181,2828198,2828250,2828251,2828252,2828257,2828268,2828287,2828313,2828318,2828326,2828330,2828335,2828336,2828337,2828338,2828346,2828348,2828356,2828361,2828365,2828384,2828391,2828394,2828411,2828438,2828450,2828467,2828498,2828503,2828512,2828518,2828524,2828527,2828540,2828547,2828556,2828563,2828567,2828569,2828570,2828577,2828580,2828594,2828599,2828608,2828613,2828619,2828624,2828633,2828656,2828671,2828674,2828684,2828685,2828702,2828751,2828758,2828759,2828764,2828766,2828767,2828769,2828770,2828781,2828790,2828791,2828792,2828804,2828822,2828823,2828838,2828839,2828840,2828841,2828858,2828864,2828903,2828906,2828917,2828930,2829000,2829003,2829007,2829008,2829036,2829038,2829051,2829052,2829078,2829081,2829083,2829089,2829097,2829105,2829114,2829120,2829135,2829148,2829158,2829159,2829165,2829166,2829167,2829184,2829188,2829197,2829200,2829221,2829327,2829330,2829331,2829334,2829336,2829338,2829341,2829344,2829345,2829346,2829352,2829357,2829359,2829387,2829925,2829926,2829953,2829997,2830024,2830026,2830068,2830079,2830094,2830220,2830296,2830319,2830346,2830377,2830430,2830469,2830546,2830616,2830622,2830625,2830689,2830761,2830887,2830895,2830914,2830972,2831080,2831146,2831157,2831193,2831194,2831202,2831205,2831208,2831239,2831244,2831247,2831250,2831255,2831261,2831264,2831278,2831288,2831299,2831347,2831349,2831350,2831368,2831379,2831387,2831392,2831394,2831400,2831403,2831405,2831408,2831410,2831423,2831447,2831482,2831511,2831521,2831540,2831555,2831563,2831568,2831594,2831647,2831648,2831669,2831672,2831711,2831729,2831730,2831751,2831783,2831785,2831791,2831795,2831796,2831818,2831822,2831835,2831849,2831869,2831879,2831902,2831918,2831922,2831937,2831939,2831940,2831949,2831955,2831969,2831991,2831999,2832005,2832025,2832045,2832118,2832121,2832132,2832136,2832139,2832140,2832148,2832154,2832164,2832173,2832174,2832186,2832190,2832191,2832195,2832203,2832210,2832253,2832304,2832323,2832334,2832390,2832451,2832503,2832504,2832512,2832514,2832521,2832525,2832557,2832579,2832582,2832615,2832626,2832630,2832636,2832637,2832638,2832639,2832640,2832761,2832763,2832869,2832870,2832881,2832886,2832890,2832893,2832896,2832901,2832920,2832929,2832936,2832944,2832957,2832959,2832961,2832963,2832964,2832965,2832967,2832968,2832972,2832996,2832997,2833000,2833006,2833015,2833016,2833019,2833023,2833025,2833043,2833066,2833071,2833075,2833083,2833088,2833095,2833111,2833114,2833116,2833123,2833129,2833133,2833137,2833138,2833139,2833140,2833144,2833147,2833148,2833150,2833151,2833157,2833167,2833168,2833169,2833170,2833174,2833175,2833176,2833179,2833180,2833184,2833185,2833197,2833204,2833215,2833218,2833220,2833230,2833231,2833240,2833262,2833264,2833267,2833285,2833286,2833288,2833289,2833304,2833307,2833321,2833341,2833343,2833355,2833359,2833360,2833362,2833369,2833370,2833377,2833378,2833387,2833392,2833435,2833487,2833503,2833504,2833555,2833562,2833565,2833593,2833638,2833691,2833693,2833725,2833729,2833731,2833734,2833735,2833740,2833742,2833743,2833746,2833751,2833758,2833759,2833760,2833765,2833768,2833769,2833774,2833786,2833791,2833792,2833793,2833794,2833797,2833802,2833803,2833815,2833822,2833824,2833827,2833829,2833831,2833832,2833834,2833835,2833836,2833837,2833839,2833840,2833841,2833842,2833845,2833847,2833850,2833851,2833852,2833853,2833854,2833855,2833856,2833857,2833858,2833859,2833860,2833861,2833862,2833863,2833865,2833866,2833872,2833876,2833878,2833886,2833888,2833889,2833892,2833903,2833912,2833924,2833943,2833952,2833961,2833963,2833978,2833980,2833983,2833984,2833985,2833989,2833994,2833996,2833999,2834001,2834013,2834014,2834023,2834031,2834044,2834051,2834056,2834059,2834061,2834067,2834068,2834070,2834071,2834090,2834093,2834102,2834112,2834143,2834170,2834172,2834178,2834194,2834195,2834196,2834269,2834270,2834285,2834296,2834331,2834339,2834346,2834358,2834361,2834365,2834384,2834387,2834388,2834389,2834398,2834401,2834413,2834480,2834497,2834674,2834695,2834722,2834732,2834743,2834745,2834750,2834771,2834812,2835027,2835048,2835050,2835089,2835103,2835105,2835114,2835129,2835130,2835143,2835146,2835163,2835187,2835242,2835280,2835355,2835381,2835382,2835385,2835420,2835492,2835539,2835544,2835551,2835552,2835555,2835567,2835569,2835639,2835644,2835661,2835680,2835685,2835688,2835698,2835769,2835779,2835782,2835784,2835785,2835786,2835790,2835814,2835816,2835824,2835830,2835839,2835854,2835855,2835859,2835881,2835887,2835894,2835900,2835902,2835903,2835924,2835929,2835931,2835934,2835939,2835945,2835948,2835952,2835959,2835962,2835963,2835967,2835969,2835972,2835973,2835979,2835983,2835987,2835989,2835990,2835992,2835993,2835994,2836001,2836023,2836029,2836048,2836066,2836156,2836161,2836172,2836189,2836210,2836226,2836353,2836356,2836445,2836450,2836458,2836463,2836473,2836481,2836490,2836498,2836504,2836505,2836519,2836530,2836535,2836537,2836541,2836628,2836647,2836652,2836665,2836726,2836729,2836733,2836738,2836745,2836790,2836845,2836878,2836917,2836920,2836924,2836927,2836929,2836939,2836942,2836944,2836946,2836947,2836948,2836952,2836955,2836962,2836965,2836966,2836980,2837003,2837036,2837039,2837041,2837049,2837058,2837128,2837130,2837338,2837340,2837343,2837344,2837349,2837357,2837358,2837361,2837362,2837363,2837364,2837365,2837366,2837367,2837368,2837369,2837371,2837373,2837374,2837376,2837379,2837386,2837388,2837390,2837391,2837392,2837393,2837395,2837402,2837407,2837410,2837417,2837420,2837421,2837429,2837434,2837447,2837449,2837455,2837496,2837497,2837508,2837512,2837517,2837521,2837522,2837523,2837524,2837525,2837529,2837533,2837536,2837537,2837540,2837550,2837552,2837553,2837559,2837561,2837566,2837567,2837568,2837569,2837571,2837572,2837577,2837581,2837582,2837583,2837587,2837588,2837590,2837594,2837595,2837597,2837601,2837609,2837610,2837620,2837622,2837623,2837625,2837628,2837630,2837636,2837639,2837641,2837642,2837643,2837648,2837650,2837655,2837660,2837669,2837677,2837689,2837690,2837691,2837697,2837698,2837703,2837708,2837718,2837719,2837724,2837733,2837744,2837748,2837750,2837774,2837775,2837783,2837792,2837795,2837798,2837800,2837803,2837804,2837805,2837808,2837816,2837821,2837826,2837914,2837937,2837939,2837946,2837961,2837966,2837968,2837972,2837984,2837985,2838133,2838141,2838166,2838170,2838172,2838173,2838183,2838188,2838190,2838193,2838197,2838200,2838205,2838211,2838233,2838249,2838250,2838255,2838259,2838261,2838266,2838275,2838279,2838325,2838330,2838333,2838338,2838339,2838341,2838346,2838358,2838360,2838370,2838371,2838372,2838373,2838374,2838375,2838376,2838377,2838378,2838379,2838382,2838386,2838388,2838389,2838391,2838392,2838393,2838395,2838397,2838401,2838403,2838410,2838413,2838431,2838446,2838465,2838467,2838473,2838475,2838479,2838500,2838502,2838515,2838546,2838602,2838609,2838614,2838620,2838626,2838646,2838647,2838656,2838658,2838674,2838675,2838686,2838694,2838695,2838703,2838706,2838712,2838729,2838730,2838731,2838738,2838740,2838742,2838765,2838769,2838780,2838792,2838795,2838799,2838802,2838815,2838818,2838834,2838849,2838850,2838851,2838864,2838895,2839003,2839007,2839011,2839014,2839019,2839021,2839023,2839024,2839025,2839028,2839029,2839032,2839036,2839037,2839041,2839047,2839059,2839071,2839076,2839130,2839149,2839157,2839182,2839208,2839237,2839245,2839256,2839266,2839270,2839299,2839352,2839378,2839435,2839461,2839529,2839544,2839546,2839558,2839564,2839577,2839579,2839581,2839618,2839651,2839656,2839657,2839658,2839667,2839713,2839766,2839783,2839845,2839944,2839981,2840039,2840046,2840047,2840050,2840052,2840054,2840056,2840057,2840060,2840061,2840063,2840065,2840066,2840073,2840082,2840084,2840090,2840107,2840112,2840113,2840114,2840120,2840126,2840127,2840128,2840130,2840131,2840132,2840135,2840136,2840142,2840148,2840156,2840157,2840158,2840159,2840161,2840165,2840167,2840170,2840176,2840178,2840179,2840180,2840188,2840204,2840222,2840225,2840227,2840248,2840285,2840334,2840340,2840345,2840349,2840353,2840357,2840358,2840362,2840384,2840389,2840422,2840455,2840462,2840464,2840465,2840477,2840478,2840505,2840508,2840514,2840517,2840528,2840533,2840539,2840547,2840555,2840557,2840563,2840570,2840627,2840649,2840676,2840677,2840689,2840706,2840711,2840717,2840727,2840731,2840732,2840735,2840736,2840737,2840738,2840739,2840740,2840742,2840760,2840835,2840850,2840964,2840992,2840994,2841016,2841027,2841032,2841075,2841126,2841143,2841149,2841151,2841180,2841182,2841184,2841193,2841202,2841208,2841255,2841256,2841258,2841276,2841277,2841279,2841281,2841283,2841286,2841287,2841288,2841289,2841293,2841299,2841305,2841308,2841309,2841310,2841312,2841316,2841320,2841321,2841322,2841328,2841342,2841357,2841359,2841361,2841365,2841367,2841369,2841374,2841383,2841384,2841395,2841400,2841408,2841441,2841480,2841493,2841499,2841501,2841504,2841509,2841510,2841517,2841525,2841530,2841534,2841553,2841565,2841575,2841579,2841590,2841597,2841601,2841612,2841637,2841640,2841742,2841760,2841791,2841799,2841806,2841835,2841837,2841845,2841868,2841873,2841875,2841878,2841884,2841895,2841897,2841898,2841900,2841902,2841908,2841911,2841916,2841927,2841931,2841935,2841937,2841940,2841942,2841948,2841950,2841951,2841955,2841961,2841964,2841967,2841980,2841983,2841989,2841994,2841999,2842040,2842041,2842048,2842054,2842055,2842076,2842080,2842081,2842117,2842130,2842137,2842142,2842145,2842146,2842182,2842183,2842192,2842218,2842233,2842242,2842244,2842245,2842251,2842252,2842254,2842279,2842281,2842283,2842285,2842286,2842287,2842294,2842297,2842300,2842304,2842309,2842334,2842347,2842350,2842352,2842368,2842372,2842430,2842501,2842510,2842531,2842568,2842570,2842611,2842637,2842644,2842646,2842660,2842661,2842663,2842664,2842670,2842671,2842672,2842681,2842697,2842703,2842704,2842707,2842708,2842713,2842719,2842721,2842722,2842735,2842739,2842745,2842746,2842748,2842751,2842752,2842755,2842756,2842757,2842761,2842763,2842768,2842782,2842788,2842791,2842794,2842802,2842805,2842807,2842811,2842815,2842816,2842821,2842830,2842838,2842842,2842847,2842850,2842868,2842875,2842881,2842886,2842897,2842898,2842901,2842911,2842912,2842913,2842925,2842947,2842948,2842960,2842988,2843028,2843036,2843049,2843055,2843057,2843058,2843061,2843063,2843093,2843098,2843104,2843136,2843139,2843141,2843142,2843147,2843148,2843149,2843151,2843187,2843215,2843246,2843249,2843251,2843252,2843260,2843261,2843272,2843276,2843279,2843297,2843300,2843305,2843315,2843322,2843331,2843339,2843344,2843346,2843348,2843366,2843373,2843398,2843402,2843443,2843451,2843457,2843460,2843467,2843469,2843475,2843480,2843483,2843495,2843499,2843512,2843515,2843516,2843519,2843521,2843523,2843524,2843527,2843531,2843533,2843535,2843540,2843569,2843579,2843598,2843607,2843614,2843623,2843653,2843660,2843676,2843683,2843684,2843687,2843688,2843690,2843691,2843692,2843694,2843695,2843696,2843698,2843700,2843702,2843704,2843719,2843725,2843731,2843733,2843735,2843738,2843748,2843755,2843758,2843764,2843768,2843771,2843773,2843775,2843776,2843777,2843787,2843806,2843807,2843808,2843811,2843816,2843817,2843819,2843823,2843827,2843828,2843841,2843861,2843863,2843867,2843869,2843883,2843907,2843908,2843909,2843913,2843917,2843924,2843947,2843951,2843956,2843969,2843971,2843981,2843984,2843991,2844006,2844007,2844010,2844012,2844014,2844015,2844017,2844024,2844026,2844029,2844043,2844052,2844058,2844062,2844065,2844068,2844070,2844072,2844073,2844076,2844082,2844084,2844086,2844097,2844098,2844099,2844101,2844137,2844195,2844196,2844218,2844222,2844230,2844240,2844291,2844315,2844349,2844356,2844357,2844367,2844432,2844440,2844449,2844475,2844476,2844477,2844478,2844479,2844484,2844493,2844496,2844503,2844504,2844509,2844520,2844534,2844535,2844536,2844542,2844546,2844553,2844614,2844639,2844641,2844648,2844649,2844655,2844808,2844818,2844820,2844836,2844851,2844855,2844916,2844923,2844975,2844987,2844999,2845082,2845138,2845165,2845180,2845318,2845523,2845528,2845542,2845575,2845613,2845627,2845653,2845654,2845666,2845670,2845672,2845676,2845692,2845695,2845696,2845700,2845701,2845702,2845703,2845710,2845739,2845776,2845805,2845927,2845930,2845933,2845935,2845940,2845951,2845954,2845956,2845957,2845959,2845962,2845964,2845968,2845970,2845979,2845985,2845988,2845998,2846002,2846008,2846010,2846011,2846013,2846078,2846084,2846085,2846141,2846174,2846180,2846194,2846224,2846227,2846230,2846259,2846264,2846274,2846275,2846279,2846336,2846339,2846341,2846344,2846351,2846356,2846359,2846361,2846363,2846366,2846368,2846373,2846382,2846408,2846440,2846479,2846492,2846524,2846577,2846578,2846580,2846597,2846598,2846616,2846617,2846628,2846629,2846634,2846635,2846639,2846650,2846652,2846655,2846656,2846658,2846669,2846680,2846688,2846697,2846719,2846721,2846722,2846725,2846727,2846728,2846733,2846735,2846736,2846740,2846774,2846788,2846804,2846806,2846809,2846810,2846813,2846832,2846846,2846847,2846874,2846878,2846882,2846884,2846901,2846913,2846915,2846918,2846920,2846921,2846922,2846925,2846933,2846938,2846940,2846944,2846947,2846948,2846951,2846952,2846970,2846978,2846989,2846993,2846997,2847004,2847006,2847007,2847028,2847050,2847066,2847067,2847070,2847072,2847075,2847076,2847078,2847080,2847085,2847086,2847090,2847092,2847094,2847095,2847098,2847100,2847103,2847113,2847119,2847137,2847151,2847153,2847154,2847157,2847160,2847162,2847164,2847166,2847168,2847169,2847170,2847174,2847176,2847180,2847181,2847186,2847190,2847194,2847203,2847212,2847218,2847219,2847221,2847245,2847258,2847259,2847261,2847262,2847264,2847267,2847271,2847277,2847278,2847280,2847288,2847295,2847299,2847302,2847304,2847307,2847309,2847312,2847315,2847317,2847318,2847333,2847334,2847335,2847338,2847339,2847351,2847359,2847362,2847368,2847374,2847376,2847383,2847387,2847393,2847394,2847395,2847400,2847402,2847404,2847409,2847411,2847413,2847420,2847425,2847428,2847430,2847436,2847438,2847440,2847441,2847444,2847445,2847447,2847455,2847457,2847463,2847465,2847466,2847467,2847468,2847470,2847471,2847474,2847476,2847478,2847487,2847493,2847499,2847503,2847505,2847511,2847512,2847514,2847516,2847528,2847542,2847543,2847546,2847551,2847552,2847555,2847557,2847559,2847560,2847563,2847570,2847584,2847595,2847596,2847620,2847626,2847627,2847693,2847927,2847961,2847975,2847986,2848020,2848046,2848047,2848068,2848071,2848115,2848117,2848128,2848155,2848162,2848165,2848177,2848179,2848183,2848195,2848205,2848284,2848286,2848287,2848291,2848292,2848293,2848297,2848308,2848312,2848320,2848323,2848329,2848332,2848335,2848337,2848352,2848372,2848374,2848375,2848379,2848382,2848386,2848387,2848389,2848392,2848394,2848396,2848400,2848401,2848402,2848403,2848407,2848427,2848452,2848463,2848466,2848475,2848482,2848484,2848485,2848486,2848493,2848511,2848517,2848518,2848554,2848572,2848584,2848586,2848779,2848787,2848797,2848803,2848881,2848898,2848900,2848909,2849055,2849089,2849096,2849100,2849155,2849171,2849172,2849212,2849220,2849223,2849231,2849233,2849242,2849245,2849254,2849258,2849262,2849284,2849299,2849346,2849350,2849367,2849370,2849378,2849386,2849402,2849405,2849412,2849416,2849422,2849427,2849431,2849445,2849564,2849901,2849904,2849932,2849937,2850268,2850279,2850288,2850327,2850340,2850347,2850350,2850362,2850368,2850370,2850381,2850448,2850452,2850458,2850489,2850513,2850525,2850530,2850540,2850549,2850559,2850573,2850589,2850608,2850618,2850620,2850629,2850634,2850647,2850655,2850658,2850743,2850776,2850814,2850855,2850885,2851130,2851133,2851150,2851152,2851183,2851187,2851197,2851210,2851215,2851227,2851230,2851246,2851294,2851296,2851299,2851304,2851306,2851316,2851376,2851458,2851996,2852159,2852202,2852276,2852424,2852433,2852567,2852572,2852598,2852608,2852627,2852789,2852858,2852885,2852921,2852951,2852974,2852983,2852988,2852992,2852999,2853021,2853028,2853041,2853051,2853091,2853102,2853124,2853127,2853255,2853292,2853295,2853304,2853317,2853339,2853352,2853358,2853364,2853367,2853368,2853369,2853370,2853372,2853373,2853376,2853379,2853380,2853388,2853389,2853395,2853396,2853401,2853408,2853412,2853414,2853419,2853420,2853431,2853432,2853434,2853436,2853438,2853440,2853441,2853443,2853446,2853447,2853451,2853459,2853474,2853476,2853486,2853487,2853489,2853490,2853491,2853495,2853498,2853500,2853505,2853506,2853511,2853515,2853523,2853525,2853526,2853538,2853543,2853544,2853550,2853564,2853565,2853591,2853598,2853600,2853610,2853611,2853612,2853614,2853616,2853617,2853620,2853622,2853659,2853713,2853723,2853781,2853788,2853793,2853810,2853814,2853817,2853837,2853853,2853880,2853891,2853911,2853915,2853919,2853921,2853922,2853923,2853924,2853938,2853940,2853944,2853984,2853999,2854005,2854015,2854033,2854037,2854068,2854072,2854078,2854089,2854150,2854170,2854176,2854177,2854179,2854285,2854287,2854288,2854294,2854297,2854298,2854299,2854300,2854303,2854304,2854306,2854308,2854310,2854311,2854312,2854313,2854317,2854318,2854322,2854324,2854329,2854330,2854332,2854359,2854367,2854387,2854390,2854409,2854468,2854520,2854533,2854534,2854535,2854537,2854541,2854545,2854546,2854548,2854549,2854551,2854552,2854555,2854557,2854561,2854564,2854569,2854570,2854571,2854572,2854573,2854574,2854578,2854580,2854584,2854585,2854586,2854588,2854590,2854594,2854599,2854603,2854606,2854609,2854613,2854630,2854631,2854634,2854648,2854651,2854652,2854654,2854655,2854666,2854676,2854679,2854680,2854681,2854682,2854690,2854694,2854698,2854703,2854708,2854709,2854711,2854715,2854716,2854718,2854730,2854746,2854756,2854758,2854766,2854770,2854771,2854774,2854792,2854797,2854802,2854803,2854806,2854808,2854810,2854813,2854814,2854815,2854817,2854819,2854820,2854821,2854825,2854832,2854834,2854837,2854840,2854842,2854843,2854845,2854846,2854848,2854849,2854854,2854859,2854862,2854866,2854867,2854868,2854870,2854875,2854883,2854887,2854893,2854895,2854898,2854901,2854914,2854916,2854917,2854919,2854922,2854924,2854928,2854931,2854934,2854935,2854942,2854945,2854949,2854951,2854957,2854958,2854959,2854961,2854962,2854964,2854965,2854968,2854969,2854970,2854975,2854979,2854982,2854983,2854984,2854988,2854989,2854993,2854995,2854996,2854998,2854999,2855000,2855001,2855004,2855006,2855010,2855011,2855013,2855014,2855015,2855016,2855022,2855024,2855026,2855028,2855031,2855034,2855038,2855040,2855042,2855052,2855054,2855055,2855056,2855058,2855061,2855071,2855072,2855076,2855081,2855083,2855084,2855085,2855087,2855091,2855100,2855108,2855114,2855117,2855118,2855121,2855137,2855150,2855154,2855156,2855157,2855162,2855166,2855167,2855169,2855170,2855173,2855174,2855175,2855177,2855179,2855183,2855184,2855195,2855197,2855201,2855206,2855208,2855209,2855213,2855218,2855222,2855231,2855250,2855277,2855279,2855281,2855288,2855302,2855305,2855308,2855313,2855314,2855318,2855328,2855336,2855416,2855429,2855432,2855434,2855435,2855436,2855437,2855440,2855445,2855488,2855490,2855492,2855496,2855497,2855498,2855517,2855527,2855530,2855587,2855591,2855593,2855608,2855611,2855638,2855654,2855656,2855678,2855694,2855695,2855709,2855719,2855724,2855725,2855727,2855728,2855766,2856026,2856052,2856177,2856181,2856186,2856286,2856342,2856346,2856350,2856353,2856359,2856361,2856385,2856389,2856440,2856441,2856449,2856456,2856458,2856468,2856478,2856480,2856481,2856488,2856495,2856501,2856506,2856516,2856526,2856553,2856554,2856562,2856566,2856588,2856592,2856594,2856598,2856600,2856607,2856610,2856617,2856620,2856621,2856622,2856623,2856629,2856631,2856632,2856633,2856635,2856638,2856641,2856644,2856649,2856650,2856660,2856668,2856669,2856670,2856679,2856696,2856698,2856719,2856721,2856725,2856729,2856731,2856732,2856735,2856738,2856741,2856750,2856753,2856754,2856758,2856759,2856764,2856765,2856769,2856777,2856785,2856792,2856795,2856834,2856853,2856865,2856869,2856906,2856908,2856939,2856971,2856974,2856977,2856979,2856982,2856984,2856987,2856993,2856994,2856995,2856997,2856998,2857000,2857001,2857002,2857003,2857004,2857009,2857015,2857021,2857025,2857027,2857028,2857050,2857051,2857078,2857091,2857098,2857101,2857111,2857113,2857137,2857219,2857242,2857247,2857331,2857352,2857370,2857384,2857422,2857432,2857434,2857435,2857436,2857443,2857445,2857462,2857464,2857471,2857472,2857474,2857489,2857506,2857510,2857522,2857524,2857531,2857534,2857535,2857536,2857539,2857540,2857543,2857585,2857596,2857602,2857626,2857640,2857641,2857646,2857648,2857649,2857653,2857655,2857657,2857691,2857692,2857699,2857702,2857706,2857708,2857709,2857712,2857714,2857715,2857719,2857720,2857724,2857725,2857736,2857737,2857741,2857743,2857748,2857758,2857760,2857761,2857769,2857771,2857772,2857776,2857782,2857783,2857787,2857797,2857798,2857799,2857801,2857803,2857810,2857853,2857888,2857889,2857890,2857891,2857905,2857923,2857926,2857928,2857932,2857934,2857957,2857958,2857959,2857962,2857964,2857965,2857971,2857974,2857975,2857982,2857983,2857988,2858009,2858012,2858060,2858061,2858088,2858110,2858132,2858169,2858220,2858281,2858284,2858288,2858298,2858305,2858307,2858308,2858310,2858340,2858343,2858344,2858353,2858355,2858357,2858358,2858366,2858368,2858369,2858380,2858387,2858396,2858403,2858406,2858418,2858421,2858438,2858451,2858457,2858460,2858462,2858463,2858465,2858467,2858469,2858472,2858473,2858474,2858515,2858523,2858561,2858566,2858568,2858573,2858574,2858576,2858593,2858604,2858605,2858620,2858622,2858623,2858628,2858641,2858646,2858653,2858656,2858663,2858693,2858751,2858752,2858763,2858765,2858774,2858776,2858777,2858780,2858781,2858783,2858786,2858792,2858821,2858838,2858840,2858864,2858898,2858905,2858909,2858918,2858919,2858943,2858952,2858954,2859015,2859086,2859107,2859163,2859176,2859213,2859221,2859224,2859225,2859227,2859229,2859235,2859270,2859277,2859310,2859358,2859364,2859369,2859371,2859394,2859405,2859434,2859446,2859470,2859474,2859496,2859504,2859517,2859537,2859542,2859548,2859554,2859564,2859571,2859695,2859713,2859719,2859744,2859775,2859805,2859913,2859927,2859931,2859968,2859975,2859983,2859984,2859985,2859991,2859997,2860018,2860023,2860033,2860035,2860037,2860089,2860107,2860111,2860117,2860140,2860151,2860155,2860157,2860163,2860169,2860170,2860171,2860174,2860177,2860178,2860180,2860183,2860184,2860202,2860204,2860209,2860212,2860214,2860217,2860221,2860227,2860232,2860241,2860245,2860260,2860263,2860265,2860269,2860275,2860282,2860289,2860290,2860291,2860297,2860298,2860306,2860309,2860311,2860322,2860332,2860339,2860341,2860360,2860361,2860364,2860365,2860367,2860368,2860371,2860372,2860373,2860379,2860384,2860402,2860408,2860412,2860422,2860429,2860431,2860439,2860440,2860456,2860504,2860587,2860613,2860637,2860681,2860695,2860696,2860702,2860703,2860705,2860707,2860708,2860712,2860719,2860720,2860724,2860728,2860730,2860733,2860737,2860738,2860763,2860764,2860769,2860772,2860794,2860805,2860806,2860807,2860809,2860812,2860815,2860817,2860821,2860824,2860832,2860834,2860866,2860881,2860884,2860890,2860892,2860895,2860896,2860898,2860905,2860934,2860953,2860954,2860955,2860973,2860996,2860997,2861009,2861013,2861021,2861043,2861102,2861116,2861118,2861123,2861127,2861176,2861181,2861186,2861194,2861199,2861227,2861233,2861256,2861293,2861296,2861345,2861362,2861369,2861375,2861408,2861426,2861428,2861438,2861439,2861442,2861444,2861445,2861449,2861458,2861473,2861475,2861477,2861478,2861480,2861482,2861485,2861486,2861488,2861492,2861493,2861494,2861496,2861500,2861511,2861552,2861561,2861571,2861601,2861615,2861618,2861619,2861640,2861645,2861705,2861723,2861729,2861780,2861884,2861902,2861904,2861916,2861918,2861952,2861954,2861962,2861968,2861980,2861984,2861991,2861997,2862013,2862016,2862019,2862034,2862064,2862089,2862117,2862121,2862132,2862170,2862198,2862200,2862203,2862206,2862207,2862208,2862218,2862224,2862226,2862233,2862239,2862258,2862259,2862262,2862268,2862269,2862276,2862292,2862294,2862334,2862343,2862345,2862358,2862361,2862363,2862367,2862371,2862396,2862459,2862479,2862512,2862514,2862540,2862548,2862625,2862653,2862671,2862677,2862688,2862696,2862700,2862704,2862707,2862731,2862732,2862735,2862744,2862747,2862758,2862761,2862767,2862782,2862786,2862807,2862823,2862829,2862845,2862846,2862881,2862885,2862899,2862900,2862901,2862902,2862904,2862921,2862930,2862932,2862934,2862936,2862941,2862948,2862953,2862965,2862981,2862988,2862992,2862995,2862998,2863002,2863003,2863040,2863041,2863043,2863050,2863052,2863162,2863301,2863305,2863316,2863317,2863334,2863338,2863341,2863344,2863351,2863353,2863357,2863360,2863365,2863368,2863370,2863374,2863390,2863391,2863408,2863433,2863435,2863437,2863438,2863442,2863461,2863490,2863503,2863513,2863534,2863536,2863537,2863545,2863552,2863569,2863602,2863605,2863610,2863612,2863641,2863644,2863650,2863746,2863752,2863776,2863786,2863832,2863836,2863837,2863843,2863844,2863855,2863858,2863898,2863899,2863912,2863913,2863940,2864093,2864122,2864148,2864183,2864208,2864211,2864212,2864221,2864223,2864225,2864241,2864258,2864260,2864266,2864272,2864281,2864287,2864312,2864318,2864324,2864353,2864359,2864383,2864428,2864440,2864453,2864462,2864465,2864467,2864478,2864500,2864504,2864506,2864511,2864513,2864516,2864518,2864520,2864523,2864525,2864527,2864528,2864541,2864544,2864548,2864549,2864550,2864551,2864556,2864560,2864561,2864568,2864572,2864574,2864584,2864589,2864592,2864601,2864606,2864640,2864655,2864663,2864730,2864795,2864835,2864945,2864970,2864997,2865034,2865047,2865062,2865065,2865068,2865075,2865091,2865099,2865108,2865125,2865161,2865162,2865177,2865211,2865215,2865218,2865235,2865239,2865241,2865254,2865258,2865260,2865287,2865288,2865311,2865348,2865359,2865360,2865363,2865374,2865408,2865412,2865418,2865425,2865438,2865446,2865450,2865464,2865482,2865505,2865560,2865616,2865756,2865766,2865772,2865778,2865780,2865784,2865814,2865861,2865862,2865867,2865876,2865883,2866077,2866116,2866123,2866156,2866204,2866243,2866276,2866698,2866846,2866861,2866868,2866875,2866894,2866903,2866923,2866943,2866959,2866970,2866971,2866972,2866984,2866994,2867002,2867008,2867015,2867018,2867022,2867025,2867028,2867035,2867038,2867039,2867041,2867064,2867068,2867077,2867084,2867096,2867100,2867106,2867118,2867121,2867133,2867135,2867136,2867137,2867139,2867149,2867168,2867173,2867175,2867176,2867184,2867186,2867227,2867253,2867258,2867333,2867364,2867369,2867373,2867374,2867391,2867401,2867451,2867570,2867634,2867643,2867657,2867661,2867663,2867673,2867683,2867699,2867724,2867727,2867749,2867779,2867930,2867931,2868069,2868090,2868094,2868166,2868173,2868254,2868262,2868268,2868273,2868284,2868286,2868288,2868290,2868292,2868293,2868297,2868302,2868337,2868357,2868370,2868379,2868381,2868387,2868392,2868397,2868401,2868407,2868421,2868427,2868429,2868432,2868435,2868528,2868561,2868574,2868577,2868587,2868600,2868604,2868617,2868627,2868633,2868640,2868648,2868650,2868651,2868655,2868658,2868663,2868668,2868670,2868675,2868677,2868678,2868679,2868680,2868685,2868688,2868690,2868691,2868692,2868694,2868695,2868696,2868699,2868700,2868703,2868704,2868708,2868715,2868716,2868717,2868718,2868720,2868722,2868724,2868726,2868728,2868730,2868742,2868763,2868764,2868765,2868769,2868773,2868776,2868780,2868782,2868786,2868797,2868800,2868804,2868813,2868814,2868912,2868933,2869066,2869072,2869076,2869082,2869095,2869137,2869599,2869602,2869614,2869615,2869618,2869619,2869630,2869631,2869632,2869635,2869636,2869637,2869639,2869643,2869647,2869651,2869652,2869656,2869658,2869659,2869664,2869676,2869688,2869696,2869699,2869712,2869715,2869725,2869732,2869750,2869764,2869774,2869777,2869782,2869784,2869787,2869788,2869814,2869817,2869819,2869820,2869841,2869865,2869869,2869871,2869883,2869886,2869902,2869908,2869913,2869924,2869929,2869942,2869977,2869978,2869981,2869988,2869991,2869992,2869996,2869998,2869999,2870001,2870007,2870012,2870126,2870182,2870186,2870200,2870216,2870218,2870220,2870242,2870254,2870284,2870292,2870329,2870332,2870337,2870339,2870346,2870350,2870355,2870357,2870359,2870362,2870368,2870372,2870374,2870382,2870387,2870396,2870398,2870414,2870421,2870428,2870432,2870453,2870463,2870468,2870470,2870473,2870486,2870490,2870497,2870501,2870537,2870548,2870556,2870577,2870643,2870648,2870718,2870736,2870768,2870771,2870785,2870800,2870819,2870831,2870837,2870839,2870875,2870891,2870894,2870904,2870913,2870938,2870940,2870941,2870949,2870952,2870953,2870958,2870966,2871003,2871042,2871049,2871059,2871104,2871122,2871128,2871133,2871137,2871149,2871153,2871195,2871225,2871226,2871227,2871229,2871232,2871233,2871237,2871249,2871277,2871300,2871304,2871306,2871307,2871361,2871373,2871403,2871415,2871417,2871447,2871490,2871500,2871512,2871524,2871529,2871530,2871547,2871680,2871682,2871685,2871692,2871694,2871749,2871751,2871754,2871802,2871811,2871837,2871845,2871846,2871848,2871854,2871865,2871870,2871871,2871876,2871877,2871878,2871889,2871892,2871905,2871995,2872061,2872075,2872081,2872101,2872158,2872159,2872179,2872180,2872181,2872190,2872192,2872203,2872206,2872208,2872215,2872221,2872235,2872269,2872279,2872281,2872286,2872289,2872292,2872293,2872297,2872298,2872300,2872301,2872304,2872328,2872333,2872349,2872355,2872362,2872409,2872410,2872417,2872425,2872427,2872429,2872433,2872435,2872439,2872445,2872458,2872467,2872477,2872480,2872501,2872505,2872512,2872518,2872519,2872525,2872528,2872534,2872537,2872543,2872545,2872556,2872558,2872562,2872565,2872571,2872573,2872579,2872583,2872629,2872632,2872678,2872685,2872686,2872687,2872690,2872693,2872722,2872724,2872740,2872762,2872772,2872851,2872865,2872869,2873141,2873173,2873192,2873196,2873210,2873560,2873592,2873737,2873739,2873786,2873843,2874067,2874250,2875291,2875660,2875702,2875810,2875828,2875852,2875905,2875940,2875983,2876027,2876031,2876032,2876034,2876105,2876163,2876196,2876232,2876239,2876241,2876250,2876293,2876304,2876312,2876316,2876319,2876321,2876329,2876352,2876353,2876396,2876410,2876547,2876858,2876872,2876876,2877041,2877070,2877087,2877088,2877165,2877166,2877168,2877169,2877171,2877174,2877190,2877200,2877212,2877214,2877215,2877216,2877224,2877235,2877238,2877250,2877254,2877255,2877257,2877299,2877306,2877375,2877398,2877404,2877413,2877424,2877428,2877441,2877452,2877453,2877488,2877490,2877545,2877565,2877618,2877624,2877629,2877695,2877767,2877771,2877815,2878008,2878025,2878216,2878242,2878254,2878257,2878258,2878266,2878273,2878290,2878303,2878337,2878342,2878343,2878344,2878449,2878467,2878471,2878497,2878502,2878506,2878604,2878693,2878719,2878720,2878772,2878785,2878813,2878842,2878859,2878876,2878882,2878959,2878968,2878970,2879020,2879084,2879085,2879113,2879118,2879119,2879121,2879124,2879128,2879132,2879139,2879140,2879142,2879144,2879150,2879152,2879154,2879156,2879162,2879164,2879167,2879176,2879184,2879199,2879211,2879237,2879242,2879253,2879257,2879262,2879263,2879269,2879285,2879301,2879321,2879357,2879364,2879428,2879432,2879439,2879449,2879455,2879471,2879487,2879496,2879502,2879515,2879534,2879570,2879597,2879667,2879674,2879706,2879743,2879793,2879829,2879831,2879840,2879841,2879843,2879848,2879850,2879859,2879874,2879889,2879902,2879910,2879912,2879918,2879919,2879925,2880043,2880046,2880070,2880073,2880132,2880264,2880283,2880309,2880339,2880346,2880351,2880355,2880614,2881025,2881199,2881298,2881376,2881408,2881412,2881420,2881560,2882717,2882738,2882740,2883637,2883795,2884088,2884132,2884137,2884154,2884233,2884246,2884247,2884256,2884348,2884414,2884424,2884432,2884433,2884436,2884438,2884454,2884456,2884458,2884467,2884499,2884501,2884507,2884508,2884515,2884516,2884522,2884531,2884540,2884542,2884547,2884569,2884574,2884576,2884591,2884592,2884617,2884633,2884644,2884655,2884660,2884663,2884666,2884667,2884682,2884683,2884700,2884707,2884708,2884784,2884834,2884843,2884876,2884921,2884930,2884932,2884950,2884980,2885002,2885006,2885017,2885042,2885043,2885050,2885060,2885063,2885067,2885083,2885087,2885088,2885090,2885094,2885095,2885098,2885101,2885102,2885106,2885152,2885157,2885176,2885180,2885193,2885215,2885220,2885226,2885232,2885238,2885250,2885254,2885264,2885265,2885270,2885280,2885288,2885308,2885337,2885395,2885402,2885407,2885408,2885429,2885443,2885444,2885446,2885448,2885449,2885452,2885456,2885460,2885461,2885465,2885466,2885471,2885475,2885485,2885491,2885494,2885500,2885503,2885507,2885518,2885525,2885528,2885531,2885552,2885555,2885571,2885574,2885578,2885651,2885672,2885673,2885683,2885684,2885685,2885690,2885695,2885696,2885698,2885699,2885703,2885705,2885711,2885713,2885724,2885731,2885739,2885746,2885762,2885774,2885780,2885798,2885845,2885880,2885881,2885884,2885895,2885904,2885908,2885920,2885921,2885924,2885925,2885943,2885961,2885996,2886037,2886113,2886393,2886558,2886621,2886649,2886654,2886658,2886659,2886665,2886671,2886680,2886681,2886682,2886693,2886743,2886745,2886747,2886754,2886756,2886777,2886785,2886788,2886797,2886804,2886808,2886838,2886851,2886854,2886856,2886859,2887543,2887568,2887630,2887919,2887925,2887927,2887945,2887959,2888014,2888029,2888039,2888044,2888070,2888071,2888150,2888151,2888157,2888164,2888166,2888202,2888204,2888215,2888219,2888220,2888229,2888230,2888234,2888236,2888283,2888326,2888332,2888337,2888341,2888342,2888345,2888347,2888355,2888359,2888376,2888426,2888434,2888440,2888441,2888442,2888444,2888496,2888498,2888500,2888501,2888503,2888504,2888506,2888508,2888509,2888514,2888515,2888518,2888519,2888523,2888524,2888528,2888530,2888533,2888534,2888539,2888558,2888559,2888582,2888703,2888716,2888718,2888729,2888771,2888775,2888811,2888812,2888816,2888819,2888823,2888825,2888832,2888833,2888834,2888840,2888842,2888846,2888879,2889120,2889163,2889179,2889362,2889368,2889369,2889370,2889371,2889372,2889374,2889377,2889378,2889384,2889388,2889389,2889390,2889393,2889396,2889400,2889402,2889405,2889409,2889411,2889412,2889413,2889444,2889449,2889493,2889518,2889521,2889526,2889528,2889535,2889537,2889545,2889559,2889589,2889590,2889625,2889638,2889658,2889666,2889689,2889691,2889785,2889811,2889902,2889917,2889987,2890268,2890346,2890370,2890916,2890923,2890926,2890943,2890969,2890970,2890971,2890984,2891123,2891126,2891131,2891143,2891145,2891147,2891151,2891156,2891170,2891171,2891292,2891305,2891314,2891433,2891482,2891485,2891500,2891522,2891538,2891550,2891555,2891571,2891572,2891579,2891622,2891636,2891643,2891647,2891648,2891658,2891671,2891672,2891673,2891680,2891683,2891685,2891688,2891690,2891693,2891700,2891706,2891715,2891729,2891750,2891752,2891755,2891774,2891785,2891787,2891791,2891792,2891895,2891899,2891914,2891955,2891978,2891980,2891981,2892752,2892754,2892766,2892771,2892775,2892817,2892841,2892852,2892947,2893147,2893173,2893179,2893188,2893191,2893196,2893198,2893224,2893225,2893228,2893235,2893237,2893238,2893245,2893248,2893251,2893268,2893269,2893270,2893273,2893274,2893278,2893282,2893287,2893289,2893294,2893296,2893317,2893359,2893364,2893380,2893389,2893424,2893440,2893451,2893454,2893456,2893457,2893459,2893463,2893476,2893479,2893487,2893489,2893491,2893493,2893495,2893500,2893502,2893503,2893510,2893516,2893546,2893547,2893630,2893682,2893699,2893703,2893705,2893719,2893752,2893756,2893759,2893760,2893762,2893771,2893779,2893795,2893806,2893808,2893809,2893813,2893849,2893868,2893888,2893889,2893891,2893894,2893916,2893926,2893928,2893991,2894034,2894077,2894081,2894139,2894238,2894245,2894249,2894253,2894259,2894262,2894268,2894275,2894293,2894306,2894310,2894316,2894319,2894321,2894323,2894331,2894338,2894344,2894345,2894350,2894354,2894355,2894356,2894367,2894369,2894385,2894399,2894416,2894437,2894533,2894673,2894688,2894727,2894761,2894763,2894780,2894839,2894840,2894935,2894992,2894996,2895053,2895067,2895069,2895075,2895106,2895109,2895117,2895156,2895157,2895158,2895163,2895165,2895180,2895189,2895195,2895211,2895223,2895225,2895256,2895257,2895262,2895263,2895269,2895275,2895279,2895283,2895288,2895342,2895363,2895366,2895368,2895390,2895455,2895506,2896608,2896647,2896649,2896652,2896674,2896675,2896694,2896750,2896896,2896986,2897051,2897210,2897256,2897293,2897310,2897320,2897322,2897324,2897332,2897335,2897356,2897359,2897387,2897769,2897795,2897800,2897867,2897878,2897881,2897884,2897891,2897898,2897903,2897907,2897909,2897914,2897921,2897947,2897950,2897955,2897958,2897963,2897966,2897969,2897974,2897980,2897981,2897989,2897995,2898006,2898026,2898035,2898039,2898079,2898104,2898105,2898108,2898168,2898175,2898257,2898263,2898266,2898268,2898271,2898307,2898322,2898327,2898342,2898344,2898367,2898368,2898380,2898392,2898395,2898398,2898399,2898400,2898401,2898405,2898437,2898523,2898541,2898554,2898576,2898599,2898649,2898653,2898657,2898760,2898765,2898774,2898783,2898784,2898810,2898820,2898836,2898849,2898853,2898854,2898881,2898882,2898894,2898946,2898971,2898976,2899015,2899029,2899068,2899101,2899114,2899148,2899149,2899184,2899223,2899239,2899246,2899397,2899403,2899404,2899421,2899428,2899440,2899443,2899453,2899454,2899461,2899464,2899479,2899579,2899601,2899616,2899619,2899629,2899630,2899633,2899646,2899647,2899686,2899694,2899709,2899718,2899726,2899728,2899729,2899733,2899760,2899762,2899766,2899792,2899821,2899881,2899885,2899891,2899893,2899901,2899910,2899913,2899938,2899939,2899955,2899957,2899972,2899975,2899987,2899992,2899994,2899997,2900012,2900023,2900035,2900059,2900074,2900093,2900094,2900100,2900105,2900117,2900127,2900134,2900143,2900166,2900171,2900417,2900502,2900516,2900519,2900524,2900583,2900654,2900686,2900724,2900829,2901023,2901042,2901421,2901436,2901454,2901592,2901813,2901852,2901854,2901855,2901929,2902038,2902039,2902048,2902050,2902060,2902064,2902065,2902075,2902205,2902225,2902256,2902259,2902260,2902281,2902329,2902361,2902458,2902502,2902929,2902932,2903013,2903017,2903046,2904347,2904402,2904503,2904552,2904562,2904669,2904818,2904820,2904867,2904887,2904932,2904942,2904976,2904986,2904992,2904995,2905097,2905105,2905115,2905128,2905132,2905144,2905147,2905149,2905174,2905188,2905195,2905206,2905217,2905386,2905417,2905424,2905451,2905465,2905480,2905513,2905523,2905527,2905534,2905726,2906332,2906334,2906336,2906340,2906342,2906350,2906362,2906426,2906644,2906659,2906801,2906811,2906864,2906928,2906987,2907002,2907016,2907220,2907237,2907380,2907567,2907588,2907934,2908068,2908077,2908079,2908104,2908262,2908264,2908478,2908482,2908487,2908586,2908589,2908592,2908615,2908682,2908689,2908699,2908803,2909388,2909707,2909709,2909739,2909741,2909751,2909754,2909757,2909758,2909764,2909766,2909770,2909771,2909772,2909776,2909777,2909781,2909787,2909792,2909793,2909803,2909909,2909920,2909946,2909951,2909952,2909987,2909988,2910004,2910111,2910113,2910122,2910142,2910289,2910297,2910318,2910393,2910394,2910396,2911066,2911091,2911096,2911122,2911220,2911225,2911229,2911231,2911235,2911237,2911238,2911242,2911243,2911246,2911247,2911248,2911259,2911260,2911263,2911265,2911266,2911267,2911269,2911271,2911277,2911278,2911279,2911282,2911283,2911285,2911287,2911288,2911296,2911298,2911302,2911303,2911306,2911313,2911316,2911323,2911329,2911330,2911337,2911338,2911342,2911349,2911351,2911354,2911356,2911359,2911369,2911372,2911381,2911384,2911385,2911388,2911391,2911392,2911393,2911394,2911413,2911417,2911420,2911421,2911424,2911425,2911428,2911429,2911430,2911431,2911432,2911433,2911435,2911436,2911437,2911441,2911442,2911445,2911449,2911454,2911465,2911467,2911473,2911485,2911488,2911489,2911490,2911491,2911496,2911501,2911502,2911507,2911508,2911513,2911516,2911517,2911520,2911521,2911523,2911528,2911529,2911530,2911531,2911533,2911537,2911538,2911542,2911551,2911553,2911565,2911572,2911574,2911613,2911630,2911712,2911723,2911766,2911810,2911918,2911931,2911943,2911965,2911970,2911998,2911999,2912092,2912131,2912474,2912510,2912530,2912572,2912577,2912594,2912605,2912614,2912616,2912637,2912638,2912646,2912648,2912651,2912652,2912658,2912659,2912661,2912669,2912703,2912704,2912706,2912714,2912716,2912717,2912719,2912721,2912722,2912723,2912725,2912726,2912727,2912733,2912735,2912738,2912750,2912753,2912761,2912763,2912767,2912769,2912773,2912774,2912775,2912776,2912777,2912785,2912790,2912791,2912796,2912797,2912798,2912799,2912801,2912804,2912808,2912809,2912810,2912811,2912813,2912816,2912819,2912822,2912830,2912831,2912833,2912834,2912846,2912849,2912854,2912857,2912858,2912860,2912861,2912863,2912868,2912872,2912873,2912881,2912882,2912898,2912907,2912911,2912912,2912914,2912915,2912917,2912923,2912928,2912930,2912932,2912934,2912942,2912954,2912955,2912956,2912962,2912978,2912984,2912992,2912994,2913001,2913006,2913008,2913013,2913014,2913015,2913018,2913028,2913029,2913035,2913050,2913051,2913064,2913077,2913079,2913088,2913097,2913098,2913099,2913101,2913130,2913134,2913148,2913150,2913152,2913154,2913163,2913166,2913167,2913169,2913172,2913174,2913176,2913177,2913180,2913181,2913190,2913191,2913199,2913200,2913203,2913206,2913218,2913221,2913227,2913248,2913259,2913267,2913275,2913276,2913279,2913281,2913282,2913302,2913316,2913355,2913368,2913370,2913411,2913419,2913430,2913434,2913467,2913496,2913606,2913607,2913608,2913610,2913611,2913612,2913618,2913633,2913635,2913812,2913814,2913880,2913892) ) AND ( core_reputation_index.reaction IN(1,2,3,6,4,5) )

Hey Marc, Assuming I drop my new index and recreate it as post_date, I should be fine right? Unless something has to be changed on a specific index (such as implementing the topic_id 😄 ) I doubt an upgrade will drop and recreate all indexes, would take ages

If you're mostly remote, my go-to would be: Disable ssh access with password, only use public key authentication. Remove all unknown keys in /root/.ssh/authorized_keys file And for all other accounts . When adding public keys to authorized_keys, annotate whose key is whose, will greatly simplify this in the future. But for all intents and purposes you have to assume your server is compromised, especially if your ex employee had root access. This is something that your Legal department should know about. This is less of a technical issue imo.

Addendum: I dropped the post_date index for now, it seems to be running better. But I'm now a bit scared that future updates will break, so if I have to recreate post_date instead, let me know!

Hey, last weeks I've been having complaints from our users that our (self hosted) IP is slower than before. First I tried tweaking php-fpm settings, but I never really saw enough concurrent connections to really justify upping the max_clients to something absurd. Then I saw that the database seemed to be having difficulties. I enabled slow query logging and found the following query that was really slow (> 5seconds) for about every user. MariaDB [mysql]> select * from slow_log limit 10; +----------------------------+--------------------------------------+-----------------+-----------------+-----------+---------------+-------+----------------+-----------+-----------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-----------+---------------+ | start_time | user_host | query_time | lock_time | rows_sent | rows_examined | db | last_insert_id | insert_id | server_id | sql_text | thread_id | rows_affected | +----------------------------+--------------------------------------+-----------------+-----------------+-----------+---------------+-------+----------------+-----------+-----------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-----------+---------------+ | 2024-07-28 08:38:04.975686 | forumrsca[forumrsca] @ [172.19.0.8] | 00:00:07.687649 | 00:00:00.000022 | 1 | 2595147 | forum | 0 | 0 | 1 | /*forum::forumrsca::IPS\Content\_Item::_comments:2109*/ SELECT forums_posts.*, author.*, author_pfields.* FROM `forums_posts` LEFT JOIN `core_members` AS `author` ON author.member_id = forums_posts.author_id LEFT JOIN `core_pfields_content` AS `author_pfields` ON author_pfields.member_id=author.member_id WHERE forums_posts.topic_id=8215 AND forums_posts.queued!=-2 AND forums_posts.queued!=-3 ORDER BY post_date ASC LIMIT 0,1 | 3542766 | When running an EXPLAIN i see the following: MariaDB [forum]> EXPLAIN SELECT forums_posts.*, author.*, author_pfields.* FROM forums_posts LEFT JOIN core_members AS author ON author.member_id = forums_posts.author_id LEFT JOIN core_pfields_content AS author_pfields ON author_pfields.member_id = author.member_id WHERE forums_posts.topic_id = 8215 AND forums_posts.queued != -2 AND forums_posts.queued != -3 ORDER BY post_date ASC LIMIT 0, 1; +------+-------------+----------------+--------+-------------------------------------------------------+-----------+---------+------------------------------+------+-------------+ | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | +------+-------------+----------------+--------+-------------------------------------------------------+-----------+---------+------------------------------+------+-------------+ | 1 | SIMPLE | forums_posts | index | queued,topic_id,first_post,idx_topic_queued_post_date | post_date | 5 | NULL | 835 | Using where | | 1 | SIMPLE | author | eq_ref | PRIMARY,mgroup | PRIMARY | 8 | forum.forums_posts.author_id | 1 | Using where | | 1 | SIMPLE | author_pfields | eq_ref | PRIMARY | PRIMARY | 3 | forum.author.member_id | 1 | Using where | +------+-------------+----------------+--------+-------------------------------------------------------+-----------+---------+------------------------------+------+-------------+ 3 rows in set (0.51 sec) It's using post_date here, which isn't really ideal as there's no indexing on topic_id I then tried creating this index: CREATE INDEX idx_topic_id_queued_post_date ON forums_posts(topic_id, queued, post_date); But it's not being used in this query. And admin CP doesn't agree with my fix 😄 How could I fix this issue? Is this a known one? I guess I could drop the post_date index and recreate it with the topic_id and queued instead... But hey, I'd rather double check 🙂 Added info: Invision Community v4.7.17

Where is it hosted? You don't neccesarily need to delete the account, if you can ensure only internal network can reach your machine.

That's actually a fair point, I hadn't thought about that. Thanks @Jim M!

When upgrading I got an error saying a script "insert ignore select into gallery_images_uploads select * from gallery_images_uploads_new" This is because my database had more columns in the "new" table. This I worked around this by manually adding the columns in mysql: MariaDB [dbname]> alter table gallery_images_uploads add column upload_location text; Query OK, 0 rows affected (0.01 sec) Records: 0 Duplicates: 0 Warnings: 0 MariaDB [dbname]> alter table gallery_images_uploads add column upload_unique_id bigint(20) unsigned NOT NULL; Query OK, 0 rows affected (0.01 sec) Records: 0 Duplicates: 0 Warnings: 0 MariaDB [dbname]> alter table gallery_images_uploads add column upload_order int(10) unsigned; Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 This may be caused because I never upgraded anything else than Core and Forums. But I didn't have an option to deselect other features from this upgrade. But anyway... We survived!

Slightly related question: are your avatars generated with some sort of publicly available tool? 🙂

Yeah that should have been my first idea. Thanks @Marc Stridgen!

Hi guys, To test the PHP 8 upgrade I restored production db to a staging environment. Everything seems to work fine, however I have some issues with fonts being fetched from the production environment. And because it comes from another URL, a CORS error is thrown: Any idea where I can change this so it goes to the staging environment?

Thanks @Randy Calvert!

Hey guys, For our community we run a docker stack on an azure machine. It's comprised of: - Nginx - PHP-FPM (7.3) - Mariadb (10.2) - Certbot for https certs - Some helper containers Currently we run IPS 4.5.2. As PHP 8.0 will be recommended for new version I wanted to test if the upgrade procedure was working correctly. Therefore I took a backup of the database, spun up a new stack with the same settings and tried upgrading the php-fpm container to 8.0. Before the new container, I can access the staging environment just fine. After the new php-fpm container I notice that it just keeps loading until the max_execution_time is hit, and then it proceeds to dump some code in the browser, without any error messages. Any ideas? Should I try a more "baby steps" approach using a 7.4 container?