Mysql query to avoid GPS issues

I record from devices the location each 10 second and store it into a mysql table with this fields: CREATE TABLE `schedules_trackings` ( `id` bigint(20) NOT NULL, `device_id` bigint(20) UNSIGNED …