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='43' AND i.activo='1'
ROOMS :Deluxe Silver (Room:33 sqm)Deluxe Gold (Room:33 sqm)Deluxe Swim-Up (Room:33 sqm)Studio Suite Tub Terrace (Room:36 sqm - Terrace:10 sqm)Studio Suite Silver (Room:48 sqm) Studio Suite Gold (Room:48 sqm)Studio Suite Platinum (Room:48 sqm)Studio Suite Swim-Up (Room:48 sqm)Rock Suite (Room:60 sqm - Terrace : 10 sqm)80´S Suite (Room:60 sqm) Rock Suite Platinum (Room:80 sqm )Rock Suite Diamond (Room:75 sqm - Terrace:10 sqm )Rock Suite Legend (Room:75 sqm - Terrace:10 sqm)Rock Star Suite (Room:165 sqm - Terrace:32 sqm) Este hotel de lujo se encuentra a 1 minuto a pie de la playa Platja d'en Bossa.