Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-18 7:40:45' AND e.date<='2024-03-19 7:40:45' AND e.DeviceLoginName='3086' 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-03-18 05:40:45' AND g.time<='2024-03-19 05:40:45' AND g.DeviceLoginName='3086' GROUP BY  g.time, g.Distance;
CountAzimuth:0
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-18 12:25:52' AND e.date<='2024-03-19 12:25:52' AND e.DeviceLoginName='2574' 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-03-18 10:25:52' AND g.time<='2024-03-19 10:25:52' AND g.DeviceLoginName='2574' GROUP BY  g.time, g.Distance;
CountAzimuth:521
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-18 14:2:18' AND e.date<='2024-03-19 14:2:18' AND e.DeviceLoginName='2574' 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-03-18 12:02:18' AND g.time<='2024-03-19 12:02:18' AND g.DeviceLoginName='2574' GROUP BY  g.time, g.Distance;
CountAzimuth:521
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-19 3:37:28' AND e.date<='2024-03-19 14:37:28' AND e.DeviceLoginName='2516' 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-03-19 01:37:28' AND g.time<='2024-03-19 12:37:28' AND g.DeviceLoginName='2516' GROUP BY  g.time, g.Distance;
CountAzimuth:312
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-19 0:38:35' AND e.date<='2024-03-19 14:38:35' 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-03-18 22:38:35' AND g.time<='2024-03-19 12:38:35' AND g.DeviceLoginName='2837' GROUP BY  g.time, g.Distance;
CountAzimuth:1355
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-19 3:39:32' AND e.date<='2024-03-19 14:39:32' 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-03-19 01:39:32' AND g.time<='2024-03-19 12:39:32' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:326
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-18 0:39:56' AND e.date<='2024-03-18 23:39: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-03-17 22:39:56' AND g.time<='2024-03-18 21:39:56' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:1602
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-19 1:41:16' AND e.date<='2024-03-19 14:41:16' 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-03-18 23:41:16' AND g.time<='2024-03-19 12:41:16' AND g.DeviceLoginName='2473' GROUP BY  g.time, g.Distance;
CountAzimuth:1025
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-03-18 22:00:00' AND g.time<='2024-03-19 13:05:46' AND g.DeviceLoginName='356078111279986'
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-03-19 12:24:37' AND TIME<='2024-03-19 12:34:37' AND DeviceLoginName='356078111279986' AND speed=0
Method:GetStops; Query:SELECT e.date,e.EventType FROM tms_events e WHERE e.DeviceLoginName='356078111279986' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-03-18 22:00:00' AND e.date<='2024-03-19 13:05:46'
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-03-19 12:24:37' AND TIME<='2024-03-19 12:34:37' AND DeviceLoginName='356078111279986' AND speed=0
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-19 3:26:59' AND e.date<='2024-03-19 15:26:59' 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-03-19 01:26:59' AND g.time<='2024-03-19 13:26:59' AND g.DeviceLoginName='2473' GROUP BY  g.time, g.Distance;
CountAzimuth:1024