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-05-13 21:00:00' AND g.time<='2024-05-14 05:54:11' AND g.DeviceLoginName='356078116474665'
Method:GetStops; Query:SELECT e.date,e.EventType FROM tms_events e WHERE e.DeviceLoginName='356078116474665' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-05-13 21:00:00' AND e.date<='2024-05-14 05:54:11'
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-05-13 21:00:00' AND g.time<='2024-05-14 05:55:40' AND g.DeviceLoginName='3206'
Method:GetStops; Query:SELECT e.date,e.EventType FROM tms_events e WHERE e.DeviceLoginName='3206' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-05-13 21:00:00' AND e.date<='2024-05-14 05:55:40'
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-29 0:31:6' AND e.date<='2024-05-12 23:31:6' AND e.DeviceLoginName='352353086131585' 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-28 21:31:06' AND g.time<='2024-05-12 20:31:06' AND g.DeviceLoginName='352353086131585' GROUP BY  g.time, g.Distance;
CountAzimuth:5898
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-05-24 0:31:6' AND e.date<='2024-05-24 23:31:6' AND e.DeviceLoginName='AI5164' 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-05-23 21:31:06' AND g.time<='2024-05-24 20:31:06' AND g.DeviceLoginName='AI5164' GROUP BY  g.time, g.Distance;
CountAzimuth:0
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-05-13 21:00:00' AND g.time<='2024-05-14 07:34:15' AND g.DeviceLoginName='352353083473741'
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-05-14 05:13:22' AND TIME<='2024-05-14 05:23:22' AND DeviceLoginName='352353083473741' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-05-14 06:34:05' AND TIME<='2024-05-14 06:44:05' AND DeviceLoginName='352353083473741' AND speed=0
Method:GetStops; Query:SELECT e.date,e.EventType FROM tms_events e WHERE e.DeviceLoginName='352353083473741' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-05-13 21:00:00' AND e.date<='2024-05-14 07:34:15'
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-05-14 05:13:22' AND TIME<='2024-05-14 05:23:22' AND DeviceLoginName='352353083473741' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-05-14 06:34:05' AND TIME<='2024-05-14 06:44:05' AND DeviceLoginName='352353083473741' AND speed=0
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-05-10 0:31:6' AND e.date<='2024-05-10 23:31:6' AND e.DeviceLoginName='AI5164' 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-05-09 21:31:06' AND g.time<='2024-05-10 20:31:06' AND g.DeviceLoginName='AI5164' GROUP BY  g.time, g.Distance;
CountAzimuth:0
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-05-10 0:31:6' AND e.date<='2024-05-10 23:31:6' AND e.DeviceLoginName='354836080091142' 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-05-09 21:31:06' AND g.time<='2024-05-10 20:31:06' AND g.DeviceLoginName='354836080091142' GROUP BY  g.time, g.Distance;
CountAzimuth:1455
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-05-06 0:36:46' AND e.date<='2024-05-10 23:36:46' AND e.DeviceLoginName='3068' 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-05-05 21:36:46' AND g.time<='2024-05-10 20:36:46' AND g.DeviceLoginName='3068' GROUP BY  g.time, g.Distance;
CountAzimuth:5743
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-05-14 0:17:52' AND e.date<='2024-05-14 11:17:52' 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-05-13 21:17:52' AND g.time<='2024-05-14 08:17:52' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:484
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-05-14 1:19:27' AND e.date<='2024-05-14 11:19: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-05-13 22:19:27' AND g.time<='2024-05-14 08:19:27' AND g.DeviceLoginName='2556' GROUP BY  g.time, g.Distance;
CountAzimuth:108
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-05-13 21:00:00' AND g.time<='2024-05-14 11:10:31' AND g.DeviceLoginName='9005'
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-05-14 10:31:55' AND TIME<='2024-05-14 10:41:55' AND DeviceLoginName='9005' AND speed=0
Method:GetStops; Query:SELECT e.date,e.EventType FROM tms_events e WHERE e.DeviceLoginName='9005' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-05-13 21:00:00' AND e.date<='2024-05-14 11:10:31'
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-05-14 1:23:9' AND e.date<='2024-05-14 14:23:9' AND e.DeviceLoginName='356078111301566' 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-05-13 22:23:09' AND g.time<='2024-05-14 11:23:09' AND g.DeviceLoginName='356078111301566' GROUP BY  g.time, g.Distance;
CountAzimuth:59
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-05-14 0:46:34' AND e.date<='2024-05-14 14:46:34' 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-05-13 21:46:34' AND g.time<='2024-05-14 11:46:34' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:489
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-05-14 5:47:0' AND e.date<='2024-05-14 14:47:0' AND e.DeviceLoginName='2516' 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-05-14 02:47:00' AND g.time<='2024-05-14 11:47:00' AND g.DeviceLoginName='2516' GROUP BY  g.time, g.Distance;
CountAzimuth:425
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-05-14 0:7:51' AND e.date<='2024-05-14 15:7:51' 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-05-13 21:07:51' AND g.time<='2024-05-14 12:07:51' AND g.DeviceLoginName='354836080167561' GROUP BY  g.time, g.Distance;
CountAzimuth:733
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-05-13 15:14:3' AND e.date<='2024-05-14 15:14:3' AND e.DeviceLoginName='4865' 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-05-13 12:14:03' AND g.time<='2024-05-14 12:14:03' AND g.DeviceLoginName='4865' GROUP BY  g.time, g.Distance;
CountAzimuth:3677
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-05-13 0:44:11' AND e.date<='2024-05-13 23:44:11' 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-05-12 21:44:11' AND g.time<='2024-05-13 20:44:11' AND g.DeviceLoginName='354836080167561' GROUP BY  g.time, g.Distance;
CountAzimuth:1542
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-05-14 6:56:29' AND e.date<='2024-05-14 15:56:29' AND e.DeviceLoginName='2516' 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-05-14 03:56:29' AND g.time<='2024-05-14 12:56:29' AND g.DeviceLoginName='2516' GROUP BY  g.time, g.Distance;
CountAzimuth:444