SELECT w.Moneda, w.Operador, w.Precio, w.Tipo, w.ID_Salida, w.NombreHotel, w.CategoriaHotel, w.ID_Regimen, w.NombreRegimen, w.PaisDest from ( SELECT pt.Moneda, pt.Operador, (CASE WHEN pt.doble > 0 THEN pt.doble ELSE pt.single END) AS 'Precio', (CASE WHEN pt.doble > 0 THEN 'Base Doble' ELSE 'Base Single' eND) AS 'Tipo', pt.ID_Salida, h.NombreHotel, h.CategoriaHotel, r.ID AS ID_Regimen, r.NombreRegimen, de.PaisDest FROM hacien_db.producto_tarifas AS pt JOIN hacien_db.salida_hotel_regimen AS shr ON shr.ID_Salida = pt.ID_Salida JOIN hacien_db.hoteles_es as h ON shr.ID_Hotel = h.ID and pt.ID_Producto = 1695 JOIN hacien_db.producto_destino AS pd ON pd.ID_Producto = pt.ID_Producto JOIN hacien_db.destinos_es AS de ON pd.ID_Destino = de.ID join ( select x.id_salida from (select d.id_salida, group_concat(d.NombreHotel) hoteles from ( SELECT pt.Moneda, pt.Operador, (CASE WHEN pt.doble > 0 THEN pt.doble ELSE pt.single END) AS 'precio', (CASE WHEN pt.doble > 0 THEN 'Base Doble' ELSE 'Base Single' END) AS 'Tipo', pt.Doble, pt.single, pt.ID_Salida, h.NombreHotel, h.CategoriaHotel FROM hacien_db.producto_tarifas AS pt JOIN hacien_db.salida_hotel_regimen AS shr ON shr.ID_Salida = pt.ID_Salida JOIN hacien_db.hoteles_es as h ON shr.ID_Hotel = h.ID WHERE pt.ID_Producto = 1695 ) d group by d.ID_Salida order by d.precio ) x group by hoteles order by x.id_salida) x on x.id_salida = pt.id_salida join travelto_precargados.regimenes r on r.id = shr.id_regimen group by h.NombreHotel, pt.ID_Salida order by precio limit 100 ) w group by w.NombreHotel, w.ID_Salida order by Precio

Error: Disk full (/tmp/#sql_650_9.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")