No valid database connection 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 ' u.name AS author, u.usertype, cc.title AS category, s.title AS section, CASE WH' at line 1 SQL=SELECT DISTINCT a.id, a.*, jfc.value as jfcvalue, , u.name AS author, u.usertype, cc.title AS category, s.title AS section, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END as slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END as catslug, g.name AS groups, s.published AS sec_pub, cc.published AS cat_pub, s.access AS sec_access, cc.access AS cat_access FROM jos_content AS a LEFT JOIN jos_categories AS cc ON cc.id = a.catid LEFT JOIN jos_sections AS s ON s.id = cc.section AND s.scope = "content" LEFT JOIN jos_users AS u ON u.id = a.created_by LEFT JOIN jos_groups AS g ON a.access = g.id LEFT JOIN jos_jf_content as jfc ON jfc.reference_table='content' AND jfc.reference_id=a.id AND jfc.reference_field='title' AND jfc.language_id =1 WHERE jfc.reference_id IS NOT NULL AND jfc.published=1 AND a.id = 59 AND ( ( a.created_by = 0 ) OR ( a.state = 1 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2010-09-05 15:34:12' ) AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2010-09-05 15:34:12' ) ) OR ( a.state = -1 ) )
Hotel partner with Aquafan and Oltremare/Imax theme parks
- Imax included in the Oltremare price
- Avoid the line. Straight access to the parks
- Oltremare free entrace the day after
- Aquafan second day free entrace when you want
Oltremare – fly on the wings of adventure
Oltremare, a new theme park, will immerse you in a GREAT ADVENTURE from the BEGINNING OF LIFE ON EARTH to the marvels of the Adriatic Sea and the charm of our animals. Oltremare is a JOURNEY THROUGH TIME and space with lots of ADVENTURE ROUTES and exciting attractions.
Oltremare is divided in 3 main areas:
-
A JOURNEY THROUGHT TIME – allows visitors to discover the origin of our planet, through the milestones of the Life’s Evolution, from the Big Bang to the Dinosaurs exctinction, till the Ice Age.
-
FROM THE OCEANS TO THE ADRIATIC SEA – see our 11 dolphins with their amazing show in the largest dolphin lagoon in Europe. See the creatures that inhabit the reefs from the sea horses, the sea dragons to rays and colourful invertebrates. Have a walk through life-size reproductions of mantas, sharks, moonfish and many other marine vertebrates.
-
OUR ANIMALS – THE DELTA AND ITS MARSHLANDS – an adventure that will lead you through land and water , through the habitat of the Po River where you can observe the habitats of birds, reptiles, insects, fish and many other typical animal. Enjoy the spectacular flight of the birds of prey and the happiest farm in the world which is populated by the most unruly tribe of animals ever.
IMAX offers the most spectacular and exciting cinematographic experience in the world. Two and three-dimension films are shown in a giant screen of over 600 square metres, as tall as a 7-storey building and wide enough to show a razorback whale, spectators have the privilege of visiting and exploring distant places, entering a completely new dimension and living an unforgettable adventure.
IMAX goes beyond the cinema: wonder, amazement and discovery.
 
Aquafan, the most famous water park in Europe, owes its huge success to the fact that is not just a water park. In 20 years of activity Aquafan has always succeeded in leaving its mark on fashions and trends. Aquafan aims to offer to the public real emotions, emotions that go far beyond its fantastic waterslides and games and its pleasant, green surroundings.
Aquafan is a “Place of Opportunities”: opportunities for living and opportunities for reliving various events, initiatives, gatherings and surprise entertainment that the park has planned to organise for this coming season.
|
