select user_id, count(*) from registered_users
group by user_id
having count(*) > 1
this should give no rows at all.
It is giving me a row for any user mapped to any group, the count being the number of groups he is mapped to.
Mapping a user to a group maps him to registered_users also?
Weird!