Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-16 4:46:30' AND e.date<='2024-01-16 9:46:30' 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-01-16 02:46:30' AND g.time<='2024-01-16 07:46:30' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:601
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-08 0:24:22' AND e.date<='2024-01-08 23:24:22' AND e.DeviceLoginName='2837' 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-01-07 22:24:22' AND g.time<='2024-01-08 21:24:22' AND g.DeviceLoginName='2837' GROUP BY  g.time, g.Distance;
CountAzimuth:5316
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-09 0:24:22' AND e.date<='2024-01-09 23:24:22' AND e.DeviceLoginName='2837' 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-01-08 22:24:22' AND g.time<='2024-01-09 21:24:22' AND g.DeviceLoginName='2837' GROUP BY  g.time, g.Distance;
CountAzimuth:2615
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-08 0:24:22' AND e.date<='2024-01-12 23:24:22' AND e.DeviceLoginName='2837' 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-01-07 22:24:22' AND g.time<='2024-01-12 21:24:22' AND g.DeviceLoginName='2837' GROUP BY  g.time, g.Distance;
CountAzimuth:17142
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-10 0:24:22' AND e.date<='2024-01-10 23:24:22' AND e.DeviceLoginName='2837' 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-01-09 22:24:22' AND g.time<='2024-01-10 21:24:22' AND g.DeviceLoginName='2837' GROUP BY  g.time, g.Distance;
CountAzimuth:5114
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-11 0:24:22' AND e.date<='2024-01-11 23:24:22' AND e.DeviceLoginName='2837' 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-01-10 22:24:22' AND g.time<='2024-01-11 21:24:22' AND g.DeviceLoginName='2837' GROUP BY  g.time, g.Distance;
CountAzimuth:1961
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-12 0:24:22' AND e.date<='2024-01-12 23:24:22' AND e.DeviceLoginName='2837' 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-01-11 22:24:22' AND g.time<='2024-01-12 21:24:22' AND g.DeviceLoginName='2837' GROUP BY  g.time, g.Distance;
CountAzimuth:2136
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-02 0:3:3' AND e.date<='2023-12-03 23:3:3' AND e.DeviceLoginName='355234055763185' 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>='2023-12-01 22:03:03' AND g.time<='2023-12-03 21:03:03' AND g.DeviceLoginName='355234055763185' GROUP BY  g.time, g.Distance;
CountAzimuth:606
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-09 0:5:22' AND e.date<='2023-12-10 23:5:22' AND e.DeviceLoginName='355234055763185' 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>='2023-12-08 22:05:22' AND g.time<='2023-12-10 21:05:22' AND g.DeviceLoginName='355234055763185' GROUP BY  g.time, g.Distance;
CountAzimuth:789
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-16 0:8:45' AND e.date<='2023-12-17 23:8:45' AND e.DeviceLoginName='355234055763185' 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>='2023-12-15 22:08:45' AND g.time<='2023-12-17 21:08:45' AND g.DeviceLoginName='355234055763185' GROUP BY  g.time, g.Distance;
CountAzimuth:531
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-23 0:10:44' AND e.date<='2023-12-24 23:10:44' AND e.DeviceLoginName='355234055763185' 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>='2023-12-22 22:10:44' AND g.time<='2023-12-24 21:10:44' AND g.DeviceLoginName='355234055763185' GROUP BY  g.time, g.Distance;
CountAzimuth:645
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-30 0:13:20' AND e.date<='2023-12-31 23:13:20' AND e.DeviceLoginName='355234055763185' 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>='2023-12-29 22:13:20' AND g.time<='2023-12-31 21:13:20' 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-01-16 0:5:20' AND e.date<='2024-01-16 14:5:20' AND e.DeviceLoginName='2473' 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-01-15 22:05:20' AND g.time<='2024-01-16 12:05:20' AND g.DeviceLoginName='2473' GROUP BY  g.time, g.Distance;
CountAzimuth:776
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-16 8:5:49' AND e.date<='2024-01-16 14:5:49' 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-01-16 06:05:49' AND g.time<='2024-01-16 12:05:49' AND g.DeviceLoginName='3056' GROUP BY  g.time, g.Distance;
CountAzimuth:941
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-16 8:6:13' AND e.date<='2024-01-16 14:6:13' AND e.DeviceLoginName='358021081803706' 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-01-16 06:06:13' AND g.time<='2024-01-16 12:06:13' AND g.DeviceLoginName='358021081803706' GROUP BY  g.time, g.Distance;
CountAzimuth:62
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-16 9:6:30' AND e.date<='2024-01-16 14:6:30' 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-01-16 07:06:30' AND g.time<='2024-01-16 12:06:30' AND g.DeviceLoginName='5117' GROUP BY  g.time, g.Distance;
CountAzimuth:795
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-01-15 22:00:00' AND g.time<='2024-01-16 12:37:07' AND g.DeviceLoginName='864866053465430'
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-01-16 05:37:56' AND TIME<='2024-01-16 05:47:56' AND DeviceLoginName='864866053465430' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-01-16 06:19:06' AND TIME<='2024-01-16 06:29:06' AND DeviceLoginName='864866053465430' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-01-16 11:49:35' AND TIME<='2024-01-16 11:59:35' AND DeviceLoginName='864866053465430' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-01-16 12:19:46' AND TIME<='2024-01-16 12:29:46' AND DeviceLoginName='864866053465430' AND speed=0
Method:GetStops; Query:SELECT e.date,e.EventType FROM tms_events e WHERE e.DeviceLoginName='864866053465430' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-01-15 22:00:00' AND e.date<='2024-01-16 12:37:07'
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-01-16 05:37:56' AND TIME<='2024-01-16 05:47:56' AND DeviceLoginName='864866053465430' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-01-16 06:19:06' AND TIME<='2024-01-16 06:29:06' AND DeviceLoginName='864866053465430' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-01-16 11:49:35' AND TIME<='2024-01-16 11:59:35' AND DeviceLoginName='864866053465430' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-01-16 12:19:46' AND TIME<='2024-01-16 12:29:46' AND DeviceLoginName='864866053465430' AND speed=0
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-01-15 22:00:00' AND g.time<='2024-01-16 12:37:21' AND g.DeviceLoginName='864866053465430'
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-01-16 05:37:56' AND TIME<='2024-01-16 05:47:56' AND DeviceLoginName='864866053465430' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-01-16 06:19:06' AND TIME<='2024-01-16 06:29:06' AND DeviceLoginName='864866053465430' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-01-16 11:49:35' AND TIME<='2024-01-16 11:59:35' AND DeviceLoginName='864866053465430' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-01-16 12:19:46' AND TIME<='2024-01-16 12:29:46' AND DeviceLoginName='864866053465430' AND speed=0
Method:GetStops; Query:SELECT e.date,e.EventType FROM tms_events e WHERE e.DeviceLoginName='864866053465430' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-01-15 22:00:00' AND e.date<='2024-01-16 12:37:21'
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-01-16 05:37:56' AND TIME<='2024-01-16 05:47:56' AND DeviceLoginName='864866053465430' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-01-16 06:19:06' AND TIME<='2024-01-16 06:29:06' AND DeviceLoginName='864866053465430' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-01-16 11:49:35' AND TIME<='2024-01-16 11:59:35' AND DeviceLoginName='864866053465430' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-01-16 12:19:46' AND TIME<='2024-01-16 12:29:46' AND DeviceLoginName='864866053465430' AND speed=0
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-16 11:17:50' AND e.date<='2024-01-16 15:17:50' AND e.DeviceLoginName='2473' 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-01-16 09:17:50' AND g.time<='2024-01-16 13:17:50' AND g.DeviceLoginName='2473' GROUP BY  g.time, g.Distance;
CountAzimuth:791
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-16 13:18:17' AND e.date<='2024-01-16 15:18:17' 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-01-16 11:18:17' AND g.time<='2024-01-16 13:18:17' AND g.DeviceLoginName='3056' GROUP BY  g.time, g.Distance;
CountAzimuth:178
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-16 13:18:42' AND e.date<='2024-01-16 15:18:42' 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-01-16 11:18:42' AND g.time<='2024-01-16 13:18:42' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:36