SELECT * FROM 1_Kampe WHERE LigaID = '90' 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

2016-07-29

Nimes

0-0

Laval

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

2016-08-05

Le Havre

1-0

Nimes

1/1

1,00

3.00/1

3.00/1

0.00/0

3.00/1

0/0

0,00

1.00/1

1.00/1

1.00/1

0.00/0

2016-08-15

Nimes

0-2

Lens

0/-1

0,50

0.50/2

0.50/2

1.00/1

0.00/1

2/0

2,00

1.00/2

1.00/2

1.00/1

1.00/1

2016-08-19

Strasbourg

1-1

Nimes

4/3

1,67

2.33/3

2.33/3

3.00/1

2.00/2

0/-3

1,00

0.33/3

0.33/3

0.50/2

0.00/1

2016-08-26

Nimes

2-3

Amiens

1/-3

1,25

0.50/4

0.50/4

0.50/2

0.50/2

4/2

1,50

1.75/4

1.75/4

2.00/2

1.50/2

2016-09-09

Niort

1-3

Nimes

4/-5

2,60

0.60/5

0.60/5

0.50/2

0.67/3

3/-4

2,00

0.40/5

0.40/5

0.33/3

0.50/2

2016-09-16

Tours

1-3

Nimes

9/-1

3,17

1.00/6

1.00/6

0.67/3

1.33/3

6/-2

2,33

0.83/6

0.83/6

0.33/3

1.33/3

2016-09-20

Nimes

2-2

Troyes

9/0

2,57

1.14/7

1.14/7

0.33/3

1.75/4

8/-2

2,57

1.14/7

1.14/7

1.25/4

1.00/3

2016-09-23

GFC Ajaccio

0-2

Nimes

5/0

1,43

1.43/7

1.43/7

1.00/3

1.75/4

11/0

2,75

1.13/8

1.13/8

0.50/4

1.75/4

2016-09-30

Nimes

0-0

Bourg en Bresse

13/2

2,67

1.33/9

1.38/8

0.50/4

2.00/5

10/-2

2,44

1.11/9

1.13/8

1.20/5

1.00/4

2016-10-14

Red Star

3-3

Nimes

4/-5

1,30

1.00/10

1.00/8

1.00/5

1.00/5

13/2

2,40

1.30/10

1.50/8

0.60/5

2.00/5

2016-10-21

Nimes

0-0

Sochaux

16/2

2,73

1.27/11

1.63/8

0.60/5

1.83/6

12/4

1,82

1.64/11

1.38/8

1.67/6

1.60/5

2016-10-28

Valenciennes

2-3

Nimes

18/3

2,75

1.42/12

1.50/8

1.83/6

1.00/6

16/2

2,50

1.25/12

1.63/8

0.67/6

1.83/6

2016-11-04

Nimes

1-1

Clermont

19/3

2,69

1.38/13

2.00/8

0.67/6

2.00/7

12/-2

2,00

1.23/13

1.13/8

1.29/7

1.17/6

2016-11-18

Orleans

2-1

Nimes

11/-6

2,00

0.79/14

0.75/8

1.29/7

0.29/7

20/3

2,64

1.36/14

1.75/8

0.71/7

2.00/7

2016-11-25

Nimes

3-0

Reims

21/2

2,67

1.27/15

1.38/8

0.71/7

1.75/8

18/6

2,00

1.73/15

1.63/8

2.57/7

1.00/8

2016-11-29

Auxerre

2-0

Nimes

10/-11

1,94

0.69/16

0.63/8

0.71/7

0.67/9

24/5

2,69

1.38/16

1.63/8

1.00/8

1.75/8

2016-12-09

Nimes

1-2

Brest

24/3

2,65

1.29/17

1.25/8

1.00/8

1.56/9

24/4

2,59

1.82/17

1.63/8

2.00/9

1.63/8

2016-12-16

AC Ajaccio

1-2

Nimes

19/-4

2,33

1.17/18

1.13/8

1.89/9

0.44/9

25/2

2,67

1.22/18

1.13/8

0.89/9

1.56/9

2017-01-13

Nimes

0-0

Le Havre

27/3

2,68

1.32/19

1.38/8

0.89/9

1.70/10

19/2

1,89

1.42/19

1.00/8

1.33/9

1.50/10

2017-01-21

Lens

1-3

Nimes

28/8

2,40

1.75/20

2.13/8

1.78/9

1.73/11

27/3

2,55

1.30/20

1.38/8

0.90/10

1.70/10

2017-01-27

Nimes

2-2

Strasbourg

30/5

2,62

1.38/21

1.38/8

0.90/10

1.82/11

28/5

2,55

1.60/20

1.88/8

2.00/10

1.20/10

2017-02-03

Amiens

1-2

Nimes

30/9

2,32

1.59/22

1.50/8

1.73/11

1.45/11

32/5

2,68

1.36/22

1.38/8

0.91/11

1.82/11

2017-02-07

Nimes

3-0

Niort

34/6

2,70

1.43/23

1.75/8

0.91/11

1.92/12

29/-1

2,57

1.43/23

1.25/8

1.67/12

1.18/11

2017-02-10

Nimes

1-1

Tours

37/9

2,71

1.50/24

1.75/8

1.08/12

1.92/12

25/-12

2,70

0.87/23

1.25/8

0.77/13

1.00/10

2017-02-17

Troyes

0-0

Nimes

33/6

2,40

1.56/25

1.00/8

2.08/13

1.00/12

38/9

2,68

1.48/25

1.88/8

1.08/13

1.92/12

2017-02-24

Nimes

1-1

GFC Ajaccio

38/9

2,58

1.46/26

2.00/8

1.08/13

1.85/13

26/-1

2,04

1.35/26

1.38/8

1.62/13

1.08/13

2017-03-03

Bourg en Bresse

0-1

Nimes

37/2

2,67

1.41/27

2.00/8

1.71/14

1.08/13

39/9

2,56

1.44/27

1.75/8

1.07/14

1.85/13

2017-03-10

Nimes

2-0

Red Star

40/10

2,50

1.50/28

2.00/8

1.07/14

1.93/14

28/-9

2,32

1.11/28

1.50/8

1.13/15

1.08/13

2017-03-17

Sochaux

2-1

Nimes

27/0

1,86

1.31/29

0.63/8

1.36/14

1.27/15

42/12

2,48

1.55/29

2.00/8

1.20/15

1.93/14

2017-03-31

Nimes

1-0

Valenciennes

43/11

2,50

1.50/30

1.88/8

1.20/15

1.80/15

36/-5

2,57

1.13/30

0.75/8

1.40/15

0.87/15

2017-04-07

Clermont

2-3

Nimes

34/2

2,13

1.29/31

1.38/8

1.20/15

1.38/16

44/12

2,45

1.55/31

1.88/8

1.31/16

1.80/15

2017-04-14

Nimes

2-0

Orleans

47/13

2,53

1.59/32

1.88/8

1.31/16

1.88/16

32/-10

2,31

1.09/32

1.38/8

1.59/17

0.53/15

2017-04-21

Reims

1-1

Nimes

37/5

2,09

1.55/33

1.50/8

1.94/16

1.18/17

49/15

2,52

1.64/33

2.13/8

1.41/17

1.88/16

2017-04-28

Nimes

0-1

Auxerre

50/15

2,50

1.62/34

2.13/8

1.41/17

1.82/17

24/-13

1,79

1.06/34

1.00/8

1.12/17

1.00/17

2017-05-06

Brest

2-3

Nimes

48/10

2,46

1.69/35

1.25/8

1.71/17

1.67/18

50/14

2,46

1.57/35

2.00/8

1.33/18

1.82/17

2017-05-12

Nimes

3-1

AC Ajaccio

53/15

2,53

1.61/36

2.00/8

1.33/18

1.89/18

43/-10

2,67

1.25/36

1.00/8

1.89/18

0.61/18

2017-05-19

Laval

1-2

Nimes

32/-18

2,22

0.81/37

0.50/8

0.94/18

0.68/19

56/17

2,57

1.65/37

2.00/8

1.42/19

1.89/18