For my REST-API i need to get for every post the username, date ... and Avatar !
$query ="SELECT POST.ID, POST.post_title, POST.post_date, USER.user_nicename FROM wp0x_posts POST INNER JOIN wp0x_users USER ON USER.ID=POST.post_author and POST.post_type='post' ";
The probleme that i have faced is that the avatars are stored in wp_posts , so i don't know how to call it for posts titles and call it again for users avatars
it would be much easier if the avatars were stored in wp_users :/
is there a way to get all these values in one query
POST ID POST TITLE POST DATE AUTHOR AVATAR