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
.
Blocked users with any curation logs between 2015-03-27 and 2016-03-27. See query 8688 for the source of these user ids; the single query times out.
Toggle Highlighting
SQL
SELECT ipb_address, ipb_expiry, ipb_by_text, ipb_reason FROM ipblocks_ipindex WHERE ipb_user IN ( -- output from -- SELECT DISTINCT log_user AS recent_user FROM logging_userindex WHERE log_type='pagetriage-curation' -- AND log_timestamp >= 20150327000000 AND log_timestamp < 20160328000000; 10023696,10051232,10101798,1014218,10188896,102066,10236113,1024002, 10248457,10357594,10405052,104348,10451630,10466085,1046972,10484581, 10539714,10568707,10614794,10646449,10657529,10728040,10734192,10754397, 10773272,10829383,1084125,108528,10867422,10872741,10903890,10929479, 10948993,10951369,10954699,10962883,10984523,1100050,11049176,111640, 11225276,11226188,11263730,11322693,1138432,11393832,11417305,11440641, 114988,11498870,11533489,11557355,11561968,11571461,11635704,11656865, 11687141,1168880,1169249,11760349,11777330,1179460,11803854,11916782, 11995480,12023796,12068706,120801,121745,12176,1218696,12235997, 12242743,12248341,12367887,12471978,12485231,12488324,12529706,12553070, 12566854,125787,12585163,126457,12652641,12669973,12670366,12699123, 12711397,12875904,12962094,12971640,1306352,13096125,13136225,13143236, 13181437,13224898,13259281,13348893,13355545,13358750,13477862,13512281, 13571521,1357356,13588723,13616371,13662,13667518,136864,1368779, 13710167,13791663,13821812,13889901,13928436,13947331,13975403,13994934, 14001857,14025607,1414762,1416400,14221450,14450285,14462122,14489501, 14492664,14504098,14504258,14539932,1455149,14593520,14596827,14643131, 14657398,14723373,14730724,14756621,14760635,14860824,1487243,14882394, 14886336,1492328,14946498,14970971,15009458,150564,15088191,15132243, 15139576,1514746,15151559,15167173,15171645,15179295,15202081,15220326, 15225879,15280917,15342549,15364288,15433182,1544984,15467324,15469129, 15502511,15515548,15532149,1554842,15564627,15566186,15571685,15628038, 15636960,15676351,15679460,1569062,15707762,15763484,1576422,15776738, 15799047,15799856,1588193,15890710,15891802,159678,15988095,16000814, 16016498,16019814,16041637,16043543,16063233,16076709,16123725,16132726, 16152436,16163846,16191043,16191065,16203606,162296,16265574,16291719, 16359941,16364713,16397225,16443295,1646408,16474985,16476012,16578927, 16636007,16647372,16663390,16699440,16718996,1676211,16787888,16795899, 16818327,16819248,1682577,16852310,16860320,16944783,16947235,16947556, 16998582,170099,17079922,17084027,17107579,17121655,17168387,17175981, 17200709,17223173,17283576,17311078,17317244,17322254,17340900,17370235, 17375010,17378704,17397640,17421396,17423488,17436477,17449355,17455969, 17487443,17500133,17543794,17594434,1759632,17619006,17622016,17651076, 17652082,1767038,17688569,17692156,17716702,17746512,17771490,17772824, 17779745,17780922,17823581,17843555,17847210,17863160,17891487,17911012, 17944818,17956451,17971031,18004971,18017774,18066332,180736,18109531, 18130370,18177679,18189084,18213547,18215845,1826888,1827336,18281217, 18281898,1830371,18305830,18308978,18313966,18336458,18364158,18368297, 18371010,18371554,1839637,18418173,18488006,18489314,18510469,18557890, 18578145,18622101,18650035,18650529,1870314,1874255,18766808,18783712, 18824446,18853599,18857348,18892583,18899359,18907122,18911373,18917475, 18947572,18980287,18985077,1904640,19050143,19050228,19057820,19059602, 19077245,19079409,1907991,19089174,19164162,19207416,1921264,19217, 1923336,19234344,19234405,19244234,1925080,19259246,19261965,19263063, 19280148,19285809,19297189,19323020,19343293,1935381,19390481,19392310, 19396915,19407754,19413316,1943537,19443199,19464662,19477919,19500131, 19502780,19512211,19550906,19583588,19605834,19627469,19627935,19639226, 196471,19649881,19655465,19680382,19737011,19757313,19781588,19818307, 19905535,19912518,1992122,19922230,19928789,19936905,19940,19959423, 19964745,19973778,19999621,20008731,20010244,200762,20083999,20086261, 2012100,20145563,20163293,2016996,20224789,20238112,20255624,20293243, 20319727,20350509,20371397,20402762,20410206,20419951,20441404,20442586, 20452276,20483988,20488265,20543045,20550549,20568271,20574729,20596006, 2067592,20676877,20693857,20728426,20732776,20743205,207517,20754560, 207616,20766074,20789573,20800274,20820109,20834545,20852651,20919629, 20935996,20949630,20957809,20996381,20999826,21003237,21035594,21056935, 21062275,21090172,21119524,21151565,21153935,21166720,21178912,21226966, 21226984,21227381,21248988,21268108,21304876,213194,21319995,21322594, 21339858,2136008,21375375,21397832,21415354,21431308,2143840,21479757, 21482476,21482526,21491290,21515138,21545668,21549123,21552604,21552999, 21560758,21561423,2157954,21615878,21632347,21659507,21685244,21689556, 21717051,21733618,21752688,21790429,21795021,21795767,21803309,21810445, 21825264,21832781,21835215,21840846,218593,21861755,21868555,21886425, 21895182,21929136,21934908,21939030,21943430,21943456,21966602,21976653, 21984574,2203608,22083128,22089808,22094539,22096151,22150306,22164567, 22166722,2217514,22208726,22249760,22252595,22270931,22295782,22345858, 22359576,22400417,22412276,22434203,22495477,22504150,2250766,2251138, 22537453,22537479,2255048,22581480,22604547,22614337,22632709,22639573, 22665218,22672130,22689620,22709054,2273199,22767140,22776755,22788045, 22817928,22827486,22828362,22842580,22857734,22860730,22872773,22883165, 2290552,22945049,22957913,23035847,23037249,23039188,23068335,23085006, 23124722,23161404,23164364,23175107,23175163,23187350,23257138,23278095, 23299921,23334106,23355395,23398148,23428938,23443770,23487947,23500032, 23512252,23541669,23571224,23595433,23616447,236339,23687974,23694859, 23703235,23712817,23725384,23728166,23734220,23748255,23753558,23763220, 23770065,2377922,23786866,2379078,238154,23815531,23863110,23872047, 2387886,238943,23897939,23914831,23941229,23945475,23960444,23962824, 23970182,23986579,23987251,23992275,23994444,23999330,24012321,24039894, 24041054,24050446,24101482,24136187,24160555,24167941,24168406,24170287, 24207737,24208635,24219721,24243100,24253262,24253470,24254310,24261100, 24261284,24265647,24269253,24269494,24275433,24282447,24289919,2429012, 24299302,24315112,24321320,24323389,24346608,24355845,24361832,24401905, 24407922,24416395,24444640,24469849,24484530,24501061,24508002,24522074, 24524350,24536213,24544211,24562946,24586732,24602859,24619723,24625156, 24631979,24632052,24633626,24706733,24721920,24731466,24736674,24741572, 24747272,24796666,24799826,24812038,24812962,24844794,2484495,24853148, 24878374,24888299,24897076,2489738,24903812,24947180,24953496,24969835, 25029221,25029499,25034998,25061312,25062535,25063735,25093617,25106867, 25124517,25124554,2512606,25133407,25136741,25146394,25148589,25151159, 25153857,25166182,25180984,25190808,25209507,25227926,25255196,25265719, 25274679,25314640,25325641,25382587,25400201,25404341,25420061,25432563, 2543303,25434004,25436602,254396,25442544,25471656,25501097,25508447, 25519390,25523690,25530780,25540432,25542642,25553373,25582059,25587789, 25599893,25602706,25611010,25612507,25613592,25616904,25638542,25639426, 25663764,25699383,25714004,25724030,2572536,25729147,25739236,25739245, 25771936,25777057,25792737,25802465,25803941,25812203,25819323,25824467, 25830045,25847501,25862313,25864232,25866225,25870349,25876435,25891365, 25897560,25907358,25914906,25916996,25919295,25923238,25942273,25945719, 25959191,25976018,25977910,25977978,25980261,25998241,26008018,26010822, 26011624,26015190,26032994,26033934,26034386,26039521,26044021,26057591, 26061221,26073722,26075877,26075897,26078999,26110696,26129968,26140449, 26141511,26142263,26150076,26188758,26195465,26198056,26203363,26233276, 26250453,26252026,262675,26291280,26299357,26301921,26303010,26303422, 26319564,26332323,26344286,2639797,26398660,26399282,26449835,26485173, 26490224,26497142,26530922,26535374,26542584,26544978,26563260,26565098, 26576324,26596867,26635666,26638500,26642726,26661121,26670,26677019, 26688472,26701184,26736903,26749294,26806162,26825960,26830382,26840736, 26849763,26851933,26863438,26867021,26867111,26881796,26883893,26906394, 26932540,26941810,26951022,26952028,26960688,269651,26970773,2697759, 26990635,27032296,27045933,27065623,27065928,27067052,27081040,27089526, 27091652,27140317,27145427,27187759,27200041,27212416,27215445,27216374, 2724330,27273818,27307561,27329372,27360059,27374179,27388749,27398670, 27413045,27474377,27481818,27481985,27484617,27496036,27498385,27591598, 27598246,27612457,27615589,27624080,27626790,27650417,2766075,27670413, 27671189,27673706,27691986,27763972,27775093,2779825,27800951,27816709, 27871940,27891597,2790592,2797907,2813280,2820395,28438,2886642, 291848,2921886,2922800,292494,2927383,294121,297315,3004667, 302457,3035650,3070596,3080493,3090517,3174456,3185451,32, 3223018,323105,325437,327763,3326310,334887,3370936,340520, 342151,34431,346148,346308,3495083,351776,35228,3533381, 3543074,356802,3681258,3687005,380382,38427,3887259,3938714, 3982375,403055,4058581,4071608,4076676,4081329,4110769,416036, 416184,417165,4200934,4205870,422470,4287536,4295,4315482, 434947,4381155,440493,444985,4493105,4507268,451287,453528, 455421,4555919,455767,458825,459990,461300,4637213,4640081, 4649353,469625,473546,4748910,4753040,4756724,4772123,4789749, 4800249,492056,4984038,4985989,500937,5014595,502540,5043812, 5048054,509743,5197671,5204226,5236723,5238361,5315381,5333362, 5360838,53685,5379071,551300,555794,560483,5627478,563447, 564195,5711305,5724179,576715,57673,5811004,5879957,5939267, 594997,5958709,59944,6012516,6068355,6169056,6180217,6196463, 62411,6272462,6277621,6282205,6315995,6320921,635323,6374305, 6393447,6402792,6469902,64897,6496196,6530726,6576147,66074, 6682565,6778186,6798958,6804626,680711,6894576,6945735,6959733, 69942,7044616,7099464,7125848,7169912,719387,7219979,7271780, 7282073,7304264,7332659,7335803,7362014,7408657,74615,748005, 7480926,7505908,7529026,753413,753665,754987,7627388,770058, 7704631,7724,7759401,776137,7867282,7872,79,794241, 803092,8035165,8043052,8155960,8184661,8209418,8220586,82348, 8281842,82835,8294396,829440,829880,83057,8390765,8414284, 8500787,8524405,8586922,8589524,85952,86247,86361,8638440, 8716944,8757051,878293,88858,8921173,90232,9078664,9080397, 9092818,9109237,9125508,917223,9287752,931155,9344046,9346035, 9412278,9555110,9607385,96257,9627578,9633942,9639277,9676078, 9696476,9699525,9703281,9732999,97994,9822501,9830510,9911813, 9951654,9961776 );
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...