The script below - will list todays flights by height - run in a similar to Tarbats daily log report.
.output ht-report.htm
.mode list
.header OFF
SELECT DISTINCT "<html><head><title>Radarbox Height Report for Today</title><body><table>" AS FIELD_1 FROM Aircraft;
.mode html
.header ON
SELECT DISTINCT Aircraft.Registration AS "Reg",
Flights.Callsign AS "Flight ID",
MAX(Flights.StartAltitude, Flights.EndAltitude) AS "MHeight" ,
Flights.Route AS "Route",
Aircraft.Airline AS "Airline",
Aircraft.AircraftTypeLong AS "Aircraft",
substr(Flights.EndTime,1,16) AS "Flight Ended",
Aircraft.ModeS AS "Mode S" FROM Aircraft
LEFT OUTER JOIN Flights ON (Aircraft.ModeS=Flights.ModeS)
WHERE ((date('now') = substr(Aircraft.LastTime,1,4)||"-"||substr(Aircraft.LastTime,6,2)||"-"||substr(Aircraft.LastTime,9,2))
AND (Flights.StartTime IS NULL))
OR ((date('now') = substr(Flights.EndTime,1,4)||"-"||substr(Flights.EndTime,6,2)||"-"||substr(Flights.EndTime,9,2)))
ORDER BY Cast(MAX(Flights.StartAltitude, Flights.EndAltitude) as INTEGER),Flights.EndTime,Aircraft.ModeS;
.mode list
.header OFF
SELECT DISTINCT "</table></body></html>" AS FIELD_1 FROM Aircraft;
.exit
