Rush Creek 24 Rod Wood Round Rack
|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 = '38-2003' AND (upper(f.web_text) = 'RUSH CREEK' or upper(f.orig_text) = 'RUSH CREEK' or upper(a.brand) = 'RUSH CREEK') 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|
Duly named the Infinity Series, these are made from multiple layers of wood to create the most durable rod rack in the market.
Innovative dual clip design allows for storage of two rods back to back with a maximum rod diameter of 1.25″— great for musky or salt water rods
Heavy duty 1.25″ weighted base plate add stability
1.5” diameter solid wood post
Marine grade varnish is used to seal coat and make water resistant
Padded handle guides on base plate
Assembled rack size is 13.5″ x 33″
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review
$4.48 to $8.99
$10.99 to $14.99
$29.99 to $36.99
$24.99 to $29.99