SELECT * FROM 1_Kampe WHERE LigaID = '121' 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

2015-09-06

Bari

4-3

Spezia

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

2015-09-13

Spezia

1-1

Pro Vercelli

3/-1

7,00

0.00/1

0.00/1

0.00/0

0.00/1

2/1

3,00

3.00/1

3.00/1

3.00/1

0.00/0

2015-09-19

Salernitana

0-2

Spezia

5/2

4,00

2.00/2

2.00/2

3.00/1

1.00/1

4/-1

4,50

0.50/2

0.50/2

1.00/1

0.00/1

2015-09-22

Spezia

1-0

Perugia

6/1

3,67

1.33/3

1.33/3

1.00/1

1.50/2

3/1

1,67

1.33/3

1.33/3

2.00/2

0.00/1

2015-09-26

Livorno

1-2

Spezia

12/8

4,00

3.00/4

3.00/4

3.00/2

3.00/2

7/2

3,00

1.75/4

1.75/4

2.00/2

1.50/2

2015-10-03

Lanciano

0-0

Spezia

4/0

1,60

1.00/5

1.00/5

2.00/2

0.33/3

9/3

3,00

2.00/5

2.00/5

2.00/2

2.00/3

2015-10-11

Spezia

1-0

Ternana

9/3

2,50

1.83/6

1.83/6

2.00/2

1.75/4

6/-4

2,67

0.67/6

0.67/6

1.33/3

0.00/3

2015-10-19

Cesena

5-1

Spezia

10/4

2,29

1.86/7

1.86/7

3.00/3

1.00/4

10/4

2,29

2.00/7

2.00/7

2.33/3

1.75/4

2015-10-24

Spezia

1-1

Avellino

11/0

2,75

1.75/8

1.75/8

2.33/3

1.40/5

10/-5

3,13

0.75/8

0.75/8

1.25/4

0.25/4

2015-10-27

Modena

1-1

Spezia

6/-6

2,00

1.11/9

1.25/8

1.80/5

0.25/4

12/0

2,67

1.67/9

1.88/8

2.00/4

1.40/5

2015-11-01

Spezia

0-0

Entella

13/0

2,60

1.60/10

1.88/8

2.00/4

1.33/6

7/-3

1,70

1.20/10

1.13/8

2.00/5

0.40/5

2015-11-07

Trapani

5-1

Spezia

12/-3

2,45

1.18/11

1.00/8

1.33/6

1.00/5

13/0

2,36

1.55/11

1.63/8

1.80/5

1.33/6

2015-11-15

Spezia

0-3

Cagliari

14/-4

2,67

1.42/12

1.25/8

1.80/5

1.14/7

24/14

2,83

2.17/12

2.00/8

3.00/7

1.00/5

2015-11-21

Novara

1-0

Spezia

13/4

1,69

1.62/13

2.00/8

2.17/6

1.14/7

14/-7

2,69

1.31/13

0.88/8

1.50/6

1.14/7

2015-11-27

Spezia

0-1

Crotone

14/-8

2,57

1.21/14

0.75/8

1.50/6

1.00/8

25/12

2,71

2.00/14

1.88/8

2.71/7

1.29/7

2015-12-05

Pescara

2-2

Spezia

21/3

2,60

1.60/15

1.88/8

2.29/7

1.00/8

14/-9

2,47

1.13/15

0.38/8

1.29/7

1.00/8

2015-12-09

Spezia

1-0

L.R. Vicenza

16/-9

2,56

1.13/16

0.50/8

1.29/7

1.00/9

19/1

2,31

1.25/16

1.13/8

1.13/8

1.38/8

2015-12-12

Spezia

2-1

Latina

17/-8

2,47

1.24/17

0.75/8

1.50/8

1.00/9

21/-1

2,53

1.18/17

0.88/8

1.75/8

0.67/9

2015-12-19

Brescia

1-1

Spezia

28/4

2,89

1.67/18

2.00/8

2.50/8

1.00/10

19/-7

2,50

1.33/18

1.00/8

1.67/9

1.00/9

2015-12-23

Spezia

1-1

Como

20/-7

2,47

1.32/19

1.00/8

1.67/9

1.00/10

14/-20

2,53

0.53/19

0.38/8

0.40/10

0.67/9

2015-12-27

Ascoli

3-0

Spezia

16/-13

2,25

1.00/20

1.25/8

1.40/10

0.60/10

21/-7

2,45

1.30/20

1.13/8

1.60/10

1.00/10

2016-01-15

Spezia

0-0

Bari

21/-10

2,48

1.24/21

1.13/8

1.60/10

0.91/11

25/3

2,24

1.67/21

1.25/8

2.18/11

1.10/10

2016-01-23

Pro Vercelli

0-1

Spezia

16/-7

1,77

1.09/22

0.88/8

1.45/11

0.73/11

21/-10

2,36

1.23/22

1.25/8

1.55/11

0.91/11

2016-02-01

Spezia

3-1

Salernitana

22/-9

2,30

1.30/23

1.63/8

1.55/11

1.08/12

23/-7

2,30

1.00/23

1.00/8

1.55/11

0.50/12

2016-02-06

Perugia

0-0

Spezia

23/2

1,83

1.38/24

1.13/8

1.58/12

1.17/12

25/-7

2,38

1.38/24

1.88/8

1.67/12

1.08/12

2016-02-14

Spezia

3-0

Livorno

25/-7

2,28

1.36/25

1.63/8

1.67/12

1.08/13

31/-2

2,56

1.20/25

1.00/8

1.54/13

0.83/12

2016-02-20

Spezia

2-0

Lanciano

28/-4

2,31

1.42/26

1.63/8

1.77/13

1.08/13

25/-10

2,31

1.08/26

1.63/8

1.69/13

0.46/13

2016-02-27

Ternana

1-2

Spezia

32/-1

2,41

1.33/27

1.75/8

1.77/13

0.93/14

30/-2

2,30

1.48/27

1.88/8

1.86/14

1.08/13

2016-03-01

Spezia

1-1

Cesena

32/-1

2,32

1.54/28

2.13/8

1.86/14

1.21/14

39/16

2,21

1.64/28

1.75/8

2.47/15

0.69/13

2016-03-05

Avellino

0-1

Spezia

41/1

2,79

1.38/29

1.13/8

1.93/14

0.87/15

33/-1

2,31

1.52/29

2.25/8

1.80/15

1.21/14

2016-03-12

Spezia

2-0

Modena

34/0

2,27

1.57/30

2.50/8

1.80/15

1.33/15

26/-6

1,93

1.17/30

1.38/8

2.00/15

0.33/15

2016-03-18

Entella

2-2

Spezia

37/8

2,13

1.55/31

2.13/8

2.13/16

0.93/15

36/2

2,26

1.61/31

2.50/8

1.88/16

1.33/15

2016-03-26

Spezia

1-2

Trapani

38/2

2,31

1.59/32

2.25/8

1.88/16

1.31/16

40/0

2,50

1.47/32

1.88/8

1.69/16

1.25/16

2016-04-02

Cagliari

1-2

Spezia

58/26

2,73

2.06/33

1.63/8

2.50/16

1.65/17

39/1

2,33

1.55/33

2.13/8

1.76/17

1.31/16

2016-04-09

Spezia

1-0

Novara

41/2

2,35

1.59/34

2.13/8

1.76/17

1.41/17

46/18

2,18

1.65/34

1.50/8

1.82/17

1.47/17

2016-04-15

Crotone

0-0

Spezia

55/26

2,40

2.09/35

2.13/8

2.47/17

1.72/18

42/3

2,31

1.63/35

2.13/8

1.83/18

1.41/17

2016-04-19

Spezia

0-1

Pescara

42/3

2,25

1.61/36

1.88/8

1.83/18

1.39/18

56/8

2,89

1.61/36

1.13/8

2.06/18

1.17/18

2016-04-23

L.R. Vicenza

0-3

Spezia

37/-10

2,27

1.14/37

1.38/8

1.17/18

1.11/19

42/2

2,22

1.57/37

1.75/8

1.74/19

1.39/18

2016-04-30

Latina

0-0

Spezia

40/-8

2,32

1.05/38

0.75/8

1.42/19

0.68/19

45/5

2,24

1.61/38

1.75/8

1.74/19

1.47/19

2016-05-09

Spezia

2-1

Brescia

45/5

2,18

1.59/39

1.50/8

1.74/19

1.45/20

50/-6

2,72

1.38/39

0.75/8

2.00/20

0.74/19

2016-05-15

Como

4-0

Spezia

35/-28

2,45

0.75/40

0.50/8

0.80/20

0.70/20

47/6

2,20

1.63/40

1.75/8

1.80/20

1.45/20

2016-05-20

Spezia

0-0

Ascoli

47/2

2,24

1.59/41

1.75/8

1.80/20

1.38/21

45/-19

2,66

1.12/41

1.25/8

1.48/21

0.75/20