Club Record Results & Runs

SELECT * FROM Cards c INNER JOIN Matches m ON c.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, 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;
-------------------------
5201 rows returned
-------------------------

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