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=77) 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
12.11.2024

KAVAN Vectopor

We have added the new KAVAN Vectopor to our building materials offer. It is a finely porous material based on polypropylene, which you can use for building ultra-light and durable indoors, park flyers, shock flyers and so on. The boards are highly resistant to breaking and tearing, easy to shape and bond with contact or CA glue.

© 2024, KAVAN Europe s.r.o.