Club Record Results & Runs

SELECT * FROM Cards c INNER JOIN Matches m ON c.crd_date = m.date INNER JOIN Comps b ON m.comp = b.comp_key WHERE m.att >= 1;SELECT date, season, comp, WDL, opponent, HAN, G_For, G_Ag, G_For_ht, G_Ag_ht, scorer1, scorer2, scorer3, scorer4, scorer5, scorer6, scorer7, scorer8, scorer9, scorer10, scorer11 FROM Matches m INNER JOIN Comps c ON m.comp = c.comp_key WHERE m.att >= 1;
-------------------------
5213 rows returned
-------------------------

Match Result Records

Most goals scored : 11
11-1 v Carlisle United(H), Div 3 (N) - 14/01/1939

Biggest winning margin : 10 goals
10-0 v Halifax Town(H), Div 3 (N) - 26/12/1930
11-1 v Carlisle United(H), Div 3 (N) - 14/01/1939

Highest scoring draw : 5-5
5-5 v Bristol City(A), LC - 21/04/2018

Most goals conceded : 8
0-8 v Wolverhampton Wanderers(A), Div 2 - 04/11/1911
0-8 v Wigan Athletic(A), LC - 14/07/2020

Biggest losing margin : -8 goals
0-8 v Wolverhampton Wanderers(A), Div 2 - 04/11/1911
0-8 v Wigan Athletic(A), LC - 14/07/2020

Highest aggregate score : 13 goals scored
10-3 v Wolverhampton Wanderers(H), Div 2 - 27/12/1919

1st Half Records

Most 1st half goals scored : 7
7-0 v Southport(H), Div 3 (N) - 13/01/1938 (FT:10-1)

Biggest 1st half winning margin : 7 goals
7-0 v Southport(H), Div 3 (N) - 13/01/1938 (FT:10-1)

Highest 1st half scoring draw : 3-3
3-3 v Plymouth Argyle(A), Div 2 - 29/08/1934
3-3 v Bristol City(A), Div 2 - 30/09/1967
3-3 v Middlesbrough(H), Div 2 - 11/12/1971

Most 1st half goals conceded : 7
0-7 v Wigan Athletic(A), LC - 14/07/2020

Biggest 1st half losing margin : -7 goals
0-7 v Wigan Athletic(A), LC - 14/07/2020

Highest 1st half aggregate score : 7 goals scored
7-0 v Southport(H), Div 3 (N) - 13/01/1938
0-7 v Wigan Athletic(A), LC - 14/07/2020

2nd Half Records

Most 2nd half goals scored : 8
8-4 v Whitby Town(H), FAC 1R - 26/11/1996

Biggest 2nd half winning margin : 7 goals
7-0 v Carlisle United(H), Div 3 (N) - 14/01/1939

Highest 2nd half scoring draw : 3-3
3-3 v Stockport County(H), Div 3 (N) - 24/09/1938
3-3 v Tranmere Rovers(A), Div 3 (N) - 29/03/1958
3-3 v Sheffield Wednesday(H), Div 2 - 26/12/1970
3-3 v Rotherham United(A), L Div 3 - 28/12/1997
3-3 v Middlesbrough(A), FAC 3R - 16/01/2007
3-3 v Swansea City(H), LC - 14/02/2020

Most 2nd half goals conceded : 6
0-6 v Wolverhampton Wanderers(A), Div 2 - 04/11/1911
1-6 v South Shields(A), Div 2 - 03/01/1920

Biggest 2nd half losing margin : -6 goals
0-6 v Wolverhampton Wanderers(A), Div 2 - 04/11/1911

Highest 2nd half aggregate score : 12 goals scored
8-4 v Whitby Town(H), FAC 1R - 26/11/1996

Best 2nd half turnaround :
HT: 0-1, FT: 5-1 v Gainsborough Trinity(H), Div 2 - 18/09/1909
HT: 0-2, FT: 5-2 v Barnsley(H), Div 2 - 11/10/1924

Worst 2nd half collapse :
HT: 2-1, FT: 2-5 v Huddersfield Town(A), Div 2 - 26/10/1912
HT: 1-0, FT: 1-4 v Grimsby Town(A), Div 2 - 25/11/1933
HT: 2-0, FT: 2-4 v Bristol Rovers(A), Div 2 - 21/01/1956
HT: 1-0, FT: 1-4 v Bradford Park Avenue(A), Div 3 (N) - 17/09/1956
HT: 1-0, FT: 1-4 v Wigan Athletic(A), FAC 3 - 02/01/2010
HT: 1-0, FT: 1-4 v Sheffield United(A), LC - 04/11/2017

Record Sequences

Winning run : 10 games
01/05/1948 to 28/09/1948

Drawing run : 5 games
30/03/1929 to 15/04/1929
08/09/1990 to 25/09/1990
14/02/2012 to 10/03/2012

Losing run : 8 games
07/04/1934 to 08/09/1934

Unbeaten run : 18 games
23/10/1948 to 12/02/1949

Run of Clean Sheets : 6 games
26/09/1908 to 31/10/1908

Scored 1 or more : 25 games
06/10/1956 to 05/03/1957

Run of 0-0 draws : 3 games
02/09/1995 to 12/09/1995

Run without a win : 16 games
15/02/1936 to 02/05/1936
09/01/1988 to 12/04/1988
26/08/1989 to 04/11/1989

Run without a draw : 30 games
27/09/1919 to 27/03/1920

Run without scoring : 6 games
13/11/1920 to 18/12/1920
26/04/1997 to 23/08/1997
14/08/2021 to 14/09/2021

Run without clean sheet : 22 games
14/09/1935 to 01/02/1936
06/10/1990 to 19/01/1991
23/08/2016 to 02/01/2017
04/01/2020 to 22/07/2020

Run without goal-less draw : 151 games
24/04/1965 to 17/08/1968