Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-15 0:37:21' AND e.date<='2023-12-15 23:37:21' AND e.DeviceLoginName='352353084656807' 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>='2023-12-14 22:37:21' AND g.time<='2023-12-15 21:37:21' AND g.DeviceLoginName='352353084656807' GROUP BY  g.time, g.Distance;
CountAzimuth:1669
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-15 0:38:58' AND e.date<='2023-12-15 23:38:58' AND e.DeviceLoginName='2504' 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>='2023-12-14 22:38:58' AND g.time<='2023-12-15 21:38:58' AND g.DeviceLoginName='2504' GROUP BY  g.time, g.Distance;
CountAzimuth:2624
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-15 0:41:8' AND e.date<='2023-12-15 23:41:8' AND e.DeviceLoginName='2752' 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>='2023-12-14 22:41:08' AND g.time<='2023-12-15 21:41:08' AND g.DeviceLoginName='2752' GROUP BY  g.time, g.Distance;
CountAzimuth:1380
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-18 10:26:49' AND e.date<='2023-12-19 10:26:49' AND e.DeviceLoginName='2657' 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>='2023-12-18 08:26:49' AND g.time<='2023-12-19 08:26:49' AND g.DeviceLoginName='2657' GROUP BY  g.time, g.Distance;
CountAzimuth:360
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-19 0:26:49' AND e.date<='2023-12-19 10:26:49' AND e.DeviceLoginName='2657' 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>='2023-12-18 22:26:49' AND g.time<='2023-12-19 08:26:49' AND g.DeviceLoginName='2657' GROUP BY  g.time, g.Distance;
CountAzimuth:106
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-19 0:26:49' AND e.date<='2023-12-19 10:26:49' AND e.DeviceLoginName='3133' 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>='2023-12-18 22:26:49' AND g.time<='2023-12-19 08:26:49' AND g.DeviceLoginName='3133' GROUP BY  g.time, g.Distance;
CountAzimuth:0
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-18 0:29:7' AND e.date<='2023-12-18 23:29:7' AND e.DeviceLoginName='2880' 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>='2023-12-17 22:29:07' AND g.time<='2023-12-18 21:29:07' AND g.DeviceLoginName='2880' GROUP BY  g.time, g.Distance;
CountAzimuth:3847
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-19 6:37:18' AND e.date<='2023-12-19 11:37:18' AND e.DeviceLoginName='352353083458635' 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>='2023-12-19 04:37:18' AND g.time<='2023-12-19 09:37:18' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:482
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-18 0:42:20' AND e.date<='2023-12-19 13:42:20' AND e.DeviceLoginName='356078111450124' 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>='2023-12-17 22:42:20' AND g.time<='2023-12-19 11:42:20' AND g.DeviceLoginName='356078111450124' GROUP BY  g.time, g.Distance;
CountAzimuth:4127
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-19 8:32:35' AND e.date<='2023-12-19 14:32:35' AND e.DeviceLoginName='352353083458635' 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>='2023-12-19 06:32:35' AND g.time<='2023-12-19 12:32:35' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:498
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-19 12:39:45' AND e.date<='2023-12-19 14:39:45' AND e.DeviceLoginName='352353083458635' 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>='2023-12-19 10:39:45' AND g.time<='2023-12-19 12:39:45' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:292
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-19 0:39:25' AND e.date<='2023-12-19 18:39:25' AND e.DeviceLoginName='356078111471005' 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>='2023-12-18 22:39:25' AND g.time<='2023-12-19 16:39:25' AND g.DeviceLoginName='356078111471005' GROUP BY  g.time, g.Distance;
CountAzimuth:845