fox - Quarry

This query is marked as a draft This query has been published by Nintendofan885.

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 "%fox%"
    AND `comment_text` NOT LIKE "%roops%"

    AND `rev_actor` = (SELECT `actor_id` FROM `actor_revision` WHERE `actor_name` = "Nintendofan885")
ORDER BY `rev_timestamp` DESC

SQL

Checking query status...