USD $220.00

Motorcycle Leather Pant MPT-004-2016(FREE SHIPPING)

Top quality leather (grade A) Motorcycle Pant for best safety and looking great. Race quality leather along with CE approved protectors, knee sliders and Reinforced Rubber padding at thie's provides best protection. Includes full mesh liner for maximum comfort and best fitting style provides comfirt while you are on ride. PRODUCT FEATURES : Top quality leather (grade A)1.3-1.4mm. Includes full mesh liner for maximum comfort. CE Approved Knee armours and knee slider. Front zipped Pockets. Kevlar strech panel at calf. Inclusive of a pair of knee sliders. Zipper connector for connecting with Jacket.

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 = '867' and opa.orders_id = opb.orders_id and opb.products_id != '867' 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