query
RESULTSET
query
  ATTR1LIST BRAND BRANDDISPLAY DEPT DEPTTREE FAMLIST HASIMAGE INTERNALLISTPRICE INTERNALMARKDOWN INTERNALPRICE LARGEPICTURE LISTPRICE MEDIUMPICTURE NAME NEW OF1 OF10 OF11 OF12 OF13 OF14 OF15 OF16 OF17 OF18 OF19 OF2 OF20 OF3 OF4 OF5 OF6 OF7 OF8 OF9 OVERALLQOH PRICERANGE PRODREVIEWSAVERAGE RANKING REALNAME ROMANTICCOPYLONG ROMANTICCOPYSHORT SALE SALEPRICERANGEBOTTOM SALEPRICERANGETOP SIZELIST SMALLPICTURE SOLD SORTPOSITION SORTPOSITION STYLE STYLE_ID SUBTYP1 SUBTYP2 SUBTYP3 TERMSALE TERMSALELISTPRICE TERMSALEPRICE TYP URL WEBSTYLE WEIGHTED_SEARCH
1 REALTREE_AP_XTRA UNDER ARMOUR Under Armour UNCATEGORIZED Uncategorized REALTREE_AP_XTRA|NULL|NULL 0 41.99 0 41.99 [empty string] 41.99 [empty string] UA MENS ALL PURPOSE FIELD PANT N [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 2140 .UAMENSALLPURPOSEFIELDPANT [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 1 25-to-50 0.00 [empty string] Ua Mens All Purpose Field Pant [empty string] [empty string] N 41.99 41.99 44 [empty string] [empty string] 1000 1000 1238327 79975 EMPTY EMPTY EMPTY 0 0 0 EMPTY under-armour/ua-mens-all-purpose-field-pant-79975 1238327 0
2 BLACK UNDER ARMOUR Under Armour CLOTHING Clothing>Hunting>Base Layer>Men BLACK|NULL|NULL 1 69.99 0 69.99 3591-DEFAULT-l.jpg 69.99 3591-DEFAULT-m.jpg UA PACKAGED BASE 3.0 CREW N [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 2140 .UAPACKAGEDBASE3.0CREW [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 9 50-to-100 0.00 [empty string] Under Armour ColdGear Base 3.0 Crew <p>UA Base 3.0 is built for very cold weather and moderate activity. It uses a unique pattern that's designed to trap heat without adding bulk. Think long underwear, revamped for today's top athletes.</p><p><strong>SPECIFICATIONS:</strong></p><ul><li>UA Base 3.0 All Season Baselayer provides midweight warmth at many activity levels &amp; cold temperatures</li><li>UA Scent Control Technology to keep you undetected in all pursuits</li><li>Soft, brushed grid interior traps air, managing your body's microclimate to keep you warm &amp; comfortable</li><li>Material wicks sweat &amp; dries really fast</li><li>4-way stretch construction moves better in every direction</li></ul> [empty string] N 69.99 69.99 S,XL,3X,2X 3591-DEFAULT-s.jpg [empty string] 1000 1000 1343243 80255 EMPTY MEN EMPTY 0 0 0 HUNTING under-armour/under-armour-coldgear-base-3-0-crew-80255 1343243 0
3 BLACK UNDER ARMOUR Under Armour CLOTHING Clothing>Hunting>Base Layer>Men BLACK|NULL|NULL 1 59.99 0 59.99 3592-DEFAULT-l.jpg 59.99 3592-DEFAULT-m.jpg UA PACKAGED BASE 2.0 CREW N [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 2140 .UAPACKAGEDBASE2.0CREW [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 9 50-to-100 0.00 [empty string] Under Armour ColdGear Base 2.0 Crew - Black <p>UA Base is a system of baselayers, numbered from 2.0 to 4.0, that takes you from cold to absolutely freezing temps. It's constructed using a special negative grid pattern with each individual cell designed to trap heat without adding bulk. Think long underwear, reengineered for athletes performing at their peak. UA Base 2.0 is built for cold weather and higher activity levels.<br /></p><p><strong>SPECIFICATIONS:</strong></p><ul><li>Fitted: Next-to-skin without the squeeze.</li><li>UA Base 2.0 Active Baselayer is lightweight, flexible &amp; breathable for high activity performance in cool conditions</li><li>UA Scent Control Technology to keep you undetected in all pursuits</li><li>Soft, brushed grid interior traps air against your skin, closely managing your body's microclimate to keep you warm &amp; comfortable</li><li>Material wicks sweat &amp; dries really fast</li><li>4-way stretch construction moves better in every direction</li><li>71% Polyester/29% Elasterell</li><li>Imported</li></ul> [empty string] N 59.99 59.99 L,XL,2X 3592-DEFAULT-s.jpg [empty string] 1000 1000 1343244 80256 EMPTY MEN EMPTY 0 0 0 HUNTING under-armour/under-armour-coldgear-base-2-0-crew-black-80256 1343244 0
4 BLACK UNDER ARMOUR Under Armour CLOTHING Clothing>Hunting>Base Layer>Men BLACK|NULL|NULL 1 100 0 100 3614-DEFAULT-l.jpg 100 3614-DEFAULT-m.jpg UA PACKAGED BASE 4.0 LEGGING N [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 2140 .UAPACKAGEDBASE4.0LEGGING [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 16 50-to-100 0.00 [empty string] Under Armour ColdGear Base 4.0 Leggings - 1343245 <p>UA Base 4.0 men's cold weather leggings are built for extreme cold weather and lower activity. Their unique pattern traps heat without adding bulk. Think long underwear, revamped for today's top athletes.</p><p><strong>SPECIFICATIONS:</strong></p><ul><li>UA Base 4.0 Extreme Baselayer is our warmest yet, delivering extreme warmth in the extreme cold</li><li>UA Scent Control Technology to keep you undetected in all pursuits</li><li>Soft, brushed grid interior traps air, managing your body's microclimate to keep you warm &amp; comfortable</li><li>Material wicks sweat &amp; dries really fast</li><li>4-way stretch construction moves better in every direction</li><li>Performance elastic waistband</li></ul> [empty string] N 100 100 XLARGE,3X,S,LARGE 3614-DEFAULT-s.jpg [empty string] 1000 1000 1343245 80257 EMPTY MEN EMPTY 0 0 0 HUNTING under-armour/under-armour-coldgear-base-4-0-leggings-1343245-80257 1343245 0
5 BLACK UNDER ARMOUR Under Armour UNCATEGORIZED Uncategorized BLACK|NULL|NULL 1 69.99 0 69.99 3605-DEFAULT-l.jpg 69.99 3605-DEFAULT-m.jpg UA PACKAGED BASE 3.0 LEGGING N [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 2140 .UAPACKAGEDBASE3.0LEGGING [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 11 50-to-100 0.00 [empty string] Under Armour ColdGear Base 3.0 Leggings - 1343246 <p>UA Base 3.0 men's cold weather leggings are built for extreme cold weather and lower activity. Their unique pattern traps heat without adding bulk. Think long underwear, revamped for today's top athletes.</p><p><strong>SPECIFICATIONS:</strong></p><ul><li>UA Base 3.0 All Season Baselayer provides midweight warmth at many activity levels &amp; cold temperatures</li><li>UA Scent Control Technology to keep you undetected in all pursuits</li><li>Soft, brushed grid interior traps air, managing your body's microclimate to keep you warm &amp; comfortable</li><li>Material wicks sweat &amp; dries really fast</li><li>4-way stretch construction moves better in every direction</li><li>Performance elastic waistband</li></ul> [empty string] N 69.99 69.99 SMALL,2X,MEDIUM,LARGE 3605-DEFAULT-s.jpg [empty string] 1000 1000 1343246 80258 EMPTY MEN EMPTY 0 0 0 HUNTING under-armour/under-armour-coldgear-base-3-0-leggings-1343246-80258 1343246 0
6 BLACK UNDER ARMOUR Under Armour CLOTHING Clothing>Hunting>Base Layer>Men BLACK|NULL|NULL 1 59.99 0 59.99 3600-DEFAULT-l.jpg 59.99 3600-DEFAULT-m.jpg UA PACKAGED BASE 2.0 LEGGING N [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 2140 .UAPACKAGEDBASE2.0LEGGING [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 1 50-to-100 0.00 [empty string] Under Armour ColdGear Base 2.0 Leggings - Black <p>UA Base is a system of baselayers, numbered from 2.0 to 4.0, that takes you from cold to absolutely freezing temps. It's constructed using a special negative grid pattern with each individual cell designed to trap heat without adding bulk. Think long underwear, reengineered for athletes performing at their peak. UA Base 2.0 is built for cold weather and higher activity levels.<br /><strong>SPECIFICATIONS:</strong></p><ul><li>Fitted: Next-to-skin without the squeeze.</li><li>UA Base 2.0 Active Baselayer is lightweight, flexible &amp; breathable for high activity performance in cool conditions</li><li>UA Scent Control Technology to keep you undetected in all pursuits</li><li>Soft, brushed grid interior traps air against your skin, closely managing your body's microclimate to keep you warm &amp; comfortable</li><li>Material wicks sweat &amp; dries really fast</li><li>4-way stretch construction moves better in every direction</li><li>Performance elastic waistband</li><li>Working fly</li><li>Inseam: 30.5&quot;</li><li>71% Polyester/29% Elasterell</li><li>Imported</li></ul> [empty string] N 59.99 59.99 S 3600-DEFAULT-s.jpg [empty string] 1000 1000 1343247 80259 EMPTY MEN EMPTY 0 0 0 HUNTING under-armour/under-armour-coldgear-base-2-0-leggings-black-80259 1343247 0
7 BLACK UNDER ARMOUR Under Armour CLOTHING Clothing>Hunting>Base Layer>Women BLACK|NULL|NULL 1 110 0 110 18586-DEFAULT-l.jpg 110 18586-DEFAULT-m.jpg UA WMS BASE 4.0 1/2 ZIP N [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 2140 .UAWMSBASE4.0CREW [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 19 100-to-150 0.00 [empty string] Under Armour Womens Base 4.0 1/2 Zip Top [empty string] [empty string] N 110 110 M,L,XL 18586-DEFAULT-s.jpg [empty string] 1000 1000 1343319 80260 EMPTY WOMEN EMPTY 0 0 0 HUNTING under-armour/under-armour-womens-base-4-0-1-2-zip-top-80260 1343319 0
8 BLACK UNDER ARMOUR Under Armour UNCATEGORIZED Uncategorized BLACK|NULL|NULL 1 69.99 0 69.99 3609-DEFAULT-l.jpg 69.99 3609-DEFAULT-m.jpg UA WMS BASE 3.0 CREW N [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 2140 .UAWMSBASE3.0CREW [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 5 50-to-100 0.00 [empty string] Under Armour Women`s ColdGear Base 3.0 Crew - 1343320 <p><strong>DESCRIPTION:</strong></p><p>UA Base 3.0 is built for very cold weather and moderate activity. It uses a unique pattern that's designed to trap heat without adding bulk. Think long underwear, revamped for today's top athletes.</p><p><strong>SPECIFICATIONS:</strong></p><ul><li>UA Base 3.0 All Season Baselayer provides midweight warmth at many activity levels &amp; cold temperatures</li><li>UA Scent Control Technology to keep you undetected in all pursuits</li><li>Soft, brushed grid interior traps air, managing your body's microclimate to keep you warm &amp; comfortable</li><li>Material wicks sweat &amp; dries really fast</li><li>4-way stretch construction moves better in every direction</li></ul> [empty string] N 69.99 69.99 2X,XS,L 3609-DEFAULT-s.jpg [empty string] 1000 1000 1343320 80261 EMPTY WOMEN EMPTY 0 0 0 HUNTING under-armour/under-armour-women-s-coldgear-base-3-0-crew-1343320-80261 1343320 0
9 BLACK UNDER ARMOUR Under Armour CLOTHING Clothing>Hunting>Base Layer>Women BLACK|NULL|NULL 1 100 0 100 3618-DEFAULT-l.jpg 100 3618-DEFAULT-m.jpg UA WMS BASE 4.0 LEGGING N [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 2140 .UAWMSBASE4.0LEGGING [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 25 50-to-100 0.00 [empty string] Under Armour Women`s ColdGear Base 4.0 Leggings - 1343323 <p><strong>DESCRIPTION:</strong></p><p>UA Base 4.0 is built for extreme cold weather and lower activity. It uses a unique pattern that's designed to trap heat without adding bulk. Think long underwear, revamped for today's top athletes.</p><p><strong>SPPECIFICATIONS:</strong></p><ul><li>UA Base 4.0 Extreme Baselayer is our warmest yet, delivering extreme warmth in the extreme cold</li><li>UA Scent Control Technology to keep you undetected in all pursuits</li><li>Soft, brushed grid interior traps air, managing your body's microclimate to keep you warm &amp; comfortable</li><li>Material wicks sweat &amp; dries really fast</li><li>4-way stretch construction moves better in every direction</li><li>Wide, flat waistband with a rise that sits just right on your hips</li></ul> [empty string] N 100 100 XL,L,MD,SM 3618-DEFAULT-s.jpg [empty string] 1000 1000 1343323 80262 EMPTY WOMEN EMPTY 0 0 0 HUNTING under-armour/under-armour-women-s-coldgear-base-4-0-leggings-1343323-80262 1343323 0
10 BLACK UNDER ARMOUR Under Armour CLOTHING Clothing>Hunting>Base Layer>Women BLACK|NULL|NULL 1 69.99 0 69.99 3598-DEFAULT-l.jpg 69.99 3598-DEFAULT-m.jpg UA WMS BASE 3.0 LEGGING N [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 2140 .UAWMSBASE3.0LEGGING [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 9 50-to-100 0.00 [empty string] Under Armour Women`s ColdGear Base 3.0 Leggings - Black <p>UA Base is a system of baselayers, numbered from 2.0 - 4.0, that takes you from cold to absolutely freezing temps. It uses a special negative grid structure to trap heat without adding bulk. Think long underwear, reengineered for athletes performing at their peak. UA Base 3.0 is built for very cold weather and moderate activity levels.<br /></p><p><strong>Product DNA:</strong></p><ul><li>Fitted: Next-to-skin without the squeeze.</li><li>UA Base 3.0 All Season Baselayer is extremely versatile, providing midweight warmth &amp; mobility to a variety of activity levels &amp; cold temperatures</li><li>UA Scent Control Technology to keep you undetected in all pursuits</li><li>Soft, brushed grid interior traps air against your skin, closely managing your body's microclimate to keep you warm &amp; comfortable</li><li>Material wicks sweat &amp; dries really fast</li><li>4-way stretch construction moves better in every direction</li><li>Wide, flat waistband with a rise that sits just right on your hips</li><li>Inseam: 29.5&quot;</li><li>78% Polyester/22% Elasterell</li><li>Imported</li></ul> [empty string] N 69.99 69.99 MD,L 3598-DEFAULT-s.jpg [empty string] 1000 1000 1343324 80263 EMPTY WOMEN EMPTY 0 0 0 HUNTING under-armour/under-armour-women-s-coldgear-base-3-0-leggings-black-80263 1343324 0
CACHED false
EXECUTIONTIME 0
SQL SELECT * FROM GetALLProducts ORDER BY sortposition asc