Untitled query #56000

SQL

SELECT potentially_matched.user_id, potentially_matched.user_registration, potentially_matched.user_editcount, COUNT(*) 
FROM (SELECT user.user_id, user.user_registration, user.user_editcount, user_former_groups.ufg_group 
      FROM user 
      right join 
      user_former_groups 
      on user.user_id = user_former_groups.ufg_user 
      where ABS(user.user_registration - 20070514133040) < 180 * 24 * 60 * 60 
      and user_former_groups.ufg_group IN ('rollbacker') 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...
