SELECT player.Name, items_gd.name, SUM(amount) AS Anzahl, Sum(price) AS Summe  FROM `log_gangwar_sell` INNER JOIN player ON player.id = player_id INNER JOIN items_gd ON items_gd.id = item_id GROUP BY item_id, player_id
ORDER BY `Anzahl`  DESC