Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-11 16:4:35' AND e.date<='2024-01-11 23:4:35' AND e.DeviceLoginName='355234055698654' 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-01-11 14:04:35' AND g.time<='2024-01-11 21:04:35' AND g.DeviceLoginName='355234055698654' GROUP BY  g.time, g.Distance;
CountAzimuth:196
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-11 10:8:10' AND e.date<='2024-01-11 23:8:10' AND e.DeviceLoginName='9021' 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-01-11 08:08:10' AND g.time<='2024-01-11 21:08:10' AND g.DeviceLoginName='9021' GROUP BY  g.time, g.Distance;
CountAzimuth:2491
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-08 23:0:0' AND e.date<='2024-01-09 5:0:0' AND e.DeviceLoginName='3203' 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-01-08 21:00:00' AND g.time<='2024-01-09 03:00:00' AND g.DeviceLoginName='3203' GROUP BY  g.time, g.Distance;
CountAzimuth:342
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-08 23:0:0' AND e.date<='2024-01-09 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-01-08 21:00:00' AND g.time<='2024-01-09 03:00:00' AND g.DeviceLoginName='3064' GROUP BY  g.time, g.Distance;
CountAzimuth:5
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-08 23:0:0' AND e.date<='2024-01-09 5:0:0' AND e.DeviceLoginName='352353086184048' 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-01-08 21:00:00' AND g.time<='2024-01-09 03:00:00' AND g.DeviceLoginName='352353086184048' GROUP BY  g.time, g.Distance;
CountAzimuth:98
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-08 23:0:0' AND e.date<='2024-01-09 5:0:0' AND e.DeviceLoginName='2565' 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-01-08 21:00:00' AND g.time<='2024-01-09 03:00:00' AND g.DeviceLoginName='2565' GROUP BY  g.time, g.Distance;
CountAzimuth:56
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-08 23:0:0' AND e.date<='2024-01-09 5:0:0' AND e.DeviceLoginName='3158' 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-01-08 21:00:00' AND g.time<='2024-01-09 03:00:00' AND g.DeviceLoginName='3158' GROUP BY  g.time, g.Distance;
CountAzimuth:49
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-08 23:0:0' AND e.date<='2024-01-09 5:0:0' AND e.DeviceLoginName='353173060487970' 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-01-08 21:00:00' AND g.time<='2024-01-09 03:00:00' AND g.DeviceLoginName='353173060487970' GROUP BY  g.time, g.Distance;
CountAzimuth:77
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-08 23:0:0' AND e.date<='2024-01-09 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-01-08 21:00:00' AND g.time<='2024-01-09 03:00:00' AND g.DeviceLoginName='2783' GROUP BY  g.time, g.Distance;
CountAzimuth:819
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-08 23:0:0' AND e.date<='2024-01-09 5:0:0' AND e.DeviceLoginName='2844' 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-01-08 21:00:00' AND g.time<='2024-01-09 03:00:00' AND g.DeviceLoginName='2844' GROUP BY  g.time, g.Distance;
CountAzimuth:3
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-08 23:0:0' AND e.date<='2024-01-09 5:0:0' AND e.DeviceLoginName='3210' 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-01-08 21:00:00' AND g.time<='2024-01-09 03:00:00' AND g.DeviceLoginName='3210' GROUP BY  g.time, g.Distance;
CountAzimuth:2
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-08 23:0:0' AND e.date<='2024-01-09 5:0:0' AND e.DeviceLoginName='355234055748228' 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-01-08 21:00:00' AND g.time<='2024-01-09 03:00:00' AND g.DeviceLoginName='355234055748228' GROUP BY  g.time, g.Distance;
CountAzimuth:20
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-08 23:0:0' AND e.date<='2024-01-09 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-01-08 21:00:00' AND g.time<='2024-01-09 03:00:00' AND g.DeviceLoginName='2500' GROUP BY  g.time, g.Distance;
CountAzimuth:457
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-08 23:0:0' AND e.date<='2024-01-09 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-01-08 21:00:00' AND g.time<='2024-01-09 03:00:00' AND g.DeviceLoginName='3124' GROUP BY  g.time, g.Distance;
CountAzimuth:1176
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-08 23:0:0' AND e.date<='2024-01-09 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-01-08 21:00:00' AND g.time<='2024-01-09 03:00:00' AND g.DeviceLoginName='2470' GROUP BY  g.time, g.Distance;
CountAzimuth:383
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-08 23:0:0' AND e.date<='2024-01-09 5:0:0' AND e.DeviceLoginName='2684' 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-01-08 21:00:00' AND g.time<='2024-01-09 03:00:00' AND g.DeviceLoginName='2684' GROUP BY  g.time, g.Distance;
CountAzimuth:11
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-08 23:0:0' AND e.date<='2024-01-09 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-01-08 21:00:00' AND g.time<='2024-01-09 03:00:00' AND g.DeviceLoginName='4862' GROUP BY  g.time, g.Distance;
CountAzimuth:279
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-08 23:0:0' AND e.date<='2024-01-09 5:0:0' AND e.DeviceLoginName='2585' 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-01-08 21:00:00' AND g.time<='2024-01-09 03:00:00' AND g.DeviceLoginName='2585' GROUP BY  g.time, g.Distance;
CountAzimuth:47
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-08 23:0:0' AND e.date<='2024-01-09 5:0:0' AND e.DeviceLoginName='3179' 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-01-08 21:00:00' AND g.time<='2024-01-09 03:00:00' AND g.DeviceLoginName='3179' GROUP BY  g.time, g.Distance;
CountAzimuth:169
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-08 23:0:0' AND e.date<='2024-01-09 5:0:0' AND e.DeviceLoginName='2672' 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-01-08 21:00:00' AND g.time<='2024-01-09 03:00:00' AND g.DeviceLoginName='2672' GROUP BY  g.time, g.Distance;
CountAzimuth:5
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-08 23:0:0' AND e.date<='2024-01-09 5:0:0' AND e.DeviceLoginName='2889' 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-01-08 21:00:00' AND g.time<='2024-01-09 03:00:00' AND g.DeviceLoginName='2889' GROUP BY  g.time, g.Distance;
CountAzimuth:322
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-08 23:0:0' AND e.date<='2024-01-09 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-01-08 21:00:00' AND g.time<='2024-01-09 03:00:00' AND g.DeviceLoginName='353173060497698' GROUP BY  g.time, g.Distance;
CountAzimuth:47
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-08 23:0:0' AND e.date<='2024-01-09 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>='2024-01-08 21:00:00' AND g.time<='2024-01-09 03:00:00' AND g.DeviceLoginName='2550' GROUP BY  g.time, g.Distance;
CountAzimuth:9
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-08 23:0:0' AND e.date<='2024-01-09 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>='2024-01-08 21:00:00' AND g.time<='2024-01-09 03:00:00' AND g.DeviceLoginName='2580' GROUP BY  g.time, g.Distance;
CountAzimuth:144
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-08 23:0:0' AND e.date<='2024-01-09 5:0:0' AND e.DeviceLoginName='2707' 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-01-08 21:00:00' AND g.time<='2024-01-09 03:00:00' AND g.DeviceLoginName='2707' GROUP BY  g.time, g.Distance;
CountAzimuth:4
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-08 23:0:0' AND e.date<='2024-01-09 5:0:0' AND e.DeviceLoginName='352353083500956' 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-01-08 21:00:00' AND g.time<='2024-01-09 03:00:00' AND g.DeviceLoginName='352353083500956' GROUP BY  g.time, g.Distance;
CountAzimuth:67
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-08 23:0:0' AND e.date<='2024-01-09 5:0:0' AND e.DeviceLoginName='2752' 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-01-08 21:00:00' AND g.time<='2024-01-09 03:00:00' AND g.DeviceLoginName='2752' GROUP BY  g.time, g.Distance;
CountAzimuth:180
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-08 23:0:0' AND e.date<='2024-01-09 5:0:0' AND e.DeviceLoginName='2950' 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-01-08 21:00:00' AND g.time<='2024-01-09 03:00:00' AND g.DeviceLoginName='2950' GROUP BY  g.time, g.Distance;
CountAzimuth:3
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-08 23:0:0' AND e.date<='2024-01-09 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-01-08 21:00:00' AND g.time<='2024-01-09 03:00:00' AND g.DeviceLoginName='2888' GROUP BY  g.time, g.Distance;
CountAzimuth:181
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-09 23:0:0' AND e.date<='2024-01-10 5:0:0' AND e.DeviceLoginName='2652' 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-01-09 21:00:00' AND g.time<='2024-01-10 03:00:00' AND g.DeviceLoginName='2652' GROUP BY  g.time, g.Distance;
CountAzimuth:18
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-09 23:0:0' AND e.date<='2024-01-10 5:0:0' AND e.DeviceLoginName='2949' 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-01-09 21:00:00' AND g.time<='2024-01-10 03:00:00' AND g.DeviceLoginName='2949' GROUP BY  g.time, g.Distance;
CountAzimuth:178
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-09 23:0:0' AND e.date<='2024-01-10 5:0:0' AND e.DeviceLoginName='3081' 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-01-09 21:00:00' AND g.time<='2024-01-10 03:00:00' AND g.DeviceLoginName='3081' GROUP BY  g.time, g.Distance;
CountAzimuth:108
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-09 23:0:0' AND e.date<='2024-01-10 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-01-09 21:00:00' AND g.time<='2024-01-10 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-01-09 23:0:0' AND e.date<='2024-01-10 5:0:0' AND e.DeviceLoginName='353173060487970' 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-01-09 21:00:00' AND g.time<='2024-01-10 03:00:00' AND g.DeviceLoginName='353173060487970' GROUP BY  g.time, g.Distance;
CountAzimuth:70
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-09 23:0:0' AND e.date<='2024-01-10 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>='2024-01-09 21:00:00' AND g.time<='2024-01-10 03:00:00' AND g.DeviceLoginName='5117' GROUP BY  g.time, g.Distance;
CountAzimuth:146
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-09 23:0:0' AND e.date<='2024-01-10 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-01-09 21:00:00' AND g.time<='2024-01-10 03:00:00' AND g.DeviceLoginName='2500' GROUP BY  g.time, g.Distance;
CountAzimuth:655
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-09 23:0:0' AND e.date<='2024-01-10 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-01-09 21:00:00' AND g.time<='2024-01-10 03:00:00' AND g.DeviceLoginName='4862' GROUP BY  g.time, g.Distance;
CountAzimuth:56
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-09 23:0:0' AND e.date<='2024-01-10 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-01-09 21:00:00' AND g.time<='2024-01-10 03:00:00' AND g.DeviceLoginName='3061' GROUP BY  g.time, g.Distance;
CountAzimuth:28
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-09 23:0:0' AND e.date<='2024-01-10 5:0:0' AND e.DeviceLoginName='2496' 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-01-09 21:00:00' AND g.time<='2024-01-10 03:00:00' AND g.DeviceLoginName='2496' GROUP BY  g.time, g.Distance;
CountAzimuth:204
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-09 23:0:0' AND e.date<='2024-01-10 5:0:0' AND e.DeviceLoginName='2473' 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-01-09 21:00:00' AND g.time<='2024-01-10 03:00:00' AND g.DeviceLoginName='2473' GROUP BY  g.time, g.Distance;
CountAzimuth:2
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-09 23:0:0' AND e.date<='2024-01-10 5:0:0' AND e.DeviceLoginName='2707' 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-01-09 21:00:00' AND g.time<='2024-01-10 03:00:00' AND g.DeviceLoginName='2707' GROUP BY  g.time, g.Distance;
CountAzimuth:2
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-09 23:0:0' AND e.date<='2024-01-10 5:0:0' 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-01-09 21:00:00' AND g.time<='2024-01-10 03:00:00' AND g.DeviceLoginName='2908' GROUP BY  g.time, g.Distance;
CountAzimuth:4
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-09 23:0:0' AND e.date<='2024-01-10 5:0:0' AND e.DeviceLoginName='3047' 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-01-09 21:00:00' AND g.time<='2024-01-10 03:00:00' AND g.DeviceLoginName='3047' GROUP BY  g.time, g.Distance;
CountAzimuth:5
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-10 23:0:0' AND e.date<='2024-01-11 5:0:0' AND e.DeviceLoginName='2652' 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-01-10 21:00:00' AND g.time<='2024-01-11 03:00:00' AND g.DeviceLoginName='2652' GROUP BY  g.time, g.Distance;
CountAzimuth:48
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-10 23:0:0' AND e.date<='2024-01-11 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>='2024-01-10 21:00:00' AND g.time<='2024-01-11 03:00:00' AND g.DeviceLoginName='4964' GROUP BY  g.time, g.Distance;
CountAzimuth:413
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-10 23:0:0' AND e.date<='2024-01-11 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-01-10 21:00:00' AND g.time<='2024-01-11 03:00:00' AND g.DeviceLoginName='4849' GROUP BY  g.time, g.Distance;
CountAzimuth:207
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-10 23:0:0' AND e.date<='2024-01-11 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-01-10 21:00:00' AND g.time<='2024-01-11 03:00:00' AND g.DeviceLoginName='3157' GROUP BY  g.time, g.Distance;
CountAzimuth:146
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-10 23:0:0' AND e.date<='2024-01-11 5:0:0' AND e.DeviceLoginName='352353084234167' 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-01-10 21:00:00' AND g.time<='2024-01-11 03:00:00' AND g.DeviceLoginName='352353084234167' GROUP BY  g.time, g.Distance;
CountAzimuth:15
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-10 23:0:0' AND e.date<='2024-01-11 5:0:0' AND e.DeviceLoginName='353173060487970' 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-01-10 21:00:00' AND g.time<='2024-01-11 03:00:00' AND g.DeviceLoginName='353173060487970' GROUP BY  g.time, g.Distance;
CountAzimuth:91
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-10 23:0:0' AND e.date<='2024-01-11 5:0:0' AND e.DeviceLoginName='3091' 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-01-10 21:00:00' AND g.time<='2024-01-11 03:00:00' AND g.DeviceLoginName='3091' GROUP BY  g.time, g.Distance;
CountAzimuth:87
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-10 23:0:0' AND e.date<='2024-01-11 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-01-10 21:00:00' AND g.time<='2024-01-11 03:00:00' AND g.DeviceLoginName='2470' GROUP BY  g.time, g.Distance;
CountAzimuth:246
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-10 23:0:0' AND e.date<='2024-01-11 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-01-10 21:00:00' AND g.time<='2024-01-11 03:00:00' AND g.DeviceLoginName='9019' GROUP BY  g.time, g.Distance;
CountAzimuth:176
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-10 23:0:0' AND e.date<='2024-01-11 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-01-10 21:00:00' AND g.time<='2024-01-11 03:00:00' AND g.DeviceLoginName='4862' GROUP BY  g.time, g.Distance;
CountAzimuth:278
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-10 23:0:0' AND e.date<='2024-01-11 5:0:0' AND e.DeviceLoginName='3205' 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-01-10 21:00:00' AND g.time<='2024-01-11 03:00:00' AND g.DeviceLoginName='3205' GROUP BY  g.time, g.Distance;
CountAzimuth:106
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-11 7:0:0' AND e.date<='2024-01-12 10:28:45' AND e.DeviceLoginName='2949' 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-01-11 05:00:00' AND g.time<='2024-01-12 08:28:45' AND g.DeviceLoginName='2949' GROUP BY  g.time, g.Distance;
CountAzimuth:239
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-11 23:0:0' AND e.date<='2024-01-12 5:0:0' AND e.DeviceLoginName='2652' 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-01-11 21:00:00' AND g.time<='2024-01-12 03:00:00' AND g.DeviceLoginName='2652' GROUP BY  g.time, g.Distance;
CountAzimuth:212
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-11 23:0:0' AND e.date<='2024-01-12 5:0:0' AND e.DeviceLoginName='5130' 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-01-11 21:00:00' AND g.time<='2024-01-12 03:00:00' AND g.DeviceLoginName='5130' GROUP BY  g.time, g.Distance;
CountAzimuth:159
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-11 23:0:0' AND e.date<='2024-01-12 5:0:0' AND e.DeviceLoginName='2949' 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-01-11 21:00:00' AND g.time<='2024-01-12 03:00:00' AND g.DeviceLoginName='2949' GROUP BY  g.time, g.Distance;
CountAzimuth:207
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-11 23:0:0' AND e.date<='2024-01-12 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>='2024-01-11 21:00:00' AND g.time<='2024-01-12 03:00:00' AND g.DeviceLoginName='4964' GROUP BY  g.time, g.Distance;
CountAzimuth:400
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-11 23:0:0' AND e.date<='2024-01-12 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-01-11 21:00:00' AND g.time<='2024-01-12 03:00:00' AND g.DeviceLoginName='2883' GROUP BY  g.time, g.Distance;
CountAzimuth:148
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-11 23:0:0' AND e.date<='2024-01-12 5:0:0' AND e.DeviceLoginName='3081' 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-01-11 21:00:00' AND g.time<='2024-01-12 03:00:00' AND g.DeviceLoginName='3081' GROUP BY  g.time, g.Distance;
CountAzimuth:4
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-11 23:0:0' AND e.date<='2024-01-12 5:0:0' AND e.DeviceLoginName='352353084234167' 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-01-11 21:00:00' AND g.time<='2024-01-12 03:00:00' AND g.DeviceLoginName='352353084234167' GROUP BY  g.time, g.Distance;
CountAzimuth:13
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-11 23:0:0' AND e.date<='2024-01-12 5:0:0' AND e.DeviceLoginName='3023' 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-01-11 21:00:00' AND g.time<='2024-01-12 03:00:00' AND g.DeviceLoginName='3023' GROUP BY  g.time, g.Distance;
CountAzimuth:184
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-11 23:0:0' AND e.date<='2024-01-12 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-01-11 21:00:00' AND g.time<='2024-01-12 03:00:00' AND g.DeviceLoginName='2470' GROUP BY  g.time, g.Distance;
CountAzimuth:348
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-11 23:0:0' AND e.date<='2024-01-12 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-01-11 21:00:00' AND g.time<='2024-01-12 03:00:00' AND g.DeviceLoginName='4862' GROUP BY  g.time, g.Distance;
CountAzimuth:214
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-11 23:0:0' AND e.date<='2024-01-12 5:0:0' AND e.DeviceLoginName='3179' 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-01-11 21:00:00' AND g.time<='2024-01-12 03:00:00' AND g.DeviceLoginName='3179' GROUP BY  g.time, g.Distance;
CountAzimuth:23
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-11 23:0:0' AND e.date<='2024-01-12 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-01-11 21:00:00' AND g.time<='2024-01-12 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-01-11 23:0:0' AND e.date<='2024-01-12 5:0:0' AND e.DeviceLoginName='2723' 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-01-11 21:00:00' AND g.time<='2024-01-12 03:00:00' AND g.DeviceLoginName='2723' GROUP BY  g.time, g.Distance;
CountAzimuth:84
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-11 23:0:0' AND e.date<='2024-01-12 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>='2024-01-11 21:00:00' AND g.time<='2024-01-12 03:00:00' AND g.DeviceLoginName='2762' GROUP BY  g.time, g.Distance;
CountAzimuth:286
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-11 23:0:0' AND e.date<='2024-01-12 5:0:0' AND e.DeviceLoginName='3187' 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-01-11 21:00:00' AND g.time<='2024-01-12 03:00:00' AND g.DeviceLoginName='3187' GROUP BY  g.time, g.Distance;
CountAzimuth:137
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-11 7:0:0' AND e.date<='2024-01-12 10:37:14' 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-01-11 05:00:00' AND g.time<='2024-01-12 08:37:14' AND g.DeviceLoginName='353173060497698' GROUP BY  g.time, g.Distance;
CountAzimuth:55
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-12 17:55:49' AND e.date<='2024-01-12 17:55:49' AND e.DeviceLoginName='2456' 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-01-12 15:55:49' AND g.time<='2024-01-12 15:55:49' AND g.DeviceLoginName='2456' GROUP BY  g.time, g.Distance;
CountAzimuth:0