exofficio

ExOfficio Women's Give-N-Go Bikini Briefs

$8.99 to $18.00

Item # 2241-2185

query
RESULTSET
query
  ORIGSIZ QOH SCALE_ENTRY_ID SIZ SIZE_ORDER SKU_ID STYLE_ID
1 00_XS 39 152633 XS 1 498495 86402
2 01_SM 57 152634 S 2 498496 86402
3 02_MD 67 152635 M 3 498497 86402
4 03_LG 48 152636 L 13 498504 86402
5 04_XL 28 152637 XL 24 498499 86402
6 05_XXL 7 152638 XXL 33 324250 86402
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 2241-2185
2 86402
query
RESULTSET
query
  ATTR1 ATTR1_ALIAS ATTR1_ENTRY_ID FAM HEX ORIGATTR1 QOH SIZE SKU_ID SORT_ORDER STYLE_ID
1 Nude Nude 130333 [empty string] [empty string] NUDE_8010 72 152638 324250 [empty string] 86402
2 Black Black 130332 [empty string] [empty string] BLACK_9999 68 152638 324249 [empty string] 86402
3 White White 130331 [empty string] [empty string] WHITE_1000 60 152637 324084 [empty string] 86402
4 Lollipop Lollipop 130341 [empty string] [empty string] LOPOP_3030 44 152637 498499 [empty string] 86402
5 Air Blue Air Blue 130342 [empty string] [empty string] ARBLU_5010 2 152636 498504 [empty string] 86402
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 86402
ExOfficio Women's Give-N-Go Bikini Briefs NUDE_8010 ExOfficio Women's Give-N-Go Bikini Briefs BLACK_9999 ExOfficio Women's Give-N-Go Bikini Briefs WHITE_1000 ExOfficio Women's Give-N-Go Bikini Briefs LOPOP_3030 ExOfficio Women's Give-N-Go Bikini Briefs ARBLU_5010
XS 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 130331 30786 24-UNDERWEAR [empty string] 8 152633 324068 98 2241-2185
2 130332 30786 24-UNDERWEAR [empty string] 13 152633 324069 98 2241-2185
3 130333 30786 24-UNDERWEAR [empty string] 12 152633 324070 98 2241-2185
4 130334 30786 24-UNDERWEAR [empty string] 0 152633 324071 98 2241-2185
5 130331 30786 24-UNDERWEAR [empty string] 11 152634 324072 98 2241-2185
6 130332 30786 24-UNDERWEAR [empty string] 15 152634 324073 98 2241-2185
7 130333 30786 24-UNDERWEAR [empty string] 17 152634 324074 98 2241-2185
8 130334 30786 24-UNDERWEAR [empty string] 0 152634 324075 98 2241-2185
9 130331 30786 24-UNDERWEAR [empty string] 26 152635 324076 98 2241-2185
10 130332 30786 24-UNDERWEAR [empty string] 16 152635 324077 98 2241-2185
11 130333 30786 24-UNDERWEAR [empty string] 13 152635 324078 98 2241-2185
12 130334 30786 24-UNDERWEAR [empty string] 0 152635 324079 98 2241-2185
13 130331 30786 24-UNDERWEAR [empty string] 9 152636 324080 98 2241-2185
14 130332 30786 24-UNDERWEAR [empty string] 13 152636 324081 98 2241-2185
15 130333 30786 24-UNDERWEAR [empty string] 17 152636 324082 98 2241-2185
16 130334 30786 24-UNDERWEAR [empty string] 0 152636 324083 98 2241-2185
17 130331 30786 24-UNDERWEAR [empty string] 6 152637 324084 98 2241-2185
18 130332 30786 24-UNDERWEAR [empty string] 7 152637 324085 98 2241-2185
19 130333 30786 24-UNDERWEAR [empty string] 10 152637 324086 98 2241-2185
20 130334 30786 24-UNDERWEAR [empty string] 0 152637 324087 98 2241-2185
21 130331 30786 24-UNDERWEAR [empty string] 1 152638 324248 98 2241-2185
22 130332 30786 24-UNDERWEAR [empty string] 4 152638 324249 98 2241-2185
23 130333 30786 24-UNDERWEAR [empty string] 3 152638 324250 98 2241-2185
24 130334 30786 24-UNDERWEAR [empty string] 0 152638 324251 98 2241-2185
25 130335 30786 24-UNDERWEAR [empty string] 0 152633 343687 98 2241-2185
26 130335 30786 24-UNDERWEAR [empty string] 0 152634 343688 98 2241-2185
27 130335 30786 24-UNDERWEAR [empty string] 0 152635 343689 98 2241-2185
28 130335 30786 24-UNDERWEAR [empty string] 0 152636 343690 98 2241-2185
29 130335 30786 24-UNDERWEAR [empty string] 0 152637 343691 98 2241-2185
30 130335 30786 24-UNDERWEAR [empty string] 0 152638 343692 98 2241-2185
31 130336 30786 24-UNDERWEAR [empty string] 0 152633 359153 98 2241-2185
32 130336 30786 24-UNDERWEAR [empty string] 0 152634 359154 98 2241-2185
33 130336 30786 24-UNDERWEAR [empty string] 0 152635 359155 98 2241-2185
34 130336 30786 24-UNDERWEAR [empty string] 0 152636 359156 98 2241-2185
35 130336 30786 24-UNDERWEAR [empty string] 0 152637 359157 98 2241-2185
36 130336 30786 24-UNDERWEAR [empty string] 0 152638 359158 98 2241-2185
37 130337 30786 24-UNDERWEAR [empty string] 0 152633 378974 98 2241-2185
38 130337 30786 24-UNDERWEAR [empty string] 0 152634 378975 98 2241-2185
39 130337 30786 24-UNDERWEAR [empty string] 0 152635 378976 98 2241-2185
40 130337 30786 24-UNDERWEAR [empty string] 0 152636 378977 98 2241-2185
41 130337 30786 24-UNDERWEAR [empty string] 0 152637 378978 98 2241-2185
42 130337 30786 24-UNDERWEAR [empty string] 0 152638 378979 98 2241-2185
43 130338 30786 24-UNDERWEAR [empty string] 0 152633 406353 98 2241-2185
44 130338 30786 24-UNDERWEAR [empty string] 0 152634 406354 98 2241-2185
45 130338 30786 24-UNDERWEAR [empty string] 0 152635 406355 98 2241-2185
46 130338 30786 24-UNDERWEAR [empty string] 0 152636 406356 98 2241-2185
47 130338 30786 24-UNDERWEAR [empty string] 0 152637 406357 98 2241-2185
48 130338 30786 24-UNDERWEAR [empty string] 0 152638 406358 98 2241-2185
49 130339 30786 24-UNDERWEAR [empty string] 0 152633 419260 98 2241-2185
50 130339 30786 24-UNDERWEAR [empty string] 0 152634 419261 98 2241-2185
51 130339 30786 24-UNDERWEAR [empty string] 0 152635 419262 98 2241-2185
52 130339 30786 24-UNDERWEAR [empty string] 0 152636 419263 98 2241-2185
53 130339 30786 24-UNDERWEAR [empty string] 0 152637 419264 98 2241-2185
54 130339 30786 24-UNDERWEAR [empty string] 0 152638 419265 98 2241-2185
55 130340 30786 24-UNDERWEAR [empty string] 0 152633 466454 98 2241-2185
56 130340 30786 24-UNDERWEAR [empty string] 0 152634 466455 98 2241-2185
57 130340 30786 24-UNDERWEAR [empty string] 0 152635 466456 98 2241-2185
58 130340 30786 24-UNDERWEAR [empty string] 0 152636 466457 98 2241-2185
59 130340 30786 24-UNDERWEAR [empty string] 0 152637 466458 98 2241-2185
60 130340 30786 24-UNDERWEAR [empty string] 0 152638 466459 98 2241-2185
61 130341 30786 24-UNDERWEAR [empty string] 6 152633 498495 98 2241-2185
62 130341 30786 24-UNDERWEAR [empty string] 14 152634 498496 98 2241-2185
63 130341 30786 24-UNDERWEAR [empty string] 12 152635 498497 98 2241-2185
64 130341 30786 24-UNDERWEAR [empty string] 7 152636 498498 98 2241-2185
65 130341 30786 24-UNDERWEAR [empty string] 5 152637 498499 98 2241-2185
66 130341 30786 24-UNDERWEAR [empty string] 0 152638 498500 98 2241-2185
67 130342 30786 24-UNDERWEAR [empty string] 0 152633 498501 98 2241-2185
68 130342 30786 24-UNDERWEAR [empty string] 1 152634 498502 98 2241-2185
69 130342 30786 24-UNDERWEAR [empty string] 0 152635 498503 98 2241-2185
70 130342 30786 24-UNDERWEAR [empty string] 2 152636 498504 98 2241-2185
71 130342 30786 24-UNDERWEAR [empty string] 0 152637 498505 98 2241-2185
72 130342 30786 24-UNDERWEAR [empty string] 0 152638 498506 98 2241-2185
CACHED false
EXECUTIONTIME 0
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 = '2241-2185' ) or b.style_id =?) and c.store_id in(98,8,9,2,5,7,6,3) --AND c.qoh > 1 and b.attr2_entry_id = 30786 AND isNull(b.sell_web,'Y') = 'Y' GROUP BY b.sku_id ORDER BY b.sku_id
SQLPARAMETERS
array
1 86402
248
Add to Cart Find in Store Add to Wish List

product description

Revolutionize your underwear drawer with the award-winning design of the ExOfficio Women's Give-N-Go Bikini Briefs. Discover what sets ExOfficio underwear apart with these bikini briefs that are breathable, lightweight, odor resistant and long-wearing. Ideal for travel, Give-N-Go's can be tossed in the laundry or washed in the sink to quickly produce a fresh, dry pair of undies. Guaranteed to keep your travels light, easy and breezy, these technically progressive underwear will spiritually enlighten your nether region and soon replace every other pair in your underwear drawer.

product specs
  • Antimicrobial treatment reduces odor in fabric
  • Breathable mesh fabric supplies airflow to keep you cool
  • Comfortable and durable fabric won't stretch out
  • Easy-care so you only need two for any trip
  • 94% Nylon / 6% Lycra® Spandex

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>Antimicrobial treatment reduces odor in fabric</li> <li>Breathable mesh fabric supplies airflow to keep you cool</li> <li>Comfortable and durable fabric won&#39;t stretch out</li> <li>Easy-care so you only need two for any trip</li> <li>94% Nylon / 6% Lycra&reg; Spandex</li> </ul> [empty string] [empty string] 59612 NUDE_8010,BLACK_9999,WHITE_1000,LOPOP_3030,ARBLU_5010, 30772 EXOFFICIO exofficio DISCOVER Discover &gt Gifts For &gt Heritage [empty string] [empty string] [empty string] 596 [empty string] 27429715 [empty string] 18 8 8.99 [empty string] 12277-DEFAULT-l.jpg 18 [empty string] 12277-DEFAULT-m.jpg Revolutionize your underwear drawer with the award-winning design of the ExOfficio Women's Give-N-Go Bikini Briefs. [empty string] W/ GIVE N GO BIKINI BRIEF N NEWATTR [empty string] [empty string] [empty string] [empty string] BTSTFW [empty string] [empty string] [empty string] [empty string] ACTIVE A 24D [empty string] [empty string] FALL_3 [empty string] [empty string] [empty string] [empty string] EX OFFICIO 246 0 [empty string] 12277 12277 5-to-10 0.00 0 [empty string] [empty string] [empty string] ExOfficio Women's Give-N-Go Bikini Briefs <p>Revolutionize your underwear drawer with the award-winning design of the ExOfficio Women&#39;s Give-N-Go Bikini Briefs. Discover what sets ExOfficio underwear apart with these bikini briefs that are breathable, lightweight, odor resistant and long-wearing. Ideal for travel, Give-N-Go&#39;s can be tossed in the laundry or washed in the sink to quickly produce a fresh, dry pair of undies. Guaranteed to keep your travels light, easy and breezy, these technically progressive underwear will spiritually enlighten your nether region and soon replace every other pair in your underwear drawer.</p> [empty string] Y 8.99 18 61089 0 L,M,S,XL,XS,XXL, [empty string] 12277-DEFAULT-s.jpg 1000 2241-2185 86402 HERITAGE EMPTY EMPTY 0 [empty string] [empty string] 12277-DEFAULT-xs.jpg GIFTS FOR shop/exofficio-womens-give-n-go-bik-86402 0 [empty string] 2241-2185 [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='86402' order by ID desc