# Time: 120523 14:37:48
# User@Host: c9hlstatsxce[c9hlstatsxce] @ localhost []
# Query_time: 4.820014  Lock_time: 0.000107 Rows_sent: 13  Rows_examined: 389369
SET timestamp=1337801868;
SELECT
                        code,
                        hlstats_Actions.description,
                        COUNT(hlstats_Events_PlayerPlayerActions.id) AS obj_count,
                        SUM(hlstats_Events_PlayerPlayerActions.bonus) * -1 AS obj_bonus
                FROM
                        hlstats_Actions
                LEFT JOIN hlstats_Events_PlayerPlayerActions ON
                        hlstats_Events_PlayerPlayerActions.actionId = hlstats_Actions.id
                LEFT JOIN hlstats_Players ON
                        hlstats_Players.playerId=hlstats_Events_PlayerPlayerActions.victimId
                WHERE
                        clan=12346
                GROUP BY
                        hlstats_Actions.id
                ORDER BY
                        obj_count asc,
                        description asc;