wp sql query - get all revisions prior to a specific date, unique to post ID

gistfile1.txt

select ID,post_author,post_title,post_parent from `wp_posts` where `post_type` = 'revision' AND `post_date` <= '2024-10-16 00:00:00' AND post_parent IN (SELECT post_parent FROM (SELECT post_parent, COUNT(post_parent) FROM wp_posts
                                 GROUP BY post_parent 
                                 HAVING COUNT(post_parent) = 1) AS subQuery);