Edits made with Deputy (userscript, tagged)

Edits made using the Deputy CCI user script. Only checks tagged revisions. See query/70097 to see all non-tagged revisions.

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 `change_tag` ON `ct_rev_id` = `rev_id`
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
	WHERE ct_tag_id = 655
    AND `actor_id` != 210693732 -- not User:Chlod (test);

SQL

Checking query status...