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
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='X'
ORDER BY
ter_von DESC,
ter_bis DESC,
ter_schiff,
tri_key,
bes_sort,
bes_grp_key,
bes_modus,
bes_grp_sort
#DiveSafe, Dive Cocos | Safety COVID-19 Protocols 
"This was my 21st trip to Cocos & my first time with 7 orcas who swam 8 feet below me on our safety stop near dos amigos! Thank you Juan Manuel and the great crew of sea hunter. Excellent crew.”
