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 Jr. Tiempo Legend 9 Club MG
Little/Big Kids' Multi-Ground Soccer Cleats 1 OF OUR LIGHTEST LEGENDS EVER.
The Nike Jr. Tiempo Legend 9 Club MG is a low-profile design that's reinvented for fast play. The upper features raised areas throughout the strike zone for precise dribbling, passing and shooting, while studs on the bottom provide traction for quick cuts and sudden stops.
The Nike Jr. Tiempo Legend 9 Club MG is a low-profile design that's reinvented for fast play. The upper features raised areas throughout the strike zone for precise dribbling, passing and shooting, while studs on the bottom provide traction for quick cuts and sudden stops.
A redesigned plate and refined upper help reduce bulk, so you can strike fast on the field. Supersoft Upper
Soft synthetic leather is durable and helps you place your shots with precision. Dig In, Take Off
Conical studs deliver exceptional traction when the game heats up.