#!/usr/bin/env -S rootifysql
SELECT
   Telescope,
   NIGHT,
   RUNID,
   (TSTARTI+TSTARTF) AS ObsStart,
   RUNTYPE,
   Imed,
   Patch,
   Amplitude,
   Baseline
FROM
   `Callisto` Callisto
LEFT JOIN
   RawData USING(Telescope, NIGHT, RUNID)
LEFT JOIN
   AuxData USING(Telescope, NIGHT, RUNID)
ORDER BY
   Telesscope, NIGHT, RUNID