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=63) 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
The KAVAN V20 is a 24-channel RC kit using a 2.4GHz simultaneous dual-frequency transmission system with full telemetry support (Twin 2.4GHz). It boasts a superior response time of up to 4ms and a range of up to tens of kilometres. You can also choose ACCST D16 or ACCESS transmission systems, also with telemetry. The V20 can therefore be paired with a wide range of KAVAN or FrSky receivers, telemetry or not, with classic PWM and S.BUS outputs. It is suitable for both advanced and sport pilots. Excellent for controlling various aircraft models or heli/multicopters. It can also be easily set up for ships or land models. To do this, use the wide range of functions and mixes available in the ETHOS operating system. You can conveniently adjust these to your own preferences on the large colour touchscreen.