Injinji

Injinji Unisex Run Lightweight No-Show Socks

$12.00

Item # 201110

query
RESULTSET
query
  ORIGSIZ QOH SCALE_ENTRY_ID SIZ SIZE_ORDER SKU_ID STYLE_ID
1 S 50 7902 S [empty string] 500233 74978
2 M 128 7903 M [empty string] 500234 74978
3 L 44 7904 L [empty string] 500235 74978
CACHED false
EXECUTIONTIME 415
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 201110
2 74978
query
RESULTSET
query
  ATTR1 ATTR1_ALIAS ATTR1_ENTRY_ID FAM HEX ORIGATTR1 QOH SIZE SKU_ID SORT_ORDER STYLE_ID
1 BLACK [empty string] 126086 [empty string] [empty string] BLACK 68 7904 275067 [empty string] 74978
2 Seafoam Seafoam 126096 [empty string] [empty string] SEAFOAM 56 7904 468889 [empty string] 74978
3 AQUABERRY [empty string] 126098 [empty string] [empty string] AQUABERRY 49 7904 500235 [empty string] 74978
4 GRAY [empty string] 126097 [empty string] [empty string] GRAY 49 7904 500232 [empty string] 74978
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 74978
Injinji Unisex Run Lightweight No-Show Socks BLACK Injinji Unisex Run Lightweight No-Show Socks SEAFOAM Injinji Unisex Run Lightweight No-Show Socks AQUABERRY Injinji Unisex Run Lightweight No-Show Socks GRAY
S M L
query
RESULTSET
query
  ATTR1_ENTRY_ID ATTR2_ENTRY_ID DEPT PURCHASE_AMOUNT QOH SCALE_ENTRY_ID SKU_ID STORE_ID STYLE
1 126086 [empty string] 55-SOCKS [empty string] 17 7902 275063 98 201110
2 126087 [empty string] 55-SOCKS [empty string] 0 7902 275064 98 201110
3 126086 [empty string] 55-SOCKS [empty string] 41 7903 275065 98 201110
4 126087 [empty string] 55-SOCKS [empty string] 0 7903 275066 98 201110
5 126086 [empty string] 55-SOCKS [empty string] 10 7904 275067 98 201110
6 126087 [empty string] 55-SOCKS [empty string] 0 7904 275068 98 201110
7 126088 [empty string] 55-SOCKS [empty string] 0 7902 275072 98 201110
8 126088 [empty string] 55-SOCKS [empty string] 0 7903 275073 98 201110
9 126088 [empty string] 55-SOCKS [empty string] 0 7904 275074 98 201110
10 126089 [empty string] 55-SOCKS [empty string] 0 7902 275075 98 201110
11 126089 [empty string] 55-SOCKS [empty string] 0 7903 275076 98 201110
12 126089 [empty string] 55-SOCKS [empty string] 0 7904 275077 98 201110
13 126090 [empty string] 55-SOCKS [empty string] 0 7902 296150 98 201110
14 126090 [empty string] 55-SOCKS [empty string] 0 7903 296151 98 201110
15 126090 [empty string] 55-SOCKS [empty string] 0 7904 296152 98 201110
16 126091 [empty string] 55-SOCKS [empty string] 0 7902 296153 98 201110
17 126091 [empty string] 55-SOCKS [empty string] 0 7903 296154 98 201110
18 126091 [empty string] 55-SOCKS [empty string] 0 7904 296155 98 201110
19 126092 [empty string] 55-SOCKS [empty string] 0 7902 306578 98 201110
20 126092 [empty string] 55-SOCKS [empty string] 0 7903 306579 98 201110
21 126092 [empty string] 55-SOCKS [empty string] 0 7904 306580 98 201110
22 126093 [empty string] 55-SOCKS [empty string] 0 7902 376360 98 201110
23 126093 [empty string] 55-SOCKS [empty string] 0 7903 376361 98 201110
24 126093 [empty string] 55-SOCKS [empty string] 0 7904 376362 98 201110
25 126094 [empty string] 55-SOCKS [empty string] 0 7902 382428 98 201110
26 126094 [empty string] 55-SOCKS [empty string] 0 7903 382429 98 201110
27 126094 [empty string] 55-SOCKS [empty string] 0 7904 382430 98 201110
28 126095 [empty string] 55-SOCKS [empty string] 0 7902 422307 98 201110
29 126095 [empty string] 55-SOCKS [empty string] 0 7903 422308 98 201110
30 126095 [empty string] 55-SOCKS [empty string] 0 7904 422309 98 201110
31 126096 [empty string] 55-SOCKS [empty string] 9 7902 468887 98 201110
32 126096 [empty string] 55-SOCKS [empty string] 36 7903 468888 98 201110
33 126096 [empty string] 55-SOCKS [empty string] 11 7904 468889 98 201110
34 126097 [empty string] 55-SOCKS [empty string] 14 7902 500230 98 201110
35 126097 [empty string] 55-SOCKS [empty string] 23 7903 500231 98 201110
36 126097 [empty string] 55-SOCKS [empty string] 12 7904 500232 98 201110
37 126098 [empty string] 55-SOCKS [empty string] 10 7902 500233 98 201110
38 126098 [empty string] 55-SOCKS [empty string] 28 7903 500234 98 201110
39 126098 [empty string] 55-SOCKS [empty string] 11 7904 500235 98 201110
CACHED false
EXECUTIONTIME 445
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 = '201110' ) 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 74978
222
Add to Cart Find in Store Add to Wish List

product description

Maximize your running comfort by minimizing moisture build-up and friction with the Injinji Unisex Run Lightweight No-Show Socks. Ultra-thin to minimize bulk, these performance toe socks allow your toes to splay naturally for alignment and a more comfortable fit. Your feet will remain light and dry with the breathable mesh top that allows for maximum ventilation during high-output activities. Its minimalist design sits below the ankle and features a heel tab to prevent chafing and keep the sock fitting securely in place. The Run series offers innovative, restriction-free movement and eliminates skin on skin friction, which is one of the primary causes of blisters.

product specs
  • 200 needle count fiber
  • Supportive band provides arch support
  • Better grip
  • Blister prevention
  • Moisture-wicking properties
  • Toes splay naturally allowing for total foot utilization
  • Mesh top for breathability
  • Fiber content: 28% COOLMAX®, 67% Nylon and 5% Lycra®
  • Machine wash delicate with cold water, line dry
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>200 needle count fiber</li> <li>Supportive band provides arch support</li> <li>Better grip</li> <li>Blister prevention</li> <li>Moisture-wicking properties</li> <li>Toes splay naturally allowing for total foot utilization</li> <li>Mesh top for breathability</li> <li>Fiber content: 28% COOLMAX&reg;, 67% Nylon and 5% Lycra&reg;</li> <li>Machine wash delicate with cold water, line dry</li> </ul> [empty string] [empty string] 58019 BLACK,SEAFOAM,AQUABERRY,GRAY, [empty string] INJINJI Injinji CLOTHING & FOOTWEAR Clothing & Footwear &gt Men's &gt Socks &gt Performance [empty string] [empty string] [empty string] 596 [empty string] 27367996 [empty string] 12 12 12 [empty string] 11794-DEFAULT-l.jpg 12 [empty string] 11794-DEFAULT-m.jpg Maximize your running comfort with the Injinji Unisex Run Lightweight No-Show Socks. Ultra-thin to minimize bulk, these performance toe socks allow your toes to splay naturally for alignment and a more comfortable fit. [empty string] U/RUN LT-WT NO SHOW N NEWATTR [empty string] [empty string] [empty string] [empty string] BTSTFW [empty string] [empty string] [empty string] [empty string] [empty string] A 55A [empty string] [empty string] FALL_3 [empty string] [empty string] [empty string] N INJINJI FOOTWEAR 221 0 [empty string] 11794 11794 10-to-15 0.00 0 [empty string] [empty string] [empty string] Injinji Unisex Run Lightweight No-Show Socks <p>Maximize your running comfort by minimizing moisture build-up and friction with the Injinji Unisex Run Lightweight No-Show Socks. Ultra-thin to minimize bulk, these performance toe socks allow your toes to splay naturally for alignment and a more comfortable fit. Your feet will remain light and dry with the breathable mesh top that allows for maximum ventilation during high-output activities. Its minimalist design sits below the ankle and features a heel tab to prevent chafing and keep the sock fitting securely in place. The Run series offers innovative, restriction-free movement and eliminates skin on skin friction, which is one of the primary causes of blisters.</p> [empty string] N 12 12 2864 0 L,M,S, [empty string] 11794-DEFAULT-s.jpg 1000 201110 74978 SOCKS PERFORMANCE EMPTY 0 [empty string] [empty string] 11794-DEFAULT-xs.jpg MENS shop/injinji-unisex-run-lightweight-74978 0 [empty string] 201110 [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 8
SQL SELECT * from [dbo].[web_all_products] WHERE style_id='74978' order by ID desc