SELECT p.ID, p.Titulo, p.Subtitulo, p.Shortdesc, p.Operador, p.Noches, p.Plan, p.Oferta, p.Descuento, p.Origen, p.Vendidos, p.Moneda, p.Orden, d.NombreDest, rg.NombreRegimen, MIN(pi.URL) as Imagen FROM productos_es as p LEFT JOIN producto_destino as pd ON pd.ID_Producto = p.ID AND pd.Tipo_Producto = 'Paquete' LEFT JOIN destinos_es as d ON pd.ID_Destino = d.ID LEFT JOIN producto_images AS pi ON pi.ID_Producto = p.ID AND pi.Tipo_Producto = 'Paquete' AND pi.Orden < 2 LEFT JOIN regimenes as rg ON rg.ID = p.Regimen LEFT JOIN producto_tematica as pt ON pt.ID_Producto = p.ID AND pt.Tipo_Producto = 'Paquete' WHERE p.Visible='1' AND (Vencimiento='0000-00-00' OR (Alta <= '2026-04-26' AND Vencimiento >= '2026-04-26')) AND pt.ID_Tematica = 6 AND Archivado!=1 AND Idioma = 'english' GROUP BY p.ID ORDER BY p.Orden LIMIT 12

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