Evolution Outdoor Drift Series 3600 Tackle Tray
|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,4) ) 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 = '36005-EV' AND (upper(f.web_text) = 'EVOLUTION OUTDOOR' or upper(f.orig_text) = 'EVOLUTION OUTDOOR' or upper(a.brand) = 'EVOLUTION OUTDOOR') 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|
Make your fishing expedition a great experience with this Evolution Fishing lineup. Color code and organize your tackle with these trays so you can get to the right tray quickly while you're on your fishing adventure. Store all your bait in one very convenient place while you enjoy your fishing adventure. The EVOLUTION FISHING DRIFT SERIES TACKLE TRAY will go great with other Evolution Outdoor Tackle Bags or Tackle Backpacks.
- Durable 3600 tackle tray
- Colorful compartments
- Clear lid for easy organization
- Two latch closure
- Dimensions: 10.5”w x 7”h x 1.5”d
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review
$39.97 to $50.00
$5.99 to $7.99
$6.49 to $9.99
$29.97 to $40.00