Now in your cart :  0 item(s)

Wear the best-selling The North Face Men's Apex Bionic Jacket to beat the elements this season. Designed with functional features to keep you going, this soft shell jacket is a must-have essential for your winter wardrobe. It is constructed of a windproof, water resistant outer fabric and a comfortable fleece lining perfect for inclement weather. Whether you wear it alone or as an external shell, the Apex Bionic Jacket delivers.

FEATURES:

* Full zip * The North Face brand you trust to deliver cold weather protection * Jacket features a stretchy, comfortable standard fit * TNF Apex ClimaBlock fabric wind permeability rated at 0 CFM * Napoleon chest pocket * Two hand pockets to keep your fingers warm whether you're skiing or hiking * Adjustable hem cinch cord for the perfect fit * Velcro adjustable cuffs and molded tabs * The North Face logo at left chest to represent your favorite brand * Built for mobility and designed for adventure * Fleece backer * Center Back: 28" * Fabric: plain weave polyester TNF Apex ClimateBlock * Style: AMVY


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