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
HAVING sum(e.qoh+e.qc) > 0
ORDER BY max(b.attr1_order), max(b.attr1_entry_id)
When you’re fast enough to be first, you make the rules. Lead the charge and
own all 90 minutes in these junior soccer boots made for precision and control
at high speed. A Primeknit upper delivers total control with no wear-in time.
Designed for firm ground and artificial grass.
Upper: Experience zero wear-in
time with a Primeknit upper that molds perfectly to your foot the instant you slip
it on. Control the ball at high speed with a Purecut laceless sock forefoot with
no edges, overlays or laces to get between you and the ball. Control the ball in
all conditions with NON STOP GRIP (NSG), a thin layer of raised dots applied to
the upper that keeps the ball glued to your feet.
Outsole: Provides rock-solid
stability at high speeds with its extremely lightweight SPRINTFRAME outsole.
Move with high-speed control and stability on firm ground (third- and fourthgeneration
artificial grass) with the TOTAL CONTROL stud alignment