You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') ORDER BY db_car.update_date DESC' at line 22
SELECT db_car.car_id, db_car.sub_detail, db_car.sub_submodel, db_car.years, db_car.colors, db_car.transmition, db_car.engine, db_car.engine_type, db_car.prices, db_car.car_interior, db_car.car_exterior, db_car.car_option, db_car_brand.brand_name, db_car_model.model FROM db_car LEFT JOIN db_car_brand ON db_car.brand_id = db_car_brand.id LEFT JOIN db_car_model ON db_car.model_id = db_car_model.id WHERE db_car.status_car = 1 AND db_car.tent_id IN () ORDER BY db_car.update_date DESC