'SELECT cars.* FROM cars inner join shared_cars on shared_cars.car_id = cars.id WHERE (cars.id = 167 and (cars.public = 1 or (shared_cars.shared_with_id = 1))) LIMIT 1')