IP: - - 95.158.42.8; TIME:2020-09-20 09:50:02; SORT SELECT ci.id, ci.car_name,ci.fuel,ci.model,ci.fuel_type,ci.atp,ci.company,ci.imei, d.NAME AS driver_name, ci.image_path FROM wm_car_info ci LEFT JOIN wm_drivers d ON ci.driver_id = d.id INNER JOIN `wm_car_visibility` cv ON cv.car_id = ci.id AND (cv.isVisible=1 AND cv.user_id=276) WHERE ci.client_id = 53 AND (ci.car_name LIKE '%%' OR ci.imei LIKE '%%') GROUP BY ci.id ORDER BY ci.car_name asc