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

Bastia

1-0

Amiens

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

Amiens

1-0

Colmar

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

Paris FC

1-0

Amiens

2/1

1,50

2.00/2

2.00/2

3.00/1

1.00/1

1/0

1,00

1.50/2

1.50/2

3.00/1

0.00/1

2010-08-28

Amiens

1-0

Gap

1/-1

1,00

1.00/3

1.00/3

3.00/1

0.00/2

3/-3

3,00

1.00/3

1.00/3

1.50/2

0.00/1

2010-09-04

Gueugnon

1-2

Amiens

0/-7

1,75

0.00/4

0.00/4

0.00/2

0.00/2

2/0

1,00

1.50/4

1.50/4

3.00/2

0.00/2

2010-09-10

Amiens

1-0

Plabennec

4/1

1,40

1.80/5

1.80/5

3.00/2

1.00/3

5/-1

2,20

1.40/5

1.40/5

1.33/3

1.50/2

2010-09-14

Beauvais

0-0

Amiens

9/4

2,33

2.00/6

2.00/6

1.00/3

3.00/3

5/2

1,33

2.00/6

2.00/6

3.00/3

1.00/3

2010-09-18

Amiens

1-0

Frejus Saint Raphael

5/2

1,14

1.86/7

1.86/7

3.00/3

1.00/4

9/6

2,00

2.33/6

2.33/6

2.33/3

2.33/3

2010-09-24

Pacy Eure

2-1

Amiens

4/-3

1,57

1.00/7

1.00/7

1.33/3

0.75/4

6/3

1,13

2.00/8

2.00/8

3.00/4

1.00/4

2010-09-28

Amiens

3-1

Alfortville

7/2

1,33

1.78/9

2.00/8

3.00/4

0.80/5

6/-8

2,50

0.63/8

0.63/8

0.25/4

1.00/4

2010-10-01

Creteil

1-3

Amiens

9/2

1,78

1.56/9

1.38/8

2.25/4

1.00/5

10/4

1,60

1.90/10

2.00/8

3.00/5

0.80/5

2010-10-08

Amiens

1-1

Luzenac

13/6

1,82

2.00/11

2.38/8

3.00/5

1.17/6

15/8

2,20

1.70/10

1.75/8

2.40/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-11-05

Amiens

5-1

Rodez

14/6

1,69

1.85/13

1.88/8

2.67/6

1.14/7

12/-9

2,36

1.00/14

1.50/8

1.57/7

0.43/7

2010-11-09

Rouen

2-0

Amiens

17/6

1,87

1.67/15

1.75/8

2.43/7

1.00/8

19/10

2,00

1.93/14

1.88/8

2.71/7

1.14/7

2010-11-13

Amiens

1-1

Bayonne

19/8

2,00

1.80/15

1.75/8

2.71/7

1.00/8

6/-18

1,88

0.69/16

0.63/8

0.75/8

0.63/8

2010-11-26

Strasbourg

1-1

Amiens

19/8

1,88

1.50/16

1.63/8

2.25/8

0.75/8

20/8

2,00

1.75/16

1.50/8

2.50/8

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

Guingamp

1-2

Amiens

34/21

2,76

2.24/17

2.75/8

2.78/9

1.63/8

23/10

2,00

1.78/18

1.63/8

2.56/9

1.00/9

2011-01-15

Colmar

0-0

Amiens

11/-17

2,05

0.79/19

1.13/8

0.78/9

0.80/10

25/11

2,05

1.84/19

1.63/8

2.56/9

1.20/10

2011-01-26

Amiens

2-1

Niort

25/11

1,95

1.80/20

1.63/8

2.56/9

1.18/11

26/8

2,10

1.52/21

1.38/8

1.82/11

1.20/10

2011-02-04

Amiens

3-2

Gueugnon

27/12

2,00

1.86/21

1.88/8

2.60/10

1.18/11

13/-21

2,24

0.52/21

0.63/8

0.27/11

0.80/10

2011-02-08

Amiens

2-0

Paris FC

30/13

2,14

1.91/22

1.88/8

2.64/11

1.18/11

29/7

2,22

1.43/23

1.13/8

1.83/12

1.00/11

2011-02-11

Plabennec

0-0

Amiens

24/-6

2,25

1.17/24

1.13/8

1.58/12

0.75/12

32/15

2,13

1.96/23

2.25/8

2.67/12

1.18/11

2011-02-19

Amiens

2-0

Beauvais

32/15

2,04

1.92/24

2.25/8

2.67/12

1.17/12

33/6

2,40

1.64/25

1.25/8

1.46/13

1.83/12

2011-02-26

Frejus Saint Raphael

0-1

Amiens

29/7

2,13

1.75/24

2.00/8

2.45/11

1.15/13

34/17

2,04

1.96/25

2.50/8

2.69/13

1.17/12

2011-03-04

Amiens

2-0

Pacy Eure

35/18

2,00

2.00/26

2.50/8

2.69/13

1.31/13

26/-6

2,23

1.04/26

0.38/8

0.92/13

1.15/13

2011-03-08

Gap

0-1

Amiens

30/-14

2,74

1.19/27

1.38/8

1.85/13

0.57/14

37/20

2,00

2.04/27

2.50/8

2.71/14

1.31/13

2011-03-12

Alfortville

2-4

Amiens

22/-27

2,63

0.63/27

1.13/8

0.46/13

0.79/14

38/21

1,96

2.07/28

2.75/8

2.71/14

1.43/14

2011-03-18

Amiens

2-1

Creteil

42/23

2,10

2.10/29

2.75/8

2.71/14

1.53/15

24/-1

1,75

1.36/28

1.50/8

1.14/14

1.57/14

2011-03-25

Luzenac

1-1

Amiens

26/2

1,72

1.24/29

1.13/8

1.86/14

0.67/15

44/24

2,13

2.13/30

2.75/8

2.73/15

1.53/15

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

Rodez

0-2

Amiens

37/-15

2,70

1.12/33

2.25/8

1.63/16

0.65/17

45/24

2,06

2.06/32

2.50/8

2.63/16

1.50/16

2011-04-22

Amiens

2-1

Rouen

47/26

2,06

2.09/33

2.50/8

2.63/16

1.59/17

45/15

2,21

1.68/34

1.75/8

2.18/17

1.18/17

2011-04-26

Bayonne

0-2

Amiens

31/-20

2,34

1.09/35

1.13/8

1.29/17

0.89/18

49/27

2,09

2.12/34

2.50/8

2.65/17

1.59/17

2011-04-30

Amiens

1-1

Strasbourg

51/29

2,09

2.14/35

2.50/8

2.65/17

1.67/18

49/25

2,03

1.86/36

2.50/8

2.11/18

1.61/18

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

Amiens

2-1

Guingamp

53/29

2,08

2.08/37

2.00/8

2.56/18

1.63/19

80/48

3,03

2.00/37

2.25/8

2.47/19

1.50/18

2011-05-20

Niort

2-2

Amiens

43/0

2,26

1.24/38

0.88/8

1.74/19

0.74/19

55/30

2,11

2.11/38

2.00/8

2.58/19

1.63/19

2011-05-27

Amiens

1-0

Bastia

57/30

2,15

2.08/39

2.00/8

2.58/19

1.60/20

81/58

2,67

2.33/39

2.25/8

2.40/20

2.26/19