Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-18 0:1:56' AND e.date<='2024-06-18 23:1:56' AND e.DeviceLoginName='352353084656807' 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-17 21:01:56' AND g.time<='2024-06-18 20:01:56' AND g.DeviceLoginName='352353084656807' GROUP BY  g.time, g.Distance;
CountAzimuth:2047
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-19 3:15:52' AND e.date<='2024-06-19 8:15:52' 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-19 00:15:52' AND g.time<='2024-06-19 05:15:52' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:316
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-18 8:16:32' AND e.date<='2024-06-18 23:16:32' 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-18 05:16:32' AND g.time<='2024-06-18 20:16:32' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:841
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-19 0:18:50' AND e.date<='2024-06-19 8:18:50' 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-18 21:18:50' AND g.time<='2024-06-19 05:18:50' AND g.DeviceLoginName='354836080167561' GROUP BY  g.time, g.Distance;
CountAzimuth:366
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-18 8:25:40' AND e.date<='2024-06-18 23:25:40' AND e.DeviceLoginName='2556' 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-18 05:25:40' AND g.time<='2024-06-18 20:25:40' AND g.DeviceLoginName='2556' GROUP BY  g.time, g.Distance;
CountAzimuth:164
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-18 8:26:4' AND e.date<='2024-06-18 23:26:4' 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-18 05:26:04' AND g.time<='2024-06-18 20:26:04' AND g.DeviceLoginName='354836080167561' GROUP BY  g.time, g.Distance;
CountAzimuth:785
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-18 8:26:37' AND e.date<='2024-06-18 23:26:37' 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-18 05:26:37' AND g.time<='2024-06-18 20:26:37' AND g.DeviceLoginName='356078116278207' GROUP BY  g.time, g.Distance;
CountAzimuth:1622
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-18 8:28:41' AND e.date<='2024-06-18 23:28:41' 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-18 05:28:41' AND g.time<='2024-06-18 20:28:41' AND g.DeviceLoginName='3056' GROUP BY  g.time, g.Distance;
CountAzimuth:2184
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude FROM  tms_gpsdata_fixed g WHERE g.time>='2024-06-18 21:00:00' AND g.time<='2024-06-19 06:04:17' AND g.DeviceLoginName='355234055763185'
Method:GetStops; Query:SELECT e.date,e.EventType FROM tms_events e WHERE e.DeviceLoginName='355234055763185' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-06-18 21:00:00' AND e.date<='2024-06-19 06:04:17'
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-18 9:33:31' AND e.date<='2024-06-19 9:33:31' 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-18 06:33:31' AND g.time<='2024-06-19 06:33:31' AND g.DeviceLoginName='354836080167561' GROUP BY  g.time, g.Distance;
CountAzimuth:1299
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-18 10:12:20' AND e.date<='2024-06-19 10:12:20' AND e.DeviceLoginName='355234055763185' 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-18 07:12:20' AND g.time<='2024-06-19 07:12:20' AND g.DeviceLoginName='355234055763185' GROUP BY  g.time, g.Distance;
CountAzimuth:25
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-18 10:12:20' AND e.date<='2024-06-19 23:12:20' AND e.DeviceLoginName='355234055763185' 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-18 07:12:20' AND g.time<='2024-06-19 20:12:20' AND g.DeviceLoginName='355234055763185' GROUP BY  g.time, g.Distance;
CountAzimuth:25
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-19 0:51:18' AND e.date<='2024-06-19 11:51:18' 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-18 21:51:18' AND g.time<='2024-06-19 08:51:18' AND g.DeviceLoginName='354836080167561' GROUP BY  g.time, g.Distance;
CountAzimuth:578
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-19 5:15:28' AND e.date<='2024-06-19 14:15:28' 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-19 02:15:28' AND g.time<='2024-06-19 11:15:28' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:412
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-19 6:26:9' AND e.date<='2024-06-19 14:26:9' 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-19 03:26:09' AND g.time<='2024-06-19 11:26:09' AND g.DeviceLoginName='354836080167561' GROUP BY  g.time, g.Distance;
CountAzimuth:793
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-10 14:49:2' AND e.date<='2024-06-16 14:49:2' AND e.DeviceLoginName='355234055763185' 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 11:49:02' AND g.time<='2024-06-16 11:49:02' AND g.DeviceLoginName='355234055763185' GROUP BY  g.time, g.Distance;
CountAzimuth:0
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-17 0:49:2' AND e.date<='2024-06-16 14:49:2' AND e.DeviceLoginName='355234055763185' 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:49:02' AND g.time<='2024-06-16 11:49:02' AND g.DeviceLoginName='355234055763185' GROUP BY  g.time, g.Distance;
CountAzimuth:0
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-17 0:49:2' AND e.date<='2024-06-19 14:49:2' AND e.DeviceLoginName='355234055763185' 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:49:02' AND g.time<='2024-06-19 11:49:02' AND g.DeviceLoginName='355234055763185' GROUP BY  g.time, g.Distance;
CountAzimuth:186