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