1. The DRIVE Wheel Covers Set-Sandstone
    [GCA-JW950-20-00]

    Our Price:  $9.85

    Fits all models with stock 8" wheels.

    Exclusive to Yamaha. Yamaha wheel covers have the familiar classic look as previous wheel covers with a host of improvements. New clip retention system that doesn't scratch your rim while being installed. Sterm hole protection system to help protect the valve stem from damage. Upgraded chrome plating process that improves retention and coverage.

    Made in the USA!

    Sandstone Metallic

    PRICE EACH HUB CAP

    Reviews
1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'tntgolfc_oscom.o.date_purchased' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

select p.products_id, p.products_image from orders_products opa, orders_products opb, orders o, products p where opa.products_id = '467' and opa.orders_id = opb.orders_id and opb.products_id != '467' and opb.products_id = p.products_id and opb.orders_id = o.orders_id and p.products_status = '1' group by p.products_id order by o.date_purchased desc limit 6

[TEP STOP]