Comentarios y opiniones de Escuela Española de Esquí de Navacerrada
Escuela de Esquí en Navacerrada, Madrid
Navacerrada, Madrid
En estos momentos no está disponible la información de Escuela Española de Esquí de Navacerrada.
A continuación te mostramos resultados cercanos:
SELECT SQL_CALC_FOUND_ROWS wp_posts.*, ROUND(111.111 * DEGREES(ACOS(LEAST(COS(RADIANS(mt1.meta_value)) * COS(RADIANS(40.787695)) * COS(RADIANS(wp_postmeta.meta_value - -4.002908)) + SIN(RADIANS(mt1.meta_value)) * SIN(RADIANS(40.787695)), 1.0)))) AS distance_in_km
FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) INNER JOIN wp_postmeta AS mt1 ON ( wp_posts.ID = mt1.post_id )
WHERE 1=1 AND (
wp_term_relationships.term_taxonomy_id IN (11,49,55)
) AND (
( wp_postmeta.meta_key = 'property_longitude' AND CAST(wp_postmeta.meta_value AS DECIMAL) BETWEEN '-5.7995725622372' AND '-2.2062426449628' )
AND
( mt1.meta_key = 'property_latitude' AND CAST(mt1.meta_value AS DECIMAL) BETWEEN '38.981786315577' AND '42.585692698369' )
) AND wp_posts.post_type = 'estate_property' AND ((wp_posts.post_status = 'publish'))
GROUP BY wp_posts.ID
ORDER BY distance_in_km ASC, wp_posts.post_date DESC
LIMIT 0, 16
Aventura y relajación
