Deps Slide Swimmer 175
Out Of Stock
|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 = 'SS175/10' AND (upper(f.web_text) = 'DEP`S' or upper(f.orig_text) = 'DEP`S' or upper(a.brand) = 'DEP`S') 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|
Deps Slide Swimmer 175
The Slide Swimmer 175 is a large, hard plastic swimbait designed to mimic large species such as trout, hitch and shad when targeting bass. The 7" Deps Slide Swimmer 175 displays the "glide" style action that has become incredibly popular over the past couple of years. Much of the bait's effectiveness has been attributed to its' completely silent nature. Even the hinges of the jointed-body are precision engineered not to make a sound. The bait's body is now constructed from an ABS plastic injection molding process in contrast to the original foam used for the 250. Outside, the bait will still be covered with a soft silicone skin. The lure, which swims completely on its own free of any diving lip, also boasts an astounding level of detail, including accurate color finishes, 3D eyes and is finished with life-like scale patterns and gills. The 175 size measures 6.88" in length.
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review
$7.09 to $7.19
$8.39 to $9.39
$5.09 to $5.29