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)
A New Era: The Binho Classic is an upgraded, fully modular take on our original Binho Classic models with some major improvements to take your flicking game to another realm.
Each game comes with two Biñho balls, two scoring pieces, and two yellow/red playing cards and a Binho Rule Card all within a Biñho box.
New Features include:
Removable player parts. While red cards of Binho past may have let rule breakers and high-risk shooters off the hook relatively easy. On the Binho Classic losing a player on a red card brings an entirely new element to the game. This feature also makes for a beautiful new sound when hit, an underrated aspect of the Binho experience.
New integrated net design. The new goals on your Binho board are a fully integrated part which will significantly reduce broken parts and provide a cleaner aesthetic.
Laser imbedded turf print. Gone are the days of minor plastisol print lines on the Binho pitch and aftereffects of using high temperature printing. Our new high-end proprietary printing mechanics will laser print directly into the turf itself allowing for a buttery smooth playability.