-2147217871: Query timeout expired

SELECT id_tour, codigo, tipo_tour, duracion_1 AS duracion, tref_usd, tref_clp, IsNull(html_titulo_1, '') AS html_titulo, IsNull(html_desc_1, '') AS html_desc, IsNull(html_kw_1, '') AS html_kw, dias, n_cultural, n_dificultad, n_naturaleza, n_vida_nocturna, nombre_1 AS nombre, desc_corta_1 AS desc_corta, itinerario_1 AS itinerario, notas_itinerario_1 notas_itinerario, detalle_itinerario_1 AS detalle_itinerario, equipamiento_1 AS equipamiento, comentario_1 AS comentario, the_geom_google_static, the_geom_encpoly, the_geom_centroid.STAsText() AS centroid, the_geom_lat AS y, the_geom_lng AS x, es_esencial, es_opcional, servicio_privado, url_0, url_1, url_2, posicion_validez, sitio_0, tarifas_formato_oris, desayuno, boxlunch, almuerzo, cena, lugar_inicio_1 AS lugar_inicio, lugar_fin_1 AS lugar_fin, idiomas, horarios_inicio, incluye_1 AS incluye, no_incluye_1 AS no_incluye, condicion_clima, condicion_camino, politica_anulacion_1 AS politica_anulacion, condiciones_1 AS condiciones, esencial, tipo_esencial, es_conexion, STUFF((SELECT '/en/' + url_1 + '/' AS [span/@data-href], 'a' AS [span/@data-tipo], 'tooltip atractivo' AS [span/@class], at.id_atractivo AS [span/@data-id], CONCAT(CAST(ROUND((CASE WHEN at.the_geom.STGeometryType() = 'Point' THEN at.the_geom ELSE at.the_geom.STCentroid() END).STY, 6) AS varchar(max)), ' ', CAST(ROUND((CASE WHEN at.the_geom.STGeometryType() = 'Point' THEN at.the_geom ELSE at.the_geom.STCentroid() END).STX, 6) AS varchar(max)) ) AS[span/@data-latlng], at.nombre_1 AS span FROM atractivo at WHERE activo = 1 AND id_atractivo IN (SELECT id_atractivo FROM tour_atractivo WHERE id_tour = t.id_tour ) FOR XML PATH('')), 1, 0, '') AS highlights FROM ovw_ficha_tour t WHERE url_1 = 'cruce-andino-en-un-dia' ORDER BY sitio_0 DESC

An error occurred on the server when processing the URL. Please contact the system administrator.

If you are the system administrator please click here to find out more about this error.