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: $159.96 Bundle Price: $139.99
Item Number: LXD-03895

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!

Indoor Lacrosse 4-Pack

(4 Items)
See more by Johnny Mouradian
  • Currently 5/5 Stars.
5/5 Stars (0 Reviews)
  • Learn the features and benefits of the high speed game of indoor lacrosse (box lacrosse)
  • Get six essential shooting techniques for your offensive arsenal
  • Get a thorough breakdown of the highly visual Alley System
  • NLL All-Star goalie Brandon Miller shares player tips and insights into becoming a successful goalie
Sample Videos

Loading Video...


Description

with Johnny Mouradian, Philadelphia Wings General Manager and Head Coach; Inducted into the National Lacrosse League Hall of Fame ('08)

See all the items in this series!

See more products by: Johnny Mouradian


Ratings & Reviews

Log in to review this product!

Indoor Lacrosse 4-Pack
139.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.