exofficio

ExOfficio Men's BugsAway Sandfly Jacket

$59.99 to $80.00

Item # 1111-2005

query
RESULTSET
query
  ORIGSIZ QOH SCALE_ENTRY_ID SIZ SIZE_ORDER SKU_ID STYLE_ID
1 M 12 101577 M [empty string] 507195 100141
2 L 8 101578 L [empty string] 507196 100141
3 XL 11 101579 XL [empty string] 507197 100141
4 XXL 2 101580 XXL [empty string] 507198 100141
CACHED false
EXECUTIONTIME 391
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 1111-2005
2 100141
query
RESULTSET
query
  ATTR1 ATTR1_ALIAS ATTR1_ENTRY_ID FAM HEX ORIGATTR1 QOH SIZE SKU_ID SORT_ORDER STYLE_ID
1 Scotch Scotch 127870 [empty string] [empty string] SCOTCH 13 101580 507198 [empty string] 100141
2 Walnut Walnut 127867 [empty string] [empty string] WALNUT 10 101579 386409 [empty string] 100141
3 Dark Pebble Dark Pebble 127868 [empty string] [empty string] DKPEBBLE 10 101579 422672 [empty string] 100141
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 100141
ExOfficio Men's BugsAway Sandfly Jacket SCOTCH ExOfficio Men's BugsAway Sandfly Jacket WALNUT ExOfficio Men's BugsAway Sandfly Jacket DKPEBBLE
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 127867 41820 71-M/S SPORTSWEAR [empty string] 0 101576 386406 98 1111-2005
2 127867 41820 71-M/S SPORTSWEAR [empty string] 3 101577 386407 98 1111-2005
3 127867 41820 71-M/S SPORTSWEAR [empty string] 5 101578 386408 98 1111-2005
4 127867 41820 71-M/S SPORTSWEAR [empty string] 2 101579 386409 98 1111-2005
5 127867 41820 71-M/S SPORTSWEAR [empty string] 0 101580 386410 98 1111-2005
6 127868 41820 71-M/S SPORTSWEAR [empty string] 1 101576 422669 98 1111-2005
7 127868 41820 71-M/S SPORTSWEAR [empty string] 6 101577 422670 98 1111-2005
8 127868 41820 71-M/S SPORTSWEAR [empty string] 1 101578 422671 98 1111-2005
9 127868 41820 71-M/S SPORTSWEAR [empty string] 4 101579 422672 98 1111-2005
10 127868 41820 71-M/S SPORTSWEAR [empty string] 0 101580 422673 98 1111-2005
11 127869 41820 71-M/S SPORTSWEAR [empty string] 0 101576 468299 98 1111-2005
12 127869 41820 71-M/S SPORTSWEAR [empty string] 0 101577 468300 98 1111-2005
13 127869 41820 71-M/S SPORTSWEAR [empty string] 0 101578 468301 98 1111-2005
14 127869 41820 71-M/S SPORTSWEAR [empty string] 1 101579 468302 98 1111-2005
15 127869 41820 71-M/S SPORTSWEAR [empty string] 0 101580 468303 98 1111-2005
16 127870 41820 71-M/S SPORTSWEAR [empty string] 0 101576 507194 98 1111-2005
17 127870 41820 71-M/S SPORTSWEAR [empty string] 3 101577 507195 98 1111-2005
18 127870 41820 71-M/S SPORTSWEAR [empty string] 3 101578 507196 98 1111-2005
19 127870 41820 71-M/S SPORTSWEAR [empty string] 5 101579 507197 98 1111-2005
20 127870 41820 71-M/S SPORTSWEAR [empty string] 2 101580 507198 98 1111-2005
CACHED false
EXECUTIONTIME 63
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 = '1111-2005' ) 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 = 41820 AND isNull(b.sell_web,'Y') = 'Y' GROUP BY b.sku_id ORDER BY b.sku_id
SQLPARAMETERS
array
1 100141
36
Add to Cart Find in Store Add to Wish List

product description

Keep airborne antagonists and crawling critters at bay with the ExOfficio Men's BugsAway Sandfly Jacket. Constructed with UPF 30, Insect Shield® fabric, you'll repel a variety of vermin along with the harmful rays of the sun. An adjustable, peripheral vision hood, elastic binding at the cuffs and cinch cord at the hem, insures defense against the lower end of the food chain. Reinforced panels at the shoulders, sides and center prevent unnecessary abrasion from backpack or camera straps. Lightweight and thin enough to stuff in its own front security pocket, you'll always have room for this winner.

product specs
  • Fabric: 100% nylon, 100% polyester
  • Weight: 7.8oz
  • Natural fit
  • Mesh body with woven paneling
  • Packable security zip pocket on left front
  • BugsAway® Insect Shield® uses permethrin to repel unwanted pests. Treatment lasts for 70 washings

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>Fabric: 100% nylon, 100% polyester</li> <li>Weight: 7.8oz</li> <li>Natural fit</li> <li>Mesh body with woven paneling</li> <li>Packable security zip pocket on left front</li> <li>BugsAway&reg; Insect Shield&reg; uses permethrin to repel unwanted pests. Treatment lasts for 70 washings</li> </ul> [empty string] [empty string] 58759 SCOTCH,WALNUT,DKPEBBLE, 41797 EXOFFICIO exofficio DISCOVER Discover &gt Gifts For &gt Summer Travel [empty string] [empty string] [empty string] 596 [empty string] 27432573 [empty string] 80 59 59.99 [empty string] 13407-DEFAULT-l.jpg 80 [empty string] 13407-DEFAULT-m.jpg Keep airborne antagonists and crawling critters at bay with the ExOfficio Men's BugsAway Sandfly Jacket. [empty string] M/ BugsAway Sandfly Jacket N NEWATTR [empty string] [empty string] [empty string] [empty string] BTSTFW [empty string] [empty string] LANYARD [empty string] [empty string] A 71J [empty string] [empty string] FALL_3 [empty string] [empty string] [empty string] [empty string] EX OFFICIO 32 0 [empty string] 13407 13407 50-to-100 0.00 0 [empty string] [empty string] [empty string] ExOfficio Men's BugsAway Sandfly Jacket <p>Keep airborne antagonists and crawling critters at bay with the ExOfficio Men&#39;s BugsAway Sandfly Jacket. Constructed with UPF 30, Insect Shield&reg; fabric, you&#39;ll repel a variety of vermin along with the harmful rays of the sun. An adjustable, peripheral vision hood, elastic binding at the cuffs and cinch cord at the hem, insures defense against the lower end of the food chain. Reinforced panels at the shoulders, sides and center prevent unnecessary abrasion from backpack or camera straps. Lightweight and thin enough to stuff in its own front security pocket, you&#39;ll always have room for this winner.</p> [empty string] Y 59.99 80 35148 0 L,M,XL,XXL, [empty string] 13407-DEFAULT-s.jpg 21 1111-2005 100141 SUMMER TRAVEL EMPTY EMPTY 0 [empty string] [empty string] 13407-DEFAULT-xs.jpg GIFTS FOR shop/exofficio-mens-bugsaway-sandfl-100141 0 [empty string] 1111-2005 [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 16
SQL SELECT * from [dbo].[web_all_products] WHERE style_id='100141' order by ID desc