Shimano Baraja Worm Binder Medium
|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,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 = 'SHMBARAJA20MD' AND (upper(f.web_text) = 'SHIMANO' or upper(f.orig_text) = 'SHIMANO' or upper(a.brand) = 'SHIMANO') 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 new and improved Baraja Worm Binder is the perfect accessory for anglers to store and transport their arsenal of soft plastics for a day of fishing. Constructed with premium rip-stop fabric and sturdy corrosion-resistant zippers, the outer liners provide added protection while increasing the bags visual appeal. The Baraja Worm Binder includes resealable PVC bags that can be removed to allow anglers to organize soft plastics to fit their specific needs. The Baraja Worm Binder is a great tackle storage solution for anglers fishing in freshwater or inshore with soft plastics. Spend more time fishing, and less time looking for your ideal soft plastic with the new and improved Baraja Warm Binder.
- Heavy TPU Corrosion-Resistant Zippers
- Heavy Denier Rip-Stop Polyester Fabric
- Hard Construction Exterior
- Durable Resealable PVC Bags
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review
$139.99 to $159.99
$29.99 to $36.99