tmohrbach

SELECT
    datetime(locations.timestamp, 'unixepoch', 'localtime') AS 'Timestamp', 
    devices.service_data AS 'R. Prox. Identifier',
    locations.rssi AS 'RSSI',
    locations.latitude AS 'Latitude',
    locations.longitude AS 'Longitude'
FROM
    devices
INNER JOIN locations ON devices.id = locations.device_id
WHERE

tmohrbach

package openknowledge.de