You have an error below: Query on table products failed: DBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and p.price <> p.sale_price and p.series = 0 order by c.category_desc' at line 1 at /usr/lib/interchange/lib/Vend/Table/DBI.pm line 1944. Query was: select distinct c.category_id, c.category_desc, c2.category_desc as top_category_name from products p join category_item ci on p.sku = ci.item_no join categories c on c.category_id = ci.category_id join categories c2 on c2.category_id = c.top_category where c.parent_category = and p.price <> p.sale_price and p.series = 0 order by c.category_desc

DVD formatChampionship Instant Video Price: $29.99
Item Number: WRD-02605D

Query on table products failed: DBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and p.price <> p.sale_price and p.series = 0 order by c.category_desc' at line 1 at /usr/lib/interchange/lib/Vend/Table/DBI.pm line 1944. Query was: select distinct c.category_id, c.category_desc, c2.category_desc as top_category_name from products p join category_item ci on p.sku = ci.item_no join categories c on c.category_id = ci.category_id join categories c2 on c2.category_id = c.top_category where c.parent_category = and p.price <> p.sale_price and p.series = 0 order by c.category_desc
Format:

Sorry, this video is no longer available. Please call 1-800-873-2730 or email us at Info@ChampionshipProductions.com for recommendations on similar products.

Lessons with Bobby Douglas: Set-ups



Lessons with Bobby Douglas: Set-ups
See more by Bobby Douglas
  • Currently 5/5 Stars.
5/5 Stars (0 Reviews)
  • Improve your Wrestling coaching!
  • Learn from Bobby Douglas!
  • Take your team to the next level!
  • Learn from the best, to become your best!


Description

with Bobby Douglas,
former Iowa State University Head Coach;
National Wrestling Hall of Fame (1987),
2000 NWCA Coach of the Year

In this DVD, Coach Douglas focuses on two set-ups, the underhook and 2-on-1. Douglas illustrates at least five takedowns for each set-up, including the double leg tackle, trips and throws. He also describes the defense against each. As a bonus, Douglas covers the single leg tackle. Douglas demonstrates how to teach the technique, how to drill the techniques as well as covering some of the finer point that make these techniques work - which will make your wrestlers better on their feet.

39 minutes. 2006

See more products by: Bobby Douglas

See related products: Set-Ups and Tie-Ups


Ratings & Reviews

Log in to review this product!

Lessons with Bobby Douglas: Set-ups
29.99

Drake University Continuing Education Gold Medal Guarantee Sign Up for our Newsletter Request a Catalog Testimonials Career Opportunities
1-800-873-2730
info@ChampionshipProductions.com
SecurityWorry-Free Shopping
Championship Productions, Inc.