Women's Nike Air Zoom Pegasus 36

Style: AQ2210

Brand: nike

$120.00 $90.00

query

RESULTSET

query
	ATTR1	ATTR1_ENTRY_ID	FAM	HEX	NON_INVT	ORIGATTR1	QOH	SKU_ID	SORT_ORDER
1	LASER_CRIMSON/WHITE/PLATINUM	53409	[empty string]	[empty string]	N	LCWPT	0	519766	[empty string]
2	BLACK/METALLIC_GOLD/WHITE	53410	[empty string]	[empty string]	N	BKMGW	0	506270	0
3	BLACK/WHITE/THUNDER GRAY	53411	[empty string]	[empty string]	N	BWHTG	2	506286	0
4	GUNSMOKE/OIL_GRAY/WHITE	53412	[empty string]	[empty string]	N	GSOGW	0	506302	0
5	HYPER_PINK/BLACK/HALF_BLUE	53413	[empty string]	[empty string]	N	HPBHB	0	506318	0
6	OCEAN_CUBE/METALLIC_COOL_GRAY	53414	[empty string]	[empty string]	N	OCMCG	0	506334	0
7	PLATINUM_TINT/PURPLE_AGATE	53415	[empty string]	[empty string]	N	PTPA	0	506350	0
8	PUMICE/PINK_QUARTZ	53416	[empty string]	[empty string]	N	PUMICE/PINK_QUARTZ	0	506366	0

CACHED

false

EXECUTIONTIME

SQL

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(z.non_invt) as non_invt FROM tb_skus a 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) LEFT JOIN tb_styles z on (z.style_id = a.style_id) WHERE (a.sell_web not in ('N','NO') or (a.sell_web is null)) and a.style_id=? AND e.store_id in(1,2,3) GROUP BY b.attr1 ORDER BY max(b.attr1_order), max(b.attr1_entry_id)

SQLPARAMETERS

array
1	37015

Colors:

Size: 5 5.5 6 6.5 7 7.5 8 8.5 9 9.5 10 10.5 11 11.5 12 13

Width REGULAR

description
shipping & returns

Nike Air Zoom Pegasus 36
Women's Running Shoe
AN ICON GETS SLIMMER AND COOLER.
The iconic Nike Air Zoom Pegasus 36 returns with more perforations and engineered mesh in the upper for targeted breathability across high-heat areas. A slimmer heel collar and tongue reduce bulk without compromising comfort, while exposed Flywire cables give you a snug fit at higher speeds.

Perforations on upper enhance breathability in forefoot and arch.
Full-length Zoom Air unit provides a smooth, responsive ride.
Slimmer design reduces bulk for a comfortable, conforming fit.
Exposed Flywire cables in the midfoot promote a snug fit at higher speeds.
Cushlon ST foam provides soft, responsive cushioning.
High resiliency sockliner adapts to the contour of your foot for support.
Waffle pistons on outsole help absorb impact and provide multi-surface traction.
Reduced tongue weight from the Pegasus 35 conforms to your foot.
Heel collar tapers away around the Achilles tendon.

Shipping

We offer free standard shipping on all orders $50+ and a flat rate on all orders under that amount. Expedited shipping is available in checkout for a shipping premium.

Returns

Any unworn product can be returned for a full refund within 90 days. We do not offer free return shipping except in cases of defective items. These can be returned for a full refund within 90 days at no expense to you. Please contact us with any inquiries.

Returns can be mailed to:
Runners Plus
8970 Kingsridge Dr.
Dayton, OH 45458