Welcome to
the Undersea Hunter Group

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