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

Troyes

1-3

Sochaux

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

Sochaux

0-0

Valenciennes

3/2

4,00

3.00/1

3.00/1

0.00/0

3.00/1

2/2

2,00

3.00/1

3.00/1

3.00/1

0.00/0

2016-08-12

Clermont

1-2

Sochaux

0/-2

1,00

0.50/2

0.50/2

1.00/1

0.00/1

3/2

2,00

2.00/2

2.00/2

1.00/1

3.00/1

2016-08-19

Sochaux

0-0

Orleans

5/3

2,33

2.33/3

2.33/3

1.00/1

3.00/2

3/0

2,00

1.00/3

1.00/3

1.50/2

0.00/1

2016-08-29

Sochaux

2-2

Brest

5/3

1,75

2.00/4

2.00/4

1.00/2

3.00/2

8/5

2,75

2.50/4

2.50/4

3.00/2

2.00/2

2016-09-09

Auxerre

0-0

Sochaux

5/0

2,00

1.00/5

1.00/5

0.00/2

1.67/3

7/3

2,20

1.80/5

1.80/5

1.00/3

3.00/2

2016-09-16

Sochaux

1-1

Reims

7/3

1,83

1.67/6

1.67/6

1.00/3

2.33/3

7/4

1,67

2.00/6

2.00/6

3.00/3

1.00/3

2016-09-20

Laval

1-1

Sochaux

4/-3

1,57

0.71/7

0.71/7

1.33/3

0.25/4

8/3

1,86

1.57/7

1.57/7

1.00/4

2.33/3

2016-09-23

Sochaux

1-0

AC Ajaccio

9/3

1,88

1.50/8

1.50/8

1.00/4

2.00/4

10/1

2,38

1.38/8

1.38/8

2.25/4

0.50/4

2016-10-03

Le Havre

2-1

Sochaux

9/0

2,00

1.44/9

1.25/8

1.25/4

1.60/5

10/4

1,78

1.67/9

1.50/8

1.40/5

2.00/4

2016-10-17

Sochaux

1-0

Lens

11/3

1,90

1.50/10

1.38/8

1.40/5

1.60/5

15/6

2,40

1.70/10

1.88/8

1.60/5

1.80/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-29

Sochaux

1-2

Strasbourg

12/4

1,67

1.58/12

1.38/8

1.67/6

1.50/6

14/1

2,25

1.42/12

1.13/8

1.83/6

1.00/6

2016-11-04

Niort

2-0

Sochaux

15/-2

2,46

1.31/13

1.75/8

1.33/6

1.29/7

13/3

1,77

1.46/13

1.25/8

1.43/7

1.50/6

2016-11-18

Sochaux

2-1

Tours

13/1

1,79

1.36/14

1.13/8

1.43/7

1.29/7

16/-10

3,00

0.71/14

0.50/8

0.63/8

0.83/6

2016-11-25

GFC Ajaccio

0-1

Sochaux

14/0

1,87

1.33/15

1.25/8

1.43/7

1.25/8

15/2

1,87

1.47/15

1.38/8

1.63/8

1.29/7

2016-11-29

Sochaux

1-1

Bourg en Bresse

16/3

1,81

1.56/16

1.63/8

1.63/8

1.50/8

20/-1

2,56

1.19/16

1.25/8

1.44/9

0.86/7

2016-12-09

Amiens

0-1

Sochaux

21/9

1,94

1.65/17

1.25/8

1.63/8

1.67/9

17/3

1,82

1.53/17

1.38/8

1.56/9

1.50/8

2016-12-16

Sochaux

2-0

Red Star

18/4

1,78

1.61/18

1.75/8

1.56/9

1.67/9

16/-7

2,17

1.06/18

1.13/8

1.30/10

0.75/8

2017-01-16

Valenciennes

2-1

Sochaux

28/2

2,84

1.26/19

0.88/8

1.44/9

1.10/10

20/6

1,79

1.68/19

1.75/8

1.70/10

1.67/9

2017-01-20

Sochaux

3-3

Clermont

21/5

1,85

1.60/20

1.63/8

1.70/10

1.50/10

23/4

2,10

1.40/20

1.88/8

1.60/10

1.20/10

2017-01-27

Orleans

1-0

Sochaux

15/-13

2,05

0.71/21

0.63/8

1.18/11

0.20/10

24/5

2,05

1.57/21

1.75/8

1.64/11

1.50/10

2017-02-04

Brest

2-0

Sochaux

28/6

2,27

1.86/22

1.63/8

1.73/11

2.00/11

24/4

2,00

1.50/22

1.75/8

1.64/11

1.36/11

2017-02-07

Sochaux

0-1

Auxerre

24/2

2,00

1.43/23

1.38/8

1.64/11

1.25/12

15/-14

1,91

0.83/23

1.00/8

0.82/11

0.83/12

2017-02-11

Reims

0-1

Sochaux

26/6

1,92

1.63/24

1.63/8

2.36/11

1.00/13

24/1

1,96

1.38/24

1.00/8

1.50/12

1.25/12

2017-02-17

Sochaux

1-1

Laval

25/2

1,92

1.44/25

1.25/8

1.50/12

1.38/13

20/-6

1,84

0.92/25

1.13/8

1.00/12

0.85/13

2017-02-24

AC Ajaccio

0-0

Sochaux

30/-5

2,50

1.27/26

1.50/8

2.00/13

0.54/13

26/2

1,92

1.42/26

1.00/8

1.46/13

1.38/13

2017-03-03

Sochaux

0-1

Le Havre

26/2

1,85

1.41/27

0.75/8

1.46/13

1.36/14

26/2

1,85

1.33/27

1.13/8

1.46/13

1.21/14

2017-03-13

Lens

2-1

Sochaux

39/9

2,46

1.64/28

1.38/8

1.77/13

1.53/15

26/1

1,82

1.36/28

0.75/8

1.36/14

1.36/14

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-04-03

Strasbourg

2-0

Sochaux

47/8

2,87

1.63/30

1.63/8

2.13/15

1.13/15

29/1

1,90

1.37/30

1.00/8

1.47/15

1.27/15

2017-04-07

Sochaux

2-2

Niort

29/-1

1,90

1.32/31

1.00/8

1.47/15

1.19/16

39/-2

2,58

1.48/31

1.63/8

1.81/16

1.13/15

2017-04-14

Tours

3-1

Sochaux

43/-7

2,91

1.03/32

1.50/8

1.06/16

1.00/16

31/-1

1,97

1.31/32

1.13/8

1.44/16

1.19/16

2017-04-21

Sochaux

1-2

GFC Ajaccio

32/-3

2,03

1.27/33

0.75/8

1.44/16

1.12/17

42/3

2,45

1.36/33

1.63/8

1.53/17

1.19/16

2017-04-28

Bourg en Bresse

0-1

Sochaux

44/-7

2,79

1.21/34

0.75/8

1.41/17

1.00/17

33/-4

2,06

1.24/34

0.63/8

1.35/17

1.12/17

2017-05-05

Sochaux

1-2

Amiens

34/-3

2,03

1.29/35

0.88/8

1.35/17

1.22/18

49/13

2,43

1.63/35

1.88/8

1.72/18

1.53/17

2017-05-12

Red Star

1-1

Sochaux

35/-19

2,47

0.97/36

0.50/8

1.11/18

0.83/18

35/-4

2,06

1.25/36

0.88/8

1.28/18

1.22/18

2017-05-19

Sochaux

2-3

Troyes

36/-4

2,05

1.24/37

1.00/8

1.28/18

1.21/19

56/15

2,62

1.70/37

2.38/8

2.26/19

1.11/18