2021-09-17 16:40:10
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-09-17' AND t.client_id= ORDER BY t.imei ASC;
2021-09-17 16:40:20
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-09-17 16:40:21
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-09-17' AND t.client_id=53 ORDER BY t.imei ASC;
2021-09-17 16:40:23
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-09-17 16:40:29
53
SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 3:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-09-17 10:40:29' and t.time < '2021-09-17 16:40:29' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-09-17 16:40:59
53
SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 3:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-09-17 10:40:59' and t.time < '2021-09-17 16:40:59' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-09-17 16:41:30
53
SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 3:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-09-17 10:41:30' and t.time < '2021-09-17 16:41:30' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-09-17 16:45:13
53
SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 3:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-09-17 10:45:13' and t.time < '2021-09-17 16:45:13' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-09-17 16:45:16
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-09-17 16:45:20
53
SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 3:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-09-17 10:45:20' and t.time < '2021-09-17 16:45:20' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-09-17 16:45:51
53
SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 3:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-09-17 10:45:51' and t.time < '2021-09-17 16:45:51' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-09-17 16:45:55
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-09-17 16:45:59
53
SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 3:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-09-17 10:45:59' and t.time < '2021-09-17 16:45:59' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-09-17 16:55:19
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-09-17' AND t.client_id= ORDER BY t.imei ASC;
2021-09-17 16:55:23
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-09-17 16:55:30
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-09-17 16:55:30
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-09-17' AND t.client_id=53 ORDER BY t.imei ASC;
2021-09-17 16:55:32
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-09-17 16:55:36
53
SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 3:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-09-17 10:55:36' and t.time < '2021-09-17 16:55:36' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-09-17 16:56:06
53
SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 3:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-09-17 10:56:06' and t.time < '2021-09-17 16:56:06' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-09-17 17:03:41
53
SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 3:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-09-17 11:03:41' and t.time < '2021-09-17 17:03:41' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-09-17 17:13:50
53
SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 3:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-09-17 11:13:50' and t.time < '2021-09-17 17:13:50' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-09-17 17:24:51
53
SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 3:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-09-17 11:24:51' and t.time < '2021-09-17 17:24:51' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-09-17 17:25:21
53
SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 3:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-09-17 11:25:21' and t.time < '2021-09-17 17:25:21' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-09-17 17:30:59
53
SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 3:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-09-17 11:30:59' and t.time < '2021-09-17 17:30:59' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-09-17 17:31:29
53
SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 3:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-09-17 11:31:29' and t.time < '2021-09-17 17:31:29' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-09-17 17:32:00
53
SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 3:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-09-17 11:32:00' and t.time < '2021-09-17 17:32:00' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-09-17 17:32:31
53
SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 3:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-09-17 11:32:31' and t.time < '2021-09-17 17:32:31' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-09-17 17:33:02
53
SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 3:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-09-17 11:33:02' and t.time < '2021-09-17 17:33:02' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-09-17 17:33:33
53
SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 3:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-09-17 11:33:33' and t.time < '2021-09-17 17:33:33' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-09-17 17:34:04
53
SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 3:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-09-17 11:34:04' and t.time < '2021-09-17 17:34:04' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-09-17 17:35:11
53
SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 3:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-09-17 11:35:11' and t.time < '2021-09-17 17:35:11' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-09-17 17:57:18
53
SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 3:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-09-17 11:57:18' and t.time < '2021-09-17 17:57:18' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-09-17 17:57:48
53
SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 3:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-09-17 11:57:48' and t.time < '2021-09-17 17:57:48' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-09-17 18:03:05
53
SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 3:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-09-17 12:03:05' and t.time < '2021-09-17 18:03:05' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-09-17 18:03:36
53
SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 3:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-09-17 12:03:36' and t.time < '2021-09-17 18:03:36' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-09-17 18:12:21
53
SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 3:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-09-17 12:12:21' and t.time < '2021-09-17 18:12:21' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-09-17 18:12:51
53
SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 3:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-09-17 12:12:51' and t.time < '2021-09-17 18:12:51' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-09-17 18:16:10
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-09-17' AND t.client_id= ORDER BY t.imei ASC;
2021-09-17 18:16:19
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-09-17 18:16:19
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-09-17' AND t.client_id=53 ORDER BY t.imei ASC;
2021-09-17 18:16:20
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-09-17 18:16:23
53
SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 3:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-09-17 12:16:23' and t.time < '2021-09-17 18:16:23' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-09-17 18:18:14
53
SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 3:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-09-17 12:18:14' and t.time < '2021-09-17 18:18:14' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-09-17 18:35:48
53
SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 3:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-09-17 12:35:48' and t.time < '2021-09-17 18:35:48' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-09-17 18:36:45
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-09-17 18:36:45
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-09-17' AND t.client_id=53 ORDER BY t.imei ASC;
2021-09-17 18:36:47
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-09-17 18:36:52
53
SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 3:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-09-17 12:36:52' and t.time < '2021-09-17 18:36:52' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-09-17 18:37:22
53
SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 3:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-09-17 12:37:22' and t.time < '2021-09-17 18:37:22' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-09-17 18:37:52
53
SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 3:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-09-17 12:37:52' and t.time < '2021-09-17 18:37:52' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-09-17 18:38:22
53
SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 3:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-09-17 12:38:22' and t.time < '2021-09-17 18:38:22' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-09-17 18:38:52
53
SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 3:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-09-17 12:38:52' and t.time < '2021-09-17 18:38:52' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-09-17 18:39:22
53
SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 3:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-09-17 12:39:22' and t.time < '2021-09-17 18:39:22' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-09-17 18:39:53
53
SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 3:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-09-17 12:39:53' and t.time < '2021-09-17 18:39:53' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-09-17 18:40:24
53
SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 3:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-09-17 12:40:24' and t.time < '2021-09-17 18:40:24' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-09-17 18:40:55
53
SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 3:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-09-17 12:40:55' and t.time < '2021-09-17 18:40:55' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-09-17 18:41:26
53
SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 3:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-09-17 12:41:26' and t.time < '2021-09-17 18:41:26' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-09-17 18:41:57
53
SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 3:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-09-17 12:41:57' and t.time < '2021-09-17 18:41:57' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-09-17 18:42:28
53
SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 3:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-09-17 12:42:28' and t.time < '2021-09-17 18:42:28' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-09-17 18:42:59
53
SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 3:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-09-17 12:42:59' and t.time < '2021-09-17 18:42:59' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-09-17 18:43:30
53
SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 3:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-09-17 12:43:30' and t.time < '2021-09-17 18:43:30' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-09-17 18:44:01
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-09-17' AND t.client_id= ORDER BY t.imei ASC;
2021-09-17 18:44:03
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-09-17 18:44:09
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-09-17 18:44:09
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-09-17' AND t.client_id=53 ORDER BY t.imei ASC;
2021-09-17 18:44: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-09-17 18:44:14
53
SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 3:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-09-17 12:44:14' and t.time < '2021-09-17 18:44:14' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-09-17 19:02:01
53
SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 3:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-09-17 13:02:01' and t.time < '2021-09-17 19:02:01' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-09-17 19:23:52
53
SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 3:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-09-17 13:23:52' and t.time < '2021-09-17 19:23:52' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-09-17 19:24:50
53
SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 3:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-09-17 13:24:50' and t.time < '2021-09-17 19:24:50' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-09-17 19:30:07
53
SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 3:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-09-17 13:30:07' and t.time < '2021-09-17 19:30:07' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-09-17 19:30:37
53
SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 3:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-09-17 13:30:37' and t.time < '2021-09-17 19:30:37' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-09-17 20:07:59
53
SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 3:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-09-17 14:07:59' and t.time < '2021-09-17 20:07:59' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-09-17 20:21:57
53
SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 3:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-09-17 14:21:57' and t.time < '2021-09-17 20:21:57' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-09-17 20:22:27
53
SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 3:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-09-17 14:22:27' and t.time < '2021-09-17 20:22:27' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-09-17 20:22:57
53
SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 3:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-09-17 14:22:57' and t.time < '2021-09-17 20:22:57' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-09-17 20:23:28
53
SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 3:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-09-17 14:23:28' and t.time < '2021-09-17 20:23:28' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-09-17 21:59:54
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-09-17 15:59:54' and t.time < '2021-09-17 21:59:54' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-09-17 22:00:25
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-09-17 16:00:25' and t.time < '2021-09-17 22:00:25' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-09-17 22:00:56
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-09-17 16:00:56' and t.time < '2021-09-17 22:00:56' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-09-17 22:01:27
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-09-17 16:01:27' and t.time < '2021-09-17 22:01:27' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-09-17 22:01:58
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-09-17 16:01:58' and t.time < '2021-09-17 22:01:58' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-09-17 22:02:29
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-09-17 16:02:29' and t.time < '2021-09-17 22:02:29' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-09-17 22:03:00
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-09-17 16:03:00' and t.time < '2021-09-17 22:03:00' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-09-17 22:03:31
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-09-17 16:03:31' and t.time < '2021-09-17 22:03:31' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-09-17 22:04:02
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-09-17 16:04:02' and t.time < '2021-09-17 22:04:02' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-09-17 22:04:33
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-09-17 16:04:33' and t.time < '2021-09-17 22:04:33' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-09-17 22:05:04
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-09-17 16:05:04' and t.time < '2021-09-17 22:05:04' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-09-17 22:05:34
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-09-17 16:05:34' and t.time < '2021-09-17 22:05:34' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC
2021-09-17 22:06:59
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-09-17 16:06:59' and t.time < '2021-09-17 22:06:59' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC