-2147217871: Query timeout expired

SELECT id_tour, codigo, tipo_tour, duracion_0 AS duracion, tref_usd, tref_clp, IsNull(html_titulo_0, '') AS html_titulo, IsNull(html_desc_0, '') AS html_desc, IsNull(html_kw_0, '') AS html_kw, dias, n_cultural, n_dificultad, n_naturaleza, n_vida_nocturna, nombre_0 AS nombre, desc_corta_0 AS desc_corta, itinerario_0 AS itinerario, notas_itinerario_0 notas_itinerario, detalle_itinerario_0 AS detalle_itinerario, equipamiento_0 AS equipamiento, comentario_0 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_0 AS lugar_inicio, lugar_fin_0 AS lugar_fin, idiomas, horarios_inicio, incluye_0 AS incluye, no_incluye_0 AS no_incluye, condicion_clima, condicion_camino, politica_anulacion_0 AS politica_anulacion, condiciones_0 AS condiciones, esencial, tipo_esencial, es_conexion, STUFF((SELECT '/es/' + url_0 + '/' 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_0 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_0 = 'excursion-a-palguin-y-caburga' 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.