Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-20 4:31:19' AND e.date<='2024-09-20 7:31:19' 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-09-20 01:31:19' AND g.time<='2024-09-20 04:31:19' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:237
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-19 7:32:36' AND e.date<='2024-09-19 23:32:36' 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-09-19 04:32:36' AND g.time<='2024-09-19 20:32:36' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:1473
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-19 7:35:10' AND e.date<='2024-09-19 23:35:10' 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-09-19 04:35:10' AND g.time<='2024-09-19 20:35:10' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:1473
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-19 5:25:21' AND e.date<='2024-09-19 23:25:21' AND e.DeviceLoginName='354836080167561' 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-19 02:25:21' AND g.time<='2024-09-19 20:25:21' AND g.DeviceLoginName='354836080167561' GROUP BY  g.time, g.Distance;
CountAzimuth:380
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-19 8:26:33' AND e.date<='2024-09-19 23:26:33' AND e.DeviceLoginName='356078116278207' 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-19 05:26:33' AND g.time<='2024-09-19 20:26:33' AND g.DeviceLoginName='356078116278207' GROUP BY  g.time, g.Distance;
CountAzimuth:1673
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-20 6:26:55' AND e.date<='2024-09-20 8:26:55' 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-09-20 03:26:55' AND g.time<='2024-09-20 05:26:55' AND g.DeviceLoginName='2556' GROUP BY  g.time, g.Distance;
CountAzimuth:101
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-19 8:27:27' AND e.date<='2024-09-19 23:27:27' 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-09-19 05:27:27' AND g.time<='2024-09-19 20:27:27' AND g.DeviceLoginName='2556' GROUP BY  g.time, g.Distance;
CountAzimuth:1031
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude FROM  tms_gpsdata_fixed g WHERE g.time>='2024-09-19 21:00:00' AND g.time<='2024-09-20 06:24:49' AND g.DeviceLoginName='864866053465430'
Method:GetStops; Query:SELECT e.date,e.EventType FROM tms_events e WHERE e.DeviceLoginName='864866053465430' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-09-19 21:00:00' AND e.date<='2024-09-20 06:24:49'
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-19 10:12:56' AND e.date<='2024-09-20 10:12:56' AND e.DeviceLoginName='3081' 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-19 07:12:56' AND g.time<='2024-09-20 07:12:56' AND g.DeviceLoginName='3081' GROUP BY  g.time, g.Distance;
CountAzimuth:9
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-01 10:20:52' AND e.date<='2024-09-20 10:20:52' AND e.DeviceLoginName='2790' 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-01 07:20:52' AND g.time<='2024-09-20 07:20:52' AND g.DeviceLoginName='2790' GROUP BY  g.time, g.Distance;
CountAzimuth:9500
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-19 10:31:26' AND e.date<='2024-09-20 10:31:26' AND e.DeviceLoginName='2790' 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-19 07:31:26' AND g.time<='2024-09-20 07:31:26' AND g.DeviceLoginName='2790' GROUP BY  g.time, g.Distance;
CountAzimuth:615
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-02 0:31:26' AND e.date<='2024-09-02 23:31:26' AND e.DeviceLoginName='2790' 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-01 21:31:26' AND g.time<='2024-09-02 20:31:26' AND g.DeviceLoginName='2790' GROUP BY  g.time, g.Distance;
CountAzimuth:380
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-03 0:31:26' AND e.date<='2024-09-03 23:31:26' AND e.DeviceLoginName='2790' 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-02 21:31:26' AND g.time<='2024-09-03 20:31:26' AND g.DeviceLoginName='2790' GROUP BY  g.time, g.Distance;
CountAzimuth:668
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-01 10:20:52' AND e.date<='2024-09-20 10:20:52' 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-09-01 07:20:52' AND g.time<='2024-09-20 07:20:52' AND g.DeviceLoginName='355234055575019' GROUP BY  g.time, g.Distance;
CountAzimuth:3680
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-20 0:17:29' AND e.date<='2024-09-20 14:17:29' AND e.DeviceLoginName='2590' 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-19 21:17:29' AND g.time<='2024-09-20 11:17:29' AND g.DeviceLoginName='2590' GROUP BY  g.time, g.Distance;
CountAzimuth:1062
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-20 0:17:29' AND e.date<='2024-09-20 14:17:29' AND e.DeviceLoginName='2590' 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-19 21:17:29' AND g.time<='2024-09-20 11:17:29' AND g.DeviceLoginName='2590' GROUP BY  g.time, g.Distance;
CountAzimuth:1065
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-20 0:22:20' AND e.date<='2024-09-20 14:22:20' AND e.DeviceLoginName='3059' 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-19 21:22:20' AND g.time<='2024-09-20 11:22:20' AND g.DeviceLoginName='3059' GROUP BY  g.time, g.Distance;
CountAzimuth:1982
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-09 0:22:20' AND e.date<='2024-09-09 23:22:20' AND e.DeviceLoginName='3059' 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-08 21:22:20' AND g.time<='2024-09-09 20:22:20' AND g.DeviceLoginName='3059' GROUP BY  g.time, g.Distance;
CountAzimuth:978
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-10 0:22:20' AND e.date<='2024-09-10 23:22:20' AND e.DeviceLoginName='3059' 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-09 21:22:20' AND g.time<='2024-09-10 20:22:20' AND g.DeviceLoginName='3059' GROUP BY  g.time, g.Distance;
CountAzimuth:900
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-11 0:22:20' AND e.date<='2024-09-11 23:22:20' AND e.DeviceLoginName='3059' 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 21:22:20' AND g.time<='2024-09-11 20:22:20' AND g.DeviceLoginName='3059' GROUP BY  g.time, g.Distance;
CountAzimuth:875
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-19 14:35:41' AND e.date<='2024-09-20 14:35:41' AND e.DeviceLoginName='356078111471005' 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-08-19 11:35:41' AND g.time<='2024-09-20 11:35:41' AND g.DeviceLoginName='356078111471005' GROUP BY  g.time, g.Distance;
CountAzimuth:5873