Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-12 8:28:26' AND e.date<='2024-03-13 8:28:26' AND e.DeviceLoginName='2516' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-03-12 06:28:26' AND g.time<='2024-03-13 06:28:26' AND g.DeviceLoginName='2516' GROUP BY  g.time, g.Distance;
CountAzimuth:581
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-12 8:40:12' AND e.date<='2024-03-12 23:40:12' AND e.DeviceLoginName='2516' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-03-12 06:40:12' AND g.time<='2024-03-12 21:40:12' AND g.DeviceLoginName='2516' GROUP BY  g.time, g.Distance;
CountAzimuth:581
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-12 8:41:8' AND e.date<='2024-03-12 23:41:8' AND e.DeviceLoginName='352353083458635' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-03-12 06:41:08' AND g.time<='2024-03-12 21:41:08' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:735
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-13 5:42:46' AND e.date<='2024-03-13 8:42:46' AND e.DeviceLoginName='352353083458635' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-03-13 03:42:46' AND g.time<='2024-03-13 06:42:46' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:355
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude FROM  tms_gpsdata_fixed g WHERE g.time>='2024-03-12 22:00:00' AND g.time<='2024-03-13 07:56:55' AND g.DeviceLoginName='3212'
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-03-13 06:09:22' AND TIME<='2024-03-13 06:19:22' AND DeviceLoginName='3212' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-03-13 07:15:14' AND TIME<='2024-03-13 07:25:14' AND DeviceLoginName='3212' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-03-13 07:30:13' AND TIME<='2024-03-13 07:40:13' AND DeviceLoginName='3212' AND speed=0
Method:GetStops; Query:SELECT e.date,e.EventType FROM tms_events e WHERE e.DeviceLoginName='3212' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-03-12 22:00:00' AND e.date<='2024-03-13 07:56:55'
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-03-13 07:09:02' AND TIME<='2024-03-13 07:19:02' AND DeviceLoginName='3212' AND speed=0
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-13 0:1:38' AND e.date<='2024-03-13 10:1:38' AND e.DeviceLoginName='2473' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-03-12 22:01:38' AND g.time<='2024-03-13 08:01:38' AND g.DeviceLoginName='2473' GROUP BY  g.time, g.Distance;
CountAzimuth:317
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-12 10:2:5' AND e.date<='2024-03-12 23:2:5' AND e.DeviceLoginName='2473' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-03-12 08:02:05' AND g.time<='2024-03-12 21:02:05' AND g.DeviceLoginName='2473' GROUP BY  g.time, g.Distance;
CountAzimuth:1299
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-12 10:2:39' AND e.date<='2024-03-12 23:2:39' AND e.DeviceLoginName='356078111301566' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-03-12 08:02:39' AND g.time<='2024-03-12 21:02:39' AND g.DeviceLoginName='356078111301566' GROUP BY  g.time, g.Distance;
CountAzimuth:352
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-12 10:3:5' AND e.date<='2024-03-12 23:3:5' AND e.DeviceLoginName='352353083458635' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-03-12 08:03:05' AND g.time<='2024-03-12 21:03:05' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:735
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-12 10:3:25' AND e.date<='2024-03-12 23:3:25' AND e.DeviceLoginName='2556' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-03-12 08:03:25' AND g.time<='2024-03-12 21:03:25' AND g.DeviceLoginName='2556' GROUP BY  g.time, g.Distance;
CountAzimuth:355
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-12 10:4:0' AND e.date<='2024-03-12 23:4:0' AND e.DeviceLoginName='358021081803706' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-03-12 08:04:00' AND g.time<='2024-03-12 21:04:00' AND g.DeviceLoginName='358021081803706' GROUP BY  g.time, g.Distance;
CountAzimuth:307
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-12 10:4:20' AND e.date<='2024-03-12 23:4:20' AND e.DeviceLoginName='358021081803706' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-03-12 08:04:20' AND g.time<='2024-03-12 21:04:20' AND g.DeviceLoginName='358021081803706' GROUP BY  g.time, g.Distance;
CountAzimuth:307
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-02 10:29:5' AND e.date<='2024-03-03 10:29:5' AND e.DeviceLoginName='9378' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-03-02 08:29:05' AND g.time<='2024-03-03 08:29:05' AND g.DeviceLoginName='9378' GROUP BY  g.time, g.Distance;
CountAzimuth:789
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-02 0:29:5' AND e.date<='2024-03-03 23:29:5' AND e.DeviceLoginName='9378' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-03-01 22:29:05' AND g.time<='2024-03-03 21:29:05' AND g.DeviceLoginName='9378' GROUP BY  g.time, g.Distance;
CountAzimuth:1591
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-09 0:42:58' AND e.date<='2024-03-10 23:42:58' AND e.DeviceLoginName='9378' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-03-08 22:42:58' AND g.time<='2024-03-10 21:42:58' AND g.DeviceLoginName='9378' GROUP BY  g.time, g.Distance;
CountAzimuth:351
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-13 8:0:20' AND e.date<='2024-03-13 11:0:20' AND e.DeviceLoginName='3092' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-03-13 06:00:20' AND g.time<='2024-03-13 09:00:20' AND g.DeviceLoginName='3092' GROUP BY  g.time, g.Distance;
CountAzimuth:506
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-07 0:0:20' AND e.date<='2024-03-07 23:0:20' AND e.DeviceLoginName='9378' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-03-06 22:00:20' AND g.time<='2024-03-07 21:00:20' AND g.DeviceLoginName='9378' GROUP BY  g.time, g.Distance;
CountAzimuth:4904
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-11 0:0:20' AND e.date<='2024-03-11 23:0:20' AND e.DeviceLoginName='9378' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-03-10 22:00:20' AND g.time<='2024-03-11 21:00:20' AND g.DeviceLoginName='9378' GROUP BY  g.time, g.Distance;
CountAzimuth:2139
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-13 3:28:40' AND e.date<='2024-03-13 11:28:40' AND e.DeviceLoginName='352353083458635' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-03-13 01:28:40' AND g.time<='2024-03-13 09:28:40' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:407
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-13 0:0:20' AND e.date<='2024-03-13 23:0:20' AND e.DeviceLoginName='9378' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-03-12 22:00:20' AND g.time<='2024-03-13 21:00:20' AND g.DeviceLoginName='9378' GROUP BY  g.time, g.Distance;
CountAzimuth:1748
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-11 0:0:20' AND e.date<='2024-03-13 23:0:20' AND e.DeviceLoginName='9378' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-03-10 22:00:20' AND g.time<='2024-03-13 21:00:20' AND g.DeviceLoginName='9378' GROUP BY  g.time, g.Distance;
CountAzimuth:7664
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-13 2:47:9' AND e.date<='2024-03-13 11:47:9' AND e.DeviceLoginName='352353083458635' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-03-13 00:47:09' AND g.time<='2024-03-13 09:47:09' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:514
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-13 0:48:27' AND e.date<='2024-03-13 11:48:27' AND e.DeviceLoginName='862531041069957' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-03-12 22:48:27' AND g.time<='2024-03-13 09:48:27' AND g.DeviceLoginName='862531041069957' GROUP BY  g.time, g.Distance;
CountAzimuth:818
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-13 1:13:12' AND e.date<='2024-03-13 12:13:12' AND e.DeviceLoginName='2516' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-03-12 23:13:12' AND g.time<='2024-03-13 10:13:12' AND g.DeviceLoginName='2516' GROUP BY  g.time, g.Distance;
CountAzimuth:91
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-12 12:13:39' AND e.date<='2024-03-13 12:13:39' AND e.DeviceLoginName='2516' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-03-12 10:13:39' AND g.time<='2024-03-13 10:13:39' AND g.DeviceLoginName='2516' GROUP BY  g.time, g.Distance;
CountAzimuth:591
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-13 0:15:38' AND e.date<='2024-03-13 12:15:38' AND e.DeviceLoginName='2516' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-03-12 22:15:38' AND g.time<='2024-03-13 10:15:38' AND g.DeviceLoginName='2516' GROUP BY  g.time, g.Distance;
CountAzimuth:99
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-13 12:26:35' AND e.date<='2024-03-13 15:26:35' AND e.DeviceLoginName='2473' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-03-13 10:26:35' AND g.time<='2024-03-13 13:26:35' AND g.DeviceLoginName='2473' GROUP BY  g.time, g.Distance;
CountAzimuth:163