SELECT
				hlstats_Events_TeamBonuses.playerId,
				hlstats_Players.lastName AS playerName,
				hlstats_Players.flag as flag,
				COUNT(hlstats_Events_TeamBonuses.id) AS obj_count,
				COUNT(hlstats_Events_TeamBonuses.id) * hlstats_Actions.reward_player AS obj_bonus
			FROM
				hlstats_Events_TeamBonuses, hlstats_Players, hlstats_Actions
			WHERE
				hlstats_Actions.code = 'Terrorists_Win' AND
				hlstats_Players.game = 'cstrike1' AND
				hlstats_Players.playerId = hlstats_Events_TeamBonuses.playerId AND
				hlstats_Events_TeamBonuses.actionId = hlstats_Actions.id AND
				hlstats_Players.hideranking = '0'
			GROUP BY
				hlstats_Events_TeamBonuses.playerId
			ORDER BY
				obj_count desc,
				playerName desc
			LIMIT 0,40