The North Face

The North Face Men's Venture 2 Jacket

$78.99 to $99.00

Item # NF0A2VD3

query
RESULTSET
query
  ORIGSIZ QOH SCALE_ENTRY_ID SIZ SIZE_ORDER SKU_ID STYLE_ID
1 01_SM 15 114413 S 13 531419 107037
2 03_LG 42 114415 L 13 531421 107037
3 02_MD 24 114414 M 18 531420 107037
4 04_XL 22 114416 XL 24 531422 107037
5 05_XXL 6 114417 XXL 33 531418 107037
CACHED false
EXECUTIONTIME 438
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 NF0A2VD3
2 107037
query
RESULTSET
query
  ATTR1 ATTR1_ALIAS ATTR1_ENTRY_ID FAM HEX ORIGATTR1 QOH SIZE SKU_ID SORT_ORDER STYLE_ID
1 URBANNVY_H2G [empty string] 135121 [empty string] [empty string] URBANNVY_H2G 41 114416 531422 [empty string] 107037
2 DRKGRY_DYZ [empty string] 135120 [empty string] [empty string] DRKGRY_DYZ 34 114417 531418 [empty string] 107037
3 TNF Black/TNF Black TNF Black/TNF Black 135107 [empty string] [empty string] BLACK_KX7 32 114417 419652 [empty string] 107037
4 AYJ_LEAFGRY [empty string] 135119 [empty string] [empty string] AYJ_LEAFGRY 2 114417 515140 [empty string] 107037
CACHED false
EXECUTIONTIME 3
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 107037
The North Face Men's Venture 2 Jacket URBANNVY_H2G DRKGRY_DYZ The North Face Men's Venture 2 Jacket BLACK_KX7 The North Face Men's Venture 2 Jacket AYJ_LEAFGRY
S L M XL XXL
query
RESULTSET
query
  ATTR1_ENTRY_ID ATTR2_ENTRY_ID DEPT PURCHASE_AMOUNT QOH SCALE_ENTRY_ID SKU_ID STORE_ID STYLE
1 135107 47512 10-OUTERWEAR [empty string] 6 114413 419636 98 NF0A2VD3
2 135108 47512 10-OUTERWEAR [empty string] 0 114413 419637 98 NF0A2VD3
3 135109 47512 10-OUTERWEAR [empty string] 0 114413 419638 98 NF0A2VD3
4 135110 47512 10-OUTERWEAR [empty string] 0 114413 419639 98 NF0A2VD3
5 135107 47512 10-OUTERWEAR [empty string] 5 114414 419640 98 NF0A2VD3
6 135108 47512 10-OUTERWEAR [empty string] 0 114414 419641 98 NF0A2VD3
7 135109 47512 10-OUTERWEAR [empty string] 0 114414 419642 98 NF0A2VD3
8 135110 47512 10-OUTERWEAR [empty string] 0 114414 419643 98 NF0A2VD3
9 135107 47512 10-OUTERWEAR [empty string] 13 114415 419644 98 NF0A2VD3
10 135108 47512 10-OUTERWEAR [empty string] 0 114415 419645 98 NF0A2VD3
11 135109 47512 10-OUTERWEAR [empty string] 0 114415 419646 98 NF0A2VD3
12 135110 47512 10-OUTERWEAR [empty string] 0 114415 419647 98 NF0A2VD3
13 135107 47512 10-OUTERWEAR [empty string] 6 114416 419648 98 NF0A2VD3
14 135108 47512 10-OUTERWEAR [empty string] 0 114416 419649 98 NF0A2VD3
15 135109 47512 10-OUTERWEAR [empty string] 1 114416 419650 98 NF0A2VD3
16 135110 47512 10-OUTERWEAR [empty string] 0 114416 419651 98 NF0A2VD3
17 135107 47512 10-OUTERWEAR [empty string] 2 114417 419652 98 NF0A2VD3
18 135108 47512 10-OUTERWEAR [empty string] 0 114417 419653 98 NF0A2VD3
19 135109 47512 10-OUTERWEAR [empty string] 0 114417 419654 98 NF0A2VD3
20 135110 47512 10-OUTERWEAR [empty string] 0 114417 419655 98 NF0A2VD3
21 135111 47512 10-OUTERWEAR [empty string] 0 114413 425404 98 NF0A2VD3
22 135111 47512 10-OUTERWEAR [empty string] 0 114414 425405 98 NF0A2VD3
23 135111 47512 10-OUTERWEAR [empty string] 0 114415 425406 98 NF0A2VD3
24 135111 47512 10-OUTERWEAR [empty string] 1 114416 425407 98 NF0A2VD3
25 135111 47512 10-OUTERWEAR [empty string] 0 114417 425408 98 NF0A2VD3
26 135112 47512 10-OUTERWEAR [empty string] 0 114413 425409 98 NF0A2VD3
27 135112 47512 10-OUTERWEAR [empty string] 0 114414 425410 98 NF0A2VD3
28 135112 47512 10-OUTERWEAR [empty string] 0 114415 425411 98 NF0A2VD3
29 135112 47512 10-OUTERWEAR [empty string] 0 114416 425412 98 NF0A2VD3
30 135112 47512 10-OUTERWEAR [empty string] 0 114417 425413 98 NF0A2VD3
31 135113 47512 10-OUTERWEAR [empty string] 0 114413 436897 98 NF0A2VD3
32 135113 47512 10-OUTERWEAR [empty string] 0 114414 436898 98 NF0A2VD3
33 135113 47512 10-OUTERWEAR [empty string] 0 114415 436899 98 NF0A2VD3
34 135113 47512 10-OUTERWEAR [empty string] 0 114416 436900 98 NF0A2VD3
35 135113 47512 10-OUTERWEAR [empty string] 0 114417 436901 98 NF0A2VD3
36 135114 47512 10-OUTERWEAR [empty string] 0 114413 463499 98 NF0A2VD3
37 135114 47512 10-OUTERWEAR [empty string] 0 114414 463500 98 NF0A2VD3
38 135114 47512 10-OUTERWEAR [empty string] 0 114415 463501 98 NF0A2VD3
39 135114 47512 10-OUTERWEAR [empty string] 0 114416 463502 98 NF0A2VD3
40 135114 47512 10-OUTERWEAR [empty string] 0 114417 463503 98 NF0A2VD3
41 135115 47512 10-OUTERWEAR [empty string] 0 114413 483013 98 NF0A2VD3
42 135115 47512 10-OUTERWEAR [empty string] 0 114414 483014 98 NF0A2VD3
43 135115 47512 10-OUTERWEAR [empty string] 0 114415 483015 98 NF0A2VD3
44 135115 47512 10-OUTERWEAR [empty string] 0 114416 483016 98 NF0A2VD3
45 135115 47512 10-OUTERWEAR [empty string] 0 114417 483017 98 NF0A2VD3
46 135116 47512 10-OUTERWEAR [empty string] 0 114413 483018 98 NF0A2VD3
47 135116 47512 10-OUTERWEAR [empty string] 0 114414 483019 98 NF0A2VD3
48 135116 47512 10-OUTERWEAR [empty string] 0 114415 483020 98 NF0A2VD3
49 135116 47512 10-OUTERWEAR [empty string] 0 114416 483021 98 NF0A2VD3
50 135116 47512 10-OUTERWEAR [empty string] 0 114417 483022 98 NF0A2VD3
51 135117 47512 10-OUTERWEAR [empty string] 1 114413 515126 98 NF0A2VD3
52 135117 47512 10-OUTERWEAR [empty string] 0 114414 515127 98 NF0A2VD3
53 135117 47512 10-OUTERWEAR [empty string] 0 114415 515128 98 NF0A2VD3
54 135117 47512 10-OUTERWEAR [empty string] 1 114416 515129 98 NF0A2VD3
55 135117 47512 10-OUTERWEAR [empty string] 0 114417 515130 98 NF0A2VD3
56 135119 47512 10-OUTERWEAR [empty string] 0 114413 515136 98 NF0A2VD3
57 135119 47512 10-OUTERWEAR [empty string] 0 114414 515137 98 NF0A2VD3
58 135119 47512 10-OUTERWEAR [empty string] 0 114415 515138 98 NF0A2VD3
59 135119 47512 10-OUTERWEAR [empty string] 1 114416 515139 98 NF0A2VD3
60 135119 47512 10-OUTERWEAR [empty string] 2 114417 515140 98 NF0A2VD3
61 135120 47512 10-OUTERWEAR [empty string] 3 114413 531414 98 NF0A2VD3
62 135120 47512 10-OUTERWEAR [empty string] 9 114414 531415 98 NF0A2VD3
63 135120 47512 10-OUTERWEAR [empty string] 13 114415 531416 98 NF0A2VD3
64 135120 47512 10-OUTERWEAR [empty string] 7 114416 531417 98 NF0A2VD3
65 135120 47512 10-OUTERWEAR [empty string] 2 114417 531418 98 NF0A2VD3
66 135121 47512 10-OUTERWEAR [empty string] 6 114413 531419 98 NF0A2VD3
67 135121 47512 10-OUTERWEAR [empty string] 10 114414 531420 98 NF0A2VD3
68 135121 47512 10-OUTERWEAR [empty string] 16 114415 531421 98 NF0A2VD3
69 135121 47512 10-OUTERWEAR [empty string] 9 114416 531422 98 NF0A2VD3
70 135121 47512 10-OUTERWEAR [empty string] 1 114417 531423 98 NF0A2VD3
71 135122 47512 10-OUTERWEAR [empty string] 0 114413 531424 98 NF0A2VD3
72 135122 47512 10-OUTERWEAR [empty string] 0 114414 531425 98 NF0A2VD3
73 135122 47512 10-OUTERWEAR [empty string] 0 114415 531426 98 NF0A2VD3
74 135122 47512 10-OUTERWEAR [empty string] 0 114416 531427 98 NF0A2VD3
75 135122 47512 10-OUTERWEAR [empty string] 0 114417 531428 98 NF0A2VD3
76 135123 47512 10-OUTERWEAR [empty string] 0 114413 531429 98 NF0A2VD3
77 135123 47512 10-OUTERWEAR [empty string] 0 114414 531430 98 NF0A2VD3
78 135123 47512 10-OUTERWEAR [empty string] 0 114415 531431 98 NF0A2VD3
79 135123 47512 10-OUTERWEAR [empty string] 0 114416 531432 98 NF0A2VD3
80 135123 47512 10-OUTERWEAR [empty string] 0 114417 531433 98 NF0A2VD3
CACHED false
EXECUTIONTIME 6
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 = 'NF0A2VD3' ) 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 = 47512 AND isNull(b.sell_web,'Y') = 'Y' GROUP BY b.sku_id ORDER BY b.sku_id
SQLPARAMETERS
array
1 107037
115
Add to Cart Find in Store Add to Wish List

product description

Constructed with waterproof, breathable, seam-sealed DryVent 2.5L fabric, The North Face Men's Venture 2 Jacket is a classic year-round jacket that is designed to withstand backcountry storms and is styled for everyday use.

product specs
  • Waterproof, breathable, seam-sealed DryVent shell
  • 100% windproof fabric
  • Relaxed fit
  • Adjustable hood
  • Velcro stormflap covers front zipper
  • Pit-zip venting for added breathability
  • Covered, secure-zip hand pockets
  • Velcro® adjustable cuff tabs
  • Hem cinch-cord
  • Packs into its own pocket
  • Weight: 330g (11.6oz)
  • Center back: 29in
  • Materials:
  • Solid: 40D 85 g/m² DryVent 2.5L - 100% nylon ripstop
  • Heather: 70D 161 g/m² DryVent 2.5L - 62% nylon, 38% polyester
  • Ripstop heather: 70D 144 G/M² DryVent 2.5L—72% Nylon, 28% Polyester Ripstop
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>Waterproof, breathable, seam-sealed DryVent shell</li> <li>100% windproof fabric</li> <li>Relaxed fit</li> <li>Adjustable hood</li> <li>Velcro&nbsp;stormflap covers front zipper</li> <li>Pit-zip venting for added breathability</li> <li>Covered, secure-zip hand pockets</li> <li>Velcro&reg; adjustable cuff tabs</li> <li>Hem cinch-cord</li> <li>Packs into its own pocket</li> <li>Weight: 330g (11.6oz)</li> <li>Center back: 29in</li> <li>Materials:</li> <li>Solid: 40D 85 g/m&sup2; DryVent 2.5L - 100% nylon ripstop</li> <li>Heather: 70D 161 g/m&sup2; DryVent 2.5L - 62% nylon, 38% polyester</li> <li>Ripstop heather: 70D 144 G/M&sup2; DryVent&nbsp;2.5L&mdash;72% Nylon, 28% Polyester Ripstop</li> </ul> [empty string] [empty string] 61187 URBANNVY_H2G,DRKGRY_DYZ,BLACK_KX7,AYJ_LEAFGRY, 47490 THE NORTH FACE The North Face CLOTHING & FOOTWEAR Clothing & Footwear &gt Men's &gt Outerwear &gt Rainwear [empty string] [empty string] [empty string] 596 [empty string] 27307934 [empty string] 99 78 78.99 northface, thenorthface 13245-DEFAULT-l.jpg 99 [empty string] 13245-DEFAULT-m.jpg Be prepared for backcountry storms as well as everyday urban exploration. The North Face Men's Venture 2 Jacket protects with waterproof, breathable, seam-sealed fabric plus style and versatility for year-round wear. [empty string] M/VENTURE 2 JACKET N NEWATTR [empty string] [empty string] [empty string] [empty string] BTSTFW [empty string] [empty string] LANYARD [empty string] ACTIVE A 10A [empty string] [empty string] FALL_3 [empty string] [empty string] [empty string] N NORTH FACE 110 0 [empty string] 13245 13245 50-to-100 0.00 0 [empty string] [empty string] [empty string] The North Face Men's Venture 2 Jacket <p>Constructed with waterproof, breathable, seam-sealed DryVent 2.5L fabric, The North Face Men&#39;s Venture 2 Jacket is a classic year-round jacket that is designed to withstand backcountry storms and is styled for everyday use.</p> [empty string] Y 78.99 99 40042 0 L,M,S,XL,XXL, [empty string] 13245-DEFAULT-s.jpg 1000 NF0A2VD3 107037 OUTERWEAR RAINWEAR EMPTY 0 [empty string] [empty string] 13245-DEFAULT-xs.jpg MENS shop/the-north-face-mens-venture-2--107037 0 [empty string] NF0A2VD3 [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='107037' order by ID desc