Flambeau Kwikdraw 2 Tray Box
Item# 1804 / 6008TB
|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 = '1804 / 6008TB' AND (upper(f.web_text) = 'FLAMBEAU' or upper(f.orig_text) = 'FLAMBEAU' or upper(a.brand) = 'FLAMBEAU') 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|
This oversized two tray will accommodate the most demanding fisherman's needs. Three Kwikdraw Tuff Tainers attached to the exterior of this tackle box make for fast fisherman friendly access to your most use tackle.
Size 18 x 10 x 9.75 Oversized 2-tray with quick utility box access. Comes with (2) 2003 and (1) 3003 external, quick access Tuff 'Tainers. Largest capacity 2-tray available, with "3rd tray" on the outside. Exterior rack for hanging lures and various tools. Heavy-duty handle and Drawtite Mega Latch. Stackable on the shelf for efficient retail display. Up to 36 compartments.
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review
$6.99 to $10.99
$19.99 to $29.99
$24.99 to $29.99