Archive Tables

Error at 2020-07-07 18:55:35:

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 = 7 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 2013-2014
Combined Home & Away Results table

Team P W D L F A GD Pts

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

Pos Player Goals Current Team
1 Chrisi Conway 23 Conway Albion
2 Jack Ashford 19 Solihull Spartans
3 Paul Whitehead 16 Conway Albion
4 Tom Adams 16 FC Adelaide
5 Lee Hankinson 14 Hall Green Galaxy
6 Cashel McDonald 13 Solihull Town
7 Gareth Hodson 13 Solihull Town
8 Kieran Waddingham 13 Hall Green Athletic
9 Andrew Ford 12 Solihull Spartans
10 Ben Atkins 12 Hall Green Galaxy
11 Rhys Williams 12 Hall Green Galaxy
12 Anthony Savin 10 Solihull Spartans
13 Ashley Cattermole 10 Hall Green Athletic
14 David Ward 10 FC Adelaide
15 DJ Budden 10 FC Adelaide
16 Shaun Knight 10 Billesley F.C.
17 Matt Jordan 9 Conway Albion
18 Ryan Jelley 8 Billesley F.C.
19 Aaron Butt 7 FC Adelaide
20 Alastair Lewis 7 Solihull Town
21 Andrew McGarry 7 Conway Albion
22 Jake Brown 7 Hall Green Athletic
23 Laurence Martin 7 FC Adelaide
24 Lyndon Aleksic 7 Hilton Rangers
25 Matthew Patterson 7 Hilton Rangers
26 Ross Walsh 7 Sporting Phoenix
27 Adam Gray 6 Solihull Spartans
28 Jack Mullen 6 Solihull Town
29 Jon Stephens 6 FC Adelaide
30 Kraig Sarapuk 6 Billesley F.C.
31 Scott Martin 6 Sporting Phoenix
32 Stephen Barrett 6 Solihull Spartans
33 Adam Mitcham 5 Sporting Phoenix
34 Ashley Price 5 Solihull Spartans
35 James Cartwright 5 Hall Green Galaxy
36 Michael Partridge 5 FC Adelaide
37 Richard Simmonds 5 Billesley F.C.
38 Robert Harper 5 Hall Green Galaxy
39 Ben Lindsey 4 Billesley F.C.
40 James Osborne 4 Hall Green Athletic
41 Jonathan Boyce 4 Solihull Town
42 Kristopher Sarapuk 4 Billesley F.C.
43 Paul Meredith 4 Hilton Rangers
44 Ricky Jelley 4 Billesley F.C.
45 Tyran Thunder 4 Hall Green Galaxy
46 Aaron Daly 3 Solihull Town
47 Adam Butler 3 Sporting Phoenix
48 Andrew Hooper 3 FC Adelaide
49 Christopher Poole 3 Billesley F.C.
50 Craig Nolan 3 Conway Albion
51 Danny Wynn 3 Solihull Town
52 Jordan McGrath 3 Sporting Phoenix
53 Luke Wilkins 3 FC Adelaide
54 Nick Conway 3 Conway Albion
55 Rory Barber 3 Sporting Phoenix
Pos Player Goals Current Team
56 Scott Lewis 3 Solihull Spartans
57 Shaun Hoccom 3 Hall Green Galaxy
58 Spencer McCracken 3 Billesley F.C.
59 Tom Kavanagh 3 Sporting Phoenix
60 Zak Lyons 3 Hall Green Athletic
61 Aidan Moore 2 Hilton Rangers
62 Billy Allison 2 Hall Green Athletic
63 Charles McColgan 2 Hall Green Galaxy
64 Chris Caffrey 2 Solihull Spartans
65 Chris Sharp 2 Hilton Rangers
66 Daniel Gleeson 2 Billesley F.C.
67 David Louden 2 Quinton Athletic
68 James Kerr 2 Billesley F.C.
69 Joel Francis 2 Conway Albion
70 Joseph Roberts 2 Hall Green Athletic
71 Kane Daly 2 Solihull Town
72 Luke Hinson 2 Solihull Spartans
73 Luke Kirby 2 Hall Green Galaxy
74 Martin O'Driscoll 2 FC Adelaide
75 Matthew Campbell 2 Solihull Spartans
76 Richard Partridge 2 FC Adelaide
77 Ryan Cope 2 Sporting Phoenix
78 Ryan Froggatt 2 Hall Green Galaxy
79 Ryan Rumley 2 Hall Green Athletic
80 Sam Edwards 2 Sporting Phoenix
81 Steven Lander 2 Solihull Spartans
82 Adam Ball 1 Solihull Spartans
83 Adam Khan 1 Hilton Rangers
84 Christopher McCoy 1 FC Adelaide
85 Craig Ritchie 1 Solihull Town
86 Craig Shipley 1 Solihull Spartans
87 Dan Douras 1 Billesley F.C.
88 Darren Bourne 1 Solihull Town
89 Darren Conway 1 Conway Albion
90 Dean Garey 1 Hall Green Athletic
91 James Walsh 1 Hall Green Athletic
92 Jason Powell 1 Hall Green Athletic
93 James Goggin 1 Hall Green Athletic
94 Joshua Heaven 1 Solihull Town
95 Kieran Melody 1 Hall Green Athletic
96 Leigh Jenkins 1 Hall Green Athletic
97 Liam Conway 1 Conway Albion
98 Luke Ellett 1 FC Adelaide
99 Luke Stanley 1 Quinton Athletic
100 Matt Butler 1 Sporting Phoenix
101 Michael Townsend 1 Hilton Rangers
102 Neil Underwood 1 Solihull Town
103 Noel Walsh 1 Hall Green Athletic
104 Oliver Reeves 1 Quinton Athletic
105 Paul Delves 1 Conway Albion
106 Paul Ford 1 Conway Albion
107 Peter Adkins 1 Billesley F.C.
108 Ryan Cornelius 1 Solihull Spartans
109 Thomas Vincent 1 FC Adelaide
110 TJ Munthali 1 Hall Green Galaxy

Error at 2020-07-07 18:55:35:

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 = 7 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 2013-2014
Combined Home & Away Results table

Team P W D L F A GD Pts

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

Pos Player Goals Current Team
1 Roy Dunkley 61 Meadway Sports
2 Mark Toal 26 Meadway Sports
3 David Hamilton 23 Highgate Dynamos
4 Thomas Campbell 22 Stechford Social
5 Neil Harris 20 Shirley Rovers
6 Andrew Millan 19 Stechford Social
7 Luke Bagagiolo 19 Acocks Green Legion
8 Stuart Lee 19 Meadway Sports
9 Brett Horobin 18 Solihull Lions
10 Clint Andrews 17 Sporting Villa
11 Lewis Sayer 17 Acocks Green Legion
12 Josh Lea 15 Solihull Lions
13 Jack Garey 14 Shirley Town
14 Rees James 14 Kings Norton Athletic
15 Simon Myles 14 Stechford Social
16 Daniel Lynch 12 Kings Norton Athletic
17 Jamie Rossiter 12 Olton Orient
18 Kieran Robotham 12 Highgate Dynamos
19 Mark O'Donnell 12 Stechford Social
20 Nicky Playdon 12 Stechford Social
21 Sean Cooney 12 Sporting Villa
22 Shaun Horobin 12 Solihull Lions
23 Aidan Johnson 11 Sporting Villa
24 Darren Hanson 11 Stechford Social
25 David Barfield 11 Meadway Sports
26 Reece Skeffington 11 Kings Norton Athletic
27 Christopher Lacey 10 Shirley Town
28 Daniel Taylor 10 Shirley Town
29 Luke Scarborough 10 Acocks Green Legion
30 Neil Jenkins 10 Olton Orient
31 Andrew Rowe 9 Highgate Dynamos
32 Andy Toal 9 Meadway Sports
33 Jason Baillie 9 Kings Norton Athletic
34 Ryan Thomas 8 Kings Norton Athletic
35 Joe Mulligan 7 Solihull Lions
36 Lee Woodward 7 Kings Norton Athletic
37 Matthew Levi 7 Kings Norton Athletic
38 Paul Martin 7 Meadway Sports
39 Richard Deans 7 Shirley Rovers
40 Adam Shakespeare 6 Solihull Lions
41 David Hunt 6 Highgate Dynamos
42 Jonny Martin 6 Acocks Green Legion
43 Matthew Watts 6 Grange FC
44 Michael Toms 6 Meadway Sports
45 Adrian Cooney 5 Sporting Villa
46 Andrew Jones 5 Sporting Villa
47 John Barratt 5 Olton Orient
48 John Higgins 5 Shirley Rovers
49 John Treacy 5 Grange FC
50 Martin Hands 5 Acocks Green Legion
51 Michael Cardall 5 Olton Orient
52 Thomas Lacey 5 Shirley Town
53 Alan Holman 4 Acocks Green Legion
54 Andrew Lane 4 Shirley Rovers
55 Ben Adams 4 Coleshill Town
56 Chris Carlile 4 Shirley Rovers
57 Jamie Whitehouse 4 Solihull Lions
58 John Mallon 4 Sporting Villa
59 Michael Gray 4 Kings Norton Athletic
60 Sam Beavan 4 Olton Orient
61 Stuart Kempson 4 Stechford Social
62 Sukhraj Sanghera 4 Solihull Lions
63 Zeeshan Khan 4 Coleshill Town
64 Adam Thomas 3 Stechford Social
65 Alex Masters 3 Coleshill Town
66 Carl Jackson 3 Acocks Green Legion
67 Chris Chamberlain 3 Olton Orient
68 Conor OReilly 3 Coleshill Town
69 Daniel Crook 3 Stechford Social
70 David Walker 3 Coleshill Town
71 Eyob Kidane 3 Coleshill Town
72 Jermaine Pencheon 3 Kings Norton Athletic
73 John Rooke 3 Sporting Villa
74 Matthew Morris 3 Solihull Lions
75 Paul Hope 3 Shirley Town
76 Richard Stone 3 Grange FC
77 Sam Brogan 3 Meadway Sports
78 Shane Baker 3 Highgate Dynamos
Pos Player Goals Current Team
79 Warren Bradley 3 Acocks Green Legion
80 Adam Jones 2 Coleshill Town
81 Andrew Lockyer 2 Solihull Lions
82 Ben Hussain 2 Shirley Town
83 Connor Deards 2 Grange FC
84 Daniel Cotterill 2 Grange FC
85 Daniel Hamilton 2 Grange FC
86 Danny Roberts 2 Coleshill Town
87 Dave Turnbull 2 Acocks Green Legion
88 Dwayne Gayle 2 Grange FC
89 Grantley Reid 2 Grange FC
90 James Evans 2 Acocks Green Legion
91 Keiron Chubb 2 Kings Norton Athletic
92 Kurt Mahoney 2 Highgate Dynamos
93 Mahir Shafiq 2 Coleshill Town
94 Matt Shakespeare 2 Solihull Lions
95 Matthew Barrow 2 Olton Orient
96 Matthew Gorman 2 Acocks Green Legion
97 Matthew Pegg 2 Grange FC
98 Matthias Blake 2 Meadway Sports
99 Mehran Ali 2 Highgate Dynamos
100 Michael Tarbuck 2 Acocks Green Legion
101 Michael Williams 2 Highgate Dynamos
102 Oli Parry 2 Solihull Lions
103 Patrick Fanning 2 Acocks Green Legion
104 Reece Hall 2 Meadway Sports
105 Richard Prosser 2 Highgate Dynamos
106 Robert Memory 2 Olton Orient
107 Ryan Wilson 2 Highgate Dynamos
108 Theo Andrews 2 Sporting Villa
109 Theon Black 2 Kings Norton Athletic
110 Tyron Smith 2 Stechford Social
111 Abdi Mumin 1 Coleshill Town
112 Adam Hemming 1 Coleshill Town
113 Adam Kirby 1 Acocks Green Legion
114 Andrew James 1 Sporting Villa
115 Aran Altay 1 Solihull Lions
116 Ben Forrester 1 Acocks Green Legion
117 Billy Lambie 1 Coleshill Town
118 Blaine O'Reilly 1 Olton Orient
119 Bradley Whitmore 1 Stechford Social
120 Christopher Cooper 1 Shirley Town
121 Colin Atterbury 1 Sporting Villa
122 Daniel Wright 1 Shirley Rovers
123 Dean Hodge 1 Stechford Social
124 Dean Morris 1 Meadway Sports
125 Dwayne Boyce 1 Grange FC
126 Gareth Jolly 1 Acocks Green Legion
127 Glen Harris 1 Shirley Rovers
128 Jake Merchant 1 Grange FC
129 James Clarke 1 Stechford Social
130 James Cottrill 1 Highgate Dynamos
131 James Paul 1 Olton Orient
132 Jared Iwenofu 1 Solihull Lions
133 Jason Gardner 1 Shirley Town
134 Joe Wallace 1 Shirley Town
135 John Smith 1 Coleshill Town
136 Jordan Broadbent 1 Grange FC
137 Jordan Turner 1 Solihull Lions
138 Lei Brown 1 Grange FC
139 Liam Cronin 1 Olton Orient
140 Liam Murphy 1 Shirley Rovers
141 Luke Harris 1 Kings Norton Athletic
142 Marc Miller 1 Shirley Rovers
143 Mark Jones 1 Olton Orient
144 Matthew Sale 1 Solihull Lions
145 Michael Jacques 1 Highgate Dynamos
146 Nathan Jeffers 1 Sporting Villa
147 Nic Cassidy 1 Shirley Rovers
148 Paul King 1 Olton Orient
149 Peter Allen 1 Stechford Social
150 Peter Andrews 1 Coleshill Town
151 Rees Adamson 1 Grange FC
152 Robert Jones 1 Coleshill Town
153 Saran Dar 1 Coleshill Town
154 Simeon Cumberbatch 1 Sporting Villa
155 Simon Jephcott 1 Shirley Rovers
156 William O'Loughlin 1 Stechford Social

Error at 2020-07-07 18:55:35:

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 = 7 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 2013-2014
Combined Home & Away Results table

Team P W D L F A GD Pts

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

Pos Player Goals Current Team
1 Chris Heath 40 Real Norton FC
2 Mark Cass 33 Wythall Juniors OB
3 Matthew Beard 28 Solihull Lodge Athletic
4 Ashley Checketts 27 Wythall Juniors OB
5 Scott Thompson 27 Mitre Athletic
6 Paul Heath 23 Real Norton FC
7 Adam Harris 22 Solihull Astros
8 Daniel Baker 22 MVU FC
9 Matthew Stewart 21 Linden Athletic
10 Gary Thacker 20 Punchbowl FC
11 John Borland 20 St Bernard’s Grange
12 Reece Ward 18 Real Norton FC
13 Carl Lintern 15 Solihull Supernovas
14 Daniel Ward 15 Punchbowl FC
15 Jon Millward 14 Real Norton FC
16 Joe Tilley 13 Linden Athletic
17 Richard Cooper 13 St Bernard’s Grange
18 Richard Craddock 13 Wythall Juniors OB
19 Alex Fleming 12 Wing Jobs FC
20 John Thompson 11 Mitre Athletic
21 Daniel Davies 10 Solihull Lodge Athletic
22 Gregory Jones 10 Wing Jobs FC
23 Kieran Pace 10 Wythall Juniors OB
24 Chris Smith 9 Linden Athletic
25 John Allcott 9 MVU FC
26 Michael Richards 9 MVU FC
27 Nathan Tipper 8 Linden Athletic
28 Paul Webster 8 Linden Athletic
29 Shane Smith 8 Mitre Athletic
30 Steven Bickley 8 Solihull Astros
31 Gary Mattiello 7 MVU FC
32 Jake Scott 7 Shirley Griffs
33 James Brueton 7 Real Norton FC
34 Mark Craddock 7 Wythall Juniors OB
35 Brad Davies 6 St Bernard’s Grange
36 Christopher Watkins 6 Solihull Lodge Athletic
37 Daniel Buss 6 Solihull Lodge Athletic
38 James Evans 6 Linden Athletic
39 Josh Taylor 6 Solihull Lodge Athletic
40 Richard Bamber 6 Punchbowl FC
41 Ryan Percival 6 Linden Athletic
42 Sam Beattie 6 Solihull Supernovas
43 Anthony Steeles 5 Wing Jobs FC
44 Daniel Southall 5 Wythall Juniors OB
45 James Hannon 5 Mitre Athletic
46 Jordan Mills 5 Mitre Athletic
47 Mark Cooper 5 Wing Jobs FC
48 Mark Rollins 5 Wythall Juniors OB
49 Neil Sunner 5 St Bernard’s Grange
50 Sam Whitby 5 Shirley Griffs
51 Simon Cooper 5 St Bernard’s Grange
52 Chris Moran 4 St Bernard’s Grange
53 Cyrol Pryce 4 MVU FC
54 Kieron Dunn 4 Mitre Athletic
55 Luke Alexander 4 MVU FC
56 Paul Stephenson 4 Solihull Astros
57 Ross Firth 4 Solihull Supernovas
58 Sean Clarke 4 Shirley Griffs
59 Sean Mahon 4 Wing Jobs FC
60 Thomas Willott 4 Solihull Supernovas
61 Tyrone Greaves 4 Punchbowl FC
62 Wesley Tasker 4 Solihull Supernovas
63 Adam Wynn 3 Solihull Astros
64 Adam Wynne 3 Solihull Supernovas
65 Alexander Wilkins 3 Linden Athletic
66 Ben Mansell 3 Solihull Astros
67 Benn Horrobin 3 St Bernard’s Grange
68 Casey Vollrath 3 Wythall Juniors OB
69 Chris Lawlor 3 Solihull Astros
70 Gary Maddocks 3 MVU FC
71 Jeevon Sin 3 Shirley Griffs
72 John Hughes 3 Punchbowl FC
Pos Player Goals Current Team
73 Josh Sidwell 3 Solihull Lodge Athletic
74 Michael Kinsella 3 MVU FC
75 Sam Smith 3 Real Norton FC
76 Sami Mian 3 Shirley Griffs
77 Sean Cunningham 3 Solihull Astros
78 Tom Masters 3 Shirley Griffs
79 Vincent Hatfield 3 Wythall Juniors OB
80 Aaron Paul 2 St Bernard’s Grange
81 Aarron Jones 2 Mitre Athletic
82 Anthony Hughes 2 Mitre Athletic
83 Craig Jagger 2 Real Norton FC
84 Craig Reeves 2 Real Norton FC
85 Daniel Ward 2 Real Norton FC
86 James Coe 2 Solihull Astros
87 Jamie Powell 2 Wing Jobs FC
88 Jason Jagger 2 Real Norton FC
89 Josh Brown 2 Shirley Griffs
90 Karl Jones 2 Shirley Griffs
91 Noel McWhirter 2 MVU FC
92 Samuel Regan 2 Solihull Lodge Athletic
93 Stephen Wicklen 2 Linden Athletic
94 Stuart Roberts 2 Solihull Supernovas
95 Thomas Williams 2 Linden Athletic
96 Tom Storer 2 Solihull Lodge Athletic
97 Tom Sturdy 2 Solihull Lodge Athletic
98 Aaron Harris 1 Wythall Juniors OB
99 Adam McConkey 1 Wing Jobs FC
100 Adam Morroll 1 Real Norton FC
101 Adam Pugh 1 Solihull Astros
102 Anthony Friar 1 Punchbowl FC
103 Ashley Pardoe 1 Wythall Juniors OB
104 Ben Strahan 1 Wythall Juniors OB
105 Cal Mooney 1 Punchbowl FC
106 Dale Harrison 1 Solihull Supernovas
107 Dan Mian 1 Shirley Griffs
108 Daniel Caddick 1 Punchbowl FC
109 David Pugh 1 Solihull Astros
110 David Stott 1 Solihull Astros
111 Dean Bayliss 1 Linden Athletic
112 Gary Rourke 1 Punchbowl FC
113 George Goodwin 1 Real Norton FC
114 Jack Ingram 1 Wing Jobs FC
115 Jack Thomas 1 Wing Jobs FC
116 James Morris 1 Solihull Lodge Athletic
117 James Watkins 1 Solihull Lodge Athletic
118 Jerome Greaves 1 Punchbowl FC
119 Joe Ghazanfar 1 MVU FC
120 John Brooks 1 Mitre Athletic
121 Kamran Din 1 Shirley Griffs
122 Lawton Bailey 1 Linden Athletic
123 Lewis Best 1 Linden Athletic
124 Luke Edmonds 1 Solihull Astros
125 Marcus King 1 Wythall Juniors OB
126 Mark Jackson 1 St Bernard’s Grange
127 Matthew Belcher 1 Solihull Astros
128 Michael Rose 1 Real Norton FC
129 Mieszko Jaskiewicz 1 Solihull Astros
130 Nathan Kirkland 1 MVU FC
131 Nyle Thomas 1 Punchbowl FC
132 Paul Walton 1 Wing Jobs FC
133 Peter Marshall 1 Punchbowl FC
134 Peter Robinson 1 Solihull Lodge Athletic
135 Richard Kerrigan 1 Wing Jobs FC
136 Roy Winterbottom 1 Shirley Griffs
137 Scott Donegan 1 Punchbowl FC
138 Sean McAvoy 1 Punchbowl FC
139 Stephen Jones 1 MVU FC
140 Stephen O'Farrell 1 Punchbowl FC
141 Steven Green 1 Punchbowl FC
142 Thomas Winter 1 Solihull Supernovas
143 Tommy Duggan 1 MVU FC
144 Tristan Perry 1 Wythall Juniors OB

Error at 2020-07-07 18:55:36:

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 = 7 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 2013-2014
Combined Home & Away Results table

Team P W D L F A GD Pts

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

Pos Player Goals Current Team
1 Jamie Smith 71 Shirley Town Dynamos
2 Ben Huskisson 39 Dingle FC
3 Georgio Panayiotou 33 Sporting Brockhurst
4 Andrew Stockton 30 Dingle FC
5 Bradley Hall 30 Shirley Town Dynamos
6 Andy Bowen 27 Kitts Green FCB
7 James Murphy 22 BC United
8 Ryan Reynolds 16 Cole Bank Rangers
9 Aidan Hearfield 15 Dickens Heath
10 Alix Hayward 15 Cole Bank Rangers
11 Ben Pickford 14 Stechford Bees
12 James Hoad 14 Dickens Heath
13 Thomas Cleaver 13 Kitts Green FCB
14 Ashley Basnett 12 Stechford Bees
15 Scott Hutchison 12 Dingle FC
16 Thomas Brazil 12 Kings Norton Celtic
17 Jack Jeffcott 11 BC United
18 James Read 10 Sporting Brockhurst
19 Joseph Breslin 10 BC United
20 Philip Breslin 10 BC United
21 Brett Gilbert 9 Shirley Town Dynamos
22 Daniel Bolan 9 Kings Norton Celtic
23 Eamon Mahon 9 BC United
24 James Coyne 9 Kings Norton Celtic
25 Julian Brydson 9 Cole Bank Rangers
26 Thomas Hughes 9 Fieldhouse
27 Daniel Faithfullll 8 Sporting Brockhurst
28 Daniel ODonnell 8 HGC FC
29 Jamie Wheeler 8 Sporting Brockhurst
30 John Clyne 8 Sporting Brockhurst
31 Michael Varley 8 Cole Bank Rangers
32 Ryan Moore 8 HGC FC
33 Sean Timlin 8 HGC FC
34 Brett Woodcock 7 Cole Bank Rangers
35 Courtney Miller 7 Kings Norton Celtic
36 Daniel Hughes 7 Fieldhouse
37 Matt Ryan 7 Kings Norton Celtic
38 Tony Bates 7 Dickens Heath
39 Marco Doddato 6 Cole Bank Rangers
40 Michael Yapp 6 Sporting Brockhurst
41 Mikey Corrigan 6 Fieldhouse
42 Rory Perry 6 Shirley Town Dynamos
43 Thomas Breslin 6 BC United
44 Thomas Wall 6 HGC FC
45 Andrew Cumiskey 5 Dingle FC
46 Daniel Furnell 5 Dickens Heath
47 David Seel 5 Cole Bank Rangers
48 James White 5 Dickens Heath
49 Jason Porter 5 BC United
50 Richard Pretty 5 Kings Norton Celtic
51 Sam Tyler 5 Dickens Heath
52 Alex Pavey 4 Sporting Brockhurst
53 Chris Bishop 4 Kings Norton Celtic
54 Christopher Gould 4 Kitts Green FCB
55 Connor Drury 4 Shirley Town Dynamos
56 Daniel Smith 4 Dickens Heath
57 Harry Chiles 4 Dickens Heath
58 Jake Chinn 4 Dingle FC
59 James Giblin 4 Shirley Town Dynamos
60 Joel Mardenborough 4 Cole Bank Rangers
61 Josh Parkes 4 Cole Bank Rangers
62 Lawrence Smith 4 HGC FC
63 Anthony Fogarty 3 Kitts Green FCB
64 Callum Hewitt 3 Dingle FC
65 Cameron Clark 3 Dickens Heath
66 Craig Baker 3 Kitts Green FCB
67 Daniel Meredith 3 Dingle FC
68 Jack Doyle 3 HGC FC
69 James Mason 3 Stechford Bees
70 Kane Cartlidge 3 Cole Bank Rangers
71 Nathan Brown 3 Kings Norton Celtic
72 Philip Doyle 3 BC United
73 Shane Thomas 3 Kitts Green FCB
Pos Player Goals Current Team
74 Aaron Price 2 Shirley Town Dynamos
75 Andrew Ellis 2 Cole Bank Rangers
76 Ben Surti 2 Shirley Town Dynamos
77 Bret Clowes 2 Kings Norton Celtic
78 Charlie Harris 2 Cole Bank Rangers
79 Colin Hutchison 2 Dingle FC
80 Dan Gray 2 Dingle FC
81 Daniel Vickery 2 Sporting Brockhurst
82 Dominic Landucci 2 Kings Norton Celtic
83 Graham Woodward 2 Dickens Heath
84 Harry March 2 Fieldhouse
85 Jack Duffy 2 Shirley Town Dynamos
86 Jack Sturdy 2 Shirley Town Dynamos
87 Jordan Fish 2 Stechford Bees
88 Joshua Michael 2 Cole Bank Rangers
89 Mark Allbutt 2 Dingle FC
90 Michael Fellows 2 Kitts Green FCB
91 Michael Reynolds 2 HGC FC
92 Owen Ralph 2 Fieldhouse
93 Peter Murphy 2 BC United
94 Reece Quinn 2 Kitts Green FCB
95 Ross Richards 2 Stechford Bees
96 Scott Byrne 2 Stechford Bees
97 Sean Carney 2 BC United
98 Thomas Hopkins 2 Stechford Bees
99 Aarondeep Padam 1 Dingle FC
100 Aman Sohanta 1 Cole Bank Rangers
101 Andrew Bell 1 Dingle FC
102 Ben Riding 1 Kitts Green FCB
103 Benjamin Dowling 1 HGC FC
104 Carlo Marshall 1 Dickens Heath
105 Chris Powell 1 Cole Bank Rangers
106 Conor McCarthy E/Goalkeeper 1 Fieldhouse
107 Daniel Hawkins 1 Kings Norton Celtic
108 Daniel O'Brien 1 Sporting Brockhurst
109 David Carter 1 HGC FC
110 David Pigott 1 HGC FC
111 Dominic Ryan 1 Stechford Bees
112 Gorvinder Rai 1 Sporting Brockhurst
113 Hugh Maguire 1 BC United
114 James Brooks 1 Stechford Bees
115 James Locker 1 Fieldhouse
116 James Lyons 1 Cole Bank Rangers
117 Josh Gunter 1 Cole Bank Rangers
118 Kane Law 1 Stechford Bees
119 Karl Green 1 Stechford Bees
120 Kieran Burbidge 1 Stechford Bees
121 Laurence Cole 1 Kings Norton Celtic
122 Lee Ware 1 Kings Norton Celtic
123 Leonard Smith 1 Stechford Bees
124 Luke Bridson 1 Kings Norton Celtic
125 Luke Johnson 1 Shirley Town Dynamos
126 Luke Smith 1 HGC FC
127 Martin Bentley 1 Fieldhouse
128 Matt Stephens 1 Shirley Town Dynamos
129 Matthew Brydson 1 Cole Bank Rangers
130 Matthew Daly 1 Dingle FC
131 Michael Iommi 1 HGC FC
132 Nathan Smith 1 Shirley Town Dynamos
133 Nicholas Georgiou 1 Dickens Heath
134 Patrick McEvoy 1 BC United
135 Patrick McEvoy 1 Cole Bank Rangers
136 Rich Storer 1 Dickens Heath
137 Richard Parsonage 1 HGC FC
138 Ronnie Smith 1 HGC FC
139 Stephen Nurrish 1 HGC FC
140 Steven Sargent 1 BC United
141 Stuart Brookes 1 Dingle FC
142 Stuart Malin 1 Dickens Heath
143 Thomas Carney 1 BC United
144 Thomas Holton 1 Kings Norton Celtic
145 Tim Garnett 1 Fieldhouse

Error at 2020-07-07 18:55:36:

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 = 7 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 2013-2014
Combined Home & Away Results table

Team P W D L F A GD Pts

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

Pos Player Goals Current Team
Sorry record not found!