WOMEN'S INQUIRE MID

No 64531

Be the first to review!

$159.95

Choose Color

query
	ATTR1	ATTR1_ENTRY_ID	FAM	HEX	MAXQC	MAXQOH	MINQC	MINQOH	ORIGATTR1	QOH	SELL_WEB	SKUOF16	SKU_ID	SORT_ORDER	STYLE_ID
1	GRAY,ORANGE	105638	[empty string]	[empty string]	0	1	0	0	DARKGREY_SALMON	27	Y	[empty string]	880883	[empty string]	185339

SELECT distinct (b.attr1) as origAttr1, 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+e.qc) as qoh , max(b.attr1_order) as sort_order, max(c.attr1_hex) as hex,max(d.attr1_fam) as fam,max(a.SKU_OF16) as skuOF16,max(e.qoh) as maxqoh,max(e.qc) as maxqc,min(e.qoh) as minqoh,min(e.qc) as minqc,max(a.style_id) as style_id,max(a.sell_web) as sell_web FROM tb_skus a with (nolock) inner join (select distinct sku_id as sku_id from TB_SKU_BUCKETS with (nolock) where 1=1 and store_id in (11,5,8,6,9,14,15,7,2,1,3,97) group by sku_id having sum(qoh+qc) >=1) skuqoh on (skuqoh.sku_id=a.sku_id) LEFT JOIN tb_attr1_entries b WITH (NOLOCK) ON (b.attr1_entry_id = a.attr1_entry_id) LEFT JOIN tb_sku_buckets e WITH (NOLOCK) ON (e.sku_id = a.sku_id) LEFT JOIN tb_attr1_hexes c WITH (NOLOCK) ON (b.attr1=c.attr1) LEFT JOIN tb_attr1_families d WITH (NOLOCK) ON (c.attr1_fam_id = d.attr1_fam_id) WHERE (a.sell_web in ('Y','YES') ) and a.style_id=? AND e.store_id in(11,5,8,6,9,14,15,7,2,1,3,97) GROUP BY b.attr1 HAVING sum(e.qoh+e.qc) >= 1 ORDER BY max(b.attr1_order), max(b.attr1_entry_id)

SQLPARAMETERS

array
1	185339

struct
INTERNALLISTPRICE	159.95
INTERNALMARKDOWN	false
INTERNALPRICE	159.95
REG	159.95
SALE	159.95
TERMSALE	false
TERMSALELISTPRICE	0
TERMSALEPRICE	0

CHOOSE Size

Size

One

Qty

Check Store Availability

Add to Basket

Please login or create an account to save this product to your wish list.

Description
Specs
Reviews
Live Chat

They check off all the boxes!

How will they handle steep inclines, rocky terrain, or creek crossings? These are just a few of the questions we ask ourselves before settling on a pair of hiking boots. Well, the Women's Inquire Mid from Danner wants to answer all your questions—and then some. Wrapped in a durable upper, lined with waterproof Danner Dry technology, and filled with a supportive OrthoLite footbed, your toes are sure to keep dry, cushioned, and happy as you rack up the miles. Whether you're heading up to the summit or down into the valley, the Vibram Inquire provides traction and stability along the way.

Danner Trailguard - Lightweight, seamless support with a roomier fit in the toe box and snug fit in the heel
Danner Dry - 100% waterproof barrier allows moisture to escape without letting water in, keeping your feet dry and comfortable all day long.
Upper: Suede & textile - Danner combines a durable suede with a lightweight textile to create an upper with modern performance and timeless Danner® durability
Footbed: Removable OrthoLite footbed - Three layers of varying density are combined for maximum cushioning and support; The entire footbed is made of open-cell polyurethane for better heat dissipation and air circulation
Midsole: Danner® Plyolite® midsole offers lightweight comfort and shock absorption
Outsole: Vibram® Inquire outsole - This exclusive outsole features multi-directional lugs and a split heel for adaptive traction with Vibram’s Megagrip compound for incredible grip on wet and dry surfaces
Height: 5 inches
Average weight (per pair): 29 ounces

No Reviews Yet!

Spill the Beans

Headline Name Email Overall Rating

Review

We want to make sure you know: All reviews become the property of Mast General Store. Your review requires staff approval before posting. See our Terms of Use for details.

Description

How will they handle steep inclines, rocky terrain, or creek crossings? These are just a few of the questions we ask ourselves before settling on a pair of hiking boots. Well, the Women's Inquire Mid from Danner wants to answer all your questions—and then some. Wrapped in a durable upper, lined with waterproof Danner Dry technology, and filled with a supportive OrthoLite footbed, your toes are sure to keep dry, cushioned, and happy as you rack up the miles. Whether you're heading up to the summit or down into the valley, the Vibram Inquire provides traction and stability along the way.
Specs
- Danner Trailguard - Lightweight, seamless support with a roomier fit in the toe box and snug fit in the heel
- Danner Dry - 100% waterproof barrier allows moisture to escape without letting water in, keeping your feet dry and comfortable all day long.
- Upper: Suede & textile - Danner combines a durable suede with a lightweight textile to create an upper with modern performance and timeless Danner® durability
- Footbed: Removable OrthoLite footbed - Three layers of varying density are combined for maximum cushioning and support; The entire footbed is made of open-cell polyurethane for better heat dissipation and air circulation
- Midsole: Danner® Plyolite® midsole offers lightweight comfort and shock absorption
- Outsole: Vibram® Inquire outsole - This exclusive outsole features multi-directional lugs and a split heel for adaptive traction with Vibram’s Megagrip compound for incredible grip on wet and dry surfaces
- Height: 5 inches
- Average weight (per pair): 29 ounces
Reviews

No Reviews Yet!
Live Chat

WOMEN'S INQUIRE MID

$159.95

Choose Color

CHOOSE Size

One

Qty

Spill the Beans

You may also like