2021-12-21 00:01:16 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 18:01:16' and t.time < '2021-12-21 00:01:16' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 00:08:04 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 18:08:04' and t.time < '2021-12-21 00:08:04' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 00:08:34 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 18:08:34' and t.time < '2021-12-21 00:08:34' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 00:09:05 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 18:09:05' and t.time < '2021-12-21 00:09:05' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 00:09:36 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 18:09:36' and t.time < '2021-12-21 00:09:36' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 00:10:07 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 18:10:07' and t.time < '2021-12-21 00:10:07' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 00:10:38 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 18:10:38' and t.time < '2021-12-21 00:10:38' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 00:11:10 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 18:11:10' and t.time < '2021-12-21 00:11:10' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 00:11:41 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 18:11:41' and t.time < '2021-12-21 00:11:41' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 00:12:11 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 18:12:11' and t.time < '2021-12-21 00:12:11' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 00:12:42 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 18:12:42' and t.time < '2021-12-21 00:12:42' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 00:13:13 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 18:13:13' and t.time < '2021-12-21 00:13:13' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 00:13:44 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 18:13:44' and t.time < '2021-12-21 00:13:44' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 00:14:15 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 18:14:15' and t.time < '2021-12-21 00:14:15' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 00:14:46 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 18:14:46' and t.time < '2021-12-21 00:14:46' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 00:15:17 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 18:15:17' and t.time < '2021-12-21 00:15:17' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 00:15:48 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 18:15:48' and t.time < '2021-12-21 00:15:48' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 00:16:20 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 18:16:20' and t.time < '2021-12-21 00:16:20' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 00:16:50 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 18:16:50' and t.time < '2021-12-21 00:16:50' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 00:17:21 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 18:17:21' and t.time < '2021-12-21 00:17:21' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 00:17:52 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 18:17:52' and t.time < '2021-12-21 00:17:52' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 00:18:24 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 18:18:24' and t.time < '2021-12-21 00:18:24' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 00:18:54 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 18:18:54' and t.time < '2021-12-21 00:18:54' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 00:19:25 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 18:19:25' and t.time < '2021-12-21 00:19:25' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 00:19:56 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 18:19:56' and t.time < '2021-12-21 00:19:56' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 00:20:27 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 18:20:27' and t.time < '2021-12-21 00:20:27' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 00:20:58 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 18:20:58' and t.time < '2021-12-21 00:20:58' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 00:21:29 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 18:21:29' and t.time < '2021-12-21 00:21:29' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 00:22:00 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 18:22:00' and t.time < '2021-12-21 00:22:00' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 00:22:31 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 18:22:31' and t.time < '2021-12-21 00:22:31' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 00:23:02 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 18:23:02' and t.time < '2021-12-21 00:23:02' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 00:23:33 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 18:23:33' and t.time < '2021-12-21 00:23:33' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 00:24:04 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 18:24:04' and t.time < '2021-12-21 00:24:04' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 00:24:35 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 18:24:35' and t.time < '2021-12-21 00:24:35' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 00:25:06 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 18:25:06' and t.time < '2021-12-21 00:25:06' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 00:25:37 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 18:25:37' and t.time < '2021-12-21 00:25:37' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 00:26:09 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 18:26:09' and t.time < '2021-12-21 00:26:09' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 00:26:39 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 18:26:39' and t.time < '2021-12-21 00:26:39' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 00:27:11 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 18:27:11' and t.time < '2021-12-21 00:27:11' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 00:27:42 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 18:27:42' and t.time < '2021-12-21 00:27:42' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 00:28:12 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 18:28:12' and t.time < '2021-12-21 00:28:12' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 00:28:43 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 18:28:43' and t.time < '2021-12-21 00:28:43' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 00:29:14 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 18:29:14' and t.time < '2021-12-21 00:29:14' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 00:29:45 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 18:29:45' and t.time < '2021-12-21 00:29:45' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 00:30:16 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 18:30:16' and t.time < '2021-12-21 00:30:16' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 00:30:47 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 18:30:47' and t.time < '2021-12-21 00:30:47' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 00:31:18 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 18:31:18' and t.time < '2021-12-21 00:31:18' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 00:31:49 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 18:31:49' and t.time < '2021-12-21 00:31:49' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 00:32:20 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 18:32:20' and t.time < '2021-12-21 00:32:20' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 00:32:51 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 18:32:51' and t.time < '2021-12-21 00:32:51' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 00:33:23 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 18:33:23' and t.time < '2021-12-21 00:33:23' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 00:33:53 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 18:33:53' and t.time < '2021-12-21 00:33:53' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 00:34:25 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 18:34:25' and t.time < '2021-12-21 00:34:25' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 00:34:55 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 18:34:55' and t.time < '2021-12-21 00:34:55' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 00:35:26 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 18:35:26' and t.time < '2021-12-21 00:35:26' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 00:35:58 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 18:35:57' and t.time < '2021-12-21 00:35:57' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 00:36:29 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 18:36:29' and t.time < '2021-12-21 00:36:29' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 00:37:00 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 18:37:00' and t.time < '2021-12-21 00:37:00' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 00:37:30 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 18:37:30' and t.time < '2021-12-21 00:37:30' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 00:38:02 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 18:38:02' and t.time < '2021-12-21 00:38:02' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 00:38:32 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 18:38:32' and t.time < '2021-12-21 00:38:32' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 00:39:04 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 18:39:04' and t.time < '2021-12-21 00:39:04' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 00:39:35 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 18:39:34' and t.time < '2021-12-21 00:39:34' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 00:40:06 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 18:40:06' and t.time < '2021-12-21 00:40:06' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 00:40:37 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 18:40:37' and t.time < '2021-12-21 00:40:37' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 00:41:08 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 18:41:08' and t.time < '2021-12-21 00:41:08' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 00:41:39 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 18:41:39' and t.time < '2021-12-21 00:41:39' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 00:42:10 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 18:42:10' and t.time < '2021-12-21 00:42:10' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 00:42:41 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 18:42:41' and t.time < '2021-12-21 00:42:41' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 00:43:12 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 18:43:12' and t.time < '2021-12-21 00:43:12' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 00:43:43 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 18:43:43' and t.time < '2021-12-21 00:43:43' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 00:44:14 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 18:44:14' and t.time < '2021-12-21 00:44:14' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 00:44:45 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 18:44:45' and t.time < '2021-12-21 00:44:45' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 00:45:16 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 18:45:16' and t.time < '2021-12-21 00:45:16' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 00:45:47 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 18:45:47' and t.time < '2021-12-21 00:45:47' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 00:46:18 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 18:46:18' and t.time < '2021-12-21 00:46:18' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 00:46:49 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 18:46:49' and t.time < '2021-12-21 00:46:49' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 00:47:20 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 18:47:20' and t.time < '2021-12-21 00:47:20' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 00:47:51 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 18:47:51' and t.time < '2021-12-21 00:47:51' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 00:48:22 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 18:48:22' and t.time < '2021-12-21 00:48:22' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 00:48:53 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 18:48:53' and t.time < '2021-12-21 00:48:53' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 00:49:24 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 18:49:24' and t.time < '2021-12-21 00:49:24' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 00:49:55 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 18:49:55' and t.time < '2021-12-21 00:49:55' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 00:50:26 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 18:50:26' and t.time < '2021-12-21 00:50:26' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 00:50:57 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 18:50:57' and t.time < '2021-12-21 00:50:57' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 00:51:28 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 18:51:28' and t.time < '2021-12-21 00:51:28' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 00:51:59 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 18:51:59' and t.time < '2021-12-21 00:51:59' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 00:52:30 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 18:52:30' and t.time < '2021-12-21 00:52:30' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 00:53:01 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 18:53:01' and t.time < '2021-12-21 00:53:01' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 00:53:32 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 18:53:32' and t.time < '2021-12-21 00:53:32' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 00:54:03 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 18:54:03' and t.time < '2021-12-21 00:54:03' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 00:54:34 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 18:54:34' and t.time < '2021-12-21 00:54:34' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 00:55:05 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 18:55:05' and t.time < '2021-12-21 00:55:05' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 00:55:36 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 18:55:36' and t.time < '2021-12-21 00:55:36' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 00:56:07 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 18:56:07' and t.time < '2021-12-21 00:56:07' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 00:56:38 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 18:56:38' and t.time < '2021-12-21 00:56:38' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 00:57:09 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 18:57:09' and t.time < '2021-12-21 00:57:09' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 00:57:40 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 18:57:40' and t.time < '2021-12-21 00:57:40' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 00:58:11 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 18:58:11' and t.time < '2021-12-21 00:58:11' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 00:58:42 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 18:58:42' and t.time < '2021-12-21 00:58:42' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 00:59:13 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 18:59:13' and t.time < '2021-12-21 00:59:13' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 00:59:44 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 18:59:44' and t.time < '2021-12-21 00:59:44' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 01:00:15 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 19:00:15' and t.time < '2021-12-21 01:00:15' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 01:00:46 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 19:00:46' and t.time < '2021-12-21 01:00:46' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 01:01:17 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 19:01:17' and t.time < '2021-12-21 01:01:17' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 01:01:48 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 19:01:48' and t.time < '2021-12-21 01:01:48' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 01:02:19 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 19:02:19' and t.time < '2021-12-21 01:02:19' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 01:02:50 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 19:02:50' and t.time < '2021-12-21 01:02:50' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 01:03:21 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 19:03:21' and t.time < '2021-12-21 01:03:21' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 01:03:52 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 19:03:52' and t.time < '2021-12-21 01:03:52' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 01:04:23 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 19:04:23' and t.time < '2021-12-21 01:04:23' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 01:04:54 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 19:04:54' and t.time < '2021-12-21 01:04:54' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 01:05:25 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 19:05:25' and t.time < '2021-12-21 01:05:25' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 01:05:56 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 19:05:56' and t.time < '2021-12-21 01:05:56' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 01:06:27 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 19:06:27' and t.time < '2021-12-21 01:06:27' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 01:06:58 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 19:06:58' and t.time < '2021-12-21 01:06:58' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 01:07:29 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 19:07:29' and t.time < '2021-12-21 01:07:29' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 01:08:00 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 19:08:00' and t.time < '2021-12-21 01:08:00' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 01:08:31 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 19:08:31' and t.time < '2021-12-21 01:08:31' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 01:09:02 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 19:09:02' and t.time < '2021-12-21 01:09:02' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 01:09:33 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 19:09:33' and t.time < '2021-12-21 01:09:33' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 01:10:04 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 19:10:04' and t.time < '2021-12-21 01:10:04' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 01:10:35 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 19:10:35' and t.time < '2021-12-21 01:10:35' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 01:11:06 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 19:11:06' and t.time < '2021-12-21 01:11:06' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 01:11:37 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 19:11:37' and t.time < '2021-12-21 01:11:37' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 01:12:08 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 19:12:08' and t.time < '2021-12-21 01:12:08' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 01:12:39 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 19:12:39' and t.time < '2021-12-21 01:12:39' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 01:13:10 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 19:13:10' and t.time < '2021-12-21 01:13:10' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 01:13:41 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 19:13:41' and t.time < '2021-12-21 01:13:41' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 01:14:12 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 19:14:12' and t.time < '2021-12-21 01:14:12' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 01:14:43 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 19:14:43' and t.time < '2021-12-21 01:14:43' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 01:15:14 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 19:15:14' and t.time < '2021-12-21 01:15:14' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 01:15:45 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 19:15:45' and t.time < '2021-12-21 01:15:45' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 01:16:16 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 19:16:16' and t.time < '2021-12-21 01:16:16' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 01:16:47 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 19:16:47' and t.time < '2021-12-21 01:16:47' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 01:17:18 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 19:17:18' and t.time < '2021-12-21 01:17:18' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 01:17:49 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 19:17:49' and t.time < '2021-12-21 01:17:49' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 01:18:20 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 19:18:20' and t.time < '2021-12-21 01:18:20' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 01:18:51 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 19:18:51' and t.time < '2021-12-21 01:18:51' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 01:19:22 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 19:19:22' and t.time < '2021-12-21 01:19:22' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 01:19:53 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 19:19:53' and t.time < '2021-12-21 01:19:53' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 01:20:24 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 19:20:24' and t.time < '2021-12-21 01:20:24' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 01:20:55 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 19:20:55' and t.time < '2021-12-21 01:20:55' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 01:21:26 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 19:21:26' and t.time < '2021-12-21 01:21:26' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 01:21:57 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 19:21:57' and t.time < '2021-12-21 01:21:57' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 01:22:28 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 19:22:28' and t.time < '2021-12-21 01:22:28' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 01:22:59 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 19:22:59' and t.time < '2021-12-21 01:22:59' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 01:23:30 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 19:23:30' and t.time < '2021-12-21 01:23:30' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 01:24:01 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 19:24:01' and t.time < '2021-12-21 01:24:01' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 01:24:32 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 19:24:32' and t.time < '2021-12-21 01:24:32' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 01:25:03 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 19:25:03' and t.time < '2021-12-21 01:25:03' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 01:25:34 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 19:25:34' and t.time < '2021-12-21 01:25:34' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 01:26:05 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 19:26:05' and t.time < '2021-12-21 01:26:05' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 01:26:36 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 19:26:36' and t.time < '2021-12-21 01:26:36' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 01:27:07 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 19:27:07' and t.time < '2021-12-21 01:27:07' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 01:27:38 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-20 19:27:38' and t.time < '2021-12-21 01:27:38' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 07:30:11 <BR>  <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 :0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-21 01:30:11' and t.time < '2021-12-21 07:30:11' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 08:15:53 <BR>  <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 :0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-21 02:15:53' and t.time < '2021-12-21 08:15:53' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 08:24:43 <BR>  <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 :0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-21 02:24:43' and t.time < '2021-12-21 08:24:43' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 17:14:38 <BR>  <BR> SELECT t.id,t.date,c.car_name,t.description,t.client,t.adress_to,t.adress_from,t.customer,t.target FROM tms_tasks t INNER JOIN wm_car_info c ON t.imei=c.imei WHERE DATE='2021-12-21' AND t.client_id= ORDER BY t.imei ASC;
2021-12-21 17:14:42 <BR>  <BR> SELECT ci.id, ci.car_name,ci.fuel,ci.model,ci.fuel_type,ci.atp,ci.company,ci.imei, d.NAME AS driver_name FROM wm_car_info ci LEFT JOIN wm_drivers d ON ci.driver_id = d.id WHERE ci.client_id =  ORDER BY ci.car_name ASC
2021-12-21 17:14:48 <BR>  <BR> SELECT COUNT(*),u.role_id, u.client_id, u.id, u.frequency, s.milestone,s.MapCenter_longitude,s.MapCenter_latitude,s.defaultMap_scale,s.gmt,s.use_fixed_data,c.is_blocked,b.balance,s.time_track,s.dist_track, s.car_name_format FROM wm_users AS u LEFT JOIN wm_settings AS s ON u.client_id = s.client_id LEFT JOIN wm_clients c on u.client_id=c.id LEFT JOIN wm_balances b ON b.client_id=c.id WHERE (u.`login`='cola-admin' AND u.`password`='7a04440e92466d362697f4929b71c3bd')
2021-12-21 17:14:48 <BR> 53 <BR> SELECT t.id,t.date,c.car_name,t.description,t.client,t.adress_to,t.adress_from,t.customer,t.target FROM tms_tasks t INNER JOIN wm_car_info c ON t.imei=c.imei WHERE DATE='2021-12-21' AND t.client_id=53 ORDER BY t.imei ASC;
2021-12-21 17:14:50 <BR> 53 <BR> SELECT ci.id, ci.car_name,ci.fuel,ci.model,ci.fuel_type,ci.atp,ci.company,ci.imei, d.NAME AS driver_name FROM wm_car_info ci LEFT JOIN wm_drivers d ON ci.driver_id = d.id WHERE ci.client_id = 53 ORDER BY ci.car_name ASC
2021-12-21 17:14:52 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-21 11:14:52' and t.time < '2021-12-21 17:14:52' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 17:35:20 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-21 11:35:20' and t.time < '2021-12-21 17:35:20' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 17:53:49 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-21 11:53:49' and t.time < '2021-12-21 17:53:49' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 18:07:16 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-21 12:07:16' and t.time < '2021-12-21 18:07:16' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 18:14:50 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-21 12:14:50' and t.time < '2021-12-21 18:14:50' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 18:19:56 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-21 12:19:56' and t.time < '2021-12-21 18:19:56' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 18:20:10 <BR> 53 <BR> SELECT ci.id, ci.car_name,ci.fuel,ci.model,ci.fuel_type,ci.atp,ci.company,ci.imei, d.NAME AS driver_name FROM wm_car_info ci LEFT JOIN wm_drivers d ON ci.driver_id = d.id WHERE ci.client_id = 53 ORDER BY ci.car_name ASC
2021-12-21 18:20:11 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-21 12:20:11' and t.time < '2021-12-21 18:20:11' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 18:20:52 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-21 12:20:52' and t.time < '2021-12-21 18:20:52' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 18:21:34 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-21 12:21:34' and t.time < '2021-12-21 18:21:34' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 18:23:53 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-21 12:23:53' and t.time < '2021-12-21 18:23:53' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 18:53:52 <BR>  <BR> SELECT t.id,t.date,c.car_name,t.description,t.client,t.adress_to,t.adress_from,t.customer,t.target FROM tms_tasks t INNER JOIN wm_car_info c ON t.imei=c.imei WHERE DATE='2021-12-21' AND t.client_id= ORDER BY t.imei ASC;
2021-12-21 18:53:53 <BR>  <BR> SELECT ci.id, ci.car_name,ci.fuel,ci.model,ci.fuel_type,ci.atp,ci.company,ci.imei, d.NAME AS driver_name FROM wm_car_info ci LEFT JOIN wm_drivers d ON ci.driver_id = d.id WHERE ci.client_id =  ORDER BY ci.car_name ASC
2021-12-21 18:53:59 <BR>  <BR> SELECT COUNT(*),u.role_id, u.client_id, u.id, u.frequency, s.milestone,s.MapCenter_longitude,s.MapCenter_latitude,s.defaultMap_scale,s.gmt,s.use_fixed_data,c.is_blocked,b.balance,s.time_track,s.dist_track, s.car_name_format FROM wm_users AS u LEFT JOIN wm_settings AS s ON u.client_id = s.client_id LEFT JOIN wm_clients c on u.client_id=c.id LEFT JOIN wm_balances b ON b.client_id=c.id WHERE (u.`login`='cola-admin' AND u.`password`='7a04440e92466d362697f4929b71c3bd')
2021-12-21 18:54:00 <BR> 53 <BR> SELECT t.id,t.date,c.car_name,t.description,t.client,t.adress_to,t.adress_from,t.customer,t.target FROM tms_tasks t INNER JOIN wm_car_info c ON t.imei=c.imei WHERE DATE='2021-12-21' AND t.client_id=53 ORDER BY t.imei ASC;
2021-12-21 18:54:01 <BR> 53 <BR> SELECT ci.id, ci.car_name,ci.fuel,ci.model,ci.fuel_type,ci.atp,ci.company,ci.imei, d.NAME AS driver_name FROM wm_car_info ci LEFT JOIN wm_drivers d ON ci.driver_id = d.id WHERE ci.client_id = 53 ORDER BY ci.car_name ASC
2021-12-21 18:54:04 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-21 12:54:04' and t.time < '2021-12-21 18:54:04' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 19:04:41 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-21 13:04:41' and t.time < '2021-12-21 19:04:41' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 19:06:58 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-21 13:06:58' and t.time < '2021-12-21 19:06:58' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 19:16:11 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-21 13:16:11' and t.time < '2021-12-21 19:16:11' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 19:45:57 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-21 13:45:57' and t.time < '2021-12-21 19:45:57' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 20:07:08 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-21 14:07:08' and t.time < '2021-12-21 20:07:08' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 20:17:59 <BR>  <BR> SELECT t.id,t.date,c.car_name,t.description,t.client,t.adress_to,t.adress_from,t.customer,t.target FROM tms_tasks t INNER JOIN wm_car_info c ON t.imei=c.imei WHERE DATE='2021-12-21' AND t.client_id= ORDER BY t.imei ASC;
2021-12-21 20:18:01 <BR>  <BR> SELECT ci.id, ci.car_name,ci.fuel,ci.model,ci.fuel_type,ci.atp,ci.company,ci.imei, d.NAME AS driver_name FROM wm_car_info ci LEFT JOIN wm_drivers d ON ci.driver_id = d.id WHERE ci.client_id =  ORDER BY ci.car_name ASC
2021-12-21 20:18:05 <BR>  <BR> SELECT COUNT(*),u.role_id, u.client_id, u.id, u.frequency, s.milestone,s.MapCenter_longitude,s.MapCenter_latitude,s.defaultMap_scale,s.gmt,s.use_fixed_data,c.is_blocked,b.balance,s.time_track,s.dist_track, s.car_name_format FROM wm_users AS u LEFT JOIN wm_settings AS s ON u.client_id = s.client_id LEFT JOIN wm_clients c on u.client_id=c.id LEFT JOIN wm_balances b ON b.client_id=c.id WHERE (u.`login`='cola-admin' AND u.`password`='7a04440e92466d362697f4929b71c3bd')
2021-12-21 20:18:06 <BR> 53 <BR> SELECT t.id,t.date,c.car_name,t.description,t.client,t.adress_to,t.adress_from,t.customer,t.target FROM tms_tasks t INNER JOIN wm_car_info c ON t.imei=c.imei WHERE DATE='2021-12-21' AND t.client_id=53 ORDER BY t.imei ASC;
2021-12-21 20:18:07 <BR> 53 <BR> SELECT ci.id, ci.car_name,ci.fuel,ci.model,ci.fuel_type,ci.atp,ci.company,ci.imei, d.NAME AS driver_name FROM wm_car_info ci LEFT JOIN wm_drivers d ON ci.driver_id = d.id WHERE ci.client_id = 53 ORDER BY ci.car_name ASC
2021-12-21 20:18:10 <BR> 53 <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 2:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-12-21 14:18:10' and t.time < '2021-12-21 20:18:10' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-21 20:35:27 <BR>  <BR> SELECT t.id,t.date,c.car_name,t.description,t.client,t.adress_to,t.adress_from,t.customer,t.target FROM tms_tasks t INNER JOIN wm_car_info c ON t.imei=c.imei WHERE DATE='2021-12-21' AND t.client_id= ORDER BY t.imei ASC;