Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-04 7:41:50' AND e.date<='2024-03-05 7:41:50' 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-03-04 05:41:50' AND g.time<='2024-03-05 05:41:50' AND g.DeviceLoginName='356078111301566' GROUP BY  g.time, g.Distance;
CountAzimuth:712
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-04 7:42:13' AND e.date<='2024-03-05 7:42:13' 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-03-04 05:42:13' AND g.time<='2024-03-05 05:42:13' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:1530
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-04 7:43:2' AND e.date<='2024-03-05 7:43:2' 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-03-04 05:43:02' AND g.time<='2024-03-05 05:43:02' AND g.DeviceLoginName='2556' GROUP BY  g.time, g.Distance;
CountAzimuth:992
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-04 7:43:43' AND e.date<='2024-03-05 7:43:43' 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-03-04 05:43:43' AND g.time<='2024-03-05 05:43:43' AND g.DeviceLoginName='358021081803706' GROUP BY  g.time, g.Distance;
CountAzimuth:1055
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-03-04 22:00:00' AND g.time<='2024-03-05 06:08:56' AND g.DeviceLoginName='864866053465430'
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-03-05 05:37:57' AND TIME<='2024-03-05 05:47:57' AND DeviceLoginName='864866053465430' AND speed=0
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-03-04 22:00:00' AND e.date<='2024-03-05 06:08:56'
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-03-05 05:37:57' AND TIME<='2024-03-05 05:47:57' AND DeviceLoginName='864866053465430' AND speed=0
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-05 4:34:36' AND e.date<='2024-03-05 10:34:36' 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-03-05 02:34:36' AND g.time<='2024-03-05 08:34:36' AND g.DeviceLoginName='356078111301566' GROUP BY  g.time, g.Distance;
CountAzimuth:718
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-05 3:40:26' AND e.date<='2024-03-05 10:40:26' 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-03-05 01:40:26' AND g.time<='2024-03-05 08:40:26' AND g.DeviceLoginName='2556' GROUP BY  g.time, g.Distance;
CountAzimuth:216
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-05 0:45:11' AND e.date<='2024-03-05 10:45:11' 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-03-04 22:45:11' AND g.time<='2024-03-05 08:45:11' AND g.DeviceLoginName='2473' GROUP BY  g.time, g.Distance;
CountAzimuth:1
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-05 2:48:35' AND e.date<='2024-03-05 10:48:35' 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-03-05 00:48:35' AND g.time<='2024-03-05 08:48:35' AND g.DeviceLoginName='2473' GROUP BY  g.time, g.Distance;
CountAzimuth:1
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-05 0:49:49' AND e.date<='2024-03-05 10:49:49' AND e.DeviceLoginName='5117' 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-03-04 22:49:49' AND g.time<='2024-03-05 08:49:49' AND g.DeviceLoginName='5117' GROUP BY  g.time, g.Distance;
CountAzimuth:506
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-04 10:50:10' AND e.date<='2024-03-04 23:50:10' AND e.DeviceLoginName='5117' 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-03-04 08:50:10' AND g.time<='2024-03-04 21:50:10' AND g.DeviceLoginName='5117' GROUP BY  g.time, g.Distance;
CountAzimuth:1349
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-05 1:31:36' AND e.date<='2024-03-05 12:31:36' 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-03-04 23:31:36' AND g.time<='2024-03-05 10:31:36' AND g.DeviceLoginName='2556' GROUP BY  g.time, g.Distance;
CountAzimuth:235
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-05 3:32:9' AND e.date<='2024-03-05 12:32: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-03-05 01:32:09' AND g.time<='2024-03-05 10:32:09' AND g.DeviceLoginName='2473' GROUP BY  g.time, g.Distance;
CountAzimuth:756
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-05 9:6:41' AND e.date<='2024-03-05 15:6:41' 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-03-05 07:06:41' AND g.time<='2024-03-05 13:06:41' AND g.DeviceLoginName='2556' GROUP BY  g.time, g.Distance;
CountAzimuth:66
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-05 10:7:0' AND e.date<='2024-03-05 15:7:0' 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-03-05 08:07:00' AND g.time<='2024-03-05 13:07:00' AND g.DeviceLoginName='2473' GROUP BY  g.time, g.Distance;
CountAzimuth:1196
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-05 11:37:52' AND e.date<='2024-03-05 15:37:52' 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-03-05 09:37:52' AND g.time<='2024-03-05 13:37:52' AND g.DeviceLoginName='2556' GROUP BY  g.time, g.Distance;
CountAzimuth:1
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-05 8:38:6' AND e.date<='2024-03-05 15:38:6' 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-03-05 06:38:06' AND g.time<='2024-03-05 13:38:06' AND g.DeviceLoginName='2473' GROUP BY  g.time, g.Distance;
CountAzimuth:1294
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-05 13:39:16' AND e.date<='2024-03-05 15:39:16' AND e.DeviceLoginName='5117' 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-03-05 11:39:16' AND g.time<='2024-03-05 13:39:16' AND g.DeviceLoginName='5117' GROUP BY  g.time, g.Distance;
CountAzimuth:277