PRANA

prAna Men's PrAna V-Neck T-Shirt

$19.99 to $29.00

Item # M1VNEK114

query
RESULTSET
query
  ORIGSIZ QOH SCALE_ENTRY_ID SIZ SIZE_ORDER SKU_ID STYLE_ID
1 S 4 119788 S [empty string] 493082 109351
2 M 23 119789 M [empty string] 529636 109351
3 L 22 119790 L [empty string] 529637 109351
4 XL 5 119791 XL [empty string] 529638 109351
5 XXL 2 119792 XXL [empty string] 510824 109351
CACHED false
EXECUTIONTIME 406
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 M1VNEK114
2 109351
query
RESULTSET
query
  ATTR1 ATTR1_ALIAS ATTR1_ENTRY_ID FAM HEX ORIGATTR1 QOH SIZE SKU_ID SORT_ORDER STYLE_ID
1 MAPLEHTHR [empty string] 134560 [empty string] [empty string] MAPLEHTHR 16 119791 529638 [empty string] 109351
2 Marigold Marigold 134554 [empty string] [empty string] MARIGOLD 16 119791 475798 [empty string] 109351
3 Denim Heather Denim Heather 134553 [empty string] [empty string] DENIMHTHR 15 119790 475792 [empty string] 109351
4 KOIHTHR [empty string] 134559 [empty string] [empty string] KOIHTHR 3 119790 510832 [empty string] 109351
5 AGAVEHTHR [empty string] 134557 [empty string] [empty string] AGAVEHTHR 2 119792 510824 [empty string] 109351
6 Charcoal Charcoal 134550 [empty string] [empty string] CHARCOAL 2 119789 430783 [empty string] 109351
7 Mulled Wine Mulled Wine 134556 [empty string] [empty string] MULLEDWINE 2 119788 493082 [empty string] 109351
CACHED false
EXECUTIONTIME 0
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 109351
prAna Men's PrAna V-Neck T-Shirt MAPLEHTHR prAna Men's PrAna V-Neck T-Shirt MARIGOLD prAna Men's PrAna V-Neck T-Shirt DENIMHTHR prAna Men's PrAna V-Neck T-Shirt KOIHTHR prAna Men's PrAna V-Neck T-Shirt AGAVEHTHR prAna Men's PrAna V-Neck T-Shirt CHARCOAL prAna Men's PrAna V-Neck T-Shirt MULLEDWINE
S M L XL XXL
query
RESULTSET
query
  ATTR1_ENTRY_ID ATTR2_ENTRY_ID DEPT PURCHASE_AMOUNT QOH SCALE_ENTRY_ID SKU_ID STORE_ID STYLE
1 134548 49290 71-M/S SPORTSWEAR [empty string] 0 119788 430778 98 M1VNEK114
2 134549 49290 71-M/S SPORTSWEAR [empty string] 0 119788 430779 98 M1VNEK114
3 134550 49290 71-M/S SPORTSWEAR [empty string] 0 119788 430780 98 M1VNEK114
4 134548 49290 71-M/S SPORTSWEAR [empty string] 0 119789 430781 98 M1VNEK114
5 134549 49290 71-M/S SPORTSWEAR [empty string] 0 119789 430782 98 M1VNEK114
6 134550 49290 71-M/S SPORTSWEAR [empty string] 2 119789 430783 98 M1VNEK114
7 134548 49290 71-M/S SPORTSWEAR [empty string] 0 119790 430784 98 M1VNEK114
8 134549 49290 71-M/S SPORTSWEAR [empty string] 0 119790 430785 98 M1VNEK114
9 134550 49290 71-M/S SPORTSWEAR [empty string] 0 119790 430786 98 M1VNEK114
10 134548 49290 71-M/S SPORTSWEAR [empty string] 0 119791 430787 98 M1VNEK114
11 134549 49290 71-M/S SPORTSWEAR [empty string] 0 119791 430788 98 M1VNEK114
12 134550 49290 71-M/S SPORTSWEAR [empty string] 1 119791 430789 98 M1VNEK114
13 134548 49290 71-M/S SPORTSWEAR [empty string] 0 119792 430790 98 M1VNEK114
14 134549 49290 71-M/S SPORTSWEAR [empty string] 0 119792 430791 98 M1VNEK114
15 134550 49290 71-M/S SPORTSWEAR [empty string] 0 119792 430792 98 M1VNEK114
16 134551 49290 71-M/S SPORTSWEAR [empty string] 1 119788 445958 98 M1VNEK114
17 134551 49290 71-M/S SPORTSWEAR [empty string] 1 119789 445959 98 M1VNEK114
18 134551 49290 71-M/S SPORTSWEAR [empty string] 0 119790 445960 98 M1VNEK114
19 134551 49290 71-M/S SPORTSWEAR [empty string] 0 119791 445961 98 M1VNEK114
20 134551 49290 71-M/S SPORTSWEAR [empty string] 0 119792 445962 98 M1VNEK114
21 134552 49290 71-M/S SPORTSWEAR [empty string] 0 119788 445963 98 M1VNEK114
22 134552 49290 71-M/S SPORTSWEAR [empty string] 0 119789 445964 98 M1VNEK114
23 134552 49290 71-M/S SPORTSWEAR [empty string] 0 119790 445965 98 M1VNEK114
24 134552 49290 71-M/S SPORTSWEAR [empty string] 0 119791 445966 98 M1VNEK114
25 134552 49290 71-M/S SPORTSWEAR [empty string] 0 119792 445967 98 M1VNEK114
26 134553 49290 71-M/S SPORTSWEAR [empty string] 2 119788 475790 98 M1VNEK114
27 134553 49290 71-M/S SPORTSWEAR [empty string] 7 119789 475791 98 M1VNEK114
28 134553 49290 71-M/S SPORTSWEAR [empty string] 6 119790 475792 98 M1VNEK114
29 134553 49290 71-M/S SPORTSWEAR [empty string] 1 119791 475793 98 M1VNEK114
30 134553 49290 71-M/S SPORTSWEAR [empty string] 0 119792 475794 98 M1VNEK114
31 134554 49290 71-M/S SPORTSWEAR [empty string] 1 119788 475795 98 M1VNEK114
32 134554 49290 71-M/S SPORTSWEAR [empty string] 7 119789 475796 98 M1VNEK114
33 134554 49290 71-M/S SPORTSWEAR [empty string] 7 119790 475797 98 M1VNEK114
34 134554 49290 71-M/S SPORTSWEAR [empty string] 2 119791 475798 98 M1VNEK114
35 134554 49290 71-M/S SPORTSWEAR [empty string] 0 119792 475799 98 M1VNEK114
36 134555 49290 71-M/S SPORTSWEAR [empty string] 0 119788 475800 98 M1VNEK114
37 134555 49290 71-M/S SPORTSWEAR [empty string] 0 119789 475801 98 M1VNEK114
38 134555 49290 71-M/S SPORTSWEAR [empty string] 0 119790 475802 98 M1VNEK114
39 134555 49290 71-M/S SPORTSWEAR [empty string] 0 119791 475803 98 M1VNEK114
40 134555 49290 71-M/S SPORTSWEAR [empty string] 0 119792 475804 98 M1VNEK114
41 134556 49290 71-M/S SPORTSWEAR [empty string] 2 119788 493082 98 M1VNEK114
42 134556 49290 71-M/S SPORTSWEAR [empty string] 0 119789 493083 98 M1VNEK114
43 134556 49290 71-M/S SPORTSWEAR [empty string] 0 119790 493084 98 M1VNEK114
44 134556 49290 71-M/S SPORTSWEAR [empty string] 0 119791 493085 98 M1VNEK114
45 134556 49290 71-M/S SPORTSWEAR [empty string] 0 119792 493086 98 M1VNEK114
46 134557 49290 71-M/S SPORTSWEAR [empty string] 1 119788 510820 98 M1VNEK114
47 134557 49290 71-M/S SPORTSWEAR [empty string] 0 119789 510821 98 M1VNEK114
48 134557 49290 71-M/S SPORTSWEAR [empty string] 0 119790 510822 98 M1VNEK114
49 134557 49290 71-M/S SPORTSWEAR [empty string] 0 119791 510823 98 M1VNEK114
50 134557 49290 71-M/S SPORTSWEAR [empty string] 2 119792 510824 98 M1VNEK114
51 134558 49290 71-M/S SPORTSWEAR [empty string] 1 119788 510825 98 M1VNEK114
52 134558 49290 71-M/S SPORTSWEAR [empty string] 0 119789 510826 98 M1VNEK114
53 134558 49290 71-M/S SPORTSWEAR [empty string] 0 119790 510827 98 M1VNEK114
54 134558 49290 71-M/S SPORTSWEAR [empty string] 0 119791 510828 98 M1VNEK114
55 134558 49290 71-M/S SPORTSWEAR [empty string] 1 119792 510829 98 M1VNEK114
56 134559 49290 71-M/S SPORTSWEAR [empty string] 1 119788 510830 98 M1VNEK114
57 134559 49290 71-M/S SPORTSWEAR [empty string] 0 119789 510831 98 M1VNEK114
58 134559 49290 71-M/S SPORTSWEAR [empty string] 3 119790 510832 98 M1VNEK114
59 134559 49290 71-M/S SPORTSWEAR [empty string] 1 119791 510833 98 M1VNEK114
60 134559 49290 71-M/S SPORTSWEAR [empty string] 1 119792 510834 98 M1VNEK114
61 134560 49290 71-M/S SPORTSWEAR [empty string] 1 119788 529635 98 M1VNEK114
62 134560 49290 71-M/S SPORTSWEAR [empty string] 7 119789 529636 98 M1VNEK114
63 134560 49290 71-M/S SPORTSWEAR [empty string] 6 119790 529637 98 M1VNEK114
64 134560 49290 71-M/S SPORTSWEAR [empty string] 3 119791 529638 98 M1VNEK114
65 134560 49290 71-M/S SPORTSWEAR [empty string] 1 119792 529639 98 M1VNEK114
CACHED false
EXECUTIONTIME 31
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 = 'M1VNEK114' ) 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 = 49290 AND isNull(b.sell_web,'Y') = 'Y' GROUP BY b.sku_id ORDER BY b.sku_id
SQLPARAMETERS
array
1 109351
69
Add to Cart Find in Store Add to Wish List

product description The prAna Men's PrAna V-Neck T-Shirt is a lightweight basic for everyday wear when it's warm and a base layer as it cools. This Fair Trade Factory Certified tee is cut for a standard fit.
product specs
  • Lightweight cotton jersey
  • V-neck
  • Woven label on wearer's left sleeve
  • Standard fit
  • 60% Organic Cotton / 40% Recycled Polyester
  • Fair Trade Factory Certified
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>Lightweight cotton jersey</li> <li>V-neck</li> <li>Woven label on wearer&#39;s left sleeve</li> <li>Standard fit</li> <li>60% Organic Cotton / 40% Recycled Polyester</li> <li>Fair Trade Factory Certified</li> [empty string] [empty string] 61004 MARIGOLD,MAPLEHTHR,DENIMHTHR,KOIHTHR,AGAVEHTHR,CHARCOAL,MULLEDWINE, 49268 PRANA PRANA CLOTHING & FOOTWEAR Clothing & Footwear &gt Men's &gt Tops [empty string] [empty string] [empty string] 212 [empty string] 27426338 [empty string] 29 19 19.99 [empty string] 14607-DEFAULT-l.jpg 29 [empty string] 14607-DEFAULT-m.jpg Get a comfy tee for your day-to-day rotation. The prAna Men's PrAna V-Neck T-Shirt is a lightweight basic that's Fair Trade Factory Certified. [empty string] M/Prana V-Neck N NEWATTR [empty string] [empty string] [empty string] [empty string] BTSTFW [empty string] [empty string] PIN [empty string] [empty string] A 71B [empty string] [empty string] FALL_3 [empty string] [empty string] [empty string] N PRANA 54 0 [empty string] 14607 14607 15-to-20 0.00 0 [empty string] [empty string] [empty string] prAna Men's PrAna V-Neck T-Shirt The prAna Men&#39;s PrAna V-Neck T-Shirt is a lightweight basic for everyday wear when it&#39;s warm and a base layer as it cools. This Fair Trade Factory Certified tee is cut for a standard fit. [empty string] Y 19.99 29 41780 0 L,M,S,XL,XXL, [empty string] 14607-DEFAULT-s.jpg 1000 M1VNEK114 109351 TOPS EMPTY EMPTY 0 [empty string] [empty string] 14607-DEFAULT-xs.jpg MENS shop/prana-mens-prana-v-neck-t-shir-109351 0 [empty string] M1VNEK114 [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 0
SQL SELECT * from [dbo].[web_all_products] WHERE style_id='109351' order by ID desc