Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-13 0:58:16' AND e.date<='2024-06-13 23:58:16' AND e.DeviceLoginName='356078116278207' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-06-12 21:58:16' AND g.time<='2024-06-13 20:58:16' AND g.DeviceLoginName='356078116278207' GROUP BY  g.time, g.Distance;
CountAzimuth:1268
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-10 23:0:0' AND e.date<='2024-06-11 5:0:0' AND e.DeviceLoginName='4849' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-06-10 20:00:00' AND g.time<='2024-06-11 02:00:00' AND g.DeviceLoginName='4849' GROUP BY  g.time, g.Distance;
CountAzimuth:334
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-10 23:0:0' AND e.date<='2024-06-11 5:0:0' AND e.DeviceLoginName='2904' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-06-10 20:00:00' AND g.time<='2024-06-11 02:00:00' AND g.DeviceLoginName='2904' GROUP BY  g.time, g.Distance;
CountAzimuth:209
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-11 23:0:0' AND e.date<='2024-06-12 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-06-11 20:00:00' AND g.time<='2024-06-12 02:00:00' AND g.DeviceLoginName='9010' GROUP BY  g.time, g.Distance;
CountAzimuth:40
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-11 23:0:0' AND e.date<='2024-06-12 5:0:0' AND e.DeviceLoginName='8997' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-06-11 20:00:00' AND g.time<='2024-06-12 02:00:00' AND g.DeviceLoginName='8997' GROUP BY  g.time, g.Distance;
CountAzimuth:33
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-11 23:0:0' AND e.date<='2024-06-12 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-06-11 20:00:00' AND g.time<='2024-06-12 02:00:00' AND g.DeviceLoginName='3176' GROUP BY  g.time, g.Distance;
CountAzimuth:56
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-11 23:0:0' AND e.date<='2024-06-12 5:0:0' AND e.DeviceLoginName='8992' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-06-11 20:00:00' AND g.time<='2024-06-12 02:00:00' AND g.DeviceLoginName='8992' GROUP BY  g.time, g.Distance;
CountAzimuth:147
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-11 23:0:0' AND e.date<='2024-06-12 5:0:0' AND e.DeviceLoginName='4849' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-06-11 20:00:00' AND g.time<='2024-06-12 02:00:00' AND g.DeviceLoginName='4849' GROUP BY  g.time, g.Distance;
CountAzimuth:360
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-11 23:0:0' AND e.date<='2024-06-12 5:0:0' AND e.DeviceLoginName='356078111320111' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-06-11 20:00:00' AND g.time<='2024-06-12 02:00:00' AND g.DeviceLoginName='356078111320111' GROUP BY  g.time, g.Distance;
CountAzimuth:127
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-11 23:0:0' AND e.date<='2024-06-12 5:0:0' AND e.DeviceLoginName='9382' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-06-11 20:00:00' AND g.time<='2024-06-12 02:00:00' AND g.DeviceLoginName='9382' GROUP BY  g.time, g.Distance;
CountAzimuth:708
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-11 23:0:0' AND e.date<='2024-06-12 5:0:0' AND e.DeviceLoginName='352353085654322' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-06-11 20:00:00' AND g.time<='2024-06-12 02:00:00' AND g.DeviceLoginName='352353085654322' GROUP BY  g.time, g.Distance;
CountAzimuth:67
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-11 23:0:0' AND e.date<='2024-06-12 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-06-11 20:00:00' AND g.time<='2024-06-12 02:00:00' AND g.DeviceLoginName='353173060497698' GROUP BY  g.time, g.Distance;
CountAzimuth:73
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-11 23:0:0' AND e.date<='2024-06-12 5:0:0' AND e.DeviceLoginName='2630' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-06-11 20:00:00' AND g.time<='2024-06-12 02:00:00' AND g.DeviceLoginName='2630' GROUP BY  g.time, g.Distance;
CountAzimuth:15
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-11 23:0:0' AND e.date<='2024-06-12 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-06-11 20:00:00' AND g.time<='2024-06-12 02:00:00' AND g.DeviceLoginName='3197' GROUP BY  g.time, g.Distance;
CountAzimuth:48
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-12 23:0:0' AND e.date<='2024-06-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-06-12 20:00:00' AND g.time<='2024-06-13 02:00:00' AND g.DeviceLoginName='4849' GROUP BY  g.time, g.Distance;
CountAzimuth:281
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-12 23:0:0' AND e.date<='2024-06-13 5:0:0' AND e.DeviceLoginName='2585' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-06-12 20:00:00' AND g.time<='2024-06-13 02:00:00' AND g.DeviceLoginName='2585' GROUP BY  g.time, g.Distance;
CountAzimuth:65
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-12 23:0:0' AND e.date<='2024-06-13 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-06-12 20:00:00' AND g.time<='2024-06-13 02:00:00' AND g.DeviceLoginName='3156' GROUP BY  g.time, g.Distance;
CountAzimuth:155
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-12 23:0:0' AND e.date<='2024-06-13 5:0:0' AND e.DeviceLoginName='356078116291259' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-06-12 20:00:00' AND g.time<='2024-06-13 02:00:00' AND g.DeviceLoginName='356078116291259' GROUP BY  g.time, g.Distance;
CountAzimuth:116
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-12 23:0:0' AND e.date<='2024-06-13 5:0:0' AND e.DeviceLoginName='2912' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-06-12 20:00:00' AND g.time<='2024-06-13 02:00:00' AND g.DeviceLoginName='2912' GROUP BY  g.time, g.Distance;
CountAzimuth:88
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-12 23:0:0' AND e.date<='2024-06-13 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-06-12 20:00:00' AND g.time<='2024-06-13 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-06-12 23:0:0' AND e.date<='2024-06-13 5:0:0' AND e.DeviceLoginName='2912' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-06-12 20:00:00' AND g.time<='2024-06-13 02:00:00' AND g.DeviceLoginName='2912' GROUP BY  g.time, g.Distance;
CountAzimuth:88
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-13 23:0:0' AND e.date<='2024-06-14 5:0:0' AND e.DeviceLoginName='5046' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-06-13 20:00:00' AND g.time<='2024-06-14 02:00:00' AND g.DeviceLoginName='5046' GROUP BY  g.time, g.Distance;
CountAzimuth:40
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-13 23:0:0' AND e.date<='2024-06-14 5:0:0' AND e.DeviceLoginName='862531041078313' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-06-13 20:00:00' AND g.time<='2024-06-14 02:00:00' AND g.DeviceLoginName='862531041078313' GROUP BY  g.time, g.Distance;
CountAzimuth:92
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-13 23:0:0' AND e.date<='2024-06-14 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-06-13 20:00:00' AND g.time<='2024-06-14 02:00:00' AND g.DeviceLoginName='9376' GROUP BY  g.time, g.Distance;
CountAzimuth:284
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-13 23:0:0' AND e.date<='2024-06-14 5:0:0' AND e.DeviceLoginName='4848' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-06-13 20:00:00' AND g.time<='2024-06-14 02:00:00' AND g.DeviceLoginName='4848' GROUP BY  g.time, g.Distance;
CountAzimuth:143
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-13 23:0:0' AND e.date<='2024-06-14 5:0:0' AND e.DeviceLoginName='2652' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-06-13 20:00:00' AND g.time<='2024-06-14 02:00:00' AND g.DeviceLoginName='2652' GROUP BY  g.time, g.Distance;
CountAzimuth:47
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-13 23:0:0' AND e.date<='2024-06-14 5:0:0' AND e.DeviceLoginName='8992' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-06-13 20:00:00' AND g.time<='2024-06-14 02:00:00' AND g.DeviceLoginName='8992' GROUP BY  g.time, g.Distance;
CountAzimuth:150
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-13 23:0:0' AND e.date<='2024-06-14 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-06-13 20:00:00' AND g.time<='2024-06-14 02:00:00' AND g.DeviceLoginName='2769' GROUP BY  g.time, g.Distance;
CountAzimuth:92
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-13 23:0:0' AND e.date<='2024-06-14 5:0:0' AND e.DeviceLoginName='4883' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-06-13 20:00:00' AND g.time<='2024-06-14 02:00:00' AND g.DeviceLoginName='4883' GROUP BY  g.time, g.Distance;
CountAzimuth:84
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-13 23:0:0' AND e.date<='2024-06-14 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-06-13 20:00:00' AND g.time<='2024-06-14 02:00:00' AND g.DeviceLoginName='8993' GROUP BY  g.time, g.Distance;
CountAzimuth:79
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-13 23:0:0' AND e.date<='2024-06-14 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-06-13 20:00:00' AND g.time<='2024-06-14 02:00:00' AND g.DeviceLoginName='2947' GROUP BY  g.time, g.Distance;
CountAzimuth:162
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-13 23:0:0' AND e.date<='2024-06-14 5:0:0' AND e.DeviceLoginName='2506' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-06-13 20:00:00' AND g.time<='2024-06-14 02:00:00' AND g.DeviceLoginName='2506' GROUP BY  g.time, g.Distance;
CountAzimuth:49
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-13 23:0:0' AND e.date<='2024-06-14 5:0:0' AND e.DeviceLoginName='2585' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-06-13 20:00:00' AND g.time<='2024-06-14 02:00:00' AND g.DeviceLoginName='2585' GROUP BY  g.time, g.Distance;
CountAzimuth:95
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-13 23:0:0' AND e.date<='2024-06-14 5:0:0' AND e.DeviceLoginName='3179' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-06-13 20:00:00' AND g.time<='2024-06-14 02:00:00' AND g.DeviceLoginName='3179' GROUP BY  g.time, g.Distance;
CountAzimuth:18
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-13 23:0:0' AND e.date<='2024-06-14 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-06-13 20:00:00' AND g.time<='2024-06-14 02:00:00' AND g.DeviceLoginName='2713' GROUP BY  g.time, g.Distance;
CountAzimuth:160
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-13 23:0:0' AND e.date<='2024-06-14 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-06-13 20:00:00' AND g.time<='2024-06-14 02:00:00' AND g.DeviceLoginName='3156' GROUP BY  g.time, g.Distance;
CountAzimuth:53
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-13 23:0:0' AND e.date<='2024-06-14 5:0:0' AND e.DeviceLoginName='356078116291259' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-06-13 20:00:00' AND g.time<='2024-06-14 02:00:00' AND g.DeviceLoginName='356078116291259' GROUP BY  g.time, g.Distance;
CountAzimuth:90
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-13 23:0:0' AND e.date<='2024-06-14 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-06-13 20:00:00' AND g.time<='2024-06-14 02:00:00' AND g.DeviceLoginName='3197' GROUP BY  g.time, g.Distance;
CountAzimuth:5
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-13 23:0:0' AND e.date<='2024-06-14 5:0:0' AND e.DeviceLoginName='2752' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-06-13 20:00:00' AND g.time<='2024-06-14 02:00:00' AND g.DeviceLoginName='2752' GROUP BY  g.time, g.Distance;
CountAzimuth:24
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-13 23:0:0' AND e.date<='2024-06-14 5:0:0' AND e.DeviceLoginName='2804' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-06-13 20:00:00' AND g.time<='2024-06-14 02:00:00' AND g.DeviceLoginName='2804' GROUP BY  g.time, g.Distance;
CountAzimuth:69
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-01 0:48:30' AND e.date<='2024-06-02 23:48:30' AND e.DeviceLoginName='3126' 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-05-31 21:48:30' AND g.time<='2024-06-02 20:48:30' AND g.DeviceLoginName='3126' GROUP BY  g.time, g.Distance;
CountAzimuth:2229
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-10 0:49:31' AND e.date<='2024-06-14 14:49:31' AND e.DeviceLoginName='2647' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-06-09 21:49:31' AND g.time<='2024-06-14 11:49:31' AND g.DeviceLoginName='2647' GROUP BY  g.time, g.Distance;
CountAzimuth:4915
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-14 4:19:37' AND e.date<='2024-06-14 15:19:37' AND e.DeviceLoginName='3056' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-06-14 01:19:37' AND g.time<='2024-06-14 12:19:37' AND g.DeviceLoginName='3056' GROUP BY  g.time, g.Distance;
CountAzimuth:1461
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-14 7:20:15' AND e.date<='2024-06-14 15:20:15' AND e.DeviceLoginName='352353086131601' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-06-14 04:20:15' AND g.time<='2024-06-14 12:20:15' AND g.DeviceLoginName='352353086131601' GROUP BY  g.time, g.Distance;
CountAzimuth:488
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-14 2:20:40' AND e.date<='2024-06-14 15:20:40' AND e.DeviceLoginName='5046' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-06-13 23:20:40' AND g.time<='2024-06-14 12:20:40' AND g.DeviceLoginName='5046' GROUP BY  g.time, g.Distance;
CountAzimuth:1709
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-14 1:21:5' AND e.date<='2024-06-14 15:21:5' AND e.DeviceLoginName='352353084175477' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-06-13 22:21:05' AND g.time<='2024-06-14 12:21:05' AND g.DeviceLoginName='352353084175477' GROUP BY  g.time, g.Distance;
CountAzimuth:1783
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-14 5:21:29' AND e.date<='2024-06-14 15:21:29' AND e.DeviceLoginName='356078111279986' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-06-14 02:21:29' AND g.time<='2024-06-14 12:21:29' AND g.DeviceLoginName='356078111279986' GROUP BY  g.time, g.Distance;
CountAzimuth:389
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-14 3:22:29' AND e.date<='2024-06-14 15:22:29' AND e.DeviceLoginName='3184' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-06-14 00:22:29' AND g.time<='2024-06-14 12:22:29' AND g.DeviceLoginName='3184' GROUP BY  g.time, g.Distance;
CountAzimuth:1716