Error en la base de datos: Instruccion sql incorrecta: SELECT i.imagen,a.id_area,a.nombre as area,z.nombre as zona,d.id_destino,d.nombre as destino,min(pd.precio) as precio_minimo,max(pd.precio) as precio_maximo,pd.noches,max(pd.fecha) as fecha_maxima,min(pd.fecha_inicio) as fecha_minima,pi.id_imagen FROM producto as p,producto_imagen as pi,imagen as i,producto_detalle as pd,area as a,zona as z,destino as d where p.id_destino=d.id_destino AND z.id_zona=d.id_zona AND a.id_area=z.id_area AND pd.id_producto=p.id_producto and p.id_producto=pi.id_producto and pi.id_imagen=i.id_imagen and pd.fecha>'2010-03-13' and z.id_zona= group by d.id_destino order by precio_minimo ASC, d.nombre
MySQL Error: 1064 (You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'group by d.id_destino order by precio_minimo ASC, d.nombre' at line 1)
Parado el proceso.