Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-14 0:16:15' AND e.date<='2024-06-14 23:16:15' AND e.DeviceLoginName='4966' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-06-13 21:16:15' AND g.time<='2024-06-14 20:16:15' AND g.DeviceLoginName='4966' GROUP BY  g.time, g.Distance;
CountAzimuth:2772
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-14 0:16:15' AND e.date<='2024-06-14 23:16:15' AND e.DeviceLoginName='356078111445637' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-06-13 21:16:15' AND g.time<='2024-06-14 20:16:15' AND g.DeviceLoginName='356078111445637' GROUP BY  g.time, g.Distance;
CountAzimuth:3946
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-15 2:19:4' AND e.date<='2024-06-17 10:19:4' AND e.DeviceLoginName='352353083458635' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-06-14 23:19:04' AND g.time<='2024-06-17 07:19:04' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:2746
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-15 0:41:6' AND e.date<='2024-06-16 23:41:6' AND e.DeviceLoginName='3187' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-06-14 21:41:06' AND g.time<='2024-06-16 20:41:06' AND g.DeviceLoginName='3187' GROUP BY  g.time, g.Distance;
CountAzimuth:1188
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-15 0:41:6' AND e.date<='2024-06-15 23:41:6' AND e.DeviceLoginName='3187' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-06-14 21:41:06' AND g.time<='2024-06-15 20:41:06' AND g.DeviceLoginName='3187' GROUP BY  g.time, g.Distance;
CountAzimuth:739
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-16 0:41:6' AND e.date<='2024-06-16 23:41:6' AND e.DeviceLoginName='3187' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-06-15 21:41:06' AND g.time<='2024-06-16 20:41:06' AND g.DeviceLoginName='3187' GROUP BY  g.time, g.Distance;
CountAzimuth:449
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-17 0:23:13' AND e.date<='2024-06-17 12:23:13' AND e.DeviceLoginName='352353083458635' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-06-16 21:23:13' AND g.time<='2024-06-17 09:23:13' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:317
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-14 23:0:0' AND e.date<='2024-06-15 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 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-06-14 20:00:00' AND g.time<='2024-06-15 02:00:00' AND g.DeviceLoginName='2652' GROUP BY  g.time, g.Distance;
CountAzimuth:11
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-14 23:0:0' AND e.date<='2024-06-15 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 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-06-14 20:00:00' AND g.time<='2024-06-15 02:00:00' AND g.DeviceLoginName='4849' GROUP BY  g.time, g.Distance;
CountAzimuth:298
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-14 23:0:0' AND e.date<='2024-06-15 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 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-06-14 20:00:00' AND g.time<='2024-06-15 02:00:00' AND g.DeviceLoginName='3157' GROUP BY  g.time, g.Distance;
CountAzimuth:227
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-14 23:0:0' AND e.date<='2024-06-15 5:0:0' AND e.DeviceLoginName='2761' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-06-14 20:00:00' AND g.time<='2024-06-15 02:00:00' AND g.DeviceLoginName='2761' GROUP BY  g.time, g.Distance;
CountAzimuth:177
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-14 23:0:0' AND e.date<='2024-06-15 5:0:0' AND e.DeviceLoginName='3055' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-06-14 20:00:00' AND g.time<='2024-06-15 02:00:00' AND g.DeviceLoginName='3055' GROUP BY  g.time, g.Distance;
CountAzimuth:133
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-14 23:0:0' AND e.date<='2024-06-15 5:0:0' AND e.DeviceLoginName='2506' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-06-14 20:00:00' AND g.time<='2024-06-15 02:00:00' AND g.DeviceLoginName='2506' GROUP BY  g.time, g.Distance;
CountAzimuth:94
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-14 23:0:0' AND e.date<='2024-06-15 5:0:0' AND e.DeviceLoginName='352353086167449' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-06-14 20:00:00' AND g.time<='2024-06-15 02:00:00' AND g.DeviceLoginName='352353086167449' GROUP BY  g.time, g.Distance;
CountAzimuth:210
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-14 23:0:0' AND e.date<='2024-06-15 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 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-06-14 20:00:00' AND g.time<='2024-06-15 02:00:00' AND g.DeviceLoginName='2580' GROUP BY  g.time, g.Distance;
CountAzimuth:180
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-14 23:0:0' AND e.date<='2024-06-15 5:0:0' AND e.DeviceLoginName='2763' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-06-14 20:00:00' AND g.time<='2024-06-15 02:00:00' AND g.DeviceLoginName='2763' GROUP BY  g.time, g.Distance;
CountAzimuth:284
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-14 23:0:0' AND e.date<='2024-06-15 5:0:0' AND e.DeviceLoginName='3032' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-06-14 20:00:00' AND g.time<='2024-06-15 02:00:00' AND g.DeviceLoginName='3032' GROUP BY  g.time, g.Distance;
CountAzimuth:1
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-14 23:0:0' AND e.date<='2024-06-15 5:0:0' AND e.DeviceLoginName='4819' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-06-14 20:00:00' AND g.time<='2024-06-15 02:00:00' AND g.DeviceLoginName='4819' GROUP BY  g.time, g.Distance;
CountAzimuth:4
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-15 23:0:0' AND e.date<='2024-06-16 5:0:0' AND e.DeviceLoginName='2689' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-06-15 20:00:00' AND g.time<='2024-06-16 02:00:00' AND g.DeviceLoginName='2689' GROUP BY  g.time, g.Distance;
CountAzimuth:158
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-15 23:0:0' AND e.date<='2024-06-16 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 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-06-15 20:00:00' AND g.time<='2024-06-16 02:00:00' AND g.DeviceLoginName='4849' GROUP BY  g.time, g.Distance;
CountAzimuth:224
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-15 23:0:0' AND e.date<='2024-06-16 5:0:0' AND e.DeviceLoginName='9014' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-06-15 20:00:00' AND g.time<='2024-06-16 02:00:00' AND g.DeviceLoginName='9014' GROUP BY  g.time, g.Distance;
CountAzimuth:503
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-15 23:0:0' AND e.date<='2024-06-16 5:0:0' AND e.DeviceLoginName='2729' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-06-15 20:00:00' AND g.time<='2024-06-16 02:00:00' AND g.DeviceLoginName='2729' GROUP BY  g.time, g.Distance;
CountAzimuth:69
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-15 23:0:0' AND e.date<='2024-06-16 5:0:0' AND e.DeviceLoginName='2773' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-06-15 20:00:00' AND g.time<='2024-06-16 02:00:00' AND g.DeviceLoginName='2773' GROUP BY  g.time, g.Distance;
CountAzimuth:291
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-15 23:0:0' AND e.date<='2024-06-16 5:0:0' AND e.DeviceLoginName='2871' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-06-15 20:00:00' AND g.time<='2024-06-16 02:00:00' AND g.DeviceLoginName='2871' GROUP BY  g.time, g.Distance;
CountAzimuth:192
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-15 23:0:0' AND e.date<='2024-06-16 5:0:0' AND e.DeviceLoginName='2738' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-06-15 20:00:00' AND g.time<='2024-06-16 02:00:00' AND g.DeviceLoginName='2738' GROUP BY  g.time, g.Distance;
CountAzimuth:48
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-15 23:0:0' AND e.date<='2024-06-16 5:0:0' AND e.DeviceLoginName='3036' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-06-15 20:00:00' AND g.time<='2024-06-16 02:00:00' AND g.DeviceLoginName='3036' GROUP BY  g.time, g.Distance;
CountAzimuth:182
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-15 23:0:0' AND e.date<='2024-06-16 5:0:0' AND e.DeviceLoginName='9002' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-06-15 20:00:00' AND g.time<='2024-06-16 02:00:00' AND g.DeviceLoginName='9002' GROUP BY  g.time, g.Distance;
CountAzimuth:92
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-17 1:48:10' AND e.date<='2024-06-17 12:48:10' AND e.DeviceLoginName='354836080167561' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-06-16 22:48:10' AND g.time<='2024-06-17 09:48:10' AND g.DeviceLoginName='354836080167561' GROUP BY  g.time, g.Distance;
CountAzimuth:329
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-16 23:0:0' AND e.date<='2024-06-17 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 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-06-16 20:00:00' AND g.time<='2024-06-17 02:00:00' AND g.DeviceLoginName='9010' GROUP BY  g.time, g.Distance;
CountAzimuth:13
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-16 23:0:0' AND e.date<='2024-06-17 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 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-06-16 20:00:00' AND g.time<='2024-06-17 02:00:00' AND g.DeviceLoginName='862531041078313' GROUP BY  g.time, g.Distance;
CountAzimuth:42
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-16 23:0:0' AND e.date<='2024-06-17 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 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-06-16 20:00:00' AND g.time<='2024-06-17 02:00:00' AND g.DeviceLoginName='4849' GROUP BY  g.time, g.Distance;
CountAzimuth:247
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-16 23:0:0' AND e.date<='2024-06-17 5:0:0' AND e.DeviceLoginName='864866053465430' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-06-16 20:00:00' AND g.time<='2024-06-17 02:00:00' AND g.DeviceLoginName='864866053465430' GROUP BY  g.time, g.Distance;
CountAzimuth:143
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-17 1:49:11' AND e.date<='2024-06-17 12:49:11' AND e.DeviceLoginName='3056' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-06-16 22:49:11' AND g.time<='2024-06-17 09:49:11' AND g.DeviceLoginName='3056' GROUP BY  g.time, g.Distance;
CountAzimuth:748
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-16 23:0:0' AND e.date<='2024-06-17 5:0:0' AND e.DeviceLoginName='9014' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-06-16 20:00:00' AND g.time<='2024-06-17 02:00:00' AND g.DeviceLoginName='9014' GROUP BY  g.time, g.Distance;
CountAzimuth:792
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-16 23:0:0' AND e.date<='2024-06-17 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 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-06-16 20:00:00' AND g.time<='2024-06-17 02:00:00' AND g.DeviceLoginName='2883' GROUP BY  g.time, g.Distance;
CountAzimuth:1
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-17 2:49:47' AND e.date<='2024-06-17 12:49:47' AND e.DeviceLoginName='356078116278207' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-06-16 23:49:47' AND g.time<='2024-06-17 09:49:47' AND g.DeviceLoginName='356078116278207' GROUP BY  g.time, g.Distance;
CountAzimuth:661
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-16 23:0:0' AND e.date<='2024-06-17 5:0:0' AND e.DeviceLoginName='9018' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-06-16 20:00:00' AND g.time<='2024-06-17 02:00:00' AND g.DeviceLoginName='9018' GROUP BY  g.time, g.Distance;
CountAzimuth:187
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-16 23:0:0' AND e.date<='2024-06-17 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 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-06-16 20:00:00' AND g.time<='2024-06-17 02:00:00' AND g.DeviceLoginName='353173060487970' GROUP BY  g.time, g.Distance;
CountAzimuth:92
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-16 23:0:0' AND e.date<='2024-06-17 5:0:0' AND e.DeviceLoginName='2506' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-06-16 20:00:00' AND g.time<='2024-06-17 02:00:00' AND g.DeviceLoginName='2506' GROUP BY  g.time, g.Distance;
CountAzimuth:23
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-16 23:0:0' AND e.date<='2024-06-17 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 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-06-16 20:00:00' AND g.time<='2024-06-17 02:00:00' AND g.DeviceLoginName='3156' GROUP BY  g.time, g.Distance;
CountAzimuth:231
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-16 23:0:0' AND e.date<='2024-06-17 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 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-06-16 20:00:00' AND g.time<='2024-06-17 02:00:00' AND g.DeviceLoginName='2667' GROUP BY  g.time, g.Distance;
CountAzimuth:123
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-16 23:0:0' AND e.date<='2024-06-17 5:0:0' AND e.DeviceLoginName='3032' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-06-16 20:00:00' AND g.time<='2024-06-17 02:00:00' AND g.DeviceLoginName='3032' GROUP BY  g.time, g.Distance;
CountAzimuth:63
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-14 13:0:14' AND e.date<='2024-06-14 14:0:14' AND e.DeviceLoginName='8997' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-06-14 10:00:14' AND g.time<='2024-06-14 11:00:14' AND g.DeviceLoginName='8997' GROUP BY  g.time, g.Distance;
CountAzimuth:149
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-13 14:30:14' AND e.date<='2024-06-13 15:30:14' AND e.DeviceLoginName='2723' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-06-13 11:30:14' AND g.time<='2024-06-13 12:30:14' AND g.DeviceLoginName='2723' GROUP BY  g.time, g.Distance;
CountAzimuth:432
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-12 10:0:27' AND e.date<='2024-06-12 11:40:27' AND e.DeviceLoginName='5078' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-06-12 07:00:27' AND g.time<='2024-06-12 08:40:27' AND g.DeviceLoginName='5078' GROUP BY  g.time, g.Distance;
CountAzimuth:265
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-12 11:40:27' AND e.date<='2024-06-12 12:40:27' AND e.DeviceLoginName='4966' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-06-12 08:40:27' AND g.time<='2024-06-12 09:40:27' AND g.DeviceLoginName='4966' GROUP BY  g.time, g.Distance;
CountAzimuth:102
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-10 15:40:27' AND e.date<='2024-06-10 16:43:27' AND e.DeviceLoginName='2890' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-06-10 12:40:27' AND g.time<='2024-06-10 13:43:27' AND g.DeviceLoginName='2890' GROUP BY  g.time, g.Distance;
CountAzimuth:285