select * ,IF((ral_titulo_ENG IS NOT NULL) and (ral_titulo_ENG<>''), ral_titulo_ENG, ral_titulo_ESP) as ral_titulo ,IF((ral_titulo_posic_ENG IS NOT NULL) and (ral_titulo_posic_ENG<>''), ral_titulo_posic_ENG, ral_titulo_posic_ESP) as ral_titulo_posic ,IF((ral_intro_ENG IS NOT NULL) and (ral_intro_ENG<>''), ral_intro_ENG, ral_intro_ESP) as ral_intro ,IF((ral_texto_ENG IS NOT NULL) and (ral_texto_ENG<>''), ral_texto_ENG, ral_texto_ESP) as ral_texto ,IF((reg_nombre_ENG IS NOT NULL) and (reg_nombre_ENG<>''), reg_nombre_ENG, reg_nombre_ESP) as reg_nombre from tbm_regionAlquiler inner join Region on (reg_id=ral_reg_id) where (ral_id=18)
Boat rental Gulets in Ciudadella - Rent gulets in Menorca - Top Barcos Mallorca .com
Ciudadela was formerly the capital of Minorca. Its harbour is hidden away in a narrow cove that is more than a kilometre long. The harbour is used by commercial, fishing and passenger boats, although a number of berths are available for recreational vessels passing through. The harbour has 174 berths, a refuelling station, a bar and restaurant, a workshop, a maritime channel, drinking water and a crane service. It also provides meteorological information.