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.
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