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)
Fine-tune your instincts in these firm ground football boots. A stretchy collar allows for easy entry. Once you're in, the upper adapts to your foot's shape to offer comfort and lockdown on the pitch. Soft and durable, the leather forefoot cushions ball contacts for a silky first touch.
ANATOMICAL FIT: BUILD TO THE CONTOURS OF YOUR FOOT, THE UPPER SEAMLESS MOLDS AROUND YOUR FEET, FOR UNRIVALED COMFORT.
LACED: SOCK CONSTRUCTIONS ALLOWS FOR EASY ENTRY WITH 4 WAY STRETCH MATERIAL. LACES PROVIDED LOCK DOWN
LEATHER VAMP: LEATHER VAMP OFFERS A SOFT TOUCH AND DURABILITY.
MEDIAL BRANDING: 3 STRIPES ON QUARTER
TPU outsole: STUD SHAPES HAVE BEEN DESIGNED FOR ENHANCED TRACTION AND ROTATIONAL MOVEMENTS