Untitled query #72179

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 (116608015, 116615736, 116648993, 116678579, 116684948, 116696760, 116698841, 116757956, 116764321, 116782557, 116830605, 116836058, 116885936, 116967557, 116996994, 116998116, 117042782, 117073339, 117104474, 117128365, 117163647, 117165454, 117244431, 117262260, 117267404, 117291710, 117301281, 117353996, 117369780, 117383902, 117410058, 117424252, 117488699, 117497822, 117525319, 117556172, 117657695, 117670871, 117674777, 117788351, 117831500, 117877272, 117896307, 117935714, 117941672, 117980367, 117993350, 118106503, 118204185, 118227285, 118286099, 118345141, 118352939, 118419093, 118426042, 118459699, 118460512, 118470490, 118527739, 118533186, 118548048, 118580131, 118602457, 118606979, 118627386, 118644530, 118646051, 118646055, 118649688, 118718631, 118736978, 118741101, 118775364, 118814600, 118820068, 118890308, 119016201, 119025590, 119077423, 119086999, 119108907, 119119300, 119129683, 119153776, 119167092, 119170331, 119180719, 119267213, 119280112, 119299150, 119320499, 119370163, 119424708, 119579111, 119586699, 119619923, 119634529, 119717187, 119789630, 119813357, 119825318, 119973558, 120000637, 120004475, 120013573, 120044342, 120060391, 120179859, 120182274, 120214179, 120240148, 120255754, 120275501, 120322303, 120382175, 120415019, 120428892, 120501419, 120502961, 120532141, 120577839, 120578700, 120610538, 120661658, 120691096, 120812167, 120842353, 120848183, 120887068, 120897292, 120975745, 121127363, 121148745, 121252688, 121366121, 121420164, 121478380, 121685545, 121692582, 121875678, 121913072, 121968108, 121979840, 122063944, 122093390, 122129254, 122148052, 122227361, 122287236, 122294363, 122299474, 122342652, 122439200, 122522593, 122684509, 122691301, 122707874, 122717788, 122929264, 122982621, 123030709, 123129975, 123177232, 123213082, 123279495, 123314653, 123348312, 123404190, 123574772, 123694871, 123810283, 123983830, 124117414, 124331887, 124363659, 124367267, 124478858, 124487383, 124552182, 124623659, 124634555, 124649191, 124678495, 124680731, 124712430, 124800854, 124821387, 124850805, 124891071, 124903031, 124909402, 124944380, 125040208, 125051295, 125133205, 125156005, 125273850, 125275171, 125408892, 125435179, 125551445, 125566211, 125599826, 125639369, 125710200, 125714716, 125747781, 125783923, 125807796, 125882525, 125960346, 126057698, 126118131, 126227217, 126269452, 126277803, 126290239, 126297133, 126372877, 126380663, 126395757, 126415304, 126427539, 126443333, 126455293, 126474877, 126509579, 126511018, 126555057, 126708905, 126744151, 126758271, 126772305, 126819963, 126833879, 126920897, 126925261, 126983846, 127037531, 127043743, 127088379, 127094603, 127128196, 127133179, 127212781, 127216303, 127216476, 127258167, 127285160, 127347718, 127389866, 127434889, 127482652, 127493141, 127501389, 127501647, 127516027, 127543370, 127567492, 127615197, 127708301, 127723183, 127746325, 127798342, 127810367, 127954104, 127960119, 128012204, 128074565, 128100862, 128160964, 128277397, 128320449, 128525081, 128535929, 128588971, 128619436, 128668139, 128719100, 128743592, 128754500, 128859397, 128922602, 129169716, 129176129, 129197350, 129203132, 129208677, 129251532, 129264187, 129276561, 129330805, 129337470, 129365529, 129367021, 129440147, 129447828, 129523735, 129542767, 129564189, 129577840, 129582355, 129597746, 129638522, 129639262, 129668404, 129677127, 129688645, 129820512, 129859275, 129866500, 130106364, 130163769, 130202226, 130353786, 130448631, 130480557, 130529596, 130633267, 130691387, 130744414, 130752272, 130818924, 130866435, 130944338, 131010085, 131015850, 131082115, 131132989, 131193361, 131227379, 131255596, 131317895, 131339250, 131372610, 131453833, 131455231, 131460568, 131493114, 131497384, 131512689, 131518109, 131528901, 131560201, 131640063, 131675864, 131682901, 131694334, 131722261, 131743777, 131778066, 131931208, 131950921, 131967738, 132030560, 132034876, 132072251, 132094701, 132150242, 132163603, 132168151, 132200976, 132328921, 132332236, 132349869, 132460058, 132483370, 132503492, 132511278, 132541695, 132544488, 132565393, 132589182, 132687938, 132707580, 132915924, 132943507, 132948624, 133029868, 133152808, 133250142, 133260596, 133326853, 133375284, 133406403, 133442524, 133456071, 133473670, 133533695, 133534612, 133556289, 133558803, 133614904, 133629233, 133681719, 133697171, 133727003, 133736018, 133741146, 133821636, 133923620, 133972378, 133977251, 134014977, 134074238, 134222574, 134290035, 134419844, 134517760, 134689130, 134702637, 134737447, 134823820, 134858672, 134932166, 134951013, 134970116, 135087000, 135155851, 135185873, 135188086, 135252060, 135270784, 135272670, 135398795, 135415142, 135467428, 135549531, 135560526, 135578674, 135658735, 135674385, 135779774, 135924555, 136006084, 136060002, 136061398, 136204635, 136240946, 136309758, 136321289, 136544246, 136619150, 136686404, 136716946, 136775151, 136802857, 136809705, 136960369, 137061414, 137063763, 137078153, 137091523, 137146973, 137188288, 137192499, 137241367, 137322894, 137405039, 137490021, 137535972, 137648252, 137663555, 137814415, 137879187, 137908934, 137930986, 137962713, 138017225, 138070499, 138115994, 138174818, 138242248, 138331120, 138351798, 138363630, 138384912, 138609864, 138718181, 138723024, 138778511, 138793810, 138845821, 138865098, 138921048, 138980204, 138999956, 139056938, 139107806, 139221791, 139226998, 139378874, 139511574, 139622394, 139735879, 139752637, 139874331, 139908383, 139968419, 139999628)
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...
