Edits made with Deputy (userscript, untagged)

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

Edits made using the Deputy CCI user script.

SQL

SELECT
    `rev_id` as "ID",
    `page_namespace` as "Namespace",
    REPLACE(`page_title`, "_", " ") as "Title",
    DATE_FORMAT(`rev_timestamp`, "%Y-%m-%d %H:%i:%s") as "Date",
    `comment_text` as "Summary",
	`actor_name` as "Username"
FROM `revision_userindex`
JOIN `comment_revision` ON `rev_comment_id` = `comment_id`
LEFT JOIN `page` ON `page_id` = `rev_page`
LEFT JOIN `actor_revision` ON `rev_actor` = `actor_id`
LEFT JOIN `user` ON `actor_user` = `user_id`
WHERE 
    `rev_id` IN (1097005551, 1097592162, 1099746512, 1099781950, 1099786416, 1099886388, 1100573347, 1100742105, 1100876546, 1102301396, 1102345933, 1103002703, 1103556882, 1104104480, 1105412671, 1105831769, 1106029411, 1106037372, 1106039093, 1106207634, 1106212183, 1106882421, 1106882823, 1107184141, 1107184631, 1107185462, 1107186120, 1107186830, 1107187486, 1107187526, 1107187822, 1107192482, 1107254224, 1107258660, 1107265105, 1107266902, 1107353929, 1107377536, 1107383102, 1107383319, 1107489526, 1107489527, 1107531029, 1107531744, 1107531855, 1107531959, 1107533963, 1107533966, 1108374480, 1108397780, 1108399007, 1108401397, 1108760775, 1109126586, 1109127140, 1109129105, 1109243656, 1109282635, 1109282932, 1109471456, 1109477637, 1109477800, 1109481038, 1110007643, 1110007939, 1110008016, 1110008466, 1110008835, 1110008985, 1110009221, 1110009325, 1110009456, 1110010021, 1110010668, 1110011061, 1110011536, 1110012060, 1110012407, 1110097161, 1110144097, 1110146590, 1110147201, 1110147438, 1110376438, 1110378788, 1110535545, 1110553219, 1110876034, 1111215899, 1111241774, 1111242074, 1111251135, 1111251136, 1111269799, 1111271249, 1111431257, 1111431261, 1111450593, 1111450670, 1111450672, 1111462076, 1111571951, 1111608023, 1111620212, 1111620336, 1111620342, 1111623820, 1112004036, 1112004149, 1112004151, 1112004343, 1112100397, 1112100832, 1112367697, 1112367848, 1112370218, 1112370435, 1112372232, 1112372587, 1112535494, 1112537504, 1112712283, 1112959649, 1112975849, 1112977128, 1112981985, 1112988584, 1112992851, 1113000432, 1113038801, 1113039283, 1113039807, 1113039930, 1113039931, 1113067229, 1113067498, 1113067839, 1113070163, 1113070786, 1113071545, 1113072031, 1113089221, 1113149283, 1113154654, 1113154919, 1113156930, 1113156943, 1113157463, 1113158858, 1113160183, 1113161836, 1113162382, 1113162743, 1113163848, 1113167173, 1113167832, 1113171892, 1113172360, 1113176386, 1113178422, 1113178437, 1113178451, 1113180707, 1113183673, 1113255966, 1113355948, 1113356725, 1113359029, 1113360504, 1113360758, 1113362031, 1113514567, 1113514900, 1113519157, 1113546989, 1113556531, 1113556837, 1113562040, 1113641221, 1113648798, 1113682599, 1113751868, 1113856879, 1113857050, 1113905537, 1113907639, 1113958247, 1113960093, 1114136933, 1114138255, 1114471272, 1114472716, 1114745333, 1114746290, 1114761903, 1115076041, 1115320920, 1115327122, 1115328791, 1115339705, 1115506274, 1115744335, 1115774285, 1115774952, 1115865109, 1115865112, 1115955408, 1115955913, 1115955989, 1115965980, 1115970811, 1116089874, 1116319612, 1116368863, 1116369539, 1116451603, 1116470210, 1116540587, 1116540603, 1116705192, 1116935567, 1117007247, 1117112826, 1117117914, 1117125669, 1117139830, 1117249872, 1117252151, 1117506203, 1117522990, 1117539194, 1117603178, 1117672452, 1117675003, 1117681532, 1117817156, 1117830506, 1117849363, 1117851347, 1117853941, 1117854713, 1117856529, 1117857376, 1117883866, 1117886284, 1117888174, 1118050436, 1118051059, 1118052268, 1118363901, 1118364677, 1118368575, 1118439245, 1118441064, 1118453374, 1118453537, 1118466248, 1118466375, 1118534315, 1118537580, 1118537770, 1118539484, 1118539780, 1118539948, 1118540404, 1118542700, 1118545979, 1118546523, 1118547201, 1118548538, 1118548596, 1118554903, 1118563123, 1118563788, 1118563882, 1118564390, 1118564455, 1118564688, 1118566303, 1118567437, 1118569507, 1118580546, 1118582220, 1118582274, 1118582665, 1118582915, 1118594423, 1118595118, 1118597236, 1118598139, 1118599102, 1118599364, 1118600030, 1118600473, 1118600528, 1118601014, 1118601143, 1118619821, 1118622744, 1118627348, 1118631759, 1118633557, 1118633666, 1118634760, 1118635806, 1118636106, 1118638148, 1118639535, 1118640488, 1118641422, 1118642118, 1118642358, 1118727500, 1118728483, 1118728569, 1118731705, 1118732140, 1118732856, 1118733599, 1118733703, 1118739665, 1118739992, 1118740623, 1118763750, 1118764244, 1118771978, 1118785867, 1118794776, 1118811257, 1118814233, 1118817756, 1118821409, 1118903332, 1118917647, 1118956867, 1118961842, 1118962109, 1118964206, 1118984274, 1119342678, 1119348374, 1119348583, 1119348855, 1119349406, 1119350308, 1119350389, 1119351135, 1119351824, 1119352608, 1119353207, 1119353537, 1119445083, 1119695758, 1119699912, 1119830053, 1119915358, 1119915990, 1119916403, 1119959842, 1120580961, 1120755016, 1120755353, 1121128877, 1121388922, 1121389113, 1121389434, 1121389586, 1121389726, 1121389847, 1121389920, 1121390000, 1121390127, 1121390200, 1121398252, 1121398363, 1121398553, 1121398611, 1121398661, 1121398882, 1121398934, 1121399038, 1121399090, 1121399129, 1121399166, 1121399193, 1121399225, 1121399257, 1121399291, 1121399338, 1121399518, 1121399621, 1121399972, 1121400084, 1121400173, 1121400372, 1121400428, 1121400465, 1121400569, 1121400718, 1121401796, 1121402199, 1121402548, 1121404346, 1121404488, 1121404583, 1121404907, 1121405092, 1121406204, 1121406360, 1121406895, 1121426603, 1121427737, 1121428461, 1121429088, 1121429305, 1121457015, 1121457123, 1121457642, 1121458146, 1121600008, 1121600269, 1121600444, 1121601717, 1121602260, 1121603124, 1121603730, 1121604321, 1121604573, 1121648029, 1121648321, 1121650495, 1121651066, 1121652411, 1121652985, 1121654300, 1121654777, 1121654932, 1121655634, 1121655701, 1121656201, 1121656759, 1121657242, 1121750098, 1121750575, 1121751050, 1121752104, 1121752282, 1121754090, 1121755845, 1121759220, 1121944194, 1121944432, 1121945483, 1121946060, 1121946521, 1122014501, 1122015600, 1122016055, 1122016637, 1122017151, 1122018407, 1122018614, 1122019549, 1122019925, 1122020563, 1122077182, 1122095231, 1122095910, 1122096360, 1122350462, 1122437588, 1122438049, 1122438437, 1122438712, 1122439210, 1122439474, 1122440167, 1122440187, 1122470711, 1122475935, 1122475937, 1122480419, 1122480497, 1122480696, 1122480840, 1122480925, 1122480968, 1122481976, 1122482721, 1122482979, 1122548145, 1122548338, 1122549329, 1122549423, 1122549793, 1122550038, 1122550754, 1122550881, 1122551204, 1122551805, 1122552090, 1122552652, 1122625238, 1122787198, 1122787367, 1122790071, 1122790815, 1122793590, 1122793742, 1122806257, 1122806632, 1122808815, 1122808929, 1122828689, 1122828809, 1123356461, 1123356509, 1123357947, 1123410177, 1123413070, 1123413363, 1123506167, 1123506450, 1123620357, 1124050192, 1124050726, 1124051200, 1124052309, 1124054501, 1124163942, 1124166163, 1124191755, 1124243714, 1124264801, 1124284776, 1124376196, 1124378837, 1124379406, 1124380020, 1124380045, 1124381619, 1124382369, 1124383893, 1124503546, 1124633337, 1124633430, 1124633853, 1124634503, 1124634520, 1124636774, 1124637519, 1124653489, 1124653496, 1124653795, 1124654252, 1124836416, 1124845653, 1124982948, 1125268663, 1125268994, 1125585846, 1125642241, 1125643751, 1125643923, 1125645008, 1125646133, 1125646240, 1125646465, 1125646947, 1125646963, 1125647414, 1125649898, 1125649954, 1125651026, 1125702776, 1125704565, 1125705983, 1125708199, 1125708483, 1125766404, 1125767186, 1125770132, 1125810294, 1125814045, 1125814815, 1125815711, 1125816412, 1125816516, 1125817378, 1125852713, 1125853108, 1125853227, 1125853832, 1125854470, 1125854522, 1125887755, 1125888066, 1125888253, 1125889140, 1125889726, 1125890347, 1125926636, 1125926749, 1125927276, 1125993459, 1126118866, 1126312730, 1126313783, 1126314997, 1126317270, 1126769625, 1127452246, 1127557406, 1127557730, 1127557786, 1127558110, 1127558853, 1127671407, 1127671999, 1127673096, 1127673699, 1127674287, 1127675130, 1127677529, 1127678258, 1127678712, 1127679382, 1127680462, 1127855588, 1127862415, 1127862740, 1127886339, 1127886837, 1127887092, 1127888256, 1127888370, 1127892805, 1127893583, 1127893596, 1127894393, 1127894809, 1127894885, 1127897235, 1127897268, 1127902760, 1127903595, 1127903943, 1128009724, 1128009958, 1128799550, 1128909781, 1129704718, 1129705324, 1130175452, 1130200480, 1130201459, 1130201665, 1130201837, 1130786914, 1130788698, 1130788722, 1131072492, 1131072759, 1131268895, 1131271587, 1131272173, 1131275034, 1131362135, 1131362681, 1131425540, 1131426687, 1131634301, 1131635921, 1131638028, 1131693269, 1131850675, 1131850801, 1131850879, 1131853417, 1131854794, 1131855152, 1131856024, 1131865060, 1131866123, 1131866370, 1131866384, 1131867951, 1131869242, 1131870612, 1131870749, 1131871075, 1131871898, 1131874396, 1131993865, 1132057464, 1132128776, 1132129208, 1132137436, 1132298398, 1132667119, 1132668217, 1132668466, 1132668684, 1132668755, 1132679585, 1132683262, 1132703003, 1132704300, 1133009016, 1133012308, 1133019564, 1133033055, 1133034405, 1133034765, 1133036704, 1133036839, 1133037276, 1133037667, 1133038993, 1133040398, 1133040400, 1133040703, 1133042198, 1133042830, 1133042936, 1133043152, 1133044598, 1133044959, 1133045311, 1133046824, 1133046848, 1133047599, 1133048376, 1133048672, 1133049597, 1133050286, 1133078559, 1133136817, 1133139230, 1133502545, 1133767664, 1133909888, 1136673907, 1136733488, 1137232982, 1137511244, 1137511306, 1137512102, 1137615684, 1137844609, 1137845114, 1139487361, 1139488376, 1139488829, 1139489234, 1139636874, 1139637465, 1139645771, 1139860293, 1139934080, 1139934082, 1139934226, 1139945999, 1139963333, 1140189453, 1140190310, 1140546238, 1140553651, 1140558236, 1140869173, 1141016549, 1141016780, 1141047071, 1141133792, 1141146735, 1141253403, 1141256422, 1141259956, 1141448224, 1141449020, 1141449686, 1141468189, 1141601562, 1141603963, 1142204971, 1142205448, 1142205727, 1142729011, 1142732562, 1142733004, 1142794855, 1142795067, 1142795314, 1142795370, 1142796717, 1142796923, 1142797159, 1142797554, 1142797829, 1142798020, 1142798470, 1142799050, 1142947664, 1142947988, 1142948812, 1142950027, 1142950663, 1142950981, 1142951528, 1142951746, 1142952653, 1142953151, 1142953874, 1142971512, 1142971855, 1142972291, 1142972582, 1142972948, 1142973515, 1142973876, 1142974070, 1142974258, 1142974703, 1142975365, 1142976684, 1142976781, 1142976873, 1143146822, 1143230690, 1143505817, 1143907576, 1144095608, 1144121689, 1144122064, 1144122235, 1144122470, 1144490138, 1144491071, 1144644179, 1144645216, 1144645387, 1144907217, 1145330909, 1145359144, 1145369988, 1145420231, 1145475194, 1145623234, 1145623238, 1145975905, 1146094978, 1146095505, 1146122051, 1146122221, 1146122565, 1146136667, 1146291527, 1146309262, 1146309993, 1146435111, 1146577704, 1146586258, 1146612697, 1146612879, 1146613081, 1146765257, 1146808008, 1146955197, 1147019673, 1147019874, 1147020927, 1147021503, 1147021847, 1147067677, 1147089514, 1147092864, 1147093439, 1147094445, 1147125661, 1147197044, 1147197069, 1147296546, 1147298697, 1147454899, 1147621695, 1147622952, 1148041100, 1148835465, 1149329974, 1149330259, 1149412422, 1149485667, 1149485690, 1149485885, 1149547350, 1149560302, 1149980032, 1150036358, 1150036727, 1150037559, 1150138505, 1150175183, 1150189103, 1150250645, 1150250835, 1150250838, 1150297376, 1150377175, 1150412150, 1150569887, 1150678466, 1150678468, 1150961468, 1151454064, 1151454230, 1151455555, 1151456513, 1151783071, 1151809898, 1152138053, 1152749904, 1152940994, 1153017179, 1153520833, 1153521994, 1153693881, 1153899848, 1154453139, 1154455166, 1154524757, 1154882585, 1154882616, 1154882813, 1154882843, 1154882886, 1154882959, 1154882996, 1155662394, 1156206911, 1156497650, 1157797613, 1157861805, 1158010985, 1158011561, 1158012819, 1158014267, 1158014965, 1158015239, 1158015637, 1158104368, 1158104613, 1158104914, 1158105706, 1158108500, 1158110066, 1158374580, 1158378473, 1159173964, 1159174609, 1159175287, 1159175499, 1159176719, 1159197133, 1159229267, 1159229673, 1159551785, 1159556915, 1159564933, 1159727983, 1159728146, 1159731418, 1159793674, 1159793880, 1159803646, 1159814291, 1159816590, 1159830682, 1159877064, 1160137520, 1160138681, 1160139104, 1160169632, 1160208359, 1160208948, 1160210141, 1160210491, 1160214948, 1160220122, 1160221843, 1160222643, 1160224364, 1160227869, 1160228551, 1160459010, 1160619346, 1160681138, 1161162244, 1161162245, 1161163446, 1161165865, 1161188063, 1161279592, 1161282033, 1161285012, 1161287853, 1162590941, 1162595641, 1162760547, 1162760663, 1162761451, 1162763255, 1162764156, 1162764541, 1162767322, 1162768372, 1162769155, 1162769231, 1162769257, 1162769717, 1162770321, 1162788361, 1162790668, 1162890936, 1162895725, 1162896840, 1162900969, 1163110342, 1163201090, 1163870892, 1163919969, 1164290203, 1164314884, 1164336270, 1164338994, 1164543653, 1164793260, 1164853841, 1165461049, 1165461631, 1166034221, 1166650118, 1166680939, 1166779721, 1166886344, 1166892796, 1166964498, 1167000275, 1167001249, 1167001544, 1167003497, 1167003705, 1167003854, 1167009348, 1167129809, 1167158612, 1167207416, 1167208193, 1167209651, 1167213133, 1167220548, 1167301175, 1167349126, 1167393765, 1167395125, 1167557674, 1167558542, 1167649429, 1167732742, 1168378013, 1168400314, 1168743469, 1168748130, 1168748245, 1168750703, 1169694341, 1169697273, 1169706315, 1169707301, 1169713388, 1169717913, 1169718176, 1169818446, 1169856164, 1169860396, 1169916956, 1170051743, 1170453929, 1170595508, 1170595647, 1170595737, 1170599916, 1170599978, 1170695672, 1170737051, 1170751172, 1170761908, 1170762081, 1170884104, 1170902914, 1170914084, 1170916761, 1171027712, 1171035715, 1171057298, 1171057417, 1171062645, 1171062897, 1171071389, 1171074170, 1171207107, 1171210002, 1171211383, 1171213569, 1171213839, 1171217234, 1171488371, 1171488373, 1171735767, 1172443475, 1172530780, 1172540299, 1172541987, 1172542972, 1172603523, 1172604772, 1172685387, 1172687425, 1172687875, 1172688720, 1172691802, 1172691934, 1172692197, 1172695985, 1172696076, 1172696182, 1172696290, 1172707870, 1172708072, 1172708326, 1172710717, 1172710804, 1172710832, 1172714263, 1172730620, 1172732390, 1172754947, 1172762103, 1172766699, 1172828952, 1172831311, 1172831524, 1172844373, 1172844374, 1172844492, 1172898619, 1172898622, 1172898783, 1172903964, 1172923026, 1172925311, 1173005385, 1173030043, 1173070016, 1173082348, 1173145813, 1173215389, 1173216049, 1173220454, 1173221151, 1173221504, 1173222195, 1173225029, 1173225552, 1173226980, 1173227222, 1173227473, 1173247417, 1173317473, 1173322941, 1173359127, 1173391835)

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...