SELECT
				MAX(hlstats_Players_Awards.awardTime) AS awardTime,
				hlstats_Awards.name,
				hlstats_Awards.verb,
				COUNT(verb) AS count,
				hlstats_Awards.awardId
			FROM
				hlstats_Players_Awards
			INNER JOIN
				hlstats_Awards
			ON
				hlstats_Awards.awardId = hlstats_Players_Awards.awardId
			WHERE
				hlstats_Players_Awards.playerId = 811
			GROUP BY
				hlstats_Awards.name,
				hlstats_Awards.verb
			ORDER BY
				awardTime desc,
				name desc
			LIMIT
				0,50