Archive Tables

Error at 2020-07-07 19:58:57:

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 = 3 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 2009-2010
Combined Home & Away Results table

Team P W D L F A GD Pts

Solihull & District Oakbourne Football League
PREMIER DIVISION - SEASON 2009-2010 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 2009-2010

Pos Player Goals Current Team
1 Matthew Foster 35 Damsonwood Blues
2 Chad Caruana 18 Billesley F.C.
3 James Cartwright 14 Bordesley Rovers Old
4 Paul Meredith 14 Hilton Rangers
5 Jon White 13 Hilton Rangers
6 Tyrone Griffiths 13 Bordesley Rovers Old
7 Cashel McDonald 10 St Leonards
8 Christian Markman 10 St Andrews Athletic
9 Lee Fearon 10 St Andrews Athletic
10 Mark Cass 10 Billesley F.C.
11 Richard Deans 10 Bordesley Rovers Old
12 Dan Orr 9 Damsonwood Blues
13 Matthew Toller 9 Parkwood St Andrews
14 Neil Walker 9 Hilton Rangers
15 Kraig Sarapuk 8 Billesley F.C.
16 Richard Simmonds 8 Billesley F.C.
17 Adam Butler 7 Sporting Phoenix
18 Joseph Halsall 7 Bordesley Rovers Old
19 Steven Smith 7 Hall Green Concorde
20 Christian Andrews 6 Parkwood St Andrews
21 John Honer 6 St Leonards
22 Matthew Fearon 6 St Andrews Athletic
23 Ryan Jelley 6 Billesley F.C.
24 Sam Edwards 6 Sporting Phoenix
25 Scott Martin 6 Sporting Phoenix
26 Danny Nicholson 5 Billesley F.C.
27 Michael Breakwell 5 Bordesley Rovers Old
28 Scott James 5 Parkwood St Andrews
29 Carl Betts 4 St Leonards
30 Kevin Hare 4 Hall Green Concorde
31 Kojo Darku 4 St Andrews Athletic
32 Matt Butler 4 Sporting Phoenix
33 Ben Frankel 3 Parkwood St Andrews
34 Ben Mason 3 Sporting Phoenix
35 Ben Toller 3 Parkwood St Andrews
36 Chris Langford 3 St Andrews Athletic
37 Craig Jarvis 3 Hall Green Concorde
38 David Tomkins 3 Hilton Rangers
39 Glenn Farrelly 3 Hilton Rangers
40 Jonathan Jones 3 Bordesley Rovers Old
41 Lee Marshall 3 Billesley F.C.
42 Matthew Court 3 Sporting Phoenix
43 Michael Hinton 3 Damsonwood Blues
44 Nathan Anibaba 3 St Andrews Athletic
45 Paul Malone 3 Damsonwood Blues
46 Peter Adkins 3 Billesley F.C.
47 Richard Lowry 3 Bordesley Rovers Old
48 Abdul Kanu 2 St Andrews Athletic
49 Chris Morgan 2 Hilton Rangers
50 Chris Smith 2 Parkwood St Andrews
51 Colin Murphy 2 Hall Green Concorde
Pos Player Goals Current Team
52 Daniel Hasson 2 Bordesley Rovers Old
53 David King 2 St Andrews Athletic
54 Gerald Burns 2 St Andrews Athletic
55 Gerard Ribera 2 Damsonwood Blues
56 Glenn Wallace 2 Sporting Phoenix
57 Jason Brookes 2 Hall Green Concorde
58 Jon Davis 2 Hall Green Concorde
59 Lee Reading 2 Bordesley Rovers Old
60 Mark Nicholas 2 Hilton Rangers
61 Neil Underwood 2 St Leonards
62 Ondre Richards 2 Damsonwood Blues
63 Russell Kirby 2 St Leonards
64 Ryan Cope 2 Sporting Phoenix
65 Sean Cooney 2 Damsonwood Blues
66 Steven Howkins 2 St Andrews Athletic
67 Tom Kavanagh 2 Sporting Phoenix
68 Aaron Toon 1 Hall Green Concorde
69 Adam Gillott 1 Hilton Rangers
70 Adam Reading 1 Bordesley Rovers Old
71 Adam Vincent 1 Hall Green Concorde
72 Adrian Cooney 1 Damsonwood Blues
73 Aidan Johnson 1 Damsonwood Blues
74 Akin Ogunbanjo 1 St Andrews Athletic
75 Alan Buswell 1 Billesley F.C.
76 Andrew Barton 1 St Andrews Athletic
77 Bernard McCluskey 1 Hall Green Concorde
78 Christopher Poole 1 Billesley F.C.
79 Daniel Ayres 1 Billesley F.C.
80 Daniel Caddick 1 Hall Green Concorde
81 Daniel Gleeson 1 Billesley F.C.
82 Darren Bourne 1 St Leonards
83 David Jones 1 Bordesley Rovers Old
84 Graham Richards 1 St Andrews Athletic
85 Grant Burton 1 Damsonwood Blues
86 Ian Ferris 1 St Leonards
87 John Fitzgibbon 1 St Leonards
88 Mark Brown 1 Hall Green Concorde
89 Mark Uddin 1 St Andrews Athletic
90 Matthew Kavanagh 1 Sporting Phoenix
91 Philip Rex 1 Hilton Rangers
92 Ricky Jelley 1 Billesley F.C.
93 Ross Fearon 1 St Andrews Athletic
94 Russell Gillott 1 Hilton Rangers
95 Scott Betts 1 St Leonards
96 Scott Rutter 1 Hilton Rangers
97 Simon Hudson 1 Damsonwood Blues
98 Stephen Jones 1 Bordesley Rovers Old
99 Tom McCabe 1 Damsonwood Blues
100 Tom Wilson 1 Parkwood St Andrews
101 Tyrone Borland 1 Damsonwood Blues
102 Wayne Bourne 1 St Leonards

Error at 2020-07-07 19:58:57:

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 = 3 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 2009-2010
Combined Home & Away Results table

Team P W D L F A GD Pts

Solihull & District Oakbourne Football League
DIVISION ONE - SEASON 2009-2010 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 2009-2010

Pos Player Goals Current Team
1 Chrisi Conway 59 Conway Albion
2 Reece Hewitt 40 AFC Lodge
3 Unus Willinger 32 AFC Lodge
4 Matthew Seeley 22 AFC Lodge
5 John Allcott 21 Richmond Eagles
6 Neil Jenkins 19 Olton Orient
7 Rob McCann 19 Real Norton FC
8 Paul Whitehead 18 Conway Albion
9 David Simpson 17 Fox & Goose
10 Sammy Davies 16 Journeys End Athletic
11 Dean Conway 15 Conway Albion
12 Elliot Rodriguez 15 Journeys End Athletic
13 Andrew Cumiskey 12 Journeys End Athletic
14 Darren Harris 12 Richmond Eagles
15 Gary O'Shea 11 Real Norton FC
16 Leon Hewitt 11 AFC Lodge
17 Earl Jordan 10 AFC Lodge
18 Ross Taylor 10 Colebrook
19 Desmond Conway 9 Conway Albion
20 Junior Hewitt 9 AFC Lodge
21 Andrew McGarry 8 Conway Albion
22 Mark Armstrong 8 Fox & Goose
23 James Averiss 7 AFC Lodge
24 Simon Dyke 7 Colebrook
25 Tom Adams 7 Bournville Athletic
26 Craig Nolan 6 Fox & Goose
27 Darren Bull 6 Richmond Eagles
28 Darren Conway 6 Conway Albion
29 Julian Ward 6 Fox & Goose
30 Matthew Latty 6 Drawbridge Rebels
31 Robert Memory 6 Bournville Athletic
32 Ryan Corrall 6 Conway Albion
33 Alex Howarth 5 Colebrook
34 Chris Golsby 5 Colebrook
35 Chris Mitchell 5 Drawbridge Rebels
36 Chris Rowe 5 Olton Orient
37 Daniel Ward 5 Richmond Eagles
38 Gary Moseley 5 Fox & Goose
39 Phil Allen 5 Richmond Eagles
40 Samuel Round 5 Richmond Eagles
41 Scott Lennon 5 Bournville Athletic
42 Andrew Lane 4 Richmond Eagles
43 Dale White 4 AFC Lodge
44 Dominic Thomas 4 Richmond Eagles
45 George Goodwin 4 Real Norton FC
46 Ian Thomas 4 Drawbridge Rebels
47 John Whitehouse 4 Colebrook
48 Sean Clarke 4 AFC Lodge
49 Stephen Jennings 4 Drawbridge Rebels
50 Carlton Sealy 3 Richmond Eagles
51 David Case 3 Olton Orient
Pos Player Goals Current Team
52 David Jenkins 3 Olton Orient
53 Sam Smith 3 Real Norton FC
54 Scott Smith 3 AFC Lodge
55 Trevor Johnson 3 Conway Albion
56 Chris Chamberlain 2 Olton Orient
57 Gavin Campbell 2 Journeys End Athletic
58 Ian Atterbury 2 Fox & Goose
59 Jamie Joyce 2 Bournville Athletic
60 Jarrell Revan 2 Journeys End Athletic
61 Kieran Davies 2 Journeys End Athletic
62 Luke Collymore 2 Richmond Eagles
63 Nigel Abbotts 2 Real Norton FC
64 Terry Coles 2 Richmond Eagles
65 Tim Stafford 2 Drawbridge Rebels
66 Adam Walshe 1 Colebrook
67 Andrew Bell 1 Olton Orient
68 Andrew Driscoll 1 Olton Orient
69 Andrew Struthers 1 Journeys End Athletic
70 Ashley Sellers 1 Journeys End Athletic
71 Carl Rose 1 Real Norton FC
72 Chris Bishop 1 Colebrook
73 Christopher Titley 1 Journeys End Athletic
74 Colin Atterbury 1 Fox & Goose
75 Daniel Conway 1 Conway Albion
76 Dean Cotterill 1 Journeys End Athletic
77 Dean Lamb 1 Journeys End Athletic
78 Douglas Humphries 1 AFC Lodge
79 Gareth Reade 1 Drawbridge Rebels
80 Graham Bradbury 1 Olton Orient
81 Ian Gallagher 1 Real Norton FC
82 James Goodman 1 Colebrook
83 James Woodward 1 Olton Orient
84 Karl Jones 1 AFC Lodge
85 Kieran Conway 1 Conway Albion
86 Levice Ward 1 Richmond Eagles
87 Liam Cronin 1 Olton Orient
88 Limahl Cottrell 1 AFC Lodge
89 Mark Allbutt 1 Colebrook
90 Matthew Daly 1 Olton Orient
91 Oliver Jones 1 Real Norton FC
92 Owen Spencer 1 Journeys End Athletic
93 Paul Stack 1 Drawbridge Rebels
94 Robert Benton 1 Real Norton FC
95 Ryan Croft 1 Colebrook
96 Ryan Kelly 1 Journeys End Athletic
97 Stephen Furley 1 Real Norton FC
98 Stuart Lancaster 1 Olton Orient
99 Terry Langston 1 Colebrook
100 Thomas Lewis 1 AFC Lodge
101 William Stockton 1 Drawbridge Rebels

Error at 2020-07-07 19:58:57:

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 = 3 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 2009-2010
Combined Home & Away Results table

Team P W D L F A GD Pts

Solihull & District Oakbourne Football League
DIVISION TWO - SEASON 2009-2010 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 2009-2010

Pos Player Goals Current Team
1 Cole Stephens 26 Widney Wanderers
2 Steven Chamberlain 23 Bordesley FC
3 Christopher Wheeldon 15 Bordesley FC
4 Charles McColgan 13 Hall Green Galaxy
5 John Smith 11 Yardley Wanderers
6 Neil Bennett 11 Widney Wanderers
7 Anthony Steeles 10 Quinton Athletic
8 Gajinder Singh 10 Bordesley FC
9 Philip Vaughan 10 Greenlands Social
10 Ricky Amalsadia 9 Norton United
11 Thomas Price 9 Yardley Wanderers
12 John Jones 8 St Bernard’s Grange
13 Michael Jefferies 8 Quinton Athletic
14 Brad Davies 7 St Bernard’s Grange
15 Daniel Davies 7 Phoenix Rangers
16 Jack Fairhurst 7 Widney Wanderers
17 Joel Francis 7 Quinton Athletic
18 Stuart Youdan 7 Widney Wanderers
19 Asif Masud 6 Bordesley FC
20 Chris Ketebu 6 Greenlands Social
21 Duncan Smith 6 Phoenix Rangers
22 James Morris 6 Phoenix Rangers
23 Joe Warner 6 Widney Wanderers
24 Josh Taylor 6 Phoenix Rangers
25 Nabeel Shabir 6 Bordesley FC
26 Ben Adams 5 Yardley Wanderers
27 Javan Welch 5 Bordesley FC
28 Joe Mellin 5 Norton United
29 Josh Sidwell 5 Phoenix Rangers
30 Kieran Jones 5 Hall Green Galaxy
31 Mark Freeman 5 Widney Wanderers
32 Neil Sunner 5 St Bernard’s Grange
33 Richard Cooper 5 St Bernard’s Grange
34 Alex Warner 4 Widney Wanderers
35 Bradley Taylor 4 Widney Wanderers
36 Daniel Sparkes 4 Hall Green Galaxy
37 Karl Evans 4 Norton United
38 Nathan Neale 4 Greenlands Social
39 Simon Cooper 4 St Bernard’s Grange
40 Andrew Burkett 3 Phoenix Rangers
41 Andrew Edmonds 3 Bordesley FC
42 Chris Earp 3 Yardley Wanderers
43 Edward Sutton 3 Quinton Athletic
44 Gary Evans 3 Norton United
45 Gary Steeles E/Goalkeeper 3 Quinton Athletic
46 Lewis Eckersley 3 Hall Green Galaxy
47 Mark Brueton 3 Hall Green Galaxy
Pos Player Goals Current Team
48 Nadeem Khan 3 Bordesley FC
49 Paul Delves 3 Quinton Athletic
50 Akeel Nazir 2 Bordesley FC
51 Andy Bowen 2 St Bernard’s Grange
52 Anthony Fogarty 2 St Bernard’s Grange
53 David Edwards 2 Greenlands Social
54 Gary Owen 2 Norton United
55 James Hughes 2 Widney Wanderers
56 Jerome Branch 2 Bordesley FC
57 Jim Colgan 2 St Bernard’s Grange
58 Joshem Ahmed 2 Bordesley FC
59 Karl Stanley 2 Phoenix Rangers
60 Lee Evans 2 Norton United
61 Lee Reading 2 Yardley Wanderers
62 Mark Cooper 2 Quinton Athletic
63 Mark Werner 2 Quinton Athletic
64 Martin Blake 2 Yardley Wanderers
65 Paul Doona 2 Greenlands Social
66 Richard Dobson 2 Quinton Athletic
67 Richard Pretty 2 Norton United
68 Shaun Watson 2 Greenlands Social
69 Thomas Mallen 2 St Bernard’s Grange
70 Troy Carter 2 St Bernard’s Grange
71 Adam Davies 1 Hall Green Galaxy
72 Adam Roberts 1 Norton United
73 Bradley Little 1 Phoenix Rangers
74 Chris Moran 1 St Bernard’s Grange
75 Christopher Jones 1 Greenlands Social
76 Craig Baker 1 St Bernard’s Grange
77 Darren Hughes 1 Hall Green Galaxy
78 James Edwards 1 Phoenix Rangers
79 Jamie Atkins 1 Greenlands Social
80 Jason Russell 1 Phoenix Rangers
81 Jonathan Wragg 1 Hall Green Galaxy
82 Karl Steele 1 Norton United
83 Keith Howe 1 Yardley Wanderers
84 Lee Colgan 1 St Bernard’s Grange
85 Lee Russell 1 Phoenix Rangers
86 Lee Stock 1 Norton United
87 Liam Burns 1 Norton United
88 Mark Wheeldon 1 Bordesley FC
89 Matthew Imrie 1 Greenlands Social
90 Matthew McQuigg 1 Hall Green Galaxy
91 Michael Fisher 1 Greenlands Social
92 Mohammed Kashif 1 Bordesley FC
93 Richard Fort 1 Norton United

Error at 2020-07-07 19:58:57:

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 = 3 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 2009-2010
Combined Home & Away Results table

Team P W D L F A GD Pts

Solihull & District Oakbourne Football League
DIVISION THREE - SEASON 2009-2010 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 2009-2010

Pos Player Goals Current Team
Sorry record not found!

Error at 2020-07-07 19:58:57:

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 = 3 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 2009-2010
Combined Home & Away Results table

Team P W D L F A GD Pts

Solihull & District Oakbourne Football League
DIVISION FOUR - SEASON 2009-2010 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 2009-2010

Pos Player Goals Current Team
Sorry record not found!