Is there a query I can run in the admincp back screen to mass move users from the "users awaiting confirmation" usergroup to the registered user usergroup?
Quickest way IMO is to use the promotion system, and select the usergroup you want, then settings the Days Registered and Posts to 0, Promotion Strategy set to Joined.