Select distinct(p.id_promocion) as pid,p.*,n.logo, b.nombre as nombrebarco
from promocion p
left join barco b on b.id_barco = p.id_barco
left join naviera n on b.id_naviera = n.id_naviera
left join itinerario i on i.id_promocion = p.id_promocion
inner join precio_promocion pp on pp.id_promocion = p.id_promocion
where date_format(pp.fecha_salida,"%M %Y") = "" and n.id_naviera = 9 and p.id_barco = and i.nro_dia = 1 and i.id_destino = UNION Select distinct(p.id_promocion) as pid,p.*,n.logo, b.nombre as nombrebarco
from promocion p
left join barco b on b.id_barco = p.id_barco
left join naviera n on b.id_naviera = n.id_naviera
left join itinerario i on i.id_promocion = p.id_promocion
inner join precio_promocion pp on pp.id_promocion = p.id_promocion
where date_format(pp.fecha_salida,"%M %Y") = "" and n.id_naviera = 9 and p.id_barco = and i.nro_dia = 1 and i.id_destino = order by pid desc LIMIT 0, 10You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and i.nro_dia = 1 and i.id_destino = UNION Select distinct(p.id_promocion) as pi' at line 7Select distinct(p.id_promocion) as pid,p.*,n.logo, b.nombre as nombrebarco
from promocion p
left join barco b on b.id_barco = p.id_barco
left join naviera n on b.id_naviera = n.id_naviera
left join itinerario i on i.id_promocion = p.id_promocion
inner join precio_promocion pp on pp.id_promocion = p.id_promocion
where date_format(pp.fecha_salida,"%M %Y") = "" and n.id_naviera = 9 and p.id_barco = and i.nro_dia = 1 and i.id_destino = UNION Select distinct(p.id_promocion) as pid,p.*,n.logo, b.nombre as nombrebarco
from promocion p
left join barco b on b.id_barco = p.id_barco
left join naviera n on b.id_naviera = n.id_naviera
left join itinerario i on i.id_promocion = p.id_promocion
inner join precio_promocion pp on pp.id_promocion = p.id_promocion
where date_format(pp.fecha_salida,"%M %Y") = "" and n.id_naviera = 9 and p.id_barco = and i.nro_dia = 1 and i.id_destino = order by pid desc
- CrucerosPremium.com
