2023 Nissan Altima: Parking Brake Hardware Kit
select distinct m.manufacturers_id as id, m.manufacturers_name as name, m.manufacturers_image from (products p, manufacturers m , products_to_categories p2c ) LEFT JOIN products_ymm pf ON pf.products_id = p.products_id AND ( products_car_year_bof <= 2023 AND 2023 <= products_car_year_eof ) AND products_car_make = 'Nissan' AND products_car_model = 'Altima' where ( p.products_universal = 1 OR pf.products_id IS NOT NULL ) AND p.products_status = 1 and p.manufacturers_id = m.manufacturers_id and p.products_id = p2c.products_id and p2c.categories_id = 910289 order by m.manufacturers_name
[TEP STOP]