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

Colmar

1-0

Orleans

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-13

Orleans

1-1

Paris FC

0/-1

1,00

0.00/1

0.00/1

0.00/0

0.00/1

1/1

1,00

3.00/1

3.00/1

3.00/1

0.00/0

2010-08-20

Gap

2-1

Orleans

1/-4

3,00

0.00/2

0.00/2

0.00/1

0.00/1

1/-1

1,50

0.50/2

0.50/2

1.00/1

0.00/1

2010-08-27

Orleans

1-0

Gueugnon

2/-2

2,00

0.33/3

0.33/3

1.00/1

0.00/2

0/-6

2,00

0.00/3

0.00/3

0.00/2

0.00/1

2010-09-04

Plabennec

1-1

Orleans

4/-1

2,25

1.50/4

1.50/4

1.50/2

1.50/2

3/-1

1,75

1.00/4

1.00/4

2.00/2

0.00/2

2010-09-10

Orleans

2-3

Beauvais

4/-1

1,80

1.00/5

1.00/5

2.00/2

0.33/3

6/3

1,80

1.80/5

1.80/5

1.00/3

3.00/2

2010-09-14

Frejus Saint Raphael

1-1

Orleans

8/6

2,00

2.60/5

2.60/5

3.00/2

2.33/3

6/-2

2,33

0.83/6

0.83/6

1.33/3

0.33/3

2010-09-18

Orleans

2-0

Pacy Eure

7/-2

2,29

0.86/7

0.86/7

1.33/3

0.50/4

4/-1

1,50

1.17/6

1.17/6

1.33/3

1.00/3

2010-09-24

Alfortville

0-2

Orleans

6/-6

2,57

0.71/7

0.71/7

0.33/3

1.00/4

9/0

2,25

1.13/8

1.13/8

1.75/4

0.50/4

2010-09-28

Orleans

0-0

Creteil

11/2

2,22

1.33/9

1.50/8

1.75/4

1.00/5

9/2

2,00

1.63/8

1.63/8

2.25/4

1.00/4

2010-10-02

Luzenac

4-2

Orleans

11/6

1,78

1.56/9

1.75/8

2.25/4

1.00/5

11/2

2,00

1.30/10

1.50/8

1.60/5

1.00/5

2010-10-13

Orleans

0-0

Amiens

13/0

2,36

1.18/11

1.50/8

1.60/5

0.83/6

14/6

1,83

1.92/12

2.13/8

2.67/6

1.17/6

2010-10-23

Rodez

1-0

Orleans

11/-10

2,46

0.85/13

1.13/8

1.33/6

0.43/7

13/0

2,17

1.17/12

1.25/8

1.50/6

0.83/6

2010-11-05

Orleans

2-2

Rouen

13/-1

2,08

1.08/13

1.13/8

1.50/6

0.71/7

15/6

1,71

1.71/14

1.75/8

2.43/7

1.00/7

2010-11-09

Bayonne

2-1

Orleans

4/-19

1,80

0.53/15

0.38/8

0.43/7

0.63/8

15/-1

2,21

1.07/14

1.25/8

1.43/7

0.71/7

2010-11-13

Orleans

1-1

Strasbourg

16/-2

2,27

1.00/15

1.13/8

1.43/7

0.63/8

18/8

1,87

1.53/15

1.63/8

2.25/8

0.71/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-17

Niort

0-0

Orleans

23/8

2,11

1.56/18

1.63/8

1.78/9

1.33/9

19/-4

2,47

0.94/17

0.50/8

1.38/8

0.56/9

2010-12-22

Orleans

0-2

Bastia

19/-4

2,33

0.94/18

0.50/8

1.38/8

0.60/10

36/25

2,61

2.33/18

2.75/8

2.60/10

2.00/8

2011-01-11

Orleans

1-1

Guingamp

19/-6

2,32

0.89/19

0.50/8

1.22/9

0.60/10

37/22

2,74

2.16/19

2.38/8

2.50/10

1.78/9

2011-01-15

Paris FC

1-3

Orleans

24/7

2,16

1.47/19

1.50/8

1.90/10

1.00/9

20/-6

2,30

0.90/20

0.50/8

1.20/10

0.60/10

2011-01-21

Orleans

4-0

Gap

23/-4

2,38

1.00/21

0.88/8

1.20/10

0.82/11

24/-8

2,95

1.11/19

1.38/8

2.00/10

0.11/9

2011-01-29

Gueugnon

0-1

Orleans

13/-20

2,30

0.55/20

0.63/8

0.30/10

0.80/10

27/0

2,45

1.09/22

1.13/8

1.36/11

0.82/11

2011-02-05

Orleans

2-1

Plabennec

28/1

2,39

1.17/23

1.50/8

1.36/11

1.00/12

23/-5

2,22

1.22/23

1.25/8

1.58/12

0.82/11

2011-02-11

Beauvais

1-2

Orleans

32/7

2,38

1.71/24

1.63/8

1.58/12

1.83/12

30/2

2,42

1.25/24

1.75/8

1.50/12

1.00/12

2011-02-18

Orleans

3-0

Frejus Saint Raphael

32/3

2,44

1.32/25

2.13/8

1.50/12

1.15/13

29/10

2,09

1.83/23

2.13/8

2.45/11

1.25/12

2011-02-26

Pacy Eure

0-0

Orleans

26/-6

2,32

1.04/25

0.63/8

0.92/12

1.15/13

35/6

2,46

1.38/26

2.38/8

1.62/13

1.15/13

2011-03-05

Orleans

0-1

Alfortville

35/6

2,37

1.37/27

2.50/8

1.62/13

1.14/14

20/-27

2,68

0.56/25

0.75/8

0.46/13

0.67/12

2011-03-11

Creteil

0-1

Orleans

24/0

1,78

1.41/27

1.63/8

1.23/13

1.57/14

35/5

2,32

1.32/28

2.38/8

1.50/14

1.14/14

2011-03-18

Orleans

1-0

Luzenac

36/6

2,28

1.38/29

2.38/8

1.50/14

1.27/15

26/3

1,75

1.29/28

1.13/8

1.86/14

0.71/14

2011-04-01

Amiens

0-0

Orleans

45/24

2,13

2.10/31

2.50/8

2.73/15

1.50/16

37/7

2,23

1.43/30

2.38/8

1.60/15

1.27/15

2011-04-08

Orleans

0-1

Rodez

37/7

2,16

1.42/31

2.13/8

1.60/15

1.25/16

36/-16

2,75

1.06/32

2.00/8

1.63/16

0.50/16

2011-04-15

Rouen

0-1

Orleans

45/16

2,24

1.73/33

2.13/8

2.31/16

1.18/17

37/6

2,13

1.38/32

1.75/8

1.50/16

1.25/16

2011-04-22

Orleans

0-1

Bayonne

38/7

2,09

1.42/33

1.75/8

1.50/16

1.35/17

30/-21

2,38

1.03/34

1.13/8

1.29/17

0.76/17

2011-04-26

Strasbourg

2-0

Orleans

47/23

2,03

1.83/35

2.50/8

2.06/17

1.61/18

38/6

2,06

1.38/34

1.38/8

1.41/17

1.35/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

Guingamp

4-1

Orleans

76/45

2,97

1.97/36

2.25/8

2.44/18

1.50/18

39/4

2,06

1.33/36

1.38/8

1.39/18

1.28/18

2011-05-13

Orleans

1-1

Niort

40/1

2,14

1.30/37

1.00/8

1.39/18

1.21/19

42/0

2,27

1.24/37

0.88/8

1.74/19

0.72/18

2011-05-20

Bastia

0-0

Orleans

81/58

2,74

2.37/38

2.50/8

2.47/19

2.26/19

41/1

2,13

1.29/38

0.75/8

1.37/19

1.21/19

2011-05-27

Orleans

2-0

Colmar

41/1

2,08

1.28/39

0.75/8

1.37/19

1.20/20

31/-15

1,97

1.05/39

1.50/8

1.05/20

1.05/19