Players Averages
- user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-map, teams_location-map, players_location-map, averages_location-map where ((a' at line 1 query: select players_location-map.id, concat(players_location-map.surname, ', ', players_location-map.first_name) as name,concat(clubs_location-map.name,' ', teams_location-map.team_no) as team, count(averages_location-map.player_id) as played, sum(averages_location-map.won) as won, round((sum(averages_location-map.won) / count(averages_location-map.player_id))*100,1) as average from clubs_location-map, teams_location-map, players_location-map, averages_location-map where ((averages_location-map.div_id='') and (averages_location-map.player_id = players_location-map.id) and (players_location-map.team_id = teams_location-map.id) and (clubs_location-map.id = teams_location-map.club_id) and (averages_location-map.player_reserve != 'on') and (averages_location-map.opponent_id != '1') and (averages_location-map.invalid_result != '1')) group by averages_location-map.player_id order by average desc, played desc , name asc in /var/www/bttc/includes/database.mysql.inc on line 172.
- user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-map where division =' at line 1 query: select count(id) from teams_location-map where division = in /var/www/bttc/includes/database.mysql.inc on line 172.
Division Averages |
(Click on players name to see players results)
| Played | Won | Lost | Average |