Query - MySQL - WordPress | Display Post Revisions

query_mysql_display_post_revisions_WP.sql

SELECT 
    p.ID AS original_post_id,
    p.post_title AS original_post_title,
    p.post_modified AS last_modified_date,
    r.ID AS revision_id,
    r.post_modified AS revision_date,
    u.display_name AS author_name,
    u.user_email AS author_email
FROM 
    wp_posts p
LEFT JOIN 
    wp_posts r ON r.post_parent = p.ID AND r.post_type = 'revision'
LEFT JOIN 
    wp_users u ON r.post_author = u.ID
WHERE 
    p.ID = 2804 -- ID Post
ORDER BY 
    r.post_modified DESC;