Error at 2021-10-22 21:35:03:
Query: SELECT
tbl_team.team_id AS TEAMID,
tbl_team.name AS TNAME,
tbl_player.player_id PLAYERID,
tbl_player.first_name AS PFIRST,
tbl_player.last_name AS PLAST,
tbl_assignteam.division_id,
tbl_assignteam.team_id,
tbl_assignteam.season_id,
tbl_assignplayer.player_id,
tbl_assignplayer.season_id,
tbl_assignplayer.team_id,
tbl_fixture_stats.player_id,
tbl_fixture_stats.team_id,
tbl_fixture_stats.season_id,
GTABLE.TGOAL
FROM
tbl_team
LEFT JOIN tbl_assignteam ON tbl_assignteam.team_id = tbl_team.team_id
LEFT JOIN tbl_assignplayer ON tbl_assignplayer.team_id = tbl_team.team_id
LEFT JOIN tbl_player ON tbl_assignplayer.player_id = tbl_player.player_id
LEFT JOIN tbl_fixture_stats ON tbl_fixture_stats.player_id = tbl_player.player_id
LEFT JOIN (SELECT
SUM(tbl_fixture_stats.goals) AS TGOAL , player_id FROM tbl_fixture_stats WHERE
tbl_fixture_stats.season_id = 14 group by player_id) GTABLE
ON GTABLE.player_id = tbl_fixture_stats.player_id
WHERE
tbl_assignteam.division_id = 1
AND tbl_assignteam.season_id = 14
AND tbl_assignplayer.season_id = 14
AND tbl_fixture_stats.season_id = 14
AND tbl_fixture_stats.goals != ''
GROUP BY tbl_fixture_stats.player_id ORDER BY TGOAL DESC, PLAST ASC
Error: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'oakbourn_admin_db.tbl_team.team_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
