Untitled

set @counter:=0; select @counter:=@counter+1 as rank, user_name, user_editcount from user where user_name not in (select ug_user from user_groups where ug_group = 'bot') order by user_editcount desc limit 4000;