Whole Earth Provision Co. | exofficio ExOfficio Women's Modern Collection Thong

exofficio

ExOfficio Women's Modern Collection Thong

$26.00

Item # 2241-3380

query

RESULTSET

query
	ORIGSIZ	QOH	SCALE_ENTRY_ID	SIZ	SIZE_ORDER	SKU_ID	STYLE_ID
1	00_XS	11	1024	XS	[empty string]	466396	126903
2	01_SM	23	1025	S	[empty string]	466398	126903
3	02_MD	30	1026	M	[empty string]	466400	126903
4	03_LG	22	1027	L	[empty string]	466402	126903
5	04_XL	11	1028	XL	[empty string]	466404	126903

CACHED

false

EXECUTIONTIME

2141

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	2241-3380
2	126903

Select Color

ExOfficio Women's Modern Collection Thong BUFF_8295

ExOfficio Women's Modern Collection Thong BLACK_9999

Select Size XS S M L XL

product description

The ExOfficio Women's Modern Collection Thong embodies sleek, smooth, comfort and style with dynamic technical performance for all your travel needs. Super soft, nylon stretch fabric regulates perspiration in response to body temperature to keep you cool & dry. Sheer mesh stripe side panels provide breathability and a flattering line. Bonded waist and leg openings create a smooth, line-free look under form-fitting clothes. With a cotton panty liner for breathability, long-lasting odor resistance, and a comfortable fit, you'll want to wear these every day during your travels and all year round.

product specs

Supersoft & comfortable nylon stretch fabric with HeiQ Adaptive finish dynamically adapts to body heat, prevents odor & is cool to the touch
Sheer stripe mesh side panels for better breathability & more flattering fit
Cotton panty liner offers additional breathability & softness
Bonded leg and waist openings provide a line-free look that works great under form-fitting clothes
Fabric: 3.24oz/yd, 82% nylon / 18% Spandex

Tula Unisex Lifeguard Hat - L/XL Natural

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

ECCO ECCO Women's Yucatan Sandals $130.00

*More Colors Available* DAKINE Dakine Jo Jo Handbag $25.00

Tula Women's Carmel Hat Cranberry Band Cranberryband

TULA HATS Tula Women's Carmel Hat Cranberry Band $37.95

Klogs Footwear Klogs Women's Springfield Shoes $59.95

Dakine Women's JoJo Elevated Handbag Elmwood

DAKINE Dakine Women's JoJo Elevated Handbag $30.00

Tula Women's Ranch Lattice Hat - M Straw

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

ECCO ECCO Women's Yucatan Sandals $135.00

Tula Women's Ranch Lattice Hat - L Straw

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

Klogs Footwear Women's Springfield Wide Non-Slip Shoes Black

Klogs Footwear Klogs Footwear Women's Springfield Wide Non-Slip Shoes $59.95

TULA HATS Tula Women's Elegant Ranch Hat $37.95

DAKINE Dakine Women's Sydney Tote 25L $65.00

*More Colors Available* DAKINE Dakine Women’s Jacky Handbag $20.00

*More Colors Available* DAKINE Dakine Women’s Jive Handbag $10.99 to $15.00

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

Dansko Women's Professional Clogs Blkbox

DANSKO Dansko Women's Professional Clogs $120.00

Injinji Injinji Unisex Liner Crew Socks $10.00

Tula Women's Ranch Lattice Hat - S Straw

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

*More Colors Available* DAKINE Dakine Women’s Jive Handbag $15.00

Tula Unisex Fedora Hat Multi Band - Small Multi_band

TULA HATS Tula Unisex Fedora Hat Multi Band - Small $35.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>Supersoft & comfortable nylon stretch fabric with HeiQ Adaptive finish dynamically adapts to body heat, prevents odor & is cool to the touch</li> <li>Sheer stripe mesh side panels for better breathability & more flattering fit</li> <li>Cotton panty liner offers additional breathability & softness</li> <li>Bonded leg and waist openings provide a line-free look that works great under form-fitting clothes</li> <li>Fabric: 3.24oz/yd, 82% nylon / 18% Spandex</li> </ul>	[empty string]	[empty string]	54509	BUFF_8295,BLACK_9999,	64967	EXOFFICIO	exofficio	CLOTHING & FOOTWEAR	Clothing & Footwear &gt Women's &gt Underwear &gt Panties	[empty string]	[empty string]	[empty string]	596	[empty string]	23787523	[empty string]	26	26	26	[empty string]	16718-DEFAULT-l.jpg	26	[empty string]	16718-DEFAULT-m.jpg	Wear the barely-there underwear with neato bells and whistles when you put on the ExOfficio Women's Modern Collection Thong.	[empty string]	W/ MODERN COLLECTION THONG	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	BTSTFW	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	24D	[empty string]	[empty string]	SPRING	[empty string]	[empty string]	[empty string]	N	EX OFFICIO	97	0	[empty string]	16718	16718	25-to-50	0.00	0	[empty string]	[empty string]	[empty string]	ExOfficio Women's Modern Collection Thong	<p>The ExOfficio Women's Modern Collection Thong embodies sleek, smooth, comfort and style with dynamic technical performance for all your travel needs. Super soft, nylon stretch fabric regulates perspiration in response to body temperature to keep you cool & dry. Sheer mesh stripe side panels provide breathability and a flattering line. Bonded waist and leg openings create a smooth, line-free look under form-fitting clothes. With a cotton panty liner for breathability, long-lasting odor resistance, and a comfortable fit, you'll want to wear these every day during your travels and all year round.</p>	[empty string]	N	26	26	439	0	00_XS,01_SM,02_MD,03_LG,04_XL,	[empty string]	16718-DEFAULT-s.jpg	4	2241-3380	126903	UNDERWEAR	PANTIES	EMPTY	0	2	[empty string]	16718-DEFAULT-xs.jpg	WOMENS	shop/exofficio-womens-modern-collec-126903	0	[empty string]	2241-3380	[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='126903' order by ID desc