added in queries with left joins in order to get user names attached to message outputs: