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='45' AND i.activo='1'
AP Ibiza
The hotel has elegant restaurants and cocktail lounges, a café next to the beach, a rooftop bar, a lively club, outdoor pools, an outdoor stage free and a recording studio. There is also a spa, a gym and a service free transfer to the airport
Properties:
THE HOTEL HAS ELEGANT RESTAURANTS AND COCKTAIL LOUNGES, A CAFÉ NEXT TO THE BEACH, A ROOFTOP BAR, A LIVELY CLUB, OUTDOOR POOLS, AN OUTDOOR STAGE FREE AND A RECORDING STUDIO. THERE IS ALSO A SPA, A GYM AND A SERVICE FREE TRANSFER TO THE AIRPORT
