SAXX

Saxx Men's Ultra Boxer Briefs

$21.99 to $31.95

Item # SXBB30F

query
RESULTSET
query
  ORIGSIZ QOH SCALE_ENTRY_ID SIZ SIZE_ORDER SKU_ID STYLE_ID
1 S 10 67950 S [empty string] 302883 80817
2 M 6 67951 M [empty string] 302885 80817
3 L 13 67952 L [empty string] 302887 80817
4 XL 7 67953 XL [empty string] 484689 80817
5 XXL 7 67954 XXL [empty string] 302891 80817
CACHED false
EXECUTIONTIME 375
SQL SELECT distinct (b.siz) as origSiz, max(CASE WHEN b.siz_alias IS NULL OR RTRIM(LTRIM(b.siz_alias)) = '' THEN b.siz ELSE b.siz_alias END) as siz, max(b.size_order) as size_order, max(a.sku_id) as sku_id, max(a.scale_entry_id) as scale_entry_id, sum(e.qoh) as qoh, max(a.style_id) as style_id FROM tb_skus a WITH (NOLOCK) LEFT JOIN tb_size_entries b WITH (NOLOCK) on (b.scale_entry_id = a.scale_entry_id) INNER JOIN ( SELECT DISTINCT sku_id , sum(qoh+qc) as qoh FROM dbo.tb_sku_buckets WITH (NOLOCK) WHERE store_id in(98,8,9,2,5,7,6,3) GROUP BY sku_id ) e on (a.sku_id = e.sku_id) LEFT JOIN tb_attr1_entries d WITH (NOLOCK) on (d.attr1_entry_id = a.attr1_entry_id) LEFT JOIN ( SELECT style_id FROM tb_styles WITH (NOLOCK) WHERE web_style = ? and web_style is not null ) sq ON(a.style_id = sq.style_id) WHERE (sq.style_id is not null OR a.style_id = ?) AND (b.siz_alias is null OR b.siz_alias NOT IN ('NO SHOW','NOSHOW') ) AND isNull(a.sell_web,'Y') = 'Y' AND e.qoh > 1 GROUP BY b.siz ORDER BY max(b.size_order), max(a.scale_entry_id)
SQLPARAMETERS
array
1 SXBB30F
2 80817
query
RESULTSET
query
  ATTR1 ATTR1_ALIAS ATTR1_ENTRY_ID FAM HEX ORIGATTR1 QOH SIZE SKU_ID SORT_ORDER STYLE_ID
1 Black Black 120459 [empty string] [empty string] BLACK_BLK 41 67954 302891 [empty string] 80817
2 HEATHERPINE [empty string] 120483 [empty string] [empty string] HEATHERPINE 2 67953 484689 [empty string] 80817
CACHED false
EXECUTIONTIME 16
SQL SELECT distinct (b.attr1) as origAttr1, max(b.attr1_alias) as attr1_alias, max(CASE WHEN b.attr1_alias IS NULL OR RTRIM(LTRIM(b.attr1_alias)) = '' THEN b.attr1 ELSE b.attr1_alias END) as attr1, max(a.sku_id) as sku_id, max(b.attr1_entry_id) as attr1_entry_id, sum(e.qoh) as qoh, max(b.attr1_order) as sort_order, max(c.attr1_hex) as hex,max(d.attr1_fam) as fam, max(a.style_id) as style_id, max(a.SCALE_ENTRY_ID) as size FROM tb_skus a LEFT JOIN tb_attr1_entries b WITH (NOLOCK) ON (b.attr1_entry_id = a.attr1_entry_id) INNER JOIN ( SELECT DISTINCT sku_id , sum(qoh+qc) as qoh FROM dbo.tb_sku_buckets WITH (NOLOCK) WHERE store_id in(98,8,9,2,5,7,6,3) GROUP BY sku_id ) e on (a.sku_id = e.sku_id) LEFT JOIN tb_attr1_hexes c WITH (NOLOCK) ON (b.attr1=c.attr1) LEFT JOIN tb_size_entries k WITH (NOLOCK) on (k.scale_entry_id = a.scale_entry_id) LEFT JOIN tb_attr1_families d WITH (NOLOCK) ON (c.attr1_fam_id = d.attr1_fam_id) WHERE a.style_id =? AND (b.attr1_alias is null OR b.attr1_alias NOT IN ('NO SHOW','NOSHOW') ) AND e.qoh > 1 AND isNull(a.sell_web,'Y') = 'Y' GROUP BY b.attr1 ORDER BY sum(e.qoh) DESC --max(b.attr1_order), max(b.attr1_entry_id)
SQLPARAMETERS
array
1 80817
Saxx Men's Ultra Boxer Briefs BLACK_BLK HEATHERPINE
S M L XL XXL
query
RESULTSET
query
  ATTR1_ENTRY_ID ATTR2_ENTRY_ID DEPT PURCHASE_AMOUNT QOH SCALE_ENTRY_ID SKU_ID STORE_ID STYLE
1 120458 [empty string] 24-UNDERWEAR [empty string] 0 67950 302882 98 SXBB30F
2 120459 [empty string] 24-UNDERWEAR [empty string] 10 67950 302883 98 SXBB30F
3 120458 [empty string] 24-UNDERWEAR [empty string] 0 67951 302884 98 SXBB30F
4 120459 [empty string] 24-UNDERWEAR [empty string] 6 67951 302885 98 SXBB30F
5 120458 [empty string] 24-UNDERWEAR [empty string] 0 67952 302886 98 SXBB30F
6 120459 [empty string] 24-UNDERWEAR [empty string] 13 67952 302887 98 SXBB30F
7 120458 [empty string] 24-UNDERWEAR [empty string] 0 67953 302888 98 SXBB30F
8 120459 [empty string] 24-UNDERWEAR [empty string] 5 67953 302889 98 SXBB30F
9 120458 [empty string] 24-UNDERWEAR [empty string] 0 67954 302890 98 SXBB30F
10 120459 [empty string] 24-UNDERWEAR [empty string] 7 67954 302891 98 SXBB30F
11 120460 [empty string] 24-UNDERWEAR [empty string] 0 67950 305482 98 SXBB30F
12 120460 [empty string] 24-UNDERWEAR [empty string] 0 67951 305483 98 SXBB30F
13 120460 [empty string] 24-UNDERWEAR [empty string] 0 67952 305484 98 SXBB30F
14 120460 [empty string] 24-UNDERWEAR [empty string] 0 67953 305485 98 SXBB30F
15 120460 [empty string] 24-UNDERWEAR [empty string] 0 67954 305486 98 SXBB30F
16 120461 [empty string] 24-UNDERWEAR [empty string] 0 67950 340792 98 SXBB30F
17 120461 [empty string] 24-UNDERWEAR [empty string] 0 67951 340793 98 SXBB30F
18 120461 [empty string] 24-UNDERWEAR [empty string] 0 67952 340794 98 SXBB30F
19 120461 [empty string] 24-UNDERWEAR [empty string] 0 67953 340795 98 SXBB30F
20 120461 [empty string] 24-UNDERWEAR [empty string] 0 67954 340796 98 SXBB30F
21 120462 [empty string] 24-UNDERWEAR [empty string] 0 67950 362332 98 SXBB30F
22 120462 [empty string] 24-UNDERWEAR [empty string] 0 67951 362333 98 SXBB30F
23 120462 [empty string] 24-UNDERWEAR [empty string] 0 67952 362334 98 SXBB30F
24 120462 [empty string] 24-UNDERWEAR [empty string] 0 67953 362335 98 SXBB30F
25 120462 [empty string] 24-UNDERWEAR [empty string] 0 67954 362336 98 SXBB30F
26 120463 [empty string] 24-UNDERWEAR [empty string] 0 67950 382516 98 SXBB30F
27 120463 [empty string] 24-UNDERWEAR [empty string] 0 67951 382517 98 SXBB30F
28 120463 [empty string] 24-UNDERWEAR [empty string] 0 67952 382518 98 SXBB30F
29 120463 [empty string] 24-UNDERWEAR [empty string] 0 67953 382519 98 SXBB30F
30 120463 [empty string] 24-UNDERWEAR [empty string] 0 67954 382520 98 SXBB30F
31 120464 [empty string] 24-UNDERWEAR [empty string] 0 67950 382521 98 SXBB30F
32 120464 [empty string] 24-UNDERWEAR [empty string] 0 67951 382522 98 SXBB30F
33 120464 [empty string] 24-UNDERWEAR [empty string] 0 67952 382523 98 SXBB30F
34 120464 [empty string] 24-UNDERWEAR [empty string] 0 67953 382524 98 SXBB30F
35 120464 [empty string] 24-UNDERWEAR [empty string] 0 67954 382525 98 SXBB30F
36 120465 [empty string] 24-UNDERWEAR [empty string] 0 67950 382526 98 SXBB30F
37 120465 [empty string] 24-UNDERWEAR [empty string] 0 67951 382527 98 SXBB30F
38 120465 [empty string] 24-UNDERWEAR [empty string] 0 67952 382528 98 SXBB30F
39 120465 [empty string] 24-UNDERWEAR [empty string] 0 67953 382529 98 SXBB30F
40 120465 [empty string] 24-UNDERWEAR [empty string] 0 67954 382530 98 SXBB30F
41 120466 [empty string] 24-UNDERWEAR [empty string] 0 67950 401525 98 SXBB30F
42 120466 [empty string] 24-UNDERWEAR [empty string] 0 67951 401526 98 SXBB30F
43 120466 [empty string] 24-UNDERWEAR [empty string] 0 67952 401527 98 SXBB30F
44 120466 [empty string] 24-UNDERWEAR [empty string] 0 67953 401528 98 SXBB30F
45 120466 [empty string] 24-UNDERWEAR [empty string] 0 67954 401529 98 SXBB30F
46 120467 [empty string] 24-UNDERWEAR [empty string] 0 67950 401536 98 SXBB30F
47 120467 [empty string] 24-UNDERWEAR [empty string] 0 67951 401537 98 SXBB30F
48 120467 [empty string] 24-UNDERWEAR [empty string] 0 67952 401538 98 SXBB30F
49 120467 [empty string] 24-UNDERWEAR [empty string] 0 67953 401539 98 SXBB30F
50 120467 [empty string] 24-UNDERWEAR [empty string] 0 67954 401540 98 SXBB30F
51 120468 [empty string] 24-UNDERWEAR [empty string] 0 67950 402192 98 SXBB30F
52 120468 [empty string] 24-UNDERWEAR [empty string] 0 67951 402193 98 SXBB30F
53 120468 [empty string] 24-UNDERWEAR [empty string] 0 67952 402194 98 SXBB30F
54 120468 [empty string] 24-UNDERWEAR [empty string] 0 67953 402195 98 SXBB30F
55 120468 [empty string] 24-UNDERWEAR [empty string] 0 67954 402196 98 SXBB30F
56 120469 [empty string] 24-UNDERWEAR [empty string] 0 67950 408075 98 SXBB30F
57 120469 [empty string] 24-UNDERWEAR [empty string] 0 67951 408076 98 SXBB30F
58 120469 [empty string] 24-UNDERWEAR [empty string] 0 67952 408077 98 SXBB30F
59 120469 [empty string] 24-UNDERWEAR [empty string] 0 67953 408078 98 SXBB30F
60 120469 [empty string] 24-UNDERWEAR [empty string] 0 67954 408079 98 SXBB30F
61 120470 [empty string] 24-UNDERWEAR [empty string] 0 67950 420088 98 SXBB30F
62 120470 [empty string] 24-UNDERWEAR [empty string] 0 67951 420089 98 SXBB30F
63 120470 [empty string] 24-UNDERWEAR [empty string] 0 67952 420090 98 SXBB30F
64 120470 [empty string] 24-UNDERWEAR [empty string] 0 67953 420091 98 SXBB30F
65 120470 [empty string] 24-UNDERWEAR [empty string] 0 67954 420092 98 SXBB30F
66 120471 [empty string] 24-UNDERWEAR [empty string] 0 67950 420093 98 SXBB30F
67 120471 [empty string] 24-UNDERWEAR [empty string] 0 67951 420094 98 SXBB30F
68 120471 [empty string] 24-UNDERWEAR [empty string] 0 67952 420095 98 SXBB30F
69 120471 [empty string] 24-UNDERWEAR [empty string] 0 67953 420096 98 SXBB30F
70 120471 [empty string] 24-UNDERWEAR [empty string] 0 67954 420097 98 SXBB30F
71 120472 [empty string] 24-UNDERWEAR [empty string] 0 67950 420098 98 SXBB30F
72 120472 [empty string] 24-UNDERWEAR [empty string] 0 67951 420099 98 SXBB30F
73 120472 [empty string] 24-UNDERWEAR [empty string] 0 67952 420100 98 SXBB30F
74 120472 [empty string] 24-UNDERWEAR [empty string] 0 67953 420101 98 SXBB30F
75 120472 [empty string] 24-UNDERWEAR [empty string] 0 67954 420102 98 SXBB30F
76 120473 [empty string] 24-UNDERWEAR [empty string] 0 67950 438971 98 SXBB30F
77 120473 [empty string] 24-UNDERWEAR [empty string] 0 67951 438972 98 SXBB30F
78 120473 [empty string] 24-UNDERWEAR [empty string] 0 67952 438973 98 SXBB30F
79 120473 [empty string] 24-UNDERWEAR [empty string] 0 67953 438974 98 SXBB30F
80 120473 [empty string] 24-UNDERWEAR [empty string] 0 67954 438975 98 SXBB30F
81 120474 [empty string] 24-UNDERWEAR [empty string] 0 67950 438976 98 SXBB30F
82 120474 [empty string] 24-UNDERWEAR [empty string] 0 67951 438977 98 SXBB30F
83 120474 [empty string] 24-UNDERWEAR [empty string] 0 67952 438978 98 SXBB30F
84 120474 [empty string] 24-UNDERWEAR [empty string] 0 67953 438979 98 SXBB30F
85 120474 [empty string] 24-UNDERWEAR [empty string] 0 67954 438980 98 SXBB30F
86 120475 [empty string] 24-UNDERWEAR [empty string] 0 67950 438981 98 SXBB30F
87 120475 [empty string] 24-UNDERWEAR [empty string] 0 67951 438982 98 SXBB30F
88 120475 [empty string] 24-UNDERWEAR [empty string] 0 67952 438983 98 SXBB30F
89 120475 [empty string] 24-UNDERWEAR [empty string] 0 67953 438984 98 SXBB30F
90 120475 [empty string] 24-UNDERWEAR [empty string] 0 67954 438985 98 SXBB30F
91 120476 [empty string] 24-UNDERWEAR [empty string] 0 67950 438986 98 SXBB30F
92 120476 [empty string] 24-UNDERWEAR [empty string] 0 67951 438987 98 SXBB30F
93 120476 [empty string] 24-UNDERWEAR [empty string] 0 67952 438988 98 SXBB30F
94 120476 [empty string] 24-UNDERWEAR [empty string] 0 67953 438989 98 SXBB30F
95 120476 [empty string] 24-UNDERWEAR [empty string] 0 67954 438990 98 SXBB30F
96 120477 [empty string] 24-UNDERWEAR [empty string] 0 67950 480574 98 SXBB30F
97 120477 [empty string] 24-UNDERWEAR [empty string] 0 67951 480575 98 SXBB30F
98 120477 [empty string] 24-UNDERWEAR [empty string] 0 67952 480576 98 SXBB30F
99 120477 [empty string] 24-UNDERWEAR [empty string] 0 67953 480577 98 SXBB30F
100 120477 [empty string] 24-UNDERWEAR [empty string] 0 67954 480578 98 SXBB30F
101 120478 [empty string] 24-UNDERWEAR [empty string] 0 67950 480580 98 SXBB30F
102 120478 [empty string] 24-UNDERWEAR [empty string] 0 67951 480581 98 SXBB30F
103 120478 [empty string] 24-UNDERWEAR [empty string] 0 67952 480582 98 SXBB30F
104 120478 [empty string] 24-UNDERWEAR [empty string] 0 67953 480583 98 SXBB30F
105 120478 [empty string] 24-UNDERWEAR [empty string] 0 67954 480584 98 SXBB30F
106 120479 [empty string] 24-UNDERWEAR [empty string] 0 67950 480585 98 SXBB30F
107 120479 [empty string] 24-UNDERWEAR [empty string] 0 67951 480586 98 SXBB30F
108 120479 [empty string] 24-UNDERWEAR [empty string] 0 67952 480587 98 SXBB30F
109 120479 [empty string] 24-UNDERWEAR [empty string] 0 67953 480588 98 SXBB30F
110 120479 [empty string] 24-UNDERWEAR [empty string] 0 67954 480589 98 SXBB30F
111 120480 [empty string] 24-UNDERWEAR [empty string] 0 67950 484671 98 SXBB30F
112 120480 [empty string] 24-UNDERWEAR [empty string] 0 67951 484672 98 SXBB30F
113 120480 [empty string] 24-UNDERWEAR [empty string] 0 67952 484673 98 SXBB30F
114 120480 [empty string] 24-UNDERWEAR [empty string] 0 67953 484674 98 SXBB30F
115 120480 [empty string] 24-UNDERWEAR [empty string] 0 67954 484675 98 SXBB30F
116 120481 [empty string] 24-UNDERWEAR [empty string] 0 67950 484676 98 SXBB30F
117 120481 [empty string] 24-UNDERWEAR [empty string] 0 67951 484677 98 SXBB30F
118 120481 [empty string] 24-UNDERWEAR [empty string] 0 67952 484678 98 SXBB30F
119 120481 [empty string] 24-UNDERWEAR [empty string] 0 67953 484679 98 SXBB30F
120 120481 [empty string] 24-UNDERWEAR [empty string] 0 67954 484680 98 SXBB30F
121 120482 [empty string] 24-UNDERWEAR [empty string] 0 67950 484681 98 SXBB30F
122 120482 [empty string] 24-UNDERWEAR [empty string] 0 67951 484682 98 SXBB30F
123 120482 [empty string] 24-UNDERWEAR [empty string] 0 67952 484683 98 SXBB30F
124 120482 [empty string] 24-UNDERWEAR [empty string] 0 67953 484684 98 SXBB30F
125 120482 [empty string] 24-UNDERWEAR [empty string] 0 67954 484685 98 SXBB30F
126 120483 [empty string] 24-UNDERWEAR [empty string] 0 67950 484686 98 SXBB30F
127 120483 [empty string] 24-UNDERWEAR [empty string] 0 67951 484687 98 SXBB30F
128 120483 [empty string] 24-UNDERWEAR [empty string] 1 67952 484688 98 SXBB30F
129 120483 [empty string] 24-UNDERWEAR [empty string] 2 67953 484689 98 SXBB30F
130 120483 [empty string] 24-UNDERWEAR [empty string] 1 67954 484690 98 SXBB30F
CACHED false
EXECUTIONTIME 453
SQL SELECT sum(c.qoh+c.qc) as qoh ,max(b.sku_id) as sku_id , max(b.scale_entry_id) as scale_entry_id , max(b.attr2_entry_id) as attr2_entry_id , max(e.attr1_entry_id) as attr1_entry_id , max(g.dept) as dept , max(a.style) as style , max(c.store_id) as store_id , max(h.purchase_amount) as purchase_amount FROM tb_styles a LEFT JOIN tb_skus b WITH (NOLOCK) ON (a.style_id = b.style_id) LEFT JOIN tb_sku_buckets c WITH (NOLOCK) ON (b.sku_id = c.sku_id) LEFT JOIN tb_size_entries d WITH (NOLOCK) ON (d.scale_entry_id = b.scale_entry_id) LEFT JOIN tb_attr1_entries e WITH (NOLOCK) ON (e.attr1_entry_id = b.attr1_entry_id) LEFT JOIN tb_attr2_entries f WITH (NOLOCK) ON (f.attr2_entry_id = b.attr2_entry_id) LEFT JOIN tb_taxonomy g WITH (NOLOCK) ON (g.taxonomy_id = a.taxonomy_id) LEFT JOIN web_product_information h WITH (NOLOCK) ON (a.style_id = h.style_id) WHERE (b.style_id IN ( SELECT style_id FROM tb_styles WHERE web_style = 'SXBB30F' ) or b.style_id =?) and c.store_id in(98,8,9,2,5,7,6,3) --AND c.qoh > 1 AND isNull(b.sell_web,'Y') = 'Y' GROUP BY b.sku_id ORDER BY b.sku_id
SQLPARAMETERS
array
1 80817
45
Add to Cart Find in Store Add to Wish List

product description

Neatly nestle your nether region's most important players in the technical fit and striking fashion of the Saxx Men's Ultra Boxer Briefs. A relaxed fit evolution from the best-selling Vibe, this boxer brief features moisture-wicking, breathable viscose fabric that serves up all-day comfort in charming prints.

product specs
  • Moisture-wicking 95% viscose / 5% spandex fabric
  • Patented BallPark Pouch for friction-free support
  • Three-D Fit with 9-panel construction
  • Non-chafing Flat Out Seams
  • 1.75in moisture-wicking twisted-yarn heather jacquard waistband
  • Limited edition prints
  • Regular fit
  • 5in inseam
  • Fly
Overall Rating

0.0/5.0

Review Stats 0 total reviews

5 0

4 0

3 0

2 0

1 0

Write a Review
Very Poor Poor Average Very Good Excellent
Name: *
Location:
Review Title:
Review: * (maximum 1000 characters)
1 - 0 of 0

No reviews have been written for this product.
Be the first one!  –


FREE SHIPPING* ON ORDERS OVER $100.00
My Bag (0)
Menu

query
RESULTSET
query
  ADDITIONAL_DESCRIPTION AGERANGE ALTIMAGERECORDCOUNT ATTR1ID ATTR1LIST ATTR2ID BRAND BRANDDISPLAY DEPT DEPTTREE DESCRIPTION FAMLIST GENDER GOOGLEPRODUCTTAXONOMY HEXLIST ID INSTORE_ONLY INTERNALLISTPRICE INTERNALMARKDOWN INTERNALPRICE KEYWORDS LARGEPICTURE LISTPRICE LOWESTPRICE MEDIUMPICTURE METADESC METATAGS NAME NEW OF1 OF10 OF11 OF12 OF13 OF14 OF15 OF16 OF17 OF18 OF19 OF2 OF20 OF3 OF4 OF5 OF6 OF7 OF8 OF9 ORIGBRAND OVERALLQOH OVERALL_RATING PAGETITLE PICTUREID PICTURE_ID PRICERANGE PRODREVIEWSAVERAGE PRODREVIEWSRECORDCOUNT QUANTITYONHANDSUM QUANTITYSOLDSUM RANKING REALNAME ROMANTICCOPYLONG ROMANTICCOPYSHORT SALE SALEPRICERANGEBOTTOM SALEPRICERANGETOP SCALEID SHIP_SURCHARGE SIZELIST SIZING_IMAGE_FILE SMALLPICTURE SORTPOSITION STYLE STYLE_ID SUBTYP1 SUBTYP2 SUBTYP3 TERMSALE TERMSALELISTPRICE TERMSALEPRICE TINYPICTURE TYP URL USEPACKAGE VIDEO WEBSTYLE WEB_OF1 WEB_OF10 WEB_OF11 WEB_OF12 WEB_OF13 WEB_OF14 WEB_OF15 WEB_OF16 WEB_OF17 WEB_OF18 WEB_OF19 WEB_OF2 WEB_OF20 WEB_OF3 WEB_OF4 WEB_OF5 WEB_OF6 WEB_OF7 WEB_OF8 WEB_OF9
1 <ul> <li>Moisture-wicking 95% viscose / 5% spandex fabric</li> <li>Patented BallPark Pouch for friction-free support</li> <li>Three-D Fit with 9-panel construction</li> <li>Non-chafing Flat Out Seams</li> <li>1.75in moisture-wicking twisted-yarn heather jacquard waistband</li> <li>Limited edition prints</li> <li>Regular fit</li> <li>5in inseam</li> <li>Fly</li> </ul> [empty string] [empty string] 56303 BLACK_BLK,HEATHERPINE, [empty string] SAXX SAXX CLOTHING & FOOTWEAR Clothing & Footwear &gt Men's &gt Underwear &gt Boxers & Briefs [empty string] [empty string] [empty string] 596 [empty string] 27452701 [empty string] 31.95 21 21.99 [empty string] 14103-DEFAULT-l.jpg 31.95 [empty string] 14103-DEFAULT-m.jpg Neatly nestle your nether region's most important players in the technical fit and striking fashion of the Saxx Men's Ultra Boxer Briefs. [empty string] M/ ULTRA BOXER BRIEF N [empty string] [empty string] [empty string] [empty string] [empty string] BTSTFW [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 24B [empty string] [empty string] FALL_3 [empty string] [empty string] [empty string] [empty string] SAXX 42 0 [empty string] 14103 14103 20-to-25 0.00 0 [empty string] [empty string] [empty string] Saxx Men's Ultra Boxer Briefs <p>Neatly nestle your nether region&#39;s most important players in the technical fit and striking fashion of the Saxx Men&#39;s Ultra Boxer Briefs. A relaxed fit evolution from the best-selling Vibe, this boxer brief features moisture-wicking, breathable viscose fabric that serves up all-day comfort in charming prints.</p> [empty string] Y 21.99 31.95 22383 0 L,M,S,XL,XXL, [empty string] 14103-DEFAULT-s.jpg 1000 SXBB30F 80817 UNDERWEAR BOXERS & BRIEFS EMPTY 0 [empty string] [empty string] 14103-DEFAULT-xs.jpg MENS shop/saxx-mens-ultra-boxer-briefs-80817 0 [empty string] SXBB30F [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string]
CACHED false
EXECUTIONTIME 0
SQL SELECT * from [dbo].[web_all_products] WHERE style_id='80817' order by ID desc