Get user with same group

SQL

SELECT potentially_matched.user_id, 
potentially_matched.user_registration, 
COUNT(*)
FROM (SELECT user.user_id, user.user_registration, user_former_groups.ufg_group FROM 
user right join user_former_groups
on user.user_id = user_former_groups.ufg_user
where 
timestampdiff(MONTH, user.user_registration, '2011-02-11 00:00:00') < 6
and 
user_former_groups.ufg_group IN ('autoreviewer')
and 
user_former_groups.ufg_group != 'bot') as potentially_matched 
right join 
user_former_groups
on potentially_matched.user_id = user_former_groups.ufg_user
GROUP BY potentially_matched.user_id, potentially_matched.user_registration
HAVING COUNT(*) = 1
SQL

Checking query status...
