Semi-compression fit comfortably skims the body without squeezing
Longline hem stays tucked in during every activity level
Traditional military style cuffs allow for sleeves to be rolled up easily
Adjustable Velcro Brand hook and loop wrist closure
Double-reinforced and double-articulated elbows enhance durability with maximum resistance against wear, tear and fading for crawling, shooting, reaching and climbing
Dual zipper-opening bicep pockets with VELCRO Brand loop provide large storage capacity for extra carrying materials and patching purposes
Articulated sleeves and gusseted underarms provide better ease of movement
Quarter-zip suede collar yields extra neck and throat protection against chafing from slings, packs and body armor
Body fabric enhanced with 37.5 technology, to promote active cooling and rapid drying
SELECT `I`.`ListID`, `I`.`ProductID`, `I`.`ItemGroup`, `I`.`ItemColorID`, `I`.`ItemColor`, `I`.`ItemSizeOnly` AS `ItemSize`, `I`.`ItemLength`, `I`.`RequiredAlterationID`, `I`.`ProspectItem`,
MAX(`S`.CatID) AS CatID, `I`.`SalesPrice`,`I`.`SalesPrice` AS `WebPrice`,
`I`.`AltShowListID`, `I`.`InventoryOnly`
FROM `tbl_items` `I`
LEFT JOIN `tbl_items_search` `S` ON (`I`.`ItemID`=`S`.`ItemID`) AND (`S`.`CatID` = '2076')
WHERE (`I`.`ItemGroup` = '8VX-VTX1911') AND (`I`.`ShowOnlyLocal` = '1') AND (`I`.`IsActive` != '0') AND (`I`.`SpecialGroupID` Is Null OR `I`.`SpecialGroupID` = '0')
GROUP BY `I`.`ListID`
ORDER BY `I`.`ProspectItem`, IFNULL(`I`.`ItemColor`,'ZZZZZZ'),`I`.`SizeSort`,`I`.`ItemSize`, `I`.`ItemLength`