Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-07 0:41:7' AND e.date<='2024-10-07 23:41:7' AND e.DeviceLoginName='356078118074109' 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-06 21:41:07' AND g.time<='2024-10-07 20:41:07' AND g.DeviceLoginName='356078118074109' GROUP BY  g.time, g.Distance;
CountAzimuth:1463
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-11 0:41:7' AND e.date<='2024-10-11 23:41:7' AND e.DeviceLoginName='862531041050148' 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-10 21:41:07' AND g.time<='2024-10-11 20:41:07' AND g.DeviceLoginName='862531041050148' GROUP BY  g.time, g.Distance;
CountAzimuth:1070
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-08 0:41:7' AND e.date<='2024-10-08 23:41:7' AND e.DeviceLoginName='5117' 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-07 21:41:07' AND g.time<='2024-10-08 20:41:07' AND g.DeviceLoginName='5117' GROUP BY  g.time, g.Distance;
CountAzimuth:2361
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-07 0:41:7' AND e.date<='2024-10-07 23:41:7' AND e.DeviceLoginName='3092' 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-06 21:41:07' AND g.time<='2024-10-07 20:41:07' AND g.DeviceLoginName='3092' GROUP BY  g.time, g.Distance;
CountAzimuth:2733
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-10 0:41:7' AND e.date<='2024-10-10 23:41:7' AND e.DeviceLoginName='2559' 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-09 21:41:07' AND g.time<='2024-10-10 20:41:07' AND g.DeviceLoginName='2559' GROUP BY  g.time, g.Distance;
CountAzimuth:1724
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-11 0:41:7' AND e.date<='2024-10-11 23:41:7' AND e.DeviceLoginName='2948' 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-10 21:41:07' AND g.time<='2024-10-11 20:41:07' AND g.DeviceLoginName='2948' GROUP BY  g.time, g.Distance;
CountAzimuth:4608
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-12 1:56:38' AND e.date<='2024-10-12 23:56:38' AND e.DeviceLoginName='3090' 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-11 22:56:38' AND g.time<='2024-10-12 20:56:38' AND g.DeviceLoginName='3090' GROUP BY  g.time, g.Distance;
CountAzimuth:1107
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-14 5:57:39' AND e.date<='2024-10-14 8:57:39' AND e.DeviceLoginName='3090' 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 02:57:39' AND g.time<='2024-10-14 05:57:39' AND g.DeviceLoginName='3090' GROUP BY  g.time, g.Distance;
CountAzimuth:1055
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-14 6:11:18' AND e.date<='2024-10-14 9:11:18' 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-14 03:11:18' AND g.time<='2024-10-14 06:11:18' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:286
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-10 4:12:46' AND e.date<='2024-10-10 23:12:46' 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-10 01:12:46' AND g.time<='2024-10-10 20:12:46' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:981
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-11 6:14:2' AND e.date<='2024-10-11 23:14:2' 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-11 03:14:02' AND g.time<='2024-10-11 20:14:02' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:988
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-11 0:41:7' AND e.date<='2024-10-11 23:41:7' AND e.DeviceLoginName='356078111430837' 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-10 21:41:07' AND g.time<='2024-10-11 20:41:07' AND g.DeviceLoginName='356078111430837' GROUP BY  g.time, g.Distance;
CountAzimuth:1
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-12 0:41:7' AND e.date<='2024-10-13 23:41:7' AND e.DeviceLoginName='356078111430837' 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-11 21:41:07' AND g.time<='2024-10-13 20:41:07' AND g.DeviceLoginName='356078111430837' GROUP BY  g.time, g.Distance;
CountAzimuth:0
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-14 0:41:7' AND e.date<='2024-10-14 23:41:7' AND e.DeviceLoginName='356078111430837' 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:41:07' AND g.time<='2024-10-14 20:41:07' AND g.DeviceLoginName='356078111430837' GROUP BY  g.time, g.Distance;
CountAzimuth:0
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-14 0:41:7' AND e.date<='2024-10-14 23:41:7' AND e.DeviceLoginName='3090' 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:41:07' AND g.time<='2024-10-14 20:41:07' AND g.DeviceLoginName='3090' GROUP BY  g.time, g.Distance;
CountAzimuth:1570
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-12 0:41:7' AND e.date<='2024-10-13 23:41:7' AND e.DeviceLoginName='3090' 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-11 21:41:07' AND g.time<='2024-10-13 20:41:07' AND g.DeviceLoginName='3090' GROUP BY  g.time, g.Distance;
CountAzimuth:1115
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-07 0:20:44' AND e.date<='2024-10-07 23:20:44' AND e.DeviceLoginName='352353083507225' 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-06 21:20:44' AND g.time<='2024-10-07 20:20:44' AND g.DeviceLoginName='352353083507225' GROUP BY  g.time, g.Distance;
CountAzimuth:549
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-08 0:20:44' AND e.date<='2024-10-08 23:20:44' AND e.DeviceLoginName='352353083507225' 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-07 21:20:44' AND g.time<='2024-10-08 20:20:44' AND g.DeviceLoginName='352353083507225' GROUP BY  g.time, g.Distance;
CountAzimuth:308
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-09 0:20:44' AND e.date<='2024-10-09 23:20:44' AND e.DeviceLoginName='352353083507225' 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-08 21:20:44' AND g.time<='2024-10-09 20:20:44' AND g.DeviceLoginName='352353083507225' GROUP BY  g.time, g.Distance;
CountAzimuth:284
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-13 6:21:14' AND e.date<='2024-10-13 23:21:14' 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-13 03:21:14' AND g.time<='2024-10-13 20:21:14' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:746
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-14 1:22:3' AND e.date<='2024-10-14 11:22:3' 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-13 22:22:03' AND g.time<='2024-10-14 08:22:03' AND g.DeviceLoginName='354836080167561' GROUP BY  g.time, g.Distance;
CountAzimuth:646
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-14 4:33:31' AND e.date<='2024-10-14 11:33:31' 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-14 01:33:31' AND g.time<='2024-10-14 08:33:31' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:286
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-11 23:0:0' AND e.date<='2024-10-12 5:0:0' AND e.DeviceLoginName='9376' 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-11 20:00:00' AND g.time<='2024-10-12 02:00:00' AND g.DeviceLoginName='9376' GROUP BY  g.time, g.Distance;
CountAzimuth:161
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-11 23:0:0' AND e.date<='2024-10-12 5:0:0' AND e.DeviceLoginName='353173060485131' 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-11 20:00:00' AND g.time<='2024-10-12 02:00:00' AND g.DeviceLoginName='353173060485131' GROUP BY  g.time, g.Distance;
CountAzimuth:31
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-11 23:0:0' AND e.date<='2024-10-12 5:0:0' AND e.DeviceLoginName='356078111301566' 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-11 20:00:00' AND g.time<='2024-10-12 02:00:00' AND g.DeviceLoginName='356078111301566' GROUP BY  g.time, g.Distance;
CountAzimuth:198
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-11 23:0:0' AND e.date<='2024-10-12 5:0:0' AND e.DeviceLoginName='862531041050148' 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-11 20:00:00' AND g.time<='2024-10-12 02:00:00' AND g.DeviceLoginName='862531041050148' GROUP BY  g.time, g.Distance;
CountAzimuth:13
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-11 23:0:0' AND e.date<='2024-10-12 5:0:0' AND e.DeviceLoginName='5117' 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-11 20:00:00' AND g.time<='2024-10-12 02:00:00' AND g.DeviceLoginName='5117' GROUP BY  g.time, g.Distance;
CountAzimuth:296
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-11 23:0:0' AND e.date<='2024-10-12 5:0:0' AND e.DeviceLoginName='862531041041535' 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-11 20:00:00' AND g.time<='2024-10-12 02:00:00' AND g.DeviceLoginName='862531041041535' GROUP BY  g.time, g.Distance;
CountAzimuth:35
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-11 23:0:0' AND e.date<='2024-10-12 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-10-11 20:00:00' AND g.time<='2024-10-12 02:00:00' AND g.DeviceLoginName='2506' GROUP BY  g.time, g.Distance;
CountAzimuth:42
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-11 23:0:0' AND e.date<='2024-10-12 5:0:0' AND e.DeviceLoginName='4862' 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-11 20:00:00' AND g.time<='2024-10-12 02:00:00' AND g.DeviceLoginName='4862' GROUP BY  g.time, g.Distance;
CountAzimuth:135
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-11 23:0:0' AND e.date<='2024-10-12 5:0:0' AND e.DeviceLoginName='2713' 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-11 20:00:00' AND g.time<='2024-10-12 02:00:00' AND g.DeviceLoginName='2713' GROUP BY  g.time, g.Distance;
CountAzimuth:96
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-12 23:0:0' AND e.date<='2024-10-13 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-10-12 20:00:00' AND g.time<='2024-10-13 02:00:00' AND g.DeviceLoginName='4849' GROUP BY  g.time, g.Distance;
CountAzimuth:250
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-12 23:0:0' AND e.date<='2024-10-13 5:0:0' AND e.DeviceLoginName='4966' 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-12 20:00:00' AND g.time<='2024-10-13 02:00:00' AND g.DeviceLoginName='4966' GROUP BY  g.time, g.Distance;
CountAzimuth:22
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-12 23:0:0' AND e.date<='2024-10-13 5:0:0' AND e.DeviceLoginName='5117' 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-12 20:00:00' AND g.time<='2024-10-13 02:00:00' AND g.DeviceLoginName='5117' GROUP BY  g.time, g.Distance;
CountAzimuth:155
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-12 23:0:0' AND e.date<='2024-10-13 5:0:0' AND e.DeviceLoginName='3013' 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-12 20:00:00' AND g.time<='2024-10-13 02:00:00' AND g.DeviceLoginName='3013' GROUP BY  g.time, g.Distance;
CountAzimuth:55
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-12 23:0:0' AND e.date<='2024-10-13 5:0:0' AND e.DeviceLoginName='4868' 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-12 20:00:00' AND g.time<='2024-10-13 02:00:00' AND g.DeviceLoginName='4868' GROUP BY  g.time, g.Distance;
CountAzimuth:12
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-13 23:0:0' AND e.date<='2024-10-14 5:0:0' AND e.DeviceLoginName='862531041050148' 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 20:00:00' AND g.time<='2024-10-14 02:00:00' AND g.DeviceLoginName='862531041050148' GROUP BY  g.time, g.Distance;
CountAzimuth:112
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-13 23:0:0' AND e.date<='2024-10-14 5:0:0' AND e.DeviceLoginName='5117' 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 20:00:00' AND g.time<='2024-10-14 02:00:00' AND g.DeviceLoginName='5117' GROUP BY  g.time, g.Distance;
CountAzimuth:161
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-13 23:0:0' AND e.date<='2024-10-14 5:0:0' AND e.DeviceLoginName='862531041041535' 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 20:00:00' AND g.time<='2024-10-14 02:00:00' AND g.DeviceLoginName='862531041041535' GROUP BY  g.time, g.Distance;
CountAzimuth:12
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-13 23:0:0' AND e.date<='2024-10-14 5:0:0' AND e.DeviceLoginName='2667' 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 20:00:00' AND g.time<='2024-10-14 02:00:00' AND g.DeviceLoginName='2667' GROUP BY  g.time, g.Distance;
CountAzimuth:143
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-14 14:19:49' AND e.date<='2024-10-14 19:19:49' 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-14 11:19:49' AND g.time<='2024-10-14 16:19:49' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:552