SELECT
			hlstats_Players.playerId,
			hlstats_Players.connection_time,
			unhex(replace(hex(hlstats_Players.lastName), 'E280AE', '')) as lastName,
			hlstats_Players.country,
			hlstats_Players.city,
			hlstats_Players.flag,
			hlstats_Players.clan,
			hlstats_Players.fullName,
			hlstats_Players.email,
			hlstats_Players.homepage,
			hlstats_Players.icq,
			hlstats_Players.game,
			hlstats_Players.hideranking,
			hlstats_Players.blockavatar,
			hlstats_Players.skill,
			hlstats_Players.kills,
			hlstats_Players.deaths,
			IFNULL(kills / deaths, '-') AS kpd,
			hlstats_Players.suicides,
			hlstats_Players.headshots,
			IFNULL(headshots / kills, '-') AS hpk,
			hlstats_Players.shots,
			hlstats_Players.hits,
			hlstats_Players.teamkills,
			IFNULL(ROUND((hits / shots * 100), 1), 0) AS acc,
			CONCAT(hlstats_Clans.name) AS clan_name,
			activity
		FROM
			hlstats_Players
		LEFT JOIN
			hlstats_Clans
		ON
			hlstats_Clans.clanId = hlstats_Players.clan
		WHERE
			hlstats_Players.playerId = '25301'
		LIMIT
			1