Specials   |   Advanced Search   |   Contact Us   |   Create an Account   |   Log In
Currencies:
Languages:
English
    Shopping Cart:     0 items
SHERPA LINED JACKET - BLACK
[YJ839MK9]

WALLS WORKWEAR- SHERPA LINED JACKET - BLACK - CALL 229-273-5299 FOR HELP WITH SIZES

  • 60% cotton, 40% polyester brushed duck
  • Muscle Backā„¢ Technology Allows extended range of motion with upper-body flex
  • 60-gram Sherpa fleece interior Traps thermal heat in rough weather conditions
  • Three-panel hood for greater peripheral vision
  • Sleeve articulation for added range and reach
  • Triple-needle stitching is three times durable
  • Concealed storm cuffs for a tighter seal
  • Heavy rib waistband
  • Stealth security interior pockets stow key items; Stash chest pocket with reflective trim
Realtree All Purpose Black
$76.99
1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'wallsout_cart.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 = '148' and opa.orders_id = opb.orders_id and opb.products_id != '148' 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]

Reviews
Current Reviews: 0