Blunders - Quarry

SQL

SELECT
	`rev_id` AS "ID",
    `page_namespace` AS "Namespace",
    REPLACE(`page_title`, "_", " ") AS "Page",
    DATE_FORMAT(`rev_timestamp`, "%Y-%m-%d %H:%i:%s") AS "Time",
    `comment_text` AS "Comment"
FROM `revision_userindex`
RIGHT JOIN `comment_revision` ON `rev_comment_id` = `comment_id`
RIGHT JOIN `page` ON `rev_page` = `page_id`
WHERE
	`comment_text` LIKE "%oops%"
    AND `comment_text` NOT LIKE "%troops%"
    AND `rev_actor` = (SELECT `actor_id` FROM `actor_revision` WHERE `actor_name` = "Chlod")
ORDER BY `rev_timestamp` DESC
SQL

Checking query status...
