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)
Men's Nike HypervenomX Phelon III Dynamic Fit (IC) Indoor/Court Football Boot
Men's Nike HypervenomX Phelon III Dynamic Fit (IC) Indoor/Court Football Boot is coiled and ready to strike. An aggressive allover texture enhances touch while the rubber outsole gives you the traction you need on indoor and court surfaces.
Dynamic Fit collar links the ankle and lower foot for increased ball awareness.
Flywire cables wrap your midfoot for stability during lateral cuts.
Foam pods in the strike zone lessen impact and provide excellent energy return.
Zig zag texture on the bottom of the sockliner provides friction to anchor it securely to the boot.
Thin forefoot flex zones allow for quick, agile movements.
Rubber outsole provides traction on indoor and court surfaces.