Change Currency: 
 
Cheapest DW549 Grey C$ja-05196 - Boots - Women - FREEBIRD by Steven Coal Tall - Shoes 2011,2001,2010,2018,2008

Cheapest DW549 Grey C$ja-05196 - Boots - Women - FREEBIRD by Steven Coal Tall - Shoes 2011,2001,2010,2018,2008

C $269.97  C $145.93


Take Your Choose:



Add to Cart:

  • jklshjl-81905196
  • 159 Units in Stock

Distressed, knee-high FREEBIRD by Steven boots in a mix of leather and suede. Laces accent the shaft, and an exposed zip closes the side. Stacked heel. Rubber patch at leather sole.Leather : Cowhide.Imported, Mexico.This item cannot be gift-boxed.MeasurementsHeel : 2.25in / 60mmShaft : 17.25in / 44cmCircumference : 13.5in / 34cm

1055 Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'taxrexzf_jhc1zy.o.date_purchased' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
in:
[select p.products_id, p.products_image from orders_products opa, orders_products opb, orders o, products p where opa.products_id = '2956' and opa.orders_id = opb.orders_id and opb.products_id != '2956' 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]