Archive Tables

Error at 2020-07-07 19:05:13:

Query: SELECT tbl_team.team_id AS TEAMID, tbl_team.name AS TNAME, tbl_archive_team.* FROM tbl_team, tbl_archive_team WHERE tbl_archive_team.team_id = tbl_team.team_id AND tbl_archive_team.division_id = 1 AND tbl_archive_team.season_id = 14 GROUP BY tbl_archive_team.team_id ORDER BY tbl_archive_team.pts DESC, tbl_archive_team.gd DESC
Error: Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'oakbourn_admin_db.tbl_archive_team.archive_team_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

Solihull & District Oakbourne Football League
PREMIER DIVISION - SEASON 2019-2020
Combined Home & Away Results table

Team P W D L F A GD Pts

Solihull & District Oakbourne Football League
PREMIER DIVISION - SEASON 2019-2020 Home & Away Results table

Name Home Away Total
P W D L F A P W D L F A GD Pts

Solihull & District Oakbourne Football League PREMIER DIVISION - SEASON 2019-2020

Pos Player Goals Current Team
Sorry record not found!

Error at 2020-07-07 19:05:13:

Query: SELECT tbl_team.team_id AS TEAMID, tbl_team.name AS TNAME, tbl_archive_team.* FROM tbl_team, tbl_archive_team WHERE tbl_archive_team.team_id = tbl_team.team_id AND tbl_archive_team.division_id = 2 AND tbl_archive_team.season_id = 14 GROUP BY tbl_archive_team.team_id ORDER BY tbl_archive_team.pts DESC, tbl_archive_team.gd DESC
Error: Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'oakbourn_admin_db.tbl_archive_team.archive_team_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

Solihull & District Oakbourne Football League
DIVISION ONE - SEASON 2019-2020
Combined Home & Away Results table

Team P W D L F A GD Pts

Solihull & District Oakbourne Football League
DIVISION ONE - SEASON 2019-2020 Home & Away Results table

Name Home Away Total
P W D L F A P W D L F A GD Pts

Solihull & District Oakbourne Football League DIVISION ONE - SEASON 2019-2020

Pos Player Goals Current Team
Sorry record not found!

Error at 2020-07-07 19:05:13:

Query: SELECT tbl_team.team_id AS TEAMID, tbl_team.name AS TNAME, tbl_archive_team.* FROM tbl_team, tbl_archive_team WHERE tbl_archive_team.team_id = tbl_team.team_id AND tbl_archive_team.division_id = 3 AND tbl_archive_team.season_id = 14 GROUP BY tbl_archive_team.team_id ORDER BY tbl_archive_team.pts DESC, tbl_archive_team.gd DESC
Error: Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'oakbourn_admin_db.tbl_archive_team.archive_team_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

Solihull & District Oakbourne Football League
DIVISION TWO - SEASON 2019-2020
Combined Home & Away Results table

Team P W D L F A GD Pts

Solihull & District Oakbourne Football League
DIVISION TWO - SEASON 2019-2020 Home & Away Results table

Name Home Away Total
P W D L F A P W D L F A GD Pts

Solihull & District Oakbourne Football League DIVISION TWO - SEASON 2019-2020

Pos Player Goals Current Team
Sorry record not found!

Error at 2020-07-07 19:05:13:

Query: SELECT tbl_team.team_id AS TEAMID, tbl_team.name AS TNAME, tbl_archive_team.* FROM tbl_team, tbl_archive_team WHERE tbl_archive_team.team_id = tbl_team.team_id AND tbl_archive_team.division_id = 4 AND tbl_archive_team.season_id = 14 GROUP BY tbl_archive_team.team_id ORDER BY tbl_archive_team.pts DESC, tbl_archive_team.gd DESC
Error: Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'oakbourn_admin_db.tbl_archive_team.archive_team_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

Solihull & District Oakbourne Football League
DIVISION THREE - SEASON 2019-2020
Combined Home & Away Results table

Team P W D L F A GD Pts

Solihull & District Oakbourne Football League
DIVISION THREE - SEASON 2019-2020 Home & Away Results table

Name Home Away Total
P W D L F A P W D L F A GD Pts

Solihull & District Oakbourne Football League DIVISION THREE - SEASON 2019-2020

Pos Player Goals Current Team
Sorry record not found!

Error at 2020-07-07 19:05:13:

Query: SELECT tbl_team.team_id AS TEAMID, tbl_team.name AS TNAME, tbl_archive_team.* FROM tbl_team, tbl_archive_team WHERE tbl_archive_team.team_id = tbl_team.team_id AND tbl_archive_team.division_id = 5 AND tbl_archive_team.season_id = 14 GROUP BY tbl_archive_team.team_id ORDER BY tbl_archive_team.pts DESC, tbl_archive_team.gd DESC
Error: Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'oakbourn_admin_db.tbl_archive_team.archive_team_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

Solihull & District Oakbourne Football League
DIVISION FOUR - SEASON 2019-2020
Combined Home & Away Results table

Team P W D L F A GD Pts

Solihull & District Oakbourne Football League
DIVISION FOUR - SEASON 2019-2020 Home & Away Results table

Name Home Away Total
P W D L F A P W D L F A GD Pts

Solihull & District Oakbourne Football League DIVISION FOUR - SEASON 2019-2020

Pos Player Goals Current Team
Sorry record not found!