SELECT resort_id, round( 6378 * 2 * atan2( sqrt( pow(sin(radians(38,0000 - latitude) /2),2) + cos(radians(latitude)) * cos(radians(38,0000)) * (pow(sin(( radians(-97,0000 - longitude) )/2),2)) ), sqrt(1- pow(sin(radians(38,0000 - latitude) /2),2) + cos(radians(latitude)) * cos(radians(38,0000)) * (pow(sin(( radians(-97,0000 - longitude) )/2),2)) ) ) ,1) as d FROM ots_si.resort r INNER JOIN ots_si.services_subscribed_web on resort=resort_id and is_listed='y' WHERE round( 6378 * 2 * atan2( sqrt( pow(sin(radians(38,0000 - latitude) /2),2) + cos(radians(latitude)) * cos(radians(38,0000)) * (pow(sin(( radians(-97,0000 - longitude) )/2),2)) ), sqrt(1- pow(sin(radians(38,0000 - latitude) /2),2) + cos(radians(latitude)) * cos(radians(38,0000)) * (pow(sin(( radians(-97,0000 - longitude) )/2),2)) ) ) ,1) <= 480 order by d OnTheSkiInfo::Service::OXSOmniListHelper /home/webadmin/live_oxs_public/lib/perl/OnTheSkiInfo/Service/OXSOmniListHelper.pm 95

Bollettini neve

Pubblicità

Ricevi notizie da Skiinfo

Ricevi notizie da Skiinfo Ricevi i bollettini neve, le previsioni meteo e le informazioni delle tue stazioni sciistiche preferite. Inzia qui...

Pubblicità