Untitled query #72180

This query is marked as a draft This query has been published by LoFat36.
SQL

select r.rev_actor, r.rev_timestamp, r.rev_page, r.rev_id
from revision r
join page p on r.rev_page = p.page_id
where p.page_namespace = 0 and p.page_is_redirect = 0 and r.rev_minor_edit = 0
	and r.rev_actor in (139999628, 140026688, 140035884, 140051681, 140056475, 140056610, 140058826, 140105333, 140194519, 140213534, 140217385, 140281616, 140471609, 140474866, 140481338, 140483244, 140500377, 140511197, 140607835, 140638342, 140654380, 140687017, 140759468, 140788853, 140793045, 140840984, 140922458, 140922664, 140954949, 141022047, 141025211, 141173176, 141198607, 141215956, 141218513, 141237312, 141286332, 141397872, 141472987, 141552301, 141601265, 141639588, 141643303, 141728010, 141741988, 141752715, 141765992, 141791966, 141811247, 141878167, 141915318, 141935327, 142082865, 142084358, 142123472, 142126677, 142128079, 142137914, 142139018, 142164721, 142188184, 142205503, 142218735, 142230000, 142238177, 142494774, 142544075, 142575181, 142604419, 142620504, 142638903, 142684697, 142736494, 142769754, 142782338, 142793433, 142796595, 142802179, 142829317, 142880676, 142943206, 142983530, 143008425, 143109090, 143114241, 143129183, 143161584, 143214874, 143260549, 143298958, 143333319, 143351225, 143419493, 143429295, 143469895, 143515420, 143563685, 143594051, 143620422, 143648347, 143651992, 143664981, 143688212, 143726628, 143742504, 143815500, 143820205, 143845078, 143917671, 143936007, 143950697, 143951271, 143988232, 144006736, 144016677, 144018423, 144124862, 144131454, 144146126, 144190907, 144236402, 144295950, 144320996, 144473415, 144490587, 144491343, 144517750, 144546837, 144592035, 144658383, 144688164, 144691374, 144754585, 144759511, 144767085, 144796676, 144818379, 144836882, 144854157, 144854990, 144893447, 144901407, 145024509, 145127374, 145128390, 145206601, 145235208, 145244432, 145248062, 145251570, 145252912, 145255814, 145276073, 145327251, 145345527, 145379164, 145425968, 145512028, 145606942, 145621793, 145641931, 145729088, 145738709, 145775274, 145782256, 145791351, 145874081, 146041002, 146136585, 146152127, 146210701, 146317390, 146318792, 146503915, 146539169, 146613293, 146685754, 146730416, 146733201, 146757974, 146804246, 146927488, 146952853, 147099597, 147110235, 147143626, 147151997, 147184064, 147188276, 147200250, 147243809, 147262056, 147263686, 147478552, 147492447, 147493391, 147637509, 147690871, 147693812, 147712481, 147830188, 147845847, 147886330, 147900290, 147901807, 148012572, 148013099, 148019195, 148024130, 148064540, 148073295, 148181795, 148322154, 148349041, 148372904, 148437916, 148728430, 148744847, 148751995, 148766248, 148812484, 148889160, 148916810, 148955319, 149005341, 149034317, 149043642, 149061445, 149138527, 149153045, 149215316, 149269811, 149278789, 149294458, 149334782, 149347886, 149356703, 149377326, 149382697, 149385579, 149429734, 149507104, 149508698, 149589146, 149596359, 149639938, 149661706, 149695121, 149719483, 149818746, 149847537, 149873149, 149929196, 149959793, 150107451, 150108455, 150130158, 150207287, 150304934, 150367109, 150445031, 150451574, 150467703, 150543460, 150548200, 150726406, 150739301, 150996094, 151162213, 151173872, 151224391, 151240905, 151274376, 151331559, 151496185, 188387887, 188389841, 188454819, 188632695, 188802995, 189028449, 189109224, 189181679, 189893844, 190033502, 190040565, 190103579, 190137178, 190351879, 190444535, 190543645, 190906863, 190972710, 191029058, 191170331, 191525088, 191604829, 191858212, 192033540, 192089271, 192106357, 192143258, 192423237, 192494615, 192586164, 192606834, 192941990, 192982186, 193018486, 193198014, 193577555, 193755632, 194228995, 194710889, 194733924, 194854033, 194854405, 194872916, 195013076, 195365376, 195744018, 195794223, 195840342, 196160252, 196299920, 196517201, 196800205, 196982519, 196992770, 197132776, 197394690, 197435105, 197487230, 197567913, 197666904, 197912476, 198191953, 198333099, 198431617, 198542790, 198568510, 198645215, 198781494, 198805210, 198869071, 198886161, 198925084, 199019442, 199025424, 199028982, 199108497, 199147193, 199169778, 199205993, 199365610, 199555827, 199598061, 199664305, 199717997, 199830691, 199916692, 199941860, 199946693, 200062302, 200131473, 200279836, 200417148, 200419695, 200900994, 200945445, 201157660, 201195601, 201248983, 201422988, 201566578, 202056282, 202256275, 202723121, 202728090, 202877050, 202996924, 203014093, 203104383, 203566278, 203585897, 203807156, 203968358, 203984061, 204202879, 204264075, 204279514, 204326890, 204355030, 204532179, 204801036, 204894958, 205025663, 205086584, 205255826, 205487954, 205524678, 205592293, 205641962, 205678787, 205756906, 205884141, 205905649, 205920251, 206084557, 206219747, 206266773, 206386247, 206418294, 206457016, 206518912, 206528869, 206630827, 206636129, 206751257, 207140973, 207598341, 207744711, 207992726, 208009722, 208479896, 208505692, 208670456, 208837721, 209073427, 209087372, 209625951, 209731071, 209853732, 209929225, 209940919, 209990095, 210020408, 210538503, 210576453, 210880619, 211442761, 211536263, 211666038, 211836818, 211850643, 211922107, 212299763, 212355081, 212385970, 212561714, 212698467, 212739333, 213020462, 213045199, 213115561, 213340726, 213446731, 213607163, 213674166, 213710001, 213744562, 213808346, 213889584, 214162637, 214174833, 214190402, 214303604, 214541893, 214587131, 214628291, 214649906, 214754764, 215019836, 215052106, 215191440, 215234718, 215241746, 215426487, 215483243, 215580068, 215724210, 215851266, 215920260, 216041314, 216178362, 216231187, 216231481, 216370586, 216392007, 216518771, 216567973, 216665957, 216676038, 216729660, 216733504, 216755720, 216906954, 216912054, 216961650, 217032873, 217151628, 217356081, 217478275, 217479308, 217493737, 217577558, 217627856, 217668500, 217707225, 217797619, 217900899, 218084416, 218090619, 218128615, 218213836, 218497928, 218572231, 218581279, 218633952, 218671517, 218872832, 218966922, 218974043, 219009714, 219042987, 219142546, 219236360, 219247218, 219836641, 220066745, 220119063, 220331226, 220337271, 220659781, 220691390, 220728679, 220729024, 221112559, 221554482, 221899023, 221928920, 221990721, 222022339, 222417941, 222434757, 222482947, 222847848, 222860028, 223029603, 223121987, 223220466)
order by r.rev_actor, r.rev_timestamp
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...
