#!/usr/bin/env -S rootifysql
SELECT
   (TSTARTI+TSTARTF) AS ObsStart,
   Star.*,
   log10(Size) AS lgSize,
   log10(Width*Length*PI()) AS lgArea
FROM
   `Star` Star
LEFT JOIN
   RawData USING(Telescope, NIGHT, RUNID)
ORDER BY
   Telescope,
   NIGHT,
   RUNID