Miscellany

SELECT messages.*, members.username FROM messages LEFT JOIN members ON messages.from_id=members.id WHERE to_id = '1' AND location = 'inbox' AND messages.created=(SELECT MAX(messages.created) FROM messages WHERE messages.to_id = '1') GROUP BY members.username ORDER BY messages.created DESC