SELECT * FROM 1_Kampe WHERE LigaID = '120' AND (Home='Spezia' OR Away='Spezia') 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-26

Spezia

1-1

Salernitana

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

Latina

0-0

Spezia

1/-3

5,00

0.00/1

0.00/1

0.00/0

0.00/1

1/0

2,00

1.00/1

1.00/1

1.00/1

0.00/0

2016-09-11

Ternana

1-1

Spezia

1/-1

1,50

1.50/2

1.50/2

3.00/1

0.00/1

1/0

1,00

1.00/2

1.00/2

1.00/1

1.00/1

2016-09-17

Spezia

2-1

Pro Vercelli

2/0

1,33

1.00/3

1.00/3

1.00/1

1.00/2

3/-4

3,33

0.67/3

0.67/3

0.50/2

1.00/1

2016-09-20

Trapani

0-0

Spezia

4/0

2,00

1.00/4

1.00/4

1.00/2

1.00/2

4/1

1,75

1.50/4

1.50/4

2.00/2

1.00/2

2016-09-24

Spezia

1-0

Novara

4/1

1,40

1.40/5

1.40/5

2.00/2

1.00/3

6/-2

2,80

1.00/5

1.00/5

1.67/3

0.00/2

2016-10-02

Ascoli

0-2

Spezia

6/1

1,83

1.17/6

1.17/6

1.67/3

0.67/3

5/2

1,33

1.67/6

1.67/6

2.33/3

1.00/3

2016-10-09

Spezia

0-1

Carpi

7/4

1,43

1.86/7

1.86/7

2.33/3

1.50/4

8/2

2,00

1.43/7

1.43/7

1.50/4

1.33/3

2016-10-15

Avellino

1-0

Spezia

5/-7

2,13

0.75/8

0.75/8

1.25/4

0.25/4

7/3

1,38

1.63/8

1.63/8

1.75/4

1.50/4

2016-10-21

Spezia

2-0

Brescia

7/2

1,33

1.44/9

1.50/8

1.75/4

1.20/5

13/4

2,44

1.33/9

1.38/8

1.40/5

1.25/4

2016-10-24

Spezia

1-1

Cittadella

9/4

1,40

1.60/10

1.75/8

2.00/5

1.20/5

17/5

2,90

1.80/10

1.50/8

1.20/5

2.40/5

2016-10-29

Benevento

1-0

Spezia

15/6

2,18

1.45/11

1.13/8

2.20/5

0.83/6

10/4

1,45

1.55/11

1.75/8

1.83/6

1.20/5

2016-11-05

Spezia

1-4

Verona

10/3

1,42

1.42/12

1.38/8

1.83/6

1.00/6

27/18

3,00

2.25/12

2.50/8

2.67/6

1.83/6

2016-11-13

Bari

1-1

Spezia

13/-2

2,15

1.23/13

1.00/8

1.67/6

0.86/7

11/0

1,69

1.31/13

1.25/8

1.57/7

1.00/6

2016-11-19

Spezia

1-0

Cesena

12/0

1,71

1.29/14

1.00/8

1.57/7

1.00/7

12/-2

1,86

0.93/14

0.88/8

1.43/7

0.43/7

2016-11-25

Entella

1-1

Spezia

21/6

2,57

1.64/14

1.88/8

2.43/7

0.86/7

13/1

1,67

1.40/15

1.00/8

1.75/8

1.00/7

2016-12-03

Spezia

0-0

Frosinone

14/1

1,69

1.38/16

1.13/8

1.75/8

1.00/8

23/7

2,44

1.94/16

2.50/8

2.22/9

1.57/7

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

Spezia

2-1

Perugia

15/0

1,67

1.28/18

0.88/8

1.67/9

0.89/9

23/8

2,11

1.61/18

1.63/8

1.67/9

1.56/9

2016-12-24

Pisa

0-0

Spezia

7/-4

0,95

1.05/19

0.75/8

1.56/9

0.60/10

17/1

1,74

1.37/19

1.13/8

1.80/10

0.89/9

2016-12-28

Spezia

0-0

L.R. Vicenza

17/1

1,65

1.35/20

1.25/8

1.80/10

0.90/10

16/-9

2,05

1.20/20

1.75/8

1.10/10

1.30/10

2017-01-22

Salernitana

1-0

Spezia

26/-1

2,52

1.14/21

1.38/8

1.60/10

0.73/11

17/1

1,57

1.33/21

1.38/8

1.73/11

0.90/10

2017-01-30

Spezia

3-2

Latina

17/0

1,55

1.27/22

1.25/8

1.73/11

0.82/11

24/-1

2,23

1.18/22

1.25/8

1.55/11

0.82/11

2017-02-04

Spezia

2-0

Ternana

20/1

1,70

1.35/23

1.25/8

1.83/12

0.82/11

21/-10

2,26

1.00/23

1.00/8

1.50/12

0.45/11

2017-02-11

Pro Vercelli

0-2

Spezia

21/-8

2,17

1.09/23

1.13/8

1.67/12

0.45/11

22/3

1,71

1.42/24

1.50/8

1.92/13

0.82/11

2017-02-18

Spezia

2-2

Trapani

24/5

1,72

1.48/25

1.75/8

1.92/13

1.00/12

20/-15

2,20

0.84/25

1.25/8

1.00/13

0.67/12

2017-02-25

Novara

2-1

Spezia

30/0

2,31

1.31/26

1.50/8

1.92/13

0.69/13

26/5

1,81

1.46/26

1.88/8

1.86/14

1.00/12

2017-02-28

Spezia

2-1

Ascoli

27/4

1,85

1.41/27

1.50/8

1.86/14

0.92/13

32/-2

2,44

1.26/27

1.38/8

1.23/13

1.29/14

2017-03-04

Carpi

1-0

Spezia

26/-2

1,93

1.32/28

0.63/8

1.46/13

1.20/15

29/5

1,89

1.46/28

1.75/8

1.93/15

0.92/13

2017-03-11

Spezia

2-1

Avellino

29/4

1,86

1.41/29

1.63/8

1.93/15

0.86/14

28/-10

2,28

1.24/29

1.88/8

1.67/15

0.79/14

2017-03-18

Brescia

1-1

Spezia

32/-11

2,50

1.03/30

0.50/8

1.71/14

0.44/16

31/5

1,90

1.47/30

2.00/8

2.00/16

0.86/14

2017-03-25

Cittadella

1-0

Spezia

42/1

2,68

1.42/31

0.88/8

1.81/16

1.00/15

32/5

1,90

1.45/31

1.75/8

2.00/16

0.87/15

2017-04-01

Spezia

1-3

Benevento

32/4

1,88

1.41/32

1.38/8

2.00/16

0.81/16

42/11

2,28

1.53/32

1.00/8

2.06/17

0.93/15

2017-04-04

Verona

0-1

Spezia

51/19

2,52

1.76/33

1.63/8

2.12/17

1.38/16

33/2

1,94

1.36/33

1.00/8

1.88/17

0.81/16

2017-04-08

Spezia

1-0

Bari

34/3

1,91

1.41/34

1.25/8

1.88/17

0.94/17

37/2

2,12

1.47/34

1.63/8

2.11/18

0.75/16

2017-04-17

Cesena

1-0

Spezia

40/-2

2,34

1.11/35

1.25/8

1.59/17

0.67/18

35/4

1,89

1.46/35

1.63/8

1.94/18

0.94/17

2017-04-22

Spezia

2-0

Entella

35/3

1,86

1.42/36

1.25/8

1.94/18

0.89/18

49/8

2,50

1.42/36

1.50/8

2.11/18

0.72/18

2017-04-25

Frosinone

2-0

Spezia

48/10

2,32

1.68/37

1.13/8

2.06/18

1.32/19

37/5

1,86

1.46/37

1.63/8

2.00/19

0.89/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-05

Perugia

0-0

Spezia

49/13

2,18

1.54/39

1.63/8

1.63/19

1.45/20

37/3

1,82

1.41/39

1.25/8

1.95/20

0.84/19

2017-05-13

Spezia

0-0

Pisa

37/3

1,78

1.40/40

1.38/8

1.95/20

0.85/20

23/-10

1,40

0.95/40

0.38/8

1.15/20

0.75/20

2017-05-18

L.R. Vicenza

0-1

Spezia

33/-18

2,05

1.00/41

0.88/8

1.05/20

0.95/21

37/3

1,73

1.39/41

1.50/8

1.90/21

0.85/20

2018-10-21

AC Carpi

1-3

Spezia

79/2

4,00

1.54/39

1.88/8

0.00/19

3.00/20

38/4

1,71

1.43/42

1.50/8

1.90/21

0.95/21

2018-10-21

Spezia

1-3

AC Carpi

41/6

1,77

1.47/43

1.50/8

1.90/21

1.05/22

36/0

4,00

1.50/18

1.88/8

0.00/9

3.00/9