Error en la base de datos: Instruccion sql incorrecta: SELECT DISTINCT a.nombre as nombre_area,z.nombre as nombre_zona,d.id_zona FROM producto_alojamiento AS pa, area AS a,zona AS z,destino AS d,producto AS p,producto_detalle AS pd, alojamiento AS alo WHERE alo.id_alojamiento=pa.id_alojamiento AND pa.id_producto=p.id_producto AND alo.cadena='9' AND pd.id_producto=p.id_producto AND a.id_area=z.id_area AND z.id_zona=d.id_zona AND p.id_destino=d.id_destino AND pd.fecha>'2012-05-19' AND a.id_area= ORDER BY nombre_zona
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 'ORDER BY nombre_zona' at line 1)
Parado el proceso.