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 = 'RT25B' AND (upper(f.web_text) = 'BILL LEWIS' or upper(f.orig_text) = 'BILL LEWIS' or upper(a.brand) = 'BILL LEWIS') 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|
Lipless crankbaits are well known and justly famous for their ability to cover a lot of water quickly and to produce fish. Rattletrap is one the best known lipless crankbaits. Loud, flashy attention getters, Rattletraps can be fished in a variety of situations from shallow to deep and everything in between.
Normally fished in a cast-and-crank shallow water situation, they are also effective when allowed to sink to the bottom and burned over deep structure back to the boat. With this method, just position the boat on the uphill side of a point or underwater hump and throw out as far as you can. Let the bait sink to the bottom and start the retrieve up the slope, banging into rocks and other obstructions along the way. The Rattletrap is best known for ripping through shallow grass beds and surprising bad tempered bass waiting in ambush. These baits will get pounded by hungry fish however you choose to fish them.
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review
$14.99 to $16.99
$8.09 to $9.39
$5.49 to $5.99
$4.79 to $5.29
$7.99 to $9.29
$5.09 to $5.29
$3.97 to $5.99