Spro BBZ1 Rat
Out Of Stock
|SQL||SELECT DISTINCT a.style_id, max(CASE WHEN m.description IS NULL OR RTRIM(LTRIM(m.description)) = '' THEN a.web_desc ELSE m.description END) as realname, sum(c.qoh+c.qc) as overallqoh, max(a.picture_id) as picture_id, max(a.of8) as of8, max(b.sku_id) as sku_id, max(b.sku_of7) as sku_of7, max(b.scale_entry_id) as scaleid, max(b.attr2_entry_id) as attr2id, max(b.attr1_entry_id) as attr1id, max(a.style) as style, max(r.package_id) as usepackage, max(a.web_style) as webStyle, max(m.capacity) as capacity, max(m.webstyle_sort) as webstyle_sort, max(a.NON_INVT) as NON_INVT FROM tb_styles a LEFT JOIN tb_skus b WITH (NOLOCK) ON (a.style_id = b.style_id) LEFT JOIN tb_sku_buckets c WITH (NOLOCK) ON (b.sku_id = c.sku_id AND NOT (c.qoh < 1 AND a.of8 in (?,?,?,?,?,?,?)) AND NOT (c.qoh < 1 AND a.of8='INACTIVE') AND c.store_id in(49,90) ) LEFT JOIN web_product_information m WITH (NOLOCK) ON (a.style_id = m.style_id) LEFT JOIN dbo.tb_inet_names f WITH (NOLOCK) on (f.orig_text = a.brand and f.field_name='BRAND') LEFT JOIN tb_package r WITH (NOLOCK) on (r.sku_id=b.sku_id) INNER JOIN web_all_products wb WITH (NOLOCK) ON (wb.style_id = a.style_id) WHERE a.web_style = 'SRT50Z1GGT' AND (upper(f.web_text) = 'SPRO' or upper(f.orig_text) = 'SPRO' or upper(a.brand) = 'SPRO') GROUP BY a.style_id,a.of8 HAVING (sum(c.qoh+c.qc) > 0 OR a.of8='STK') ORDER BY max(m.webstyle_sort), a.style_id|
LIMIT 1 OF EACH COLOR PER CUSTOMER
SPRO's Pro Staff member Bill Siemantel has been working on a BBZ project the last 2 years and on the opening day of ICAST 2014 all that hard work paid off. Spro's newest BBZ addition to the family, the BBZ-1 Rat won Best of ICAST in the hard lure category. The SPRO Rat is designed for those larger predator fish that every angler is looking for. It entices awesome surface strikes by triggering the instinctive reaction that those lager fish are looking for. When the fish are hungry the SPRO RAT is the real meal deal! The SPRO Rat can be worked in several ways - you can bulge it, v-wake it, walk the dog, pop it or you name it! Bil Siemantel designed the placement of the hooks so the hook up ration is incredible.
Size: Measures 10 inches (5 1/4-inch body and 4 3/4-inch custom articulating tail) Weight: 2.5 oz
Hooks:#1/0 Gamakatsu 2X strong Treble
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review
$6.99 $3.97 to $5.99
$14.99 to $15.99
$4.79 to $5.29
$3.97 to $7.69