2021-12-21 00:01: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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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
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
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
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
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
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
53
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
53
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
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-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
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-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
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-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
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-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
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-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
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-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
53
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
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-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
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-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
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-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
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-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
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
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
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
53
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
53
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
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-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
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-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
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-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
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-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
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-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
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-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
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
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
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
53
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
53
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
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-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
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;