A query to get the most recent post IDs from WordPress, one most recent from two different post types

query.sql

(select ID, max(post_date) as max_post_date, post_type from wp_posts where post_type = 'post' and post_status='publish' group by id order by max_post_date desc limit 1)
union
(select ID, max(post_date) as max_post_date, post_type from wp_posts where post_type = 'event' and post_status='publish' group by id order by max_post_date desc limit 1)