Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-30 18:17:13' AND e.date<='2024-10-31 23:59:13' AND e.DeviceLoginName='354836080274714' 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-10-30 16:17:13' AND g.time<='2024-10-31 21:59:13' AND g.DeviceLoginName='354836080274714' GROUP BY  g.time, g.Distance;
CountAzimuth:4
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-31 0:0:27' AND e.date<='2024-10-31 9:0:27' AND e.DeviceLoginName='2494' 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-10-30 22:00:27' AND g.time<='2024-10-31 07:00:27' AND g.DeviceLoginName='2494' GROUP BY  g.time, g.Distance;
CountAzimuth:203
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-30 0:21:53' AND e.date<='2024-10-31 10:21:53' AND e.DeviceLoginName='352353084144218' 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-10-29 22:21:53' AND g.time<='2024-10-31 08:21:53' AND g.DeviceLoginName='352353084144218' GROUP BY  g.time, g.Distance;
CountAzimuth:1750
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-29 0:21:53' AND e.date<='2024-10-29 23:21:53' AND e.DeviceLoginName='352353084144218' 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-10-28 22:21:53' AND g.time<='2024-10-29 21:21:53' AND g.DeviceLoginName='352353084144218' GROUP BY  g.time, g.Distance;
CountAzimuth:145
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-12 0:21:8' AND e.date<='2024-10-13 23:21:8' AND e.DeviceLoginName='354836080173346' 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-10-11 22:21:08' AND g.time<='2024-10-13 21:21:08' AND g.DeviceLoginName='354836080173346' GROUP BY  g.time, g.Distance;
CountAzimuth:1239
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-10-30 22:00:00' AND g.time<='2024-10-31 10:33:51' AND g.DeviceLoginName='3139'
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-10-31 10:14:20' AND TIME<='2024-10-31 10:24:20' AND DeviceLoginName='3139' AND speed=0
Method:GetStops; Query:SELECT e.date,e.EventType FROM tms_events e WHERE e.DeviceLoginName='3139' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-30 22:00:00' AND e.date<='2024-10-31 10:33:51'
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-10-31 10:14:20' AND TIME<='2024-10-31 10:24:20' AND DeviceLoginName='3139' 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-10-30 22:00:00' AND g.time<='2024-10-31 10:57:51' AND g.DeviceLoginName='3139'
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-10-31 10:14:20' AND TIME<='2024-10-31 10:24:20' AND DeviceLoginName='3139' AND speed=0
Method:GetStops; Query:SELECT e.date,e.EventType FROM tms_events e WHERE e.DeviceLoginName='3139' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-30 22:00:00' AND e.date<='2024-10-31 10:57:51'
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-10-31 10:14:20' AND TIME<='2024-10-31 10:24:20' AND DeviceLoginName='3139' 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-10-30 22:00:00' AND g.time<='2024-10-31 11:43:53' AND g.DeviceLoginName='2533'
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-10-31 05:25:09' AND TIME<='2024-10-31 05:35:09' AND DeviceLoginName='2533' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-10-31 06:55:39' AND TIME<='2024-10-31 07:05:39' AND DeviceLoginName='2533' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-10-31 07:12:39' AND TIME<='2024-10-31 07:22:39' AND DeviceLoginName='2533' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-10-31 07:22:24' AND TIME<='2024-10-31 07:32:24' AND DeviceLoginName='2533' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-10-31 07:52:09' AND TIME<='2024-10-31 08:02:09' AND DeviceLoginName='2533' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-10-31 09:13:39' AND TIME<='2024-10-31 09:23:39' AND DeviceLoginName='2533' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-10-31 09:34:09' AND TIME<='2024-10-31 09:44:09' AND DeviceLoginName='2533' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-10-31 10:26:54' AND TIME<='2024-10-31 10:36:54' AND DeviceLoginName='2533' AND speed=0
Method:GetStops; Query:SELECT e.date,e.EventType FROM tms_events e WHERE e.DeviceLoginName='2533' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-30 22:00:00' AND e.date<='2024-10-31 11:43:53'
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-10-31 05:25:09' AND TIME<='2024-10-31 05:35:09' AND DeviceLoginName='2533' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-10-31 06:51:09' AND TIME<='2024-10-31 07:01:09' AND DeviceLoginName='2533' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-10-31 06:55:39' AND TIME<='2024-10-31 07:05:39' AND DeviceLoginName='2533' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-10-31 07:05:09' AND TIME<='2024-10-31 07:15:09' AND DeviceLoginName='2533' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-10-31 07:12:39' AND TIME<='2024-10-31 07:22:39' AND DeviceLoginName='2533' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-10-31 07:22:24' AND TIME<='2024-10-31 07:32:24' AND DeviceLoginName='2533' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-10-31 07:52:09' AND TIME<='2024-10-31 08:02:09' AND DeviceLoginName='2533' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-10-31 09:13:39' AND TIME<='2024-10-31 09:23:39' AND DeviceLoginName='2533' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-10-31 09:34:09' AND TIME<='2024-10-31 09:44:09' AND DeviceLoginName='2533' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-10-31 10:26:54' AND TIME<='2024-10-31 10:36:54' AND DeviceLoginName='2533' 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-10-30 22:00:00' AND g.time<='2024-10-31 11:45:56' AND g.DeviceLoginName='2533'
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-10-31 05:25:09' AND TIME<='2024-10-31 05:35:09' AND DeviceLoginName='2533' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-10-31 06:55:39' AND TIME<='2024-10-31 07:05:39' AND DeviceLoginName='2533' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-10-31 07:12:39' AND TIME<='2024-10-31 07:22:39' AND DeviceLoginName='2533' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-10-31 07:22:24' AND TIME<='2024-10-31 07:32:24' AND DeviceLoginName='2533' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-10-31 07:52:09' AND TIME<='2024-10-31 08:02:09' AND DeviceLoginName='2533' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-10-31 09:13:39' AND TIME<='2024-10-31 09:23:39' AND DeviceLoginName='2533' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-10-31 09:34:09' AND TIME<='2024-10-31 09:44:09' AND DeviceLoginName='2533' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-10-31 10:26:54' AND TIME<='2024-10-31 10:36:54' AND DeviceLoginName='2533' AND speed=0
Method:GetStops; Query:SELECT e.date,e.EventType FROM tms_events e WHERE e.DeviceLoginName='2533' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-30 22:00:00' AND e.date<='2024-10-31 11:45:56'
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-10-31 05:25:09' AND TIME<='2024-10-31 05:35:09' AND DeviceLoginName='2533' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-10-31 06:51:09' AND TIME<='2024-10-31 07:01:09' AND DeviceLoginName='2533' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-10-31 06:55:39' AND TIME<='2024-10-31 07:05:39' AND DeviceLoginName='2533' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-10-31 07:05:09' AND TIME<='2024-10-31 07:15:09' AND DeviceLoginName='2533' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-10-31 07:12:39' AND TIME<='2024-10-31 07:22:39' AND DeviceLoginName='2533' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-10-31 07:22:24' AND TIME<='2024-10-31 07:32:24' AND DeviceLoginName='2533' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-10-31 07:52:09' AND TIME<='2024-10-31 08:02:09' AND DeviceLoginName='2533' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-10-31 09:13:39' AND TIME<='2024-10-31 09:23:39' AND DeviceLoginName='2533' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-10-31 09:34:09' AND TIME<='2024-10-31 09:44:09' AND DeviceLoginName='2533' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-10-31 10:26:54' AND TIME<='2024-10-31 10:36:54' AND DeviceLoginName='2533' AND speed=0