Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-09 1:0:0' AND e.date<='2024-10-09 9:0: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-10-08 22:00:00' AND g.time<='2024-10-09 06:00:00' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:289
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-09 4:0:48' AND e.date<='2024-10-09 9:0:48' 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-10-09 01:00:48' AND g.time<='2024-10-09 06:00:48' AND g.DeviceLoginName='3184' GROUP BY  g.time, g.Distance;
CountAzimuth:1085
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-10 23:0:55' AND e.date<='2024-09-11 5:0:55' 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-09-10 20:00:55' AND g.time<='2024-09-11 02:00:55' AND g.DeviceLoginName='9382' GROUP BY  g.time, g.Distance;
CountAzimuth:177
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-10 23:0:55' AND e.date<='2024-09-11 9:0:55' 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-09-10 20:00:55' AND g.time<='2024-09-11 06:00:55' AND g.DeviceLoginName='9382' GROUP BY  g.time, g.Distance;
CountAzimuth:177
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-10 23:0:55' AND e.date<='2024-09-11 23:0:55' 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-09-10 20:00:55' AND g.time<='2024-09-11 20:00:55' AND g.DeviceLoginName='9382' GROUP BY  g.time, g.Distance;
CountAzimuth:1163
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-10 8:0:55' AND e.date<='2024-09-11 23:0:55' 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-09-10 05:00:55' AND g.time<='2024-09-11 20:00:55' AND g.DeviceLoginName='9382' GROUP BY  g.time, g.Distance;
CountAzimuth:4602
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-09 0:20:44' AND e.date<='2024-10-09 11:20:44' 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-10-08 21:20:44' AND g.time<='2024-10-09 08:20:44' AND g.DeviceLoginName='9382' GROUP BY  g.time, g.Distance;
CountAzimuth:120
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-30 0:30:26' AND e.date<='2024-09-30 23:30:26' AND e.DeviceLoginName='352353083507225' 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-29 21:30:26' AND g.time<='2024-09-30 20:30:26' AND g.DeviceLoginName='352353083507225' GROUP BY  g.time, g.Distance;
CountAzimuth:190
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-01 0:30:26' AND e.date<='2024-10-01 23:30:26' AND e.DeviceLoginName='352353083507225' 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-30 21:30:26' AND g.time<='2024-10-01 20:30:26' AND g.DeviceLoginName='352353083507225' GROUP BY  g.time, g.Distance;
CountAzimuth:369
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-02 0:30:26' AND e.date<='2024-10-02 23:30:26' AND e.DeviceLoginName='352353083507225' 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-10-01 21:30:26' AND g.time<='2024-10-02 20:30:26' AND g.DeviceLoginName='352353083507225' GROUP BY  g.time, g.Distance;
CountAzimuth:358
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-07 0:30:26' AND e.date<='2024-10-07 23:30:26' AND e.DeviceLoginName='352353083507225' 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-10-06 21:30:26' AND g.time<='2024-10-07 20:30:26' AND g.DeviceLoginName='352353083507225' GROUP BY  g.time, g.Distance;
CountAzimuth:549
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-08 0:30:26' AND e.date<='2024-10-08 23:30:26' AND e.DeviceLoginName='352353083507225' 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-10-07 21:30:26' AND g.time<='2024-10-08 20:30:26' AND g.DeviceLoginName='352353083507225' GROUP BY  g.time, g.Distance;
CountAzimuth:308
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-09 6:57:36' AND e.date<='2024-10-09 11:57:36' AND e.DeviceLoginName='2556' 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-10-09 03:57:36' AND g.time<='2024-10-09 08:57:36' AND g.DeviceLoginName='2556' GROUP BY  g.time, g.Distance;
CountAzimuth:80
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-09 0:31:45' AND e.date<='2024-10-09 12:31:45' AND e.DeviceLoginName='355234055575019' 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-10-08 21:31:45' AND g.time<='2024-10-09 09:31:45' AND g.DeviceLoginName='355234055575019' GROUP BY  g.time, g.Distance;
CountAzimuth:601
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-09 2:30:39' AND e.date<='2024-10-09 13:30:39' AND e.DeviceLoginName='2556' 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-10-08 23:30:39' AND g.time<='2024-10-09 10:30:39' AND g.DeviceLoginName='2556' GROUP BY  g.time, g.Distance;
CountAzimuth:312
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-09 0:55:21' AND e.date<='2024-10-09 13:55:21' AND e.DeviceLoginName='2736' 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-10-08 21:55:21' AND g.time<='2024-10-09 10:55:21' AND g.DeviceLoginName='2736' GROUP BY  g.time, g.Distance;
CountAzimuth:1495
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-02 0:45:13' AND e.date<='2024-10-02 23:45:13' AND e.DeviceLoginName='358021081839700' 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-10-01 21:45:13' AND g.time<='2024-10-02 20:45:13' AND g.DeviceLoginName='358021081839700' GROUP BY  g.time, g.Distance;
CountAzimuth:1725
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-07 0:45:13' AND e.date<='2024-10-07 23:45:13' AND e.DeviceLoginName='358021081839700' 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-10-06 21:45:13' AND g.time<='2024-10-07 20:45:13' AND g.DeviceLoginName='358021081839700' GROUP BY  g.time, g.Distance;
CountAzimuth:1333
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-08 0:45:13' AND e.date<='2024-10-08 23:45:13' AND e.DeviceLoginName='358021081839700' 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-10-07 21:45:13' AND g.time<='2024-10-08 20:45:13' AND g.DeviceLoginName='358021081839700' GROUP BY  g.time, g.Distance;
CountAzimuth:1284
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-07 0:45:13' AND e.date<='2024-10-07 23:45:13' AND e.DeviceLoginName='358021081839700' 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-10-06 21:45:13' AND g.time<='2024-10-07 20:45:13' AND g.DeviceLoginName='358021081839700' GROUP BY  g.time, g.Distance;
CountAzimuth:1333