select i.id,i.name_en as name,i.code,i.brand,i.price,(i.cnt-i.cnto) as cnt,i.ims, i.imgdir_suffix,i.img_suffix,i.status,i.priceVis,ip.prNew,ip.prSale,ip.prAction,ip.prRcmnd,ip.prDscnt,ip.prPrepare,ip.prUsed,ip.prDamaged, i.eprice as price_eur, case when subQ.id is null then 0 else 1 end as regionAvail from kav_news_items ni join kav_items i on (ni.iid=i.id and ni.nid=69) join kav_cat_items ci on (ci.item_id = i.id) join kav_items_params ip on (i.id=ip.iid) left join (select i.id from kav_items i left join (select i.item_id, group_concat(sc.tree_id,'+',sc.parent) as cidd FROM kav_cat_items i join kav_subcat sc on sc.child = i.cat_id group by i.item_id) as cc on cc.item_id = i.id where (i.brand_id in (60))) as subQ on subQ.id = i.id where i.erased=0 and i.vis=1 and i.web=1 group by i.id order by ni.ord,ci.prior DESC,i.id
Now in our offer, you can find rotor and tail blades of Czech manufacturer MS Composit designed for flybarless helicopter models. They are precisely manufactured from the highest quality carbon prepreg composite and are suitable for pilots of all experience categories.
They have high performance stability even in the wildest aerobatics, can withstand minor impacts and contribute to lower energy consumption thanks to their sophisticated profile.
Find the detailed info on the product card.