Share
website
Welcome to
the Undersea Hunter Group
You have arrived at the official website of the Undersea Hunter Group, one of the world's
preeminent adventure dive operators. We specialize in live-aboard diving to Cocos Islands,
while offering unique project capabilities anywhere on the planet.
preeminent adventure dive operators. We specialize in live-aboard diving to Cocos Islands,
while offering unique project capabilities anywhere on the planet.
Welcome aboard to find out more...
SELECT
*,
DATE_FORMAT(ter_von,'%d %b') AS von,
DATE_FORMAT(ter_bis,'%d %b %Y') AS bis,
CONCAT(DATE_FORMAT(ter_von,'%d%b'),'-',DATE_FORMAT(ter_bis,'%d%b %Y')) AS tripdatum
FROM
tripreports,
beschreibung,
pax_uh_termine,
pax_uh_routen_details
WHERE
tri_sperren='a'
and bes_obj_flag='TRI' and bes_obj_key=tri_key and bes_sperren='a' and bes_modus=1
and ter_key=tri_ter_key_paxtool
and roud_key=ter_rou_key and roud_sprache='e'
and tri_deepsee=''
ORDER BY
ter_von DESC,
ter_bis DESC,
ter_schiff,
tri_key,
bes_sort,
bes_grp_key,
bes_modus,
bes_grp_sort
What does a person do with 30 years worth of photography from the sharkiest place on Earth? They put together a 340-page guidebook. That is just what Avi Klapfer has done with his spectacular photo archive from Cocos Island. 