Whole Earth Provision Co. | PATAGONIA Patagonia Women's Barely Bikini

PATAGONIA

Patagonia Women's Barely Bikini

$14.99 to $22.00

Item # 32392

query

RESULTSET

query
	ORIGSIZ	QOH	SCALE_ENTRY_ID	SIZ	SIZE_ORDER	SKU_ID	STYLE_ID
1	0_XS	15	1396	XS	[empty string]	499303	125657
2	1_S	39	1397	S	[empty string]	499304	125657
3	2_M	47	1398	M	[empty string]	499305	125657
4	3_L	38	1399	L	[empty string]	499306	125657
5	4_XL	17	1400	XL	[empty string]	499307	125657

CACHED

false

EXECUTIONTIME

2703

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+e.qc) 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) LEFT JOIN tb_sku_buckets e WITH (NOLOCK) on (e.sku_id = a.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.store_id in (98,8,9,2,5,7,6,3) GROUP BY b.siz HAVING sum(e.qoh+e.qc) > 0 ORDER BY max(b.size_order), max(a.scale_entry_id)

SQLPARAMETERS

array
1	32392
2	125657

Select Color

Patagonia Women's Barely Bikini BLACK_VJQB

Patagonia Women's Barely Bikini ROSEWTR_VJQR

Patagonia Women's Barely Bikini BGREEN_VJBE

Select Size XS S M L XL

product description

The low-rise Patagonia Women's Barely Bikini underwear has feminine styling and seamless construction to minimize panty lines; the supple, featherweight synthetic fabric blend dries quickly—keeping you comfortable longer. The fabric is treated with miDori® bioSoft for enhanced moisture wicking performance and Polygiene® permanent odor control. The soft merrow-stitch finish at the leg holes provides next-to-skin comfort. Floral jacquard is engineered into the fabric for a feminine appearance.

product specs

Soft, featherweight nylon/spandex fabric wicks and breathes
Narrow, seamless waistband lies flat and won’t roll or bind
Floral jacquard is engineered into the fabric
Soft merrow-stitch finish at the leg openings for comfort
Crotch construction is fast-wicking and dries quickly
4-oz 89% nylon (66% recycled)/11% spandex with miDori bioSoft for added wicking and softness, and Polygiene® permanent odor control
Fair Trade Certified sewn
20g / 0.7oz

ECCO ECCO Women's Yucatan Sandals $130.00

DAKINE Dakine Women's Jackey Handbag $25.00

TULA HATS Tula Unisex Pecos Hat - L/XL $37.95

Tula Unisex Lifeguard Hat - L/XL Natural

TULA HATS Tula Unisex Lifeguard Hat - L/XL $37.95

Tula Women's Ranch Lattice Hat - S Straw

TULA HATS Tula Women's Ranch Lattice Hat - S $35.95

ECCO ECCO Women's Yucatan Sandals $135.00

*More Colors Available* DAKINE Dakine Women’s Jaime Handbag $20.99 to $30.00

Tula Unisex Gardener Lattice Hat - XXL Straw

TULA HATS Tula Unisex Gardener Lattice Hat - XXL $37.95

Tula Unisex Fedora Hat Multi Band - Small Multi_band

TULA HATS Tula Unisex Fedora Hat Multi Band - Small $35.95

Injinji Injinji Unisex Liner Crew Socks $10.00

Tula Unisex Gardener Lattice Hat - L/XL Straw

TULA HATS Tula Unisex Gardener Lattice Hat - L/XL $37.95

Vionic Women's Tide II Toe Post Sandals Brnzmtl

*More Colors Available* VIONIC Vionic Women's Tide II Toe Post Sandals $64.95

TULA HATS Tula Unisex Pecos Hat - XXL $37.95

Dakine Women's JoJo Elevated Handbag Elmwood

DAKINE Dakine Women's JoJo Elevated Handbag $30.00

Klogs Footwear Klogs Women's Springfield Shoes $59.95

Tula Women's Ranch Lattice Hat - L Straw

TULA HATS Tula Women's Ranch Lattice Hat - L $37.95

*More Colors Available* VIONIC Vionic Women's Rest Kirra Sandals $99.95

TULA HATS Tula Unisex Pecos Hat - S/M $37.95

TULA HATS Tula Women's Elegant Ranch Hat $37.95

TOMS Women's Black Denim Majorca Cutout Sandals Blackdenim

Toms Shoes TOMS Women's Black Denim Majorca Cutout Sandals $89.95

Overall Rating

0.0/5.0

Review Stats 0 total reviews

5 0

4 0

3 0

2 0

1 0

Write a Review

1 - 0 of 0

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

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>Soft, featherweight nylon/spandex fabric wicks and breathes</li> <li>Narrow, seamless waistband lies flat and won’t roll or bind</li> <li>Floral jacquard is engineered into the fabric</li> <li>Soft merrow-stitch finish at the leg openings for comfort</li> <li>Crotch construction is fast-wicking and dries quickly</li> <li>4-oz 89% nylon (66% recycled)/11% spandex with miDori bioSoft for added wicking and softness, and Polygiene® permanent odor control</li> <li>Fair Trade Certified sewn</li> <li>20g / 0.7oz</li> </ul>	[empty string]	[empty string]	57880	BLACK_VJQB,ROSEWTR_VJQR,VFJN,BGREEN_VJBE,	64024	PATAGONIA	PATAGONIA	CLOTHING & FOOTWEAR	Clothing & Footwear &gt Women's &gt Underwear &gt Panties	[empty string]	[empty string]	[empty string]	596	[empty string]	23788098	[empty string]	22	14	14.99	brief, undies, underware, knickers	19719-DEFAULT-l.jpg	22	[empty string]	19719-DEFAULT-m.jpg	Move with confidence. The low-rise Patagonia Women's Barely Bikini underwear has feminine styling and seamless construction to minimize panty lines. Its wicking fabric dries quickly— keeping you comfortable longer.	[empty string]	W/ BARELY BIKINI	N	NEWATTR	[empty string]	[empty string]	[empty string]	[empty string]	BTSTFW	[empty string]	[empty string]	PIN	[empty string]	ACTIVE	[empty string]	24D	[empty string]	[empty string]	SPRING	[empty string]	[empty string]	[empty string]	N	PATAGONIA	156	0	[empty string]	19719	19719	10-to-15	0.00	0	[empty string]	[empty string]	[empty string]	Patagonia Women's Barely Bikini	<p>The low-rise Patagonia Women's Barely Bikini underwear has feminine styling and seamless construction to minimize panty lines; the supple, featherweight synthetic fabric blend dries quickly—keeping you comfortable longer. The fabric is treated with miDori® bioSoft for enhanced moisture wicking performance and Polygiene® permanent odor control. The soft merrow-stitch finish at the leg holes provides next-to-skin comfort. Floral jacquard is engineered into the fabric for a feminine appearance.</p>	[empty string]	Y	14.99	22	668	0	0_XS,1_S,2_M,3_L,4_XL,	[empty string]	19719-DEFAULT-s.jpg	14	32392	125657	UNDERWEAR	PANTIES	EMPTY	0	2	[empty string]	19719-DEFAULT-xs.jpg	WOMENS	shop/patagonia-womens-barely-bikini-125657	0	[empty string]	32392	[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

SQL

SELECT * from [dbo].[web_all_products] WHERE style_id='125657' order by ID desc