removed last log and changed chatroomusers_userid to use a join