SELECT
hlstats_Events_Frags.killerId,
hlstats_Players.lastName AS killerName,
hlstats_Players.flag as flag,
COUNT(hlstats_Events_Frags.map) AS frags,
SUM(hlstats_Events_Frags.headshot=1) as headshots,
IFNULL(SUM(hlstats_Events_Frags.headshot=1) / Count(hlstats_Events_Frags.map), '-') AS hpk
FROM
hlstats_Events_Frags,
hlstats_Players
WHERE
hlstats_Players.playerId = hlstats_Events_Frags.killerId
AND hlstats_Events_Frags.map='de_mirage'
AND hlstats_Players.game='csgo'
AND hlstats_Players.hideranking<>'1'
GROUP BY
hlstats_Events_Frags.killerId
ORDER BY
frags desc,
killerName desc
LIMIT 0,50