select
        p1.strenuus_location_id,
	p1.strenuus_id,
	a.address,
	a.suite,
	a.city,
	a.state,
	a.zip,
	max(p1.phone) as phone,
	(a.latitude/1000000.0)::decimal(10,8) as latitude,
	(a.longitude/-1000000.0)::decimal(11,8) as longitude
      from N360_Product p1
      join N360_Address a
	on p1.address_id = a.address_id
       group by
        p1.strenuus_location_id,
	p1.strenuus_id,
	a.address,
	a.suite,
	a.city,
	a.state,
	a.zip,
	latitude,
	longitude