DB::fetcht[select
(select count(0) from dw_product_desc where approved = 1 and product_id = p.id) as cnt_offers ,
d1.txt as txt_cat ,
d1.s_desc as ico_cat ,
d2.txt as txt_parent ,
m.txt as txt_manu ,
p.*
from dw_product as p
inner join dw_manufacturer as m on m.id = p.manu_id
inner join dw_stdef as d1 on d1.sttype = 1 and d1.st_id = p.cat_id
inner join dw_stdef as d2 on d2.sttype = 1 and d2.st_id = d1.parent_id
where
p.txt = 'KX-TG8220FXB RP-HV103']::ERROR[] - Ценови навигатор