Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-15 0:3:25' AND e.date<='2024-07-15 23:3:25' 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-07-14 21:03:25' AND g.time<='2024-07-15 20:03:25' AND g.DeviceLoginName='2652' GROUP BY  g.time, g.Distance;
CountAzimuth:1611
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-16 0:3:25' AND e.date<='2024-07-16 23:3:25' 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-07-15 21:03:25' AND g.time<='2024-07-16 20:03:25' AND g.DeviceLoginName='2652' GROUP BY  g.time, g.Distance;
CountAzimuth:1115
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-17 0:3:25' AND e.date<='2024-07-17 23:3:25' 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-07-16 21:03:25' AND g.time<='2024-07-17 20:03:25' AND g.DeviceLoginName='2652' GROUP BY  g.time, g.Distance;
CountAzimuth:1312
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-18 0:3:25' AND e.date<='2024-07-18 23:3:25' 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-07-17 21:03:25' AND g.time<='2024-07-18 20:03:25' AND g.DeviceLoginName='2652' GROUP BY  g.time, g.Distance;
CountAzimuth:820
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-07-23 21:00:00' AND g.time<='2024-07-24 06:36:42' AND g.DeviceLoginName='4849'
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-07-23 21:51:21' AND TIME<='2024-07-23 22:01:21' AND DeviceLoginName='4849' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-07-24 00:58:25' AND TIME<='2024-07-24 01:08:25' AND DeviceLoginName='4849' AND speed=0
Method:GetStops; Query:SELECT e.date,e.EventType FROM tms_events e WHERE e.DeviceLoginName='4849' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-07-23 21:00:00' AND e.date<='2024-07-24 06:36:42'
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-07-23 21:17:16' AND TIME<='2024-07-23 21:27:16' AND DeviceLoginName='4849' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-07-24 01:35:00' AND TIME<='2024-07-24 01:45:00' AND DeviceLoginName='4849' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-07-24 06:04:06' AND TIME<='2024-07-24 06:14:06' AND DeviceLoginName='4849' AND speed=0
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-15 0:55:20' AND e.date<='2024-07-19 23:55:20' AND e.DeviceLoginName='2614' 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-07-14 21:55:20' AND g.time<='2024-07-19 20:55:20' AND g.DeviceLoginName='2614' GROUP BY  g.time, g.Distance;
CountAzimuth:3093
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-15 0:55:20' AND e.date<='2024-07-19 23:55:20' AND e.DeviceLoginName='2647' 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-07-14 21:55:20' AND g.time<='2024-07-19 20:55:20' AND g.DeviceLoginName='2647' GROUP BY  g.time, g.Distance;
CountAzimuth:2884
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-15 0:57:35' AND e.date<='2024-07-15 23:57:35' AND e.DeviceLoginName='2647' 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-07-14 21:57:35' AND g.time<='2024-07-15 20:57:35' AND g.DeviceLoginName='2647' GROUP BY  g.time, g.Distance;
CountAzimuth:408
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-16 0:57:35' AND e.date<='2024-07-16 23:57:35' AND e.DeviceLoginName='2647' 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-07-15 21:57:35' AND g.time<='2024-07-16 20:57:35' AND g.DeviceLoginName='2647' GROUP BY  g.time, g.Distance;
CountAzimuth:1552
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-17 0:57:35' AND e.date<='2024-07-17 23:57:35' AND e.DeviceLoginName='2647' 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-07-16 21:57:35' AND g.time<='2024-07-17 20:57:35' AND g.DeviceLoginName='2647' GROUP BY  g.time, g.Distance;
CountAzimuth:297
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-22 0:55:20' AND e.date<='2024-07-24 23:55:20' AND e.DeviceLoginName='2647' 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-07-21 21:55:20' AND g.time<='2024-07-24 20:55:20' AND g.DeviceLoginName='2647' GROUP BY  g.time, g.Distance;
CountAzimuth:1417
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-18 0:57:35' AND e.date<='2024-07-18 23:57:35' AND e.DeviceLoginName='2647' 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-07-17 21:57:35' AND g.time<='2024-07-18 20:57:35' AND g.DeviceLoginName='2647' GROUP BY  g.time, g.Distance;
CountAzimuth:523
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-19 0:57:35' AND e.date<='2024-07-19 23:57:35' AND e.DeviceLoginName='2647' 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-07-18 21:57:35' AND g.time<='2024-07-19 20:57:35' AND g.DeviceLoginName='2647' GROUP BY  g.time, g.Distance;
CountAzimuth:104
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-22 10:0:8' AND e.date<='2024-07-24 10:0:8' AND e.DeviceLoginName='2647' 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-07-22 07:00:08' AND g.time<='2024-07-24 07:00:08' AND g.DeviceLoginName='2647' GROUP BY  g.time, g.Distance;
CountAzimuth:1387
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-22 10:0:8' AND e.date<='2024-07-22 10:0:8' AND e.DeviceLoginName='2647' 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-07-22 07:00:08' AND g.time<='2024-07-22 07:00:08' AND g.DeviceLoginName='2647' GROUP BY  g.time, g.Distance;
CountAzimuth:0
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-22 0:0:8' AND e.date<='2024-07-22 23:0:8' AND e.DeviceLoginName='2647' 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-07-21 21:00:08' AND g.time<='2024-07-22 20:00:08' AND g.DeviceLoginName='2647' GROUP BY  g.time, g.Distance;
CountAzimuth:323
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-23 0:20:57' AND e.date<='2024-07-23 23:20:57' AND e.DeviceLoginName='356078111326001' 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-07-22 21:20:57' AND g.time<='2024-07-23 20:20:57' AND g.DeviceLoginName='356078111326001' GROUP BY  g.time, g.Distance;
CountAzimuth:2322
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-22 0:3:28' AND e.date<='2024-07-24 15:3:28' AND e.DeviceLoginName='355234055581363' 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-07-21 21:03:28' AND g.time<='2024-07-24 12:03:28' AND g.DeviceLoginName='355234055581363' GROUP BY  g.time, g.Distance;
CountAzimuth:2373
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-22 0:10:32' AND e.date<='2024-07-22 23:10:32' AND e.DeviceLoginName='355234055581363' 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-07-21 21:10:32' AND g.time<='2024-07-22 20:10:32' AND g.DeviceLoginName='355234055581363' GROUP BY  g.time, g.Distance;
CountAzimuth:782
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-23 0:10:32' AND e.date<='2024-07-23 23:10:32' AND e.DeviceLoginName='355234055581363' 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-07-22 21:10:32' AND g.time<='2024-07-23 20:10:32' AND g.DeviceLoginName='355234055581363' GROUP BY  g.time, g.Distance;
CountAzimuth:784
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-24 0:10:32' AND e.date<='2024-07-24 23:10:32' AND e.DeviceLoginName='355234055581363' 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-07-23 21:10:32' AND g.time<='2024-07-24 20:10:32' AND g.DeviceLoginName='355234055581363' GROUP BY  g.time, g.Distance;
CountAzimuth:807