Contact Us
  My Account
  Become A Dealer
  Shipping & Returns
  About Us
  Log Out
 
 
Advanced Search
  0 items
Shopping Cart
FLD Castle
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
 
 
Align Parts
Align Parts
Compass Parts
Compass Parts
E Sky Parts
E Sky Parts
E-flite Parts
E-flite Parts
Gaui Parts
Gaui Parts
Hirobo SDX
Hirobo SDX
JR Heli Division Parts
JR Heli Division Parts
Mikado Logo Parts
Mikado Logo Parts
Miniature Aircraft Parts
Miniature Aircraft Parts
MS Heli
MS Heli
Outrage Parts
Outrage Parts
Oxy Heli by Lynx Parts
Oxy Heli by Lynx Parts
SAB Goblin Parts
SAB Goblin Parts
Synergy Parts
Synergy Parts
Thunder Tiger Parts
Thunder Tiger Parts
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 = '144' 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]