Current Activity

The table below shows the detailed information of all current flights.

Invalid query : SQLSTATE[HY000]: General error: 1021 Disk full (/var/lib/mysql/tmp/#sql_82a_8.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") Whole query: SELECT spotter_live.* FROM spotter_live INNER JOIN (SELECT l.flightaware_id, max(l.date) as maxdate FROM spotter_live l WHERE DATE_SUB(UTC_TIMESTAMP(),INTERVAL 1600 SECOND) <= l.date GROUP BY l.flightaware_id) s on spotter_live.flightaware_id = s.flightaware_id AND spotter_live.date = s.maxdate ORDER BY spotter_live.arrival_airport_city ASC LIMIT 25 OFFSET 0