This needs the `visible_to_the_public` scope. Also, we need to add a database index to the group.name field.