Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-02 0:16:3' AND e.date<='2024-09-02 12:16:3' 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-01 21:16:03' AND g.time<='2024-09-02 09:16:03' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:424
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-02 7:21:0' AND e.date<='2024-09-02 12:21: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-09-02 04:21:00' AND g.time<='2024-09-02 09:21:00' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:160
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-02 5:25:54' AND e.date<='2024-09-02 12:25:54' 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-09-02 02:25:54' AND g.time<='2024-09-02 09:25:54' AND g.DeviceLoginName='354836080167561' GROUP BY  g.time, g.Distance;
CountAzimuth:467
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-26 23:0:0' AND e.date<='2024-08-27 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-08-26 20:00:00' AND g.time<='2024-08-27 02:00:00' AND g.DeviceLoginName='9010' GROUP BY  g.time, g.Distance;
CountAzimuth:190
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-26 23:0:0' AND e.date<='2024-08-27 5:0:0' AND e.DeviceLoginName='9011' 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-08-26 20:00:00' AND g.time<='2024-08-27 02:00:00' AND g.DeviceLoginName='9011' GROUP BY  g.time, g.Distance;
CountAzimuth:86
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-26 23:0:0' AND e.date<='2024-08-27 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-08-26 20:00:00' AND g.time<='2024-08-27 02:00:00' AND g.DeviceLoginName='2756' GROUP BY  g.time, g.Distance;
CountAzimuth:112
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-26 23:0:0' AND e.date<='2024-08-27 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-08-26 20:00:00' AND g.time<='2024-08-27 02:00:00' AND g.DeviceLoginName='4849' GROUP BY  g.time, g.Distance;
CountAzimuth:251
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-26 23:0:0' AND e.date<='2024-08-27 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-08-26 20:00:00' AND g.time<='2024-08-27 02:00:00' AND g.DeviceLoginName='2783' GROUP BY  g.time, g.Distance;
CountAzimuth:238
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-26 23:0:0' AND e.date<='2024-08-27 5:0:0' AND e.DeviceLoginName='2838' 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-08-26 20:00:00' AND g.time<='2024-08-27 02:00:00' AND g.DeviceLoginName='2838' GROUP BY  g.time, g.Distance;
CountAzimuth:307
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-26 23:0:0' AND e.date<='2024-08-27 5:0:0' AND e.DeviceLoginName='2454' 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-08-26 20:00:00' AND g.time<='2024-08-27 02:00:00' AND g.DeviceLoginName='2454' GROUP BY  g.time, g.Distance;
CountAzimuth:7
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-26 23:0:0' AND e.date<='2024-08-27 5:0:0' AND e.DeviceLoginName='3124' 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-08-26 20:00:00' AND g.time<='2024-08-27 02:00:00' AND g.DeviceLoginName='3124' GROUP BY  g.time, g.Distance;
CountAzimuth:244
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-26 23:0:0' AND e.date<='2024-08-27 5:0:0' AND e.DeviceLoginName='3178' 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-08-26 20:00:00' AND g.time<='2024-08-27 02:00:00' AND g.DeviceLoginName='3178' GROUP BY  g.time, g.Distance;
CountAzimuth:148
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-26 23:0:0' AND e.date<='2024-08-27 5:0:0' AND e.DeviceLoginName='2953' 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-08-26 20:00:00' AND g.time<='2024-08-27 02:00:00' AND g.DeviceLoginName='2953' GROUP BY  g.time, g.Distance;
CountAzimuth:255
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-26 23:0:0' AND e.date<='2024-08-27 5:0:0' AND e.DeviceLoginName='2735' 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-08-26 20:00:00' AND g.time<='2024-08-27 02:00:00' AND g.DeviceLoginName='2735' GROUP BY  g.time, g.Distance;
CountAzimuth:43
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-26 23:0:0' AND e.date<='2024-08-27 5:0:0' AND e.DeviceLoginName='2707' 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-08-26 20:00:00' AND g.time<='2024-08-27 02:00:00' AND g.DeviceLoginName='2707' GROUP BY  g.time, g.Distance;
CountAzimuth:20
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-27 23:0:0' AND e.date<='2024-08-28 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-08-27 20:00:00' AND g.time<='2024-08-28 02:00:00' AND g.DeviceLoginName='4849' GROUP BY  g.time, g.Distance;
CountAzimuth:185
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-27 23:0:0' AND e.date<='2024-08-28 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-08-27 20:00:00' AND g.time<='2024-08-28 02:00:00' AND g.DeviceLoginName='3081' GROUP BY  g.time, g.Distance;
CountAzimuth:214
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-27 23:0:0' AND e.date<='2024-08-28 5:0:0' AND e.DeviceLoginName='3023' 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-08-27 20:00:00' AND g.time<='2024-08-28 02:00:00' AND g.DeviceLoginName='3023' GROUP BY  g.time, g.Distance;
CountAzimuth:4
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-27 23:0:0' AND e.date<='2024-08-28 5:0:0' AND e.DeviceLoginName='2500' 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-08-27 20:00:00' AND g.time<='2024-08-28 02:00:00' AND g.DeviceLoginName='2500' GROUP BY  g.time, g.Distance;
CountAzimuth:60
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-27 23:0:0' AND e.date<='2024-08-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-08-27 20:00:00' AND g.time<='2024-08-28 02:00:00' AND g.DeviceLoginName='3100' GROUP BY  g.time, g.Distance;
CountAzimuth:12
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-28 23:0:0' AND e.date<='2024-08-29 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-08-28 20:00:00' AND g.time<='2024-08-29 02:00:00' AND g.DeviceLoginName='4849' GROUP BY  g.time, g.Distance;
CountAzimuth:240
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-28 23:0:0' AND e.date<='2024-08-29 5:0:0' AND e.DeviceLoginName='2769' 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-08-28 20:00:00' AND g.time<='2024-08-29 02:00:00' AND g.DeviceLoginName='2769' GROUP BY  g.time, g.Distance;
CountAzimuth:95
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-28 23:0:0' AND e.date<='2024-08-29 5:0:0' AND e.DeviceLoginName='3025' 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-08-28 20:00:00' AND g.time<='2024-08-29 02:00:00' AND g.DeviceLoginName='3025' GROUP BY  g.time, g.Distance;
CountAzimuth:48
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-28 23:0:0' AND e.date<='2024-08-29 5:0:0' AND e.DeviceLoginName='3091' 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-08-28 20:00:00' AND g.time<='2024-08-29 02:00:00' AND g.DeviceLoginName='3091' GROUP BY  g.time, g.Distance;
CountAzimuth:8
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-28 23:0:0' AND e.date<='2024-08-29 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-08-28 20:00:00' AND g.time<='2024-08-29 02:00:00' AND g.DeviceLoginName='2773' GROUP BY  g.time, g.Distance;
CountAzimuth:138
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-28 23:0:0' AND e.date<='2024-08-29 5:0:0' AND e.DeviceLoginName='3063' 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-08-28 20:00:00' AND g.time<='2024-08-29 02:00:00' AND g.DeviceLoginName='3063' GROUP BY  g.time, g.Distance;
CountAzimuth:206
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-28 23:0:0' AND e.date<='2024-08-29 5:0:0' 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-08-28 20:00:00' AND g.time<='2024-08-29 02:00:00' AND g.DeviceLoginName='3092' GROUP BY  g.time, g.Distance;
CountAzimuth:71
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-28 23:0:0' AND e.date<='2024-08-29 5:0:0' AND e.DeviceLoginName='353173060497698' 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-08-28 20:00:00' AND g.time<='2024-08-29 02:00:00' AND g.DeviceLoginName='353173060497698' GROUP BY  g.time, g.Distance;
CountAzimuth:439
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-28 23:0:0' AND e.date<='2024-08-29 5:0:0' AND e.DeviceLoginName='2735' 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-08-28 20:00:00' AND g.time<='2024-08-29 02:00:00' AND g.DeviceLoginName='2735' GROUP BY  g.time, g.Distance;
CountAzimuth:51
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-28 23:0:0' AND e.date<='2024-08-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-08-28 20:00:00' AND g.time<='2024-08-29 02:00:00' AND g.DeviceLoginName='3172' GROUP BY  g.time, g.Distance;
CountAzimuth:130
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-29 23:0:0' AND e.date<='2024-08-30 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-08-29 20:00:00' AND g.time<='2024-08-30 02:00:00' AND g.DeviceLoginName='9376' GROUP BY  g.time, g.Distance;
CountAzimuth:329
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-29 23:0:0' AND e.date<='2024-08-30 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-08-29 20:00:00' AND g.time<='2024-08-30 02:00:00' AND g.DeviceLoginName='4849' GROUP BY  g.time, g.Distance;
CountAzimuth:245
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-29 23:0:0' AND e.date<='2024-08-30 5:0:0' AND e.DeviceLoginName='3238' 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-08-29 20:00:00' AND g.time<='2024-08-30 02:00:00' AND g.DeviceLoginName='3238' GROUP BY  g.time, g.Distance;
CountAzimuth:126
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-29 23:0:0' AND e.date<='2024-08-30 5:0:0' AND e.DeviceLoginName='2735' 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-08-29 20:00:00' AND g.time<='2024-08-30 02:00:00' AND g.DeviceLoginName='2735' GROUP BY  g.time, g.Distance;
CountAzimuth:44
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-29 23:0:0' AND e.date<='2024-08-30 5:0:0' AND e.DeviceLoginName='2707' 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-08-29 20:00:00' AND g.time<='2024-08-30 02:00:00' AND g.DeviceLoginName='2707' GROUP BY  g.time, g.Distance;
CountAzimuth:7
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-29 23:0:0' AND e.date<='2024-08-30 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-08-29 20:00:00' AND g.time<='2024-08-30 02:00:00' AND g.DeviceLoginName='3197' GROUP BY  g.time, g.Distance;
CountAzimuth:12
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-29 23:0:0' AND e.date<='2024-08-30 5:0:0' AND e.DeviceLoginName='3205' 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-08-29 20:00:00' AND g.time<='2024-08-30 02:00:00' AND g.DeviceLoginName='3205' GROUP BY  g.time, g.Distance;
CountAzimuth:128
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-30 23:0:0' AND e.date<='2024-08-31 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-08-30 20:00:00' AND g.time<='2024-08-31 02:00:00' AND g.DeviceLoginName='3176' GROUP BY  g.time, g.Distance;
CountAzimuth:164
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-30 23:0:0' AND e.date<='2024-08-31 5:0:0' AND e.DeviceLoginName='4846' 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-08-30 20:00:00' AND g.time<='2024-08-31 02:00:00' AND g.DeviceLoginName='4846' GROUP BY  g.time, g.Distance;
CountAzimuth:226
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-30 23:0:0' AND e.date<='2024-08-31 5:0:0' 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-08-30 20:00:00' AND g.time<='2024-08-31 02:00:00' AND g.DeviceLoginName='3184' GROUP BY  g.time, g.Distance;
CountAzimuth:167
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-30 23:0:0' AND e.date<='2024-08-31 5:0:0' AND e.DeviceLoginName='3135' 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-08-30 20:00:00' AND g.time<='2024-08-31 02:00:00' AND g.DeviceLoginName='3135' GROUP BY  g.time, g.Distance;
CountAzimuth:24
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-30 23:0:0' AND e.date<='2024-08-31 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-08-30 20:00:00' AND g.time<='2024-08-31 02:00:00' AND g.DeviceLoginName='4849' GROUP BY  g.time, g.Distance;
CountAzimuth:258
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-30 23:0:0' AND e.date<='2024-08-31 5:0:0' AND e.DeviceLoginName='3238' 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-08-30 20:00:00' AND g.time<='2024-08-31 02:00:00' AND g.DeviceLoginName='3238' GROUP BY  g.time, g.Distance;
CountAzimuth:259
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-30 23:0:0' AND e.date<='2024-08-31 5:0:0' AND e.DeviceLoginName='2883' 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-08-30 20:00:00' AND g.time<='2024-08-31 02:00:00' AND g.DeviceLoginName='2883' GROUP BY  g.time, g.Distance;
CountAzimuth:132
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-30 23:0:0' AND e.date<='2024-08-31 5:0:0' AND e.DeviceLoginName='3166' 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-08-30 20:00:00' AND g.time<='2024-08-31 02:00:00' AND g.DeviceLoginName='3166' GROUP BY  g.time, g.Distance;
CountAzimuth:376
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-30 23:0:0' AND e.date<='2024-08-31 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-08-30 20:00:00' AND g.time<='2024-08-31 02:00:00' AND g.DeviceLoginName='5117' GROUP BY  g.time, g.Distance;
CountAzimuth:177
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-30 23:0:0' AND e.date<='2024-08-31 5:0:0' AND e.DeviceLoginName='2454' 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-08-30 20:00:00' AND g.time<='2024-08-31 02:00:00' AND g.DeviceLoginName='2454' GROUP BY  g.time, g.Distance;
CountAzimuth:50
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-30 23:0:0' AND e.date<='2024-08-31 5:0:0' AND e.DeviceLoginName='8993' 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-08-30 20:00:00' AND g.time<='2024-08-31 02:00:00' AND g.DeviceLoginName='8993' GROUP BY  g.time, g.Distance;
CountAzimuth:72
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-30 23:0:0' AND e.date<='2024-08-31 5:0:0' AND e.DeviceLoginName='4861' 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-08-30 20:00:00' AND g.time<='2024-08-31 02:00:00' AND g.DeviceLoginName='4861' GROUP BY  g.time, g.Distance;
CountAzimuth:89
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-30 23:0:0' AND e.date<='2024-08-31 5:0:0' AND e.DeviceLoginName='2470' 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-08-30 20:00:00' AND g.time<='2024-08-31 02:00:00' AND g.DeviceLoginName='2470' GROUP BY  g.time, g.Distance;
CountAzimuth:205
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-30 23:0:0' AND e.date<='2024-08-31 5:0:0' 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-08-30 20:00:00' AND g.time<='2024-08-31 02:00:00' AND g.DeviceLoginName='3092' GROUP BY  g.time, g.Distance;
CountAzimuth:188
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-30 23:0:0' AND e.date<='2024-08-31 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-08-30 20:00:00' AND g.time<='2024-08-31 02:00:00' AND g.DeviceLoginName='356078111279820' GROUP BY  g.time, g.Distance;
CountAzimuth:10
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-30 23:0:0' AND e.date<='2024-08-31 5:0:0' AND e.DeviceLoginName='354836080357964' 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-08-30 20:00:00' AND g.time<='2024-08-31 02:00:00' AND g.DeviceLoginName='354836080357964' GROUP BY  g.time, g.Distance;
CountAzimuth:140
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-30 23:0:0' AND e.date<='2024-08-31 5:0:0' AND e.DeviceLoginName='2755' 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-08-30 20:00:00' AND g.time<='2024-08-31 02:00:00' AND g.DeviceLoginName='2755' GROUP BY  g.time, g.Distance;
CountAzimuth:11
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-31 23:0:0' AND e.date<='2024-09-01 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-08-31 20:00:00' AND g.time<='2024-09-01 02:00:00' AND g.DeviceLoginName='4849' GROUP BY  g.time, g.Distance;
CountAzimuth:209
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-31 23:0:0' AND e.date<='2024-09-01 5:0:0' AND e.DeviceLoginName='2633' 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-08-31 20:00:00' AND g.time<='2024-09-01 02:00:00' AND g.DeviceLoginName='2633' GROUP BY  g.time, g.Distance;
CountAzimuth:34
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-31 23:0:0' AND e.date<='2024-09-01 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-08-31 20:00:00' AND g.time<='2024-09-01 02:00:00' AND g.DeviceLoginName='5117' GROUP BY  g.time, g.Distance;
CountAzimuth:174
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-31 23:0:0' AND e.date<='2024-09-01 5:0:0' AND e.DeviceLoginName='354836080314031' 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-08-31 20:00:00' AND g.time<='2024-09-01 02:00:00' AND g.DeviceLoginName='354836080314031' GROUP BY  g.time, g.Distance;
CountAzimuth:153
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-01 23:0:0' AND e.date<='2024-09-02 5:0:0' AND e.DeviceLoginName='354836080392664' 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-01 20:00:00' AND g.time<='2024-09-02 02:00:00' AND g.DeviceLoginName='354836080392664' GROUP BY  g.time, g.Distance;
CountAzimuth:90
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-01 23:0:0' AND e.date<='2024-09-02 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-09-01 20:00:00' AND g.time<='2024-09-02 02:00:00' AND g.DeviceLoginName='4849' GROUP BY  g.time, g.Distance;
CountAzimuth:159
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-01 23:0:0' AND e.date<='2024-09-02 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-01 20:00:00' AND g.time<='2024-09-02 02:00:00' AND g.DeviceLoginName='862531041050148' GROUP BY  g.time, g.Distance;
CountAzimuth:5
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-01 23:0:0' AND e.date<='2024-09-02 5:0:0' AND e.DeviceLoginName='3188' 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-01 20:00:00' AND g.time<='2024-09-02 02:00:00' AND g.DeviceLoginName='3188' GROUP BY  g.time, g.Distance;
CountAzimuth:186
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-01 23:0:0' AND e.date<='2024-09-02 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-09-01 20:00:00' AND g.time<='2024-09-02 02:00:00' AND g.DeviceLoginName='5117' GROUP BY  g.time, g.Distance;
CountAzimuth:195
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-01 23:0:0' AND e.date<='2024-09-02 5:0:0' AND e.DeviceLoginName='2743' 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-01 20:00:00' AND g.time<='2024-09-02 02:00:00' AND g.DeviceLoginName='2743' GROUP BY  g.time, g.Distance;
CountAzimuth:9
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-01 23:0:0' AND e.date<='2024-09-02 5:0:0' AND e.DeviceLoginName='2627' 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-01 20:00:00' AND g.time<='2024-09-02 02:00:00' AND g.DeviceLoginName='2627' GROUP BY  g.time, g.Distance;
CountAzimuth:13