Blocked users with curation logs from 2015-03-27 to 2016-03-27

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.

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.

SQL

Checking query status...