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
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)
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)
Nike Hypervenom Phantom 3 Elite FG
Firm-Ground Football Boot DEADLY FINISHING. SUPERIOR FIT.
The Nike Hypervenom Phantom 3 Elite FG Firm-Ground Football Boot is the first low-top boot constructed with a full Flyknit upper. It features dynamic Flywire cables for lateral lockdown, and a HyperReactive plate with thin forefoot flex zones for agile movement.
Flywire cables wrap your midfoot for stability during lateral cuts.
Foam pods in the strike zone dampen impact and return energy.
HyperReactive plate features a flexible forefoot for responsive stability.
Flyknit constructed upper integrates areas of high breathability, stretch and support.
Chevron and hexagonal studs provide targeted traction for agile attacking movement.