Contact Us
  My Account
  Become A Dealer
  Shipping & Returns
  About Us
  Log Out
Advanced Search
  0 items
Shopping Cart
FLD Goblin 380
Fld Lynx
FLD Goblin
Browse Categories

Quantum 10+1
  Balancing Leads
  Cable Ties
  Charging Cables
  Connectors & Accessories
  Heat Shrink
  Servo & Satellite Extension
  Servo Braid
RC Helicopters
  Electric Helicopters
  Glow / Petrol Helicopters
Helicopter Parts
  Standard Heli Parts
Blades, Paddles & Props
  Main Blades
  Tail Blades
Brushless Motors & ESC
  Speed Controllers
  Speed Controller Accessories
Batteries, Chargers, Connectors
  Balance Boards And Leads
  Balance Accessories
  Parallel Balance Boards
  Charging Cables
  Parallel Charging Cables
  Connectors & Accessories
  Wire and Heat Shrink
Nuts, Bolts
  Nuts, Bolts & Screws
Decals / Stickers / Magazines
Carry Cases
  Transmitter Cases
  Helicopter Carry Cases / Bags
Apparel & Sun Glasses
  Baseball Caps
  Neck Straps
  T-Shirts, Hoodies & Jackets
Align Rotor Blades
Align Rotor Blades
Halo Blades
Halo Blades
Lynx Rotor Blades
Lynx Rotor Blades
SAB Rotor Blades
SAB Rotor Blades
Switch Blades
Switch Blades
VTX Blades
VTX Blades
Zeal Blades
Zeal Blades
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 '[.products_shadow_stock from products p left join specials s on p.products_id = ' at line 1

select distinct p.manufacturers_id, p.products_quantity, p.products_cost_price, p.products_trade_price, p.products_msrp, p.products_rrp_price, p.products_id, p.products_image, p.products_tax_class_id, if(s.status, s.specials_new_products_price, p.products_price) as products_price, [.products_shadow_stock from products p left join specials s on p.products_id = s.products_id, products_to_categories p2c, categories c where p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and c.parent_id = '137' and p.products_status = '1' and (p.siteid='fastladflp' or p.siteid='flpdist') order by p.products_date_added desc limit 0, 18