Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-08 0:34:49' AND e.date<='2024-04-08 23:34:49' AND e.DeviceLoginName='2504' 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:34:49' AND g.time<='2024-04-08 20:34:49' AND g.DeviceLoginName='2504' GROUP BY  g.time, g.Distance;
CountAzimuth:3248
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-08 0:36:32' AND e.date<='2024-04-08 23:36:32' AND e.DeviceLoginName='352353084656807' 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:36:32' AND g.time<='2024-04-08 20:36:32' AND g.DeviceLoginName='352353084656807' GROUP BY  g.time, g.Distance;
CountAzimuth:1884
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-08 0:54:44' AND e.date<='2024-04-08 23:54:44' AND e.DeviceLoginName='2752' 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:54:44' AND g.time<='2024-04-08 20:54:44' AND g.DeviceLoginName='2752' 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:55:53' AND e.date<='2024-04-08 23:55:53' AND e.DeviceLoginName='2962' 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:55:53' AND g.time<='2024-04-08 20:55:53' AND g.DeviceLoginName='2962' GROUP BY  g.time, g.Distance;
CountAzimuth:2957
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-01 0:41:8' AND e.date<='2024-04-01 23:41:8' AND e.DeviceLoginName='2837' 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-03-31 21:41:08' AND g.time<='2024-04-01 20:41:08' AND g.DeviceLoginName='2837' GROUP BY  g.time, g.Distance;
CountAzimuth:201
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-02 0:41:8' AND e.date<='2024-04-02 23:41:8' AND e.DeviceLoginName='2837' 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-01 21:41:08' AND g.time<='2024-04-02 20:41:08' AND g.DeviceLoginName='2837' GROUP BY  g.time, g.Distance;
CountAzimuth:2529
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-03 0:41:8' AND e.date<='2024-04-03 23:41:8' AND e.DeviceLoginName='2837' 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-02 21:41:08' AND g.time<='2024-04-03 20:41:08' AND g.DeviceLoginName='2837' GROUP BY  g.time, g.Distance;
CountAzimuth:3584
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-04 0:41:8' AND e.date<='2024-04-04 23:41:8' AND e.DeviceLoginName='2837' 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-03 21:41:08' AND g.time<='2024-04-04 20:41:08' AND g.DeviceLoginName='2837' GROUP BY  g.time, g.Distance;
CountAzimuth:3227
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-05 0:41:8' AND e.date<='2024-04-05 23:41:8' AND e.DeviceLoginName='2837' 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-04 21:41:08' AND g.time<='2024-04-05 20:41:08' AND g.DeviceLoginName='2837' GROUP BY  g.time, g.Distance;
CountAzimuth:3185
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-02 0:52:3' AND e.date<='2024-04-02 23:52:3' AND e.DeviceLoginName='9378' 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-01 21:52:03' AND g.time<='2024-04-02 20:52:03' AND g.DeviceLoginName='9378' GROUP BY  g.time, g.Distance;
CountAzimuth:2104
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-29 0:52:3' AND e.date<='2024-04-02 23:52:3' AND e.DeviceLoginName='9378' 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-03-28 21:52:03' AND g.time<='2024-04-02 20:52:03' AND g.DeviceLoginName='9378' GROUP BY  g.time, g.Distance;
CountAzimuth:5239