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

Niort

0-0

AC Ajaccio

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

Nancy

0-0

Niort

1/-2

4,00

0.00/1

0.00/1

0.00/0

0.00/1

0/0

0,00

1.00/1

1.00/1

1.00/1

0.00/0

2017-08-11

Niort

2-0

Auxerre

0/0

0,00

1.00/2

1.00/2

1.00/1

1.00/1

2/-2

3,00

1.50/2

1.50/2

3.00/1

0.00/1

2017-08-18

Niort

2-1

Tours

2/2

0,67

1.67/3

1.67/3

2.00/2

1.00/1

0/-6

2,00

0.00/3

0.00/3

0.00/2

0.00/1

2017-08-25

Valenciennes

4-1

Niort

2/0

1,00

1.25/4

1.25/4

1.00/2

1.50/2

4/3

1,25

2.00/4

2.00/4

2.33/3

1.00/1

2017-09-08

Niort

0-2

Paris FC

5/0

2,00

1.60/5

1.60/5

2.33/3

0.50/2

4/-3

2,20

1.40/5

1.40/5

1.33/3

1.50/2

2017-09-15

Orleans

3-1

Niort

9/4

2,33

1.83/6

1.83/6

2.33/3

1.33/3

5/-2

2,00

1.33/6

1.33/6

1.75/4

0.50/2

2017-09-19

Niort

0-2

Brest

6/-4

2,29

1.14/7

1.14/7

1.75/4

0.33/3

11/3

2,71

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

Niort

2-1

Quevilly Rouen

11/-2

2,67

1.22/9

1.25/8

1.40/5

1.00/4

8/-8

2,67

0.56/9

0.50/8

0.80/5

0.25/4

2017-10-16

Lorient

0-0

Niort

15/7

2,30

1.80/10

2.00/8

2.20/5

1.40/5

13/-1

2,70

1.40/10

1.50/8

1.67/6

1.00/4

2017-10-20

Niort

2-0

Bourg en Bresse

13/-1

2,45

1.36/11

1.25/8

1.67/6

1.00/5

14/-9

3,36

1.09/11

1.13/8

1.80/5

0.50/6

2017-10-27

Sochaux

2-1

Niort

15/-8

3,17

1.42/12

1.13/8

1.50/6

1.33/6

15/1

2,42

1.50/12

1.25/8

1.86/7

1.00/5

2017-11-03

Niort

1-1

Clermont

16/0

2,46

1.38/13

1.25/8

1.86/7

0.83/6

18/9

2,08

1.69/13

1.75/8

2.17/6

1.29/7

2017-11-20

Lens

3-1

Niort

18/-1

2,64

0.79/14

1.38/8

1.00/6

0.63/8

17/0

2,43

1.36/14

1.38/8

1.75/8

0.83/6

2017-11-24

Niort

2-1

Chateauroux

18/-2

2,53

1.27/15

1.38/8

1.75/8

0.71/7

21/-2

2,93

1.53/15

1.38/8

1.86/7

1.25/8

2017-11-28

GFC Ajaccio

0-2

Niort

12/-6

1,88

1.44/16

1.75/8

1.88/8

1.00/8

20/-1

2,56

1.38/16

1.75/8

1.89/9

0.71/7

2017-12-08

Niort

1-2

Reims

22/1

2,53

1.47/17

1.75/8

1.89/9

1.00/8

29/19

2,29

2.24/17

2.13/8

2.38/8

2.11/9

2017-12-15

Le Havre

2-1

Niort

25/11

2,17

1.72/18

1.50/8

2.25/8

1.30/10

23/0

2,56

1.39/18

1.38/8

1.70/10

1.00/8

2018-01-12

Niort

0-0

Nancy

24/-1

2,58

1.32/19

1.25/8

1.70/10

0.89/9

22/-5

2,58

1.05/19

0.88/8

1.40/10

0.67/9

2018-01-16

Auxerre

5-0

Niort

18/-11

2,35

1.00/20

0.38/8

1.50/10

0.50/10

24/-1

2,45

1.30/20

1.00/8

1.64/11

0.89/9

2018-01-19

Tours

2-1

Niort

10/-30

2,38

0.29/21

0.50/8

0.40/10

0.18/11

24/-6

2,57

1.24/21

1.00/8

1.64/11

0.80/10

2018-01-26

Niort

1-2

Valenciennes

25/-7

2,59

1.18/22

0.88/8

1.64/11

0.73/11

28/-9

2,95

1.18/22

1.00/8

1.42/12

0.90/10

2018-02-02

Paris FC

0-1

Niort

28/9

2,04

1.83/23

2.00/8

2.25/12

1.36/11

26/-8

2,61

1.13/23

0.88/8

1.50/12

0.73/11

2018-02-09

Niort

2-3

Orleans

27/-7

2,54

1.21/24

0.88/8

1.50/12

0.92/12

31/-4

2,75

1.25/24

1.38/8

1.38/13

1.09/11

2018-02-16

Brest

2-0

Niort

35/5

2,60

1.52/25

1.25/8

1.42/12

1.62/13

29/-8

2,64

1.16/25

0.50/8

1.38/13

0.92/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-02

Quevilly Rouen

1-2

Niort

29/-17

2,78

0.81/27

1.25/8

0.77/13

0.86/14

30/-13

2,70

1.07/27

0.50/8

1.29/14

0.85/13

2018-03-09

Niort

1-2

Lorient

32/-12

2,71

1.14/28

0.75/8

1.29/14

1.00/14

45/12

2,79

1.68/28

1.38/8

1.93/15

1.38/13

2018-03-16

Bourg en Bresse

0-1

Niort

39/-23

3,48

1.03/29

1.63/8

1.43/14

0.67/15

33/-13

2,72

1.10/29

0.75/8

1.20/15

1.00/14

2018-03-30

Niort

1-1

Sochaux

34/-12

2,67

1.17/30

1.13/8

1.20/15

1.13/15

40/-9

2,97

1.47/30

1.25/8

1.87/15

1.07/15

2018-04-06

Clermont

2-2

Niort

40/14

2,13

1.65/31

2.00/8

2.00/15

1.31/16

35/-12

2,65

1.16/31

1.25/8

1.19/16

1.13/15

2018-04-13

Niort

2-2

Lens

37/-12

2,69

1.16/32

1.00/8

1.19/16

1.13/16

38/1

2,34

1.09/32

1.13/8

1.25/16

0.94/16

2018-04-20

Chateauroux

2-1

Niort

44/0

2,67

1.64/33

1.63/8

1.94/16

1.35/17

39/-12

2,73

1.15/33

1.13/8

1.18/17

1.13/16

2018-04-24

Niort

4-1

GFC Ajaccio

40/-13

2,74

1.12/34

1.13/8

1.18/17

1.06/17

30/-18

2,29

1.12/34

1.00/8

1.53/17

0.71/17

2018-04-27

Reims

3-1

Niort

66/47

2,50

2.38/34

2.63/8

2.50/16

2.28/18

44/-10

2,80

1.17/35

1.50/8

1.28/18

1.06/17

2018-05-04

Niort

0-1

Le Havre

45/-12

2,83

1.14/36

1.13/8

1.28/18

1.00/18

50/16

2,33

1.67/36

2.00/8

2.28/18

1.06/18

2018-05-11

AC Ajaccio

2-2

Niort

60/19

2,73

1.81/37

2.00/8

2.39/18

1.26/19

45/-13

2,78

1.11/37

1.13/8

1.21/19

1.00/18