SELECT pname `National Park` ,plat `Park Latitude` ,wslat `Weather Station Latitude` ,plong `Park Longitude` ,wslong `Weather Station Longitude` ,wsid `Weather Station ID` ,distance `Distance` FROM ( SELECT p.Name as pname ,p.State as pstate ,p.Latitude as plat ,ws.Latitude as wslat ,p.Longitude as plong ,ws.Longitude as wslong ,ws.ID as wsid ,3956 * 2 * ASIN(SQRT(POWER(SIN((p.Latitude-ws.Latitude) * pi()/180 / 2), 2) +COS(p.Latitude * pi()/180) *COS(ws.Latitude * pi()/180) *POWER(SIN((p.Longitude - ws.Longitude) * pi()/180 / 2), 2) )) as distance FROM `WeatherStation` ws,`Parks` p ORDER BY Distance) as park GROUP BY pname