Deleted revisions

Fork of Get deleted revisions of user by Chlod

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

Get the deleted revisions for a user. You can combine this with the delete/revision action to find the reason behind deletion.

SQL

SELECT
	*,
    (CAST(`main`.`rev_len` AS SIGNED) - CAST(`parent`.`rev_len` AS SIGNED)) AS "diff"
FROM `revision_userindex` AS `main`
LEFT JOIN `revision_userindex` AS `parent` ON `parent`.`rev_id` = `main`.`rev_parent_id`
LEFT JOIN `comment_revision` ON `main`.`rev_comment_id` = `comment_id`
RIGHT JOIN `page` ON `main`.`rev_page` = `page_id`
WHERE
	`main`.`rev_actor` = (SELECT `actor_id` FROM `actor_revision` WHERE `actor_name` = "EpicPupper") AND `main`.`rev_deleted`
ORDER BY `main`.`rev_timestamp` DESC

SQL

Checking query status...