select * from owners where active = 'yes' order by team
 
Team Owner Phone Email Location
#team# #owner#
#owner2#
#phone#
#phone2#
#email#
#email2#
#trim(city)#, #state#
#trim(city2)#, #state2#