Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-18 23:0:0' AND e.date<='2023-12-19 5:0:0' AND e.DeviceLoginName='4964' 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>='2023-12-18 21:00:00' AND g.time<='2023-12-19 03:00:00' AND g.DeviceLoginName='4964' GROUP BY  g.time, g.Distance;
CountAzimuth:242
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-18 23:0:0' AND e.date<='2023-12-19 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>='2023-12-18 21:00:00' AND g.time<='2023-12-19 03:00:00' AND g.DeviceLoginName='354836080152241' GROUP BY  g.time, g.Distance;
CountAzimuth:36
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-18 23:0:0' AND e.date<='2023-12-19 5:0:0' AND e.DeviceLoginName='5117' 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>='2023-12-18 21:00:00' AND g.time<='2023-12-19 03:00:00' AND g.DeviceLoginName='5117' GROUP BY  g.time, g.Distance;
CountAzimuth:161
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-18 23:0:0' AND e.date<='2023-12-19 5:0:0' 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>='2023-12-18 21:00:00' AND g.time<='2023-12-19 03:00:00' AND g.DeviceLoginName='352353084314407' GROUP BY  g.time, g.Distance;
CountAzimuth:144
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-18 23:0:0' AND e.date<='2023-12-19 5:0:0' AND e.DeviceLoginName='4844' 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>='2023-12-18 21:00:00' AND g.time<='2023-12-19 03:00:00' AND g.DeviceLoginName='4844' GROUP BY  g.time, g.Distance;
CountAzimuth:5
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-18 23:0:0' AND e.date<='2023-12-19 5:0:0' AND e.DeviceLoginName='352353086131585' 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>='2023-12-18 21:00:00' AND g.time<='2023-12-19 03:00:00' AND g.DeviceLoginName='352353086131585' GROUP BY  g.time, g.Distance;
CountAzimuth:215
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-18 23:0:0' AND e.date<='2023-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>='2023-12-18 21:00:00' AND g.time<='2023-12-19 03:00:00' AND g.DeviceLoginName='4862' GROUP BY  g.time, g.Distance;
CountAzimuth:200
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-18 23:0:0' AND e.date<='2023-12-19 5:0:0' AND e.DeviceLoginName='2550' 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>='2023-12-18 21:00:00' AND g.time<='2023-12-19 03:00:00' AND g.DeviceLoginName='2550' GROUP BY  g.time, g.Distance;
CountAzimuth:261
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-19 23:0:0' AND e.date<='2023-12-20 5:0:0' AND e.DeviceLoginName='4964' 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>='2023-12-19 21:00:00' AND g.time<='2023-12-20 03:00:00' AND g.DeviceLoginName='4964' GROUP BY  g.time, g.Distance;
CountAzimuth:471
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-19 23:0:0' AND e.date<='2023-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>='2023-12-19 21:00:00' AND g.time<='2023-12-20 03:00:00' AND g.DeviceLoginName='3045' GROUP BY  g.time, g.Distance;
CountAzimuth:52
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-19 23:0:0' AND e.date<='2023-12-20 5:0:0' AND e.DeviceLoginName='5117' 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>='2023-12-19 21:00:00' AND g.time<='2023-12-20 03:00:00' AND g.DeviceLoginName='5117' GROUP BY  g.time, g.Distance;
CountAzimuth:255
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-19 23:0:0' AND e.date<='2023-12-20 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>='2023-12-19 21:00:00' AND g.time<='2023-12-20 03:00:00' AND g.DeviceLoginName='5076' GROUP BY  g.time, g.Distance;
CountAzimuth:93
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-19 23:0:0' AND e.date<='2023-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>='2023-12-19 21:00:00' AND g.time<='2023-12-20 03:00:00' AND g.DeviceLoginName='3124' GROUP BY  g.time, g.Distance;
CountAzimuth:321
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-19 23:0:0' AND e.date<='2023-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>='2023-12-19 21:00:00' AND g.time<='2023-12-20 03:00:00' AND g.DeviceLoginName='4861' GROUP BY  g.time, g.Distance;
CountAzimuth:115
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-19 23:0:0' AND e.date<='2023-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>='2023-12-19 21:00:00' AND g.time<='2023-12-20 03:00:00' AND g.DeviceLoginName='4862' GROUP BY  g.time, g.Distance;
CountAzimuth:199
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-19 23:0:0' AND e.date<='2023-12-20 5:0:0' AND e.DeviceLoginName='4868' 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>='2023-12-19 21:00:00' AND g.time<='2023-12-20 03:00:00' AND g.DeviceLoginName='4868' GROUP BY  g.time, g.Distance;
CountAzimuth:200
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-19 23:0:0' AND e.date<='2023-12-20 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>='2023-12-19 21:00:00' AND g.time<='2023-12-20 03:00:00' AND g.DeviceLoginName='2556' GROUP BY  g.time, g.Distance;
CountAzimuth:13
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-19 23:0:0' AND e.date<='2023-12-20 5:0:0' AND e.DeviceLoginName='2522' 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>='2023-12-19 21:00:00' AND g.time<='2023-12-20 03:00:00' AND g.DeviceLoginName='2522' GROUP BY  g.time, g.Distance;
CountAzimuth:3
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-19 23:0:0' AND e.date<='2023-12-20 5:0:0' AND e.DeviceLoginName='2878' 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>='2023-12-19 21:00:00' AND g.time<='2023-12-20 03:00:00' AND g.DeviceLoginName='2878' GROUP BY  g.time, g.Distance;
CountAzimuth:350
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-20 23:0:0' AND e.date<='2023-12-21 5:0:0' AND e.DeviceLoginName='3184' 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>='2023-12-20 21:00:00' AND g.time<='2023-12-21 03:00:00' AND g.DeviceLoginName='3184' GROUP BY  g.time, g.Distance;
CountAzimuth:5
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-20 23:0:0' AND e.date<='2023-12-21 5:0:0' AND e.DeviceLoginName='4964' 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>='2023-12-20 21:00:00' AND g.time<='2023-12-21 03:00:00' AND g.DeviceLoginName='4964' GROUP BY  g.time, g.Distance;
CountAzimuth:265
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-20 23:0:0' AND e.date<='2023-12-21 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>='2023-12-20 21:00:00' AND g.time<='2023-12-21 03:00:00' AND g.DeviceLoginName='4849' GROUP BY  g.time, g.Distance;
CountAzimuth:240
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-20 23:0:0' AND e.date<='2023-12-21 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>='2023-12-20 21:00:00' AND g.time<='2023-12-21 03:00:00' AND g.DeviceLoginName='5078' GROUP BY  g.time, g.Distance;
CountAzimuth:209
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-20 23:0:0' AND e.date<='2023-12-21 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>='2023-12-20 21:00:00' AND g.time<='2023-12-21 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>='2023-12-20 23:0:0' AND e.date<='2023-12-21 5:0:0' AND e.DeviceLoginName='2461' 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>='2023-12-20 21:00:00' AND g.time<='2023-12-21 03:00:00' AND g.DeviceLoginName='2461' GROUP BY  g.time, g.Distance;
CountAzimuth:10
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-20 23:0:0' AND e.date<='2023-12-21 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>='2023-12-20 21:00:00' AND g.time<='2023-12-21 03:00:00' AND g.DeviceLoginName='3124' GROUP BY  g.time, g.Distance;
CountAzimuth:192
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-20 23:0:0' AND e.date<='2023-12-21 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>='2023-12-20 21:00:00' AND g.time<='2023-12-21 03:00:00' AND g.DeviceLoginName='2662' GROUP BY  g.time, g.Distance;
CountAzimuth:105
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-20 23:0:0' AND e.date<='2023-12-21 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>='2023-12-20 21:00:00' AND g.time<='2023-12-21 03:00:00' AND g.DeviceLoginName='2866' GROUP BY  g.time, g.Distance;
CountAzimuth:2
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-20 23:0:0' AND e.date<='2023-12-21 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>='2023-12-20 21:00:00' AND g.time<='2023-12-21 03:00:00' AND g.DeviceLoginName='4862' GROUP BY  g.time, g.Distance;
CountAzimuth:244
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-20 23:0:0' AND e.date<='2023-12-21 5:0:0' AND e.DeviceLoginName='2606' 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>='2023-12-20 21:00:00' AND g.time<='2023-12-21 03:00:00' AND g.DeviceLoginName='2606' GROUP BY  g.time, g.Distance;
CountAzimuth:8
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-20 23:0:0' AND e.date<='2023-12-21 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>='2023-12-20 21:00:00' AND g.time<='2023-12-21 03:00:00' AND g.DeviceLoginName='2499' GROUP BY  g.time, g.Distance;
CountAzimuth:48
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-21 23:0:0' AND e.date<='2023-12-22 5:0:0' AND e.DeviceLoginName='4964' 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>='2023-12-21 21:00:00' AND g.time<='2023-12-22 03:00:00' AND g.DeviceLoginName='4964' GROUP BY  g.time, g.Distance;
CountAzimuth:366
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-21 23:0:0' AND e.date<='2023-12-22 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>='2023-12-21 21:00:00' AND g.time<='2023-12-22 03:00:00' AND g.DeviceLoginName='4849' GROUP BY  g.time, g.Distance;
CountAzimuth:128
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-21 23:0:0' AND e.date<='2023-12-22 5:0:0' AND e.DeviceLoginName='2920' 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>='2023-12-21 21:00:00' AND g.time<='2023-12-22 03:00:00' AND g.DeviceLoginName='2920' GROUP BY  g.time, g.Distance;
CountAzimuth:37
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-21 23:0:0' AND e.date<='2023-12-22 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>='2023-12-21 21:00:00' AND g.time<='2023-12-22 03:00:00' AND g.DeviceLoginName='3045' GROUP BY  g.time, g.Distance;
CountAzimuth:36
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-21 23:0:0' AND e.date<='2023-12-22 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>='2023-12-21 21:00:00' AND g.time<='2023-12-22 03:00:00' AND g.DeviceLoginName='354836080152241' GROUP BY  g.time, g.Distance;
CountAzimuth:23
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-21 23:0:0' AND e.date<='2023-12-22 5:0:0' AND e.DeviceLoginName='2703' 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>='2023-12-21 21:00:00' AND g.time<='2023-12-22 03:00:00' AND g.DeviceLoginName='2703' GROUP BY  g.time, g.Distance;
CountAzimuth:6
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-21 23:0:0' AND e.date<='2023-12-22 5:0:0' AND e.DeviceLoginName='2461' 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>='2023-12-21 21:00:00' AND g.time<='2023-12-22 03:00:00' AND g.DeviceLoginName='2461' GROUP BY  g.time, g.Distance;
CountAzimuth:48
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-21 23:0:0' AND e.date<='2023-12-22 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>='2023-12-21 21:00:00' AND g.time<='2023-12-22 03:00:00' AND g.DeviceLoginName='4861' GROUP BY  g.time, g.Distance;
CountAzimuth:274
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-21 23:0:0' AND e.date<='2023-12-22 5:0:0' AND e.DeviceLoginName='2506' 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>='2023-12-21 21:00:00' AND g.time<='2023-12-22 03:00:00' AND g.DeviceLoginName='2506' GROUP BY  g.time, g.Distance;
CountAzimuth:21
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-21 23:0:0' AND e.date<='2023-12-22 5:0:0' AND e.DeviceLoginName='2486' 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>='2023-12-21 21:00:00' AND g.time<='2023-12-22 03:00:00' AND g.DeviceLoginName='2486' GROUP BY  g.time, g.Distance;
CountAzimuth:186
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-21 23:0:0' AND e.date<='2023-12-22 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>='2023-12-21 21:00:00' AND g.time<='2023-12-22 03:00:00' AND g.DeviceLoginName='4862' GROUP BY  g.time, g.Distance;
CountAzimuth:241
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-21 23:0:0' AND e.date<='2023-12-22 5:0:0' AND e.DeviceLoginName='2647' 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>='2023-12-21 21:00:00' AND g.time<='2023-12-22 03:00:00' AND g.DeviceLoginName='2647' GROUP BY  g.time, g.Distance;
CountAzimuth:14
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-21 23:0:0' AND e.date<='2023-12-22 5:0:0' AND e.DeviceLoginName='352353083499175' 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>='2023-12-21 21:00:00' AND g.time<='2023-12-22 03:00:00' AND g.DeviceLoginName='352353083499175' GROUP BY  g.time, g.Distance;
CountAzimuth:107
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-21 23:0:0' AND e.date<='2023-12-22 5:0:0' AND e.DeviceLoginName='2560' 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>='2023-12-21 21:00:00' AND g.time<='2023-12-22 03:00:00' AND g.DeviceLoginName='2560' GROUP BY  g.time, g.Distance;
CountAzimuth:46
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-21 23:0:0' AND e.date<='2023-12-22 5:0:0' AND e.DeviceLoginName='2762' 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>='2023-12-21 21:00:00' AND g.time<='2023-12-22 03:00:00' AND g.DeviceLoginName='2762' GROUP BY  g.time, g.Distance;
CountAzimuth:588
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-22 23:0:0' AND e.date<='2023-12-23 5:0:0' AND e.DeviceLoginName='3098' 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>='2023-12-22 21:00:00' AND g.time<='2023-12-23 03:00:00' AND g.DeviceLoginName='3098' GROUP BY  g.time, g.Distance;
CountAzimuth:63
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-22 23:0:0' AND e.date<='2023-12-23 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>='2023-12-22 21:00:00' AND g.time<='2023-12-23 03:00:00' AND g.DeviceLoginName='8992' GROUP BY  g.time, g.Distance;
CountAzimuth:558
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-22 23:0:0' AND e.date<='2023-12-23 5:0:0' AND e.DeviceLoginName='4964' 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>='2023-12-22 21:00:00' AND g.time<='2023-12-23 03:00:00' AND g.DeviceLoginName='4964' GROUP BY  g.time, g.Distance;
CountAzimuth:535
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-22 23:0:0' AND e.date<='2023-12-23 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>='2023-12-22 21:00:00' AND g.time<='2023-12-23 03:00:00' AND g.DeviceLoginName='4849' GROUP BY  g.time, g.Distance;
CountAzimuth:217
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-22 23:0:0' AND e.date<='2023-12-23 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>='2023-12-22 21:00:00' AND g.time<='2023-12-23 03:00:00' AND g.DeviceLoginName='4966' GROUP BY  g.time, g.Distance;
CountAzimuth:12
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-22 23:0:0' AND e.date<='2023-12-23 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>='2023-12-22 21:00:00' AND g.time<='2023-12-23 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>='2023-12-22 23:0:0' AND e.date<='2023-12-23 5:0:0' AND e.DeviceLoginName='5117' 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>='2023-12-22 21:00:00' AND g.time<='2023-12-23 03:00:00' AND g.DeviceLoginName='5117' GROUP BY  g.time, g.Distance;
CountAzimuth:320
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-22 23:0:0' AND e.date<='2023-12-23 5:0:0' AND e.DeviceLoginName='5136' 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>='2023-12-22 21:00:00' AND g.time<='2023-12-23 03:00:00' AND g.DeviceLoginName='5136' GROUP BY  g.time, g.Distance;
CountAzimuth:384
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-22 23:0:0' AND e.date<='2023-12-23 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>='2023-12-22 21:00:00' AND g.time<='2023-12-23 03:00:00' AND g.DeviceLoginName='4861' GROUP BY  g.time, g.Distance;
CountAzimuth:92
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-22 23:0:0' AND e.date<='2023-12-23 5:0:0' AND e.DeviceLoginName='2713' 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>='2023-12-22 21:00:00' AND g.time<='2023-12-23 03:00:00' AND g.DeviceLoginName='2713' GROUP BY  g.time, g.Distance;
CountAzimuth:136
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-22 23:0:0' AND e.date<='2023-12-23 5:0:0' AND e.DeviceLoginName='355234055521542' 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>='2023-12-22 21:00:00' AND g.time<='2023-12-23 03:00:00' AND g.DeviceLoginName='355234055521542' GROUP BY  g.time, g.Distance;
CountAzimuth:73
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-22 23:0:0' AND e.date<='2023-12-23 5:0:0' AND e.DeviceLoginName='2580' 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>='2023-12-22 21:00:00' AND g.time<='2023-12-23 03:00:00' AND g.DeviceLoginName='2580' GROUP BY  g.time, g.Distance;
CountAzimuth:546
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-22 23:0:0' AND e.date<='2023-12-23 5:0:0' AND e.DeviceLoginName='2560' 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>='2023-12-22 21:00:00' AND g.time<='2023-12-23 03:00:00' AND g.DeviceLoginName='2560' GROUP BY  g.time, g.Distance;
CountAzimuth:70
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-22 23:0:0' AND e.date<='2023-12-23 5:0:0' 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>='2023-12-22 21:00:00' AND g.time<='2023-12-23 03:00:00' AND g.DeviceLoginName='356078111293896' GROUP BY  g.time, g.Distance;
CountAzimuth:125
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-22 23:0:0' AND e.date<='2023-12-23 5:0:0' AND e.DeviceLoginName='2762' 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>='2023-12-22 21:00:00' AND g.time<='2023-12-23 03:00:00' AND g.DeviceLoginName='2762' GROUP BY  g.time, g.Distance;
CountAzimuth:156