Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-26 7:23:28' AND e.date<='2024-02-26 23:23:28' 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-26 05:23:28' AND g.time<='2024-02-26 21:23:28' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:1495
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-26 7:24:46' AND e.date<='2024-02-27 7:24:46' 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-26 05:24:46' AND g.time<='2024-02-27 05:24:46' AND g.DeviceLoginName='358021081803706' GROUP BY  g.time, g.Distance;
CountAzimuth:1098
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-26 7:25:9' AND e.date<='2024-02-27 7:25:9' 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-26 05:25:09' AND g.time<='2024-02-27 05:25:09' AND g.DeviceLoginName='2556' GROUP BY  g.time, g.Distance;
CountAzimuth:247
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-26 7:25:37' AND e.date<='2024-02-27 23:25:37' 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-26 05:25:37' AND g.time<='2024-02-27 21:25:37' AND g.DeviceLoginName='2473' GROUP BY  g.time, g.Distance;
CountAzimuth:2439
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-26 5:31:12' AND e.date<='2024-02-27 23:31:12' AND e.DeviceLoginName='354836080120826' 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-26 03:31:12' AND g.time<='2024-02-27 21:31:12' AND g.DeviceLoginName='354836080120826' GROUP BY  g.time, g.Distance;
CountAzimuth:2099
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-26 7:36:13' AND e.date<='2024-02-26 23:36:13' AND e.DeviceLoginName='3075' 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-26 05:36:13' AND g.time<='2024-02-26 21:36:13' AND g.DeviceLoginName='3075' GROUP BY  g.time, g.Distance;
CountAzimuth:5104
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-27 0:20:35' AND e.date<='2024-02-27 8:20: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-02-26 22:20:35' AND g.time<='2024-02-27 06:20:35' AND g.DeviceLoginName='2473' GROUP BY  g.time, g.Distance;
CountAzimuth:40
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-26 0:29:24' AND e.date<='2024-02-26 23:29:24' AND e.DeviceLoginName='356078116474665' 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-25 22:29:24' AND g.time<='2024-02-26 21:29:24' AND g.DeviceLoginName='356078116474665' GROUP BY  g.time, g.Distance;
CountAzimuth:1036
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-27 0:43:50' AND e.date<='2024-02-27 8:43:50' 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-26 22:43:50' AND g.time<='2024-02-27 06:43:50' AND g.DeviceLoginName='2473' GROUP BY  g.time, g.Distance;
CountAzimuth:224
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-26 0:0:0' AND e.date<='2024-02-26 23:0:0' AND e.DeviceLoginName='3133' 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-25 22:00:00' AND g.time<='2024-02-26 21:00:00' AND g.DeviceLoginName='3133' GROUP BY  g.time, g.Distance;
CountAzimuth:128
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-27 0:0:0' AND e.date<='2024-02-27 23:0:0' AND e.DeviceLoginName='3133' 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-26 22:00:00' AND g.time<='2024-02-27 21:00:00' AND g.DeviceLoginName='3133' GROUP BY  g.time, g.Distance;
CountAzimuth:0
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-01 0:30:57' AND e.date<='2024-02-27 13:30:57' AND e.DeviceLoginName='352353084275186' 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:30:57' AND g.time<='2024-02-27 11:30:57' AND g.DeviceLoginName='352353084275186' GROUP BY  g.time, g.Distance;
CountAzimuth:34245
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-27 1:43:29' AND e.date<='2024-02-27 13:43:29' 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-26 23:43:29' AND g.time<='2024-02-27 11:43:29' AND g.DeviceLoginName='2473' GROUP BY  g.time, g.Distance;
CountAzimuth:245
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-27 0:44:12' AND e.date<='2024-02-27 13:44:12' 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-26 22:44:12' AND g.time<='2024-02-27 11:44:12' AND g.DeviceLoginName='3056' GROUP BY  g.time, g.Distance;
CountAzimuth:1353
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-26 22:00:00' AND g.time<='2024-02-27 11:44:49' AND g.DeviceLoginName='2594'
Method:GetStops; Query:SELECT e.date,e.EventType FROM tms_events e WHERE e.DeviceLoginName='2594' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-02-26 22:00:00' AND e.date<='2024-02-27 11:44:49'
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-02-27 11:27:50' AND TIME<='2024-02-27 11:37:50' AND DeviceLoginName='2594' AND speed=0
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-27 1:44:44' AND e.date<='2024-02-27 13:44:44' 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-26 23:44:44' AND g.time<='2024-02-27 11:44:44' AND g.DeviceLoginName='358021081803706' GROUP BY  g.time, g.Distance;
CountAzimuth:668
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-26 22:00:00' AND g.time<='2024-02-27 12:37:00' AND g.DeviceLoginName='352353084146916'
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-02-27 08:37:50' AND TIME<='2024-02-27 08:47:50' AND DeviceLoginName='352353084146916' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-02-27 09:36:52' AND TIME<='2024-02-27 09:46:52' AND DeviceLoginName='352353084146916' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-02-27 11:01:18' AND TIME<='2024-02-27 11:11:18' AND DeviceLoginName='352353084146916' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-02-27 11:24:08' AND TIME<='2024-02-27 11:34:08' AND DeviceLoginName='352353084146916' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-02-27 12:16:54' AND TIME<='2024-02-27 12:26:54' AND DeviceLoginName='352353084146916' AND speed=0
Method:GetStops; Query:SELECT e.date,e.EventType FROM tms_events e WHERE e.DeviceLoginName='352353084146916' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-02-26 22:00:00' AND e.date<='2024-02-27 12:37:00'
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-02-27 08:37:50' AND TIME<='2024-02-27 08:47:50' AND DeviceLoginName='352353084146916' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-02-27 09:36:52' AND TIME<='2024-02-27 09:46:52' AND DeviceLoginName='352353084146916' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-02-27 10:37:53' AND TIME<='2024-02-27 10:47:53' AND DeviceLoginName='352353084146916' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-02-27 11:01:18' AND TIME<='2024-02-27 11:11:18' AND DeviceLoginName='352353084146916' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-02-27 11:24:08' AND TIME<='2024-02-27 11:34:08' AND DeviceLoginName='352353084146916' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-02-27 11:58:33' AND TIME<='2024-02-27 12:08:33' AND DeviceLoginName='352353084146916' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-02-27 12:16:54' AND TIME<='2024-02-27 12:26:54' AND DeviceLoginName='352353084146916' AND speed=0
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-26 22:00:00' AND g.time<='2024-02-27 12:38:19' AND g.DeviceLoginName='2615'
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-02-27 11:50:44' AND TIME<='2024-02-27 12:00:44' AND DeviceLoginName='2615' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-02-27 12:08:05' AND TIME<='2024-02-27 12:18:05' AND DeviceLoginName='2615' AND speed=0
Method:GetStops; Query:SELECT e.date,e.EventType FROM tms_events e WHERE e.DeviceLoginName='2615' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-02-26 22:00:00' AND e.date<='2024-02-27 12:38:19'
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-02-27 11:39:24' AND TIME<='2024-02-27 11:49:24' AND DeviceLoginName='2615' AND speed=0
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-27 13:7:50' AND e.date<='2024-02-27 15:7:50' 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-27 11:07:50' AND g.time<='2024-02-27 13:07:50' AND g.DeviceLoginName='2556' GROUP BY  g.time, g.Distance;
CountAzimuth:106
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-27 13:8:24' AND e.date<='2024-02-27 15:8:24' 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-27 11:08:24' AND g.time<='2024-02-27 13:08:24' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:48
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-27 13:8:45' AND e.date<='2024-02-27 15:8:45' 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-27 11:08:45' AND g.time<='2024-02-27 13:08:45' 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-02-27 12:8:58' AND e.date<='2024-02-27 15:8:58' 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-27 10:08:58' AND g.time<='2024-02-27 13:08:58' AND g.DeviceLoginName='358021081803706' GROUP BY  g.time, g.Distance;
CountAzimuth:349
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-27 13:42:16' AND e.date<='2024-02-27 15:42:16' 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-27 11:42:16' AND g.time<='2024-02-27 13:42:16' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:48
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-27 13:42:34' AND e.date<='2024-02-27 15:42:34' 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-27 11:42:34' AND g.time<='2024-02-27 13:42:34' AND g.DeviceLoginName='2556' GROUP BY  g.time, g.Distance;
CountAzimuth:205