Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-01 3:49:1' AND e.date<='2024-10-01 7:49:1' 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-01 00:49:01' AND g.time<='2024-10-01 04:49:01' AND g.DeviceLoginName='354836080167561' GROUP BY  g.time, g.Distance;
CountAzimuth:1
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-01 6:1:28' AND e.date<='2024-10-01 8:1:28' 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-01 03:01:28' AND g.time<='2024-10-01 05:01:28' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:298
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-01 6:4:48' AND e.date<='2024-10-01 8:4:48' 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-01 03:04:48' AND g.time<='2024-10-01 05:04:48' AND g.DeviceLoginName='354836080167561' GROUP BY  g.time, g.Distance;
CountAzimuth:1
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-01 6:5:1' AND e.date<='2024-10-01 8:5:1' 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-01 03:05:01' AND g.time<='2024-10-01 05:05:01' AND g.DeviceLoginName='358021081803706' GROUP BY  g.time, g.Distance;
CountAzimuth:230
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-30 8:5:22' AND e.date<='2024-09-30 23:5:22' 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-09-30 05:05:22' AND g.time<='2024-09-30 20:05:22' AND g.DeviceLoginName='358021081803706' GROUP BY  g.time, g.Distance;
CountAzimuth:665
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-30 7:16:6' AND e.date<='2024-10-01 11:16:6' 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-09-30 04:16:06' AND g.time<='2024-10-01 08:16:06' AND g.DeviceLoginName='3090' GROUP BY  g.time, g.Distance;
CountAzimuth:0
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-30 11:16:34' AND e.date<='2024-10-01 11:16:34' 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-09-30 08:16:34' AND g.time<='2024-10-01 08:16:34' AND g.DeviceLoginName='3090' GROUP BY  g.time, g.Distance;
CountAzimuth:0
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-01 0:38:57' AND e.date<='2024-10-01 11:38:57' 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-09-30 21:38:57' AND g.time<='2024-10-01 08:38:57' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:383
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-01 4:39:18' AND e.date<='2024-10-01 11:39:18' 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-01 01:39:18' AND g.time<='2024-10-01 08:39:18' AND g.DeviceLoginName='2556' GROUP BY  g.time, g.Distance;
CountAzimuth:6
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-01 1:52:16' AND e.date<='2024-10-01 11:52:16' 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-09-30 22:52:16' AND g.time<='2024-10-01 08:52:16' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:397
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-27 23:0:0' AND e.date<='2024-09-28 5:0:0' AND e.DeviceLoginName='2756' 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-27 20:00:00' AND g.time<='2024-09-28 02:00:00' AND g.DeviceLoginName='2756' GROUP BY  g.time, g.Distance;
CountAzimuth:38
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-27 23:0:0' AND e.date<='2024-09-28 5:0:0' AND e.DeviceLoginName='3176' 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-27 20:00:00' AND g.time<='2024-09-28 02:00:00' AND g.DeviceLoginName='3176' GROUP BY  g.time, g.Distance;
CountAzimuth:172
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-27 23:0:0' AND e.date<='2024-09-28 5:0:0' AND e.DeviceLoginName='3057' 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-27 20:00:00' AND g.time<='2024-09-28 02:00:00' AND g.DeviceLoginName='3057' GROUP BY  g.time, g.Distance;
CountAzimuth:12
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-27 23:0:0' AND e.date<='2024-09-28 5:0:0' AND e.DeviceLoginName='864866053466610' 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-27 20:00:00' AND g.time<='2024-09-28 02:00:00' AND g.DeviceLoginName='864866053466610' GROUP BY  g.time, g.Distance;
CountAzimuth:74
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-27 23:0:0' AND e.date<='2024-09-28 5:0:0' AND e.DeviceLoginName='2966' 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-27 20:00:00' AND g.time<='2024-09-28 02:00:00' AND g.DeviceLoginName='2966' GROUP BY  g.time, g.Distance;
CountAzimuth:162
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-27 23:0:0' AND e.date<='2024-09-28 5:0:0' AND e.DeviceLoginName='353173060537865' 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-27 20:00:00' AND g.time<='2024-09-28 02:00:00' AND g.DeviceLoginName='353173060537865' GROUP BY  g.time, g.Distance;
CountAzimuth:199
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-27 23:0:0' AND e.date<='2024-09-28 5:0:0' AND e.DeviceLoginName='2729' 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-27 20:00:00' AND g.time<='2024-09-28 02:00:00' AND g.DeviceLoginName='2729' GROUP BY  g.time, g.Distance;
CountAzimuth:36
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-27 23:0:0' AND e.date<='2024-09-28 5:0:0' AND e.DeviceLoginName='2725' 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-27 20:00:00' AND g.time<='2024-09-28 02:00:00' AND g.DeviceLoginName='2725' GROUP BY  g.time, g.Distance;
CountAzimuth:74
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-27 23:0:0' AND e.date<='2024-09-28 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-09-27 20:00:00' AND g.time<='2024-09-28 02:00:00' AND g.DeviceLoginName='862531041050148' GROUP BY  g.time, g.Distance;
CountAzimuth:22
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-27 23:0:0' AND e.date<='2024-09-28 5:0:0' AND e.DeviceLoginName='2783' 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-27 20:00:00' AND g.time<='2024-09-28 02:00:00' AND g.DeviceLoginName='2783' GROUP BY  g.time, g.Distance;
CountAzimuth:12
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-27 23:0:0' AND e.date<='2024-09-28 5:0:0' AND e.DeviceLoginName='2773' 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-27 20:00:00' AND g.time<='2024-09-28 02:00:00' AND g.DeviceLoginName='2773' GROUP BY  g.time, g.Distance;
CountAzimuth:61
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-27 23:0:0' AND e.date<='2024-09-28 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-09-27 20:00:00' AND g.time<='2024-09-28 02:00:00' AND g.DeviceLoginName='862531041041535' GROUP BY  g.time, g.Distance;
CountAzimuth:346
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-27 23:0:0' AND e.date<='2024-09-28 5:0:0' AND e.DeviceLoginName='2768' 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-27 20:00:00' AND g.time<='2024-09-28 02:00:00' AND g.DeviceLoginName='2768' GROUP BY  g.time, g.Distance;
CountAzimuth:133
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-27 23:0:0' AND e.date<='2024-09-28 5:0:0' AND e.DeviceLoginName='3156' 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-27 20:00:00' AND g.time<='2024-09-28 02:00:00' AND g.DeviceLoginName='3156' GROUP BY  g.time, g.Distance;
CountAzimuth:135
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-27 23:0:0' AND e.date<='2024-09-28 5:0:0' AND e.DeviceLoginName='2728' 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-27 20:00:00' AND g.time<='2024-09-28 02:00:00' AND g.DeviceLoginName='2728' GROUP BY  g.time, g.Distance;
CountAzimuth:22
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-27 23:0:0' AND e.date<='2024-09-28 5:0:0' AND e.DeviceLoginName='3132' 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-27 20:00:00' AND g.time<='2024-09-28 02:00:00' AND g.DeviceLoginName='3132' GROUP BY  g.time, g.Distance;
CountAzimuth:297
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-27 23:0:0' AND e.date<='2024-09-28 5:0:0' AND e.DeviceLoginName='3100' 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-27 20:00:00' AND g.time<='2024-09-28 02:00:00' AND g.DeviceLoginName='3100' GROUP BY  g.time, g.Distance;
CountAzimuth:24
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-27 23:0:0' AND e.date<='2024-09-28 5:0:0' AND e.DeviceLoginName='2499' 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-27 20:00:00' AND g.time<='2024-09-28 02:00:00' AND g.DeviceLoginName='2499' GROUP BY  g.time, g.Distance;
CountAzimuth:60
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-28 23:0:0' AND e.date<='2024-09-29 5:0:0' AND e.DeviceLoginName='9010' 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-28 20:00:00' AND g.time<='2024-09-29 02:00:00' AND g.DeviceLoginName='9010' GROUP BY  g.time, g.Distance;
CountAzimuth:149
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-28 23:0:0' AND e.date<='2024-09-29 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-09-28 20:00:00' AND g.time<='2024-09-29 02:00:00' AND g.DeviceLoginName='4966' GROUP BY  g.time, g.Distance;
CountAzimuth:223
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-28 23:0:0' AND e.date<='2024-09-29 5:0:0' AND e.DeviceLoginName='5129' 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-28 20:00:00' AND g.time<='2024-09-29 02:00:00' AND g.DeviceLoginName='5129' GROUP BY  g.time, g.Distance;
CountAzimuth:246
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-28 23:0:0' AND e.date<='2024-09-29 5:0:0' AND e.DeviceLoginName='2768' 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-28 20:00:00' AND g.time<='2024-09-29 02:00:00' AND g.DeviceLoginName='2768' GROUP BY  g.time, g.Distance;
CountAzimuth:242
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-28 23:0:0' AND e.date<='2024-09-29 5:0:0' AND e.DeviceLoginName='2738' 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-28 20:00:00' AND g.time<='2024-09-29 02:00:00' AND g.DeviceLoginName='2738' GROUP BY  g.time, g.Distance;
CountAzimuth:76
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-28 23:0:0' AND e.date<='2024-09-29 5:0:0' AND e.DeviceLoginName='3172' 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-28 20:00:00' AND g.time<='2024-09-29 02:00:00' AND g.DeviceLoginName='3172' GROUP BY  g.time, g.Distance;
CountAzimuth:102
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-28 23:0:0' AND e.date<='2024-09-29 5:0:0' AND e.DeviceLoginName='3197' 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-28 20:00:00' AND g.time<='2024-09-29 02:00:00' AND g.DeviceLoginName='3197' GROUP BY  g.time, g.Distance;
CountAzimuth:13
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-28 23:0:0' AND e.date<='2024-09-29 5:0:0' AND e.DeviceLoginName='2809' 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-28 20:00:00' AND g.time<='2024-09-29 02:00:00' AND g.DeviceLoginName='2809' GROUP BY  g.time, g.Distance;
CountAzimuth:608
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-28 23:0:0' AND e.date<='2024-09-29 5:0:0' AND e.DeviceLoginName='3115' 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-28 20:00:00' AND g.time<='2024-09-29 02:00:00' AND g.DeviceLoginName='3115' GROUP BY  g.time, g.Distance;
CountAzimuth:132
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-29 23:0:0' AND e.date<='2024-09-30 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-09-29 20:00:00' AND g.time<='2024-09-30 02:00:00' AND g.DeviceLoginName='862531041041535' GROUP BY  g.time, g.Distance;
CountAzimuth:37
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-29 23:0:0' AND e.date<='2024-09-30 5:0:0' AND e.DeviceLoginName='2947' 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-29 20:00:00' AND g.time<='2024-09-30 02:00:00' AND g.DeviceLoginName='2947' GROUP BY  g.time, g.Distance;
CountAzimuth:63
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-29 23:0:0' AND e.date<='2024-09-30 5:0:0' AND e.DeviceLoginName='2866' 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-29 20:00:00' AND g.time<='2024-09-30 02:00:00' AND g.DeviceLoginName='2866' GROUP BY  g.time, g.Distance;
CountAzimuth:136
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-29 23:0:0' AND e.date<='2024-09-30 5:0:0' AND e.DeviceLoginName='2768' 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-29 20:00:00' AND g.time<='2024-09-30 02:00:00' AND g.DeviceLoginName='2768' GROUP BY  g.time, g.Distance;
CountAzimuth:137
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-29 23:0:0' AND e.date<='2024-09-30 5:0:0' AND e.DeviceLoginName='2728' 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-29 20:00:00' AND g.time<='2024-09-30 02:00:00' AND g.DeviceLoginName='2728' GROUP BY  g.time, g.Distance;
CountAzimuth:189
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-30 0:56:57' AND e.date<='2024-10-01 15:56:57' AND e.DeviceLoginName='356078116305406' 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-29 21:56:57' AND g.time<='2024-10-01 12:56:57' AND g.DeviceLoginName='356078116305406' GROUP BY  g.time, g.Distance;
CountAzimuth:887