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)
Men's Nike MagistaX Proximo II (IC) Indoor-Competition Football Boot
Amplify your playmaking in Men's Nike MagistaX Proximo II (IC) Indoor-Competition Football Boot. The Dynamic Fit collar integrates the foot and lower leg while a 3-D texture on key areas of the boot provides targeted friction for a precise touch. A circular pivot zone in the forefoot adds traction for quick turns and agile playmaking.
Scalloped Dynamic Fit collar links the lower leg and foot without impeding motion.
3-D texture is amplified on the high-use areas of the foot.
Circular traction pattern is ideal for quick turns and agile playmaking.
Asymmetrical lacing system expands the ball control area.
Layer of Nike Grind rubber on the toe adds durability.
Lunarlon cushioning system features a soft yet resilient foam core encased within a supportive foam carrier for the ultimate in lightweight cushioning.