Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-07 8:36:21' AND e.date<='2024-06-07 8:36:21' AND e.DeviceLoginName='2718' 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-06-07 05:36:21' AND g.time<='2024-06-07 05:36:21' AND g.DeviceLoginName='2718' GROUP BY  g.time, g.Distance;
CountAzimuth:0
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-06 0:36:21' AND e.date<='2024-06-07 23:36:21' AND e.DeviceLoginName='2718' 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-06-05 21:36:21' AND g.time<='2024-06-07 20:36:21' AND g.DeviceLoginName='2718' GROUP BY  g.time, g.Distance;
CountAzimuth:4340
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-07 0:36:21' AND e.date<='2024-06-07 23:36:21' AND e.DeviceLoginName='2718' 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-06-06 21:36:21' AND g.time<='2024-06-07 20:36:21' AND g.DeviceLoginName='2718' GROUP BY  g.time, g.Distance;
CountAzimuth:2288
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-07 0:36:21' AND e.date<='2024-06-07 23:36:21' AND e.DeviceLoginName='2908' 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-06-06 21:36:21' AND g.time<='2024-06-07 20:36:21' AND g.DeviceLoginName='2908' GROUP BY  g.time, g.Distance;
CountAzimuth:5316
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-07 0:36:21' AND e.date<='2024-06-07 23:36:21' AND e.DeviceLoginName='356078116281466' 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-06-06 21:36:21' AND g.time<='2024-06-07 20:36:21' AND g.DeviceLoginName='356078116281466' GROUP BY  g.time, g.Distance;
CountAzimuth:2892
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-07 0:36:21' AND e.date<='2024-06-07 23:36:21' AND e.DeviceLoginName='3184' 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-06-06 21:36:21' AND g.time<='2024-06-07 20:36:21' AND g.DeviceLoginName='3184' GROUP BY  g.time, g.Distance;
CountAzimuth:1976
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-06 0:36:21' AND e.date<='2024-06-06 23:36:21' AND e.DeviceLoginName='3184' 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-06-05 21:36:21' AND g.time<='2024-06-06 20:36:21' AND g.DeviceLoginName='3184' GROUP BY  g.time, g.Distance;
CountAzimuth:5562
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-06 0:0:4' AND e.date<='2024-06-06 23:0:4' AND e.DeviceLoginName='356078116281466' 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-06-05 21:00:04' AND g.time<='2024-06-06 20:00:04' AND g.DeviceLoginName='356078116281466' GROUP BY  g.time, g.Distance;
CountAzimuth:5017
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-10 2:31:44' AND e.date<='2024-06-10 12:31:44' 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-06-09 23:31:44' AND g.time<='2024-06-10 09:31:44' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:422
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-07 23:0:0' AND e.date<='2024-06-08 5:0:0' AND e.DeviceLoginName='4849' 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-06-07 20:00:00' AND g.time<='2024-06-08 02:00:00' AND g.DeviceLoginName='4849' GROUP BY  g.time, g.Distance;
CountAzimuth:302
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-07 23:0:0' AND e.date<='2024-06-08 5:0:0' AND e.DeviceLoginName='3157' 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-06-07 20:00:00' AND g.time<='2024-06-08 02:00:00' AND g.DeviceLoginName='3157' GROUP BY  g.time, g.Distance;
CountAzimuth:13
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-07 23:0:0' AND e.date<='2024-06-08 5:0:0' AND e.DeviceLoginName='3209' 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-06-07 20:00:00' AND g.time<='2024-06-08 02:00:00' AND g.DeviceLoginName='3209' GROUP BY  g.time, g.Distance;
CountAzimuth:158
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-07 23:0:0' AND e.date<='2024-06-08 5:0:0' AND e.DeviceLoginName='356078111279820' 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-06-07 20:00:00' AND g.time<='2024-06-08 02:00:00' AND g.DeviceLoginName='356078111279820' GROUP BY  g.time, g.Distance;
CountAzimuth:162
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-07 23:0:0' AND e.date<='2024-06-08 5:0:0' AND e.DeviceLoginName='352353084344826' 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-06-07 20:00:00' AND g.time<='2024-06-08 02:00:00' AND g.DeviceLoginName='352353084344826' GROUP BY  g.time, g.Distance;
CountAzimuth:25
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-07 23:0:0' AND e.date<='2024-06-08 5:0:0' AND e.DeviceLoginName='3032' 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-06-07 20:00:00' AND g.time<='2024-06-08 02:00:00' AND g.DeviceLoginName='3032' GROUP BY  g.time, g.Distance;
CountAzimuth:7
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-07 23:0:0' AND e.date<='2024-06-08 5:0:0' AND e.DeviceLoginName='356078118085311' 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-06-07 20:00:00' AND g.time<='2024-06-08 02:00:00' AND g.DeviceLoginName='356078118085311' GROUP BY  g.time, g.Distance;
CountAzimuth:31
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-08 23:0:0' AND e.date<='2024-06-09 5:0:0' AND e.DeviceLoginName='2652' 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-06-08 20:00:00' AND g.time<='2024-06-09 02:00:00' AND g.DeviceLoginName='2652' GROUP BY  g.time, g.Distance;
CountAzimuth:798
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-08 23:0:0' AND e.date<='2024-06-09 5:0:0' AND e.DeviceLoginName='3123' 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-06-08 20:00:00' AND g.time<='2024-06-09 02:00:00' AND g.DeviceLoginName='3123' GROUP BY  g.time, g.Distance;
CountAzimuth:122
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-08 23:0:0' AND e.date<='2024-06-09 5:0:0' AND e.DeviceLoginName='4849' 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-06-08 20:00:00' AND g.time<='2024-06-09 02:00:00' AND g.DeviceLoginName='4849' GROUP BY  g.time, g.Distance;
CountAzimuth:208
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-08 23:0:0' AND e.date<='2024-06-09 5:0:0' AND e.DeviceLoginName='2657' 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-06-08 20:00:00' AND g.time<='2024-06-09 02:00:00' AND g.DeviceLoginName='2657' GROUP BY  g.time, g.Distance;
CountAzimuth:82
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-08 5:0:0' AND e.date<='2024-06-08 23:0:0' AND e.DeviceLoginName='2657' 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-06-08 02:00:00' AND g.time<='2024-06-08 20:00:00' AND g.DeviceLoginName='2657' GROUP BY  g.time, g.Distance;
CountAzimuth:413
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-09 5:0:0' AND e.date<='2024-06-09 23:0:0' AND e.DeviceLoginName='2657' 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-06-09 02:00:00' AND g.time<='2024-06-09 20:00:00' AND g.DeviceLoginName='2657' GROUP BY  g.time, g.Distance;
CountAzimuth:222
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-08 22:0:0' AND e.date<='2024-06-08 23:0:0' AND e.DeviceLoginName='2657' 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-06-08 19:00:00' AND g.time<='2024-06-08 20:00:00' AND g.DeviceLoginName='2657' GROUP BY  g.time, g.Distance;
CountAzimuth:65
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-08 22:0:0' AND e.date<='2024-06-09 23:0:0' AND e.DeviceLoginName='2657' 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-06-08 19:00:00' AND g.time<='2024-06-09 20:00:00' AND g.DeviceLoginName='2657' GROUP BY  g.time, g.Distance;
CountAzimuth:369
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-08 23:0:0' AND e.date<='2024-06-09 5:0:0' AND e.DeviceLoginName='2506' 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-06-08 20:00:00' AND g.time<='2024-06-09 02:00:00' AND g.DeviceLoginName='2506' GROUP BY  g.time, g.Distance;
CountAzimuth:75
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-08 23:0:0' AND e.date<='2024-06-09 5:0:0' AND e.DeviceLoginName='2676' 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-06-08 20:00:00' AND g.time<='2024-06-09 02:00:00' AND g.DeviceLoginName='2676' GROUP BY  g.time, g.Distance;
CountAzimuth:311
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-09 23:0:0' AND e.date<='2024-06-10 5:0:0' AND e.DeviceLoginName='4849' 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-06-09 20:00:00' AND g.time<='2024-06-10 02:00:00' AND g.DeviceLoginName='4849' GROUP BY  g.time, g.Distance;
CountAzimuth:348
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-09 23:0:0' AND e.date<='2024-06-10 5:0:0' AND e.DeviceLoginName='356078111320111' 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-06-09 20:00:00' AND g.time<='2024-06-10 02:00:00' AND g.DeviceLoginName='356078111320111' GROUP BY  g.time, g.Distance;
CountAzimuth:52
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-09 23:0:0' AND e.date<='2024-06-10 5:0:0' AND e.DeviceLoginName='3081' 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-06-09 20:00:00' AND g.time<='2024-06-10 02:00:00' AND g.DeviceLoginName='3081' GROUP BY  g.time, g.Distance;
CountAzimuth:15
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-09 23:0:0' AND e.date<='2024-06-10 5:0:0' AND e.DeviceLoginName='353173060487970' 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-06-09 20:00:00' AND g.time<='2024-06-10 02:00:00' AND g.DeviceLoginName='353173060487970' GROUP BY  g.time, g.Distance;
CountAzimuth:82
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-09 23:0:0' AND e.date<='2024-06-10 5:0:0' AND e.DeviceLoginName='352353083473741' 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-06-09 20:00:00' AND g.time<='2024-06-10 02:00:00' AND g.DeviceLoginName='352353083473741' GROUP BY  g.time, g.Distance;
CountAzimuth:236
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-09 23:0:0' AND e.date<='2024-06-10 5:0:0' AND e.DeviceLoginName='2506' 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-06-09 20:00:00' AND g.time<='2024-06-10 02:00:00' AND g.DeviceLoginName='2506' GROUP BY  g.time, g.Distance;
CountAzimuth:36
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-09 23:0:0' AND e.date<='2024-06-10 5:0:0' AND e.DeviceLoginName='352353084101820' 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-06-09 20:00:00' AND g.time<='2024-06-10 02:00:00' AND g.DeviceLoginName='352353084101820' GROUP BY  g.time, g.Distance;
CountAzimuth:131
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-07 0:33:16' AND e.date<='2024-06-07 23:33:16' AND e.DeviceLoginName='5078' 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-06-06 21:33:16' AND g.time<='2024-06-07 20:33:16' AND g.DeviceLoginName='5078' GROUP BY  g.time, g.Distance;
CountAzimuth:2888
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-10 0:52:21' AND e.date<='2024-06-10 13:52:21' AND e.DeviceLoginName='356078116278207' 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-06-09 21:52:21' AND g.time<='2024-06-10 10:52:21' AND g.DeviceLoginName='356078116278207' GROUP BY  g.time, g.Distance;
CountAzimuth:470
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-03 0:28:18' AND e.date<='2024-06-07 23:28:18' AND e.DeviceLoginName='2506' 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-06-02 21:28:18' AND g.time<='2024-06-07 20:28:18' AND g.DeviceLoginName='2506' GROUP BY  g.time, g.Distance;
CountAzimuth:5175
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-10 4:54:43' AND e.date<='2024-06-10 14:54:43' 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-06-10 01:54:43' AND g.time<='2024-06-10 11:54:43' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:426
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-10 5:33:44' AND e.date<='2024-06-10 15:33:44' AND e.DeviceLoginName='356078116278207' 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-06-10 02:33:44' AND g.time<='2024-06-10 12:33:44' AND g.DeviceLoginName='356078116278207' GROUP BY  g.time, g.Distance;
CountAzimuth:581
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-10 10:34:56' AND e.date<='2024-06-10 15:34:56' AND e.DeviceLoginName='3056' 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-06-10 07:34:56' AND g.time<='2024-06-10 12:34:56' AND g.DeviceLoginName='3056' GROUP BY  g.time, g.Distance;
CountAzimuth:416
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-10 4:38:54' AND e.date<='2024-06-10 15:38:54' AND e.DeviceLoginName='356078116278207' 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-06-10 01:38:54' AND g.time<='2024-06-10 12:38:54' AND g.DeviceLoginName='356078116278207' GROUP BY  g.time, g.Distance;
CountAzimuth:581