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 tb_hoteles.nombre' at line 1
SELECT *, tb_textos.cod as codK, tb_hoteles.nombre as nombreH FROM tb_hoteles LEFT JOIN tb_textos ON tb_hoteles.ciudad = lower(tb_textos.nombre_en) WHERE tb_hoteles.cod= ORDER BY tb_hoteles.nombreYou 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 tb_hoteles.nombre' at line 1
SELECT *, tb_textos.cod as codK, tb_hoteles.nombre as nombreH FROM tb_hoteles LEFT JOIN tb_textos ON tb_hoteles.ciudad = lower(tb_textos.nombre_en) WHERE tb_hoteles.cod= ORDER BY tb_hoteles.nombre

Searching car & rates in the dates

Pickup
27/05/2020 12:00
Return
03/06/2020 12:00
Days
7


MODIFY DATES


Prices and best service to rent a car in Pueblo Camino Real hotel


Cargest will supply a delivery and collection service of your car rental straight to the hotel Pueblo Camino Real reception, included in the price. Fair fuel policy, we do not charge for petrol in advance. Enjoy your holiday car hire!

Searching car & rates in the dates



Cart online




Localization map