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

2010-08-28

Udinese

0-1

Genoa

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

2010-09-12

Genoa

1-3

Chievo

1/1

1,00

3.00/1

3.00/1

0.00/0

3.00/1

2/1

3,00

3.00/1

3.00/1

3.00/1

0.00/0

2010-09-19

Parma

1-1

Genoa

3/1

2,50

1.50/2

1.50/2

3.00/1

0.00/1

2/-1

2,50

1.50/2

1.50/2

0.00/1

3.00/1

2010-09-22

Genoa

1-1

Fiorentina

3/-1

2,33

1.33/3

1.33/3

0.00/1

2.00/2

2/-2

2,00

0.33/3

0.33/3

0.50/2

0.00/1

2010-09-25

AC Milan

1-0

Genoa

6/2

2,50

1.25/4

1.25/4

2.00/2

0.50/2

4/-1

2,25

1.25/4

1.25/4

0.50/2

2.00/2

2010-10-03

Genoa

2-1

Bari

4/-2

2,00

1.00/5

1.00/5

0.50/2

1.33/3

5/-2

2,40

1.60/5

1.60/5

2.33/3

0.50/2

2010-10-16

AS Roma

2-1

Genoa

5/-6

2,67

0.83/6

0.83/6

1.67/3

0.00/3

6/-1

2,17

1.33/6

1.33/6

1.33/3

1.33/3

2010-10-24

Genoa

1-0

Catania

7/-2

2,29

1.14/7

1.14/7

1.33/3

1.00/4

8/1

2,14

1.29/7

1.29/7

2.00/4

0.33/3

2010-10-29

Genoa

0-1

Inter

8/-1

2,13

1.38/8

1.38/8

1.75/4

1.00/4

10/6

1,75

1.88/8

1.88/8

2.00/4

1.75/4

2010-11-07

Palermo

1-0

Genoa

15/2

3,11

1.22/9

1.25/8

1.00/5

1.50/4

8/-2

2,00

1.22/9

1.00/8

1.40/5

1.00/4

2010-11-10

Genoa

1-0

Bologna

8/-3

1,90

1.10/10

1.00/8

1.40/5

0.80/5

10/-4

2,40

1.10/10

1.25/8

1.80/5

0.40/5

2010-11-14

Cagliari

0-1

Genoa

11/1

1,91

1.00/11

0.75/8

1.40/5

0.67/6

9/-2

1,82

1.27/11

1.25/8

1.67/6

0.80/5

2010-11-21

Genoa

0-2

Juventus

10/-1

1,75

1.42/12

1.50/8

1.67/6

1.17/6

23/10

3,00

1.67/12

2.00/8

1.83/6

1.50/6

2010-11-28

Brescia

0-0

Genoa

11/-6

2,15

0.85/13

0.25/8

1.17/6

0.57/7

10/-3

1,77

1.31/13

1.50/8

1.43/7

1.17/6

2010-12-05

Lecce

1-3

Genoa

12/-16

2,86

0.86/14

0.50/8

1.83/6

0.13/8

10/-3

1,64

1.29/14

1.25/8

1.43/7

1.14/7

2010-12-11

Genoa

0-1

Napoli

13/-1

1,80

1.40/15

1.63/8

1.43/7

1.38/8

24/7

2,73

1.80/15

1.88/8

1.86/7

1.75/8

2011-01-06

Genoa

0-0

Lazio

13/-2

1,75

1.31/16

1.25/8

1.25/8

1.38/8

24/8

2,35

1.94/17

1.38/8

2.22/9

1.63/8

2011-01-09

Cesena

0-0

Genoa

13/-8

2,00

1.06/17

1.25/8

1.44/9

0.63/8

13/-2

1,65

1.29/17

1.38/8

1.22/9

1.38/8

2011-01-16

Genoa

2-4

Udinese

13/-2

1,56

1.28/18

1.50/8

1.22/9

1.33/9

27/2

2,74

1.42/19

1.63/8

2.11/9

0.80/10

2011-01-23

Chievo

0-0

Genoa

20/-2

2,10

1.15/20

0.88/8

1.40/10

0.90/10

15/-4

1,79

1.21/19

1.13/8

1.10/10

1.33/9

2011-01-30

Genoa

3-1

Parma

15/-4

1,70

1.20/20

0.88/8

1.10/10

1.30/10

21/-4

2,19

1.19/21

1.25/8

1.55/11

0.80/10

2011-02-02

Fiorentina

1-0

Genoa

21/-2

2,10

1.19/21

1.25/8

2.00/10

0.45/11

18/-2

1,81

1.29/21

1.25/8

1.27/11

1.30/10

2011-02-06

Genoa

1-1

AC Milan

18/-3

1,77

1.23/22

1.13/8

1.27/11

1.18/11

39/21

2,48

2.09/23

1.88/8

2.00/12

2.18/11

2011-02-13

Bari

0-0

Genoa

14/-25

2,21

0.58/24

0.50/8

0.75/12

0.42/12

19/-3

1,78

1.22/23

0.88/8

1.25/12

1.18/11

2011-02-16

Sampdoria

0-1

Genoa

23/-3

2,04

1.25/24

0.88/8

1.67/12

0.83/12

19/-3

1,71

1.21/24

1.00/8

1.25/12

1.17/12

2011-02-20

Genoa

4-3

AS Roma

20/-2

1,68

1.28/25

1.25/8

1.25/12

1.31/13

35/3

2,79

1.63/24

1.63/8

2.25/12

1.00/12

2011-02-27

Catania

2-1

Genoa

22/-12

2,15

1.00/26

0.63/8

1.69/13

0.31/13

24/-1

1,88

1.35/26

1.50/8

1.38/13

1.31/13

2011-03-06

Inter

5-2

Genoa

49/20

2,89

1.96/27

2.25/8

2.31/13

1.64/14

25/-2

1,93

1.30/27

1.50/8

1.38/13

1.21/14

2011-03-13

Genoa

1-0

Palermo

27/-5

2,11

1.25/28

1.38/8

1.38/13

1.13/15

44/-1

3,18

1.43/28

1.13/8

1.86/14

1.00/14

2011-03-20

Bologna

1-1

Genoa

32/-4

2,34

1.45/29

1.75/8

1.86/14

1.07/15

28/-4

2,07

1.31/29

1.38/8

1.50/14

1.13/15

2011-04-03

Genoa

0-1

Cagliari

29/-4

2,07

1.30/30

1.50/8

1.50/14

1.13/16

36/0

2,40

1.30/30

1.25/8

1.67/15

0.93/15

2011-04-10

Juventus

3-2

Genoa

47/9

2,74

1.55/31

1.63/8

1.60/15

1.50/16

29/-5

2,03

1.26/31

1.38/8

1.40/15

1.13/16

2011-04-17

Genoa

3-0

Brescia

31/-6

2,13

1.22/32

1.25/8

1.40/15

1.06/17

28/-12

2,13

0.94/32

1.00/8

1.38/16

0.50/16

2011-04-23

Genoa

4-2

Lecce

34/-3

2,15

1.27/33

1.25/8

1.50/16

1.06/17

38/-18

2,85

1.06/33

1.38/8

1.35/17

0.75/16

2011-04-30

Napoli

1-0

Genoa

54/20

2,59

1.91/34

1.63/8

2.12/17

1.71/17

38/-1

2,26

1.32/34

1.25/8

1.59/17

1.06/17

2011-05-08

Genoa

2-1

Sampdoria

38/-2

2,23

1.29/35

1.25/8

1.59/17

1.00/18

30/-12

2,06

1.03/35

0.63/8

1.17/18

0.88/17

2011-05-14

Lazio

4-2

Genoa

47/12

2,28

1.67/36

1.13/8

2.17/18

1.17/18

40/-1

2,25

1.33/36

1.63/8

1.67/18

1.00/18

2011-05-22

Genoa

3-2

Cesena

42/-3

2,35

1.30/37

1.25/8

1.67/18

0.95/19

36/-11

2,24

1.16/37

1.75/8

1.37/19

0.94/18