Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-19 8:5:59' AND e.date<='2024-12-20 8:5:59' AND e.DeviceLoginName='864866053467873' 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-12-19 06:05:59' AND g.time<='2024-12-20 06:05:59' AND g.DeviceLoginName='864866053467873' GROUP BY  g.time, g.Distance;
CountAzimuth:0
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-18 8:5:59' AND e.date<='2024-12-20 8:5:59' AND e.DeviceLoginName='864866053467873' 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-12-18 06:05:59' AND g.time<='2024-12-20 06:05:59' AND g.DeviceLoginName='864866053467873' GROUP BY  g.time, g.Distance;
CountAzimuth:1656
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-18 8:5:59' AND e.date<='2024-12-20 8:5:59' AND e.DeviceLoginName='352353084176731' 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-12-18 06:05:59' AND g.time<='2024-12-20 06:05:59' AND g.DeviceLoginName='352353084176731' GROUP BY  g.time, g.Distance;
CountAzimuth:2892
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-18 8:5:59' AND e.date<='2024-12-20 8:5:59' AND e.DeviceLoginName='2638' 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-12-18 06:05:59' AND g.time<='2024-12-20 06:05:59' AND g.DeviceLoginName='2638' GROUP BY  g.time, g.Distance;
CountAzimuth:0
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-18 8:5:59' AND e.date<='2024-12-20 8:5:59' AND e.DeviceLoginName='2534' 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-12-18 06:05:59' AND g.time<='2024-12-20 06:05:59' AND g.DeviceLoginName='2534' GROUP BY  g.time, g.Distance;
CountAzimuth:1819
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-18 8:5:59' AND e.date<='2024-12-20 8:5:59' AND e.DeviceLoginName='352353084176731' 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-12-18 06:05:59' AND g.time<='2024-12-20 06:05:59' AND g.DeviceLoginName='352353084176731' GROUP BY  g.time, g.Distance;
CountAzimuth:2892
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-18 8:10:54' AND e.date<='2024-12-20 8:10:54' AND e.DeviceLoginName='352353084176731' 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-12-18 06:10:54' AND g.time<='2024-12-20 06:10:54' AND g.DeviceLoginName='352353084176731' GROUP BY  g.time, g.Distance;
CountAzimuth:2892
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-19 0:46:21' AND e.date<='2024-12-19 23:46:21' 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-12-18 22:46:21' AND g.time<='2024-12-19 21:46:21' AND g.DeviceLoginName='2494' GROUP BY  g.time, g.Distance;
CountAzimuth:869
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-16 23:0:0' AND e.date<='2024-12-17 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-12-16 21:00:00' AND g.time<='2024-12-17 03:00:00' AND g.DeviceLoginName='5078' GROUP BY  g.time, g.Distance;
CountAzimuth:147
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-16 23:0:0' AND e.date<='2024-12-17 5:0:0' AND e.DeviceLoginName='5080' 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-12-16 21:00:00' AND g.time<='2024-12-17 03:00:00' AND g.DeviceLoginName='5080' GROUP BY  g.time, g.Distance;
CountAzimuth:139
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-16 23:0:0' AND e.date<='2024-12-17 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-12-16 21:00:00' AND g.time<='2024-12-17 03:00:00' AND g.DeviceLoginName='4862' GROUP BY  g.time, g.Distance;
CountAzimuth:234
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-16 23:0:0' AND e.date<='2024-12-17 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-12-16 21:00:00' AND g.time<='2024-12-17 03:00:00' AND g.DeviceLoginName='3061' GROUP BY  g.time, g.Distance;
CountAzimuth:315
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-16 23:0:0' AND e.date<='2024-12-17 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-12-16 21:00:00' AND g.time<='2024-12-17 03:00:00' AND g.DeviceLoginName='356078111279820' GROUP BY  g.time, g.Distance;
CountAzimuth:11
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-16 23:0:0' AND e.date<='2024-12-17 5:0:0' AND e.DeviceLoginName='2726' 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-12-16 21:00:00' AND g.time<='2024-12-17 03:00:00' AND g.DeviceLoginName='2726' GROUP BY  g.time, g.Distance;
CountAzimuth:102
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-17 23:0:0' AND e.date<='2024-12-18 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-12-17 21:00:00' AND g.time<='2024-12-18 03:00:00' AND g.DeviceLoginName='9010' GROUP BY  g.time, g.Distance;
CountAzimuth:36
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-17 23:0:0' AND e.date<='2024-12-18 5:0:0' AND e.DeviceLoginName='2759' 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-12-17 21:00:00' AND g.time<='2024-12-18 03:00:00' AND g.DeviceLoginName='2759' GROUP BY  g.time, g.Distance;
CountAzimuth:150
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-17 23:0:0' AND e.date<='2024-12-18 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-12-17 21:00:00' AND g.time<='2024-12-18 03:00:00' AND g.DeviceLoginName='4849' GROUP BY  g.time, g.Distance;
CountAzimuth:188
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-17 23:0:0' AND e.date<='2024-12-18 5:0:0' AND e.DeviceLoginName='2790' 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-12-17 21:00:00' AND g.time<='2024-12-18 03:00:00' AND g.DeviceLoginName='2790' GROUP BY  g.time, g.Distance;
CountAzimuth:19
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-17 23:0:0' AND e.date<='2024-12-18 5:0:0' AND e.DeviceLoginName='356078111430837' 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-12-17 21:00:00' AND g.time<='2024-12-18 03:00:00' AND g.DeviceLoginName='356078111430837' GROUP BY  g.time, g.Distance;
CountAzimuth:144
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-17 23:0:0' AND e.date<='2024-12-18 5:0:0' AND e.DeviceLoginName='354836080152241' 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-12-17 21:00:00' AND g.time<='2024-12-18 03:00:00' AND g.DeviceLoginName='354836080152241' GROUP BY  g.time, g.Distance;
CountAzimuth:14
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-17 23:0:0' AND e.date<='2024-12-18 5:0:0' AND e.DeviceLoginName='9378' 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-12-17 21:00:00' AND g.time<='2024-12-18 03:00:00' AND g.DeviceLoginName='9378' GROUP BY  g.time, g.Distance;
CountAzimuth:58
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-17 23:0:0' AND e.date<='2024-12-18 5:0:0' AND e.DeviceLoginName='4883' 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-12-17 21:00:00' AND g.time<='2024-12-18 03:00:00' AND g.DeviceLoginName='4883' GROUP BY  g.time, g.Distance;
CountAzimuth:6
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-17 23:0:0' AND e.date<='2024-12-18 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-12-17 21:00:00' AND g.time<='2024-12-18 03:00:00' AND g.DeviceLoginName='862531041050148' GROUP BY  g.time, g.Distance;
CountAzimuth:19
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-17 23:0:0' AND e.date<='2024-12-18 5:0:0' AND e.DeviceLoginName='2783' 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-12-17 21:00:00' AND g.time<='2024-12-18 03:00:00' AND g.DeviceLoginName='2783' GROUP BY  g.time, g.Distance;
CountAzimuth:125
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-17 23:0:0' AND e.date<='2024-12-18 5:0:0' AND e.DeviceLoginName='2785' 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-12-17 21:00:00' AND g.time<='2024-12-18 03:00:00' AND g.DeviceLoginName='2785' GROUP BY  g.time, g.Distance;
CountAzimuth:16
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-17 23:0:0' AND e.date<='2024-12-18 5:0:0' AND e.DeviceLoginName='4959' 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-12-17 21:00:00' AND g.time<='2024-12-18 03:00:00' AND g.DeviceLoginName='4959' GROUP BY  g.time, g.Distance;
CountAzimuth:169
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-17 23:0:0' AND e.date<='2024-12-18 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-12-17 21:00:00' AND g.time<='2024-12-18 03:00:00' AND g.DeviceLoginName='5076' GROUP BY  g.time, g.Distance;
CountAzimuth:67
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-17 23:0:0' AND e.date<='2024-12-18 5:0:0' AND e.DeviceLoginName='2500' 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-12-17 21:00:00' AND g.time<='2024-12-18 03:00:00' AND g.DeviceLoginName='2500' GROUP BY  g.time, g.Distance;
CountAzimuth:7
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-17 23:0:0' AND e.date<='2024-12-18 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-12-17 21:00:00' AND g.time<='2024-12-18 03:00:00' AND g.DeviceLoginName='4861' GROUP BY  g.time, g.Distance;
CountAzimuth:56
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-17 23:0:0' AND e.date<='2024-12-18 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-12-17 21:00:00' AND g.time<='2024-12-18 03:00:00' AND g.DeviceLoginName='2470' GROUP BY  g.time, g.Distance;
CountAzimuth:50
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-17 23:0:0' AND e.date<='2024-12-18 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-12-17 21:00:00' AND g.time<='2024-12-18 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-12-17 23:0:0' AND e.date<='2024-12-18 5:0:0' AND e.DeviceLoginName='4819' 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-12-17 21:00:00' AND g.time<='2024-12-18 03:00:00' AND g.DeviceLoginName='4819' GROUP BY  g.time, g.Distance;
CountAzimuth:48
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-18 23:0:0' AND e.date<='2024-12-19 5:0:0' AND e.DeviceLoginName='8992' 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-12-18 21:00:00' AND g.time<='2024-12-19 03:00:00' AND g.DeviceLoginName='8992' GROUP BY  g.time, g.Distance;
CountAzimuth:40
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-18 23:0:0' AND e.date<='2024-12-19 5:0:0' AND e.DeviceLoginName='3123' 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-12-18 21:00:00' AND g.time<='2024-12-19 03:00:00' AND g.DeviceLoginName='3123' GROUP BY  g.time, g.Distance;
CountAzimuth:62
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-18 23:0:0' AND e.date<='2024-12-19 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-12-18 21:00:00' AND g.time<='2024-12-19 03:00:00' AND g.DeviceLoginName='4849' GROUP BY  g.time, g.Distance;
CountAzimuth:271
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-18 23:0:0' AND e.date<='2024-12-19 5:0:0' AND e.DeviceLoginName='2913' 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-12-18 21:00:00' AND g.time<='2024-12-19 03:00:00' AND g.DeviceLoginName='2913' GROUP BY  g.time, g.Distance;
CountAzimuth:12
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-18 23:0:0' AND e.date<='2024-12-19 5:0:0' AND e.DeviceLoginName='3157' 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-12-18 21:00:00' AND g.time<='2024-12-19 03:00:00' AND g.DeviceLoginName='3157' GROUP BY  g.time, g.Distance;
CountAzimuth:191
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-18 23:0:0' AND e.date<='2024-12-19 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-12-18 21:00:00' AND g.time<='2024-12-19 03:00:00' AND g.DeviceLoginName='5078' GROUP BY  g.time, g.Distance;
CountAzimuth:219
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-18 23:0:0' AND e.date<='2024-12-19 5:0:0' AND e.DeviceLoginName='9378' 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-12-18 21:00:00' AND g.time<='2024-12-19 03:00:00' AND g.DeviceLoginName='9378' GROUP BY  g.time, g.Distance;
CountAzimuth:12
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-18 23:0:0' AND e.date<='2024-12-19 5:0:0' AND e.DeviceLoginName='2510' 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-12-18 21:00:00' AND g.time<='2024-12-19 03:00:00' AND g.DeviceLoginName='2510' GROUP BY  g.time, g.Distance;
CountAzimuth:14
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-18 23:0:0' AND e.date<='2024-12-19 5:0:0' AND e.DeviceLoginName='4827' 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-12-18 21:00:00' AND g.time<='2024-12-19 03:00:00' AND g.DeviceLoginName='4827' GROUP BY  g.time, g.Distance;
CountAzimuth:100
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-18 23:0:0' AND e.date<='2024-12-19 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-12-18 21:00:00' AND g.time<='2024-12-19 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-12-18 23:0:0' AND e.date<='2024-12-19 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-12-18 21:00:00' AND g.time<='2024-12-19 03:00:00' AND g.DeviceLoginName='5076' GROUP BY  g.time, g.Distance;
CountAzimuth:12
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-18 23:0:0' AND e.date<='2024-12-19 5:0:0' AND e.DeviceLoginName='3124' 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-12-18 21:00:00' AND g.time<='2024-12-19 03:00:00' AND g.DeviceLoginName='3124' GROUP BY  g.time, g.Distance;
CountAzimuth:377
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-18 23:0:0' AND e.date<='2024-12-19 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-12-18 21:00:00' AND g.time<='2024-12-19 03:00:00' AND g.DeviceLoginName='4861' GROUP BY  g.time, g.Distance;
CountAzimuth:71
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-18 23:0:0' AND e.date<='2024-12-19 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-12-18 21:00:00' AND g.time<='2024-12-19 03:00:00' AND g.DeviceLoginName='2470' GROUP BY  g.time, g.Distance;
CountAzimuth:20
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-18 23:0:0' AND e.date<='2024-12-19 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-12-18 21:00:00' AND g.time<='2024-12-19 03:00:00' AND g.DeviceLoginName='2662' GROUP BY  g.time, g.Distance;
CountAzimuth:40
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-18 23:0:0' AND e.date<='2024-12-19 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-12-18 21:00:00' AND g.time<='2024-12-19 03:00:00' AND g.DeviceLoginName='4862' GROUP BY  g.time, g.Distance;
CountAzimuth:208
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-18 23:0:0' AND e.date<='2024-12-19 5:0:0' 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-12-18 21:00:00' AND g.time<='2024-12-19 03:00:00' AND g.DeviceLoginName='2556' GROUP BY  g.time, g.Distance;
CountAzimuth:53
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-18 23:0:0' AND e.date<='2024-12-19 5:0:0' 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-12-18 21:00:00' AND g.time<='2024-12-19 03:00:00' AND g.DeviceLoginName='4957' GROUP BY  g.time, g.Distance;
CountAzimuth:21
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-18 23:0:0' AND e.date<='2024-12-19 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-12-18 21:00:00' AND g.time<='2024-12-19 03:00:00' AND g.DeviceLoginName='2499' GROUP BY  g.time, g.Distance;
CountAzimuth:73
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-19 23:0:0' AND e.date<='2024-12-20 5:0:0' AND e.DeviceLoginName='9011' 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-12-19 21:00:00' AND g.time<='2024-12-20 03:00:00' AND g.DeviceLoginName='9011' GROUP BY  g.time, g.Distance;
CountAzimuth:14
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-19 23:0:0' AND e.date<='2024-12-20 5:0:0' AND e.DeviceLoginName='354836080392664' 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-12-19 21:00:00' AND g.time<='2024-12-20 03:00:00' AND g.DeviceLoginName='354836080392664' GROUP BY  g.time, g.Distance;
CountAzimuth:185
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-19 23:0:0' AND e.date<='2024-12-20 5:0:0' AND e.DeviceLoginName='3057' 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-12-19 21:00:00' AND g.time<='2024-12-20 03:00:00' AND g.DeviceLoginName='3057' GROUP BY  g.time, g.Distance;
CountAzimuth:22
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-19 23:0:0' AND e.date<='2024-12-20 5:0:0' AND e.DeviceLoginName='3073' 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-12-19 21:00:00' AND g.time<='2024-12-20 03:00:00' AND g.DeviceLoginName='3073' GROUP BY  g.time, g.Distance;
CountAzimuth:173
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-19 23:0:0' AND e.date<='2024-12-20 5:0:0' AND e.DeviceLoginName='2575' 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-12-19 21:00:00' AND g.time<='2024-12-20 03:00:00' AND g.DeviceLoginName='2575' GROUP BY  g.time, g.Distance;
CountAzimuth:571
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-19 23:0:0' AND e.date<='2024-12-20 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-12-19 21:00:00' AND g.time<='2024-12-20 03:00:00' AND g.DeviceLoginName='4849' GROUP BY  g.time, g.Distance;
CountAzimuth:250
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-19 23:0:0' AND e.date<='2024-12-20 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-12-19 21:00:00' AND g.time<='2024-12-20 03:00:00' AND g.DeviceLoginName='2883' GROUP BY  g.time, g.Distance;
CountAzimuth:68
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-19 23:0:0' AND e.date<='2024-12-20 5:0:0' AND e.DeviceLoginName='3045' 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-12-19 21:00:00' AND g.time<='2024-12-20 03:00:00' AND g.DeviceLoginName='3045' GROUP BY  g.time, g.Distance;
CountAzimuth:13
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-19 23:0:0' AND e.date<='2024-12-20 5:0:0' AND e.DeviceLoginName='354836080152241' 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-12-19 21:00:00' AND g.time<='2024-12-20 03:00:00' AND g.DeviceLoginName='354836080152241' GROUP BY  g.time, g.Distance;
CountAzimuth:13
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-19 23:0:0' AND e.date<='2024-12-20 5:0:0' AND e.DeviceLoginName='2510' 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-12-19 21:00:00' AND g.time<='2024-12-20 03:00:00' AND g.DeviceLoginName='2510' GROUP BY  g.time, g.Distance;
CountAzimuth:7
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-19 23:0:0' AND e.date<='2024-12-20 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-12-19 21:00:00' AND g.time<='2024-12-20 03:00:00' AND g.DeviceLoginName='862531041050148' GROUP BY  g.time, g.Distance;
CountAzimuth:101
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-19 23:0:0' AND e.date<='2024-12-20 5:0:0' AND e.DeviceLoginName='2773' 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-12-19 21:00:00' AND g.time<='2024-12-20 03:00:00' AND g.DeviceLoginName='2773' GROUP BY  g.time, g.Distance;
CountAzimuth:2
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-19 23:0:0' AND e.date<='2024-12-20 5:0:0' AND e.DeviceLoginName='3124' 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-12-19 21:00:00' AND g.time<='2024-12-20 03:00:00' AND g.DeviceLoginName='3124' GROUP BY  g.time, g.Distance;
CountAzimuth:125
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-19 23:0:0' AND e.date<='2024-12-20 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-12-19 21:00:00' AND g.time<='2024-12-20 03:00:00' AND g.DeviceLoginName='4861' GROUP BY  g.time, g.Distance;
CountAzimuth:34
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-19 23:0:0' AND e.date<='2024-12-20 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-12-19 21:00:00' AND g.time<='2024-12-20 03:00:00' AND g.DeviceLoginName='2866' GROUP BY  g.time, g.Distance;
CountAzimuth:76
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-19 23:0:0' AND e.date<='2024-12-20 5:0:0' AND e.DeviceLoginName='3092' 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-12-19 21:00:00' AND g.time<='2024-12-20 03:00:00' AND g.DeviceLoginName='3092' GROUP BY  g.time, g.Distance;
CountAzimuth:32
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-19 23:0:0' AND e.date<='2024-12-20 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-12-19 21:00:00' AND g.time<='2024-12-20 03:00:00' AND g.DeviceLoginName='4862' GROUP BY  g.time, g.Distance;
CountAzimuth:239
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-19 23:0:0' AND e.date<='2024-12-20 5:0:0' 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-12-19 21:00:00' AND g.time<='2024-12-20 03:00:00' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:238
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-19 23:0:0' AND e.date<='2024-12-20 5:0:0' 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-12-19 21:00:00' AND g.time<='2024-12-20 03:00:00' AND g.DeviceLoginName='4957' GROUP BY  g.time, g.Distance;
CountAzimuth:43
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-19 23:0:0' AND e.date<='2024-12-20 5:0:0' AND e.DeviceLoginName='2728' 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-12-19 21:00:00' AND g.time<='2024-12-20 03:00:00' AND g.DeviceLoginName='2728' GROUP BY  g.time, g.Distance;
CountAzimuth:12
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-19 23:0:0' AND e.date<='2024-12-20 5:0:0' AND e.DeviceLoginName='4819' 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-12-19 21:00:00' AND g.time<='2024-12-20 03:00:00' AND g.DeviceLoginName='4819' GROUP BY  g.time, g.Distance;
CountAzimuth:205
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-19 23:0:0' AND e.date<='2024-12-20 5:0:0' AND e.DeviceLoginName='354836080392664' 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-12-19 21:00:00' AND g.time<='2024-12-20 03:00:00' AND g.DeviceLoginName='354836080392664' GROUP BY  g.time, g.Distance;
CountAzimuth:185
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-19 23:0:0' AND e.date<='2024-12-20 5:0:0' 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-12-19 21:00:00' AND g.time<='2024-12-20 03:00:00' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:238
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-14 0:24:38' AND e.date<='2024-12-14 23:24:38' AND e.DeviceLoginName='356078111293896' 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-12-13 22:24:38' AND g.time<='2024-12-14 21:24:38' AND g.DeviceLoginName='356078111293896' GROUP BY  g.time, g.Distance;
CountAzimuth:769
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-20 0:33:19' AND e.date<='2024-12-20 12:33:19' AND e.DeviceLoginName='2590' 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-12-19 22:33:19' AND g.time<='2024-12-20 10:33:19' AND g.DeviceLoginName='2590' GROUP BY  g.time, g.Distance;
CountAzimuth:713
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-20 0:20:48' AND e.date<='2024-12-20 13:20:48' AND e.DeviceLoginName='9003' 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-12-19 22:20:48' AND g.time<='2024-12-20 11:20:48' AND g.DeviceLoginName='9003' GROUP BY  g.time, g.Distance;
CountAzimuth:1404
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-20 0:42:29' AND e.date<='2024-12-20 13:42:29' AND e.DeviceLoginName='2908' 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-12-19 22:42:29' AND g.time<='2024-12-20 11:42:29' AND g.DeviceLoginName='2908' GROUP BY  g.time, g.Distance;
CountAzimuth:438
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-19 0:42:29' AND e.date<='2024-12-19 23:42:29' AND e.DeviceLoginName='2908' 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-12-18 22:42:29' AND g.time<='2024-12-19 21:42:29' AND g.DeviceLoginName='2908' GROUP BY  g.time, g.Distance;
CountAzimuth:3259
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-18 0:42:29' AND e.date<='2024-12-18 23:42:29' AND e.DeviceLoginName='2908' 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-12-17 22:42:29' AND g.time<='2024-12-18 21:42:29' AND g.DeviceLoginName='2908' GROUP BY  g.time, g.Distance;
CountAzimuth:2946
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-17 0:42:29' AND e.date<='2024-12-17 23:42:29' AND e.DeviceLoginName='2908' 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-12-16 22:42:29' AND g.time<='2024-12-17 21:42:29' AND g.DeviceLoginName='2908' GROUP BY  g.time, g.Distance;
CountAzimuth:4519
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-20 0:42:29' AND e.date<='2024-12-20 23:42:29' AND e.DeviceLoginName='2908' 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-12-19 22:42:29' AND g.time<='2024-12-20 21:42:29' AND g.DeviceLoginName='2908' GROUP BY  g.time, g.Distance;
CountAzimuth:438
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-20 0:42:29' AND e.date<='2024-12-20 23:42:29' AND e.DeviceLoginName='2908' 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-12-19 22:42:29' AND g.time<='2024-12-20 21:42:29' AND g.DeviceLoginName='2908' GROUP BY  g.time, g.Distance;
CountAzimuth:438
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-20 0:42:29' AND e.date<='2024-12-20 23:42:29' AND e.DeviceLoginName='355234055747568' 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-12-19 22:42:29' AND g.time<='2024-12-20 21:42:29' AND g.DeviceLoginName='355234055747568' GROUP BY  g.time, g.Distance;
CountAzimuth:771
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-20 0:59:39' AND e.date<='2024-12-20 13:59:39' AND e.DeviceLoginName='3021' 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-12-19 22:59:39' AND g.time<='2024-12-20 11:59:39' AND g.DeviceLoginName='3021' GROUP BY  g.time, g.Distance;
CountAzimuth:704
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-14 0:59:39' AND e.date<='2024-12-14 0:59:39' AND e.DeviceLoginName='355234055747568' 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-12-13 22:59:39' AND g.time<='2024-12-13 22:59:39' AND g.DeviceLoginName='355234055747568' GROUP BY  g.time, g.Distance;
CountAzimuth:0
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-14 0:59:39' AND e.date<='2024-12-14 23:59:39' AND e.DeviceLoginName='355234055747568' 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-12-13 22:59:39' AND g.time<='2024-12-14 21:59:39' AND g.DeviceLoginName='355234055747568' GROUP BY  g.time, g.Distance;
CountAzimuth:782
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-07 0:59:39' AND e.date<='2024-12-08 23:59:39' AND e.DeviceLoginName='355234055747568' 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-12-06 22:59:39' AND g.time<='2024-12-08 21:59:39' AND g.DeviceLoginName='355234055747568' GROUP BY  g.time, g.Distance;
CountAzimuth:212
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-30 0:59:39' AND e.date<='2024-12-01 23:59:39' AND e.DeviceLoginName='355234055747568' 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-29 22:59:39' AND g.time<='2024-12-01 21:59:39' AND g.DeviceLoginName='355234055747568' GROUP BY  g.time, g.Distance;
CountAzimuth:263
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-14 0:59:39' AND e.date<='2024-12-14 23:59:39' AND e.DeviceLoginName='356078111282576' 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-12-13 22:59:39' AND g.time<='2024-12-14 21:59:39' AND g.DeviceLoginName='356078111282576' GROUP BY  g.time, g.Distance;
CountAzimuth:454
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-14 0:13:24' AND e.date<='2024-12-15 23:13:24' AND e.DeviceLoginName='352353083463817' 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-12-13 22:13:24' AND g.time<='2024-12-15 21:13:24' AND g.DeviceLoginName='352353083463817' GROUP BY  g.time, g.Distance;
CountAzimuth:1328
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-07 0:13:24' AND e.date<='2024-12-08 23:13:24' AND e.DeviceLoginName='352353083463817' 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-12-06 22:13:24' AND g.time<='2024-12-08 21:13:24' AND g.DeviceLoginName='352353083463817' GROUP BY  g.time, g.Distance;
CountAzimuth:1086
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-30 0:13:24' AND e.date<='2024-12-01 23:13:24' AND e.DeviceLoginName='352353083463817' 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-29 22:13:24' AND g.time<='2024-12-01 21:13:24' AND g.DeviceLoginName='352353083463817' GROUP BY  g.time, g.Distance;
CountAzimuth:1926
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-30 0:13:24' AND e.date<='2024-12-01 23:13:24' AND e.DeviceLoginName='2610' 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-29 22:13:24' AND g.time<='2024-12-01 21:13:24' AND g.DeviceLoginName='2610' GROUP BY  g.time, g.Distance;
CountAzimuth:10
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-19 0:13:24' AND e.date<='2024-12-20 23:13:24' AND e.DeviceLoginName='2610' 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-12-18 22:13:24' AND g.time<='2024-12-20 21:13:24' AND g.DeviceLoginName='2610' GROUP BY  g.time, g.Distance;
CountAzimuth:1552
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-16 0:13:24' AND e.date<='2024-12-20 23:13:24' AND e.DeviceLoginName='2610' 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-12-15 22:13:24' AND g.time<='2024-12-20 21:13:24' AND g.DeviceLoginName='2610' GROUP BY  g.time, g.Distance;
CountAzimuth:4233
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-09 0:13:24' AND e.date<='2024-12-20 23:13:24' AND e.DeviceLoginName='2610' 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-12-08 22:13:24' AND g.time<='2024-12-20 21:13:24' AND g.DeviceLoginName='2610' GROUP BY  g.time, g.Distance;
CountAzimuth:8206
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-20 0:38:18' AND e.date<='2024-12-20 15:38:18' AND e.DeviceLoginName='2610' 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-12-19 22:38:18' AND g.time<='2024-12-20 13:38:18' AND g.DeviceLoginName='2610' GROUP BY  g.time, g.Distance;
CountAzimuth:728
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-30 0:53:53' AND e.date<='2024-12-01 23:53:53' AND e.DeviceLoginName='352353083463817' 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-29 22:53:53' AND g.time<='2024-12-01 21:53:53' AND g.DeviceLoginName='352353083463817' GROUP BY  g.time, g.Distance;
CountAzimuth:1926
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-23 0:53:53' AND e.date<='2024-11-24 23:53:53' AND e.DeviceLoginName='352353083463817' 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-22 22:53:53' AND g.time<='2024-11-24 21:53:53' AND g.DeviceLoginName='352353083463817' GROUP BY  g.time, g.Distance;
CountAzimuth:1971
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-30 0:53:53' AND e.date<='2024-12-01 23:53:53' AND e.DeviceLoginName='352353083463817' 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-29 22:53:53' AND g.time<='2024-12-01 21:53:53' AND g.DeviceLoginName='352353083463817' GROUP BY  g.time, g.Distance;
CountAzimuth:1926
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-07 0:53:53' AND e.date<='2024-12-08 23:53:53' AND e.DeviceLoginName='352353083463817' 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-12-06 22:53:53' AND g.time<='2024-12-08 21:53:53' AND g.DeviceLoginName='352353083463817' GROUP BY  g.time, g.Distance;
CountAzimuth:1086
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-14 0:53:53' AND e.date<='2024-12-15 23:53:53' AND e.DeviceLoginName='352353083463817' 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-12-13 22:53:53' AND g.time<='2024-12-15 21:53:53' AND g.DeviceLoginName='352353083463817' GROUP BY  g.time, g.Distance;
CountAzimuth:1328