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

Cannes

3-0

Bayonne

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-08-14

Strasbourg

3-3

Cannes

0/0

0,00

0.00/0

0.00/0

0.00/0

0.00/0

3/3

3,00

3.00/1

3.00/1

3.00/1

0.00/0

2010-08-28

Cannes

0-0

Guingamp

6/3

4,50

2.00/2

2.00/2

3.00/1

1.00/1

1/1

0,33

1.67/3

1.67/3

2.00/2

1.00/1

2010-09-03

Niort

0-2

Cannes

7/4

2,50

1.75/4

1.75/4

3.00/2

0.50/2

6/3

3,00

1.67/3

1.67/3

2.00/2

1.00/1

2010-09-10

Cannes

2-1

Bastia

8/5

2,75

2.00/4

2.00/4

2.00/2

2.00/2

4/3

1,00

2.20/5

2.20/5

2.33/3

2.00/2

2010-09-15

Colmar

0-3

Cannes

3/-3

1,50

1.00/6

1.00/6

2.00/3

0.00/3

10/6

2,80

2.20/5

2.20/5

2.33/3

2.00/2

2010-09-18

Cannes

0-0

Paris FC

13/9

2,83

2.33/6

2.33/6

2.33/3

2.33/3

9/4

2,00

1.86/7

1.86/7

2.50/4

1.00/3

2010-09-24

Gap

2-3

Cannes

12/1

2,88

1.13/8

1.13/8

2.25/4

0.00/4

13/9

2,43

2.14/7

2.14/7

2.00/4

2.33/3

2010-09-28

Cannes

2-1

Gueugnon

16/10

2,75

2.25/8

2.25/8

2.00/4

2.50/4

4/-6

1,56

0.67/9

0.75/8

0.40/5

1.00/4

2010-10-02

Plabennec

0-0

Cannes

10/0

2,00

1.40/10

1.38/8

2.00/5

0.80/5

18/11

2,78

2.33/9

2.25/8

2.20/5

2.50/4

2010-10-08

Cannes

0-0

Beauvais

18/11

2,50

2.20/10

2.25/8

2.20/5

2.20/5

14/5

2,09

1.82/11

1.88/8

1.33/6

2.40/5

2010-10-13

Frejus Saint Raphael

0-0

Cannes

15/7

2,09

1.91/11

1.75/8

2.60/5

1.33/6

18/11

2,27

2.09/11

2.25/8

2.00/6

2.20/5

2010-10-22

Cannes

0-0

Pacy Eure

18/11

2,08

2.00/12

2.00/8

2.00/6

2.00/6

9/-4

1,83

1.17/12

1.00/8

1.33/6

1.00/6

2010-11-05

Alfortville

0-0

Cannes

9/-17

2,69

0.46/13

0.25/8

0.33/6

0.57/7

18/11

1,92

1.92/13

1.75/8

1.86/7

2.00/6

2010-11-09

Cannes

1-0

Creteil

18/11

1,79

1.86/14

1.50/8

1.86/7

1.86/7

12/2

1,57

1.57/14

1.63/8

1.57/7

1.57/7

2010-11-14

Luzenac

1-0

Cannes

19/9

1,93

1.53/15

1.50/8

2.29/7

0.88/8

19/12

1,73

1.93/15

1.75/8

2.00/8

1.86/7

2010-11-26

Cannes

4-2

Orleans

19/11

1,69

1.81/16

1.38/8

2.00/8

1.63/8

17/-2

2,25

1.00/16

0.88/8

1.38/8

0.63/8

2010-12-03

Amiens

2-0

Cannes

21/8

2,00

1.71/17

1.63/8

2.50/8

1.00/9

23/13

1,94

1.88/17

1.38/8

2.11/9

1.63/8

2010-12-17

Cannes

2-0

Rodez

23/11

1,94

1.78/18

1.25/8

2.11/9

1.44/9

18/-13

2,88

1.00/17

1.50/8

1.75/8

0.33/9

2011-01-15

Cannes

1-0

Strasbourg

25/13

1,95

1.84/19

1.50/8

2.20/10

1.44/9

24/11

1,95

1.53/19

1.75/8

2.00/10

1.00/9

2011-01-26

Rouen

2-0

Cannes

26/6

2,19

1.52/21

1.13/8

2.30/10

0.82/11

26/14

1,90

1.90/20

1.75/8

2.27/11

1.44/9

2011-01-29

Guingamp

4-0

Cannes

40/22

2,76

2.05/21

2.13/8

2.36/11

1.70/10

26/12

1,90

1.81/21

1.63/8

2.27/11

1.30/10

2011-02-04

Cannes

1-0

Niort

26/8

2,00

1.73/22

1.50/8

2.27/11

1.18/11

27/5

2,13

1.39/23

1.38/8

1.67/12

1.09/11

2011-02-12

Bastia

0-0

Cannes

46/31

2,54

2.33/24

2.25/8

2.50/12

2.17/12

27/9

1,96

1.78/23

1.50/8

2.33/12

1.18/11

2011-02-18

Cannes

2-1

Colmar

27/9

1,88

1.75/24

1.63/8

2.33/12

1.17/12

15/-18

1,92

0.84/25

1.50/8

0.69/13

1.00/12

2011-02-25

Paris FC

1-1

Cannes

29/3

2,12

1.31/26

0.75/8

1.69/13

0.92/13

29/10

1,92

1.80/25

1.63/8

2.38/13

1.17/12

2011-03-04

Cannes

0-1

Gap

30/10

1,92

1.77/26

1.75/8

2.38/13

1.15/13

29/-15

2,81

1.12/26

1.38/8

1.85/13

0.38/13

2011-03-12

Gueugnon

2-4

Cannes

18/-27

2,25

0.54/28

0.50/8

0.50/14

0.57/14

30/9

1,89

1.70/27

1.38/8

2.21/14

1.15/13

2011-03-19

Cannes

1-0

Plabennec

34/11

2,04

1.75/28

1.38/8

2.21/14

1.29/14

24/-13

2,10

1.00/29

0.50/8

1.33/15

0.64/14

2011-03-25

Beauvais

2-1

Cannes

40/7

2,43

1.60/30

1.13/8

1.67/15

1.53/15

35/12

2,00

1.79/29

1.75/8

2.27/15

1.29/14

2011-04-01

Cannes

1-1

Frejus Saint Raphael

36/11

2,03

1.73/30

1.75/8

2.27/15

1.20/15

36/5

2,23

1.60/30

1.13/8

2.20/15

1.00/15

2011-04-09

Pacy Eure

1-0

Cannes

30/-10

2,26

0.97/31

0.63/8

1.00/15

0.94/16

37/11

2,03

1.71/31

1.50/8

2.19/16

1.20/15

2011-04-16

Cannes

3-0

Alfortville

37/10

2,00

1.66/32

1.38/8

2.19/16

1.13/16

30/-32

2,88

0.63/32

0.75/8

0.38/16

0.88/16

2011-04-22

Creteil

2-2

Cannes

30/-2

1,88

1.36/33

1.38/8

1.38/16

1.35/17

40/13

2,03

1.70/33

1.38/8

2.24/17

1.13/16

2011-04-26

Cannes

2-0

Luzenac

42/13

2,09

1.68/34

1.38/8

2.24/17

1.12/17

31/1

1,79

1.24/34

1.25/8

1.71/17

0.76/17

2011-04-30

Orleans

1-1

Cannes

38/4

2,06

1.34/35

1.25/8

1.41/17

1.28/18

44/15

2,09

1.71/35

1.75/8

2.28/18

1.12/17

2011-05-06

Cannes

1-1

Amiens

45/15

2,08

1.69/36

1.50/8

2.28/18

1.11/18

52/29

2,08

2.11/36

2.25/8

2.56/18

1.67/18

2011-05-13

Rodez

0-2

Cannes

39/-18

2,59

1.05/37

1.38/8

1.50/18

0.63/19

46/15

2,08

1.68/37

1.25/8

2.21/19

1.11/18

2011-05-20

Cannes

3-2

Rouen

48/17

2,08

1.71/38

1.63/8

2.21/19

1.21/19

51/13

2,34

1.55/38

1.13/8

2.00/19

1.11/19

2011-05-27

Bayonne

2-0

Cannes

34/-24

2,36

1.03/39

0.63/8

1.21/19

0.85/20

51/18

2,15

1.74/39

1.88/8

2.25/20

1.21/19