- "select timestamp, imei, clntaddr, length, proto, payload from events"
-)
+c.execute("select tstamp, packet from events where proto in ({})"
+ .format(", ".join([str(n) for n in (WIFI_POSITIONING.PROTO, WIFI_OFFLINE_POSITIONING.PROTO, GPS_POSITIONING.PROTO, GPS_OFFLINE_POSITIONING.PROTO)])))