Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-08 0:21:35' AND e.date<='2024-02-08 7:21: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>='2024-02-07 22:21:35' AND g.time<='2024-02-08 05:21:35' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:0
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-07 7:21:53' AND e.date<='2024-02-07 23:21:53' 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>='2024-02-07 05:21:53' AND g.time<='2024-02-07 21:21:53' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:1905
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-07 7:23:1' AND e.date<='2024-02-08 7:23:1' AND e.DeviceLoginName='358021081803706' 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>='2024-02-07 05:23:01' AND g.time<='2024-02-08 05:23:01' AND g.DeviceLoginName='358021081803706' GROUP BY  g.time, g.Distance;
CountAzimuth:1164
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-07 7:23:26' AND e.date<='2024-02-07 23:23:26' AND e.DeviceLoginName='358021081803706' 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>='2024-02-07 05:23:26' AND g.time<='2024-02-07 21:23:26' AND g.DeviceLoginName='358021081803706' GROUP BY  g.time, g.Distance;
CountAzimuth:1163
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-07 7:23:51' AND e.date<='2024-02-07 23:23:51' AND e.DeviceLoginName='2556' 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>='2024-02-07 05:23:51' AND g.time<='2024-02-07 21:23:51' AND g.DeviceLoginName='2556' GROUP BY  g.time, g.Distance;
CountAzimuth:506
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-07 7:24:26' AND e.date<='2024-02-07 23:24:26' AND e.DeviceLoginName='356078111301566' 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>='2024-02-07 05:24:26' AND g.time<='2024-02-07 21:24:26' AND g.DeviceLoginName='356078111301566' GROUP BY  g.time, g.Distance;
CountAzimuth:436
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-07 7:24:44' AND e.date<='2024-02-07 23:24:44' AND e.DeviceLoginName='2473' 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>='2024-02-07 05:24:44' AND g.time<='2024-02-07 21:24:44' AND g.DeviceLoginName='2473' GROUP BY  g.time, g.Distance;
CountAzimuth:2363
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-08 0:30:17' AND e.date<='2024-02-08 7:30:17' 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>='2024-02-07 22:30:17' AND g.time<='2024-02-08 05:30:17' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:0
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-08 5:30:35' AND e.date<='2024-02-08 7:30:35' AND e.DeviceLoginName='358021081803706' 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>='2024-02-08 03:30:35' AND g.time<='2024-02-08 05:30:35' AND g.DeviceLoginName='358021081803706' GROUP BY  g.time, g.Distance;
CountAzimuth:1
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-08 0:31:24' AND e.date<='2024-02-08 8:31:24' AND e.DeviceLoginName='2473' 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>='2024-02-07 22:31:24' AND g.time<='2024-02-08 06:31:24' AND g.DeviceLoginName='2473' GROUP BY  g.time, g.Distance;
CountAzimuth:11
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude FROM  tms_gpsdata_fixed g WHERE g.time>='2024-02-07 22:00:00' AND g.time<='2024-02-08 07:34:47' AND g.DeviceLoginName='355234055558247'
Method:GetStops; Query:SELECT e.date,e.EventType FROM tms_events e WHERE e.DeviceLoginName='355234055558247' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-02-07 22:00:00' AND e.date<='2024-02-08 07:34:47'
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-08 0:45:9' AND e.date<='2024-02-08 9:45:9' AND e.DeviceLoginName='2473' 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>='2024-02-07 22:45:09' AND g.time<='2024-02-08 07:45:09' AND g.DeviceLoginName='2473' GROUP BY  g.time, g.Distance;
CountAzimuth:283
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-07 0:25:24' AND e.date<='2024-02-08 23:25:24' AND e.DeviceLoginName='355234055581363' 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>='2024-02-06 22:25:24' AND g.time<='2024-02-08 21:25:24' AND g.DeviceLoginName='355234055581363' GROUP BY  g.time, g.Distance;
CountAzimuth:1185
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-05 7:1:13' AND e.date<='2024-02-08 11:1:13' AND e.DeviceLoginName='2874' 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>='2024-02-05 05:01:13' AND g.time<='2024-02-08 09:01:13' AND g.DeviceLoginName='2874' GROUP BY  g.time, g.Distance;
CountAzimuth:4385
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-05 0:23:22' AND e.date<='2024-02-05 23:23:22' AND e.DeviceLoginName='2486' 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>='2024-02-04 22:23:22' AND g.time<='2024-02-05 21:23:22' AND g.DeviceLoginName='2486' GROUP BY  g.time, g.Distance;
CountAzimuth:1657
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-08 0:26:21' AND e.date<='2024-02-08 12:26:21' 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>='2024-02-07 22:26:21' AND g.time<='2024-02-08 10:26:21' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:1
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-31 0:10:58' AND e.date<='2024-01-31 23:10:58' AND e.DeviceLoginName='2461' 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>='2024-01-30 22:10:58' AND g.time<='2024-01-31 21:10:58' AND g.DeviceLoginName='2461' GROUP BY  g.time, g.Distance;
CountAzimuth:1486
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-01 0:10:58' AND e.date<='2024-02-02 23:10:58' AND e.DeviceLoginName='2461' 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>='2024-01-31 22:10:58' AND g.time<='2024-02-02 21:10:58' AND g.DeviceLoginName='2461' GROUP BY  g.time, g.Distance;
CountAzimuth:4
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-05 0:10:58' AND e.date<='2024-02-05 23:10:58' AND e.DeviceLoginName='2461' 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>='2024-02-04 22:10:58' AND g.time<='2024-02-05 21:10:58' AND g.DeviceLoginName='2461' GROUP BY  g.time, g.Distance;
CountAzimuth:1781
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-08 3:33:55' AND e.date<='2024-02-08 13:33:55' 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>='2024-02-08 01:33:55' AND g.time<='2024-02-08 11:33:55' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:1
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-08 6:34:15' AND e.date<='2024-02-08 13:34:15' AND e.DeviceLoginName='2556' 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>='2024-02-08 04:34:15' AND g.time<='2024-02-08 11:34:15' AND g.DeviceLoginName='2556' GROUP BY  g.time, g.Distance;
CountAzimuth:60
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-08 1:39:23' AND e.date<='2024-02-08 13:39:23' AND e.DeviceLoginName='2556' 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>='2024-02-07 23:39:23' AND g.time<='2024-02-08 11:39:23' AND g.DeviceLoginName='2556' GROUP BY  g.time, g.Distance;
CountAzimuth:171
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-07 5:39:54' AND e.date<='2024-02-07 23:39:54' 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>='2024-02-07 03:39:54' AND g.time<='2024-02-07 21:39:54' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:2263
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-08 1:44:40' AND e.date<='2024-02-08 13:44:40' 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>='2024-02-07 23:44:40' AND g.time<='2024-02-08 11:44:40' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:1
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-08 3:44:56' AND e.date<='2024-02-08 13:44:56' AND e.DeviceLoginName='2556' 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>='2024-02-08 01:44:56' AND g.time<='2024-02-08 11:44:56' AND g.DeviceLoginName='2556' GROUP BY  g.time, g.Distance;
CountAzimuth:165
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-08 5:45:15' AND e.date<='2024-02-08 13:45:15' AND e.DeviceLoginName='2473' 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>='2024-02-08 03:45:15' AND g.time<='2024-02-08 11:45:15' AND g.DeviceLoginName='2473' GROUP BY  g.time, g.Distance;
CountAzimuth:1032