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 ( -- first 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; 2,32,79,325,1219,1228,1398,1671,3808,3861,4259,4295,4323,4375,4626,4709,4718, 5094,5705,5894,5939,6468,6525,6549,6627,6707,6815,6827,6995,7513,7651,7724, 7872,7891,8238,8780,8834,8881,9384,9867,10059,10096,10559,10795,11096,11304, 11639,12176,13662,14515,14772,15130,15138,15476,15708,16276,16710,16945,17024, 19217,19235,19527,19556,19634,20134,20318,20329,20551,20855,21085,21804,23407, 23999,24835,24902,25824,26248,26576,26606,26670,26726,28291,28422,28438,28443, 28478,29695,30410,31706,31749,31962,32161,32233,32348,33145,34431,34467,35228, 35592,35752,36171,36352,36389,38027,38198,38427,38455,39569,39643,41050,41723, 42464,42558,42580,42630,42667,42878,43152,43393,44062,44476,44656,44846,45130, 45998,46097,46403,46515,46555,47960,48143,48198,49031,49272,50230,51070,51336, 51623,52387,52585,52706,53396,53685,54119,54381,54656,54809,55327,55582,55983, 56173,56293,56360,57658,57673,58781,59002,59005,59944,60409,61383,61920,62026, 62058,62411,63405,64897,65885,66028,66074,66197,66971,67221,67616,68411,68432, 69942,70142,71699,72441,73576,73802,74301,74414,74615,75230,75266,75312,75349, 75447,75651,77741,78380,80653,80913,81374,82348,82432,82697,82835,82982,83057, 83491,83813,84417,84755,84951,85019,85121,85193,85402,85952,85985,86076,86163, 86247,87814,87950,88026,88858,89053,90173,90232,90397,90672,91825,92457,92583, 93027,93143,93482,93594,93602,94871,94900,95756,97232,97994,98883,98915,99342, 100426,101140,101805,102066,103044,103683,105537,106922,107709,107928,107930, 108244,108284,108403,108474,109364,110228,110615,111277,111392,111640,111996, 113336,113850,113936,114643,114797,114828,114988,116143,117331,117878,118817, 119367,119438,119550,119631,120801,120856,121051,121065,121745,122305,122579, 123395,124142,124152,125459,125787,126457,128863,128887,129409,130326,133598, 134874,134937,135485,135518,136864,136926,137673,137905,138242,138511,139380, 141088,141654,141662,141808,141889,142761,142887,143982,144049,145334,145374, 145620,145988,146006,146242,146418,147410,149466,149553,150159,150564,151693, 152070,152390,152627,152983,153672,154630,154639,154881,154959,154991,156441, 156494,156661,158361,158840,158856,159678,160565,161142,161335,161571,161900, 162296,162316,162458,163732,163904,164796,164876,167898,170099,171039,171365, 174834,179697,180736,182902,183721,184162,186578,186638,187286,188122,190068, 191757,191875,194203,195496,196269,196446,196471,196704,198562,199747,200029, 200216,200402,200762,201466,201578,201985,202276,202394,202725,203786,203887, 204282,205121,205136,205944,206485,206667,207517,207616,208643,210028,210259, 210954,211728,211771,211905,212671,213194,214232,214427,217736,218499,218586, 218593,219819,220941,221304,221315,222351,224548,224960,225885,227059,227287, 230475,230800,234433,235019,236191,236339,238154,238943,239144,241387,242472, 243277,243824,244263,244558,244713,245519,246230,246943,247089,247968,251183, 251194,251228,252195,252497,253891,254361,254396,256129,256343,258000,262194, 262550,262665,262666,262675,262716,263324,263660,264323,265769,266404,269410, 269540,269651,270405,270413,271376,272143,272397,273437,274040,274748,275202, 276321,277086,277419,277855,278097,278352,280219,281675,282003,282582,283225, 283313,286305,287452,288189,290446,291848,291884,292494,293035,294121,294180, 294421,294809,295080,295268,295294,295379,297315,299408,299667,300735,300891, 301395,302229,302457,304201,305208,305540,306522,306721,308420,310131,311316, 312314,313197,314721,315483,317119,317487,318807,319064,320236,320419,320497, 322083,322936,322970,323105,325157,326384,327289,327763,329633,329764,329948, 332841,333857,334887,335180,336266,336292,336750,339081,339307,339722,340520, 342151,342538,342579,343862,343908,344384,346148,346308,346341,346608,346899, 348139,355131,355421,356335,356802,357239,358166,358790,358952,359256,359672, 361241,362688,363486,363532,365454,366915,367244,368478,370177,372114,372176, 372290,372693,373051,374195,375476,375843,376014,376297,377389,378147,379243, 380382,381401,382104,385837,386329,390477,390688,395969,397881,398607,399105, 400620,403055,403690,404352,408438,409043,409480,410898,410906,411305,412108, 413441,413716,414836,415269,415892,416036,416184,416811,417165,417659,418835, 418883,419948,422470,422817,422965,426156,427930,428690,431183,434069,434947, 440277,440367,440493,440583,442169,442189,442506,443715,444985,446342,446383, 449918,451287,453528,454640,454738,455421,455767,455783,455895,456058,458825, 459113,459815,459990,461300,461626,462702,463186,465682,466673,467815,468669, 468921,469625,470876,471296,471697,472593,473485,473546,479129,479511,486822, 488581,491491,491706,492056,492858,492929,493489,493807,498261,500937,502540, 502570,503067,503489,504717,505048,505774,506179,506765,507945,508734,509743, 510644,511813,513060,516856,518794,522013,523543,523832,523968,524544,530793, 531146,531868,532775,533131,536310,536375,539091,541218,543434,544060,544955, 545807,546309,548527,549980,550273,551385,553121,553489,555103,555794,559411, 560483,560563,561069,561624,563447,564195,564248,568400,568832,569802,570614, 570899,573321,575347,575617,576715,577432,580188,585074,590466,590476,594997, 595371,596246,596947,601623,602293,602857,607923,609896,611413,612255,612302, 612714,613068,613239,613658,613755,617133,617391,618430,621070,622881,623903, 631250,633604,634828,635323,635392,637954,639331,641784,643450,646348,646386, 647822,650981,654492,662485,663333,664832,665998,668422,669117,676502,678051, 680711,686510,687767,689041,691571,696422,700659,702940,703908,703949,704854, 706400,707950,710296,712163,713320,713860,715048,715453,715541,715877,715966, 716411,718875,719387,722418,724747,725438,726851,728168,728889,729854,730865, 734270,734297,735031,735670,735741,735937,736168,736651,736808,738200,740137, 741292,744883,746004,748005,749357,751266,753413,753665,754619,754987,755833, 758848,759211,760284,764027,764407,764600,766819,768350,768864,770058,773061, 776083,776137,777647,777667,780337,784330,787652,788408,793681,794371,798278, 800815,801435,803092,808676,808814,811676,811979,814993,815376,818523,820190, 821734,822615,822619,822851,822998,823324,824270,824323,829230,829440,829539, 829880,831435,833510,834412,835170,835495,836656,839494,840789,843730,847224, 847895,848043,853204,854140,855858,857337,858079,861016,861759,863874,869245, 869314,869479,869482,869916,873244,873891,878293,888093,888512,889851,893398, 894320,897312,897376,900614,901576,903118,903354,910180,911178,915791,917223, 919199,920547,921080,928626,931155,933359,933931,935793,937448,937895,940017, 940655,944768,948213,960841,962129,964805,966206,966714,974947,975209,981967, 981985,983723,985645,985877,990214,990513,991331,992600,997349,1000453,1004750, 1005449,1008048,1009265,1010851,1010995,1014218,1024002,1025532,1027847, 1028619,1032318,1033828,1034525,1046972,1049234,1050951,1057393,1062840, 1063872,1069316,1075732,1077292,1083792,1084125,1091044,1096414,1100050, 1100608,1105412,1108424,1115773,1116156,1120423,1120646,1123676,1128661, 1129948,1130897,1133423,1138432,1141672,1143897,1143953,1148396,1148557, 1148898,1150136,1153711,1156526,1159655,1160434,1168278,1168534,1168880, 1169249,1171346,1176363,1179151,1179460,1183239,1184287,1185362,1189662, 1192678,1193764,1195998,1198398,1207886,1210442,1211084,1211601,1211616, 1211834,1213535,1218696,1219841,1220790,1222043,1224466,1224855,1225654, 1241000,1241103,1247087,1249282,1254795,1255878,1257382,1257855,1260683, 1264145,1265352,1266298,1267919,1274395,1276024,1278576,1279278,1282822, 1283263,1286970,1292656,1293253,1294969,1295607,1300609,1304678,1305296, 1306352,1307262,1313011,1316000,1326640,1328392,1328636,1329099,1330920, 1337739,1349228,1350160,1351252,1354950,1355960,1357356,1361237,1368779, 1371800,1376828,1378174,1378652,1379000,1380135,1381068,1382933,1386856, 1387875,1393471,1399437,1403682,1409745,1412854,1414762,1416178,1416400, 1416509,1417566,1419765,1426328,1435500,1438564,1439953,1441543,1443042, 1448822,1449318,1452133,1453997,1455149,1456073,1461430,1464754,1469567, 1470097,1473122,1473712,1476295,1476858,1481604,1487243,1489846,1492328, 1498322,1500731,1505764,1505925,1513661,1514746,1515891,1521335,1522322, 1524034,1526134,1526960,1529149,1532327,1536919,1540109,1542163,1543536, 1544984,1552321,1554842,1556306,1559168,1563886,1569062,1570001,1571992, 1575358,1576422,1587350,1587393,1588193,1590599,1592016,1593681,1594127, 1597144,1600053,1603072,1604979,1606041,1607861,1609549,1611404,1611689, 1611724,1612789,1613900,1614035,1614547,1615352,1616157,1616973,1623918, 1624037,1625407,1634146,1636825,1640548,1642792,1646408,1647583,1648657, 1648777,1652336,1653101,1659234,1659925,1661156,1661619,1663062,1664932, 1667699,1668905,1669452,1671227,1672312,1672698,1673502,1676211,1677683, 1682577,1691527,1694687,1694717,1715997,1719268,1721700,1723027,1731111, 1733357,1734174,1738140,1739907,1743697,1744116,1752894,1752945,1755837, 1759604,1759632,1763353,1767038,1770706,1774010,1776566,1779282,1783871, 1784495,1789016,1792248,1797816,1799532,1808194,1812441,1813857,1814098, 1814638,1819986,1826119,1826888,1827336,1828037,1829761,1830371,1832022, 1839637,1839933,1840598,1843661,1843750,1844572,1847279,1852218,1862829, 1865063,1870314,1874255,1884088,1886647,1891867,1892257,1893265,1894081, 1898454,1900038,1902526,1902946,1904358,1904640,1906857,1907991,1909773, 1918920,1920374,1921264,1921554,1922408,1923336,1925080,1925612,1934512, 1934735,1935381,1935511,1938651,1943537,1944879,1955864,1956066,1957350, 1957748,1957903,1959624,1959764,1960810,1964288,1969151,1977478,1981037, 1988889,1992122,1998764,1998842,2001020,2001529,2001676,2004589,2006701, 2012100,2014857,2015180,2016996,2025969,2032457,2037453,2039177,2043211, 2043601,2047841,2051880,2057630,2058715,2065910,2066205,2067592,2068487, 2080147,2081562,2083213,2083469,2092344,2093199,2095368,2096436,2096716, 2101300,2104602,2106498,2111516,2115180,2116232,2121950,2126435,2129894, 2134918,2136008,2143840,2149194,2153309,2153821,2156218,2157954,2160723, 2164108,2165801,2167510,2180382,2189852,2192430,2195431,2201050,2203608, 2215415,2217514,2218085,2224404,2236783,2237864,2246483,2246992,2250766, 2251138,2255048,2255067,2259739,2267145,2267950,2273199,2278355,2298426, 2299237,2300266,2300502,2301320,2305374,2312902,2314157,2315573,2319988, 2320088,2320974,2325890,2326220,2327349,2327880,2330517,2343473,2350574, 2359527,2360782,2361977,2364714,2368277,2370145,2377922,2378092,2378969, 2379078,2381190,2381665,2387872,2387886,2389322,2390156,2393203,2396848, 2397689,2399024,2421492,2424382,2425663,2428506,2429012,2436180,2442186, 2449701,2469229,2483029,2483182,2484495,2489164,2489738,2512606,2515906, 2524922,2530149,2532707,2543303,2546474,2552569,2557327,2559432,2563820, 2566603,2572536,2575781,2576398,2584239,2584454,2592184,2602832,2613146, 2615838,2619078,2627928,2629691,2639797,2653048,2654496,2656885,2657886, 2664833,2666701,2667265,2669838,2673156,2683707,2687020,2690886,2692801, 2695782,2697237,2697759,2711260,2711598,2711768,2715594,2719357,2723793, 2724330,2731577,2734516,2738115,2766075,2767700,2771432,2777171,2779825, 2783292,2790558,2790592,2790757,2790857,2792657,2793164,2797907,2803694, 2813280,2820395,2822114,2824367,2841483,2842084,2853673,2863166,2877947, 2884580,2886642,2887301,2895456,2897717,2901026,2903288,2903722,2904170, 2909459,2921886,2922608,2922800,2924669,2927383,2929129,2929427,2943066, 2943983,2945161,2946795,2952402,2959053,2961577,2966869,2970138,2970597, 2992972,2995463,3000221,3001312,3002016,3004667,3011647,3012956,3016489, 3020778,3022076,3030741,3035650,3037228,3045327,3046455,3049367,3050953, 3054036,3065507,3070596,3072955,3077044,3080493,3080835,3082175,3082313, 3090517,3095329,3102801,3107162,3115846,3116621,3127387,3131428,3132940, 3133656,3134537,3135337,3139350,3150999,3158216,3158744,3161462,3162235, 3166830,3167251,3170772,3174456,3185451,3187858,3188090,3192076,3213752, 3222404,3223018,3231273,3236687,3240788,3245363,3247602,3268385,3275889, 3277244,3299145,3299614,3308922,3311318,3326310,3329621,3335311,3349235, 3358555,3370936,3381536,3392400,3412058,3430766,3435198,3441262,3444918, 3488865,3491839,3495083,3497133,3516226,3517150,3533381,3537067,3546089, 3571124,3578668,3585009,3587452,3590157,3594372,3596390,3596959,3597755, 3604491,3604657,3606755,3609594,3610436,3611151,3619293,3625343,3631789, 3632083,3637572,3641944,3642437,3647339,3653410,3660044,3661969,3672900, 3681258,3683078,3687005,3690042,3690382,3696489,3704851,3705239,3727527, 3729738,3736169,3738691,3742946,3744755,3761856,3761899,3771207,3787383, 3790390,3801322,3804503,3810713,3810835,3815666,3834462,3840087,3855926, 3856907,3858451,3862612,3873382,3873517,3881651,3882558,3887259,3911291, 3913850,3937515,3938714,3955768,3957791,3959530,3959919,3969442,3974252, 3977674,3980678,3981679,3982375,3997477,3998747,4007668,4015543,4017383, 4022432,4023915,4024233,4033135,4033245,4036251,4037824,4041712,4045206, 4049877,4058581,4064894,4066002,4066845,4069147,4071608,4076676,4078461, 4079085,4081329,4082870,4088067,4088632,4110769,4120571,4127612,4127816, 4151965,4156654,4156945,4168824,4174864,4179294,4179764,4182662,4184483, 4193689,4200934,4203743,4207917,4228749,4237321,4256785,4262380,4264700, 4279454,4279848,4282029,4282335,4285490,4287536,4288359,4289859,4294318, 4294649,4296922,4299108,4302594,4309737,4310523,4315482,4319149,4322911, 4328601,4331236,4334579,4339691,4358157,4359080,4373394,4379563,4381155, 4400544,4404533,4424837,4435247,4451721,4452763,4454776,4456044,4459901, 4460308,4466297,4483726,4493105,4493626,4495930,4499498,4501031,4501797, 4503828,4504002,4507268,4511218,4511460,4513085,4513618,4515346,4517787, 4529251,4541338,4548415,4554189,4555919,4562786,4564448,4569488,4571676, 4576760,4578319,4600476,4602563,4605946,4609058,4619410,4625312,4626582, 4637213,4640081,4642289,4643363,4649353,4649642,4652171,4670490,4674808, 4679727,4688754,4699368,4706604,4707421,4708675,4711431,4720106,4724834, 4730495,4738001,4746191,4748910,4753040,4754841,4756724,4758066,4761363, 4772123,4777634,4779744,4782151,4782567,4788526,4789749,4794943,4832855, 4842600,4850051,4850380,4859457,4863204,4870483,4871659,4874564,4885781, 4894531,4897226,4898300,4902328,4906524,4915101,4919722,4921533,4948354, 4953758,4959778,4967956,4968133,4984038,4985989,4991781,4995849,5011094, 5014595,5015256,5019622,5042921,5043812,5048054,5051651,5062426,5077077, 5080862,5086163,5113069,5119202,5119758,5120254,5121857,5122755,5132209, 5134192,5137495,5148528,5153975,5175353,5181812,5183450,5195920,5197671, 5197800,5198985,5200153,5204226,5214251,5222002,5223752,5225503,5227788, 5228525,5236723,5238361,5243703,5253460,5254354,5277801,5284075,5287987, 5288432,5300635,5303045,5305553,5311630,5328870,5333362,5338638,5347098, 5358734,5360838,5367171,5369523,5379071,5389659,5402993,5424503,5427160, 5431286,5450916,5452240,5462680,5465311,5471367,5482172,5490874,5495364, 5495886,5496366,5498730,5498907,5499713,5513235,5515357,5515781,5519174, 5532431,5558684,5559148,5561369,5564406,5571880,5577240,5583074,5593251, 5607191,5608681,5615802,5627478,5632092,5637167,5638216,5649451,5656115, 5656425,5661201,5661725,5670051,5674692,5680311,5691196,5692371,5697725, 5698254,5705213,5708931,5711305,5716260,5720013,5724179,5725242,5732081, 5745932,5748532,5749625,5753911,5759406,5764251,5776276,5792322,5793523, 5795695,5800086,5803135,5811002,5813927,5816594,5831119,5832140,5840535, 5849474,5849737,5851537,5860794,5871651,5878450,5879957,5886041,5894054, 5897226,5899783,5918582,5924834,5929425,5938218,5939267,5950998,5958044, 5958709,5965514,5972226,5977441,5979048,5979608,5985031,5993513,5996039, 6003195,6005708,6012230,6012516,6015768,6020287,6028820,6032993,6034506, 6036791,6036800,6041953,6046731,6053519,6054452,6066901,6068355,6073318, 6076234,6081434,6082273,6105166,6108001,6109810,6112901,6114512,6127189, 6131571,6150386,6151339,6153021,6153888,6155850,6156391,6159787,6169056, 6179713,6180217,6188256,6196463,6200168,6206690,6209803,6210421,6216240, 6230600,6239596,6246805,6255714,6261166,6264975,6267612,6272462,6274343, 6277327,6277621,6278275,6282205,6282417,6289403,6291052,6291171,6301055, 6303058,6312554,6314613,6315995,6320921,6326132,6331772,6334690,6336020, 6350448,6357557,6361851,6374305,6379643,6381306,6383155,6391508,6393447, 6394329,6396742,6402792,6413170,6414974,6419814,6433977,6454287,6457542, 6468168,6469902,6479619,6479630,6484069,6496196,6498778,6515696,6524670, 6527521,6527865,6530726,6534694,6538028,6547367,6555357,6560557,6561336, 6570686,6572977,6576147,6592709,6603956,6604420,6606261,6610477,6641796, 6643015,6660588,6665087,6668171,6672742,6682565,6696629,6711680,6727347, 6730078,6734666,6736011,6747374,6750954,6754129,6756741,6757696,6758766, 6773014,6774658,6778186,6782876,6798958,6804626,6809426,6809847,6826296, 6830819,6833051,6839963,6841850,6844725,6846897,6847637,6849511,6853769, 6855044,6857411,6860785,6869042,6871414,6875864,6875881,6877747,6886294, 6889998,6890600,6893793,6894576,6895035,6895866,6901194,6905252,6912240, 6912407,6912611,6917124,6923766,6927073,6930350,6930888,6935794,6938174, 6943410,6945735,6947808,6951863,6954095,6954605,6959733,6982000,6992460, 6999039,7007500,7010854,7011023,7011229,7021207,7021758,7024869,7029908, 7030996,7033147,7034620,7038407,7039405,7043362,7044616,7047460,7048413, 7062582,7062844,7088710,7097041,7098284,7099464,7107365,7108688,7125848, 7125896,7126990,7128128,7131173,7150114,7162600,7169912,7172521,7181920, 7186099,7190686,7193635,7196877,7199096,7200925,7201161,7209796,7214464, 7215285,7217917,7218119,7219979,7224135,7226930,7228236,7230848,7231161, 7236233,7237002,7237846,7259552,7263487,7263891,7264712,7269807,7271780, 7274040,7275117,7276012,7276656,7282073,7291004,7291611,7293201,7302427, 7304264,7307488,7310326,7312124,7312268,7314183,7318047,7318848,7324918, 7329773,7332659,7335803,7338423,7339810,7339986,7342157,7344373,7357081, 7357706,7362014,7370599,7393172,7397251,7407280,7408352,7418060,7421360, 7422188,7425042,7434902,7441463,7442243,7446871,7447121,7447956,7448284, 7460963,7465828,7468172,7469672,7470528,7471647,7479430,7480926,7480977, 7481451,7487568,7487822,7491890,7501814,7503764,7505908,7511291,7516394, 7517952,7523308,7525266,7529026,7540369,7572659,7573298,7583140,7587302, 7590229,7592629,7614868,7623302,7625905,7626859,7627388,7627571,7632366, 7635045,7638192,7641765,7643502,7646755,7656057,7662659,7664402,7666484, 7671749,7681380,7694628,7695308,7695475,7697935,7699408,7701499,7704124, 7704631,7713040,7730353,7735868,7740522,7747859,7748202,7748701,7756497, 7757377,7758676,7759401,7789374,7792240,7798562,7799163,7802682,7804507, 7805876,7818389,7821268,7828936,7830073,7835102,7845098,7848135,7851196, 7852030,7867282,7870289,7870967,7880286,7883758,7888671,7902442,7913467, 7918883,7918964,7926446,7948812,7980091,7997523,8005368,8014785,8019733, 8024439,8034212,8035165,8036726,8040687,8043052,8044761,8065172,8085569, 8085764,8087883,8088309,8114112,8114160,8131502,8144267,8155960,8156641, 8156775,8158242,8166376,8168137,8170960,8184661,8199704,8209418,8212275, 8214624,8218691,8220586,8226145,8237037,8240947,8246417,8259432,8260261, 8264159,8271180,8271874,8281842,8291214,8294396,8296445,8297125,8309822, 8315588,8318174,8323262,8327479,8327744,8330928,8331790,8339014,8339508, 8341218,8356159,8356162,8363265,8367391,8368770,8371165,8372814,8373762, 8383027,8390765,8400631,8409334,8410551,8414284,8417518,8425369,8425398, 8431555,8434909,8444632,8451545,8454797,8462317,8472109,8474250,8477986, 8488664,8494613,8498608,8500787,8504616,8509776,8515513,8524405,8524693, 8542360,8544547,8554345,8559805,8560991,8565473,8567476,8586922,8589524, 8590318,8596147,8606792,8610216,8611321,8619853,8626764,8635829,8638440, 8639916,8641695,8646782,8647562,8671586,8672422,8672553,8673548,8681972, 8698669,8699697,8713122,8716944,8721340,8731061,8735322,8741882,8752331, 8754091,8757051,8761060,8764017,8765136,8765358,8776305,8780931,8786164, 8787860,8792492,8808142,8819760,8824132,8824221,8835102,8844476,8870376, 8876600,8881879,8888707,8890439,8900236,8909127,8919388,8924507,8929032, 8930022,8931761,8934089,8934480,8939809,8956362,8959434,8960895,8962702, 8964560,8971613,8973005,8973808,8974745,8975611,8989485,8992730,9010202, 9014223,9036255,9040800,9041194,9041631,9048060,9054615,9055911,9056972, 9078664,9080397,9091958,9092818,9098417,9105202,9109237,9123391,9125508, 9128566,9142724,9143093,9161489,9167177,9190599,9191732,9198768,9203640, 9210971,9211605,9212959,9213230,9213878,9218543,9245468,9245925,9259639, 9287752,9293171,9311688,9324631,9324653,9333421,9335597,9336033,9342553, 9344046,9345962,9346035,9351162,9355428,9359131,9366145,9371326,9383924, 9389263,9396137,9396895,9397406,9411545,9412053,9412278,9420339,9423867, 9438818,9447280,9447857,9457816,9467159,9481820,9483991,9487478,9489340, 9491027,9499232,9501128,9505858,9514280,9516106,9518778,9523002,9529274, 9533323,9533576,9535527,9542239,9555110,9560390,9575782,9577648,9582401, 9591865,9593405,9601967,9607385,9612106,9624322,9627578,9633942,9637402, 9639277,9644896,9654655,9661331,9666801,9668760,9672904,9674144,9676078, 9676170,9696476,9698266,9699525,9702053,9703281,9709211,9718339,9719015, 9748276,9748448,9753772,9760120,9768958,9776336,9777393,9784415,9785241, 9787479,9788838,9789925,9790634,9798395,9801177,9803248,9806113,9809382, 9813860,9822501,9830053,9834048,9839650,9840310,9845289,9856656,9864822, 9867550,9868104,9882671,9884969,9887272,9904058,9910344,9911813,9913007, 9913346,9921600,9937763,9941302,9949312,9950568,9951654,9961776,9963582, 9964843,9967951,9994335,10000761,10006598,10007579,10023696,10036982,10038452, 10039845,10044298,10051232,10064920,10067729,10072481,10078010,10082644, 10092544,10093430,10098414,10101798,10102627,10108709,10125192,10130725, 10146143,10152666,10174985,10186073,10188896,10190823,10207186,10208062, 10227999,10236113,10239913,10240316,10241801,10244607,10248457,10252293, 10260252,10262661,10270361,10274643,10282126,10290016,10296900,10302502, 10303231,10316096,10321398,10322045,10333458,10338752,10345689,10357594, 10357855,10358129,10366743,10370269,10371471,10373262,10389498,10390326, 10391205,10394083,10394791,10400497,10401532,10402612,10405052,10426732, 10431069,10440891,10450260,10451630,10458246,10463062,10466085,10467652, 10475336,10486095,10494354,10501628,10504977,10510782,10510983,10511032, 10517566,10523190,10534893,10539714,10543986,10549810,10551308,10555026, 10555754,10556063,10558628,10561041,10567460,10568707,10571688,10574408, 10574558,10590802,10597133,10603863,10604810,10612139,10612363,10614517, 10614794,10624087,10639536,10641707,10646449,10651216,10657529,10660289, 10663283,10668626,10678181,10678909,10689882,10699935,10712930,10720492, 10722519,10727795,10728040,10729203,10734192,10735684,10744614,10745446, 10749125,10754397,10755432,10757703,10770775,10773272,10781844,10789298, 10792059,10801051,10804966,10806116,10808414,10808929,10809687,10823618, 10829383,10835753,10839994,10846722,10849703,10860986,10861155,10864331, 10866529,10867422,10869079,10871381,10872741,10877154,10878251,10879212, 10899569,10903890,10904524,10913857,10918436,10924181,10927030,10929479, 10934912,10938973,10946732,10948993,10951369,10951666,10952742,10954699, 10959119,10962546,10962742,10962883,10963479,10966468,10967116,10975320, 10981247,10984523,10984587,10996466,11007101,11015197,11015985,11025703, 11026939,11028852,11041638,11049176,11059794,11064533,11073905,11079571, 11082368,11086989,11097939,11104969,11106367,11112747,11116033,11116442, 11124700,11125911,11127842,11137213,11153903,11155033,11168476,11174014, 11176416,11177516,11184537,11188221,11219727,11222179,11222388,11223957, 11225276,11226188,11241628,11247779,11248763,11249801,11250684,11258621, 11259091,11263730,11266649,11280893,11281792,11283673,11289927,11295309, 11296535,11307718,11308236,11308516,11309017,11312068,11316070,11317079, 11317269,11317981,11320073,11322693,11332942,11337431,11344289,11348758, 11349871,11350608,11360876,11377656,11383742,11386661,11389967,11393832, 11417305,11419949,11426190,11428037,11429800,11430072,11436482,11440641, 11446687,11446954,11448260,11469668,11489290,11498870,11505133,11507924, 11508456,11509621,11511496,11519016,11522743,11533489,11554556,11557355, 11561240,11561968,11564829,11566419,11567304,11570102,11571461,11581582, 11585343,11592209,11604961,11612968,11614613,11617718,11626833,11629749, 11630810,11635704,11651105,11656865,11665711,11667772,11672776,11673932, 11676657,11676892,11677490,11677590,11681210,11687141,11693895,11698331, 11698977,11710129,11730597,11734251,11738852,11741058,11741410,11742674, 11760349,11769756,11777330,11780550,11795830,11795905,11799944,11801436, 11802337,11803854,11804897,11805328,11820662,11823802,11826647,11851222, 11852863,11856081,11857444,11858330,11877048,11886648,11889267,11902450, 11903602,11905786,11916575,11916782,11917807,11924552,11924568,11928825, 11940045,11940553,11942287,11963472,11963527,11987994,11990493,11995480, 11996735,11999754,12001544,12002321,12004276,12006778,12014816,12023766, 12023796,12023980,12026264,12030910,12035327,12035343,12035559,12037174, 12051049,12068081,12068706,12077806,12079125,12083125,12085712,12090624, 12090896,12106793,12108420,12109580,12114389,12120645,12130611,12140172, 12141279,12143687,12144015,12149463,12149955,12152628,12153029,12155373, 12160875,12162344,12163449,12163892,12168007,12171815,12202350,12203748, 12207557,12217115,12217641,12226446,12235997,12237153,12242743,12248341, 12270500,12272379,12273242,12281002,12311825,12313152,12314833,12317368, 12325765,12334838,12336988,12353458,12358798,12363294,12367887,12403496, 12404882,12407053,12413336,12413815,12414214,12426381,12439930,12440533, 12443044,12447969,12454397,12460163,12469203,12471978,12472574,12476685, 12477025,12479657,12485231,12487572,12488324,12493580,12495418,12496215, 12504799,12506210,12513485,12518017,12518508,12521479,12529706,12536756, 12538602,12543931,12547828,12548686,12548710,12553070,12554896,12554977, 12556395,12557839,12559409,12566779,12566854,12571138,12572068,12583591, 12585163,12585284,12591324,12599255,12608482,12615911,12624911,12634201, 12635662,12652641,12669973,12670366,12682813,12683541,12685774,12687144, 12689512,12699123,12705961,12708226,12711350,12711397,12716582,12719072, 12741508,12752893,12758594,12766907,12766943,12767392,12768851,12773921, 12782318,12783565,12792828,12814404,12815148,12820093,12825526,12825955, 12846626,12847129,12847941,12860989,12861237,12864049,12864794,12865411, 12866985,12869688,12875904,12877874,12878597,12902452,12904118,12910145, 12919152,12920306,12922930,12928831,12928927,12932013,12935443,12942365, 12943683,12961884,12962094,12964801,12971640,12971673,12975570,12980012, 12980293,12983266,13005385,13014954,13027312,13033360,13037279,13041312, 13054498,13059758,13060044,13068117,13073709,13079754,13079755,13081108, 13081529,13096125,13096171,13098164,13098761,13105118,13113465,13119450, 13128142,13130532,13135104,13135141,13136225,13140907,13142602,13143236, 13164839,13167879,13169979,13170625,13174227,13181437,13191738,13203906, 13208211,13211778,13213325,13215880,13219111,13224898,13238785,13242137, 13242901,13246240,13248763,13249226,13256850,13259281,13263095,13264011, 13266874,13270012,13278492,13278536,13282265,13294134,13295670,13298270, 13304210,13304706,13309927,13314572,13327316,13343859,13348893,13349072, 13353126,13355545,13355553,13358461,13358750,13360569,13364502,13373857, 13378792,13380666,13393442,13396349,13399330,13402505,13415149,13415233, 13416422,13428914,13438466,13439925,13440824,13445820,13454383,13467261, 13471007,13477862,13478039,13478222,13488761,13499214,13501083,13510414, 13512281,13513201,13513686,13517172,13518591,13523575,13529293,13530246, 13541347,13544126,13550535,13553907,13556989,13562285,13564203,13571521, 13574039,13575556,13588723,13608303,13613482,13614443,13616371,13617958, 13622240,13625495,13629175,13633140,13634631,13641275,13641490,13650824, 13679466,13680988,13681404,13692155,13696749,13697115,13700580,13701458, 13704595,13705502,13707126,13710167,13720831,13723007,13725251,13725319, 13728979,13732448,13734639,13745397,13752875,13760686,13768588,13769068, 13770017,13777813,13783940,13785741,13786079,13791031,13791663,13805448, 13805538,13821812,13834377,13840472,13841336,13843878,13845212,13851782, 13854216,13858612,13859499,13860350,13863430,13866516,13869066,13869936, 13883839,13885433,13889901,13902714,13918250,13918761,13925682,13926960, 13928436,13934112,13936758,13938632,13941425,13946393,13947331,13975403, 13980644,13985707,13987931,13994934,13997646,14000256,14001857,14001956, 14011494,14015088,14025607,14027666,14028865,14030700,14040112,14048456, 14065025,14077008,14078623,14081073,14083425,14086034,14086742,14087071, 14109132,14110041,14128937,14135932,14144510,14172047,14177768,14179551, 14194543,14199287,14216063,14221450,14231332,14237938,14239986,14249029, 14250615,14250876,14252625,14253215,14271235,14271764,14285562,14289686, 14293581,14301224,14309255,14317084,14319102,14321958,14325584,14337986, 14342186,14345259,14358777,14359838,14361126,14365232,14366918,14370093, 14370884,14376642,14378115,14378896,14380795,14383484,14386179,14388040, 14401484,14403757,14423511,14423536,14424573,14430513,14434122,14435063, 14438070,14438949,14442204,14444330,14448885,14450285,14450599,14462122, 14489501,14490457,14492664,14502511,14504019,14504098,14504258,14511822, 14512249,14520608,14521062,14529459,14533574,14535174,14537227,14538158, 14539932,14542274,14550933,14552190,14556244,14560625,14561324,14562455, 14562602,14563694,14567206,14569324,14570496,14577710,14577968,14592934, 14593153,14593520,14596827,14598024,14603412,14603948,14606996,14607955, 14609485,14609777,14611412,14627597,14630539,14635083,14636018,14639774, 14641128,14641868,14643131,14644669,14648007,14651879,14657398,14661970, 14663232,14669507,14670953,14671900,14676269,14678196,14680358,14688020, 14700420,14707058,14710013,14714069,14716246,14719718,14721381,14723373, 14730724,14733585,14737651,14738806,14742758,14748899,14749201,14756621, 14758824,14759200,14760635,14764024,14764067,14764565,14778519,14780246, 14794526,14800751,14803826,14805163,14816766,14820826,14829989,14835592, 14836860,14837725,14838110,14839172,14841472,14844776,14852036,14852992, 14853459,14855220,14860062,14860824,14866042,14870213,14871082,14871540, 14871829,14872847,14873138,14877154,14878454,14881400,14882394,14886336, 14887668,14893789,14904681,14907452,14911512,14915992,14916699,14918984, 14924086,14926857,14943992,14946498,14955363,14966545,14970971,14981491, 14983951,14985356,14989645,14992796,15001353,15009458,15013461,15018624, 15025626,15032281,15033274,15038729,15045253,15047204,15047683,15049395, 15054271,15058751,15060124,15066065,15072871,15081344,15088191,15094740, 15095522,15100435,15105137,15108104,15108155,15121006,15124901,15126080, 15128335,15132243,15132776,15135960,15139576,15145848,15149762,15159354, 15160288,15167173,15168465,15171522,15171645,15173648,15175848,15179295, 15182757,15183719,15188346,15190129,15202081,15212069,15212382,15213913, 15216445,15220326,15224185,15225879,15233318,15240809,15241787,15243143, 15247815,15250126,15257791,15258291,15259373,15261832,15263940,15264087, 15270504,15275351,15278092,15280917,15281294,15281718,15286720,15304212, 15304268,15312457,15315484,15317294,15324152,15327706,15329721,15339859, 15342549,15349796,15353686,15364288,15366045,15368304,15378597,15382537, 15382724,15392577,15393311,15398482,15399225,15408881,15419754,15419937, 15420072,15420856,15422644,15424149,15425179,15429298,15433182,15436489, 15437419,15442907,15444317,15451611,15454761,15467324,15469129,15477729, 15484855,15485757,15486163,15488769,15489754,15494259,15498646,15503141, 15515548,15526990,15528209,15532149,15536200,15549396,15564627,15564643, 15564671,15566186,15571685,15574178,15575220,15580542,15583469,15584861, 15591250,15594881,15595632,15596315,15600886,15603340,15607578,15611981, 15614734,15617341,15620688,15620707,15622501,15626478,15628038,15630315, 15636960,15641666,15642433,15650135,15651614,15654250,15655632,15668721, 15679460,15680220,15685648,15685779,15688375,15688942,15690513,15690666, 15698563,15706878,15707762,15710595,15713776,15723546,15724385,15730608, 15737103,15740552,15748968,15754425,15755114,15757508,15763484,15766455, 15771688,15776420,15776738,15780899,15785151,15799047,15799856,15807145, 15810696,15815756,15823954,15841736,15843193,15849025,15851152,15854978, 15857380,15875514,15881234,15886610,15891802,15901066,15910157,15920387, 15922806,15926580,15929326,15940873,15947313,15948267,15954718,15955664, 15962946,15963179,15967781,15967918,15969595,15969842,15974345,15976630, 15977090,15978764,15988095,15991542,15998984,15999850,16000814,16002779, 16006320,16006582,16011911,16019814,16019980,16025087,16038563,16039026, 16041637,16043323,16043543,16047242,16054025,16056009,16057316,16063233, 16069016,16069299,16072431,16076709,16084631,16085987,16088754,16090135, 16090338,16094869,16105993,16109814,16111996,16112210,16115645,16119042, 16120725,16120791,16123121,16123725,16124272,16128500,16130333,16132726, 16152436,16154640,16155596,16162780,16163452,16163838,16163846,16164263, 16164630,16165137,16166519,16167598,16171187,16176335,16179063,16179689, 16183745,16191043,16191065,16195609,16200436,16203606,16204289,16217448, 16228436,16232682,16233177,16239493,16240596,16242163,16244145,16258142, 16265574,16272450,16277042,16281910,16286136,16288458,16291719,16293069, 16304704,16314884,16319878,16328634,16329365,16331911,16338490,16343290, 16349307,16353852,16356591,16359941,16364371,16364713,16367226,16369254, 16371176,16374227,16376187,16379964,16384191,16384516,16386188,16393976, 16396275,16397225,16399165,16401749,16405059,16405082,16408005,16429773, 16431338,16431530,16434053,16434922,16436003,16440931,16442696,16442797, 16443295,16446711,16464223,16471882,16474985,16476012,16486513,16487114, 16489436,16490385,16491437,16493638,16501562,16503124,16505660,16514089, 16520816,16524227,16528411,16531866,16533439,16535969,16546243,16549668, 16550683,16552409,16552576,16554737,16557612,16557817,16567817,16567965, 16574765,16578488,16578927,16585607,16589187,16590091,16593115,16594185, 16596773,16596947,16608024,16613143,16619914,16624235,16636007,16636759, 16644027,16645784,16645949,16647372,16651172,16655691,16659691,16663390, 16667450,16669824,16674225,16680597,16696692,16697844,16699440,16718996, 16722482,16734607,16734816,16738713,16741520,16751615,16761480,16762156, 16763802,16768589,16771934,16773031,16776597,16777819,16783258,16786418, 16786460,16786476,16787888,16789199,16792046,16795899,16796352,16808487, 16808925,16810150,16818327,16819125,16819248,16826717,16832709,16834856, 16835696,16837384,16838427,16847332,16849003,16852149,16852310,16852829, 16853228,16860169,16860320,16866029,16866055,16877794,16878478,16881557, 16882625,16882800,16885753,16888350,16890697,16892534,16898453,16902756, 16905045,16909869,16917323,16920880,16921222,16925786,16927144,16927517, 16931932,16944783,16947235,16947556,16953615,16953845,16955001,16956574, 16956781,16958448,16969082,16976422,16976994,16979272,16983137,16984862, 16987855,16991656,16998582,16999703,17005465,17005604,17024129,17026787, 17039982,17044697,17045301,17051058,17057194,17060767,17068364,17079922, 17084027,17084816,17092306,17094131,17098478,17100770,17103930,17104726, 17106820,17107159,17107579,17107849,17113509,17113669,17117086,17121655, 17129153,17139010,17143911,17146254,17147732,17148458,17156265,17157159, 17167940,17168387,17169297,17169599,17169814,17171518,17175611,17175981, 17177514,17190882,17196711,17200709,17201276,17204627,17209722,17214654, 17216480,17219209,17219677,17220723,17223173,17230775,17234962,17239082, 17240256,17240436,17241637,17241756,17245768,17252003,17253136,17260415 ) 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...
