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) / 1 * 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) / 1 * 100, 2) AS hpercent
		FROM
			hlstats_Events_Frags
		LEFT JOIN hlstats_Weapons ON
			hlstats_Weapons.code = hlstats_Events_Frags.weapon
		LEFT JOIN hlstats_Players ON
			hlstats_Players.playerId=hlstats_Events_Frags.killerId
		WHERE
			clan=2744
		AND
			hlstats_Weapons.game='hl2dm_2'
		GROUP BY
			hlstats_Events_Frags.weapon
		ORDER BY
			weapon desc,
			kills desc