SQL: Select distinct *, (pr.nettopreis * (1+(pr.mwstsatz/100))) as bruttopreis from produkte as pr, produkt_kategorie as zw WHERE pr.artikelnr = zw.produktnr and zw.kategorie in (11,73,74,46,75,81,76,77) and pr.kaeuflich = '1' and pr.sichtbar='1' group by id Order by bruttopreis DESC