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` > 1096861007
    AND `actor_id` != 210693732 -- not User:Chlod (test)
    -- see https://quarry.wmcloud.org/query/72289
    AND `comment_id` IN (397748616, 398073967, 399402669, 399424547, 399478073, 399914020, 401379499, 401579102, 403298105, 403299322, 403299647, 403299818, 403326218, 403328978, 403376319, 403388187, 403388259, 403435572, 403435573, 403464577, 403857375, 403857741, 404054453, 404237522, 404258912, 404259161, 404260187, 404316684, 404419598, 404423386, 404708717, 404709091, 404765034, 404792122, 404792124, 404896372, 404897122, 404984320, 404991065, 405179599, 405341935, 405353377, 405353468, 405355280, 405361063, 405361509, 405434407, 405440354, 405440367, 405443635, 405517043, 405524413, 405524468, 405526146, 405702254, 405702281, 405702325, 405746754, 405746915, 405859349, 405925818, 406006869, 406111312, 406116237, 406116664, 406122528, 406125027, 406141448, 406141697, 406159399, 406160721, 406161367, 406161561, 406168546, 406195109, 406195810, 406195912, 406197318, 406197544, 406199025, 406200300, 406201054, 406201066, 406201825, 406202775, 406239445, 406279670, 406281192, 406349163, 406358002, 406361119, 406361236, 406363025, 406402376, 406405129, 406418126, 406442291, 406502493, 406502594, 406523826, 406524712, 406547856, 406641874, 406642415, 406802418, 406803035, 406925614, 406925945, 406931585, 407168696, 407170855, 407171411, 407175104, 407248996, 407351427, 407361445, 407361632, 407404625, 407404628, 407439463, 407442687, 407444699, 407490740, 407586860, 407604370, 407604621, 407642128, 407649277, 407677206, 407677214, 407842802, 407870764, 407918066, 407919528, 407922022, 407927061, 407976457, 407977316, 408076703, 408082394, 408091750, 408142221, 408142884, 408144613, 408200974, 408205735, 408213240, 408213875, 408214862, 408215129, 408215836, 408216176, 408225057, 408225825, 408226359, 408295215, 408430496, 408430777, 408432199, 408456865, 408460832, 408460884, 408464796, 408464831, 408496789, 408498321, 408499193, 408499318, 408499387, 408499592, 408500692, 408502376, 408502626, 408502934, 408503581, 408503609, 408506801, 408510213, 408510444, 408510547, 408511137, 408511549, 408512343, 408516449, 408521074, 408522091, 408522679, 408523331, 408531782, 408532595, 408533884, 408535117, 408535786, 408536623, 408537282, 408537721, 408538365, 408538598, 408538689, 408576589, 408576996, 408578244, 408578395, 408579257, 408582238, 408582683, 408593404, 408597234, 408608418, 408614793, 408616046, 408619305, 408668225, 408686134, 408688292, 408688404, 408689237, 408854034, 408856786, 408856876, 408856989, 408857752, 408858026, 408858505, 408858597, 408901888, 409003008, 409004438, 409057919, 409110021, 409362806, 409450112, 409713317, 409713420, 409713562, 409713638, 409713720, 409713789, 409713829, 409713924, 409713961, 409717987, 409718074, 409718088, 409718184, 409718205, 409718246, 409718255, 409718282, 409718308, 409718353, 409718483, 409718513, 409718550, 409718611, 409719070, 409719305, 409719938, 409720230, 409720668, 409727301, 409727663, 409738861, 409788787, 409788970, 409789422, 409789862, 409790164, 409790339, 409806213, 409807301, 409807717, 409808523, 409808781, 409809084, 409843677, 409844328, 409844996, 409938782, 409970817, 409970964, 409971185, 409972616, 409997113, 410004436, 410152089, 410152736, 410166816, 410168854, 410168857, 410170661, 410170697, 410170773, 410170843, 410171738, 410200972, 410201861, 410202146, 410321932, 410604534, 410666359, 410709467, 410866730, 410866905, 410867074, 410868297, 410911238, 410911997, 410921962, 410940970, 411016915, 411017935, 411018387, 411019929, 411137162, 411137201, 411137384, 411137632, 411137635, 411138538, 411138807, 411150699, 411150960, 411151368, 411239234, 411305112, 411553001, 411574142, 411574729, 411574818, 411575301, 411575803, 411575937, 411576142, 411576338, 411577650, 411577666, 411578068, 411603913, 411604612, 411606056, 411629847, 411630146, 411646605, 411647938, 411648222, 411648492, 411648832, 411648888, 411649305, 411662047, 411662178, 411662217, 411662677, 411682545, 411682660, 411682726, 411683036, 411683286, 411683549, 411698656, 412056345, 412365699, 412409332, 412409448, 412461562, 412461738, 412462040, 412462187, 412462390, 412462892, 412464662, 412464794, 412465379, 412538767, 412541050, 412541159, 412548547, 412548710, 412548800, 412549176, 412549219, 412550877, 412551724, 412552832, 412552859, 412557894, 412559351, 412559982, 412607210, 412607304, 413328456, 413328770, 413540252, 413548834, 413549293, 413801389, 413802046, 413912662, 413993260, 413994419, 413994708, 413996236, 414038410, 414038635, 414067211, 414160268, 414160810, 414161540, 414183363, 414252596, 414252642, 414252675, 414253518, 414253967, 414254095, 414254353, 414257950, 414258649, 414259201, 414259774, 414260218, 414261180, 414321434, 414347714, 414377389, 414382523, 414450385, 414609774, 414610223, 414610291, 414613631, 414621740, 414622233, 414768687, 414770430, 414774176, 414781105, 414783781, 414783883, 414784418, 414784613, 414785398, 414786108, 414786472, 414786791, 414787361, 414799797, 414822957, 414823799, 415031445, 415214332, 415316883, 416220367, 417137904, 417164312, 417420464, 417440489, 417564503, 417564524, 417564795, 417629131, 417749714, 417749981, 418540072, 418540726, 418540984, 418541306, 418607841, 418608011, 418611098, 418714311, 418749168, 418749171, 418754800, 418762211, 418867478, 418867811, 419023337, 419027187, 419029634, 419162562, 419224200, 419224283, 419238016, 419320013, 419325488, 419377794, 419486138, 419486653, 419487200, 419497222, 419569442, 419570631, 419885282, 419885494, 419885620, 420178506, 420179791, 420179956, 420208850, 420208972, 420209148, 420209820, 420209904, 420210275, 420210556, 420284765, 420285327, 420285695, 420286187, 420286648, 420286791, 420293025, 420293130, 420293296, 420293392, 420293681, 420293805, 420293882, 420293962, 420294353, 420585473, 420886704, 421026508, 421037903, 421038065, 421038169, 421237004, 421237212);

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