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)
GROUP BY b.attr1
ORDER BY max(b.attr1_order), max(b.attr1_entry_id)
"Sculpted for speed, these football boots are stripped down to the essentials. A low-cut silhouette and sock-like fit lock you in, while a flexible mesh upper delivers lightweight comfort. The outsole uses two different stud shapes to improve high-speed stability on firm ground, leaving you free to fly. True touch Match-long comfort and a true touch from a lightweight, dual-layer mesh upper that flexes with your foot Lockdown Low-cut silhouette with signature Clawcollar shape locks your foot into the boot for match-long stability and support Flexible support Sock-like construction offers adaptive support, lightweight comfort and ease of entry Light outsole Lightweight TPU outsole offers the best balance between high speed and traction Stability on firm ground Arrowhead forefoot studs combined with round heel studs enable quick starts and stops on firm ground"
Lightweight, dual-layer mesh upper with low-cut Clawcollar