Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-09 0:44:13' AND e.date<='2024-12-09 8:44:13' 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>='2024-12-08 22:44:13' AND g.time<='2024-12-09 06:44:13' AND g.DeviceLoginName='4868' GROUP BY  g.time, g.Distance;
CountAzimuth:280
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-08 0:46:56' AND e.date<='2024-12-08 23:46:56' AND e.DeviceLoginName='2709' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.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-07 22:46:56' AND g.time<='2024-12-08 21:46:56' AND g.DeviceLoginName='2709' GROUP BY  g.time, g.Distance;
CountAzimuth:72
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-07 0:47:52' AND e.date<='2024-12-07 23:47:52' AND e.DeviceLoginName='2709' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.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:47:52' AND g.time<='2024-12-07 21:47:52' AND g.DeviceLoginName='2709' GROUP BY  g.time, g.Distance;
CountAzimuth:697
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-08 8:50:43' AND e.date<='2024-12-08 23:50:43' AND e.DeviceLoginName='2709' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.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 06:50:43' AND g.time<='2024-12-08 21:50:43' AND g.DeviceLoginName='2709' GROUP BY  g.time, g.Distance;
CountAzimuth:72
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-08 9:2:48' AND e.date<='2024-12-09 9:2:48' 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-12-08 07:02:48' AND g.time<='2024-12-09 07:02:48' AND g.DeviceLoginName='2684' GROUP BY  g.time, g.Distance;
CountAzimuth:817
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-08 9:6:28' AND e.date<='2024-12-09 9:6:28' 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-12-08 07:06:28' AND g.time<='2024-12-09 07:06:28' AND g.DeviceLoginName='2684' GROUP BY  g.time, g.Distance;
CountAzimuth:821
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-02 0:21:5' AND e.date<='2024-12-02 23:21:5' AND e.DeviceLoginName='2526' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-12-01 22:21:05' AND g.time<='2024-12-02 21:21:05' AND g.DeviceLoginName='2526' GROUP BY  g.time, g.Distance;
CountAzimuth:1804
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude FROM  tms_gpsdata_fixed g WHERE g.time>='2024-12-08 22:00:00' AND g.time<='2024-12-09 07:35:03' AND g.DeviceLoginName='352353086184048'
Method:GetStops; Query:SELECT e.date,e.EventType FROM tms_events e WHERE e.DeviceLoginName='352353086184048' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-12-08 22:00:00' AND e.date<='2024-12-09 07:35:03'
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-07 0:20:4' AND e.date<='2024-12-07 23:20:4' AND e.DeviceLoginName='4884' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.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:20:04' AND g.time<='2024-12-07 21:20:04' AND g.DeviceLoginName='4884' GROUP BY  g.time, g.Distance;
CountAzimuth:255
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-09 0:21:5' AND e.date<='2024-12-09 11:21:5' AND e.DeviceLoginName='4884' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.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:21:05' AND g.time<='2024-12-09 09:21:05' AND g.DeviceLoginName='4884' GROUP BY  g.time, g.Distance;
CountAzimuth:258
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-09 0:10:2' AND e.date<='2024-12-09 12:10:2' 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-08 22:10:02' AND g.time<='2024-12-09 10:10:02' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:403
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-08 0:10:54' AND e.date<='2024-12-08 23:10:54' 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-07 22:10:54' AND g.time<='2024-12-08 21:10:54' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:656
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-09 0:13:35' AND e.date<='2024-12-09 12:13:35' 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-08 22:13:35' AND g.time<='2024-12-09 10:13:35' AND g.DeviceLoginName='2556' GROUP BY  g.time, g.Distance;
CountAzimuth:427
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-09 2:14:28' AND e.date<='2024-12-09 12:14:28' AND e.DeviceLoginName='354836080167561' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.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-09 00:14:28' AND g.time<='2024-12-09 10:14:28' AND g.DeviceLoginName='354836080167561' GROUP BY  g.time, g.Distance;
CountAzimuth:263
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-07 5:15:21' AND e.date<='2024-12-07 22:15:21' 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-07 03:15:21' AND g.time<='2024-12-07 20:15:21' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:74
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-04 0:4:57' AND e.date<='2024-12-04 23:4:57' AND e.DeviceLoginName='2557' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.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-03 22:04:57' AND g.time<='2024-12-04 21:04:57' AND g.DeviceLoginName='2557' GROUP BY  g.time, g.Distance;
CountAzimuth:2
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-05 0:4:57' AND e.date<='2024-12-05 23:4:57' AND e.DeviceLoginName='2557' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.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-04 22:04:57' AND g.time<='2024-12-05 21:04:57' AND g.DeviceLoginName='2557' GROUP BY  g.time, g.Distance;
CountAzimuth:0
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-06 0:4:57' AND e.date<='2024-12-06 23:4:57' AND e.DeviceLoginName='2557' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.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-05 22:04:57' AND g.time<='2024-12-06 21:04:57' AND g.DeviceLoginName='2557' GROUP BY  g.time, g.Distance;
CountAzimuth:914
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-03 0:4:57' AND e.date<='2024-12-06 23:4:57' AND e.DeviceLoginName='2557' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.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-02 22:04:57' AND g.time<='2024-12-06 21:04:57' AND g.DeviceLoginName='2557' GROUP BY  g.time, g.Distance;
CountAzimuth:2137
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-06 23:0:0' AND e.date<='2024-12-07 5:0:0' AND e.DeviceLoginName='4849' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-12-06 21:00:00' AND g.time<='2024-12-07 03:00:00' AND g.DeviceLoginName='4849' GROUP BY  g.time, g.Distance;
CountAzimuth:192
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-06 23:0:0' AND e.date<='2024-12-07 5:0:0' AND e.DeviceLoginName='4869' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.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 21:00:00' AND g.time<='2024-12-07 03:00:00' AND g.DeviceLoginName='4869' GROUP BY  g.time, g.Distance;
CountAzimuth:275
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-03 13:8:2' AND e.date<='2024-12-03 13:8:2' AND e.DeviceLoginName='2557' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.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-03 11:08:02' AND g.time<='2024-12-03 11:08:02' AND g.DeviceLoginName='2557' GROUP BY  g.time, g.Distance;
CountAzimuth:0
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-03 7:8:2' AND e.date<='2024-12-03 13:8:2' AND e.DeviceLoginName='2557' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.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-03 05:08:02' AND g.time<='2024-12-03 11:08:02' AND g.DeviceLoginName='2557' GROUP BY  g.time, g.Distance;
CountAzimuth:252
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-03 7:8:2' AND e.date<='2024-12-03 23:8:2' AND e.DeviceLoginName='2557' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.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-03 05:08:02' AND g.time<='2024-12-03 21:08:02' AND g.DeviceLoginName='2557' GROUP BY  g.time, g.Distance;
CountAzimuth:1214
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-06 23:0:0' AND e.date<='2024-12-07 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-12-06 21:00:00' AND g.time<='2024-12-07 03:00:00' AND g.DeviceLoginName='5117' GROUP BY  g.time, g.Distance;
CountAzimuth:207
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-06 23:0:0' AND e.date<='2024-12-07 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-06 21:00:00' AND g.time<='2024-12-07 03:00:00' AND g.DeviceLoginName='4861' GROUP BY  g.time, g.Distance;
CountAzimuth:31
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-06 23:0:0' AND e.date<='2024-12-07 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-06 21:00:00' AND g.time<='2024-12-07 03:00:00' AND g.DeviceLoginName='2470' GROUP BY  g.time, g.Distance;
CountAzimuth:38
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-06 23:0:0' AND e.date<='2024-12-07 5:0:0' AND e.DeviceLoginName='3162' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.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 21:00:00' AND g.time<='2024-12-07 03:00:00' AND g.DeviceLoginName='3162' GROUP BY  g.time, g.Distance;
CountAzimuth:192
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-06 23:0:0' AND e.date<='2024-12-07 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-06 21:00:00' AND g.time<='2024-12-07 03:00:00' AND g.DeviceLoginName='3092' GROUP BY  g.time, g.Distance;
CountAzimuth:171
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-06 23:0:0' AND e.date<='2024-12-07 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-06 21:00:00' AND g.time<='2024-12-07 03:00:00' AND g.DeviceLoginName='4862' GROUP BY  g.time, g.Distance;
CountAzimuth:218
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-06 23:0:0' AND e.date<='2024-12-07 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-06 21:00:00' AND g.time<='2024-12-07 03:00:00' AND g.DeviceLoginName='3061' GROUP BY  g.time, g.Distance;
CountAzimuth:370
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-06 23:0:0' AND e.date<='2024-12-07 5:0:0' AND e.DeviceLoginName='3033' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.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 21:00:00' AND g.time<='2024-12-07 03:00:00' AND g.DeviceLoginName='3033' GROUP BY  g.time, g.Distance;
CountAzimuth:68
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-08 13:45:56' AND e.date<='2024-12-09 13:45:56' AND e.DeviceLoginName='2557' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.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 11:45:56' AND g.time<='2024-12-09 11:45:56' AND g.DeviceLoginName='2557' GROUP BY  g.time, g.Distance;
CountAzimuth:714
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-02 13:46:35' AND e.date<='2024-12-08 13:46:35' AND e.DeviceLoginName='2948' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.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-02 11:46:35' AND g.time<='2024-12-08 11:46:35' AND g.DeviceLoginName='2948' GROUP BY  g.time, g.Distance;
CountAzimuth:5749
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-07 23:0:0' AND e.date<='2024-12-08 5:0:0' AND e.DeviceLoginName='9010' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-12-07 21:00:00' AND g.time<='2024-12-08 03:00:00' AND g.DeviceLoginName='9010' GROUP BY  g.time, g.Distance;
CountAzimuth:198
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-07 23:0:0' AND e.date<='2024-12-08 5:0:0' AND e.DeviceLoginName='3108' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.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-07 21:00:00' AND g.time<='2024-12-08 03:00:00' AND g.DeviceLoginName='3108' GROUP BY  g.time, g.Distance;
CountAzimuth:106
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-07 23:0:0' AND e.date<='2024-12-08 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-12-07 21:00:00' AND g.time<='2024-12-08 03:00:00' AND g.DeviceLoginName='5117' GROUP BY  g.time, g.Distance;
CountAzimuth:351
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-07 23:0:0' AND e.date<='2024-12-08 5:0:0' AND e.DeviceLoginName='2838' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.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-07 21:00:00' AND g.time<='2024-12-08 03:00:00' AND g.DeviceLoginName='2838' GROUP BY  g.time, g.Distance;
CountAzimuth:204
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-07 23:0:0' AND e.date<='2024-12-08 5:0:0' AND e.DeviceLoginName='352353086185359' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.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-07 21:00:00' AND g.time<='2024-12-08 03:00:00' AND g.DeviceLoginName='352353086185359' GROUP BY  g.time, g.Distance;
CountAzimuth:15
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-07 23:0:0' AND e.date<='2024-12-08 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-12-07 21:00:00' AND g.time<='2024-12-08 03:00:00' AND g.DeviceLoginName='2684' GROUP BY  g.time, g.Distance;
CountAzimuth:4
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-07 23:0:0' AND e.date<='2024-12-08 5:0:0' AND e.DeviceLoginName='3019' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.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-07 21:00:00' AND g.time<='2024-12-08 03:00:00' AND g.DeviceLoginName='3019' GROUP BY  g.time, g.Distance;
CountAzimuth:63
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-07 23:0:0' AND e.date<='2024-12-08 5:0:0' AND e.DeviceLoginName='2667' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.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-07 21:00:00' AND g.time<='2024-12-08 03:00:00' AND g.DeviceLoginName='2667' GROUP BY  g.time, g.Distance;
CountAzimuth:2445
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-07 23:0:0' AND e.date<='2024-12-08 5:0:0' AND e.DeviceLoginName='8983' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-12-07 21:00:00' AND g.time<='2024-12-08 03:00:00' AND g.DeviceLoginName='8983' GROUP BY  g.time, g.Distance;
CountAzimuth:214
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-07 23:0:0' AND e.date<='2024-12-08 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-07 21:00:00' AND g.time<='2024-12-08 03:00:00' AND g.DeviceLoginName='2499' GROUP BY  g.time, g.Distance;
CountAzimuth:23
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-07 23:0:0' AND e.date<='2024-12-08 5:0:0' AND e.DeviceLoginName='3197' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.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-07 21:00:00' AND g.time<='2024-12-08 03:00:00' AND g.DeviceLoginName='3197' GROUP BY  g.time, g.Distance;
CountAzimuth:10
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-08 23:0:0' AND e.date<='2024-12-09 5:0:0' AND e.DeviceLoginName='5131' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-12-08 21:00:00' AND g.time<='2024-12-09 03:00:00' AND g.DeviceLoginName='5131' GROUP BY  g.time, g.Distance;
CountAzimuth:3
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-08 23:0:0' AND e.date<='2024-12-09 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-08 21:00:00' AND g.time<='2024-12-09 03:00:00' AND g.DeviceLoginName='4849' GROUP BY  g.time, g.Distance;
CountAzimuth:255
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-08 23:0:0' AND e.date<='2024-12-09 5:0:0' 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>='2024-12-08 21:00:00' AND g.time<='2024-12-09 03:00:00' AND g.DeviceLoginName='3025' GROUP BY  g.time, g.Distance;
CountAzimuth:13
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-08 23:0:0' AND e.date<='2024-12-09 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-12-08 21:00:00' AND g.time<='2024-12-09 03:00:00' AND g.DeviceLoginName='5117' GROUP BY  g.time, g.Distance;
CountAzimuth:305
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-08 23:0:0' AND e.date<='2024-12-09 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-08 21:00:00' AND g.time<='2024-12-09 03:00:00' AND g.DeviceLoginName='5076' GROUP BY  g.time, g.Distance;
CountAzimuth:57
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-08 23:0:0' AND e.date<='2024-12-09 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-08 21:00:00' AND g.time<='2024-12-09 03:00:00' AND g.DeviceLoginName='4861' GROUP BY  g.time, g.Distance;
CountAzimuth:52
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-08 23:0:0' AND e.date<='2024-12-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-12-08 21:00:00' AND g.time<='2024-12-09 03:00:00' AND g.DeviceLoginName='2470' GROUP BY  g.time, g.Distance;
CountAzimuth:83
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-08 23:0:0' AND e.date<='2024-12-09 5:0:0' AND e.DeviceLoginName='356078116291713' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.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 21:00:00' AND g.time<='2024-12-09 03:00:00' AND g.DeviceLoginName='356078116291713' GROUP BY  g.time, g.Distance;
CountAzimuth:7
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-08 23:0:0' AND e.date<='2024-12-09 5:0:0' 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>='2024-12-08 21:00:00' AND g.time<='2024-12-09 03:00:00' AND g.DeviceLoginName='2743' GROUP BY  g.time, g.Distance;
CountAzimuth:6
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-05 8:30:0' AND e.date<='2024-12-05 9:30:37' AND e.DeviceLoginName='2714' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.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-05 06:30:00' AND g.time<='2024-12-05 07:30:37' AND g.DeviceLoginName='2714' GROUP BY  g.time, g.Distance;
CountAzimuth:676