SMARTWOOL

Smartwool Women's Sulawesi Stripe Socks

$20.95 $9.9952% off

Item # SW560

query
RESULTSET
query
  ORIGSIZ QOH SCALE_ENTRY_ID SIZ SIZE_ORDER SKU_ID STYLE_ID
1 S 2 7902 S [empty string] 441320 79786
2 L 2 7904 L [empty string] 486238 79786
CACHED false
EXECUTIONTIME 416
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 SW560
2 79786
query
RESULTSET
query
  ATTR1 ATTR1_ALIAS ATTR1_ENTRY_ID FAM HEX ORIGATTR1 QOH SIZE SKU_ID SORT_ORDER STYLE_ID
1 Bordeaux Heather Bordeaux Heather 121070 [empty string] [empty string] BORDEAUX_587 2 7902 441320 [empty string] 79786
2 Moonbeam Heather Moonbeam Heather 121072 [empty string] [empty string] MOONBEH_A10 2 7904 486238 [empty string] 79786
CACHED false
EXECUTIONTIME 2
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 79786
Smartwool Women's Sulawesi Stripe Socks BORDEAUX_587 Smartwool Women's Sulawesi Stripe Socks MOONBEH_A10
S L
query
RESULTSET
query
  ATTR1_ENTRY_ID ATTR2_ENTRY_ID DEPT PURCHASE_AMOUNT QOH SCALE_ENTRY_ID SKU_ID STORE_ID STYLE
1 121054 [empty string] 55-SOCKS [empty string] 0 7902 298460 98 SW560
2 121055 [empty string] 55-SOCKS [empty string] 0 7902 298461 98 SW560
3 121056 [empty string] 55-SOCKS [empty string] 0 7902 298462 98 SW560
4 121057 [empty string] 55-SOCKS [empty string] 0 7902 298463 98 SW560
5 121054 [empty string] 55-SOCKS [empty string] 0 7903 298464 98 SW560
6 121055 [empty string] 55-SOCKS [empty string] 0 7903 298465 98 SW560
7 121056 [empty string] 55-SOCKS [empty string] 0 7903 298466 98 SW560
8 121057 [empty string] 55-SOCKS [empty string] 0 7903 298467 98 SW560
9 121054 [empty string] 55-SOCKS [empty string] 0 7904 298468 98 SW560
10 121055 [empty string] 55-SOCKS [empty string] 0 7904 298469 98 SW560
11 121056 [empty string] 55-SOCKS [empty string] 0 7904 298470 98 SW560
12 121057 [empty string] 55-SOCKS [empty string] 0 7904 298471 98 SW560
13 121058 [empty string] 55-SOCKS [empty string] 0 7902 331428 98 SW560
14 121058 [empty string] 55-SOCKS [empty string] 0 7903 331429 98 SW560
15 121058 [empty string] 55-SOCKS [empty string] 0 7904 331430 98 SW560
16 121059 [empty string] 55-SOCKS [empty string] 0 7902 331431 98 SW560
17 121059 [empty string] 55-SOCKS [empty string] 0 7903 331432 98 SW560
18 121059 [empty string] 55-SOCKS [empty string] 0 7904 331433 98 SW560
19 121060 [empty string] 55-SOCKS [empty string] 0 7902 331434 98 SW560
20 121060 [empty string] 55-SOCKS [empty string] 0 7903 331435 98 SW560
21 121060 [empty string] 55-SOCKS [empty string] 0 7904 331436 98 SW560
22 121061 [empty string] 55-SOCKS [empty string] 0 7902 347118 98 SW560
23 121061 [empty string] 55-SOCKS [empty string] 0 7903 347119 98 SW560
24 121061 [empty string] 55-SOCKS [empty string] 0 7904 347120 98 SW560
25 121062 [empty string] 55-SOCKS [empty string] 0 7902 366506 98 SW560
26 121062 [empty string] 55-SOCKS [empty string] 0 7903 366507 98 SW560
27 121062 [empty string] 55-SOCKS [empty string] 0 7904 366508 98 SW560
28 121063 [empty string] 55-SOCKS [empty string] 0 7902 366509 98 SW560
29 121063 [empty string] 55-SOCKS [empty string] 0 7903 366510 98 SW560
30 121063 [empty string] 55-SOCKS [empty string] 0 7904 366511 98 SW560
31 121064 [empty string] 55-SOCKS [empty string] 0 7902 366512 98 SW560
32 121064 [empty string] 55-SOCKS [empty string] 0 7903 366513 98 SW560
33 121064 [empty string] 55-SOCKS [empty string] 0 7904 366514 98 SW560
34 121065 [empty string] 55-SOCKS [empty string] 0 7902 366515 98 SW560
35 121065 [empty string] 55-SOCKS [empty string] 0 7903 366516 98 SW560
36 121065 [empty string] 55-SOCKS [empty string] 0 7904 366517 98 SW560
37 121066 [empty string] 55-SOCKS [empty string] 0 7902 383513 98 SW560
38 121066 [empty string] 55-SOCKS [empty string] 0 7903 383514 98 SW560
39 121066 [empty string] 55-SOCKS [empty string] 0 7904 383515 98 SW560
40 121067 [empty string] 55-SOCKS [empty string] 0 7902 407225 98 SW560
41 121067 [empty string] 55-SOCKS [empty string] 0 7903 407226 98 SW560
42 121067 [empty string] 55-SOCKS [empty string] 0 7904 407227 98 SW560
43 121068 [empty string] 55-SOCKS [empty string] 0 7902 421320 98 SW560
44 121068 [empty string] 55-SOCKS [empty string] 0 7903 421321 98 SW560
45 121068 [empty string] 55-SOCKS [empty string] 0 7904 421322 98 SW560
46 121069 [empty string] 55-SOCKS [empty string] 0 7902 421323 98 SW560
47 121069 [empty string] 55-SOCKS [empty string] 0 7903 421324 98 SW560
48 121069 [empty string] 55-SOCKS [empty string] 0 7904 421325 98 SW560
49 121070 [empty string] 55-SOCKS [empty string] 2 7902 441320 98 SW560
50 121070 [empty string] 55-SOCKS [empty string] 0 7903 441321 98 SW560
51 121070 [empty string] 55-SOCKS [empty string] 0 7904 441322 98 SW560
52 121071 [empty string] 55-SOCKS [empty string] 0 7902 441323 98 SW560
53 121071 [empty string] 55-SOCKS [empty string] 0 7903 441324 98 SW560
54 121071 [empty string] 55-SOCKS [empty string] 0 7904 441325 98 SW560
55 121072 [empty string] 55-SOCKS [empty string] 0 7902 486236 98 SW560
56 121072 [empty string] 55-SOCKS [empty string] 0 7903 486237 98 SW560
57 121072 [empty string] 55-SOCKS [empty string] 2 7904 486238 98 SW560
CACHED false
EXECUTIONTIME 1299
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 = 'SW560' ) 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 79786
4
Add to Cart Find in Store Add to Wish List

product description Inspired by the pallette of Indonesia, the Smartwool Women's Sulawesi Stripe Socks will take your toes on an island vacation. Merino wool provides moisture wicking, and their arch-brace helps with all-day support. With colorful patterns and a fit that won't bunch or slip, these socks will brighten any day.
product specs
  • Supportive arch brace
  • Virtually Seamless toe
  • Sock Height: Crew
  • Knit in USA of Imported Yarn: 57% Merino Wool, 40% Nylon, 3% Elastane
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 <li>Supportive arch brace</li> <li>Virtually Seamless toe</li> <li>Sock Height: Crew</li> <li>Knit in USA of Imported Yarn: 57% Merino Wool, 40% Nylon, 3% Elastane</li> [empty string] [empty string] 56486 BORDEAUX_587,MOONBEH_A10, [empty string] SMARTWOOL SMARTWOOL CLOTHING & FOOTWEAR Clothing & Footwear &gt Women's &gt Footwear [empty string] [empty string] [empty string] 187 [empty string] 27364374 [empty string] 20.95 9 9.99 casual 11400-DEFAULT-l.jpg 20.95 [empty string] 11400-DEFAULT-m.jpg With colorful patterns and a fit that won't bunch or slip, the Smartwool Women's Sulawesi Stripe Socks will brighten any day. [empty string] W/ SULAWESI STRIPE N [empty string] [empty string] [empty string] [empty string] [empty string] BTSTFW [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 55B [empty string] [empty string] FALL_3 [empty string] [empty string] [empty string] [empty string] SMARTWOOL 3 0 [empty string] 11400 11400 5-to-10 0.00 0 [empty string] [empty string] [empty string] Smartwool Women's Sulawesi Stripe Socks Inspired by the pallette of Indonesia, the Smartwool Women's Sulawesi Stripe Socks will take your toes on an island vacation. Merino wool provides moisture wicking, and their arch-brace helps with all-day support. With colorful patterns and a fit that won't bunch or slip, these socks will brighten any day. [empty string] Y 9.99 9.99 2864 0 L,S, [empty string] 11400-DEFAULT-s.jpg 1000 SW560 79786 FOOTWEAR EMPTY EMPTY 0 [empty string] [empty string] 11400-DEFAULT-xs.jpg WOMENS shop/smartwool-womens-sulawesi-stri-79786 0 [empty string] SW560 [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 6
SQL SELECT * from [dbo].[web_all_products] WHERE style_id='79786' order by ID desc