Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-18 0:12:47' AND e.date<='2024-10-18 23:12:47' AND e.DeviceLoginName='2749' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-10-17 22:12:47' AND g.time<='2024-10-18 21:12:47' AND g.DeviceLoginName='2749' GROUP BY  g.time, g.Distance;
CountAzimuth:544
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-24 0:14:48' AND e.date<='2024-10-24 23:14:48' AND e.DeviceLoginName='2749' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-10-23 22:14:48' AND g.time<='2024-10-24 21:14:48' AND g.DeviceLoginName='2749' GROUP BY  g.time, g.Distance;
CountAzimuth:142
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-23 0:16:6' AND e.date<='2024-10-23 23:16:6' AND e.DeviceLoginName='2749' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-10-22 22:16:06' AND g.time<='2024-10-23 21:16:06' AND g.DeviceLoginName='2749' GROUP BY  g.time, g.Distance;
CountAzimuth:134
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-22 0:17:5' AND e.date<='2024-10-22 23:17:5' AND e.DeviceLoginName='2749' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-10-21 22:17:05' AND g.time<='2024-10-22 21:17:05' AND g.DeviceLoginName='2749' GROUP BY  g.time, g.Distance;
CountAzimuth:1037
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-21 0:18:13' AND e.date<='2024-10-21 23:18:13' AND e.DeviceLoginName='2749' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-10-20 22:18:13' AND g.time<='2024-10-21 21:18:13' AND g.DeviceLoginName='2749' GROUP BY  g.time, g.Distance;
CountAzimuth:150
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-18 0:19:2' AND e.date<='2024-10-18 23:19:2' AND e.DeviceLoginName='2749' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-10-17 22:19:02' AND g.time<='2024-10-18 21:19:02' AND g.DeviceLoginName='2749' GROUP BY  g.time, g.Distance;
CountAzimuth:544
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-17 0:20:23' AND e.date<='2024-10-17 23:20:23' AND e.DeviceLoginName='2749' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-10-16 22:20:23' AND g.time<='2024-10-17 21:20:23' AND g.DeviceLoginName='2749' GROUP BY  g.time, g.Distance;
CountAzimuth:931
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-16 0:21:20' AND e.date<='2024-10-16 23:21:20' AND e.DeviceLoginName='2749' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-10-15 22:21:20' AND g.time<='2024-10-16 21:21:20' AND g.DeviceLoginName='2749' GROUP BY  g.time, g.Distance;
CountAzimuth:374
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-15 0:22:40' AND e.date<='2024-10-15 23:22:40' AND e.DeviceLoginName='2749' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-10-14 22:22:40' AND g.time<='2024-10-15 21:22:40' AND g.DeviceLoginName='2749' GROUP BY  g.time, g.Distance;
CountAzimuth:1062
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-14 0:23:47' AND e.date<='2024-10-14 23:23:47' AND e.DeviceLoginName='2749' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-10-13 22:23:47' AND g.time<='2024-10-14 21:23:47' AND g.DeviceLoginName='2749' GROUP BY  g.time, g.Distance;
CountAzimuth:904