Necesito realizar un query específico en Wordpress que me traiga el último post por autor

SELECT a.ID,

(SELECT count(*)
FROM posts
WHERE a.ID = posts.post_author
AND posts.post_type = 'post'
AND posts.post_status = 'publish') AS post_count,
											 
(SELECT posts.ID
FROM posts
WHERE a.ID = posts.post_author
AND posts.post_type = 'post'
AND posts.post_status = 'publish'
***** BY posts.post_date DESC LIMIT 1) AS latest_post_ID

FROM users As a
***** BY post_count DESC