|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 = 'GRR78XXH' AND (upper(f.web_text) = 'GRAFTECH' or upper(f.orig_text) = 'GRAFTECH' or upper(a.brand) = 'GRAFTECH') 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|
The Graftech Railrods come in 7' 8" lengths. These heavy, offshore models feature a heavy-duty reel seat and robust guides for tackling large tunas.
The Graftech GRR78XXH was designed for HXW or 30 size reels. Perfect for larger bait presentation or jig fishing. This rod is also medium fast off the tip and is user friendly. Rated 100-130 pounds.
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review
$49.99 to $59.99
$199.99 to $219.99
$289.99 to $324.99
$119.99 to $129.99
$169.99 to $189.99
$234.99 to $304.99
$139.99 to $149.99
$194.99 to $229.99
$159.99 to $179.99