testing query - Quarry

SQL

-- start: 1096861007
-- end: 1173359127
SET @START = 1096861007;
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` > @START
    AND `rev_id` < (@START + 1000000)
    AND `comment_text` LIKE "%[[User:Chlod/Scripts/Deputy|Deputy]]%";
SQL

Checking query status...
