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

2017-07-28

Nimes

0-1

Reims

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

2017-08-04

Lens

1-2

Nimes

0/-1

1,00

0.00/1

0.00/1

0.00/0

0.00/1

0/-1

1,00

0.00/1

0.00/1

0.00/1

0.00/0

2017-08-14

Nimes

0-0

Nancy

2/0

2,00

1.50/2

1.50/2

0.00/1

3.00/1

1/-2

2,00

0.50/2

0.50/2

1.00/1

0.00/1

2017-08-21

Chateauroux

1-0

Nimes

3/-3

3,00

1.00/3

1.00/3

0.00/1

1.50/2

2/0

1,33

1.33/3

1.33/3

0.50/2

3.00/1

2017-08-25

Nimes

1-0

Le Havre

2/-1

1,25

1.00/4

1.00/4

0.50/2

1.50/2

11/10

3,00

3.00/4

3.00/4

3.00/2

3.00/2

2017-09-08

AC Ajaccio

1-4

Nimes

7/5

1,80

2.20/5

2.20/5

3.00/2

1.67/3

3/0

1,20

1.40/5

1.40/5

1.33/3

1.50/2

2017-09-15

Nimes

3-0

Auxerre

7/3

1,83

1.67/6

1.67/6

1.33/3

2.00/3

5/-7

2,83

0.67/6

0.67/6

1.33/3

0.00/3

2017-09-19

Tours

0-4

Nimes

3/-11

2,43

0.14/7

0.14/7

0.00/3

0.25/4

10/6

2,00

1.86/7

1.86/7

1.75/4

2.00/3

2017-09-22

Nimes

1-5

Niort

14/10

2,25

2.00/8

2.00/8

1.75/4

2.25/4

6/-6

2,25

1.00/8

1.00/8

1.40/5

0.33/3

2017-09-29

Paris FC

2-1

Nimes

10/2

2,00

1.89/9

2.00/8

2.00/5

1.75/4

15/6

2,67

1.78/9

2.00/8

1.40/5

2.25/4

2017-10-13

Nimes

4-1

Orleans

16/5

2,70

1.60/10

1.63/8

1.40/5

1.80/5

16/4

2,80

1.50/10

1.50/8

1.83/6

1.00/4

2017-10-20

Nimes

4-0

Brest

20/8

2,91

1.73/11

1.88/8

1.67/6

1.80/5

17/6

2,55

1.91/11

2.50/8

1.50/6

2.40/5

2017-10-28

Valenciennes

1-2

Nimes

15/-2

2,67

1.42/12

1.50/8

1.83/6

1.00/6

24/12

3,00

1.83/12

2.25/8

1.86/7

1.80/5

2017-11-03

Nimes

4-1

Quevilly Rouen

26/13

3,00

1.92/13

2.25/8

1.86/7

2.00/6

10/-13

2,54

0.38/13

0.38/8

0.57/7

0.17/6

2017-11-17

Sochaux

2-1

Nimes

20/-7

3,36

1.50/14

1.25/8

1.71/7

1.29/7

30/16

3,14

2.00/14

2.25/8

2.00/8

2.00/6

2017-11-24

Nimes

4-0

Bourg en Bresse

31/15

3,13

1.87/15

1.88/8

2.00/8

1.71/7

18/-14

3,33

0.87/15

0.50/8

1.43/7

0.38/8

2017-11-28

Lorient

1-2

Nimes

26/10

2,63

1.81/16

1.50/8

2.25/8

1.38/8

35/19

3,19

1.94/16

1.88/8

2.11/9

1.71/7

2017-12-11

Nimes

3-1

Clermont

37/20

3,18

2.00/17

2.25/8

2.11/9

1.88/8

23/10

2,12

1.71/17

1.50/8

2.00/8

1.44/9

2018-01-12

Nimes

0-1

Lens

40/22

3,22

2.06/18

2.63/8

2.20/10

1.88/8

27/4

2,63

1.11/19

1.50/8

1.67/9

0.60/10

2018-01-16

Nancy

0-2

Nimes

22/-5

2,45

1.05/20

0.88/8

1.40/10

0.70/10

40/21

3,11

1.95/19

2.25/8

2.00/11

1.88/8

2018-01-20

Nimes

3-0

Chateauroux

42/23

3,05

2.00/20

2.25/8

2.00/11

2.00/9

29/1

2,71

1.62/21

2.13/8

1.80/10

1.45/11

2018-01-23

GFC Ajaccio

2-0

Nimes

16/-11

2,05

1.29/21

1.38/8

1.60/10

1.00/11

45/26

3,05

2.05/21

2.25/8

2.08/12

2.00/9

2018-01-27

Le Havre

2-1

Nimes

30/12

2,18

1.68/22

1.63/8

2.20/10

1.25/12

45/24

3,00

1.95/22

1.88/8

2.08/12

1.80/10

2018-02-02

Nimes

1-1

AC Ajaccio

46/23

3,00

1.87/23

1.88/8

2.08/12

1.64/11

37/13

2,65

1.78/23

1.63/8

2.08/12

1.45/11

2018-02-12

Auxerre

0-0

Nimes

29/-3

2,54

1.25/24

1.38/8

1.58/12

0.92/12

47/23

2,96

1.83/24

1.63/8

2.00/13

1.64/11

2018-02-16

Nimes

2-2

Tours

47/23

2,84

1.80/25

1.38/8

2.00/13

1.58/12

14/-33

2,44

0.36/25

0.50/8

0.54/13

0.17/12

2018-02-23

Niort

1-4

Nimes

29/-10

2,62

1.12/26

0.50/8

1.38/13

0.85/13

49/23

2,88

1.77/26

1.13/8

1.93/14

1.58/12

2018-03-03

Nimes

2-1

Paris FC

53/26

2,96

1.81/27

1.50/8

1.93/14

1.69/13

31/8

2,00

1.70/27

1.50/8

1.93/14

1.46/13

2018-03-09

Orleans

1-4

Nimes

37/-2

2,71

1.36/28

1.88/8

1.36/14

1.36/14

55/27

2,96

1.86/28

1.50/8

2.00/15

1.69/13

2018-03-19

Brest

0-2

Nimes

41/7

2,59

1.62/29

1.50/8

1.43/14

1.80/15

59/30

3,03

1.90/29

1.50/8

2.00/15

1.79/14

2018-03-30

Nimes

1-0

Valenciennes

61/32

3,00

1.93/30

1.88/8

2.00/15

1.87/15

35/-12

2,83

1.14/29

1.00/8

1.25/16

1.00/13

2018-04-06

Quevilly Rouen

1-3

Nimes

36/-15

2,81

0.90/31

1.13/8

0.87/15

0.94/16

62/33

2,94

1.97/31

2.25/8

2.06/16

1.87/15

2018-04-13

Nimes

0-2

Sochaux

65/35

2,97

2.00/32

2.50/8

2.06/16

1.94/16

44/-8

3,00

1.50/32

1.00/8

1.94/16

1.06/16

2018-04-20

Bourg en Bresse

2-2

Nimes

43/-26

3,39

0.97/33

1.50/8

1.31/16

0.65/17

65/33

2,94

1.94/33

2.38/8

1.94/17

1.94/16

2018-04-24

Nimes

1-0

Lorient

67/33

2,97

1.91/34

2.38/8

1.94/17

1.88/17

53/11

2,79

1.65/34

1.88/8

1.94/18

1.31/16

2018-04-28

Clermont

1-1

Nimes

48/16

2,29

1.66/35

1.63/8

2.00/17

1.33/18

68/34

2,91

1.94/35

2.38/8

2.00/18

1.88/17

2018-05-04

Nimes

4-0

GFC Ajaccio

69/34

2,89

1.92/36

2.13/8

2.00/18

1.83/18

32/-20

2,33

1.14/36

1.25/8

1.61/18

0.67/18

2018-05-11

Reims

2-2

Nimes

72/50

2,54

2.35/37

2.63/8

2.39/18

2.32/19

73/38

2,92

1.95/37

2.13/8

2.05/19

1.83/18