Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-03 5:59:46' AND e.date<='2024-04-03 7:59:46' AND e.DeviceLoginName='358021081803706' 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 02:59:46' AND g.time<='2024-04-03 04:59:46' AND g.DeviceLoginName='358021081803706' GROUP BY  g.time, g.Distance;
CountAzimuth:202
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-02 8:0:12' AND e.date<='2024-04-03 8:0: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-02 05:00:12' AND g.time<='2024-04-03 05:00:12' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:989
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-03 0:0:44' AND e.date<='2024-04-03 8:0:44' 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-04-02 21:00:44' AND g.time<='2024-04-03 05:00:44' AND g.DeviceLoginName='2556' GROUP BY  g.time, g.Distance;
CountAzimuth:147
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-02 0:24:11' AND e.date<='2024-04-02 23:24:11' 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-01 21:24:11' AND g.time<='2024-04-02 20:24:11' AND g.DeviceLoginName='352353084656807' GROUP BY  g.time, g.Distance;
CountAzimuth:2903
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-01 0:27:0' AND e.date<='2024-04-01 23:27:0' AND e.DeviceLoginName='3028' 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:27:00' AND g.time<='2024-04-01 20:27:00' AND g.DeviceLoginName='3028' GROUP BY  g.time, g.Distance;
CountAzimuth:2702
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-01 0:40:34' AND e.date<='2024-04-01 23:40:34' 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-03-31 21:40:34' AND g.time<='2024-04-01 20:40:34' AND g.DeviceLoginName='2504' GROUP BY  g.time, g.Distance;
CountAzimuth:1342
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-01 0:42:39' AND e.date<='2024-04-01 23:42:39' 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-03-31 21:42:39' AND g.time<='2024-04-01 20:42:39' AND g.DeviceLoginName='352353084656807' GROUP BY  g.time, g.Distance;
CountAzimuth:1957
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-01 0:43:47' AND e.date<='2024-04-01 23:43:47' 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-03-31 21:43:47' AND g.time<='2024-04-01 20:43:47' AND g.DeviceLoginName='2752' GROUP BY  g.time, g.Distance;
CountAzimuth:979
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-01 0:45:2' AND e.date<='2024-04-01 23:45:2' 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-03-31 21:45:02' AND g.time<='2024-04-01 20:45:02' AND g.DeviceLoginName='2962' GROUP BY  g.time, g.Distance;
CountAzimuth:2605