

ERROR |
Database Error Server Address: 127.0.0.1 Server Username: unloze_stats Error Diagnostic: Bad query. Server Error: () Last SQL Query: SELECT hlstats_Events_Frags.killerId, hlstats_Players.lastName AS killerName, hlstats_Players.flag as flag, COUNT(hlstats_Events_Frags.weapon) AS frags, SUM(hlstats_Events_Frags.headshot=1) as headshots, IFNULL(SUM(hlstats_Events_Frags.headshot=1) / Count(hlstats_Events_Frags.weapon), '-') AS hpk FROM hlstats_Events_Frags, hlstats_Players WHERE hlstats_Players.playerId = hlstats_Events_Frags.killerId AND hlstats_Events_Frags.weapon='ak47' AND hlstats_Players.game='css-zr' AND hlstats_Players.hideranking = 0 GROUP BY hlstats_Events_Frags.killerId ORDER BY frags desc, killerName desc LIMIT 0,50 |