ilk group by sonra sum
SELECT sum(begen) as begen, id FROM tablo_adi GROUP BY konuid, begen ORDER BY sum(begen) DESC