Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-19 0:53:28' AND e.date<='2024-02-19 23:53:28' AND e.DeviceLoginName='2496' 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-18 22:53:28' AND g.time<='2024-02-19 21:53:28' AND g.DeviceLoginName='2496' GROUP BY  g.time, g.Distance;
CountAzimuth:1343
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-20 0:53:28' AND e.date<='2024-02-20 23:53:28' AND e.DeviceLoginName='2496' 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-19 22:53:28' AND g.time<='2024-02-20 21:53:28' AND g.DeviceLoginName='2496' GROUP BY  g.time, g.Distance;
CountAzimuth:881
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-21 0:53:28' AND e.date<='2024-02-21 23:53:28' AND e.DeviceLoginName='2496' 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-20 22:53:28' AND g.time<='2024-02-21 21:53:28' AND g.DeviceLoginName='2496' GROUP BY  g.time, g.Distance;
CountAzimuth:2064
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-22 0:53:28' AND e.date<='2024-02-22 23:53:28' AND e.DeviceLoginName='2496' 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-21 22:53:28' AND g.time<='2024-02-22 21:53:28' AND g.DeviceLoginName='2496' GROUP BY  g.time, g.Distance;
CountAzimuth:84
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-21 22:00:00' AND g.time<='2024-02-22 08:15:15' AND g.DeviceLoginName='356078116474665'
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-02-22 07:37:17' AND TIME<='2024-02-22 07:47:17' AND DeviceLoginName='356078116474665' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-02-22 07:50:18' AND TIME<='2024-02-22 08:00:18' AND DeviceLoginName='356078116474665' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-02-22 07:59:44' AND TIME<='2024-02-22 08:09:44' AND DeviceLoginName='356078116474665' AND speed=0
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-02-21 22:00:00' AND e.date<='2024-02-22 08:15:15'
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-02-22 07:37:17' AND TIME<='2024-02-22 07:47:17' AND DeviceLoginName='356078116474665' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-02-22 07:50:18' AND TIME<='2024-02-22 08:00:18' AND DeviceLoginName='356078116474665' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-02-22 07:59:44' AND TIME<='2024-02-22 08:09:44' AND DeviceLoginName='356078116474665' AND speed=0
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-21 10:19:39' AND e.date<='2024-02-22 10:19:39' AND e.DeviceLoginName='2825' 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-21 08:19:39' AND g.time<='2024-02-22 08:19:39' AND g.DeviceLoginName='2825' GROUP BY  g.time, g.Distance;
CountAzimuth:4200
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-19 0:19:39' AND e.date<='2024-02-22 10:19:39' AND e.DeviceLoginName='2825' 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-18 22:19:39' AND g.time<='2024-02-22 08:19:39' AND g.DeviceLoginName='2825' GROUP BY  g.time, g.Distance;
CountAzimuth:13621
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-21 23:0:41' AND e.date<='2024-02-22 6:0:41' AND e.DeviceLoginName='4964' 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-21 21:00:41' AND g.time<='2024-02-22 04:00:41' AND g.DeviceLoginName='4964' GROUP BY  g.time, g.Distance;
CountAzimuth:725
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-22 5:31:38' AND e.date<='2024-02-22 14:31:38' 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-22 03:31:38' AND g.time<='2024-02-22 12:31:38' AND g.DeviceLoginName='358021081803706' GROUP BY  g.time, g.Distance;
CountAzimuth:572
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-22 8:32:2' AND e.date<='2024-02-22 14:32:2' 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-22 06:32:02' AND g.time<='2024-02-22 12:32:02' AND g.DeviceLoginName='2473' GROUP BY  g.time, g.Distance;
CountAzimuth:359
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-22 6:32:26' AND e.date<='2024-02-22 14:32:26' AND e.DeviceLoginName='3056' 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-22 04:32:26' AND g.time<='2024-02-22 12:32:26' AND g.DeviceLoginName='3056' GROUP BY  g.time, g.Distance;
CountAzimuth:819
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-22 4:32:45' AND e.date<='2024-02-22 14:32:45' 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-22 02:32:45' AND g.time<='2024-02-22 12:32:45' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:478
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-22 3:54:14' AND e.date<='2024-02-22 14:54:14' 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-22 01:54:14' AND g.time<='2024-02-22 12:54:14' AND g.DeviceLoginName='2473' GROUP BY  g.time, g.Distance;
CountAzimuth:405
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-22 7:54:37' AND e.date<='2024-02-22 14:54:37' 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-22 05:54:37' AND g.time<='2024-02-22 12:54:37' AND g.DeviceLoginName='358021081803706' GROUP BY  g.time, g.Distance;
CountAzimuth:453