ERROR |
Database Error Server Address: localhost Server Username: root Error Diagnostic: Bad query. Server Error: (1055) Expression #5 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'dpgweb_stats.hlstats_Actions.reward_player' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by Last SQL Query: SELECT hlstats_Events_TeamBonuses.playerId, hlstats_Players.lastName AS playerName, hlstats_Players.flag as flag, COUNT(hlstats_Events_TeamBonuses.id) AS obj_count, COUNT(hlstats_Events_TeamBonuses.id) * hlstats_Actions.reward_player AS obj_bonus FROM hlstats_Events_TeamBonuses, hlstats_Players, hlstats_Actions WHERE hlstats_Actions.code = 'chargedeployed' AND hlstats_Players.game = 'tf' AND hlstats_Players.playerId = hlstats_Events_TeamBonuses.playerId AND hlstats_Events_TeamBonuses.actionId = hlstats_Actions.id AND hlstats_Players.hideranking = '0' GROUP BY hlstats_Events_TeamBonuses.playerId ORDER BY obj_count desc, playerName desc LIMIT 0,40 |