USD $56.00

Motorcycle Leather Glove MSG-2(FREE SHIPPING)

Gloves made of cowhide Leather specially made for the motorcycle riders.Provide full protection to fingers and palm,Hard Plastic knuckle protection make the glove more protective and padded provide wrist bone protection.

  • cowhide Leather(Analen).
  • Finger tips for fingers protection.
  • Velcro adjusted straps.
  • Hard Plastic knuckle protection.
  • Padding for palm protection.
  • Play boy inside febric linning.
  • PU.

Available Options:


1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'silascop_llink.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 = '250' and opa.orders_id = opb.orders_id and opb.products_id != '250' 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