Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
Cryptic
.
Toggle Highlighting
SQL
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;
By running queries you agree to the
Cloud Services Terms of Use
and you irrevocably agree to release your SQL under
CC0 License
.
Submit Query
Stop Query
All SQL code is licensed under
CC0 License
.
Checking query status...
