SELECT

    log_user,

    user_name AS 'Username',

    user_registration AS 'Registration',

    user_editcount AS 'Edit count',

    log_min AS 'First patrol (ever)',

    log_max AS 'Last patrol',

    ipb_expiry AS 'Block expiry',

    ipb_reason AS 'Block reason'

FROM

(

    SELECT

        log_user,

        MIN(log_timestamp) AS log_min,

        MAX(log_timestamp) AS log_max

    FROM logging_userindex

    WHERE log_user IN

        (

    -- second half of log_user column from query 8767:

    -- SELECT log_user, COUNT(*) FROM logging_userindex

    -- WHERE log_type = 'patrol'

    -- AND log_deleted = 0

    -- AND log_timestamp BETWEEN 20140401000000 AND 20160401000000

    -- AND log_params NOT LIKE '%::auto";i:1%'

    -- GROUP BY log_user;

17264722,17264771,17269560,17270758,17283576,17295145,17295265,17300358,

17306229,17307105,17307551,17309808,17311078,17316666,17317244,17319538,

17322254,17328047,17328627,17340900,17341759,17344894,17350000,17357788,

17365983,17369702,17370235,17373925,17375010,17378704,17380896,17382034,

17384343,17395718,17397640,17400328,17403609,17405062,17408260,17413393,

17415746,17421396,17422851,17423097,17423488,17427509,17428606,17436477,

17438417,17441670,17444960,17448936,17449355,17449466,17450633,17451795,

17455969,17459183,17466542,17476900,17480535,17487443,17491313,17497601,

17500133,17500636,17504578,17505739,17508693,17518092,17520314,17520643,

17521300,17522521,17532122,17543794,17555975,17557279,17560928,17561152,

17570239,17573640,17574437,17575386,17575721,17582881,17583334,17585538,

17587958,17594434,17594459,17595503,17599853,17605860,17612783,17618869,

17619006,17619827,17620346,17620552,17621034,17633563,17634930,17635105,

17640544,17643545,17647363,17651076,17651454,17652082,17654465,17656933,

17658999,17664887,17669600,17670061,17675815,17683328,17688285,17688569,

17690147,17690241,17690896,17692156,17698045,17701913,17706232,17706726,

17716702,17722916,17723323,17726870,17734046,17734822,17735990,17739606,

17746512,17753965,17756525,17758142,17762993,17763356,17771490,17772824,

17775569,17777255,17779093,17779745,17780922,17782321,17785549,17786646,

17787723,17789280,17791735,17798268,17810587,17818824,17819657,17820167,

17821985,17823581,17824058,17834777,17836912,17843555,17844196,17847210,

17852405,17852471,17859592,17860485,17863160,17864692,17865059,17865895,

17870304,17870591,17878972,17884940,17885868,17888262,17891487,17902549,

17911012,17912102,17913162,17914524,17917205,17925655,17931877,17937885,

17938734,17943841,17944471,17944818,17945259,17952751,17954581,17955641,

17956451,17957094,17967120,17971031,17973603,17980182,17984316,17987505,

17994267,18002327,18002896,18004971,18008149,18017774,18017931,18028366,

18030372,18039079,18050826,18051134,18053487,18056082,18057899,18066332,

18066951,18085305,18096677,18099258,18109531,18114646,18119532,18123252,

18129105,18130100,18130370,18135507,18142576,18143515,18145736,18150925,

18152071,18154555,18157057,18160010,18160960,18163206,18165363,18166208,

18170432,18171050,18173407,18173502,18177679,18179945,18180119,18180707,

18180760,18182096,18189084,18198957,18206476,18207719,18213547,18215845,

18218984,18222402,18225344,18231377,18237535,18240633,18241343,18241608,

18246619,18268380,18274427,18277574,18281165,18281217,18281898,18282110,

18284749,18286725,18288353,18289506,18292690,18305830,18306862,18308978,

18310256,18312540,18313966,18315292,18327308,18331982,18334455,18335576,

18336458,18339199,18340069,18344562,18357562,18362244,18364158,18368297,

18371010,18371554,18372352,18381293,18391149,18391913,18395284,18396192,

18396823,18397380,18409190,18414713,18415831,18417984,18418173,18422520,

18445690,18451820,18453825,18454943,18468837,18474721,18482812,18488006,

18489314,18495106,18501777,18504625,18507520,18509987,18510469,18510886,

18511131,18518501,18520280,18520703,18522464,18547642,18557890,18562984,

18568843,18571574,18573042,18577160,18578145,18578485,18578793,18579780,

18580757,18581525,18590216,18596685,18600472,18606104,18606886,18610892,

18612333,18614876,18622101,18622113,18623023,18630101,18630127,18630775,

18632153,18632909,18635545,18638262,18638798,18650035,18650529,18653743,

18655711,18656920,18657785,18660763,18661473,18663209,18670877,18678855,

18680674,18684401,18692896,18704014,18710878,18711305,18717168,18725624,

18727464,18729089,18732375,18735057,18735866,18746098,18749494,18749594,

18750003,18760506,18766808,18772350,18777500,18778072,18783712,18784265,

18790217,18792420,18794213,18795791,18798801,18799736,18805198,18808294,

18808818,18811473,18822125,18823469,18824446,18825597,18826517,18834883,

18853347,18853599,18856113,18857348,18866445,18869649,18871620,18873704,

18874949,18875426,18877876,18878215,18884645,18891628,18892583,18893726,

18893748,18899359,18902143,18906913,18907122,18909236,18909800,18911373,

18915639,18917475,18922183,18923727,18930177,18932721,18934599,18935077,

18935998,18936537,18938250,18942832,18947572,18952172,18952543,18958275,

18961163,18963453,18972203,18972939,18974729,18976471,18977505,18980287,

18985077,18986777,18986791,18998846,18999815,19003020,19003571,19007514,

19008077,19009321,19010806,19014806,19021017,19022053,19031216,19033106,

19034339,19036372,19039501,19039785,19040273,19047243,19049590,19050143,

19050216,19050228,19055111,19056656,19059602,19063298,19067436,19068544,

19072343,19074574,19075131,19077245,19079409,19079512,19088180,19089174,

19089608,19093690,19099103,19106470,19107394,19114861,19115920,19119394,

19120001,19127634,19127859,19128559,19129152,19130652,19134498,19139108,

19140477,19149133,19153426,19154426,19155557,19156193,19157947,19158313,

19161633,19164162,19171093,19176500,19176881,19177549,19178148,19181966,

19184123,19184898,19186296,19186632,19188824,19193669,19196851,19198568,

19200660,19204020,19207416,19211694,19212093,19214928,19215612,19217298,

19222579,19229624,19229835,19230232,19231214,19234344,19234405,19241170,

19241221,19244234,19244264,19246392,19249461,19250086,19252572,19259246,

19260347,19261346,19261717,19261965,19263063,19264265,19264654,19265353,

19266577,19266816,19267464,19267658,19269270,19272864,19274271,19274619,

19277499,19279375,19280148,19280715,19284963,19285809,19286698,19289283,

19292944,19295592,19296010,19297031,19297189,19299387,19300138,19300930,

19304695,19306181,19309571,19314519,19316689,19316880,19321557,19323020,

19323998,19326957,19327424,19329564,19331273,19334153,19338794,19338861,

19342237,19343075,19343293,19343869,19345394,19347003,19349081,19349087,

19349091,19349497,19355811,19356336,19359297,19364548,19368831,19370506,

19373908,19379913,19380565,19382112,19382177,19385613,19390481,19392055,

19392310,19396186,19396200,19396915,19397470,19399913,19402143,19404073,

19405746,19407754,19408546,19409087,19410223,19413237,19413316,19416738,

19418854,19419125,19421529,19423324,19423865,19424196,19428649,19429508,

19429864,19433605,19436844,19440047,19442388,19443199,19449603,19452144,

19454511,19457878,19464662,19465803,19472886,19476945,19477919,19485436,

19490688,19497080,19500063,19500131,19502158,19502780,19510770,19512211,

19513126,19518877,19519079,19525340,19526527,19529294,19532283,19533885,

19535494,19536359,19544196,19549021,19549390,19550906,19556597,19557640,

19571461,19575049,19575154,19575341,19575850,19576177,19576772,19579512,

19582120,19582553,19583205,19583588,19589428,19593170,19598865,19598939,

19602764,19603542,19604351,19605834,19607945,19620715,19626472,19627469,

19627935,19632307,19633555,19636017,19639226,19641370,19641692,19644429,

19649881,19655465,19664647,19666167,19667675,19667969,19669520,19671966,

19680379,19680382,19680394,19682954,19685406,19689608,19692345,19695606,

19700137,19702731,19707370,19717130,19720634,19724336,19727964,19731971,

19733343,19736978,19737011,19740960,19743590,19744011,19745755,19747965,

19748611,19749627,19753872,19757247,19757313,19759046,19759822,19764565,

19767159,19769249,19769626,19775688,19781369,19781588,19795403,19796795,

19797600,19798188,19799243,19803146,19804491,19804834,19807629,19807794,

19816285,19817036,19818307,19818549,19820161,19821343,19827892,19832796,

19834941,19835299,19838600,19839539,19843088,19843626,19853006,19857126,

19858615,19863975,19864238,19864887,19865277,19868482,19872396,19872498,

19873757,19873793,19879721,19882747,19884033,19891603,19893651,19893951,

19895717,19903250,19904827,19905535,19908386,19910963,19911617,19912518,

19915217,19918947,19919026,19921271,19922230,19924591,19926869,19928778,

19928789,19934243,19936905,19940685,19942186,19947673,19948431,19954945,

19957214,19959044,19959423,19959497,19964745,19965144,19965906,19971057,

19973778,19978062,19981181,19983830,19985602,19986047,19988957,19999621,

20008731,20008732,20010244,20011192,20015350,20019280,20022544,20029231,

20029967,20030335,20033441,20033548,20034449,20035068,20035302,20036276,

20038717,20038795,20048337,20059151,20060099,20060119,20062465,20063393,

20076804,20077431,20083999,20086261,20099128,20102211,20103569,20104018,

20105085,20105356,20107575,20108326,20111475,20119312,20119815,20123115,

20128702,20130286,20141233,20145563,20153560,20156502,20158241,20158586,

20158942,20161611,20162524,20163293,20164787,20165086,20166360,20176158,

20178250,20180186,20182127,20189907,20190015,20192167,20193463,20203233,

20205026,20205374,20206743,20207350,20208092,20208822,20211588,20215332,

20215817,20218033,20218652,20222448,20224789,20229914,20236791,20237183,

20237455,20238112,20238429,20240123,20240828,20243328,20243816,20244625,

20248801,20249862,20251815,20254913,20255451,20255624,20257692,20257836,

20258740,20261584,20265704,20266770,20269857,20271459,20277683,20282133,

20284900,20288038,20288897,20291835,20292850,20292942,20293818,20296737,

20297394,20298781,20299081,20303083,20305973,20307274,20312413,20312833,

20312904,20313089,20317460,20319544,20319727,20322959,20331055,20334150,

20334301,20349938,20350509,20355744,20361299,20361454,20362198,20369716,

20370168,20371397,20372668,20378965,20380821,20381984,20383869,20384005,

20385242,20386236,20386385,20389183,20390093,20395317,20396619,20398877,

20399841,20402762,20403259,20407588,20409138,20410206,20414805,20416846,

20418212,20419951,20425983,20433299,20436973,20439664,20441404,20442586,

20442620,20443846,20448661,20451642,20452276,20453235,20462054,20465929,

20466106,20472487,20472590,20480673,20480869,20483031,20483988,20485987,

20488265,20489198,20491435,20492208,20492596,20493706,20496994,20497679,

20497904,20498931,20501900,20502830,20502869,20508333,20508337,20508882,

20509359,20513590,20515796,20518478,20518692,20521343,20523797,20524356,

20527811,20532298,20533911,20535576,20536264,20536549,20538049,20538449,

20543045,20546717,20548678,20549476,20550549,20551343,20554599,20565598,

20568271,20568353,20569089,20569891,20569919,20570124,20574729,20576982,

20579142,20583248,20587937,20590329,20594247,20594953,20595022,20598768,

20611262,20615803,20618913,20623822,20626998,20633870,20637546,20638095,

20639613,20640736,20641784,20644568,20645211,20648597,20650448,20651316,

20658016,20662831,20664464,20665093,20668489,20669363,20674826,20675949,

20676877,20680486,20681036,20681632,20681829,20682032,20682204,20685029,

20685249,20686414,20686744,20688400,20688806,20689374,20689447,20689998,

20692916,20693857,20699492,20703868,20706220,20708093,20710138,20710260,

20718714,20722051,20726929,20728426,20730466,20732025,20732776,20734178,

20735230,20736262,20736423,20736658,20737818,20738829,20743205,20744826,

20754535,20754560,20759250,20761916,20764880,20766074,20770715,20775802,

20786740,20786939,20789573,20795188,20798353,20800274,20803506,20806120,

20811363,20815805,20820109,20825460,20826778,20826925,20830103,20834545,

20836898,20838742,20840784,20846376,20849519,20850197,20851466,20852651,

20856556,20859393,20861386,20867061,20867870,20875568,20878269,20880408,

20882708,20883229,20885655,20889045,20890152,20896651,20897732,20898270,

20898904,20899928,20900369,20901055,20905762,20907869,20908131,20908161,

20909178,20914198,20919629,20924972,20925408,20925888,20926225,20926469,

20928757,20930659,20932806,20933405,20933629,20935787,20935822,20935996,

20937072,20937189,20939083,20943418,20947291,20948859,20949630,20953378,

20954141,20956204,20957809,20958020,20958512,20965958,20967751,20970729,

20974791,20975789,20982152,20984115,20989241,20990026,20991435,20993302,

20996381,20998086,20999826,21000565,21003237,21003853,21005566,21006650,

21009996,21010615,21012505,21012571,21012992,21013176,21015877,21016485,

21018718,21020921,21026392,21031182,21031537,21032358,21032501,21033271,

21033777,21035594,21038817,21039259,21040407,21041166,21042919,21049146,

21050569,21051299,21051757,21051777,21053755,21053824,21054217,21055796,

21056935,21057347,21057916,21059501,21062275,21063153,21070414,21071050,

21071364,21074263,21074923,21077049,21080231,21080454,21087609,21087859,

21088092,21088390,21089326,21093015,21093687,21096114,21098239,21102089,

21103193,21104507,21105851,21109446,21111806,21116070,21117785,21119524,

21122717,21127693,21127813,21128196,21128531,21130952,21131140,21131536,

21132283,21132979,21133029,21138162,21146578,21147886,21148073,21151095,

21151565,21152290,21152371,21152703,21153935,21154051,21154706,21156659,

21157562,21157821,21159684,21162770,21163718,21165347,21165869,21166720,

21166806,21167240,21170456,21172728,21177361,21177597,21178912,21182039,

21182790,21183535,21184938,21188078,21191361,21191502,21191539,21193890,

21193898,21197118,21197452,21198329,21198886,21199242,21200627,21201057,

21202533,21202748,21203632,21205934,21209188,21211462,21212471,21212763,

21216547,21218152,21221428,21221868,21223961,21224110,21224244,21225716,

21226362,21226966,21226984,21227344,21227381,21230241,21233013,21234708,

21240663,21240894,21241499,21245323,21245615,21248446,21248988,21249390,

21252180,21252322,21253515,21253570,21254550,21256064,21262136,21263963,

21264557,21265529,21267106,21268102,21268108,21270123,21270677,21272504,

21273334,21275468,21275809,21276941,21282970,21283797,21285370,21285563,

21286621,21287957,21289871,21289893,21292113,21293307,21293847,21298041,

21298466,21299956,21300331,21300820,21302162,21302502,21302887,21304050,

21304215,21304876,21305023,21305511,21306109,21308262,21310331,21310424,

21310456,21311151,21311411,21312904,21313589,21313876,21313899,21314070,

21315434,21315446,21316612,21319829,21319995,21320723,21322594,21323625,

21323854,21325287,21328080,21331263,21337830,21339679,21339858,21340610,

21340834,21342496,21342675,21342914,21343364,21345675,21345727,21345908,

21346537,21349357,21350820,21351461,21352705,21353041,21356829,21357352,

21358287,21361732,21364639,21366347,21367761,21368758,21370204,21371039,

21372407,21372452,21373646,21373692,21374397,21374556,21375375,21375389,

21377912,21378623,21379775,21381688,21382116,21383541,21383602,21383835,

21387000,21390129,21390963,21393713,21394011,21394185,21395606,21395740,

21397832,21398416,21399894,21400123,21406120,21406138,21406198,21407148,

21409607,21410141,21410782,21411964,21412523,21413058,21413972,21414812,

21415354,21417698,21420041,21420806,21421198,21421882,21422108,21424090,

21430278,21431308,21438188,21438374,21438935,21440808,21441212,21442196,

21443080,21444158,21444807,21446596,21449821,21450118,21454691,21458736,

21459359,21460728,21461296,21462592,21462773,21463123,21465763,21465939,

21466832,21466937,21467816,21472272,21472861,21472985,21473088,21474918,

21479757,21482476,21482526,21482605,21487640,21489080,21490926,21491290,

21491801,21494977,21495896,21496446,21497222,21497477,21498792,21500343,

21500400,21502086,21502767,21503748,21507344,21508804,21509550,21512724,

21514978,21515138,21515879,21516466,21516552,21517564,21518829,21520426,

21520619,21521681,21521746,21523377,21524379,21525760,21527170,21528238,

21528408,21531507,21533921,21535476,21537301,21538458,21538738,21539282,

21539739,21540153,21540790,21542939,21543614,21544694,21545668,21546175,

21548268,21549123,21549819,21551202,21552373,21552604,21552999,21555691,

21556758,21556947,21557662,21559323,21560758,21561423,21562078,21562403,

21563063,21563743,21569447,21571427,21573361,21575931,21580240,21581592,

21585687,21586510,21587619,21589095,21589860,21590758,21593611,21594540,

21594916,21595647,21596268,21599448,21603705,21605265,21606123,21607956,

21608875,21609933,21614671,21615878,21616198,21617195,21619995,21620317,

21620631,21620871,21621158,21621864,21621881,21623156,21623835,21624467,

21624840,21626423,21628654,21629128,21629978,21631059,21631940,21632246,

21632347,21635255,21638625,21640150,21642655,21648630,21648814,21649504,

21649941,21650001,21652180,21652694,21652826,21652864,21653448,21659081,

21659507,21659595,21664458,21665875,21666317,21666798,21667000,21668235,

21670861,21671613,21672823,21673318,21673524,21676716,21677439,21678789,

21681251,21682452,21683676,21684422,21685244,21685826,21686168,21686849,

21688442,21688782,21689027,21689094,21689556,21690083,21690522,21693145,

21694510,21695886,21697525,21698785,21699821,21701534,21702253,21703013,

21704140,21705563,21706112,21706283,21706902,21709052,21711077,21711162,

21713167,21713275,21714588,21717051,21717404,21718791,21723733,21724572,

21728644,21730591,21732442,21733618,21733991,21737699,21738694,21743058,

21744381,21744542,21745263,21746168,21746641,21750834,21752507,21752688,

21752787,21753329,21753789,21754518,21755380,21755806,21756320,21757787,

21760804,21761142,21764501,21767729,21769870,21770148,21771910,21773139,

21773171,21774436,21774486,21777543,21777966,21778244,21778363,21779626,

21780590,21780640,21782494,21783999,21784660,21786368,21788872,21790429,

21790642,21794311,21795021,21795867,21797795,21797967,21798825,21801644,

21803309,21804983,21805921,21806597,21806933,21807853,21808467,21809535,

21810445,21811258,21816841,21817164,21818863,21818871,21820819,21820870,

21820878,21821205,21822731,21825026,21825264,21831594,21832781,21835215,

21837102,21839298,21840048,21840498,21840846,21843239,21844114,21844163,

21846816,21846838,21847856,21850814,21851853,21853531,21857263,21858434,

21858805,21859756,21860448,21861149,21861408,21861755,21863582,21864561,

21864966,21866190,21867474,21868212,21868555,21869419,21873995,21874345,

21878292,21879717,21880508,21880709,21883596,21883761,21883967,21884196,

21885719,21886425,21890514,21891776,21895182,21895240,21895733,21896110,

21897579,21906846,21908111,21909744,21912690,21915249,21921736,21924088,

21924597,21926499,21929136,21929221,21930223,21931440,21932580,21933006,

21933830,21934778,21934908,21937133,21939030,21943247,21943430,21943456,

21953096,21953851,21954866,21955701,21957436,21961348,21961752,21964895,

21966602,21968032,21975846,21976653,21979917,21984574,22008334,22008640,

22010558,22011714,22012210,22019627,22031087,22040016,22040210,22042195,

22042334,22046206,22048979,22049171,22051805,22052422,22058183,22060778,

22061626,22062585,22064228,22066455,22068604,22073176,22074716,22078491,

22078499,22078666,22083128,22086177,22087232,22089808,22091004,22094539,

22096151,22099019,22109853,22112199,22120555,22120826,22121035,22121633,

22123746,22124194,22127908,22128367,22129941,22131851,22132684,22140707,

22140806,22140957,22145331,22145481,22149912,22150306,22150936,22152266,

22154339,22154418,22154850,22164567,22166722,22168193,22169682,22173831,

22173881,22176284,22176323,22178954,22194725,22194871,22197028,22197712,

22197737,22199108,22200271,22200588,22208390,22208726,22209177,22211835,

22220459,22220474,22224273,22228489,22237753,22239521,22240226,22241939,

22242744,22249760,22251298,22252595,22253448,22256527,22259302,22264994,

22266536,22270931,22271959,22274112,22274633,22276558,22276830,22278513,

22285957,22287343,22291633,22293719,22295782,22296352,22298389,22299624,

22301040,22306087,22307024,22308480,22312364,22313089,22314067,22316628,

22317995,22319388,22320382,22322393,22322536,22325923,22326488,22335765,

22335911,22340713,22340901,22341133,22343052,22345077,22345858,22346410,

22350200,22351475,22353332,22356442,22357268,22358243,22359416,22359576,

22365623,22373070,22377222,22377881,22378848,22378926,22381518,22385147,

22385501,22391754,22394796,22396822,22398198,22400417,22402182,22402972,

22404009,22405295,22406562,22409703,22412276,22412404,22418133,22418788,

22419490,22423224,22425473,22428847,22429788,22431290,22434203,22434320,

22434788,22438066,22442759,22443344,22444257,22447045,22451000,22457600,

22460129,22467795,22471808,22472588,22476427,22478565,22487216,22487399,

22487427,22489936,22491601,22495477,22502985,22504150,22504524,22512517,

22513263,22515348,22517716,22520918,22520974,22521289,22521681,22522490,

22523059,22524621,22530104,22531711,22531781,22534370,22536596,22537453,

22537479,22539161,22539668,22541536,22544745,22548666,22549002,22549087,

22549277,22549868,22550676,22555624,22556023,22556388,22557401,22557880,

22561360,22563928,22565951,22571689,22572481,22577133,22579238,22581480,

22582001,22585131,22590519,22590843,22591786,22595177,22597653,22597944,

22598163,22599851,22601296,22603577,22604178,22604547,22604705,22608452,

22608744,22612608,22614337,22615122,22615350,22617730,22619621,22622327,

22623666,22626999,22632462,22632638,22632709,22633434,22634093,22634100,

22634363,22637251,22638945,22639573,22640582,22641303,22643490,22646961,

22649886,22650234,22651289,22656489,22656580,22657935,22663764,22665218,

22666818,22668808,22671663,22672130,22672885,22676696,22677059,22681484,

22683608,22684489,22686218,22689620,22689621,22689765,22691199,22702089,

22709054,22711415,22715236,22722082,22726397,22728585,22728977,22732700,

22733350,22736781,22738028,22738034,22738165,22739195,22742341,22744164,

22745482,22747273,22747392,22747768,22751876,22752530,22754439,22757740,

22758810,22759939,22760609,22764313,22767140,22771063,22772323,22775392,

22775831,22776755,22777107,22777203,22777323,22777490,22779547,22784335,

22784479,22784601,22784981,22788045,22800888,22801603,22802100,22803497,

22807289,22807940,22808199,22810852,22811402,22812879,22817928,22826210,

22827486,22828362,22828731,22830851,22831711,22833442,22834171,22835533,

22835779,22836893,22839470,22842198,22842580,22846084,22846288,22848322,

22849653,22850136,22850471,22857625,22857705,22857734,22859924,22860031,

22860730,22861119,22861847,22864088,22868977,22869558,22871950,22872773,

22874986,22875546,22877383,22878049,22878654,22878669,22879664,22882243,

22883165,22884568,22887433,22887468,22888600,22889228,22893905,22895271,

22896051,22896338,22896534,22898432,22903360,22904685,22906034,22907456,

22912324,22913055,22917623,22917908,22919938,22923434,22925398,22926422,

22928716,22928802,22933604,22941398,22941443,22945049,22949396,22949518,

22953447,22955537,22956815,22957913,22961833,22968089,22968374,22971304,

22974935,22976773,22976825,22977567,22978239,22978515,22981409,22983909,

22985318,22986584,22990050,22991475,22993147,22995612,22997771,23000000,

23000555,23004124,23007130,23008696,23009336,23010521,23011290,23013309,

23018543,23021595,23022412,23029221,23030593,23034287,23035847,23037005,

23037249,23037918,23039188,23040190,23040450,23040514,23043383,23044763,

23044933,23047129,23048301,23049166,23049193,23050809,23051379,23056005,

23060126,23062981,23064740,23064757,23067165,23068335,23075053,23076179,

23077170,23079112,23079596,23083211,23084922,23085006,23090878,23094136,

23095479,23095721,23098553,23099071,23099458,23102222,23103341,23104630,

23105285,23105356,23107220,23110548,23110817,23112979,23114355,23115738,

23116750,23119730,23124722,23124865,23125160,23128608,23128705,23135653,

23137613,23144133,23145414,23145907,23146526,23146572,23147622,23149867,

23151369,23159091,23161404,23161829,23161990,23162465,23163585,23164364,

23171920,23171968,23173360,23174387,23175107,23175163,23175487,23177185,

23179745,23180229,23180764,23186298,23187276,23187350,23188351,23189821,

23194602,23195661,23195923,23196228,23198206,23198783,23201115,23207750,

23208887,23212300,23214294,23215288,23215494,23216405,23216480,23222345,

23236291,23237274,23237351,23238919,23246411,23248470,23248740,23257138,

23262218,23262243,23265316,23266737,23274907,23275293,23276951,23277839,

23278095,23278311,23278831,23283005,23283576,23285493,23287326,23294752,

23295115,23296974,23299921,23300522,23307853,23314333,23315520,23318639,

23320432,23326194,23327342,23329166,23334106,23335057,23335219,23336541,

23348893,23349273,23352417,23355395,23358856,23362919,23364567,23365476,

23374469,23377161,23377241,23377578,23387239,23389865,23398148,23399448,

23401247,23405361,23408880,23410882,23413797,23414128,23416893,23420739,

23422828,23422849,23424798,23425032,23428239,23428938,23429552,23429968,

23431286,23432542,23433919,23436089,23441302,23442437,23443770,23444760,

23449906,23450201,23450318,23451029,23453722,23460697,23461117,23461148,

23462047,23465056,23469798,23470036,23471073,23474501,23476316,23481087,

23481257,23483242,23485248,23485288,23485306,23486513,23487199,23487947,

23489009,23491582,23496994,23498277,23499907,23500032,23500342,23501384,

23505510,23507985,23512252,23515484,23519776,23519976,23524525,23525997,

23527355,23528413,23535843,23536469,23539141,23539535,23541095,23541669,

23551736,23551833,23551978,23556398,23565275,23565389,23569880,23571224,

23571643,23571957,23572625,23574972,23576799,23578854,23581719,23588386,

23590914,23594469,23594542,23594627,23595433,23598744,23599441,23601954,

23614639,23615492,23616447,23618282,23619103,23619988,23620218,23620643,

23623241,23623710,23630166,23633876,23637010,23637720,23639024,23642020,

23644370,23645326,23646510,23647128,23648667,23659624,23661158,23662647,

23664684,23664879,23666020,23669273,23670950,23673397,23674371,23677213,

23678503,23682482,23685681,23686747,23690646,23690770,23692384,23702143,

23703235,23707839,23707998,23710496,23712817,23713361,23718064,23723737,

23725384,23728166,23728608,23729818,23732796,23734011,23734220,23734599,

23735345,23736239,23737139,23737562,23737810,23739834,23741898,23745688,

23748255,23750853,23751390,23753558,23755252,23758739,23759254,23761296,

23762111,23763220,23765436,23768968,23770065,23771983,23774195,23775180,

23776874,23780675,23786352,23786866,23787227,23795387,23797512,23797715,

23800234,23800556,23803543,23804131,23804329,23805816,23808984,23809005,

23815531,23815737,23816926,23819980,23820005,23821002,23822232,23824571,

23825746,23827679,23829997,23830460,23832160,23839629,23839969,23845310,

23849720,23850238,23851427,23852165,23854157,23859069,23861948,23863110,

23865004,23865648,23866940,23869799,23871109,23872047,23873514,23875235,

23882626,23884342,23885067,23891762,23892628,23894333,23895805,23896663,

23897939,23898862,23899575,23901520,23903092,23905864,23906570,23907475,

23913602,23914831,23919455,23922045,23926214,23927985,23930587,23934003,

23938518,23941229,23942452,23945227,23945475,23948565,23951648,23951687,

23953266,23957645,23959031,23960444,23962486,23962824,23963833,23966429,

23969475,23969820,23970182,23977781,23978352,23978951,23979669,23981448,

23982065,23985232,23986579,23987251,23992275,23994444,23999330,24001563,

24002854,24004333,24008182,24012321,24013044,24016947,24017394,24018694,

24018727,24020898,24027912,24030739,24036897,24039894,24041054,24041233,

24044445,24048114,24050446,24053377,24058906,24063913,24064839,24068544,

24069009,24070341,24071916,24073466,24073978,24075099,24075203,24077936,

24080262,24087213,24092460,24094059,24094489,24100888,24101482,24104321,

24106886,24109237,24112487,24113841,24115349,24116670,24117562,24117950,

24121237,24122382,24125187,24125299,24127141,24132080,24136187,24137795,

24139154,24140433,24140805,24143218,24143230,24148460,24148985,24149028,

24156045,24159214,24160144,24160555,24162876,24164305,24167941,24168406,

24170287,24175469,24177681,24179359,24181585,24186075,24186267,24199989,

24200062,24204925,24206354,24206917,24207147,24207234,24207737,24208635,

24210468,24219721,24223271,24226132,24230520,24231271,24234369,24235952,

24237573,24239790,24243100,24245717,24248730,24248811,24252151,24252780,

24253262,24253470,24254310,24256592,24259033,24261001,24261284,24263269,

24265315,24265647,24266750,24266785,24268849,24269253,24269494,24270253,

24270592,24271269,24271798,24273171,24274236,24275433,24279709,24279850,

24281051,24282447,24289919,24290307,24291681,24299302,24300377,24305318,

24310619,24313852,24314126,24315112,24315244,24318531,24320998,24321002,

24321320,24321623,24322760,24323174,24323389,24327828,24329393,24329450,

24335498,24335554,24340726,24341267,24342367,24343680,24344424,24344970,

24346608,24348434,24350825,24351292,24353066,24355845,24360606,24360670,

24361832,24363065,24366074,24366534,24367621,24372161,24373534,24374883,

24377359,24387810,24388166,24390593,24398555,24401905,24402999,24403549,

24405454,24405913,24406559,24407067,24407922,24410275,24410400,24410750,

24416395,24419253,24421756,24421918,24427875,24428432,24428862,24430353,

24430455,24436246,24444640,24447891,24449358,24449654,24456685,24460585,

24461751,24469809,24469849,24477547,24480668,24481784,24483326,24484530,

24484990,24485341,24486738,24487709,24491397,24492002,24492211,24493694,

24498361,24499300,24500169,24501061,24501596,24502811,24504667,24508002,

24508033,24512348,24512952,24513116,24515919,24517868,24519264,24522068,

24522074,24522251,24523485,24524350,24526672,24528992,24535805,24536213,

24537013,24537571,24544211,24548737,24550447,24552218,24552776,24553829,

24558476,24559346,24562946,24563228,24564254,24564400,24565781,24566330,

24567805,24568139,24574521,24579165,24582987,24584553,24585653,24586732,

24588472,24589972,24596261,24598073,24599918,24602071,24602859,24608590,

24611646,24613700,24619723,24620442,24621143,24623285,24625049,24625156,

24627255,24628895,24631979,24632052,24633626,24635396,24639750,24643474,

24652507,24654703,24656564,24662665,24665399,24668471,24675896,24677725,

24682483,24687916,24689632,24691902,24695508,24695843,24698530,24705302,

24706733,24718172,24718388,24718723,24721920,24725342,24731466,24736674,

24741572,24747272,24771007,24773315,24774177,24778613,24787010,24789439,

24790959,24794163,24794412,24796666,24797752,24798402,24799826,24801517,

24801735,24812038,24812426,24812962,24821669,24823703,24829204,24832760,

24835914,24841518,24844794,24853148,24869606,24869647,24870860,24870915,

24877482,24877970,24878374,24878512,24878982,24880950,24885781,24886858,

24888299,24891049,24891768,24892285,24896269,24897076,24897230,24903153,

24903173,24903812,24915098,24919402,24923067,24925878,24927534,24928749,

24930084,24931397,24931715,24933670,24941993,24947180,24953496,24965536,

24969835,24977803,24983520,24991679,24992570,25003029,25009044,25013402,

25016559,25016859,25017654,25022972,25023886,25027694,25029221,25029499,

25029637,25034998,25037569,25041461,25042573,25042576,25043288,25045455,

25047171,25052795,25054283,25058402,25059784,25061312,25061477,25062535,

25063735,25066074,25066462,25067325,25093444,25093617,25093707,25094257,

25094352,25100752,25100852,25103621,25103890,25106867,25116652,25117444,

25120125,25122533,25122656,25124517,25124554,25133407,25136148,25136741,

25137294,25140659,25146394,25146958,25147257,25148589,25151159,25153857,

25154634,25166182,25168103,25177042,25177137,25180984,25182953,25188150,

25188362,25190808,25193996,25194384,25201387,25206509,25207882,25209123,

25209507,25211098,25219711,25220207,25221124,25222959,25227926,25234049,

25235138,25240266,25241770,25247420,25247450,25252330,25252877,25255196,

25264853,25265719,25267181,25269140,25269915,25270912,25271141,25271918,

25274005,25274679,25279096,25280064,25280887,25286610,25290121,25290995,

25291008,25291220,25294789,25302131,25309624,25310456,25314640,25315635,

25320231,25325641,25326213,25330100,25331439,25332119,25332139,25332148,

25340910,25342497,25346152,25349983,25352073,25354101,25356293,25358398,

25360188,25360215,25361039,25361187,25362995,25371912,25373331,25373381,

25376185,25376979,25379696,25379880,25381498,25381699,25382587,25385224,

25391627,25391656,25392406,25400201,25404262,25404341,25410685,25412535,

25413404,25414875,25416130,25416543,25420061,25428601,25431313,25432563,

25433809,25434004,25436602,25436672,25440677,25442388,25442544,25443421,

25446592,25447674,25452483,25452841,25457283,25459867,25466498,25466526,

25471656,25474009,25475557,25475977,25479232,25482135,25483320,25484761,

25488818,25491501,25501097,25501471,25501688,25505126,25506434,25508447,

25509489,25511286,25511559,25518476,25519390,25519509,25521976,25522483,

25523690,25523757,25528276,25530584,25530780,25535416,25538344,25538563,

25539876,25540432,25542642,25542956,25543645,25545605,25547203,25548077,

25553373,25556545,25560079,25562257,25563000,25563255,25564426,25564999,

25568232,25569039,25577951,25579395,25582059,25587789,25588653,25589358,

25596982,25599893,25601758,25602706,25603483,25603585,25606008,25607444,

25608322,25610725,25611010,25612477,25612507,25613592,25616946,25617940,

25617987,25619761,25625025,25625102,25627793,25629149,25633458,25634819,

25637664,25637752,25638542,25639426,25643967,25649102,25652706,25652978,

25658402,25663764,25669045,25671686,25673620,25676522,25680353,25680957,

25681941,25682145,25689658,25690356,25690582,25696886,25699383,25701792,

25702798,25709114,25713576,25714004,25714140,25714171,25716199,25721306,

25721490,25722006,25722563,25723791,25724030,25727129,25727758,25729147,

25731257,25733133,25735372,25736369,25736370,25737740,25738991,25739224,

25739236,25739245,25739701,25742177,25748829,25749617,25754192,25757523,

25764302,25768673,25771923,25771936,25773991,25774139,25776260,25777057,

25777757,25777830,25780064,25780993,25781797,25782409,25785764,25792737,

25793650,25795745,25797019,25802465,25803941,25804339,25809152,25812203,

25818140,25819323,25820411,25821511,25824467,25830045,25832965,25833502,

25835674,25837385,25840092,25841398,25844825,25846491,25846695,25847501,

25849899,25850549,25851661,25851676,25856292,25857933,25859633,25862313,

25864232,25866225,25868379,25868924,25869856,25870349,25870896,25876135,

25876965,25877136,25878169,25880472,25884904,25887009,25891365,25896940,

25897097,25897560,25901056,25907358,25909824,25910463,25914906,25916996,

25918621,25919295,25920143,25920907,25923238,25925609,25926128,25927667,

25930822,25932514,25936744,25937302,25938048,25939242,25939601,25942732,

25943952,25945719,25956164,25959191,25963614,25964545,25965997,25967281,

25969342,25971729,25976018,25977910,25977978,25978478,25980261,25991131,

25992264,25993519,25994635,25997081,25998241,25998964,25999101,25999786,

26003916,26008018,26009631,26010822,26011370,26011624,26013473,26015190,

26016038,26017823,26020352,26020997,26022077,26023651,26026477,26027964,

26031307,26032485,26032994,26033934,26034386,26035365,26039521,26040077,

26041587,26042448,26043722,26044021,26048705,26050361,26054411,26054639,

26057591,26057922,26058565,26060786,26060848,26060875,26061221,26064592,

26071144,26072832,26073313,26073722,26074151,26075877,26075897,26076346,

26078999,26082908,26083931,26088339,26094945,26098358,26098496,26099120,

26100103,26100645,26100753,26104766,26106324,26109686,26110696,26113005,

26113937,26114731,26116834,26118687,26118783,26118843,26127051,26127434,

26128248,26128368,26128640,26129968,26130268,26134070,26135495,26136043,

26139487,26140449,26141511,26141554,26141756,26142263,26144501,26146600,

26149720,26150076,26150172,26161800,26168732,26172242,26174427,26175546,

26179799,26184274,26184299,26184676,26185062,26185807,26185824,26185844,

26187416,26188758,26190202,26194249,26194252,26194781,26195465,26198056,

26198733,26203363,26203965,26207995,26208159,26211514,26212744,26214571,

26215748,26217162,26218787,26222080,26224691,26227886,26231737,26233276,

26234953,26236361,26236421,26236804,26240210,26240521,26243532,26245753,

26248705,26249654,26250453,26252026,26269590,26272716,26274206,26278634,

26285500,26285555,26286503,26291280,26292245,26292707,26292952,26293326,

26295768,26298723,26298894,26299357,26301490,26301586,26301921,26303010,

26303422,26305040,26319564,26321309,26323496,26325100,26326092,26329020,

26330599,26332323,26334157,26338885,26342767,26344164,26344286,26347931,

26348158,26351108,26352381,26355533,26358930,26362137,26362212,26362728,

26365599,26369079,26376332,26380585,26386571,26391060,26391639,26393797,

26398660,26399282,26408466,26418377,26425266,26428418,26431219,26434113,

26434990,26435964,26439461,26440494,26448150,26449470,26449835,26451431,

26451970,26459936,26460455,26461026,26462202,26463631,26467979,26470196,

26472242,26473097,26473381,26482039,26485173,26485307,26485661,26486623,

26490224,26491647,26493542,26496308,26497142,26507523,26513277,26517923,

26519320,26523900,26527643,26530922,26533147,26533235,26535374,26536484,

26537959,26538742,26540910,26542584,26543546,26544978,26547760,26549733,

26551807,26555020,26558281,26563260,26565098,26565692,26567099,26568447,

26570200,26576324,26579753,26581133,26584507,26596867,26608852,26616368,

26618120,26621475,26621596,26621709,26621756,26622170,26626752,26626935,

26635666,26638500,26638926,26639728,26641473,26645843,26654741,26657568,

26658080,26658843,26661594,26664591,26670050,26670474,26672279,26675738,

26677019,26677594,26679457,26681582,26682082,26684463,26688298,26688472,

26697418,26701184,26701810,26705590,26710147,26713627,26714860,26714932,

26715221,26716500,26717361,26717622,26719116,26720460,26725419,26726193,

26727145,26732142,26736903,26739551,26740512,26741722,26747734,26749294,

26749519,26751024,26752535,26753455,26758068,26758269,26763695,26765354,

26765377,26766556,26767468,26768027,26771115,26775986,26778501,26778615,

26780745,26782793,26783476,26785062,26785217,26789854,26793843,26794288,

26798204,26798733,26800080,26803981,26804756,26806162,26814144,26815454,

26816499,26817845,26822802,26823116,26825960,26830382,26830411,26834047,

26834337,26838012,26839818,26840386,26840736,26845894,26847585,26847959,

26848148,26848882,26849763,26850350,26851933,26855241,26855538,26860806,

26861012,26863438,26863890,26866802,26867021,26867111,26867159,26870971,

26875634,26876436,26876444,26883893,26888352,26891289,26893976,26900654,

26905243,26906394,26907063,26909938,26910779,26915040,26926014,26928302,

26932540,26936583,26937987,26939980,26941810,26951022,26952028,26958612,

26960504,26960688,26962763,26965886,26970773,26971788,26973157,26979746,

26979807,26981020,26981051,26990635,26992891,26993873,26993964,26998751,

27002374,27010162,27010810,27013279,27021450,27032296,27039515,27039820,

27044510,27045933,27051520,27065623,27065928,27067052,27076744,27081040,

27082778,27089356,27089526,27090798,27091652,27094866,27097887,27104496,

27105730,27113204,27118541,27119222,27123476,27127158,27130927,27131496,

27135617,27140317,27145427,27147320,27147331,27147342,27151069,27153225,

27158364,27170445,27172359,27173110,27173121,27176149,27176336,27176441,

27177311,27182714,27183234,27187220,27187759,27196485,27200041,27200870,

27201043,27203030,27203482,27211040,27212416,27215445,27216374,27222354,

27229173,27231736,27231798,27237713,27238502,27241079,27241585,27245202,

27250178,27251953,27253283,27254435,27258395,27258758,27259417,27261661,

27264047,27265457,27271082,27271372,27273818,27292276,27292486,27292788,

27296073,27302070,27306273,27307561,27308715,27314488,27317726,27321231,

27324575,27325165,27327209,27327467,27328616,27329178,27329315,27329372,

27329960,27336588,27343536,27345221,27348289,27351381,27358151,27360059,

27362549,27365360,27366138,27366792,27369643,27374179,27374187,27380517,

27382345,27383116,27385272,27385516,27386827,27387594,27388749,27398670,

27400922,27402407,27404024,27412628,27413045,27423628,27433259,27442853,

27445277,27448872,27454814,27456866,27464405,27468380,27470640,27471768,

27471962,27472061,27481818,27481985,27484617,27491483,27491624,27494254,

27494627,27496036,27498385,27503035,27504587,27506812,27509386,27514631,

27515885,27516189,27517208,27517266,27518159,27524448,27530881,27531054,

27531635,27534649,27534723,27536002,27538975,27543036,27543699,27547149,

27549271,27549889,27555191,27557636,27559949,27564949,27565882,27566413,

27574118,27575654,27577686,27580941,27583453,27583747,27588801,27591598,

27596425,27597757,27598246,27601884,27604025,27612457,27613498,27615589,

27619133,27619701,27620051,27622901,27624080,27626269,27626790,27629777,

27643679,27645838,27649072,27650417,27650973,27662779,27665740,27670413,

27671189,27671255,27671769,27673706,27673775,27678155,27678645,27681323,

27682281,27682989,27688914,27691986,27712740,27713632,27716511,27723399,

27728885,27740301,27750128,27753656,27756987,27760910,27763972,27766180,

27773876,27775093,27775339,27778526,27778772,27792431,27793519,27796750,

27800951,27812650,27816709,27819144,27825061,27844998,27846615,27871940,

27882960,27890739,27891597,27898804,27909526,27917421,27917742,27920856,

27931432

        )

        AND log_type='patrol'

        AND log_deleted = 0

        AND log_params NOT LIKE '%::auto";i:1%'

    GROUP BY log_user

) log_minmax

LEFT JOIN `user` ON log_user = user_id

LEFT JOIN ipblocks_ipindex ON ipb_user = log_user;

​