1 and exists (
(select id_disc from discounts d
where d.id_prod=p.id_prod and (d.datefrom=0 or d.datefrom<1716166885) and (d.dateto=0 or d.dateto>1716166885))
union
(select id_disc from discounts d
left join categories parent on ( d.id_cat=parent.id_cat )
left join categories node on ( node.lft BETWEEN parent.lft AND parent.rgt )
left join cat2prod cp on(node.id_cat=cp.id_cat)
where cp.id_prod=p.id_prod and (d.datefrom=0 or d.datefrom<1716166885) and (d.dateto=0 or d.dateto>1716166885)))
Gluténmentes Bolt
