ERROR !!!: MDB2 Error: unknown error - _doQuery: [Error message: Could not execute statement]
[Last executed query: SELECT
pais1.id_country as idpais, coalesce(pais_lng.name, pais_en.name) as paisnom,
regio1.id_region as regio, coalesce(reg_lng.name, reg_en.name) as regionom,
a.id_city as city, coalesce(city_lng.name, city_en.name) as ciutatnom,
a.id_hotel idhotel, a.name as nombre_hotel,
ht.id_hoteltype as codtipohotel, coalesce(ht_lng.name, ht_en.name) as nombretipohotel,
a.class, a.hotel_url, a.bo_ranking, a.latitude, a.longitude,
a.address, a.zip,
ph.id_photo, ph.url_original, ph.url_max300, ph.url_square60,
coalesce(trans_lng.name, trans_en.name) as hotelnametrans,
coalesce(trans_lng.city, trans_en.city) as hotelcitytrans,
coalesce(trans_lng.address, trans_en.address) as hoteladdresstrans,
coalesce(quickdesc_lng.description, quickdesc_en.description) as quickdescription,
a.booking_hotel_id, a.hotusa_hotel_id, a.chain_id
FROM hotels a INNER JOIN cities as t ON a.id_city=t.id_city AND t.id_city IN (5934)
INNER JOIN city_language as city_en
ON city_en.id_city = t.id_city AND city_en.languagecode = 'en'
LEFT JOIN city_language as city_lng
ON city_lng.id_city = t.id_city AND city_lng.languagecode = 'es'
INNER JOIN countries as pais1
ON t.id_country = pais1.id_country
AND pais1.id_original IS NULL AND pais1.id_country IN (24) INNER JOIN country_language as pais_en
ON pais_en.id_country = pais1.id_country AND pais_en.languagecode = 'en'
LEFT JOIN country_language as pais_lng
ON pais_lng.id_country = pais1.id_country AND pais_lng.languagecode = 'es'
INNER JOIN citiesxregion as cr
ON a.id_city = cr.id_city
INNER JOIN regions as regio1
ON regio1.id_region= cr.id_region AND regio1.id_region IN (277)
AND regio1.id_original IS NULL AND regio1.ocult = 0 INNER JOIN region_language as reg_en
ON reg_en.id_region = regio1.id_region AND reg_en.languagecode = 'en'
LEFT JOIN region_language as reg_lng
ON reg_lng.id_region = regio1.id_region AND reg_lng.languagecode ='es'
/* Captamos los datos de tipo de hotel */
LEFT JOIN hotel_types ht ON a.id_hoteltype = ht.id_hoteltype
INNER JOIN hotel_type_language as ht_en
ON ht_en.id_hoteltype = ht.id_hoteltype AND ht_en.languagecode = 'en'
LEFT JOIN hotel_type_language as ht_lng
ON ht_lng.id_hoteltype = ht.id_hoteltype AND ht_lng.languagecode = 'es'
/* Captamos los datos de photos */
LEFT JOIN hotel_photos ph ON a.id_hotel = ph.id_hotel
AND (ph.logo = '' OR ph.logo IS NULL)
AND (ph.plano = '' OR ph.plano IS NULL)
/* Captamos las translations */
LEFT JOIN hotel_translations as trans_en
ON a.id_hotel = trans_en.id_hotel AND trans_en.languagecode = 'en'
LEFT JOIN hotel_translations as trans_lng
ON a.id_hotel = trans_lng.id_hotel AND trans_lng.languagecode = 'es'
/* Captamos la descripcion corta */
LEFT JOIN hotel_description_translations AS quickdesc_en
ON a.id_hotel = quickdesc_en.id_hotel AND quickdesc_en.languagecode = 'en'
AND quickdesc_en.descriptiontype_id= 6
LEFT JOIN hotel_description_translations AS quickdesc_lng
ON a.id_hotel = quickdesc_lng.id_hotel AND quickdesc_lng.languagecode = 'es'
AND quickdesc_lng.descriptiontype_id= 6
WHERE (a.bo_is_closed IS NULL OR a.bo_is_closed=0)
AND a.descartado = 0 GROUP BY class, nombre_hotel ORDER BY class DESC, nombre_hotel LIMIT 0 , 20 ;]
[Native code: 1030]
[Native message: Got error 28 from storage engine]
Le ofrecemos hoteles en Benalup Casas Viejas con confirmación Inmediata. Pago Directo al hotel de Benalup Casas Viejas y sin Gastos de Gestión.
