Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-14 0:28:32' AND e.date<='2024-10-14 23:28:32' AND e.DeviceLoginName='352353083473493' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-10-13 21:28:32' AND g.time<='2024-10-14 20:28:32' AND g.DeviceLoginName='352353083473493' GROUP BY  g.time, g.Distance;
CountAzimuth:1321
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-15 0:28:32' AND e.date<='2024-10-15 23:28:32' AND e.DeviceLoginName='352353083473493' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-10-14 21:28:32' AND g.time<='2024-10-15 20:28:32' AND g.DeviceLoginName='352353083473493' GROUP BY  g.time, g.Distance;
CountAzimuth:2048
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-16 0:28:32' AND e.date<='2024-10-16 23:28:32' AND e.DeviceLoginName='352353083473493' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-10-15 21:28:32' AND g.time<='2024-10-16 20:28:32' AND g.DeviceLoginName='352353083473493' GROUP BY  g.time, g.Distance;
CountAzimuth:1551
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-17 2:14:7' AND e.date<='2024-10-17 12:14:7' AND e.DeviceLoginName='352353083458635' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-10-16 23:14:07' AND g.time<='2024-10-17 09:14:07' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:318
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-17 4:14:54' AND e.date<='2024-10-17 12:14:54' AND e.DeviceLoginName='2556' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-10-17 01:14:54' AND g.time<='2024-10-17 09:14:54' AND g.DeviceLoginName='2556' GROUP BY  g.time, g.Distance;
CountAzimuth:172
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-17 4:15:40' AND e.date<='2024-10-17 12:15:40' AND e.DeviceLoginName='358021081803706' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-10-17 01:15:40' AND g.time<='2024-10-17 09:15:40' AND g.DeviceLoginName='358021081803706' GROUP BY  g.time, g.Distance;
CountAzimuth:615
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-17 6:16:11' AND e.date<='2024-10-17 12:16:11' AND e.DeviceLoginName='352353083458635' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-10-17 03:16:11' AND g.time<='2024-10-17 09:16:11' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:318
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-17 10:13:0' AND e.date<='2024-10-17 13:13:0' AND e.DeviceLoginName='352353083458635' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-10-17 07:13:00' AND g.time<='2024-10-17 10:13:00' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:82
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-18 8:46:18' AND e.date<='2024-10-17 13:46:18' AND e.DeviceLoginName='354836080167561' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-10-18 05:46:18' AND g.time<='2024-10-17 10:46:18' AND g.DeviceLoginName='354836080167561' GROUP BY  g.time, g.Distance;
CountAzimuth:0
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-17 1:46:35' AND e.date<='2024-10-17 13:46:35' AND e.DeviceLoginName='354836080167561' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-10-16 22:46:35' AND g.time<='2024-10-17 10:46:35' AND g.DeviceLoginName='354836080167561' GROUP BY  g.time, g.Distance;
CountAzimuth:857
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-23 15:57:22' AND e.date<='2024-10-17 15:57:22' AND e.DeviceLoginName='4884' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-09-23 12:57:22' AND g.time<='2024-10-17 12:57:22' AND g.DeviceLoginName='4884' GROUP BY  g.time, g.Distance;
CountAzimuth:12414
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude FROM  tms_gpsdata_fixed g WHERE g.time>='2024-10-16 21:00:00' AND g.time<='2024-10-17 14:32:35' AND g.DeviceLoginName='355234055234161'
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-10-17 05:23:13' AND TIME<='2024-10-17 05:33:13' AND DeviceLoginName='355234055234161' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-10-17 08:36:51' AND TIME<='2024-10-17 08:46:51' AND DeviceLoginName='355234055234161' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-10-17 09:20:09' AND TIME<='2024-10-17 09:30:09' AND DeviceLoginName='355234055234161' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-10-17 11:02:48' AND TIME<='2024-10-17 11:12:48' AND DeviceLoginName='355234055234161' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-10-17 12:30:01' AND TIME<='2024-10-17 12:40:01' AND DeviceLoginName='355234055234161' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-10-17 12:41:36' AND TIME<='2024-10-17 12:51:36' AND DeviceLoginName='355234055234161' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-10-17 13:08:16' AND TIME<='2024-10-17 13:18:16' AND DeviceLoginName='355234055234161' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-10-17 13:18:32' AND TIME<='2024-10-17 13:28:32' AND DeviceLoginName='355234055234161' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-10-17 13:31:58' AND TIME<='2024-10-17 13:41:58' AND DeviceLoginName='355234055234161' AND speed=0
Method:GetStops; Query:SELECT e.date,e.EventType FROM tms_events e WHERE e.DeviceLoginName='355234055234161' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-16 21:00:00' AND e.date<='2024-10-17 14:32:35'
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-10-17 05:23:13' AND TIME<='2024-10-17 05:33:13' AND DeviceLoginName='355234055234161' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-10-17 08:36:51' AND TIME<='2024-10-17 08:46:51' AND DeviceLoginName='355234055234161' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-10-17 09:20:09' AND TIME<='2024-10-17 09:30:09' AND DeviceLoginName='355234055234161' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-10-17 11:02:48' AND TIME<='2024-10-17 11:12:48' AND DeviceLoginName='355234055234161' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-10-17 12:30:01' AND TIME<='2024-10-17 12:40:01' AND DeviceLoginName='355234055234161' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-10-17 12:41:36' AND TIME<='2024-10-17 12:51:36' AND DeviceLoginName='355234055234161' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-10-17 13:08:16' AND TIME<='2024-10-17 13:18:16' AND DeviceLoginName='355234055234161' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-10-17 13:18:32' AND TIME<='2024-10-17 13:28:32' AND DeviceLoginName='355234055234161' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-10-17 13:31:58' AND TIME<='2024-10-17 13:41:58' AND DeviceLoginName='355234055234161' AND speed=0