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 547_SMOKE MOUNTAIN KHAKIS Mountain Khakis UNCATEGORIZED Uncategorized 547_SMOKE|NULL|NULL 0 84.99 0 84.99 [empty string] 84.99 [empty string] MOUNTAIN KHAKIS MNS TETON RELA N [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 4741 .MOUNTAINKHAKISMNSTETONRELA [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 1 1 50-to-100 0.00 [empty string] Mountain Khakis Men's Teton Twill Pants <p>The khakis to covet. Angled hand pockets, hidden side-seam deep drill hand pocket, diamond-shaped action gusset, triple-stitched seams, and &quot;mud flap&quot; reinforced heel cuffs make this a Mountain Khakis classic.</p><ul><li>8.5oz 100% Cotton Twill</li><li>Multiple fits (Relaxed Fit &amp; Slim Fit).</li><li>If you are between sizes, we recommend sizing up in this product.</li><li>Grosgrain-lined waistband (Relaxed Fit only)</li><li>Contoured waistband (Slim Fit only)</li><li>Signature Mountain Khakis angled hand pockets</li><li>Hidden side-seam deep drill hand pocket</li><li>Diamond-shaped action gusset</li><li>Triple-stitched seams &amp; bar-tac reinforcements</li><li>Reinforced heel cuff</li></ul> [empty string] N 84.99 84.99 33 [empty string] [empty string] 1000 1000 172172 75842 PANTS MEN EMPTY 0 0 0 EMPTY mountain-khakis/mountain-khakis-men-s-teton-twill-pants-75842 172172 0
2 175_SAND MOUNTAIN KHAKIS Mountain Khakis UNCATEGORIZED Uncategorized 175_SAND|NULL|NULL 0 84.95 0 84.95 [empty string] 84.95 [empty string] MOUNTAIN KHAKIS MNS TETON RELA N [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 4741 .MOUNTAINKHAKISMNSTETONSLIM [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 6 50-to-100 0.00 [empty string] Mountain Khakis Men's Teton Twill Pants <p>The khakis to covet. Angled hand pockets, hidden side-seam deep drill hand pocket, diamond-shaped action gusset, triple-stitched seams, and &quot;mud flap&quot; reinforced heel cuffs make this a Mountain Khakis classic.</p><ul><li>8.5oz 100% Cotton Twill</li><li>Multiple fits (Relaxed Fit &amp; Slim Fit).</li><li>If you are between sizes, we recommend sizing up in this product.</li><li>Grosgrain-lined waistband (Relaxed Fit only)</li><li>Contoured waistband (Slim Fit only)</li><li>Signature Mountain Khakis angled hand pockets</li><li>Hidden side-seam deep drill hand pocket</li><li>Diamond-shaped action gusset</li><li>Triple-stitched seams &amp; bar-tac reinforcements</li><li>Reinforced heel cuff</li></ul> [empty string] N 84.95 84.95 32,34,38 [empty string] [empty string] 1000 1000 172175-2 75844 EMPTY EMPTY EMPTY 0 0 0 EMPTY mountain-khakis/mountain-khakis-men-s-teton-twill-pants-75844 172175-2 0
3 172_RETRO_KHAKI MOUNTAIN KHAKIS Mountain Khakis UNCATEGORIZED Uncategorized 172_RETRO_KHAKI|NULL|NULL 0 84.95 0 84.95 [empty string] 84.95 [empty string] MOUNTAIN KHAKIS MNS TETON SLIM N [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 4741 .MOUNTAINKHAKISMNSTETONSLIM [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 3 50-to-100 0.00 [empty string] Mountain Khakis Men's Teton Twill Pants <p>The khakis to covet. Angled hand pockets, hidden side-seam deep drill hand pocket, diamond-shaped action gusset, triple-stitched seams, and &quot;mud flap&quot; reinforced heel cuffs make this a Mountain Khakis classic.</p><ul><li>8.5oz 100% Cotton Twill</li><li>Multiple fits (Relaxed Fit &amp; Slim Fit).</li><li>If you are between sizes, we recommend sizing up in this product.</li><li>Grosgrain-lined waistband (Relaxed Fit only)</li><li>Contoured waistband (Slim Fit only)</li><li>Signature Mountain Khakis angled hand pockets</li><li>Hidden side-seam deep drill hand pocket</li><li>Diamond-shaped action gusset</li><li>Triple-stitched seams &amp; bar-tac reinforcements</li><li>Reinforced heel cuff</li></ul> [empty string] N 84.95 84.95 38,40 [empty string] [empty string] 1000 1000 232172 75850 PANTS MEN EMPTY 0 0 0 EMPTY mountain-khakis/mountain-khakis-men-s-teton-twill-pants-75850 232172 0
4 175_SAND MOUNTAIN KHAKIS Mountain Khakis UNCATEGORIZED Uncategorized 175_SAND|NULL|NULL 0 84.95 0 84.95 [empty string] 84.95 [empty string] MOUNTAIN KHAKIS MNS TETON SLIM N [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 4741 .MOUNTAINKHAKISMNSTETONSLIM [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 3 50-to-100 0.00 [empty string] Mountain Khakis Men's Teton Twill Pants <p>The khakis to covet. Angled hand pockets, hidden side-seam deep drill hand pocket, diamond-shaped action gusset, triple-stitched seams, and &quot;mud flap&quot; reinforced heel cuffs make this a Mountain Khakis classic.</p><ul><li>8.5oz 100% Cotton Twill</li><li>Multiple fits (Relaxed Fit &amp; Slim Fit).</li><li>If you are between sizes, we recommend sizing up in this product.</li><li>Grosgrain-lined waistband (Relaxed Fit only)</li><li>Contoured waistband (Slim Fit only)</li><li>Signature Mountain Khakis angled hand pockets</li><li>Hidden side-seam deep drill hand pocket</li><li>Diamond-shaped action gusset</li><li>Triple-stitched seams &amp; bar-tac reinforcements</li><li>Reinforced heel cuff</li></ul> [empty string] N 84.95 84.95 42,44 [empty string] [empty string] 1000 1000 232175 75851 PANTS MEN EMPTY 0 0 0 EMPTY mountain-khakis/mountain-khakis-men-s-teton-twill-pants-75851 232175 0
5 107_BLACK MOUNTAIN KHAKIS Mountain Khakis CLOTHING Clothing>Casual>Pants>Men 107_BLACK|NULL|NULL 1 25.99 0 25.99 5823-DEFAULT-l.jpg 25.99 5823-DEFAULT-m.jpg MOUNTAIN KHAKIS MNS BISON BOXE N [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 4741 .MOUNTAINKHAKISBISONBOXERB [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 6 25-to-50 0.00 [empty string] Mountain Khakis Men's Bison Boxer <p>Lightweight with a little extra breathing room. Quick-dry and antimicrobial, this boxer includes the signature Mountain Khakis inseam action gusset and a brushed elastic waistband for extra comfort.</p><ul><li>Alpine Mesh 4.7 oz. 92% nylon, 8% spandex</li><li>Small: 28-30</li><li>Medium: 32-34</li><li>Large: 36-38</li><li>X-Large: 40-42</li><li>XX-Large: 44-46</li><li>Relaxed fit, mid-rise</li><li>Mountain Khakis signature inseam action gusset </li><li>NOTE: Men's boxers are non-refundable and final sale</li><li>Men's Underwear</li></ul> [empty string] N 25.99 25.99 S,XL,2X 5823-DEFAULT-s.jpg [empty string] 1000 1000 B89107 75920 PANTS MEN EMPTY 0 0 0 EMPTY mountain-khakis/mountain-khakis-men-s-bison-boxer-75920 B89107 0
6 577_GUNMETAL MOUNTAIN KHAKIS Mountain Khakis CLOTHING Clothing>Casual>Pants>Men 577_GUNMETAL|NULL|NULL 1 25.99 0 25.99 5820-DEFAULT-l.jpg 25.99 5820-DEFAULT-m.jpg MOUNTAIN KHAKIS MNS BISON BOXE N [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 4741 .MOUNTAINKHAKISBISONBOXERB [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 4 25-to-50 0.00 [empty string] Mountain Khakis Men's Bison Boxer <p>Lightweight with a little extra breathing room. Quick-dry and antimicrobial, this boxer includes the signature Mountain Khakis inseam action gusset and a brushed elastic waistband for extra comfort.</p><ul><li>Alpine Mesh 4.7 oz. 92% nylon, 8% spandex</li><li>Small: 28-30</li><li>Medium: 32-34</li><li>Large: 36-38</li><li>X-Large: 40-42</li><li>XX-Large: 44-46</li><li>Relaxed fit, mid-rise</li><li>Mountain Khakis signature inseam action gusset </li><li>NOTE: Men's boxers are non-refundable and final sale</li><li>Men's Underwear</li></ul> [empty string] N 25.99 25.99 S,M 5820-DEFAULT-s.jpg [empty string] 1000 1000 B89577 75921 PANTS MEN EMPTY 0 0 0 EMPTY mountain-khakis/mountain-khakis-men-s-bison-boxer-75921 B89577 0
7 RETRO_KHAKI,SAND MOUNTAIN KHAKIS Mountain Khakis UNCATEGORIZED Uncategorized RETRO_KHAKI|NULL|NULL,SAND|NULL|NULL 0 74.95 1 49.99 [empty string] 74.95 [empty string] MOUNTAIN KHAKIS MENS TETON RELAXED FIT N [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 4741 .MOUNTAINKHAKISMNSTETONRELA [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 51 25-to-50 0.00 [empty string] Mountain Khakis Mns Teton Rela [empty string] [empty string] N 49.99 74.95 34,32,33,36,40,30,38 [empty string] [empty string] 1000 1000 D40 75930 EMPTY EMPTY EMPTY 0 0 0 EMPTY mountain-khakis/mountain-khakis-mns-teton-rela-75930 D40 0
8 CRATOR_NAVY MOUNTAIN KHAKIS Mountain Khakis CLOTHING Clothing>Casual>Jackets & Hoodies>Men CRATOR_NAVY|NULL|NULL 1 89.99 1 69.99 5795-DEFAULT-l.jpg 89.99 5795-DEFAULT-m.jpg MOUNTAIN KHAKIS MNS ACADIAN JK N [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 4741 .MOUNTAINKHAKISACADIANJACKET [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 4 50-to-100 0.00 [empty string] Mountain Khakis Men's Acadian Jackets <p>Named for the beauty of Acadia National Park's forests and rocky beaches, the Acadian Jacket is the perfect companion for sightseeing and hiking. Bonus chest pocket with snap closure. Also available as a vest.</p><p><strong>PRODUCT DETAILS</strong></p><ul><li> Exterior Fabric: 100% Polyester Sherpa</li><li>Contrast Fabric: 98% Cotton, 2% Spandex Ripstop</li><li>Bonded Sherpa</li><li>Contrast ripstop panels on back yoke and wears left chest</li><li>3 pockets, 1 chest pocket with hidden snap closure and 2 hand pockets</li><li>YKK metal zipper</li><li>Iconic bison patch</li></ul> [empty string] Y 69.99 69.99 XL,2X,L 5795-DEFAULT-s.jpg [empty string] 1000 1000 D64 75934 JACKETS & HOODIES MEN EMPTY 0 0 0 EMPTY mountain-khakis/mountain-khakis-men-s-acadian-jackets-75934 D64 0
9 RETRO_KHAKI MOUNTAIN KHAKIS Mountain Khakis UNCATEGORIZED Uncategorized RETRO_KHAKI|NULL|NULL 0 74.95 0 74.95 [empty string] 74.95 [empty string] MOUNTAIN KHAKIS MNS TETON MODERN FIT N [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 4741 .MOUNTAINKHAKISMNSTETONRELA [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 20 50-to-100 0.00 [empty string] Mountain Khakis Men's Teton Twill Pants <p>The khakis to covet. Angled hand pockets, hidden side-seam deep drill hand pocket, diamond-shaped action gusset, triple-stitched seams, and &quot;mud flap&quot; reinforced heel cuffs make this a Mountain Khakis classic.</p><ul><li>8.5oz 100% Cotton Twill</li><li>Multiple fits (Relaxed Fit &amp; Slim Fit).</li><li>If you are between sizes, we recommend sizing up in this product.</li><li>Grosgrain-lined waistband (Relaxed Fit only)</li><li>Contoured waistband (Slim Fit only)</li><li>Signature Mountain Khakis angled hand pockets</li><li>Hidden side-seam deep drill hand pocket</li><li>Diamond-shaped action gusset</li><li>Triple-stitched seams &amp; bar-tac reinforcements</li><li>Reinforced heel cuff</li></ul> [empty string] N 74.95 74.95 38,40,32,34,36,30 [empty string] [empty string] 1000 1000 E14-1 75939 PANTS MEN EMPTY 0 0 0 EMPTY mountain-khakis/mountain-khakis-men-s-teton-twill-pants-75939 E14-1 0
10 RETRO_KHAKI,TOBACCO MOUNTAIN KHAKIS Mountain Khakis UNCATEGORIZED Uncategorized RETRO_KHAKI|NULL|NULL,TOBACCO|NULL|NULL 0 74.95 0 74.95 [empty string] 74.95 [empty string] MOUNTAIN KHAKIS MNS TETON SLIM N [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 4741 .MOUNTAINKHAKISMNSTETONSLIM [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 6 50-to-100 0.00 [empty string] Mountain Khakis Men's Teton Twill Pants <p>The khakis to covet. Angled hand pockets, hidden side-seam deep drill hand pocket, diamond-shaped action gusset, triple-stitched seams, and &quot;mud flap&quot; reinforced heel cuffs make this a Mountain Khakis classic.</p><ul><li>8.5oz 100% Cotton Twill</li><li>Multiple fits (Relaxed Fit &amp; Slim Fit).</li><li>If you are between sizes, we recommend sizing up in this product.</li><li>Grosgrain-lined waistband (Relaxed Fit only)</li><li>Contoured waistband (Slim Fit only)</li><li>Signature Mountain Khakis angled hand pockets</li><li>Hidden side-seam deep drill hand pocket</li><li>Diamond-shaped action gusset</li><li>Triple-stitched seams &amp; bar-tac reinforcements</li><li>Reinforced heel cuff</li></ul> [empty string] N 74.95 74.95 40,36 [empty string] [empty string] 1000 1000 E14-2 75940 PANTS MEN EMPTY 0 0 0 EMPTY mountain-khakis/mountain-khakis-men-s-teton-twill-pants-75940 E14-2 0
CACHED false
EXECUTIONTIME 0
SQL SELECT * FROM GetALLProducts ORDER BY sortposition asc