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=74)
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
