SELECT
			hlstats_Events_Frags.weapon,
			IFNULL(hlstats_Weapons.modifier, 1.00) AS modifier,
			COUNT(hlstats_Events_Frags.weapon) AS kills,
			ROUND(COUNT(hlstats_Events_Frags.weapon) / 443 * 100, 2) AS kpercent,
			SUM(hlstats_Events_Frags.headshot = 1) AS headshots,
			ROUND(SUM(hlstats_Events_Frags.headshot = 1) / IF(COUNT(hlstats_Events_Frags.weapon) = 0, 1, COUNT(hlstats_Events_Frags.weapon)), 2) AS hpk,
			ROUND(SUM(hlstats_Events_Frags.headshot = 1) / 140 * 100, 2) AS hpercent
		FROM
			hlstats_Events_Frags
		LEFT JOIN
			hlstats_Weapons
		ON
			hlstats_Weapons.code = hlstats_Events_Frags.weapon
		WHERE
			hlstats_Events_Frags.killerId = 37
			AND
			(
				hlstats_Weapons.game = 'cstrike'
				OR hlstats_Weapons.weaponId IS NULL
			)
		GROUP BY
			hlstats_Events_Frags.weapon
		ORDER BY
			kills desc,
			weapon desc