2 Hot Activewear & Uniforms

5.11 Tactical 1/4 Zip Job Shirt
[5.11-72314]

$71.99

• 11.6 oz poly cotton fleece
• Fade resistant poly-cotton twill
• Stain resistant finish
• No-roll collar
• Locker loop
• Deep Chest Breakthrough™ pocket with Velcro® divider for storing a full-sized radio or smaller objects without it dropping to the bottom of the pocket
• Hand warmer pockets on both sides
• Mic pockets at both shoulders
• Pen pockets on left sleeve

You can select to have your Name and Rank embroidered on the right chest in silver or gold by completing the information below.
• NO RETURNS on any item embroidered with Personal Name and/or Rank

Available Options:
Embroidered Text Color:
LOGO:
Name Embroidery:
Name Text (Enter your name if "Yes")
Rank Embroidery:
Rank Text (Enter your rank if )
Size:
Special Instruction (Type your detailed instruction)

This product was added to our catalog on Wednesday 01 October, 2008.

1104 - The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay

select p.products_id, p.products_image from orders_products opa, orders_products opb, orders o, products p where opa.products_id = '386' and opa.orders_id = opb.orders_id and opb.products_id != '386' 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]