2021-09-17 16:40:10 <BR>  <BR> SELECT t.id,t.date,c.car_name,t.description,t.client,t.adress_to,t.adress_from,t.customer,t.target FROM tms_tasks t INNER JOIN wm_car_info c ON t.imei=c.imei WHERE DATE='2021-09-17' AND t.client_id= ORDER BY t.imei ASC;
2021-09-17 16:40:20 <BR>  <BR> SELECT COUNT(*),u.role_id, u.client_id, u.id, u.frequency, s.milestone,s.MapCenter_longitude,s.MapCenter_latitude,s.defaultMap_scale,s.gmt,s.use_fixed_data,c.is_blocked,b.balance,s.time_track,s.dist_track, s.car_name_format FROM wm_users AS u LEFT JOIN wm_settings AS s ON u.client_id = s.client_id LEFT JOIN wm_clients c on u.client_id=c.id LEFT JOIN wm_balances b ON b.client_id=c.id WHERE (u.`login`='cola-admin' AND u.`password`='7a04440e92466d362697f4929b71c3bd')
2021-09-17 16:40:21 <BR> 53 <BR> SELECT t.id,t.date,c.car_name,t.description,t.client,t.adress_to,t.adress_from,t.customer,t.target FROM tms_tasks t INNER JOIN wm_car_info c ON t.imei=c.imei WHERE DATE='2021-09-17' AND t.client_id=53 ORDER BY t.imei ASC;
2021-09-17 16:40:23 <BR> 53 <BR> SELECT ci.id, ci.car_name,ci.fuel,ci.model,ci.fuel_type,ci.atp,ci.company,ci.imei, d.NAME AS driver_name FROM wm_car_info ci LEFT JOIN wm_drivers d ON ci.driver_id = d.id WHERE ci.client_id = 53 ORDER BY ci.car_name ASC
2021-09-17 16:40:29 <BR> 53 <BR> 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 <BR> 53 <BR> 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 <BR> 53 <BR> 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 <BR> 53 <BR> 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 <BR> 53 <BR> SELECT ci.id, ci.car_name,ci.fuel,ci.model,ci.fuel_type,ci.atp,ci.company,ci.imei, d.NAME AS driver_name FROM wm_car_info ci LEFT JOIN wm_drivers d ON ci.driver_id = d.id WHERE ci.client_id = 53 ORDER BY ci.car_name ASC
2021-09-17 16:45:20 <BR> 53 <BR> 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 <BR> 53 <BR> 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 <BR> 53 <BR> SELECT ci.id, ci.car_name,ci.fuel,ci.model,ci.fuel_type,ci.atp,ci.company,ci.imei, d.NAME AS driver_name FROM wm_car_info ci LEFT JOIN wm_drivers d ON ci.driver_id = d.id WHERE ci.client_id = 53 ORDER BY ci.car_name ASC
2021-09-17 16:45:59 <BR> 53 <BR> 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 <BR>  <BR> SELECT t.id,t.date,c.car_name,t.description,t.client,t.adress_to,t.adress_from,t.customer,t.target FROM tms_tasks t INNER JOIN wm_car_info c ON t.imei=c.imei WHERE DATE='2021-09-17' AND t.client_id= ORDER BY t.imei ASC;
2021-09-17 16:55:23 <BR>  <BR> SELECT ci.id, ci.car_name,ci.fuel,ci.model,ci.fuel_type,ci.atp,ci.company,ci.imei, d.NAME AS driver_name FROM wm_car_info ci LEFT JOIN wm_drivers d ON ci.driver_id = d.id WHERE ci.client_id =  ORDER BY ci.car_name ASC
2021-09-17 16:55:30 <BR>  <BR> SELECT COUNT(*),u.role_id, u.client_id, u.id, u.frequency, s.milestone,s.MapCenter_longitude,s.MapCenter_latitude,s.defaultMap_scale,s.gmt,s.use_fixed_data,c.is_blocked,b.balance,s.time_track,s.dist_track, s.car_name_format FROM wm_users AS u LEFT JOIN wm_settings AS s ON u.client_id = s.client_id LEFT JOIN wm_clients c on u.client_id=c.id LEFT JOIN wm_balances b ON b.client_id=c.id WHERE (u.`login`='cola-admin' AND u.`password`='7a04440e92466d362697f4929b71c3bd')
2021-09-17 16:55:30 <BR> 53 <BR> SELECT t.id,t.date,c.car_name,t.description,t.client,t.adress_to,t.adress_from,t.customer,t.target FROM tms_tasks t INNER JOIN wm_car_info c ON t.imei=c.imei WHERE DATE='2021-09-17' AND t.client_id=53 ORDER BY t.imei ASC;
2021-09-17 16:55:32 <BR> 53 <BR> SELECT ci.id, ci.car_name,ci.fuel,ci.model,ci.fuel_type,ci.atp,ci.company,ci.imei, d.NAME AS driver_name FROM wm_car_info ci LEFT JOIN wm_drivers d ON ci.driver_id = d.id WHERE ci.client_id = 53 ORDER BY ci.car_name ASC
2021-09-17 16:55:36 <BR> 53 <BR> 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 <BR> 53 <BR> 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 <BR> 53 <BR> 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 <BR> 53 <BR> 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 <BR> 53 <BR> 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 <BR> 53 <BR> 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 <BR> 53 <BR> 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 <BR> 53 <BR> 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 <BR> 53 <BR> 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 <BR> 53 <BR> 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 <BR> 53 <BR> 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 <BR> 53 <BR> 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 <BR> 53 <BR> 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 <BR> 53 <BR> 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 <BR> 53 <BR> 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 <BR> 53 <BR> 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 <BR> 53 <BR> 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 <BR> 53 <BR> 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 <BR> 53 <BR> 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 <BR> 53 <BR> 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 <BR>  <BR> SELECT t.id,t.date,c.car_name,t.description,t.client,t.adress_to,t.adress_from,t.customer,t.target FROM tms_tasks t INNER JOIN wm_car_info c ON t.imei=c.imei WHERE DATE='2021-09-17' AND t.client_id= ORDER BY t.imei ASC;
2021-09-17 18:16:19 <BR>  <BR> SELECT COUNT(*),u.role_id, u.client_id, u.id, u.frequency, s.milestone,s.MapCenter_longitude,s.MapCenter_latitude,s.defaultMap_scale,s.gmt,s.use_fixed_data,c.is_blocked,b.balance,s.time_track,s.dist_track, s.car_name_format FROM wm_users AS u LEFT JOIN wm_settings AS s ON u.client_id = s.client_id LEFT JOIN wm_clients c on u.client_id=c.id LEFT JOIN wm_balances b ON b.client_id=c.id WHERE (u.`login`='cola-admin' AND u.`password`='7a04440e92466d362697f4929b71c3bd')
2021-09-17 18:16:19 <BR> 53 <BR> SELECT t.id,t.date,c.car_name,t.description,t.client,t.adress_to,t.adress_from,t.customer,t.target FROM tms_tasks t INNER JOIN wm_car_info c ON t.imei=c.imei WHERE DATE='2021-09-17' AND t.client_id=53 ORDER BY t.imei ASC;
2021-09-17 18:16:20 <BR> 53 <BR> SELECT ci.id, ci.car_name,ci.fuel,ci.model,ci.fuel_type,ci.atp,ci.company,ci.imei, d.NAME AS driver_name FROM wm_car_info ci LEFT JOIN wm_drivers d ON ci.driver_id = d.id WHERE ci.client_id = 53 ORDER BY ci.car_name ASC
2021-09-17 18:16:23 <BR> 53 <BR> 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 <BR> 53 <BR> 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 <BR> 53 <BR> 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 <BR>  <BR> SELECT COUNT(*),u.role_id, u.client_id, u.id, u.frequency, s.milestone,s.MapCenter_longitude,s.MapCenter_latitude,s.defaultMap_scale,s.gmt,s.use_fixed_data,c.is_blocked,b.balance,s.time_track,s.dist_track, s.car_name_format FROM wm_users AS u LEFT JOIN wm_settings AS s ON u.client_id = s.client_id LEFT JOIN wm_clients c on u.client_id=c.id LEFT JOIN wm_balances b ON b.client_id=c.id WHERE (u.`login`='cola-admin' AND u.`password`='7a04440e92466d362697f4929b71c3bd')
2021-09-17 18:36:45 <BR> 53 <BR> SELECT t.id,t.date,c.car_name,t.description,t.client,t.adress_to,t.adress_from,t.customer,t.target FROM tms_tasks t INNER JOIN wm_car_info c ON t.imei=c.imei WHERE DATE='2021-09-17' AND t.client_id=53 ORDER BY t.imei ASC;
2021-09-17 18:36:47 <BR> 53 <BR> SELECT ci.id, ci.car_name,ci.fuel,ci.model,ci.fuel_type,ci.atp,ci.company,ci.imei, d.NAME AS driver_name FROM wm_car_info ci LEFT JOIN wm_drivers d ON ci.driver_id = d.id WHERE ci.client_id = 53 ORDER BY ci.car_name ASC
2021-09-17 18:36:52 <BR> 53 <BR> 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 <BR> 53 <BR> 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 <BR> 53 <BR> 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 <BR> 53 <BR> 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 <BR> 53 <BR> 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 <BR> 53 <BR> 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 <BR> 53 <BR> 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 <BR> 53 <BR> 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 <BR> 53 <BR> 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 <BR> 53 <BR> 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 <BR> 53 <BR> 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 <BR> 53 <BR> 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 <BR> 53 <BR> 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 <BR> 53 <BR> 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 <BR>  <BR> SELECT t.id,t.date,c.car_name,t.description,t.client,t.adress_to,t.adress_from,t.customer,t.target FROM tms_tasks t INNER JOIN wm_car_info c ON t.imei=c.imei WHERE DATE='2021-09-17' AND t.client_id= ORDER BY t.imei ASC;
2021-09-17 18:44:03 <BR>  <BR> SELECT ci.id, ci.car_name,ci.fuel,ci.model,ci.fuel_type,ci.atp,ci.company,ci.imei, d.NAME AS driver_name FROM wm_car_info ci LEFT JOIN wm_drivers d ON ci.driver_id = d.id WHERE ci.client_id =  ORDER BY ci.car_name ASC
2021-09-17 18:44:09 <BR>  <BR> SELECT COUNT(*),u.role_id, u.client_id, u.id, u.frequency, s.milestone,s.MapCenter_longitude,s.MapCenter_latitude,s.defaultMap_scale,s.gmt,s.use_fixed_data,c.is_blocked,b.balance,s.time_track,s.dist_track, s.car_name_format FROM wm_users AS u LEFT JOIN wm_settings AS s ON u.client_id = s.client_id LEFT JOIN wm_clients c on u.client_id=c.id LEFT JOIN wm_balances b ON b.client_id=c.id WHERE (u.`login`='cola-admin' AND u.`password`='7a04440e92466d362697f4929b71c3bd')
2021-09-17 18:44:09 <BR> 53 <BR> SELECT t.id,t.date,c.car_name,t.description,t.client,t.adress_to,t.adress_from,t.customer,t.target FROM tms_tasks t INNER JOIN wm_car_info c ON t.imei=c.imei WHERE DATE='2021-09-17' AND t.client_id=53 ORDER BY t.imei ASC;
2021-09-17 18:44:10 <BR> 53 <BR> SELECT ci.id, ci.car_name,ci.fuel,ci.model,ci.fuel_type,ci.atp,ci.company,ci.imei, d.NAME AS driver_name FROM wm_car_info ci LEFT JOIN wm_drivers d ON ci.driver_id = d.id WHERE ci.client_id = 53 ORDER BY ci.car_name ASC
2021-09-17 18:44:14 <BR> 53 <BR> 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 <BR> 53 <BR> 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 <BR> 53 <BR> 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 <BR> 53 <BR> 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 <BR> 53 <BR> 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 <BR> 53 <BR> 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 <BR> 53 <BR> 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 <BR> 53 <BR> 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 <BR> 53 <BR> 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 <BR> 53 <BR> 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 <BR> 53 <BR> 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 <BR>  <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 :0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-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 <BR>  <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 :0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-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 <BR>  <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 :0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-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 <BR>  <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 :0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-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 <BR>  <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 :0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-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 <BR>  <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 :0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-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 <BR>  <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 :0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-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 <BR>  <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 :0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-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 <BR>  <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 :0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-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 <BR>  <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 :0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-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 <BR>  <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 :0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-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 <BR>  <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 :0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-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 <BR>  <BR> SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 :0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-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