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 formatDigital Video Download Price: $24.99
Item Number: CHD-03329A

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:





Add to Wish List!

Jomo's 15 Favorite Basketball Cheers & Chants



Jomo's 15 Favorite Basketball Cheers & Chants
See more by Jomo Thompson
  • Currently 5/5 Stars.
5/5 Stars (0 Reviews)
  • Learn unique basketball-specific cheers and chants
  • Easy to follow front and back demonstrations
  • Discover new ways to fire up you basketball crowd

Sample Videos

Loading Video...


Description

with Jomo Thompson,
University of Kentucky Head Coach,
7x National Championship Coach;
2009 USA National Cheerleading Team Head Coach;
and head coach of North Laurel KY High School, 2009 National Champions

University of Kentucky Head Coach Jomo Thompson shares his 15 favorite basketball cheers and chants - all featuring demonstrations by members of the 2009 National Championship UK cheer squad. Jomo demonstrates each cheer with separate front and back views. Learn new moves and cheers that are certain to fire up your basketball team and get your crowd involved in the action.

16 minutes. 2009.


This item also belongs to the following series!

See more products by: Jomo Thompson

See related products: Cheers and Chants University of Kentucky Instruction Cheerleading Digital Video Downloads


Ratings & Reviews

Log in to review this product!

Jomo's 15 Favorite Basketball Cheers & Chants
24.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.