select id, login, (select comment_text from jos_comments
left join jos_posts on jos_posts.id = jos_comments.post_id
left join jos_users on jos_users.id = jos_posts.user_id
where jos_users.id = u.id
order by date_create desc
limit 1) as comment from jos_users as u
