ERROR |
Database Error Server Address: 172.16.217.100 Server Username: hlstats_user Error Diagnostic: Bad query. Server Error: (1064) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'tf23' AND hlstats_Players.hideranking<>'1' GROUP BY hlstats_Events_Fr...' at line 13 Last SQL Query: 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='z\' AND hlstats_Players.game='tf23' AND hlstats_Players.hideranking<>'1' GROUP BY hlstats_Events_Frags.killerId ORDER BY frags desc, killerName desc LIMIT 0,50 |