PATAGONIA

Patagonia Tech Web Belt

$19.99 to $29.00

Item # 59193

query
RESULTSET
query
  ORIGSIZ QOH SCALE_ENTRY_ID SIZ SIZE_ORDER SKU_ID STYLE_ID
1 ONE 141 114394 One Size [empty string] 519237 107024
CACHED false
EXECUTIONTIME 374
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 59193
2 107024
query
RESULTSET
query
  ATTR1 ATTR1_ALIAS ATTR1_ENTRY_ID FAM HEX ORIGATTR1 QOH SIZE SKU_ID SORT_ORDER STYLE_ID
1 Black Black 137446 [empty string] [empty string] BLK 50 114394 419488 [empty string] 107024
2 LDBR [empty string] 137464 [empty string] [empty string] LDBR 28 114394 519237 [empty string] 107024
3 Forge Grey Forge Grey 137448 [empty string] [empty string] FGE 20 114394 419490 [empty string] 107024
4 Dolomite Blue Dolomite Blue 137457 [empty string] [empty string] DLMB 12 114394 465039 [empty string] 107024
5 ASHT [empty string] 137461 [empty string] [empty string] ASHT 11 114394 499343 [empty string] 107024
6 CAN [empty string] 137463 [empty string] [empty string] CAN 10 114394 519236 [empty string] 107024
7 Tasmanian Teal Tasmanian Teal 137462 [empty string] [empty string] TATE 10 114394 499344 [empty string] 107024
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 107024
Patagonia Tech Web Belt BLK Patagonia Tech Web Belt LDBR Patagonia Tech Web Belt FGE Patagonia Tech Web Belt DLMB Patagonia Tech Web Belt ASHT Patagonia Tech Web Belt CAN Patagonia Tech Web Belt TATE
One Size
query
RESULTSET
query
  ATTR1_ENTRY_ID ATTR2_ENTRY_ID DEPT PURCHASE_AMOUNT QOH SCALE_ENTRY_ID SKU_ID STORE_ID STYLE
1 137446 47497 51-CLOTHING ACC. [empty string] 50 114394 419488 98 59193
2 137447 47497 51-CLOTHING ACC. [empty string] 0 114394 419489 98 59193
3 137448 47497 51-CLOTHING ACC. [empty string] 20 114394 419490 98 59193
4 137449 47497 51-CLOTHING ACC. [empty string] 0 114394 419491 98 59193
5 137450 47497 51-CLOTHING ACC. [empty string] 0 114394 419492 98 59193
6 137451 47497 51-CLOTHING ACC. [empty string] 0 114394 419493 98 59193
7 137452 47497 51-CLOTHING ACC. [empty string] 0 114394 432070 98 59193
8 137453 47497 51-CLOTHING ACC. [empty string] -1 114394 432071 98 59193
9 137454 47497 51-CLOTHING ACC. [empty string] 0 114394 432072 98 59193
10 137455 47497 51-CLOTHING ACC. [empty string] 0 114394 435790 98 59193
11 137456 47497 51-CLOTHING ACC. [empty string] 0 114394 435791 98 59193
12 137457 47497 51-CLOTHING ACC. [empty string] 12 114394 465039 98 59193
13 137458 47497 51-CLOTHING ACC. [empty string] 0 114394 465040 98 59193
14 137459 47497 51-CLOTHING ACC. [empty string] 0 114394 484283 98 59193
15 137460 47497 51-CLOTHING ACC. [empty string] 0 114394 484284 98 59193
16 137461 47497 51-CLOTHING ACC. [empty string] 11 114394 499343 98 59193
17 137462 47497 51-CLOTHING ACC. [empty string] 10 114394 499344 98 59193
18 137463 47497 51-CLOTHING ACC. [empty string] 10 114394 519236 98 59193
19 137464 47497 51-CLOTHING ACC. [empty string] 28 114394 519237 98 59193
20 137465 47497 51-CLOTHING ACC. [empty string] 0 114394 538638 98 59193
21 137466 47497 51-CLOTHING ACC. [empty string] 0 114394 538639 98 59193
CACHED false
EXECUTIONTIME 2
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 = '59193' ) 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 = 47497 and b.scale_entry_id = 114394 AND isNull(b.sell_web,'Y') = 'Y' GROUP BY b.sku_id ORDER BY b.sku_id
SQLPARAMETERS
array
1 107024
140
Add to Cart Find in Store Add to Wish List

product description

Forged from the burly demands of holding up your pants, the Patagonia Tech Web Belt is a lightweight belt built to tackle the rigors of your waistline. Made from 1½ inch polyester webbing with an aluminum buckle, this multifunctional belt can double as a lash strap or a bottle opener. Strong and reliable, the fit of your pants will never hold you back when you strap on this belt on your way to your next adventure.

product specs
  • Strong and quick-drying 1½in polyester webbing doubles as an emergency lash strap
  • Forged aluminum buckle is tough, lightweight and notched to pry off a bottle cap
  • Belt length: 46.5in
  • 1½in polyester webbing with a forged aluminum buckle
  • Made in Philippines
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>Strong and quick-drying 1&frac12;in polyester webbing doubles as an emergency lash strap</li> <li>Forged aluminum buckle is tough, lightweight and notched to pry off a bottle cap</li> <li>Belt length: 46.5in</li> <li>1&frac12;in polyester webbing with a forged aluminum buckle</li> <li>Made in Philippines</li> </ul> [empty string] [empty string] 61957 BLK,LDBR,FGE,DLMB,ASHT,CAN,TATE, 47475 PATAGONIA PATAGONIA CLOTHING & FOOTWEAR Clothing & Footwear &gt Women's &gt Hats & Accessories [empty string] [empty string] [empty string] 169 [empty string] 27390524 [empty string] 29 19 19.99 webbing, accessories 12756-DEFAULT-l.jpg 29 [empty string] 12756-DEFAULT-m.jpg Secure your pants with the lightweight Patagonia Tech Web Belt. Built to tackle the rigors of your waistline, it's made from polyester webbing with an aluminum buckle, and can double as a lash strap or a bottle opener. [empty string] TECH WEB BELT N SPRINGNEWATTR [empty string] [empty string] [empty string] [empty string] BTSTFW [empty string] [empty string] [empty string] [empty string] [empty string] A 51A [empty string] [empty string] FALL_3 [empty string] [empty string] [empty string] N PATAGONIA 140 0 [empty string] 12756 12756 15-to-20 0.00 0 [empty string] [empty string] [empty string] Patagonia Tech Web Belt <p>Forged from the burly demands of holding up your pants, the Patagonia Tech Web Belt is a lightweight belt built to tackle the rigors of your waistline. Made from 1&frac12; inch polyester webbing with an aluminum buckle, this multifunctional belt can double as a lash strap or a bottle opener. Strong and reliable, the fit of your pants will never hold you back when you strap on this belt on your way to your next adventure.</p> [empty string] Y 19.99 29 40038 0 One Size, [empty string] 12756-DEFAULT-s.jpg 1000 59193 107024 HATS & ACCESSORIES EMPTY EMPTY 0 [empty string] [empty string] 12756-DEFAULT-xs.jpg WOMENS shop/patagonia-tech-web-belt-107024 0 [empty string] 59193 [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='107024' order by ID desc