Big Bass Dreams Volume 1 DVD
|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 = 'BBD-V1' AND (upper(f.web_text) = 'BIG BASS DREAMS LLC' or upper(f.orig_text) = 'BIG BASS DREAMS LLC' or upper(a.brand) = 'BIG BASS DREAMS LLC') 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|
Watch as we battle trophy class largemouth up to 15lbs and experience the Big Bass Dreams each and every one of us have had!!! Be one of the first to view the first volume in this very special project. The effort and production in this movie is unlike anything that bass fishing has ever seen. This isn't your standard fishing tv show or movie. It's a modern perspective that the world needs to see. Something different than what we have been fed all our lives. There's more to bass fishing than catching "keepers" or a "limit". This is a direct reflection of the anglers featured in this special project. Passion and energy, excitement and frustration, highs and lows. It's sure to keep you engaged from start to finish.
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review
$19.97 to $25.00
$16.99 to $24.50
$24.97 to $30.00
$39.97 to $50.00