Untitled query #72178

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 (4780569, 4858553, 4952270, 4957101, 5020057, 5057019, 5100843, 5102152, 5103259, 5186752, 5209322, 5283087, 5326748, 5397233, 5536436, 5566814, 5618580, 5619186, 5680772, 5718286, 5799008, 5918099, 5988395, 6013942, 6027375, 6120942, 6130525, 6160873, 6485331, 6690049, 6764251, 6786064, 6797266, 6819763, 6906070, 6985052, 6999779, 7030276, 7043637, 7255399, 7313446, 7341463, 7377623, 7597056, 7694543, 7840475, 7934432, 8080769, 8163741, 8175520, 8188437, 8206487, 8306861, 8332637, 8406061, 8412734, 8414452, 8454952, 8478347, 8484730, 8499928, 8535753, 8644698, 8660792, 8668431, 8718536, 8808111, 8863350, 8874066, 8951181, 9161510, 9182814, 9211639, 9269532, 9351002, 9409983, 9452588, 9562791, 9574401, 9575326, 9733020, 9754109, 9818604, 9970311, 9971165, 10045579, 10075743, 10307258, 10342255, 10401027, 10409011, 10481025, 10560292, 10564103, 10614380, 10627701, 10795970, 10844630, 10860660, 10904492, 11177056, 11207801, 11303359, 11306997, 11449058, 11485419, 11553501, 11561724, 11670233, 11844617, 11868885, 11890769, 11893199, 12102761, 12135094, 12155644, 12294938, 12455470, 12499699, 12506386, 12554817, 12573099, 12575925, 12603088, 12641338, 12673855, 12813814, 12825556, 12854862, 12952316, 12953945, 13031203, 13081748, 13108393, 13132114, 13387224, 13516650, 13560477, 13568379, 13782041, 13928164, 14205504, 14258845, 14291555, 14544464, 14570361, 14710485, 14724686, 15039452, 15261286, 15307997, 15514367, 15735289, 15741929, 16063257, 16222128, 16399028, 17004418, 17007464, 17138936, 17213296, 17251506, 17308114, 17457263, 17477100, 17491496, 17595374, 17685105, 17728784, 17881938, 17960373, 17999434, 18110630, 18145505, 18627662, 18665586, 18723453, 19106188, 19151013, 19202142, 19432303, 19599207, 19625124, 19826126, 19860704, 20136895, 20141583, 20262576, 20302000, 20334548, 20352149, 20361371, 20535196, 20542496, 20548952, 21062236, 21098161, 21195934, 21226720, 21251400, 21318274, 21490615, 21502050, 21532684, 22908354, 22939264, 22996247, 23047588, 23078414, 23107172, 23458816, 23542480, 23618017, 23651741, 23735720, 24025951, 24487190, 24546856, 24606927, 24678895, 24699384, 25358030, 25982115, 26294352, 26357112, 26400729, 26436881, 27124317, 27231118, 27410232, 27687179, 28063399, 28065830, 28215838, 28452800, 28541425, 28734285, 28859509, 29053486, 29090697, 29098138, 29117100, 29351292, 29354124, 30222667, 30448494, 30493557, 30514069, 30688434, 30694536, 31133176, 31349021, 31413282, 31584503, 32122682, 32621418, 32849618, 32929930, 32935341, 33741348, 34129094, 34295716, 34365130, 34552986, 35347611, 35604730, 36624803, 36647893, 36679355, 36681558, 36683495, 36688437, 36697863, 36702626, 36713783, 36735046, 36759772, 36762957, 36808178, 36817831, 36855491, 36911145, 36916077, 107776886, 107788421, 107805114, 107815084, 107817230, 107837637, 107844468, 107853269, 107867903, 107896038, 107902015, 107904725, 107930047, 107930112, 107934753, 107960732, 107962852, 107977413, 108019811, 108024527, 108036431, 108039467, 108163950, 108173887, 108179952, 108330041, 108342229, 108387431, 108389980, 108430334, 108430923, 108466658, 108525707, 108580097, 108594650, 108657907, 108661341, 108714711, 108728410, 108764335, 108777025, 108797921, 108924291, 108932797, 108936812, 108937954, 108945795, 108956012, 108976950, 109017437, 109046976, 109065376, 109091046, 109112703, 109119855, 109126995, 109131276, 109187203, 109190192, 109208039, 109219714, 109284348, 109433780, 109451327, 109487529, 109489821, 109594514, 109608961, 109670482, 109682015, 109737578, 109767798, 109802336, 109833468, 109911469, 109916793, 110044628, 110093240, 110094383, 110117974, 110140718, 110204332, 110246823, 110262966, 110302424, 110342467, 110380295, 110430191, 110438848, 110527430, 110538200, 110574709, 110582855, 110705567, 110723148, 110726265, 110826567, 110926329, 111256627, 111295820, 111346031, 111397101, 111462989, 111478261, 111509037, 111519956, 111520876, 111577315, 111677408, 111682178, 111707658, 111763109, 111835500, 111844382, 111881445, 111910028, 111912582, 111914951, 112010528, 112068609, 112106348, 112147163, 112257643, 112263320, 112268032, 112269828, 112456215, 112520519, 112634502, 112685895, 112745568, 112829770, 112840692, 112859031, 112887427, 112895416, 113052797, 113067778, 113091916, 113172674, 113197524, 113200840, 113203664, 113205219, 113240608, 113256905, 113320240, 113364336, 113398995, 113459022, 113547469, 113561863, 113622630, 113629364, 113632718, 113646904, 113743751, 113757800, 113831578, 113841633, 113842402, 113981506, 114033911, 114060888, 114115156, 114131805, 114169956, 114304036, 114335017, 114349500, 114396476, 114471836, 114518756, 114538906, 114562462, 114612008, 114666554, 114723307, 114782027, 114798496, 114876144, 115145870, 115155954, 115229654, 115235374, 115243298, 115382834, 115398957, 115412522, 115417395, 115419075, 115447309, 115603248, 115604054, 115687630, 115764131, 115765445, 115801823, 115830753, 115887071, 115890400, 115897710, 115913790, 115934497, 115943871, 116015040, 116043943, 116170802, 116266543, 116297182, 116353192, 116497999, 116520219, 116525598, 116546511, 116594222, 116606223)
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...
