USD $99.99

Mens Aircon Motorcycle Protection Jacket MJK-T16-03(FREE SHIPING
[MJK-T16-03]

Motorcycle textile jacket suitable for ride on tour and rally bikes in all weathers with removable quilt inner lining. Attractive and beautiful design, Protective with CE approved armours.

Features:

  • WATERPROOF CORDURA CONSTRUCTION
  • REMOVABLE CE ARMOURS AT ELBOWS AND SHOULDERS
  • SOFT ARMOUR PLATE AT BACK
  • REMOVABLE WATERPROOF LINING & FIXED MESH LINING UNDERNEATH 
  • 4 FRONT AND 3 BACK AIR VENTS  
  • 2 SIDE POCKETS
  • HEAVY DUTY ZIPPER AT BOTTOM TO ATTACH TROUSERS
  • REFLECTIVE PIPING FOR ENHANCED ROAD VISIBILITY
  • VELCRO FASTENERS AT CUFFS
  • COMFORTABLE PADDED COLLAR
Reviews
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 = '928' and opa.orders_id = opb.orders_id and opb.products_id != '928' 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]