SELECT i.*,il.titulo,il.mini,il.descripcion,c.categoria,c.url,c.portada FROM items i LEFT JOIN categorias c ON i.id_categoria=c.id LEFT JOIN items_lang il ON i.id=il.id_item AND il.id_lang='1' WHERE i.id='39' AND i.activo='1'
Rooms: 3 Bathrooms: 2 Area: Marina Botafoch May 800 € x day June 900 € x day July 1.000 € x day August 1.000 € x day Sept 900 € x day Oct 800 € x day Check in : After 15:00 hs Check out: Before 10:00 hs Deposit: 1.000 € Final clean : 150 €