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-11-07 22:00:00' AND g.time<='2024-11-08 05:57:59' AND g.DeviceLoginName='2875'
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-11-08 01:15:16' AND TIME<='2024-11-08 01:25:16' AND DeviceLoginName='2875' AND speed=0
Method:GetStops; Query:SELECT e.date,e.EventType FROM tms_events e WHERE e.DeviceLoginName='2875' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-07 22:00:00' AND e.date<='2024-11-08 05:57:59'
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-08 1:11:20' AND e.date<='2024-11-08 8:11:20' 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-11-07 23:11:20' AND g.time<='2024-11-08 06:11:20' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:318
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-07 8:11:41' AND e.date<='2024-11-07 23:11:41' 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-11-07 06:11:41' AND g.time<='2024-11-07 21:11:41' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:918
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-11-07 22:00:00' AND g.time<='2024-11-08 07:14:50' AND g.DeviceLoginName='2875'
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-11-08 01:15:16' AND TIME<='2024-11-08 01:25:16' AND DeviceLoginName='2875' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-11-08 02:24:02' AND TIME<='2024-11-08 02:34:02' AND DeviceLoginName='2875' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-11-08 06:37:57' AND TIME<='2024-11-08 06:47:57' AND DeviceLoginName='2875' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-11-08 06:49:49' AND TIME<='2024-11-08 06:59:49' AND DeviceLoginName='2875' AND speed=0
Method:GetStops; Query:SELECT e.date,e.EventType FROM tms_events e WHERE e.DeviceLoginName='2875' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-07 22:00:00' AND e.date<='2024-11-08 07:14:50'
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-11-08 06:03:34' AND TIME<='2024-11-08 06:13:34' AND DeviceLoginName='2875' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-11-08 06:37:57' AND TIME<='2024-11-08 06:47:57' AND DeviceLoginName='2875' AND speed=0
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-07 9:0:0' AND e.date<='2024-11-07 23:59:59' AND e.DeviceLoginName='2620' 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-11-07 07:00:00' AND g.time<='2024-11-07 21:59:59' AND g.DeviceLoginName='2620' GROUP BY  g.time, g.Distance;
CountAzimuth:427
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-04 23:0:0' AND e.date<='2024-11-05 5:0:0' AND e.DeviceLoginName='2677' 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-11-04 21:00:00' AND g.time<='2024-11-05 03:00:00' AND g.DeviceLoginName='2677' GROUP BY  g.time, g.Distance;
CountAzimuth:2
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-04 23:0:0' AND e.date<='2024-11-05 5:0:0' AND e.DeviceLoginName='862531041050148' 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-11-04 21:00:00' AND g.time<='2024-11-05 03:00:00' AND g.DeviceLoginName='862531041050148' GROUP BY  g.time, g.Distance;
CountAzimuth:30
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-04 23:0:0' AND e.date<='2024-11-05 5:0:0' AND e.DeviceLoginName='5076' 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-11-04 21:00:00' AND g.time<='2024-11-05 03:00:00' AND g.DeviceLoginName='5076' GROUP BY  g.time, g.Distance;
CountAzimuth:75
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-04 23:0:0' AND e.date<='2024-11-05 5:0:0' AND e.DeviceLoginName='4861' 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-11-04 21:00:00' AND g.time<='2024-11-05 03:00:00' AND g.DeviceLoginName='4861' GROUP BY  g.time, g.Distance;
CountAzimuth:174
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-04 23:0:0' AND e.date<='2024-11-05 5:0:0' AND e.DeviceLoginName='2470' 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-11-04 21:00:00' AND g.time<='2024-11-05 03:00:00' AND g.DeviceLoginName='2470' GROUP BY  g.time, g.Distance;
CountAzimuth:32
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-04 23:0:0' AND e.date<='2024-11-05 5:0:0' AND e.DeviceLoginName='2662' 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-11-04 21:00:00' AND g.time<='2024-11-05 03:00:00' AND g.DeviceLoginName='2662' GROUP BY  g.time, g.Distance;
CountAzimuth:17
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-04 23:0:0' AND e.date<='2024-11-05 5:0:0' AND e.DeviceLoginName='2576' 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-11-04 21:00:00' AND g.time<='2024-11-05 03:00:00' AND g.DeviceLoginName='2576' GROUP BY  g.time, g.Distance;
CountAzimuth:9
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-04 23:0:0' AND e.date<='2024-11-05 5:0:0' AND e.DeviceLoginName='4862' 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-11-04 21:00:00' AND g.time<='2024-11-05 03:00:00' AND g.DeviceLoginName='4862' GROUP BY  g.time, g.Distance;
CountAzimuth:190
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-04 23:0:0' AND e.date<='2024-11-05 5:0:0' AND e.DeviceLoginName='3061' 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-11-04 21:00:00' AND g.time<='2024-11-05 03:00:00' AND g.DeviceLoginName='3061' GROUP BY  g.time, g.Distance;
CountAzimuth:231
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-07 0:35:37' AND e.date<='2024-11-07 23:35:37' AND e.DeviceLoginName='352353086180491' 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-11-06 22:35:37' AND g.time<='2024-11-07 21:35:37' AND g.DeviceLoginName='352353086180491' GROUP BY  g.time, g.Distance;
CountAzimuth:2539
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-04 23:0:0' AND e.date<='2024-11-05 5:0:0' AND e.DeviceLoginName='356078111279820' 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-11-04 21:00:00' AND g.time<='2024-11-05 03:00:00' AND g.DeviceLoginName='356078111279820' GROUP BY  g.time, g.Distance;
CountAzimuth:12
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-04 23:0:0' AND e.date<='2024-11-05 5:0:0' AND e.DeviceLoginName='353173060497698' 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-11-04 21:00:00' AND g.time<='2024-11-05 03:00:00' AND g.DeviceLoginName='353173060497698' GROUP BY  g.time, g.Distance;
CountAzimuth:14
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-04 23:0:0' AND e.date<='2024-11-05 5:0:0' AND e.DeviceLoginName='8983' 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-11-04 21:00:00' AND g.time<='2024-11-05 03:00:00' AND g.DeviceLoginName='8983' GROUP BY  g.time, g.Distance;
CountAzimuth:251
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-04 23:0:0' AND e.date<='2024-11-05 5:0:0' AND e.DeviceLoginName='2888' 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-11-04 21:00:00' AND g.time<='2024-11-05 03:00:00' AND g.DeviceLoginName='2888' GROUP BY  g.time, g.Distance;
CountAzimuth:15
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-05 23:0:0' AND e.date<='2024-11-06 5:0:0' AND e.DeviceLoginName='356078116292406' 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-11-05 21:00:00' AND g.time<='2024-11-06 03:00:00' AND g.DeviceLoginName='356078116292406' GROUP BY  g.time, g.Distance;
CountAzimuth:128
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-05 23:0:0' AND e.date<='2024-11-06 5:0:0' AND e.DeviceLoginName='4849' 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-11-05 21:00:00' AND g.time<='2024-11-06 03:00:00' AND g.DeviceLoginName='4849' GROUP BY  g.time, g.Distance;
CountAzimuth:305
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-05 23:0:0' AND e.date<='2024-11-06 5:0:0' AND e.DeviceLoginName='862531041050148' 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-11-05 21:00:00' AND g.time<='2024-11-06 03:00:00' AND g.DeviceLoginName='862531041050148' GROUP BY  g.time, g.Distance;
CountAzimuth:110
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-05 23:0:0' AND e.date<='2024-11-06 5:0:0' AND e.DeviceLoginName='4862' 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-11-05 21:00:00' AND g.time<='2024-11-06 03:00:00' AND g.DeviceLoginName='4862' GROUP BY  g.time, g.Distance;
CountAzimuth:138
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-05 23:0:0' AND e.date<='2024-11-06 5:0:0' AND e.DeviceLoginName='3061' 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-11-05 21:00:00' AND g.time<='2024-11-06 03:00:00' AND g.DeviceLoginName='3061' GROUP BY  g.time, g.Distance;
CountAzimuth:199
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-06 23:0:0' AND e.date<='2024-11-07 5:0:0' AND e.DeviceLoginName='355234055581363' 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-11-06 21:00:00' AND g.time<='2024-11-07 03:00:00' AND g.DeviceLoginName='355234055581363' GROUP BY  g.time, g.Distance;
CountAzimuth:14
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-06 23:0:0' AND e.date<='2024-11-07 5:0:0' AND e.DeviceLoginName='355234055579235' 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-11-06 21:00:00' AND g.time<='2024-11-07 03:00:00' AND g.DeviceLoginName='355234055579235' GROUP BY  g.time, g.Distance;
CountAzimuth:55
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-07 0:41:3' AND e.date<='2024-11-07 23:41:3' AND e.DeviceLoginName='352353086180491' 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-11-06 22:41:03' AND g.time<='2024-11-07 21:41:03' AND g.DeviceLoginName='352353086180491' GROUP BY  g.time, g.Distance;
CountAzimuth:2539
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-06 23:0:0' AND e.date<='2024-11-07 5:0:0' AND e.DeviceLoginName='3064' 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-11-06 21:00:00' AND g.time<='2024-11-07 03:00:00' AND g.DeviceLoginName='3064' GROUP BY  g.time, g.Distance;
CountAzimuth:21
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-06 23:0:0' AND e.date<='2024-11-07 5:0:0' AND e.DeviceLoginName='4849' 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-11-06 21:00:00' AND g.time<='2024-11-07 03:00:00' AND g.DeviceLoginName='4849' GROUP BY  g.time, g.Distance;
CountAzimuth:139
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-06 23:0:0' AND e.date<='2024-11-07 5:0:0' AND e.DeviceLoginName='4966' 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-11-06 21:00:00' AND g.time<='2024-11-07 03:00:00' AND g.DeviceLoginName='4966' GROUP BY  g.time, g.Distance;
CountAzimuth:30
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-06 23:0:0' AND e.date<='2024-11-07 5:0:0' AND e.DeviceLoginName='862531041050148' 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-11-06 21:00:00' AND g.time<='2024-11-07 03:00:00' AND g.DeviceLoginName='862531041050148' GROUP BY  g.time, g.Distance;
CountAzimuth:49
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-06 23:0:0' AND e.date<='2024-11-07 5:0:0' AND e.DeviceLoginName='2662' 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-11-06 21:00:00' AND g.time<='2024-11-07 03:00:00' AND g.DeviceLoginName='2662' GROUP BY  g.time, g.Distance;
CountAzimuth:125
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-06 23:0:0' AND e.date<='2024-11-07 5:0:0' AND e.DeviceLoginName='9019' 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-11-06 21:00:00' AND g.time<='2024-11-07 03:00:00' AND g.DeviceLoginName='9019' GROUP BY  g.time, g.Distance;
CountAzimuth:30
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-06 23:0:0' AND e.date<='2024-11-07 5:0:0' AND e.DeviceLoginName='2866' 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-11-06 21:00:00' AND g.time<='2024-11-07 03:00:00' AND g.DeviceLoginName='2866' GROUP BY  g.time, g.Distance;
CountAzimuth:84
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-06 23:0:0' AND e.date<='2024-11-07 5:0:0' AND e.DeviceLoginName='3060' 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-11-06 21:00:00' AND g.time<='2024-11-07 03:00:00' AND g.DeviceLoginName='3060' GROUP BY  g.time, g.Distance;
CountAzimuth:167
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-06 23:0:0' AND e.date<='2024-11-07 5:0:0' AND e.DeviceLoginName='353173060497698' 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-11-06 21:00:00' AND g.time<='2024-11-07 03:00:00' AND g.DeviceLoginName='353173060497698' GROUP BY  g.time, g.Distance;
CountAzimuth:32
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-06 23:0:0' AND e.date<='2024-11-07 5:0:0' AND e.DeviceLoginName='2499' 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-11-06 21:00:00' AND g.time<='2024-11-07 03:00:00' AND g.DeviceLoginName='2499' GROUP BY  g.time, g.Distance;
CountAzimuth:22
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-06 23:0:0' AND e.date<='2024-11-07 5:0:0' AND e.DeviceLoginName='2584' 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-11-06 21:00:00' AND g.time<='2024-11-07 03:00:00' AND g.DeviceLoginName='2584' GROUP BY  g.time, g.Distance;
CountAzimuth:50
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-07 23:0:0' AND e.date<='2024-11-08 5:0:0' AND e.DeviceLoginName='9010' 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-11-07 21:00:00' AND g.time<='2024-11-08 03:00:00' AND g.DeviceLoginName='9010' GROUP BY  g.time, g.Distance;
CountAzimuth:135
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-07 23:0:0' AND e.date<='2024-11-08 5:0:0' AND e.DeviceLoginName='5131' 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-11-07 21:00:00' AND g.time<='2024-11-08 03:00:00' AND g.DeviceLoginName='5131' GROUP BY  g.time, g.Distance;
CountAzimuth:183
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-07 23:0:0' AND e.date<='2024-11-08 5:0:0' AND e.DeviceLoginName='4962' 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-11-07 21:00:00' AND g.time<='2024-11-08 03:00:00' AND g.DeviceLoginName='4962' GROUP BY  g.time, g.Distance;
CountAzimuth:56
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-07 23:0:0' AND e.date<='2024-11-08 5:0:0' AND e.DeviceLoginName='4849' 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-11-07 21:00:00' AND g.time<='2024-11-08 03:00:00' AND g.DeviceLoginName='4849' GROUP BY  g.time, g.Distance;
CountAzimuth:227
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-07 23:0:0' AND e.date<='2024-11-08 5:0:0' AND e.DeviceLoginName='5078' 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-11-07 21:00:00' AND g.time<='2024-11-08 03:00:00' AND g.DeviceLoginName='5078' GROUP BY  g.time, g.Distance;
CountAzimuth:53
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-07 23:0:0' AND e.date<='2024-11-08 5:0:0' AND e.DeviceLoginName='4863' 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-11-07 21:00:00' AND g.time<='2024-11-08 03:00:00' AND g.DeviceLoginName='4863' GROUP BY  g.time, g.Distance;
CountAzimuth:199
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-07 23:0:0' AND e.date<='2024-11-08 5:0:0' AND e.DeviceLoginName='2883' 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-11-07 21:00:00' AND g.time<='2024-11-08 03:00:00' AND g.DeviceLoginName='2883' GROUP BY  g.time, g.Distance;
CountAzimuth:15
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-07 23:0:0' AND e.date<='2024-11-08 5:0:0' AND e.DeviceLoginName='3263' 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-11-07 21:00:00' AND g.time<='2024-11-08 03:00:00' AND g.DeviceLoginName='3263' GROUP BY  g.time, g.Distance;
CountAzimuth:21
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-07 23:0:0' AND e.date<='2024-11-08 5:0:0' AND e.DeviceLoginName='862531041050148' 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-11-07 21:00:00' AND g.time<='2024-11-08 03:00:00' AND g.DeviceLoginName='862531041050148' GROUP BY  g.time, g.Distance;
CountAzimuth:322
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-07 23:0:0' AND e.date<='2024-11-08 5:0:0' AND e.DeviceLoginName='356078111279820' 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-11-07 21:00:00' AND g.time<='2024-11-08 03:00:00' AND g.DeviceLoginName='356078111279820' GROUP BY  g.time, g.Distance;
CountAzimuth:10
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-07 23:0:0' AND e.date<='2024-11-08 5:0:0' AND e.DeviceLoginName='2526' 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-11-07 21:00:00' AND g.time<='2024-11-08 03:00:00' AND g.DeviceLoginName='2526' GROUP BY  g.time, g.Distance;
CountAzimuth:98
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-07 23:0:0' AND e.date<='2024-11-08 5:0:0' AND e.DeviceLoginName='3192' 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-11-07 21:00:00' AND g.time<='2024-11-08 03:00:00' AND g.DeviceLoginName='3192' GROUP BY  g.time, g.Distance;
CountAzimuth:244
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-07 11:44:52' AND e.date<='2024-11-08 11:44:52' AND e.DeviceLoginName='352353084314407' 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-11-07 09:44:52' AND g.time<='2024-11-08 09:44:52' AND g.DeviceLoginName='352353084314407' GROUP BY  g.time, g.Distance;
CountAzimuth:1651
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-04 0:44:52' AND e.date<='2024-11-04 23:44:52' AND e.DeviceLoginName='352353084314407' 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-11-03 22:44:52' AND g.time<='2024-11-04 21:44:52' AND g.DeviceLoginName='352353084314407' GROUP BY  g.time, g.Distance;
CountAzimuth:1261
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-05 0:44:52' AND e.date<='2024-11-05 23:44:52' AND e.DeviceLoginName='352353084314407' 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-11-04 22:44:52' AND g.time<='2024-11-05 21:44:52' AND g.DeviceLoginName='352353084314407' GROUP BY  g.time, g.Distance;
CountAzimuth:1664
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-08 3:27:58' AND e.date<='2024-11-08 12:27:58' 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-11-08 01:27:58' AND g.time<='2024-11-08 10:27:58' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:388
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-07 12:33:40' AND e.date<='2024-11-08 12:33:40' AND e.DeviceLoginName='352353084290888' 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-11-07 10:33:40' AND g.time<='2024-11-08 10:33:40' AND g.DeviceLoginName='352353084290888' GROUP BY  g.time, g.Distance;
CountAzimuth:1302
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-07 12:33:40' AND e.date<='2024-11-08 12:33:40' AND e.DeviceLoginName='4957' 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-11-07 10:33:40' AND g.time<='2024-11-08 10:33:40' AND g.DeviceLoginName='4957' GROUP BY  g.time, g.Distance;
CountAzimuth:764
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-08 7:41:24' AND e.date<='2024-11-08 12:41: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-11-08 05:41:24' AND g.time<='2024-11-08 10:41:24' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:96