Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-23 23:0:0' AND e.date<='2024-09-24 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-23 20:00:00' AND g.time<='2024-09-24 02:00:00' AND g.DeviceLoginName='2756' GROUP BY  g.time, g.Distance;
CountAzimuth:100
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-23 23:0:0' AND e.date<='2024-09-24 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-09-23 20:00:00' AND g.time<='2024-09-24 02:00:00' AND g.DeviceLoginName='3081' GROUP BY  g.time, g.Distance;
CountAzimuth:116
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-23 23:0:0' AND e.date<='2024-09-24 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-23 20:00:00' AND g.time<='2024-09-24 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-09-23 23:0:0' AND e.date<='2024-09-24 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-23 20:00:00' AND g.time<='2024-09-24 02:00:00' AND g.DeviceLoginName='5117' GROUP BY  g.time, g.Distance;
CountAzimuth:211
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-23 23:0:0' AND e.date<='2024-09-24 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-09-23 20:00:00' AND g.time<='2024-09-24 02:00:00' AND g.DeviceLoginName='3092' GROUP BY  g.time, g.Distance;
CountAzimuth:61
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-23 23:0:0' AND e.date<='2024-09-24 5:0:0' AND e.DeviceLoginName='3019' 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-23 20:00:00' AND g.time<='2024-09-24 02:00:00' AND g.DeviceLoginName='3019' GROUP BY  g.time, g.Distance;
CountAzimuth:133
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-23 23:0:0' AND e.date<='2024-09-24 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-09-23 20:00:00' AND g.time<='2024-09-24 02:00:00' AND g.DeviceLoginName='3178' GROUP BY  g.time, g.Distance;
CountAzimuth:57
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-23 23:0:0' AND e.date<='2024-09-24 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-09-23 20:00:00' AND g.time<='2024-09-24 02:00:00' AND g.DeviceLoginName='353173060497698' GROUP BY  g.time, g.Distance;
CountAzimuth:53
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-23 23:0:0' AND e.date<='2024-09-24 5:0:0' AND e.DeviceLoginName='2726' 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-23 20:00:00' AND g.time<='2024-09-24 02:00:00' AND g.DeviceLoginName='2726' GROUP BY  g.time, g.Distance;
CountAzimuth:142
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-23 23:0:0' AND e.date<='2024-09-24 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-23 20:00:00' AND g.time<='2024-09-24 02:00:00' AND g.DeviceLoginName='3172' GROUP BY  g.time, g.Distance;
CountAzimuth:109
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-23 23:0:0' AND e.date<='2024-09-24 5:0:0' 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-09-23 20:00:00' AND g.time<='2024-09-24 02:00:00' AND g.DeviceLoginName='2908' GROUP BY  g.time, g.Distance;
CountAzimuth:3
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-24 23:0:0' AND e.date<='2024-09-25 5:0:0' AND e.DeviceLoginName='2704' 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-24 20:00:00' AND g.time<='2024-09-25 02:00:00' AND g.DeviceLoginName='2704' GROUP BY  g.time, g.Distance;
CountAzimuth:8
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-24 23:0:0' AND e.date<='2024-09-25 5:0:0' AND e.DeviceLoginName='2677' 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-24 20:00:00' AND g.time<='2024-09-25 02:00:00' AND g.DeviceLoginName='2677' GROUP BY  g.time, g.Distance;
CountAzimuth:188
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-24 23:0:0' AND e.date<='2024-09-25 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-24 20:00:00' AND g.time<='2024-09-25 02:00:00' AND g.DeviceLoginName='862531041050148' GROUP BY  g.time, g.Distance;
CountAzimuth:107
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-24 23:0:0' AND e.date<='2024-09-25 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-24 20:00:00' AND g.time<='2024-09-25 02:00:00' AND g.DeviceLoginName='2773' GROUP BY  g.time, g.Distance;
CountAzimuth:71
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-24 23:0:0' AND e.date<='2024-09-25 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-09-24 20:00:00' AND g.time<='2024-09-25 02:00:00' AND g.DeviceLoginName='2500' GROUP BY  g.time, g.Distance;
CountAzimuth:9
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-24 23:0:0' AND e.date<='2024-09-25 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-09-24 20:00:00' AND g.time<='2024-09-25 02:00:00' AND g.DeviceLoginName='353173060497698' GROUP BY  g.time, g.Distance;
CountAzimuth:74
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-24 23:0:0' AND e.date<='2024-09-25 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-24 20:00:00' AND g.time<='2024-09-25 02:00:00' AND g.DeviceLoginName='3197' GROUP BY  g.time, g.Distance;
CountAzimuth:11
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-25 23:0:0' AND e.date<='2024-09-26 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-25 20:00:00' AND g.time<='2024-09-26 02:00:00' AND g.DeviceLoginName='9010' GROUP BY  g.time, g.Distance;
CountAzimuth:140
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-25 23:0:0' AND e.date<='2024-09-26 5:0:0' AND e.DeviceLoginName='5131' 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-25 20:00:00' AND g.time<='2024-09-26 02:00:00' AND g.DeviceLoginName='5131' GROUP BY  g.time, g.Distance;
CountAzimuth:56
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-25 23:0:0' AND e.date<='2024-09-26 5:0:0' 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-09-25 20:00:00' AND g.time<='2024-09-26 02:00:00' AND g.DeviceLoginName='5078' GROUP BY  g.time, g.Distance;
CountAzimuth:25
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-25 23:0:0' AND e.date<='2024-09-26 5:0:0' AND e.DeviceLoginName='862531041079980' 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-25 20:00:00' AND g.time<='2024-09-26 02:00:00' AND g.DeviceLoginName='862531041079980' GROUP BY  g.time, g.Distance;
CountAzimuth:62
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-25 23:0:0' AND e.date<='2024-09-26 5:0:0' AND e.DeviceLoginName='2874' 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-25 20:00:00' AND g.time<='2024-09-26 02:00:00' AND g.DeviceLoginName='2874' GROUP BY  g.time, g.Distance;
CountAzimuth:19
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-25 23:0:0' AND e.date<='2024-09-26 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-25 20:00:00' AND g.time<='2024-09-26 02:00:00' AND g.DeviceLoginName='353173060537865' GROUP BY  g.time, g.Distance;
CountAzimuth:90
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-25 23:0:0' AND e.date<='2024-09-26 5:0:0' AND e.DeviceLoginName='4869' 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-25 20:00:00' AND g.time<='2024-09-26 02:00:00' AND g.DeviceLoginName='4869' GROUP BY  g.time, g.Distance;
CountAzimuth:193
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-25 23:0:0' AND e.date<='2024-09-26 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-25 20:00:00' AND g.time<='2024-09-26 02:00:00' AND g.DeviceLoginName='862531041041535' GROUP BY  g.time, g.Distance;
CountAzimuth:44
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-25 23:0:0' AND e.date<='2024-09-26 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-25 20:00:00' AND g.time<='2024-09-26 02:00:00' AND g.DeviceLoginName='2947' GROUP BY  g.time, g.Distance;
CountAzimuth:143
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-25 23:0:0' AND e.date<='2024-09-26 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-09-25 20:00:00' AND g.time<='2024-09-26 02:00:00' AND g.DeviceLoginName='2470' GROUP BY  g.time, g.Distance;
CountAzimuth:78
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-25 23:0:0' AND e.date<='2024-09-26 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-25 20:00:00' AND g.time<='2024-09-26 02:00:00' AND g.DeviceLoginName='2866' GROUP BY  g.time, g.Distance;
CountAzimuth:76
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-25 23:0:0' AND e.date<='2024-09-26 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-09-25 20:00:00' AND g.time<='2024-09-26 02:00:00' AND g.DeviceLoginName='4862' GROUP BY  g.time, g.Distance;
CountAzimuth:226
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-25 23:0:0' AND e.date<='2024-09-26 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-25 20:00:00' AND g.time<='2024-09-26 02:00:00' AND g.DeviceLoginName='3156' GROUP BY  g.time, g.Distance;
CountAzimuth:213
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-25 23:0:0' AND e.date<='2024-09-26 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-09-25 20:00:00' AND g.time<='2024-09-26 02:00:00' AND g.DeviceLoginName='353173060497698' GROUP BY  g.time, g.Distance;
CountAzimuth:145
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-25 23:0:0' AND e.date<='2024-09-26 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-25 20:00:00' AND g.time<='2024-09-26 02:00:00' AND g.DeviceLoginName='2627' GROUP BY  g.time, g.Distance;
CountAzimuth:49
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-26 23:0:0' AND e.date<='2024-09-27 5:0:0' AND e.DeviceLoginName='2898' 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-26 20:00:00' AND g.time<='2024-09-27 02:00:00' AND g.DeviceLoginName='2898' GROUP BY  g.time, g.Distance;
CountAzimuth:7
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-26 23:0:0' AND e.date<='2024-09-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-09-26 20:00:00' AND g.time<='2024-09-27 02:00:00' AND g.DeviceLoginName='4849' GROUP BY  g.time, g.Distance;
CountAzimuth:327
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-26 23:0:0' AND e.date<='2024-09-27 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-26 20:00:00' AND g.time<='2024-09-27 02:00:00' AND g.DeviceLoginName='862531041050148' GROUP BY  g.time, g.Distance;
CountAzimuth:4
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-26 23:0:0' AND e.date<='2024-09-27 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-09-26 20:00:00' AND g.time<='2024-09-27 02:00:00' AND g.DeviceLoginName='4862' GROUP BY  g.time, g.Distance;
CountAzimuth:224
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-26 23:0:0' AND e.date<='2024-09-27 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-09-26 20:00:00' AND g.time<='2024-09-27 02:00:00' AND g.DeviceLoginName='353173060497698' GROUP BY  g.time, g.Distance;
CountAzimuth:45
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-26 23:0:0' AND e.date<='2024-09-27 5:0:0' AND e.DeviceLoginName='3036' 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-26 20:00:00' AND g.time<='2024-09-27 02:00:00' AND g.DeviceLoginName='3036' GROUP BY  g.time, g.Distance;
CountAzimuth:38
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-26 11:24:49' AND e.date<='2024-09-27 11:24:49' 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-26 08:24:49' AND g.time<='2024-09-27 08:24:49' AND g.DeviceLoginName='3057' GROUP BY  g.time, g.Distance;
CountAzimuth:490
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-23 0:24:49' AND e.date<='2024-09-23 23:24:49' 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-22 21:24:49' AND g.time<='2024-09-23 20:24:49' AND g.DeviceLoginName='3057' GROUP BY  g.time, g.Distance;
CountAzimuth:547
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-23 0:24:49' AND e.date<='2024-09-23 23:24:49' AND e.DeviceLoginName='355234055170423' 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-22 21:24:49' AND g.time<='2024-09-23 20:24:49' AND g.DeviceLoginName='355234055170423' GROUP BY  g.time, g.Distance;
CountAzimuth:308
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-24 0:24:49' AND e.date<='2024-09-24 23:24:49' AND e.DeviceLoginName='355234055170423' 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-23 21:24:49' AND g.time<='2024-09-24 20:24:49' AND g.DeviceLoginName='355234055170423' GROUP BY  g.time, g.Distance;
CountAzimuth:515
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-25 0:24:49' AND e.date<='2024-09-25 23:24:49' AND e.DeviceLoginName='355234055170423' 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-24 21:24:49' AND g.time<='2024-09-25 20:24:49' AND g.DeviceLoginName='355234055170423' GROUP BY  g.time, g.Distance;
CountAzimuth:890
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-26 0:24:49' AND e.date<='2024-09-26 23:24:49' AND e.DeviceLoginName='355234055170423' 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-25 21:24:49' AND g.time<='2024-09-26 20:24:49' AND g.DeviceLoginName='355234055170423' GROUP BY  g.time, g.Distance;
CountAzimuth:655