Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-09 0:54:56' AND e.date<='2024-02-09 7:54:56' 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-02-08 22:54:56' AND g.time<='2024-02-09 05:54:56' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:237
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-08 0:55:31' AND e.date<='2024-02-08 23:55:31' 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-02-07 22:55:31' AND g.time<='2024-02-08 21:55:31' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:1493
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-08 7:58:37' AND e.date<='2024-02-08 23:58:37' 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-02-08 05:58:37' AND g.time<='2024-02-08 21:58:37' AND g.DeviceLoginName='2556' GROUP BY  g.time, g.Distance;
CountAzimuth:221
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-08 7:59:18' AND e.date<='2024-02-08 23:59:18' AND e.DeviceLoginName='358021081803706' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.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-02-08 05:59:18' AND g.time<='2024-02-08 21:59:18' AND g.DeviceLoginName='358021081803706' GROUP BY  g.time, g.Distance;
CountAzimuth:440
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-08 8:0:15' AND e.date<='2024-02-08 23:0:15' 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-02-08 06:00:15' AND g.time<='2024-02-08 21:00:15' AND g.DeviceLoginName='2473' GROUP BY  g.time, g.Distance;
CountAzimuth:1482
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-09 2:1:8' AND e.date<='2024-02-09 8:1:8' AND e.DeviceLoginName='358021081803706' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.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-02-09 00:01:08' AND g.time<='2024-02-09 06:01:08' AND g.DeviceLoginName='358021081803706' GROUP BY  g.time, g.Distance;
CountAzimuth:227
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-09 8:0:3' AND e.date<='2024-02-09 9:0:3' 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-02-09 06:00:03' AND g.time<='2024-02-09 07:00:03' AND g.DeviceLoginName='2585' GROUP BY  g.time, g.Distance;
CountAzimuth:128
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-05 23:0:0' AND e.date<='2024-02-06 5:0:0' AND e.DeviceLoginName='862531041078313' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.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-02-05 21:00:00' AND g.time<='2024-02-06 03:00:00' AND g.DeviceLoginName='862531041078313' GROUP BY  g.time, g.Distance;
CountAzimuth:8
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-05 23:0:0' AND e.date<='2024-02-06 5:0:0' AND e.DeviceLoginName='9376' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.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-02-05 21:00:00' AND g.time<='2024-02-06 03:00:00' AND g.DeviceLoginName='9376' GROUP BY  g.time, g.Distance;
CountAzimuth:75
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-05 23:0:0' AND e.date<='2024-02-06 5:0:0' AND e.DeviceLoginName='4962' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.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-02-05 21:00:00' AND g.time<='2024-02-06 03:00:00' AND g.DeviceLoginName='4962' GROUP BY  g.time, g.Distance;
CountAzimuth:181
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-05 23:0:0' AND e.date<='2024-02-06 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-02-05 21:00:00' AND g.time<='2024-02-06 03:00:00' AND g.DeviceLoginName='4964' GROUP BY  g.time, g.Distance;
CountAzimuth:137
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-05 23:0:0' AND e.date<='2024-02-06 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-02-05 21:00:00' AND g.time<='2024-02-06 03:00:00' AND g.DeviceLoginName='4849' GROUP BY  g.time, g.Distance;
CountAzimuth:233
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-05 23:0:0' AND e.date<='2024-02-06 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-02-05 21:00:00' AND g.time<='2024-02-06 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>='2024-02-05 23:0:0' AND e.date<='2024-02-06 5:0:0' AND e.DeviceLoginName='4825' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.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-02-05 21:00:00' AND g.time<='2024-02-06 03:00:00' AND g.DeviceLoginName='4825' GROUP BY  g.time, g.Distance;
CountAzimuth:2
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-05 23:0:0' AND e.date<='2024-02-06 5:0:0' AND e.DeviceLoginName='3086' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.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-02-05 21:00:00' AND g.time<='2024-02-06 03:00:00' AND g.DeviceLoginName='3086' GROUP BY  g.time, g.Distance;
CountAzimuth:189
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-05 23:0:0' AND e.date<='2024-02-06 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-02-05 21:00:00' AND g.time<='2024-02-06 03:00:00' AND g.DeviceLoginName='4862' GROUP BY  g.time, g.Distance;
CountAzimuth:246
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-05 23:0:0' AND e.date<='2024-02-06 5:0:0' AND e.DeviceLoginName='3121' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.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-02-05 21:00:00' AND g.time<='2024-02-06 03:00:00' AND g.DeviceLoginName='3121' GROUP BY  g.time, g.Distance;
CountAzimuth:228
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-05 23:0:0' AND e.date<='2024-02-06 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-02-05 21:00:00' AND g.time<='2024-02-06 03:00:00' AND g.DeviceLoginName='2585' GROUP BY  g.time, g.Distance;
CountAzimuth:36
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-05 23:0:0' AND e.date<='2024-02-06 5:0:0' AND e.DeviceLoginName='3156' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.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-02-05 21:00:00' AND g.time<='2024-02-06 03:00:00' AND g.DeviceLoginName='3156' GROUP BY  g.time, g.Distance;
CountAzimuth:403
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-05 23:0:0' AND e.date<='2024-02-06 5:0:0' AND e.DeviceLoginName='2556' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-02-05 21:00:00' AND g.time<='2024-02-06 03:00:00' AND g.DeviceLoginName='2556' GROUP BY  g.time, g.Distance;
CountAzimuth:3
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-05 23:0:0' AND e.date<='2024-02-06 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-02-05 21:00:00' AND g.time<='2024-02-06 03:00:00' AND g.DeviceLoginName='353173060497698' GROUP BY  g.time, g.Distance;
CountAzimuth:15
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-06 23:0:0' AND e.date<='2024-02-07 5:0:0' AND e.DeviceLoginName='4962' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.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-02-06 21:00:00' AND g.time<='2024-02-07 03:00:00' AND g.DeviceLoginName='4962' GROUP BY  g.time, g.Distance;
CountAzimuth:205
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-06 23:0:0' AND e.date<='2024-02-07 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-02-06 21:00:00' AND g.time<='2024-02-07 03:00:00' AND g.DeviceLoginName='4964' GROUP BY  g.time, g.Distance;
CountAzimuth:156
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-06 23:0:0' AND e.date<='2024-02-07 5:0:0' AND e.DeviceLoginName='2974' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.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-02-06 21:00:00' AND g.time<='2024-02-07 03:00:00' AND g.DeviceLoginName='2974' GROUP BY  g.time, g.Distance;
CountAzimuth:7
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-06 23:0:0' AND e.date<='2024-02-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-02-06 21:00:00' AND g.time<='2024-02-07 03:00:00' AND g.DeviceLoginName='5117' GROUP BY  g.time, g.Distance;
CountAzimuth:413
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-06 23:0:0' AND e.date<='2024-02-07 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>='2024-02-06 21:00:00' AND g.time<='2024-02-07 03:00:00' AND g.DeviceLoginName='5136' GROUP BY  g.time, g.Distance;
CountAzimuth:257
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-06 23:0:0' AND e.date<='2024-02-07 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-02-06 21:00:00' AND g.time<='2024-02-07 03:00:00' AND g.DeviceLoginName='3124' GROUP BY  g.time, g.Distance;
CountAzimuth:185
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-06 23:0:0' AND e.date<='2024-02-07 5:0:0' AND e.DeviceLoginName='3086' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.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-02-06 21:00:00' AND g.time<='2024-02-07 03:00:00' AND g.DeviceLoginName='3086' GROUP BY  g.time, g.Distance;
CountAzimuth:281
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-06 23:0:0' AND e.date<='2024-02-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-02-06 21:00:00' AND g.time<='2024-02-07 03:00:00' AND g.DeviceLoginName='4862' GROUP BY  g.time, g.Distance;
CountAzimuth:255
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-06 23:0:0' AND e.date<='2024-02-07 5:0:0' AND e.DeviceLoginName='5126' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.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-02-06 21:00:00' AND g.time<='2024-02-07 03:00:00' AND g.DeviceLoginName='5126' GROUP BY  g.time, g.Distance;
CountAzimuth:25
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-06 23:0:0' AND e.date<='2024-02-07 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>='2024-02-06 21:00:00' AND g.time<='2024-02-07 03:00:00' AND g.DeviceLoginName='2878' GROUP BY  g.time, g.Distance;
CountAzimuth:290
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-07 23:0:0' AND e.date<='2024-02-08 5:0:0' AND e.DeviceLoginName='8997' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.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-02-07 21:00:00' AND g.time<='2024-02-08 03:00:00' AND g.DeviceLoginName='8997' GROUP BY  g.time, g.Distance;
CountAzimuth:87
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-07 23:0:0' AND e.date<='2024-02-08 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-02-07 21:00:00' AND g.time<='2024-02-08 03:00:00' AND g.DeviceLoginName='4849' GROUP BY  g.time, g.Distance;
CountAzimuth:319
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-07 23:0:0' AND e.date<='2024-02-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-02-07 21:00:00' AND g.time<='2024-02-08 03:00:00' AND g.DeviceLoginName='5117' GROUP BY  g.time, g.Distance;
CountAzimuth:225
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-07 23:0:0' AND e.date<='2024-02-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-02-07 21:00:00' AND g.time<='2024-02-08 03:00:00' AND g.DeviceLoginName='2838' GROUP BY  g.time, g.Distance;
CountAzimuth:82
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-07 23:0:0' AND e.date<='2024-02-08 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-02-07 21:00:00' AND g.time<='2024-02-08 03:00:00' AND g.DeviceLoginName='3124' GROUP BY  g.time, g.Distance;
CountAzimuth:365
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-07 23:0:0' AND e.date<='2024-02-08 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-02-07 21:00:00' AND g.time<='2024-02-08 03:00:00' AND g.DeviceLoginName='2470' GROUP BY  g.time, g.Distance;
CountAzimuth:795
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-07 23:0:0' AND e.date<='2024-02-08 5:0:0' AND e.DeviceLoginName='2662' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-02-07 21:00:00' AND g.time<='2024-02-08 03:00:00' AND g.DeviceLoginName='2662' GROUP BY  g.time, g.Distance;
CountAzimuth:93
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-07 23:0:0' AND e.date<='2024-02-08 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-02-07 21:00:00' AND g.time<='2024-02-08 03:00:00' AND g.DeviceLoginName='4862' GROUP BY  g.time, g.Distance;
CountAzimuth:257
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-07 23:0:0' AND e.date<='2024-02-08 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>='2024-02-07 21:00:00' AND g.time<='2024-02-08 03:00:00' AND g.DeviceLoginName='2713' GROUP BY  g.time, g.Distance;
CountAzimuth:157
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-07 23:0:0' AND e.date<='2024-02-08 5:0:0' AND e.DeviceLoginName='352353083458635' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-02-07 21:00:00' AND g.time<='2024-02-08 03:00:00' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:363
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-07 23:0:0' AND e.date<='2024-02-08 5:0:0' AND e.DeviceLoginName='2556' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-02-07 21:00:00' AND g.time<='2024-02-08 03:00:00' AND g.DeviceLoginName='2556' GROUP BY  g.time, g.Distance;
CountAzimuth:43
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-07 23:0:0' AND e.date<='2024-02-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-02-07 21:00:00' AND g.time<='2024-02-08 03:00:00' AND g.DeviceLoginName='2499' GROUP BY  g.time, g.Distance;
CountAzimuth:24
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-08 23:0:0' AND e.date<='2024-02-09 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-02-08 21:00:00' AND g.time<='2024-02-09 03:00:00' AND g.DeviceLoginName='4964' GROUP BY  g.time, g.Distance;
CountAzimuth:882
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-08 23:0:0' AND e.date<='2024-02-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-02-08 21:00:00' AND g.time<='2024-02-09 03:00:00' AND g.DeviceLoginName='4849' GROUP BY  g.time, g.Distance;
CountAzimuth:258
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-08 23:0:0' AND e.date<='2024-02-09 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-02-08 21:00:00' AND g.time<='2024-02-09 03:00:00' AND g.DeviceLoginName='3157' GROUP BY  g.time, g.Distance;
CountAzimuth:166
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-08 23:0:0' AND e.date<='2024-02-09 5:0:0' AND e.DeviceLoginName='353173060512918' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.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-02-08 21:00:00' AND g.time<='2024-02-09 03:00:00' AND g.DeviceLoginName='353173060512918' GROUP BY  g.time, g.Distance;
CountAzimuth:205
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-08 23:0:0' AND e.date<='2024-02-09 5:0:0' AND e.DeviceLoginName='5082' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.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-02-08 21:00:00' AND g.time<='2024-02-09 03:00:00' AND g.DeviceLoginName='5082' GROUP BY  g.time, g.Distance;
CountAzimuth:147
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-08 23:0:0' AND e.date<='2024-02-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-02-08 21:00:00' AND g.time<='2024-02-09 03:00:00' AND g.DeviceLoginName='5117' GROUP BY  g.time, g.Distance;
CountAzimuth:170
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-08 23:0:0' AND e.date<='2024-02-09 5:0:0' AND e.DeviceLoginName='2662' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-02-08 21:00:00' AND g.time<='2024-02-09 03:00:00' AND g.DeviceLoginName='2662' GROUP BY  g.time, g.Distance;
CountAzimuth:92
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-08 23:0:0' AND e.date<='2024-02-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-02-08 21:00:00' AND g.time<='2024-02-09 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-02-08 23:0:0' AND e.date<='2024-02-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-02-08 21:00:00' AND g.time<='2024-02-09 03:00:00' AND g.DeviceLoginName='3179' GROUP BY  g.time, g.Distance;
CountAzimuth:12
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-08 23:0:0' AND e.date<='2024-02-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-02-08 21:00:00' AND g.time<='2024-02-09 03:00:00' AND g.DeviceLoginName='353173060497698' GROUP BY  g.time, g.Distance;
CountAzimuth:13
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-08 23:0:0' AND e.date<='2024-02-09 5:0:0' AND e.DeviceLoginName='9015' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.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-02-08 21:00:00' AND g.time<='2024-02-09 03:00:00' AND g.DeviceLoginName='9015' GROUP BY  g.time, g.Distance;
CountAzimuth:350
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-08 23:0:0' AND e.date<='2024-02-09 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-02-08 21:00:00' AND g.time<='2024-02-09 03:00:00' AND g.DeviceLoginName='8983' GROUP BY  g.time, g.Distance;
CountAzimuth:195
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-05 21:0:0' AND e.date<='2024-02-05 22: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-02-05 19:00:00' AND g.time<='2024-02-05 20:00:00' AND g.DeviceLoginName='353173060497698' GROUP BY  g.time, g.Distance;
CountAzimuth:54
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-07 8:0:0' AND e.date<='2024-02-07 9:0:0' AND e.DeviceLoginName='2577' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.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-02-07 06:00:00' AND g.time<='2024-02-07 07:00:00' AND g.DeviceLoginName='2577' GROUP BY  g.time, g.Distance;
CountAzimuth:19
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-07 11:0:0' AND e.date<='2024-02-07 12:0:0' AND e.DeviceLoginName='352353084209250' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.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-02-07 09:00:00' AND g.time<='2024-02-07 10:00:00' AND g.DeviceLoginName='352353084209250' GROUP BY  g.time, g.Distance;
CountAzimuth:143
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-07 13:0:0' AND e.date<='2024-02-07 14:0:0' AND e.DeviceLoginName='2953' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.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-02-07 11:00:00' AND g.time<='2024-02-07 12:00:00' AND g.DeviceLoginName='2953' GROUP BY  g.time, g.Distance;
CountAzimuth:723
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-09 0:39:47' AND e.date<='2024-02-09 10:39:47' 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-02-08 22:39:47' AND g.time<='2024-02-09 08:39:47' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:347
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-09 0:13:25' AND e.date<='2024-02-09 11:13:25' 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-02-08 22:13:25' AND g.time<='2024-02-09 09:13:25' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:436
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-09 0:16:42' AND e.date<='2024-02-09 11:16:42' 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-02-08 22:16:42' AND g.time<='2024-02-09 09:16:42' AND g.DeviceLoginName='2473' GROUP BY  g.time, g.Distance;
CountAzimuth:425
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-09 2:29:53' AND e.date<='2024-02-09 13:29:53' AND e.DeviceLoginName='358021081803706' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.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-02-09 00:29:53' AND g.time<='2024-02-09 11:29:53' AND g.DeviceLoginName='358021081803706' GROUP BY  g.time, g.Distance;
CountAzimuth:231
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-09 3:6:35' AND e.date<='2024-02-09 14:6:35' 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-02-09 01:06:35' AND g.time<='2024-02-09 12:06:35' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:594
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-09 6:46:8' AND e.date<='2024-02-09 14:46:8' 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-02-09 04:46:08' AND g.time<='2024-02-09 12:46:08' AND g.DeviceLoginName='2473' GROUP BY  g.time, g.Distance;
CountAzimuth:812
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-09 5:13:41' AND e.date<='2024-02-09 15:13:41' 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-02-09 03:13:41' AND g.time<='2024-02-09 13:13:41' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:636
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-09 3:14:18' AND e.date<='2024-02-09 15:14:18' 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-02-09 01:14:18' AND g.time<='2024-02-09 13:14:18' AND g.DeviceLoginName='2473' GROUP BY  g.time, g.Distance;
CountAzimuth:949
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-09 10:14:45' AND e.date<='2024-02-09 15:14:45' AND e.DeviceLoginName='3056' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.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-02-09 08:14:45' AND g.time<='2024-02-09 13:14:45' AND g.DeviceLoginName='3056' GROUP BY  g.time, g.Distance;
CountAzimuth:829
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-09 0:36:31' AND e.date<='2024-02-09 15:36:31' AND e.DeviceLoginName='2916' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.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-02-08 22:36:31' AND g.time<='2024-02-09 13:36:31' AND g.DeviceLoginName='2916' GROUP BY  g.time, g.Distance;
CountAzimuth:0