Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-01 0:0:56' AND e.date<='2023-12-01 23:0:56' AND e.DeviceLoginName='2898' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.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-11-30 22:00:56' AND g.time<='2023-12-01 21:00:56' AND g.DeviceLoginName='2898' GROUP BY  g.time, g.Distance;
CountAzimuth:2056
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-02 0:0:56' AND e.date<='2023-12-02 23:0:56' AND e.DeviceLoginName='353173060485131' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.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-01 22:00:56' AND g.time<='2023-12-02 21:00:56' AND g.DeviceLoginName='353173060485131' GROUP BY  g.time, g.Distance;
CountAzimuth:88
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-02 0:6:56' AND e.date<='2023-12-02 23:6:56' 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>='2023-12-01 22:06:56' AND g.time<='2023-12-02 21:06:56' AND g.DeviceLoginName='2500' GROUP BY  g.time, g.Distance;
CountAzimuth:148
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-16 0:6:56' AND e.date<='2023-12-16 23:6:56' AND e.DeviceLoginName='3188' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.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-15 22:06:56' AND g.time<='2023-12-16 21:06:56' AND g.DeviceLoginName='3188' GROUP BY  g.time, g.Distance;
CountAzimuth:90
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-16 0:6:56' AND e.date<='2023-12-16 23:6:56' AND e.DeviceLoginName='2876' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.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-15 22:06:56' AND g.time<='2023-12-16 21:06:56' AND g.DeviceLoginName='2876' GROUP BY  g.time, g.Distance;
CountAzimuth:478
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-16 0:6:56' AND e.date<='2023-12-16 23:6:56' AND e.DeviceLoginName='355234055170423' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.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-15 22:06:56' AND g.time<='2023-12-16 21:06:56' AND g.DeviceLoginName='355234055170423' GROUP BY  g.time, g.Distance;
CountAzimuth:749
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-11-25 0:25:28' AND e.date<='2023-11-25 23:25:28' AND e.DeviceLoginName='2554' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.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-11-24 22:25:28' AND g.time<='2023-11-25 21:25:28' AND g.DeviceLoginName='2554' GROUP BY  g.time, g.Distance;
CountAzimuth:264
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-11-25 0:25:28' AND e.date<='2023-11-25 23:25:28' AND e.DeviceLoginName='3025' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.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-11-24 22:25:28' AND g.time<='2023-11-25 21:25:28' AND g.DeviceLoginName='3025' GROUP BY  g.time, g.Distance;
CountAzimuth:1417
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-11-25 0:25:28' AND e.date<='2023-11-25 23:25:28' AND e.DeviceLoginName='3126' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.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-11-24 22:25:28' AND g.time<='2023-11-25 21:25:28' AND g.DeviceLoginName='3126' GROUP BY  g.time, g.Distance;
CountAzimuth:102
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-11-25 0:25:28' AND e.date<='2023-11-25 23:25:28' AND e.DeviceLoginName='2743' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.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-11-24 22:25:28' AND g.time<='2023-11-25 21:25:28' AND g.DeviceLoginName='2743' GROUP BY  g.time, g.Distance;
CountAzimuth:171
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-11-26 0:25:28' AND e.date<='2023-11-26 23:25:28' 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>='2023-11-25 22:25:28' AND g.time<='2023-11-26 21:25:28' AND g.DeviceLoginName='3187' GROUP BY  g.time, g.Distance;
CountAzimuth:624
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-11-26 0:28:41' AND e.date<='2023-11-26 23:28:41' AND e.DeviceLoginName='2756' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.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-11-25 22:28:41' AND g.time<='2023-11-26 21:28:41' AND g.DeviceLoginName='2756' GROUP BY  g.time, g.Distance;
CountAzimuth:43
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-09 0:28:41' AND e.date<='2023-12-09 23:28:41' AND e.DeviceLoginName='3167' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.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-08 22:28:41' AND g.time<='2023-12-09 21:28:41' AND g.DeviceLoginName='3167' GROUP BY  g.time, g.Distance;
CountAzimuth:1409
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-23 0:28:41' AND e.date<='2023-12-23 23:28:41' AND e.DeviceLoginName='352353083473444' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.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 22:28:41' AND g.time<='2023-12-23 21:28:41' AND g.DeviceLoginName='352353083473444' GROUP BY  g.time, g.Distance;
CountAzimuth:529
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-24 0:28:41' AND e.date<='2023-12-24 23:28:41' AND e.DeviceLoginName='352353083473444' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.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-23 22:28:41' AND g.time<='2023-12-24 21:28:41' AND g.DeviceLoginName='352353083473444' GROUP BY  g.time, g.Distance;
CountAzimuth:620
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-16 0:28:41' AND e.date<='2023-12-16 23:28:41' 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>='2023-12-15 22:28:41' AND g.time<='2023-12-16 21:28:41' AND g.DeviceLoginName='3187' GROUP BY  g.time, g.Distance;
CountAzimuth:681
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-09 0:28:41' AND e.date<='2023-12-09 23:28:41' AND e.DeviceLoginName='3167' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.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-08 22:28:41' AND g.time<='2023-12-09 21:28:41' AND g.DeviceLoginName='3167' GROUP BY  g.time, g.Distance;
CountAzimuth:1409
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-10 0:28:41' AND e.date<='2023-12-10 23:28:41' AND e.DeviceLoginName='352353083473444' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.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-09 22:28:41' AND g.time<='2023-12-10 21:28:41' AND g.DeviceLoginName='352353083473444' GROUP BY  g.time, g.Distance;
CountAzimuth:677
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-25 7:30:20' AND e.date<='2023-12-25 11:30:20' AND e.DeviceLoginName='356078111472417' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.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-25 05:30:20' AND g.time<='2023-12-25 09:30:20' AND g.DeviceLoginName='356078111472417' GROUP BY  g.time, g.Distance;
CountAzimuth:372
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-22 2:40:23' AND e.date<='2023-12-22 23:59:23' 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 00:40:23' AND g.time<='2023-12-22 21:59:23' AND g.DeviceLoginName='2580' GROUP BY  g.time, g.Distance;
CountAzimuth:3200
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-23 23:0:0' AND e.date<='2023-12-24 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>='2023-12-23 21:00:00' AND g.time<='2023-12-24 03:00:00' AND g.DeviceLoginName='5130' GROUP BY  g.time, g.Distance;
CountAzimuth:179
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-23 23:0:0' AND e.date<='2023-12-24 5:0:0' AND e.DeviceLoginName='3079' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.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-23 21:00:00' AND g.time<='2023-12-24 03:00:00' AND g.DeviceLoginName='3079' GROUP BY  g.time, g.Distance;
CountAzimuth:411
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-23 23:0:0' AND e.date<='2023-12-24 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-23 21:00:00' AND g.time<='2023-12-24 03:00:00' AND g.DeviceLoginName='4964' GROUP BY  g.time, g.Distance;
CountAzimuth:548
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-23 23:0:0' AND e.date<='2023-12-24 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-23 21:00:00' AND g.time<='2023-12-24 03:00:00' AND g.DeviceLoginName='5078' GROUP BY  g.time, g.Distance;
CountAzimuth:155
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-23 23:0:0' AND e.date<='2023-12-24 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-23 21:00:00' AND g.time<='2023-12-24 03:00:00' AND g.DeviceLoginName='3045' GROUP BY  g.time, g.Distance;
CountAzimuth:414
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-24 23:0:0' AND e.date<='2023-12-25 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-24 21:00:00' AND g.time<='2023-12-25 03:00:00' AND g.DeviceLoginName='5078' GROUP BY  g.time, g.Distance;
CountAzimuth:165
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-24 23:0:0' AND e.date<='2023-12-25 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-24 21:00:00' AND g.time<='2023-12-25 03:00:00' AND g.DeviceLoginName='3045' GROUP BY  g.time, g.Distance;
CountAzimuth:49
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-24 23:0:0' AND e.date<='2023-12-25 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-24 21:00:00' AND g.time<='2023-12-25 03:00:00' AND g.DeviceLoginName='3045' GROUP BY  g.time, g.Distance;
CountAzimuth:49
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-24 23:0:0' AND e.date<='2023-12-25 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-24 21:00:00' AND g.time<='2023-12-25 03:00:00' AND g.DeviceLoginName='354836080152241' GROUP BY  g.time, g.Distance;
CountAzimuth:27
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-24 23:0:0' AND e.date<='2023-12-25 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>='2023-12-24 21:00:00' AND g.time<='2023-12-25 03:00:00' AND g.DeviceLoginName='2783' GROUP BY  g.time, g.Distance;
CountAzimuth:290
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-24 23:0:0' AND e.date<='2023-12-25 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-24 21:00:00' AND g.time<='2023-12-25 03:00:00' AND g.DeviceLoginName='4868' GROUP BY  g.time, g.Distance;
CountAzimuth:164