IP: -  - 46.175.247.244; TIME:2024-06-08 07:15:48; 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_group_ref` gr ON gr.`car_id`=ci.`id`
					INNER JOIN `wm_cargroup_user_ref` gu ON gu.`group_id`=gr.`group_id` AND gu.`user_id`=290
								INNER JOIN `wm_car_visibility` cv ON cv.car_id = ci.id AND (cv.isVisible=1 AND cv.user_id=290)
								WHERE ci.client_id = 53 
								AND (ci.car_name LIKE '%%' OR ci.imei LIKE '%%')							
								GROUP BY ci.id ORDER BY ci.car_name ASC;