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