2021-12-17 00:00:17
53
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-16 18:00:17' and t.time < '2021-12-17 00:00:17' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-17 00:00:48
53
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-16 18:00:48' and t.time < '2021-12-17 00:00:48' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-17 00:01:19
53
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-16 18:01:19' and t.time < '2021-12-17 00:01:19' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-17 00:01:50
53
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-16 18:01:50' and t.time < '2021-12-17 00:01:50' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-17 00:02:21
53
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-16 18:02:21' and t.time < '2021-12-17 00:02:21' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-17 00:02:52
53
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-16 18:02:52' and t.time < '2021-12-17 00:02:52' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-17 00:03:23
53
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-16 18:03:23' and t.time < '2021-12-17 00:03:23' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-17 00:03:54
53
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-16 18:03:54' and t.time < '2021-12-17 00:03:54' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-17 00:04:25
53
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-16 18:04:25' and t.time < '2021-12-17 00:04:25' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-17 00:04:56
53
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-16 18:04:56' and t.time < '2021-12-17 00:04:56' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-17 00:05:27
53
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-16 18:05:27' and t.time < '2021-12-17 00:05:27' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-17 00:05:58
53
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-16 18:05:58' and t.time < '2021-12-17 00:05:58' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-17 00:06:29
53
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-16 18:06:29' and t.time < '2021-12-17 00:06:29' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-17 00:07:00
53
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-16 18:07:00' and t.time < '2021-12-17 00:07:00' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-17 00:07:31
53
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-16 18:07:31' and t.time < '2021-12-17 00:07:31' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-17 00:08:02
53
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-16 18:08:02' and t.time < '2021-12-17 00:08:02' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-17 00:08:33
53
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-16 18:08:33' and t.time < '2021-12-17 00:08:33' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-17 00:09:04
53
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-16 18:09:04' and t.time < '2021-12-17 00:09:04' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-17 00:09:35
53
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-16 18:09:35' and t.time < '2021-12-17 00:09:35' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-17 00:10:06
53
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-16 18:10:06' and t.time < '2021-12-17 00:10:06' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-17 00:10:37
53
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-16 18:10:37' and t.time < '2021-12-17 00:10:37' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-17 00:11:08
53
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-16 18:11:08' and t.time < '2021-12-17 00:11:08' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-17 00:11:39
53
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-16 18:11:39' and t.time < '2021-12-17 00:11:39' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-17 00:12:10
53
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-16 18:12:10' and t.time < '2021-12-17 00:12:10' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-17 00:12:41
53
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-16 18:12:41' and t.time < '2021-12-17 00:12:41' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-17 00:13:12
53
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-16 18:13:12' and t.time < '2021-12-17 00:13:12' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-17 00:13:43
53
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-16 18:13:43' and t.time < '2021-12-17 00:13:43' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-17 00:14:14
53
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-16 18:14:14' and t.time < '2021-12-17 00:14:14' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-17 00:14:45
53
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-16 18:14:45' and t.time < '2021-12-17 00:14:45' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-17 00:15:16
53
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-16 18:15:16' and t.time < '2021-12-17 00:15:16' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-17 00:15:47
53
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-16 18:15:47' and t.time < '2021-12-17 00:15:47' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-17 00:16:18
53
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-16 18:16:18' and t.time < '2021-12-17 00:16:18' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-17 00:16:49
53
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-16 18:16:49' and t.time < '2021-12-17 00:16:49' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-17 00:17:20
53
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-16 18:17:20' and t.time < '2021-12-17 00:17:20' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-17 00:17:51
53
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-16 18:17:51' and t.time < '2021-12-17 00:17:51' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-17 00:18:22
53
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-16 18:18:22' and t.time < '2021-12-17 00:18:22' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-17 00:18:53
53
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-16 18:18:53' and t.time < '2021-12-17 00:18:53' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-17 00:19:24
53
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-16 18:19:24' and t.time < '2021-12-17 00:19:24' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-17 00:19:55
53
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-16 18:19:55' and t.time < '2021-12-17 00:19:55' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-17 00:20:26
53
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-16 18:20:26' and t.time < '2021-12-17 00:20:26' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-17 00:20:57
53
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-16 18:20:57' and t.time < '2021-12-17 00:20:57' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-17 00:21:28
53
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-16 18:21:28' and t.time < '2021-12-17 00:21:28' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-17 00:21:59
53
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-16 18:21:59' and t.time < '2021-12-17 00:21:59' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-17 00:22:30
53
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-16 18:22:30' and t.time < '2021-12-17 00:22:30' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-17 00:23:01
53
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-16 18:23:01' and t.time < '2021-12-17 00:23:01' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-17 00:23:32
53
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-16 18:23:32' and t.time < '2021-12-17 00:23:32' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-17 00:24:03
53
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-16 18:24:03' and t.time < '2021-12-17 00:24:03' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-17 00:24:34
53
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-16 18:24:34' and t.time < '2021-12-17 00:24:34' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-17 00:25:05
53
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-16 18:25:05' and t.time < '2021-12-17 00:25:05' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-17 00:25:36
53
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-16 18:25:36' and t.time < '2021-12-17 00:25:36' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-17 00:26:07
53
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-16 18:26:07' and t.time < '2021-12-17 00:26:07' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-17 00:26:38
53
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-16 18:26:38' and t.time < '2021-12-17 00:26:38' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-17 00:27:09
53
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-16 18:27:09' and t.time < '2021-12-17 00:27:09' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-17 00:27:40
53
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-16 18:27:40' and t.time < '2021-12-17 00:27:40' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-17 00:28:11
53
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-16 18:28:11' and t.time < '2021-12-17 00:28:11' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-17 00:28:42
53
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-16 18:28:42' and t.time < '2021-12-17 00:28:42' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-17 00:29:13
53
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-16 18:29:13' and t.time < '2021-12-17 00:29:13' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-17 00:29:44
53
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-16 18:29:44' and t.time < '2021-12-17 00:29:44' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-17 00:30:15
53
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-16 18:30:15' and t.time < '2021-12-17 00:30:15' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-17 00:30:46
53
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-16 18:30:46' and t.time < '2021-12-17 00:30:46' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-17 00:31:17
53
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-16 18:31:17' and t.time < '2021-12-17 00:31:17' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-17 00:31:48
53
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-16 18:31:48' and t.time < '2021-12-17 00:31:48' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-17 00:32:19
53
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-16 18:32:19' and t.time < '2021-12-17 00:32:19' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-17 00:32:50
53
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-16 18:32:50' and t.time < '2021-12-17 00:32:50' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-17 00:33:21
53
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-16 18:33:21' and t.time < '2021-12-17 00:33:21' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-17 00:33:52
53
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-16 18:33:52' and t.time < '2021-12-17 00:33:52' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-17 00:34:23
53
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-16 18:34:23' and t.time < '2021-12-17 00:34:23' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-17 00:34:54
53
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-16 18:34:54' and t.time < '2021-12-17 00:34:54' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-17 00:35:25
53
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-16 18:35:25' and t.time < '2021-12-17 00:35:25' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-17 00:35:56
53
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-16 18:35:56' and t.time < '2021-12-17 00:35:56' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-17 00:36:27
53
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-16 18:36:27' and t.time < '2021-12-17 00:36:27' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-17 00:36:58
53
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-16 18:36:58' and t.time < '2021-12-17 00:36:58' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-17 00:37:29
53
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-16 18:37:29' and t.time < '2021-12-17 00:37:29' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-17 00:38:00
53
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-16 18:38:00' and t.time < '2021-12-17 00:38:00' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-17 00:38:31
53
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-16 18:38:31' and t.time < '2021-12-17 00:38:31' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-17 00:39:02
53
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-16 18:39:02' and t.time < '2021-12-17 00:39:02' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-17 00:39:33
53
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-16 18:39:33' and t.time < '2021-12-17 00:39:33' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-17 00:40:04
53
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-16 18:40:04' and t.time < '2021-12-17 00:40:04' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-17 00:40:35
53
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-16 18:40:35' and t.time < '2021-12-17 00:40:35' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-17 00:41:06
53
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-16 18:41:06' and t.time < '2021-12-17 00:41:06' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-12-17 06:59:35
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-17 00:59:35' and t.time < '2021-12-17 06:59:35' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC