Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-16 8:53:34' AND e.date<='2024-11-16 23:53:34' 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-11-16 06:53:34' AND g.time<='2024-11-16 21:53:34' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:918
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-17 8:55:3' AND e.date<='2024-11-17 23:55:3' 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-11-17 06:55:03' AND g.time<='2024-11-17 21:55:03' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:116
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-16 7:56:22' AND e.date<='2024-11-18 8:56:22' 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-11-16 05:56:22' AND g.time<='2024-11-18 06:56:22' AND g.DeviceLoginName='354836080167561' GROUP BY  g.time, g.Distance;
CountAzimuth:316
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-16 8:57:21' AND e.date<='2024-11-18 8:57:21' 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-11-16 06:57:21' AND g.time<='2024-11-18 06:57:21' AND g.DeviceLoginName='3056' GROUP BY  g.time, g.Distance;
CountAzimuth:336
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-16 8:58:10' AND e.date<='2024-11-18 8:58:10' AND e.DeviceLoginName='356078116278207' 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-11-16 06:58:10' AND g.time<='2024-11-18 06:58:10' AND g.DeviceLoginName='356078116278207' GROUP BY  g.time, g.Distance;
CountAzimuth:104
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-18 3:58:1' AND e.date<='2024-11-18 9:58:1' 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-11-18 01:58:01' AND g.time<='2024-11-18 07:58:01' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:482
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-18 3:58:37' AND e.date<='2024-11-18 9: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-11-18 01:58:37' AND g.time<='2024-11-18 07:58:37' AND g.DeviceLoginName='2556' GROUP BY  g.time, g.Distance;
CountAzimuth:8
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-18 3:59:7' AND e.date<='2024-11-18 9:59:7' 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-11-18 01:59:07' AND g.time<='2024-11-18 07:59:07' AND g.DeviceLoginName='3056' GROUP BY  g.time, g.Distance;
CountAzimuth:454
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-18 5:30:56' AND e.date<='2024-11-18 11:30: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-11-18 03:30:56' AND g.time<='2024-11-18 09:30:56' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:482
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-18 4:31:19' AND e.date<='2024-11-18 11:31:19' 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-11-18 02:31:19' AND g.time<='2024-11-18 09:31:19' AND g.DeviceLoginName='2556' GROUP BY  g.time, g.Distance;
CountAzimuth:15
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-18 7:16:58' AND e.date<='2024-11-18 12:16:58' AND e.DeviceLoginName='356078116281466' 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-11-18 05:16:58' AND g.time<='2024-11-18 10:16:58' AND g.DeviceLoginName='356078116281466' GROUP BY  g.time, g.Distance;
CountAzimuth:715
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-15 23:0:0' AND e.date<='2024-11-16 5:0:0' AND e.DeviceLoginName='3064' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-11-15 21:00:00' AND g.time<='2024-11-16 03:00:00' AND g.DeviceLoginName='3064' GROUP BY  g.time, g.Distance;
CountAzimuth:934
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-15 23:0:0' AND e.date<='2024-11-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 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-11-15 21:00:00' AND g.time<='2024-11-16 03:00:00' AND g.DeviceLoginName='4849' GROUP BY  g.time, g.Distance;
CountAzimuth:206
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-15 23:0:0' AND e.date<='2024-11-16 5:0:0' AND e.DeviceLoginName='2703' 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-11-15 21:00:00' AND g.time<='2024-11-16 03:00:00' AND g.DeviceLoginName='2703' GROUP BY  g.time, g.Distance;
CountAzimuth:92
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-15 23:0:0' AND e.date<='2024-11-16 5:0:0' AND e.DeviceLoginName='4883' 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-11-15 21:00:00' AND g.time<='2024-11-16 03:00:00' AND g.DeviceLoginName='4883' GROUP BY  g.time, g.Distance;
CountAzimuth:130
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-15 23:0:0' AND e.date<='2024-11-16 5:0:0' AND e.DeviceLoginName='2677' 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-11-15 21:00:00' AND g.time<='2024-11-16 03:00:00' AND g.DeviceLoginName='2677' GROUP BY  g.time, g.Distance;
CountAzimuth:1351
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-15 23:0:0' AND e.date<='2024-11-16 5:0:0' AND e.DeviceLoginName='352353086144547' 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-11-15 21:00:00' AND g.time<='2024-11-16 03:00:00' AND g.DeviceLoginName='352353086144547' GROUP BY  g.time, g.Distance;
CountAzimuth:10
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-15 23:0:0' AND e.date<='2024-11-16 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-11-15 21:00:00' AND g.time<='2024-11-16 03:00:00' AND g.DeviceLoginName='4862' GROUP BY  g.time, g.Distance;
CountAzimuth:278
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-15 23:0:0' AND e.date<='2024-11-16 5:0:0' AND e.DeviceLoginName='2676' 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-11-15 21:00:00' AND g.time<='2024-11-16 03:00:00' AND g.DeviceLoginName='2676' GROUP BY  g.time, g.Distance;
CountAzimuth:12
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-15 23:0:0' AND e.date<='2024-11-16 5:0:0' AND e.DeviceLoginName='3100' 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-11-15 21:00:00' AND g.time<='2024-11-16 03:00:00' AND g.DeviceLoginName='3100' GROUP BY  g.time, g.Distance;
CountAzimuth:69
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-15 23:0:0' AND e.date<='2024-11-16 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-11-15 21:00:00' AND g.time<='2024-11-16 03:00:00' AND g.DeviceLoginName='2499' GROUP BY  g.time, g.Distance;
CountAzimuth:332
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-15 23:0:0' AND e.date<='2024-11-16 5:0:0' AND e.DeviceLoginName='2627' 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-11-15 21:00:00' AND g.time<='2024-11-16 03:00:00' AND g.DeviceLoginName='2627' GROUP BY  g.time, g.Distance;
CountAzimuth:37
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-15 23:0:0' AND e.date<='2024-11-16 5:0:0' AND e.DeviceLoginName='2888' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-11-15 21:00:00' AND g.time<='2024-11-16 03:00:00' AND g.DeviceLoginName='2888' GROUP BY  g.time, g.Distance;
CountAzimuth:129
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-16 23:0:0' AND e.date<='2024-11-17 5:0:0' AND e.DeviceLoginName='4848' 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-11-16 21:00:00' AND g.time<='2024-11-17 03:00:00' AND g.DeviceLoginName='4848' GROUP BY  g.time, g.Distance;
CountAzimuth:119
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-16 23:0:0' AND e.date<='2024-11-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 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-11-16 21:00:00' AND g.time<='2024-11-17 03:00:00' AND g.DeviceLoginName='4849' GROUP BY  g.time, g.Distance;
CountAzimuth:340
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-16 23:0:0' AND e.date<='2024-11-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 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-11-16 21:00:00' AND g.time<='2024-11-17 03:00:00' AND g.DeviceLoginName='9014' GROUP BY  g.time, g.Distance;
CountAzimuth:137
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-16 23:0:0' AND e.date<='2024-11-17 5:0:0' AND e.DeviceLoginName='2703' 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-11-16 21:00:00' AND g.time<='2024-11-17 03:00:00' AND g.DeviceLoginName='2703' GROUP BY  g.time, g.Distance;
CountAzimuth:31
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-16 23:0:0' AND e.date<='2024-11-17 5:0:0' AND e.DeviceLoginName='9004' 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-11-16 21:00:00' AND g.time<='2024-11-17 03:00:00' AND g.DeviceLoginName='9004' GROUP BY  g.time, g.Distance;
CountAzimuth:109
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-16 23:0:0' AND e.date<='2024-11-17 5:0:0' AND e.DeviceLoginName='353173060537865' 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-11-16 21:00:00' AND g.time<='2024-11-17 03:00:00' AND g.DeviceLoginName='353173060537865' GROUP BY  g.time, g.Distance;
CountAzimuth:28
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-16 23:0:0' AND e.date<='2024-11-17 5:0:0' AND e.DeviceLoginName='862531041050148' 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-11-16 21:00:00' AND g.time<='2024-11-17 03:00:00' AND g.DeviceLoginName='862531041050148' GROUP BY  g.time, g.Distance;
CountAzimuth:61
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-16 23:0:0' AND e.date<='2024-11-17 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-11-16 21:00:00' AND g.time<='2024-11-17 03:00:00' AND g.DeviceLoginName='4861' GROUP BY  g.time, g.Distance;
CountAzimuth:29
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-16 23:0:0' AND e.date<='2024-11-17 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-11-16 21:00:00' AND g.time<='2024-11-17 03:00:00' AND g.DeviceLoginName='2470' GROUP BY  g.time, g.Distance;
CountAzimuth:40
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-16 23:0:0' AND e.date<='2024-11-17 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-11-16 21:00:00' AND g.time<='2024-11-17 03:00:00' AND g.DeviceLoginName='3162' GROUP BY  g.time, g.Distance;
CountAzimuth:101
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-16 23:0:0' AND e.date<='2024-11-17 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-11-16 21:00:00' AND g.time<='2024-11-17 03:00:00' AND g.DeviceLoginName='352353086185359' GROUP BY  g.time, g.Distance;
CountAzimuth:35
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-16 23:0:0' AND e.date<='2024-11-17 5:0:0' AND e.DeviceLoginName='354836080080590' 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-11-16 21:00:00' AND g.time<='2024-11-17 03:00:00' AND g.DeviceLoginName='354836080080590' GROUP BY  g.time, g.Distance;
CountAzimuth:222
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-16 23:0:0' AND e.date<='2024-11-17 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-11-16 21:00:00' AND g.time<='2024-11-17 03:00:00' AND g.DeviceLoginName='8983' GROUP BY  g.time, g.Distance;
CountAzimuth:138
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-16 23:0:0' AND e.date<='2024-11-17 5:0:0' AND e.DeviceLoginName='2676' 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-11-16 21:00:00' AND g.time<='2024-11-17 03:00:00' AND g.DeviceLoginName='2676' GROUP BY  g.time, g.Distance;
CountAzimuth:179
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-17 23:0:0' AND e.date<='2024-11-18 5:0:0' AND e.DeviceLoginName='2676' 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-11-17 21:00:00' AND g.time<='2024-11-18 03:00:00' AND g.DeviceLoginName='2676' GROUP BY  g.time, g.Distance;
CountAzimuth:39
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-17 23:0:0' AND e.date<='2024-11-18 5:0:0' AND e.DeviceLoginName='9011' 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-11-17 21:00:00' AND g.time<='2024-11-18 03:00:00' AND g.DeviceLoginName='9011' GROUP BY  g.time, g.Distance;
CountAzimuth:89
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-17 23:0:0' AND e.date<='2024-11-18 5:0:0' AND e.DeviceLoginName='3136' 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-11-17 21:00:00' AND g.time<='2024-11-18 03:00:00' AND g.DeviceLoginName='3136' GROUP BY  g.time, g.Distance;
CountAzimuth:11
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-17 23:0:0' AND e.date<='2024-11-18 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-11-17 21:00:00' AND g.time<='2024-11-18 03:00:00' AND g.DeviceLoginName='3025' GROUP BY  g.time, g.Distance;
CountAzimuth:122
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-17 23:0:0' AND e.date<='2024-11-18 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-11-17 21:00:00' AND g.time<='2024-11-18 03:00:00' AND g.DeviceLoginName='5082' GROUP BY  g.time, g.Distance;
CountAzimuth:54
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-17 23:0:0' AND e.date<='2024-11-18 5:0:0' AND e.DeviceLoginName='862531041050148' 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-11-17 21:00:00' AND g.time<='2024-11-18 03:00:00' AND g.DeviceLoginName='862531041050148' GROUP BY  g.time, g.Distance;
CountAzimuth:5
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-17 23:0:0' AND e.date<='2024-11-18 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-11-17 21:00:00' AND g.time<='2024-11-18 03:00:00' AND g.DeviceLoginName='5117' GROUP BY  g.time, g.Distance;
CountAzimuth:160
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-17 23:0:0' AND e.date<='2024-11-18 5:0:0' AND e.DeviceLoginName='4959' 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-11-17 21:00:00' AND g.time<='2024-11-18 03:00:00' AND g.DeviceLoginName='4959' GROUP BY  g.time, g.Distance;
CountAzimuth:318
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-17 23:0:0' AND e.date<='2024-11-18 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-11-17 21:00:00' AND g.time<='2024-11-18 03:00:00' AND g.DeviceLoginName='4861' GROUP BY  g.time, g.Distance;
CountAzimuth:75
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-17 23:0:0' AND e.date<='2024-11-18 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-11-17 21:00:00' AND g.time<='2024-11-18 03:00:00' AND g.DeviceLoginName='2470' GROUP BY  g.time, g.Distance;
CountAzimuth:73
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-17 23:0:0' AND e.date<='2024-11-18 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-11-17 21:00:00' AND g.time<='2024-11-18 03:00:00' AND g.DeviceLoginName='2556' GROUP BY  g.time, g.Distance;
CountAzimuth:14
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-17 23:0:0' AND e.date<='2024-11-18 5:0:0' AND e.DeviceLoginName='356078111279820' 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-11-17 21:00:00' AND g.time<='2024-11-18 03:00:00' AND g.DeviceLoginName='356078111279820' GROUP BY  g.time, g.Distance;
CountAzimuth:11
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-17 23:0:0' AND e.date<='2024-11-18 5:0:0' AND e.DeviceLoginName='2676' 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-11-17 21:00:00' AND g.time<='2024-11-18 03:00:00' AND g.DeviceLoginName='2676' GROUP BY  g.time, g.Distance;
CountAzimuth:39
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-17 23:0:0' AND e.date<='2024-11-18 5:0:0' AND e.DeviceLoginName='2755' 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-11-17 21:00:00' AND g.time<='2024-11-18 03:00:00' AND g.DeviceLoginName='2755' GROUP BY  g.time, g.Distance;
CountAzimuth:37
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-17 13:52:35' AND e.date<='2024-11-18 13:52:35' AND e.DeviceLoginName='355234055521468' 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-11-17 11:52:35' AND g.time<='2024-11-18 11:52:35' AND g.DeviceLoginName='355234055521468' GROUP BY  g.time, g.Distance;
CountAzimuth:0
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-17 0:52:35' AND e.date<='2024-11-18 13:52:35' AND e.DeviceLoginName='355234055521468' 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-11-16 22:52:35' AND g.time<='2024-11-18 11:52:35' AND g.DeviceLoginName='355234055521468' GROUP BY  g.time, g.Distance;
CountAzimuth:407
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-17 0:52:35' AND e.date<='2024-11-17 23:52:35' AND e.DeviceLoginName='355234055521468' 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-11-16 22:52:35' AND g.time<='2024-11-17 21:52:35' AND g.DeviceLoginName='355234055521468' GROUP BY  g.time, g.Distance;
CountAzimuth:407
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-11 18:45:35' AND e.date<='2024-11-11 18:59:35' AND e.DeviceLoginName='2875' 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-11-11 16:45:35' AND g.time<='2024-11-11 16:59:35' AND g.DeviceLoginName='2875' GROUP BY  g.time, g.Distance;
CountAzimuth:167
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-14 15:0:35' AND e.date<='2024-11-14 15:10: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-11-14 13:00:35' AND g.time<='2024-11-14 13:10:35' AND g.DeviceLoginName='2556' GROUP BY  g.time, g.Distance;
CountAzimuth:41
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-16 23:0:0' AND e.date<='2024-11-17 5:0:0' AND e.DeviceLoginName='9004' 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-11-16 21:00:00' AND g.time<='2024-11-17 03:00:00' AND g.DeviceLoginName='9004' GROUP BY  g.time, g.Distance;
CountAzimuth:109
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-16 23:0:0' AND e.date<='2024-11-16 23:0:0' AND e.DeviceLoginName='9004' 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-11-16 21:00:00' AND g.time<='2024-11-16 21:00:00' AND g.DeviceLoginName='9004' GROUP BY  g.time, g.Distance;
CountAzimuth:0
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-16 22:0:0' AND e.date<='2024-11-16 23:0:0' AND e.DeviceLoginName='9004' 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-11-16 20:00:00' AND g.time<='2024-11-16 21:00:00' AND g.DeviceLoginName='9004' GROUP BY  g.time, g.Distance;
CountAzimuth:1
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-16 21:0:0' AND e.date<='2024-11-16 23:0:0' AND e.DeviceLoginName='9004' 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-11-16 19:00:00' AND g.time<='2024-11-16 21:00:00' AND g.DeviceLoginName='9004' GROUP BY  g.time, g.Distance;
CountAzimuth:1
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-16 20:0:0' AND e.date<='2024-11-16 23:0:0' AND e.DeviceLoginName='9004' 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-11-16 18:00:00' AND g.time<='2024-11-16 21:00:00' AND g.DeviceLoginName='9004' GROUP BY  g.time, g.Distance;
CountAzimuth:1
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-16 19:0:0' AND e.date<='2024-11-16 23:0:0' AND e.DeviceLoginName='9004' 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-11-16 17:00:00' AND g.time<='2024-11-16 21:00:00' AND g.DeviceLoginName='9004' GROUP BY  g.time, g.Distance;
CountAzimuth:6
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-16 18:0:0' AND e.date<='2024-11-16 23:0:0' AND e.DeviceLoginName='9004' 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-11-16 16:00:00' AND g.time<='2024-11-16 21:00:00' AND g.DeviceLoginName='9004' GROUP BY  g.time, g.Distance;
CountAzimuth:76
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-16 18:0:0' AND e.date<='2024-11-16 23:59:0' AND e.DeviceLoginName='9004' 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-11-16 16:00:00' AND g.time<='2024-11-16 21:59:00' AND g.DeviceLoginName='9004' GROUP BY  g.time, g.Distance;
CountAzimuth:101
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-16 18:0:0' AND e.date<='2024-11-17 5:0:0' AND e.DeviceLoginName='9004' 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-11-16 16:00:00' AND g.time<='2024-11-17 03:00:00' AND g.DeviceLoginName='9004' GROUP BY  g.time, g.Distance;
CountAzimuth:185
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-16 18:0:0' AND e.date<='2024-11-17 0:0:0' AND e.DeviceLoginName='9004' 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-11-16 16:00:00' AND g.time<='2024-11-16 22:00:00' AND g.DeviceLoginName='9004' GROUP BY  g.time, g.Distance;
CountAzimuth:111
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-16 17:0:0' AND e.date<='2024-11-17 0:0:0' AND e.DeviceLoginName='9004' 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-11-16 15:00:00' AND g.time<='2024-11-16 22:00:00' AND g.DeviceLoginName='9004' GROUP BY  g.time, g.Distance;
CountAzimuth:111
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-16 17:0:0' AND e.date<='2024-11-17 1:0:0' AND e.DeviceLoginName='9004' 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-11-16 15:00:00' AND g.time<='2024-11-16 23:00:00' AND g.DeviceLoginName='9004' GROUP BY  g.time, g.Distance;
CountAzimuth:185
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-16 17:0:0' AND e.date<='2024-11-17 0:0:0' AND e.DeviceLoginName='9004' 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-11-16 15:00:00' AND g.time<='2024-11-16 22:00:00' AND g.DeviceLoginName='9004' GROUP BY  g.time, g.Distance;
CountAzimuth:111
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-16 17:0:0' AND e.date<='2024-11-16 23:0:0' AND e.DeviceLoginName='9004' 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-11-16 15:00:00' AND g.time<='2024-11-16 21:00:00' AND g.DeviceLoginName='9004' GROUP BY  g.time, g.Distance;
CountAzimuth:76
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-16 23:0:0' AND e.date<='2024-11-17 1:0:0' AND e.DeviceLoginName='9004' 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-11-16 21:00:00' AND g.time<='2024-11-16 23:00:00' AND g.DeviceLoginName='9004' GROUP BY  g.time, g.Distance;
CountAzimuth:109
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-16 5:0:0' AND e.date<='2024-11-16 23:0:0' AND e.DeviceLoginName='9004' 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-11-16 03:00:00' AND g.time<='2024-11-16 21:00:00' AND g.DeviceLoginName='9004' GROUP BY  g.time, g.Distance;
CountAzimuth:618
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-16 23:0:0' AND e.date<='2024-11-17 1:0:0' AND e.DeviceLoginName='9004' 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-11-16 21:00:00' AND g.time<='2024-11-16 23:00:00' AND g.DeviceLoginName='9004' GROUP BY  g.time, g.Distance;
CountAzimuth:109
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-16 23:0:0' AND e.date<='2024-11-17 5:0:0' AND e.DeviceLoginName='9004' 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-11-16 21:00:00' AND g.time<='2024-11-17 03:00:00' AND g.DeviceLoginName='9004' GROUP BY  g.time, g.Distance;
CountAzimuth:109
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-17 5:0:0' AND e.date<='2024-11-17 23:0:0' AND e.DeviceLoginName='9004' 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-11-17 03:00:00' AND g.time<='2024-11-17 21:00:00' AND g.DeviceLoginName='9004' GROUP BY  g.time, g.Distance;
CountAzimuth:201
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-16 23:0:0' AND e.date<='2024-11-17 5:0:0' AND e.DeviceLoginName='9004' 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-11-16 21:00:00' AND g.time<='2024-11-17 03:00:00' AND g.DeviceLoginName='9004' GROUP BY  g.time, g.Distance;
CountAzimuth:109
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-16 5:0:0' AND e.date<='2024-11-16 23:0:0' AND e.DeviceLoginName='9004' 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-11-16 03:00:00' AND g.time<='2024-11-16 21:00:00' AND g.DeviceLoginName='9004' GROUP BY  g.time, g.Distance;
CountAzimuth:618
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-17 5:0:0' AND e.date<='2024-11-17 23:0:0' AND e.DeviceLoginName='9004' 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-11-17 03:00:00' AND g.time<='2024-11-17 21:00:00' AND g.DeviceLoginName='9004' GROUP BY  g.time, g.Distance;
CountAzimuth:201
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-17 23:0:0' AND e.date<='2024-11-17 5:0:0' AND e.DeviceLoginName='9004' 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-11-17 21:00:00' AND g.time<='2024-11-17 03:00:00' AND g.DeviceLoginName='9004' GROUP BY  g.time, g.Distance;
CountAzimuth:0
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-16 23:0:0' AND e.date<='2024-11-17 5:0:0' AND e.DeviceLoginName='9004' 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-11-16 21:00:00' AND g.time<='2024-11-17 03:00:00' AND g.DeviceLoginName='9004' GROUP BY  g.time, g.Distance;
CountAzimuth:109
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-16 5:0:0' AND e.date<='2024-11-16 23:0:0' AND e.DeviceLoginName='9004' 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-11-16 03:00:00' AND g.time<='2024-11-16 21:00:00' AND g.DeviceLoginName='9004' GROUP BY  g.time, g.Distance;
CountAzimuth:618
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-17 5:0:0' AND e.date<='2024-11-17 23:0:0' AND e.DeviceLoginName='9004' 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-11-17 03:00:00' AND g.time<='2024-11-17 21:00:00' AND g.DeviceLoginName='9004' GROUP BY  g.time, g.Distance;
CountAzimuth:201
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-16 23:0:0' AND e.date<='2024-11-17 5:0:0' AND e.DeviceLoginName='9004' 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-11-16 21:00:00' AND g.time<='2024-11-17 03:00:00' AND g.DeviceLoginName='9004' GROUP BY  g.time, g.Distance;
CountAzimuth:109
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-11 5:0:0' AND e.date<='2024-11-15 23:0:0' AND e.DeviceLoginName='2722' 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-11-11 03:00:00' AND g.time<='2024-11-15 21:00:00' AND g.DeviceLoginName='2722' GROUP BY  g.time, g.Distance;
CountAzimuth:2622
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-18 3:51:11' AND e.date<='2024-11-18 14:51:11' 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-11-18 01:51:11' AND g.time<='2024-11-18 12:51:11' AND g.DeviceLoginName='2556' GROUP BY  g.time, g.Distance;
CountAzimuth:726
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-18 7:2:35' AND e.date<='2024-11-18 15:2:35' AND e.DeviceLoginName='356078116278207' 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-11-18 05:02:35' AND g.time<='2024-11-18 13:02:35' AND g.DeviceLoginName='356078116278207' GROUP BY  g.time, g.Distance;
CountAzimuth:332
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-18 14:13:41' AND e.date<='2024-11-18 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-11-18 12:13:41' AND g.time<='2024-11-18 13:13:41' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:1
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-18 13:13:59' AND e.date<='2024-11-18 15:13:59' AND e.DeviceLoginName='356078116278207' 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-11-18 11:13:59' AND g.time<='2024-11-18 13:13:59' AND g.DeviceLoginName='356078116278207' GROUP BY  g.time, g.Distance;
CountAzimuth:58
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-18 13:14:31' AND e.date<='2024-11-18 15:14: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-11-18 11:14:31' AND g.time<='2024-11-18 13:14:31' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:1