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=72) 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 News - KAVANRC.com
21.10.2024

Bittydesign ŠKODA Fabia

Brighten up the track with Bittydesign's hot new officially-licensed ŠKODA Fabia RS Rally2. The perfectly detailed body is versatile, with a wheelbase of 258 mm, and fits all 1/10 190mm models, both touring and rally specials. Several months of fine-tuning the details are behind the design, and the result is really worth it.

The clear lexan body is available in two thicknesses, and you'll also find a pre-cut wing with fitting kit in the package. Together with the separately available replacement wing, all new items are already available.

© 2024, KAVAN Europe s.r.o.