Coming Soon
  Contact Us
  Create an Account
  My Account
  Shipping & Returns
  About Us
  Wishlists
  Log Out
 
 
Advanced Search
  0 items
Shopping Cart
Magic Mirrow
New Castle
New parts Finder 2014
Browse Categories
Manufacturers

Bargain Box
  .99 Bargain Box
  2.99 Bargain Box
  4.99 Bargain Box
  9.99 and up Bargain Box
Compass Helicopters
OptiPower Ultra Guard
Helicopter Kits
Helicopter Parts
Rotor Blades
Motors and Speed Controls
Batteries and Chargers
  OptiPower
Servos and Electronics
Engines and Parts
Tools and Accessories
Metric Nuts, Bolts and Washers
Miscellaneous Items
Glue,Greases & Oil
Starting Equipment
Shirts and Hats
Halo Blades
RSS Facebook Twitter
YoutubeInstagram
 
Get Them While They're Hot!
Items per page: 24 | 60 | 120 | 240
1064 - 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 '-24, 24' at line 1

select p.products_quantity, p.products_id, pd.products_name, p.products_price, p.products_msrp, p.products_tax_class_id, p.products_image, s.specials_new_products_price from products p, products_description pd, specials s where p.products_status = '1' and s.products_id = p.products_id and p.products_id = pd.products_id and pd.language_id = '1' and s.status = '1' and (s.siteid='experience' or s.siteid='exptotal') order by s.specials_date_added DESC limit -24, 24

[TEP STOP]