SELECT user.username, user.userid, user.email, user.joindate, useractivation.activationid
SELECT DISTINCT(user.username), user.userid, user.email, user.joindate, useractivation.activationid