IP: - 178.158.194.42 - 147.161.248.92; TIME:2024-10-13 20:04:30; 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