Eastern Helicopters  Your VARIO Helicopters Source In Canada

Canadian vario dealer for scale helicopters

  Home » Catalog » Scale Accessories » External Acc. » 340/40 My Account  |  Cart Contents  |  Checkout   

 

The VarioCanada.com store has moved to

http://www.easternhelicopters.com

Click here to go to our new website and online store.
Categories
Pod & Booms
Scale Fuselages
Scale Accessories
  Cockpits Acc.
  External Acc.
Mechanics set
Engines Sets
Radio Systems
Rotor Blades
Replacement Parts
Promotional
Tools
Fueling Station
Turbine Accessories
JetCat Heli Engines
JetCat Jet Engines
Manufacturers
Quick Find
 
Use keywords to find the product you are looking for.
Advanced Search
Mirror set for large-scale models
Order No. 340/40
$69.67 CAN
Mirror set, complete as illustrated
e.g. for Lama and other large-scale models
Reviews
3065 - Expression #1 of ORDER BY clause is not in SELECT list, references column 'variocan_a.xp.products_id' which is not in SELECT list; this is incompatible with DISTINCT

select distinct p.products_id, p.products_image, pd.products_name, p.products_tax_class_id, products_price from products_xsell xp, products p, products_description pd where xp.products_id = '2866' and xp.xsell_id = p.products_id and p.products_id = pd.products_id and pd.language_id = '1' and p.products_status = '1' order by xp.products_id asc limit 30

[TEP STOP]