Untitled

mysql>

update user set last_email = (select max(email.date_created) from email join contact on (contact.id = email.contact) join user u on (u.id = contact.user) where user.id = u.id);