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,4)
GROUP BY b.attr1
ORDER BY max(b.attr1_order), max(b.attr1_entry_id)
Nike Mercurial Superfly 7 Elite MDS IC Indoor/Court Soccer Shoe
ACCELERATE YOUR DREAM.
Dream of speed and play fast in the Nike Mercurial Superfly 7 Elite MDS IC. A streamlined upper wraps your foot, while the rubber sole helps supercharge traction on indoor and court surfaces.
Second-Skin Fit
The Flyknit construction and the Dynamic Fit collar wrap your foot for a second-skin feel.
Cushioning and Durability
Foam cushioning helps absorb the impact of urban play, and an extra layer of NIKESKIN on the upper adds durability.
Made to Move
Based on Nike Sports Research Lab analysis of player movements, the rubber sole is designed to provide multidirectional traction on street, court and indoor surfaces.
More Details
For traction on the street, court and indoor surfaces