Top

  1. Previous
    Next
    Product 4 of 12

    Floor Mats - Retainer Kit, Black
    [22867502**1893]

    Price:  $3.86

    Hold your factory floor mats in place with these factory replacement floor mat clips. Sometimes the floor mat hook can get lost or broken, especially on the driver's side where the most use occurs. With these replacement floor mat clips, your floor mats may be repaired instead of having to replace them.
    Fits Model: Cruze
    Fits model year(s): 2013, 2014, 2015
    Reviews
1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'chevypar_new.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, p.products_price, p.products_tax_class_id from orders_products opa, orders_products opb, orders o, products p where opa.products_id = '6956' and opa.orders_id = opb.orders_id and opb.products_id != '6956' 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 3

[TEP STOP]