Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-19 0:13:50' AND e.date<='2024-04-19 23:13:50' AND e.DeviceLoginName='8987' 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-04-18 21:13:50' AND g.time<='2024-04-19 20:13:50' AND g.DeviceLoginName='8987' GROUP BY  g.time, g.Distance;
CountAzimuth:0
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-12 0:13:50' AND e.date<='2024-04-12 23:13:50' AND e.DeviceLoginName='8987' 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-04-11 21:13:50' AND g.time<='2024-04-12 20:13:50' AND g.DeviceLoginName='8987' GROUP BY  g.time, g.Distance;
CountAzimuth:416
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-13 0:13:50' AND e.date<='2024-04-13 23:13:50' AND e.DeviceLoginName='8987' 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-04-12 21:13:50' AND g.time<='2024-04-13 20:13:50' AND g.DeviceLoginName='8987' GROUP BY  g.time, g.Distance;
CountAzimuth:1380
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-14 0:13:50' AND e.date<='2024-04-14 23:13:50' AND e.DeviceLoginName='8987' 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-04-13 21:13:50' AND g.time<='2024-04-14 20:13:50' AND g.DeviceLoginName='8987' GROUP BY  g.time, g.Distance;
CountAzimuth:1451
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-08 0:2:47' AND e.date<='2024-04-12 23:2:47' AND e.DeviceLoginName='2759' 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-04-07 21:02:47' AND g.time<='2024-04-12 20:02:47' AND g.DeviceLoginName='2759' GROUP BY  g.time, g.Distance;
CountAzimuth:1811
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-16 0:9:37' AND e.date<='2024-04-16 11:9:37' 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-04-15 21:09:37' AND g.time<='2024-04-16 08:09:37' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:98
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-16 0:43:19' AND e.date<='2024-04-16 12:43:19' 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-04-15 21:43:19' AND g.time<='2024-04-16 09:43:19' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:98
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-16 4:43:55' AND e.date<='2024-04-16 12:43:55' 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-04-16 01:43:55' AND g.time<='2024-04-16 09:43:55' AND g.DeviceLoginName='5117' GROUP BY  g.time, g.Distance;
CountAzimuth:953
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-08 0:7:36' AND e.date<='2024-04-12 23:7:36' AND e.DeviceLoginName='3032' 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-04-07 21:07:36' AND g.time<='2024-04-12 20:07:36' AND g.DeviceLoginName='3032' GROUP BY  g.time, g.Distance;
CountAzimuth:4106
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-16 4:9:12' AND e.date<='2024-04-16 15:9:12' 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-04-16 01:09:12' AND g.time<='2024-04-16 12:09:12' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:555
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-15 15:56:54' AND e.date<='2024-04-16 15:56:54' AND e.DeviceLoginName='352353084159372' 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-04-15 12:56:54' AND g.time<='2024-04-16 12:56:54' AND g.DeviceLoginName='352353084159372' GROUP BY  g.time, g.Distance;
CountAzimuth:3389