Get authors of the last modified wordpress posts

lastmodifieduser.sql

select wp_postmeta.post_id, meta_value as 'authorid', user_login, post_title, post_type, post_modified, post_date
from wp_postmeta
inner join wp_posts
on wp_posts.ID = post_id
	inner join wp_users
	on wp_users.ID = meta_value
where meta_key ='_edit_last'
order by post_modified desc