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)
Something every coach and parent should have. The Player First Aid Kit comes with an assortment of basic medical supplies to help a player that picked-up a minor injury. The small carry bag keeps the supplies secure during travel. The First Aid Kit from Kwik Goal can easily be brought to games or practice. Inside of the First Aid Kit there is an assortment of bandages, gauze pads, and antiseptic wipes. Also included are gloves, first aid cream, and athletic tape. All of these items come neatly packed in the soft shell carrying case that includes Velcro and zippered storage nor injury.
Height: 4 1/2" | Width: 7"
First aid guide, assorted bandages, gloves, cleansing towelette, gauze pads, first aid cream and a roll of 1 1/2" athletic tape