SELECT * FROM 1_Kampe WHERE LigaID = '120' AND (Home='Spal' OR Away='Spal') ORDER BY Dato ASC;

Dato

Home

Score

Away

H Goals/Dif

A Goals Av.

H Avp/M

H Avp Last/M

H Avp Home/M

H Avp Away/M

A Goals/Dif

A Goals Av.

A Avp/M

A Avp Last/M

A Avp Home/M

A Avp Away/M

2016-08-27

Benevento

2-0

Spal

0/0

0,00

0.00/0

0.00/0

0.00/0

0.00/0

0/0

0,00

0.00/0

0.00/0

0.00/0

0.00/0

2016-09-04

Spal

3-0

L.R. Vicenza

0/-2

2,00

0.00/1

0.00/1

0.00/0

0.00/1

0/-2

2,00

0.00/1

0.00/1

0.00/1

0.00/0

2016-09-10

Ascoli

1-1

Spal

1/0

2,00

1.00/1

1.00/1

0.00/0

1.00/1

3/1

2,50

1.50/2

1.50/2

3.00/1

0.00/1

2016-09-17

Spal

2-2

Entella

4/1

2,33

1.33/3

1.33/3

3.00/1

0.50/2

2/0

1,33

1.33/3

1.33/3

2.00/2

0.00/1

2016-09-20

Spal

1-3

Verona

6/1

2,75

1.25/4

1.25/4

2.00/2

0.50/2

8/3

3,25

1.75/4

1.75/4

3.00/2

0.50/2

2016-09-26

Perugia

1-0

Spal

4/-2

2,00

0.60/5

0.60/5

0.50/2

0.67/3

7/-1

3,00

1.00/5

1.00/5

1.33/3

0.50/2

2016-10-01

Spal

3-2

Salernitana

7/-2

2,67

0.83/6

0.83/6

1.33/3

0.33/3

6/0

2,00

1.00/6

1.00/6

1.33/3

0.67/3

2016-10-09

Pisa

0-1

Spal

5/2

1,14

1.71/7

1.71/7

3.00/3

0.75/4

10/-1

3,00

1.14/7

1.14/7

1.75/4

0.33/3

2016-10-14

Cesena

1-1

Spal

5/-1

1,38

1.00/8

1.00/8

1.50/4

0.50/4

11/0

2,75

1.38/8

1.38/8

1.75/4

1.00/4

2016-10-22

Spal

3-1

Carpi

12/0

2,67

1.33/9

1.50/8

1.75/4

1.00/5

11/5

1,89

1.78/9

1.63/8

1.80/5

1.75/4

2016-10-25

Frosinone

2-1

Spal

12/1

2,30

1.50/10

1.50/8

2.00/5

1.00/5

15/2

2,80

1.50/10

1.50/8

2.00/5

1.00/5

2016-10-31

Spal

3-0

Avellino

16/1

2,82

1.36/11

1.38/8

2.00/5

0.83/6

7/-6

1,82

1.09/11

1.25/8

1.83/6

0.20/5

2016-11-05

Novara

0-1

Spal

13/-3

2,42

1.17/12

1.25/8

2.33/6

0.00/6

19/4

2,83

1.50/12

1.63/8

2.17/6

0.83/6

2016-11-12

Spal

3-2

Brescia

20/5

2,69

1.62/13

2.00/8

2.17/6

1.14/7

18/0

2,77

1.38/13

1.50/8

1.86/7

0.83/6

2016-11-21

Trapani

1-1

Spal

8/-11

1,93

0.71/14

0.63/8

1.00/7

0.43/7

23/6

2,86

1.71/14

2.38/8

2.29/7

1.14/7

2016-11-26

Spal

0-0

Latina

24/6

2,80

1.67/15

2.13/8

2.29/7

1.13/8

17/-3

2,47

1.13/15

1.50/8

1.57/7

0.75/8

2016-12-03

Cittadella

1-2

Spal

27/9

2,81

1.75/16

1.25/8

1.88/8

1.63/8

24/6

2,63

1.63/16

1.88/8

2.13/8

1.13/8

2016-12-10

Spal

2-1

Spezia

26/7

2,65

1.71/17

2.13/8

2.13/8

1.33/9

14/1

1,59

1.35/17

1.25/8

1.67/9

1.00/8

2016-12-17

Pro Vercelli

3-1

Spal

14/-9

2,06

1.00/18

0.75/8

1.56/9

0.44/9

28/8

2,67

1.78/18

2.13/8

2.22/9

1.33/9

2016-12-24

Spal

4-0

Ternana

29/6

2,74

1.68/19

2.13/8

2.22/9

1.20/10

20/-5

2,37

1.05/19

1.38/8

1.50/10

0.56/9

2016-12-29

Bari

1-1

Spal

21/2

2,00

1.40/20

1.50/8

2.00/10

0.80/10

33/10

2,80

1.75/20

2.13/8

2.30/10

1.20/10

2017-01-21

Spal

2-0

Benevento

34/10

2,76

1.71/21

1.88/8

2.30/10

1.18/11

28/14

2,00

1.76/21

1.88/8

2.45/11

1.00/10

2017-01-28

L.R. Vicenza

1-1

Spal

16/-9

1,86

1.18/22

1.63/8

1.10/10

1.25/12

36/12

2,73

1.77/22

1.88/8

2.36/11

1.18/11

2017-02-04

Spal

1-1

Ascoli

37/12

2,70

1.74/23

1.88/8

2.36/11

1.17/12

23/-2

2,18

1.27/22

1.63/8

1.20/10

1.33/12

2017-02-11

Entella

0-3

Spal

36/7

2,71

1.42/24

1.13/8

2.27/11

0.69/13

38/12

2,67

1.71/24

1.88/8

2.25/12

1.17/12

2017-02-20

Verona

0-0

Spal

44/15

2,92

1.80/25

1.38/8

2.31/13

1.25/12

41/15

2,68

1.76/25

1.88/8

2.25/12

1.31/13

2017-02-25

Spal

2-0

Perugia

41/15

2,58

1.73/26

1.63/8

2.25/12

1.29/14

33/8

2,23

1.50/26

1.25/8

1.62/13

1.38/13

2017-02-28

Salernitana

1-2

Spal

29/-2

2,22

1.19/27

1.38/8

1.62/13

0.79/14

43/17

2,56

1.78/27

2.00/8

2.31/13

1.29/14

2017-03-04

Spal

1-1

Pisa

45/18

2,57

1.82/28

2.00/8

2.31/13

1.40/15

15/-2

1,14

1.14/28

1.38/8

1.50/14

0.79/14

2017-03-11

Spal

2-0

Cesena

46/18

2,55

1.79/29

2.00/8

2.21/14

1.40/15

35/-1

2,45

1.07/29

1.13/8

1.57/14

0.60/15

2017-03-18

Carpi

1-4

Spal

28/0

1,87

1.43/30

1.25/8

1.57/14

1.31/16

48/20

2,53

1.83/30

2.00/8

2.27/15

1.40/15

2017-03-26

Spal

0-2

Frosinone

52/23

2,61

1.87/31

2.25/8

2.27/15

1.50/16

41/11

2,29

1.81/31

1.88/8

2.25/16

1.33/15

2017-03-31

Avellino

1-0

Spal

31/-14

2,38

1.16/32

1.38/8

1.63/16

0.69/16

52/21

2,59

1.81/32

2.13/8

2.13/16

1.50/16

2017-04-04

Spal

2-0

Novara

52/20

2,55

1.76/33

1.75/8

2.13/16

1.41/17

37/2

2,18

1.39/33

1.88/8

1.88/17

0.88/16

2017-04-09

Brescia

1-3

Spal

37/-11

2,50

1.03/34

0.88/8

1.63/16

0.50/18

54/22

2,53

1.79/34

2.00/8

2.18/17

1.41/17

2017-04-17

Spal

2-1

Trapani

57/24

2,57

1.83/35

2.00/8

2.18/17

1.50/18

38/-8

2,40

1.09/35

1.63/8

1.28/18

0.88/17

2017-04-22

Latina

1-2

Spal

32/-11

2,08

0.92/36

0.38/8

1.06/18

0.78/18

59/25

2,58

1.86/36

2.00/8

2.22/18

1.50/18

2017-04-25

Spal

2-1

Cittadella

61/26

2,59

1.89/37

2.25/8

2.22/18

1.58/19

50/6

2,54

1.54/37

1.75/8

2.00/19

1.06/18

2017-04-29

Spezia

0-0

Spal

37/3

1,87

1.42/38

1.25/8

2.00/19

0.84/19

63/27

2,61

1.92/38

2.25/8

2.26/19

1.58/19

2017-05-07

Spal

0-0

Pro Vercelli

63/27

2,54

1.90/39

2.00/8

2.26/19

1.55/20

32/-9

1,87

1.21/39

1.63/8

1.45/20

0.95/19

2017-05-13

Ternana

2-1

Spal

38/-13

2,23

1.08/40

1.75/8

1.55/20

0.60/20

63/27

2,48

1.88/40

2.13/8

2.20/20

1.55/20

2017-05-18

Spal

2-1

Bari

64/26

2,49

1.83/41

2.13/8

2.20/20

1.48/21

38/-4

1,95

1.29/41

0.75/8

1.86/21

0.70/20

2018-10-21

AC Carpi

1-3

Spal

64/0

4,00

1.50/32

1.88/8

0.00/16

3.00/16

66/27

2,50

1.86/42

2.13/8

2.24/21

1.48/21

2018-10-21

Spal

1-3

AC Carpi

69/29

2,53

1.88/43

1.75/8

2.24/21

1.55/22

23/2

4,00

1.64/11

1.88/8

0.00/5

3.00/6