Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-01 0:37:43' AND e.date<='2024-10-01 23:37:43' AND e.DeviceLoginName='3144' 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-09-30 21:37:43' AND g.time<='2024-10-01 20:37:43' AND g.DeviceLoginName='3144' GROUP BY  g.time, g.Distance;
CountAzimuth:1658
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-02 0:41:12' AND e.date<='2024-10-02 23:41:12' AND e.DeviceLoginName='3144' 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-10-01 21:41:12' AND g.time<='2024-10-02 20:41:12' AND g.DeviceLoginName='3144' GROUP BY  g.time, g.Distance;
CountAzimuth:0
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-03 0:41:43' AND e.date<='2024-10-03 23:41:43' AND e.DeviceLoginName='3144' 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-10-02 21:41:43' AND g.time<='2024-10-03 20:41:43' AND g.DeviceLoginName='3144' GROUP BY  g.time, g.Distance;
CountAzimuth:0
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-01 0:45:14' AND e.date<='2024-10-07 9:45:14' AND e.DeviceLoginName='3144' 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-09-30 21:45:14' AND g.time<='2024-10-07 06:45:14' AND g.DeviceLoginName='3144' GROUP BY  g.time, g.Distance;
CountAzimuth:2939
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-02 0:45:14' AND e.date<='2024-10-04 23:45:14' AND e.DeviceLoginName='3144' 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-10-01 21:45:14' AND g.time<='2024-10-04 20:45:14' AND g.DeviceLoginName='3144' GROUP BY  g.time, g.Distance;
CountAzimuth:1
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-09 9:55:50' AND e.date<='2024-10-10 9:55:50' AND e.DeviceLoginName='2593' 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-10-09 06:55:50' AND g.time<='2024-10-10 06:55:50' AND g.DeviceLoginName='2593' GROUP BY  g.time, g.Distance;
CountAzimuth:1069
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-07 9:55:50' AND e.date<='2024-10-10 9:55:50' AND e.DeviceLoginName='2593' 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-10-07 06:55:50' AND g.time<='2024-10-10 06:55:50' AND g.DeviceLoginName='2593' GROUP BY  g.time, g.Distance;
CountAzimuth:3871
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-09 0:55:50' AND e.date<='2024-10-09 23:55:50' AND e.DeviceLoginName='2593' 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-10-08 21:55:50' AND g.time<='2024-10-09 20:55:50' AND g.DeviceLoginName='2593' GROUP BY  g.time, g.Distance;
CountAzimuth:1020
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-07 0:55:50' AND e.date<='2024-10-07 23:55:50' AND e.DeviceLoginName='2593' 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-10-06 21:55:50' AND g.time<='2024-10-07 20:55:50' AND g.DeviceLoginName='2593' GROUP BY  g.time, g.Distance;
CountAzimuth:1276
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-09 10:2:23' AND e.date<='2024-10-10 10:2:23' AND e.DeviceLoginName='2751' 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-10-09 07:02:23' AND g.time<='2024-10-10 07:02:23' AND g.DeviceLoginName='2751' GROUP BY  g.time, g.Distance;
CountAzimuth:1184
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-01 0:2:23' AND e.date<='2024-10-01 23:2:23' AND e.DeviceLoginName='2751' 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-09-30 21:02:23' AND g.time<='2024-10-01 20:02:23' AND g.DeviceLoginName='2751' GROUP BY  g.time, g.Distance;
CountAzimuth:898
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-02 0:2:23' AND e.date<='2024-10-02 23:2:23' AND e.DeviceLoginName='2751' 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-10-01 21:02:23' AND g.time<='2024-10-02 20:02:23' AND g.DeviceLoginName='2751' GROUP BY  g.time, g.Distance;
CountAzimuth:847
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-03 0:2:23' AND e.date<='2024-10-03 23:2:23' AND e.DeviceLoginName='2751' 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-10-02 21:02:23' AND g.time<='2024-10-03 20:02:23' AND g.DeviceLoginName='2751' GROUP BY  g.time, g.Distance;
CountAzimuth:1009
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-04 0:2:23' AND e.date<='2024-10-04 23:2:23' AND e.DeviceLoginName='2751' 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-10-03 21:02:23' AND g.time<='2024-10-04 20:02:23' AND g.DeviceLoginName='2751' GROUP BY  g.time, g.Distance;
CountAzimuth:846
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-09 0:5:13' AND e.date<='2024-10-09 23:5:13' AND e.DeviceLoginName='2505' 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-10-08 21:05:13' AND g.time<='2024-10-09 20:05:13' AND g.DeviceLoginName='2505' GROUP BY  g.time, g.Distance;
CountAzimuth:334
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-07 0:2:23' AND e.date<='2024-10-07 23:2:23' AND e.DeviceLoginName='2751' 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-10-06 21:02:23' AND g.time<='2024-10-07 20:02:23' AND g.DeviceLoginName='2751' GROUP BY  g.time, g.Distance;
CountAzimuth:889
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-10-09 21:00:00' AND g.time<='2024-10-10 07:50:40' AND g.DeviceLoginName='3033'
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-10-10 05:25:58' AND TIME<='2024-10-10 05:35:58' AND DeviceLoginName='3033' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-10-10 06:07:03' AND TIME<='2024-10-10 06:17:03' AND DeviceLoginName='3033' AND speed=0
Method:GetStops; Query:SELECT e.date,e.EventType FROM tms_events e WHERE e.DeviceLoginName='3033' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-09 21:00:00' AND e.date<='2024-10-10 07:50:40'
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-10-10 05:25:58' AND TIME<='2024-10-10 05:35:58' AND DeviceLoginName='3033' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-10-10 06:01:18' AND TIME<='2024-10-10 06:11:18' AND DeviceLoginName='3033' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-10-10 06:07:03' AND TIME<='2024-10-10 06:17:03' AND DeviceLoginName='3033' AND speed=0
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-03 0:55:32' AND e.date<='2024-10-03 23:55:32' AND e.DeviceLoginName='3033' 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-10-02 21:55:32' AND g.time<='2024-10-03 20:55:32' AND g.DeviceLoginName='3033' GROUP BY  g.time, g.Distance;
CountAzimuth:1529
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-11 23:0:39' AND e.date<='2024-09-11 23:59:39' AND e.DeviceLoginName='2874' 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-09-11 20:00:39' AND g.time<='2024-09-11 20:59:39' AND g.DeviceLoginName='2874' GROUP BY  g.time, g.Distance;
CountAzimuth:11
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-12 23:0:39' AND e.date<='2024-09-12 23:59:39' AND e.DeviceLoginName='2874' 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-09-12 20:00:39' AND g.time<='2024-09-12 20:59:39' AND g.DeviceLoginName='2874' GROUP BY  g.time, g.Distance;
CountAzimuth:34
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-12 22:0:39' AND e.date<='2024-09-12 23:59:39' AND e.DeviceLoginName='2874' 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-09-12 19:00:39' AND g.time<='2024-09-12 20:59:39' AND g.DeviceLoginName='2874' GROUP BY  g.time, g.Distance;
CountAzimuth:145
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-11 22:0:39' AND e.date<='2024-09-11 23:59:39' AND e.DeviceLoginName='2874' 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-09-11 19:00:39' AND g.time<='2024-09-11 20:59:39' AND g.DeviceLoginName='2874' GROUP BY  g.time, g.Distance;
CountAzimuth:11