Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-24 0:49:29' AND e.date<='2024-04-24 7:49:29' 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-04-23 21:49:29' AND g.time<='2024-04-24 04:49:29' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:351
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-24 0:4:21' AND e.date<='2024-04-24 8:4:21' 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-04-23 21:04:21' AND g.time<='2024-04-24 05:04:21' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:351
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-19 0:31:57' AND e.date<='2024-04-19 23:31:57' AND e.DeviceLoginName='352353084656807' 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-18 21:31:57' AND g.time<='2024-04-19 20:31:57' AND g.DeviceLoginName='352353084656807' GROUP BY  g.time, g.Distance;
CountAzimuth:1947
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-19 0:36:27' AND e.date<='2024-04-19 23:36:27' AND e.DeviceLoginName='2962' 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-18 21:36:27' AND g.time<='2024-04-19 20:36:27' AND g.DeviceLoginName='2962' GROUP BY  g.time, g.Distance;
CountAzimuth:4048
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-24 0:33:39' AND e.date<='2024-04-24 10:33:39' 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-04-23 21:33:39' AND g.time<='2024-04-24 07:33:39' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:463
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-24 0:5:23' AND e.date<='2024-04-24 11:5:23' 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-04-23 21:05:23' AND g.time<='2024-04-24 08:05:23' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:661
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-04-23 21:00:00' AND g.time<='2024-04-24 08:16:28' AND g.DeviceLoginName='3044'
Method:GetStops; Query:SELECT e.date,e.EventType FROM tms_events e WHERE e.DeviceLoginName='3044' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-04-23 21:00:00' AND e.date<='2024-04-24 08:16:28'
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-04-23 21:00:00' AND g.time<='2024-04-24 08:16:41' AND g.DeviceLoginName='3044'
Method:GetStops; Query:SELECT e.date,e.EventType FROM tms_events e WHERE e.DeviceLoginName='3044' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-04-23 21:00:00' AND e.date<='2024-04-24 08:16:41'
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-04-23 21:00:00' AND g.time<='2024-04-24 08:17:06' AND g.DeviceLoginName='3044'
Method:GetStops; Query:SELECT e.date,e.EventType FROM tms_events e WHERE e.DeviceLoginName='3044' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-04-23 21:00:00' AND e.date<='2024-04-24 08:17:06'
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-04-23 21:00:00' AND g.time<='2024-04-24 08:17:27' AND g.DeviceLoginName='352353086184048'
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-04-24 04:40:53' AND TIME<='2024-04-24 04:50:53' AND DeviceLoginName='352353086184048' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-04-24 05:13:24' AND TIME<='2024-04-24 05:23:24' AND DeviceLoginName='352353086184048' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-04-24 06:46:59' AND TIME<='2024-04-24 06:56:59' AND DeviceLoginName='352353086184048' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-04-24 07:20:14' AND TIME<='2024-04-24 07:30:14' AND DeviceLoginName='352353086184048' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-04-24 07:51:55' AND TIME<='2024-04-24 08:01:55' AND DeviceLoginName='352353086184048' AND speed=0
Method:GetStops; Query:SELECT e.date,e.EventType FROM tms_events e WHERE e.DeviceLoginName='352353086184048' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-04-23 21:00:00' AND e.date<='2024-04-24 08:17:27'
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-04-24 04:40:53' AND TIME<='2024-04-24 04:50:53' AND DeviceLoginName='352353086184048' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-04-24 05:13:24' AND TIME<='2024-04-24 05:23:24' AND DeviceLoginName='352353086184048' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-04-24 06:26:17' AND TIME<='2024-04-24 06:36:17' AND DeviceLoginName='352353086184048' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-04-24 06:46:59' AND TIME<='2024-04-24 06:56:59' AND DeviceLoginName='352353086184048' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-04-24 07:20:14' AND TIME<='2024-04-24 07:30:14' AND DeviceLoginName='352353086184048' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-04-24 07:51:55' AND TIME<='2024-04-24 08:01:55' AND DeviceLoginName='352353086184048' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-04-24 08:03:11' AND TIME<='2024-04-24 08:13:11' AND DeviceLoginName='352353086184048' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-04-24 08:08:19' AND TIME<='2024-04-24 08:18:19' AND DeviceLoginName='352353086184048' AND speed=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-04-23 21:00:00' AND g.time<='2024-04-24 08:17:38' AND g.DeviceLoginName='3044'
Method:GetStops; Query:SELECT e.date,e.EventType FROM tms_events e WHERE e.DeviceLoginName='3044' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-04-23 21:00:00' AND e.date<='2024-04-24 08:17:38'
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-23 0:17:56' AND e.date<='2024-04-23 23:17:56' AND e.DeviceLoginName='3044' 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-22 21:17:56' AND g.time<='2024-04-23 20:17:56' AND g.DeviceLoginName='3044' 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-04-23 21:00:00' AND g.time<='2024-04-24 08:18:37' AND g.DeviceLoginName='3044'
Method:GetStops; Query:SELECT e.date,e.EventType FROM tms_events e WHERE e.DeviceLoginName='3044' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-04-23 21:00:00' AND e.date<='2024-04-24 08:18:37'
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-04-23 21:00:00' AND g.time<='2024-04-24 08:19:35' AND g.DeviceLoginName='3044'
Method:GetStops; Query:SELECT e.date,e.EventType FROM tms_events e WHERE e.DeviceLoginName='3044' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-04-23 21:00:00' AND e.date<='2024-04-24 08:19:35'
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-21 0:43:7' AND e.date<='2024-04-21 23:43:7' AND e.DeviceLoginName='3081' 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-20 21:43:07' AND g.time<='2024-04-21 20:43:07' AND g.DeviceLoginName='3081' GROUP BY  g.time, g.Distance;
CountAzimuth:2744
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-24 1:9:8' AND e.date<='2024-04-24 12:9:8' 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-04-23 22:09:08' AND g.time<='2024-04-24 09:09:08' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:661
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-23 0:46:48' AND e.date<='2024-04-23 23:46:48' AND e.DeviceLoginName='3122' 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-22 21:46:48' AND g.time<='2024-04-23 20:46:48' AND g.DeviceLoginName='3122' GROUP BY  g.time, g.Distance;
CountAzimuth:1652
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-22 0:50:9' AND e.date<='2024-04-22 23:50:9' AND e.DeviceLoginName='3122' 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-21 21:50:09' AND g.time<='2024-04-22 20:50:09' AND g.DeviceLoginName='3122' GROUP BY  g.time, g.Distance;
CountAzimuth:3031
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-24 8:3:57' AND e.date<='2024-04-24 15:3:57' AND e.DeviceLoginName='2473' 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-24 05:03:57' AND g.time<='2024-04-24 12:03:57' AND g.DeviceLoginName='2473' GROUP BY  g.time, g.Distance;
CountAzimuth:802
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-24 10:36:22' AND e.date<='2024-04-24 15:36:22' AND e.DeviceLoginName='2473' 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-24 07:36:22' AND g.time<='2024-04-24 12:36:22' AND g.DeviceLoginName='2473' GROUP BY  g.time, g.Distance;
CountAzimuth:602