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

Quantum 10+1
  Balancing Leads
  Cable Ties
  Charging Cables
  Connectors & Accessories
  Heat Shrink
  Miscellaneous
  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
  Batteries
  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
  Towels
 
 
Goblin 380
Goblin 380
Goblin 500
Goblin 500
Goblin 500 Sport
Goblin 500 Sport
Goblin 570
Goblin 570
Goblin 630 Competition
Goblin 630 Competition
Goblin 700 Competition
Goblin 700 Competition
Goblin 770
Goblin 770
Goblin Black Nitro
Goblin Black Nitro
Goblin Black Thunder
Goblin Black Thunder
Goblin Speed
Goblin Speed
Goblin Urukay / Competition
Goblin Urukay / Competition
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 = '711' and p.products_status = '1' and (p.siteid='fastladflp' or p.siteid='flpdist') order by p.products_date_added desc limit 0, 18

[TEP STOP]