select p.id from promotionproduktprovision p 
join promotionprodukt pp on pp.id=p.id_promotionprodukt 
where pp.id_promotion=837 and datum_bis="2020-05-31"