Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-18 7:36:7' AND e.date<='2024-12-18 23:36:7' 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-12-18 05:36:07' AND g.time<='2024-12-18 21:36:07' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:1773
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-19 5:36:48' AND e.date<='2024-12-19 7:36:48' 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-12-19 03:36:48' AND g.time<='2024-12-19 05:36:48' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:367
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-19 5:49:3' AND e.date<='2024-12-19 7:49:3' 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-12-19 03:49:03' AND g.time<='2024-12-19 05:49:03' AND g.DeviceLoginName='354836080167561' GROUP BY  g.time, g.Distance;
CountAzimuth:532
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-11 0:40:25' AND e.date<='2024-12-11 23:40:25' AND e.DeviceLoginName='352353086150999' 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-12-10 22:40:25' AND g.time<='2024-12-11 21:40:25' AND g.DeviceLoginName='352353086150999' GROUP BY  g.time, g.Distance;
CountAzimuth:1640
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-06 0:54:40' AND e.date<='2024-12-09 23:54:40' 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-12-05 22:54:40' AND g.time<='2024-12-09 21:54:40' AND g.DeviceLoginName='4883' GROUP BY  g.time, g.Distance;
CountAzimuth:7855
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-04 0:57:56' AND e.date<='2024-12-05 23:57:56' AND e.DeviceLoginName='352353083473741' 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-12-03 22:57:56' AND g.time<='2024-12-05 21:57:56' AND g.DeviceLoginName='352353083473741' GROUP BY  g.time, g.Distance;
CountAzimuth:7606
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-10 0:57:56' AND e.date<='2024-12-11 23:57:56' AND e.DeviceLoginName='352353083473741' 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-12-09 22:57:56' AND g.time<='2024-12-11 21:57:56' AND g.DeviceLoginName='352353083473741' GROUP BY  g.time, g.Distance;
CountAzimuth:5437
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-16 0:57:56' AND e.date<='2024-12-16 23:57:56' AND e.DeviceLoginName='352353083473741' 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-12-15 22:57:56' AND g.time<='2024-12-16 21:57:56' AND g.DeviceLoginName='352353083473741' GROUP BY  g.time, g.Distance;
CountAzimuth:2249
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-09 10:8:7' AND e.date<='2024-12-19 10:8:7' AND e.DeviceLoginName='2783' 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-12-09 08:08:07' AND g.time<='2024-12-19 08:08:07' AND g.DeviceLoginName='2783' GROUP BY  g.time, g.Distance;
CountAzimuth:18489
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-16 10:22:8' AND e.date<='2024-12-19 10:22:8' AND e.DeviceLoginName='2833' 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-12-16 08:22:08' AND g.time<='2024-12-19 08:22:08' AND g.DeviceLoginName='2833' GROUP BY  g.time, g.Distance;
CountAzimuth:7643
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude FROM  tms_gpsdata_fixed g WHERE g.time>='2024-12-18 22:00:00' AND g.time<='2024-12-19 08:35:16' AND g.DeviceLoginName='2906'
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-12-19 08:07:05' AND TIME<='2024-12-19 08:17:05' AND DeviceLoginName='2906' AND speed=0
Method:GetStops; Query:SELECT e.date,e.EventType FROM tms_events e WHERE e.DeviceLoginName='2906' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-12-18 22:00:00' AND e.date<='2024-12-19 08:35:16'
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-12-19 08:00:11' AND TIME<='2024-12-19 08:10:11' AND DeviceLoginName='2906' AND speed=0
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-18 12:2:28' AND e.date<='2024-12-19 12:2:28' 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-12-18 10:02:28' AND g.time<='2024-12-19 10:02:28' AND g.DeviceLoginName='9376' GROUP BY  g.time, g.Distance;
CountAzimuth:988
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-16 0:2:28' AND e.date<='2024-12-16 23:2:28' 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-12-15 22:02:28' AND g.time<='2024-12-16 21:02:28' AND g.DeviceLoginName='9376' GROUP BY  g.time, g.Distance;
CountAzimuth:935
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-19 0:13:6' AND e.date<='2024-12-19 13:13:6' AND e.DeviceLoginName='3088' 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-12-18 22:13:06' AND g.time<='2024-12-19 11:13:06' AND g.DeviceLoginName='3088' GROUP BY  g.time, g.Distance;
CountAzimuth:721
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-30 0:3:43' AND e.date<='2024-11-30 23:3:43' AND e.DeviceLoginName='2559' 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-29 22:03:43' AND g.time<='2024-11-30 21:03:43' AND g.DeviceLoginName='2559' GROUP BY  g.time, g.Distance;
CountAzimuth:828
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-16 0:3:43' AND e.date<='2024-12-16 23:3:43' AND e.DeviceLoginName='2559' 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-12-15 22:03:43' AND g.time<='2024-12-16 21:03:43' AND g.DeviceLoginName='2559' GROUP BY  g.time, g.Distance;
CountAzimuth:1822
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-18 14:7:48' AND e.date<='2024-12-19 14:7:48' AND e.DeviceLoginName='2879' 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-12-18 12:07:48' AND g.time<='2024-12-19 12:07:48' AND g.DeviceLoginName='2879' GROUP BY  g.time, g.Distance;
CountAzimuth:227
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-16 0:7:48' AND e.date<='2024-12-16 23:7:48' AND e.DeviceLoginName='2879' 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-12-15 22:07:48' AND g.time<='2024-12-16 21:07:48' AND g.DeviceLoginName='2879' GROUP BY  g.time, g.Distance;
CountAzimuth:1683
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-17 0:7:48' AND e.date<='2024-12-17 23:7:48' AND e.DeviceLoginName='2879' 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-12-16 22:07:48' AND g.time<='2024-12-17 21:07:48' AND g.DeviceLoginName='2879' GROUP BY  g.time, g.Distance;
CountAzimuth:286
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-18 0:7:48' AND e.date<='2024-12-18 23:7:48' AND e.DeviceLoginName='2879' 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-12-17 22:07:48' AND g.time<='2024-12-18 21:07:48' AND g.DeviceLoginName='2879' GROUP BY  g.time, g.Distance;
CountAzimuth:543
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-19 0:7:48' AND e.date<='2024-12-19 23:7:48' AND e.DeviceLoginName='2879' 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-12-18 22:07:48' AND g.time<='2024-12-19 21:07:48' AND g.DeviceLoginName='2879' GROUP BY  g.time, g.Distance;
CountAzimuth:0
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-19 0:7:48' AND e.date<='2024-12-19 23:7:48' AND e.DeviceLoginName='2879' 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-12-18 22:07:48' AND g.time<='2024-12-19 21:07:48' AND g.DeviceLoginName='2879' GROUP BY  g.time, g.Distance;
CountAzimuth:0
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-18 0:7:48' AND e.date<='2024-12-18 23:7:48' AND e.DeviceLoginName='2879' 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-12-17 22:07:48' AND g.time<='2024-12-18 21:07:48' AND g.DeviceLoginName='2879' GROUP BY  g.time, g.Distance;
CountAzimuth:543