IP: - 188.163.80.20 - 147.161.138.119; TIME:2024-01-06 10:29:35; 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