Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-13 6:31:3' AND e.date<='2024-06-13 23:31:3' AND e.DeviceLoginName='3104' 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 03:31:03' AND g.time<='2024-06-13 20:31:03' AND g.DeviceLoginName='3104' GROUP BY  g.time, g.Distance;
CountAzimuth:0
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-13 6:31:3' AND e.date<='2024-06-13 23:31:3' AND e.DeviceLoginName='356078111469876' 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 03:31:03' AND g.time<='2024-06-13 20:31:03' AND g.DeviceLoginName='356078111469876' GROUP BY  g.time, g.Distance;
CountAzimuth:1828
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-13 6:37:6' AND e.date<='2024-06-13 23:37:6' AND e.DeviceLoginName='356078111469876' 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 03:37:06' AND g.time<='2024-06-13 20:37:06' AND g.DeviceLoginName='356078111469876' GROUP BY  g.time, g.Distance;
CountAzimuth:1828
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-12 6:37:6' AND e.date<='2024-06-12 23:37:6' AND e.DeviceLoginName='356078111469876' 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 03:37:06' AND g.time<='2024-06-12 20:37:06' AND g.DeviceLoginName='356078111469876' GROUP BY  g.time, g.Distance;
CountAzimuth:1765
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-12 6:37:6' AND e.date<='2024-06-12 23:37:6' AND e.DeviceLoginName='356078111469876' 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 03:37:06' AND g.time<='2024-06-12 20:37:06' AND g.DeviceLoginName='356078111469876' GROUP BY  g.time, g.Distance;
CountAzimuth:1765
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-17 10:57:9' AND e.date<='2024-06-21 10:57:9' AND e.DeviceLoginName='2789' 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-17 07:57:09' AND g.time<='2024-06-21 07:57:09' AND g.DeviceLoginName='2789' GROUP BY  g.time, g.Distance;
CountAzimuth:3662
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-21 5:21:34' AND e.date<='2024-06-21 11:21:34' 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-06-21 02:21:34' AND g.time<='2024-06-21 08:21:34' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:340