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

2012-08-11

Nancy

1-0

Brest

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

2012-08-18

Brest

1-0

Thonon-Evian

0/-1

1,00

0.00/1

0.00/1

0.00/0

0.00/1

2/-1

5,00

0.00/1

0.00/1

0.00/1

0.00/0

2012-08-26

St Etienne

4-0

Brest

2/-2

3,00

0.00/2

0.00/2

0.00/1

0.00/1

1/0

1,00

1.50/2

1.50/2

3.00/1

0.00/1

2012-09-01

Brest

2-1

Troyes

1/-4

2,00

1.00/3

1.00/3

3.00/1

0.00/2

3/-4

3,33

0.33/3

0.33/3

0.50/2

0.00/1

2012-09-15

Nice

4-2

Brest

3/-1

1,75

0.75/4

0.75/4

0.50/2

1.00/2

3/-3

2,25

1.50/4

1.50/4

3.00/2

0.00/2

2012-09-22

Brest

2-1

Valenciennes

5/-5

3,00

1.20/5

1.20/5

3.00/2

0.00/3

6/3

1,80

1.60/5

1.60/5

1.67/3

1.50/2

2012-09-29

AC Ajaccio

1-0

Brest

5/-2

2,00

1.33/6

1.33/6

2.00/2

1.00/4

7/-4

3,00

1.50/6

1.50/6

3.00/3

0.00/3

2012-10-07

Brest

1-1

Bordeaux

7/-5

2,71

1.29/7

1.29/7

3.00/3

0.00/4

9/4

2,00

1.86/7

1.86/7

1.67/3

2.00/4

2012-10-21

Lyon

1-0

Brest

13/5

2,63

1.88/8

1.88/8

2.25/4

1.50/4

8/-5

2,63

1.25/8

1.25/8

2.50/4

0.00/4

2012-10-27

Toulouse

3-1

Brest

15/6

2,67

1.78/9

1.88/8

1.50/4

2.00/5

8/-6

2,44

1.11/9

1.25/8

2.50/4

0.00/5

2012-11-02

Brest

2-0

Lorient

9/-8

2,60

1.00/10

0.88/8

2.50/4

0.00/6

19/0

3,80

1.50/10

1.38/8

1.80/5

1.20/5

2012-11-10

Lille

1-0

Brest

15/3

2,45

1.55/11

1.50/8

1.60/5

1.50/6

11/-6

2,55

1.18/11

1.25/8

2.60/5

0.00/6

2012-11-17

Brest

3-0

Bastia

11/-7

2,42

1.08/12

0.88/8

2.60/5

0.00/7

19/-10

4,00

1.17/12

1.00/8

1.50/6

0.83/6

2012-11-24

Reims

0-0

Brest

13/-1

2,08

1.15/13

1.00/8

1.86/7

0.33/6

14/-4

2,46

1.23/13

1.25/8

2.67/6

0.00/7

2012-12-02

Brest

1-2

Marseille

14/-4

2,29

1.21/14

1.00/8

2.67/6

0.13/8

18/3

2,36

1.86/14

1.00/8

2.00/7

1.71/7

2012-12-08

Rennes

2-2

Brest

21/2

2,67

1.67/15

2.25/8

1.71/7

1.63/8

15/-5

2,33

1.13/15

1.00/8

2.29/7

0.13/8

2012-12-12

Brest

1-2

Montpellier

17/-5

2,44

1.13/16

1.00/8

2.29/7

0.22/9

22/3

2,56

1.25/16

1.50/8

1.50/8

1.00/8

2012-12-15

Sochaux

1-2

Brest

16/-9

2,41

0.94/17

1.13/8

1.00/8

0.89/9

18/-6

2,47

1.06/17

1.00/8

2.00/8

0.22/9

2012-12-21

Brest

0-3

PSG

20/-5

2,50

1.17/18

1.38/8

2.00/8

0.50/10

33/21

2,50

1.94/18

1.63/8

2.00/10

1.88/8

2013-01-12

Thonon-Evian

0-2

Brest

22/-10

2,84

1.00/19

1.38/8

1.11/9

0.90/10

20/-8

2,53

1.11/19

1.00/8

1.78/9

0.50/10

2013-01-19

Brest

0-1

St Etienne

22/-6

2,50

1.20/20

1.38/8

1.78/9

0.73/11

26/10

2,10

1.40/20

0.88/8

1.55/11

1.22/9

2013-01-26

Troyes

2-1

Brest

23/-19

3,10

0.62/21

0.63/8

1.00/11

0.20/10

22/-7

2,43

1.14/21

1.00/8

1.60/10

0.73/11

2013-02-02

Brest

0-2

Nice

23/-8

2,45

1.09/22

0.88/8

1.60/10

0.67/12

33/6

2,73

1.59/22

2.00/8

2.00/12

1.10/10

2013-02-09

Valenciennes

2-1

Brest

32/-2

2,87

1.30/23

0.63/8

1.91/11

0.75/12

23/-10

2,43

1.04/23

0.88/8

1.45/11

0.67/12

2013-02-16

Brest

1-1

AC Ajaccio

24/-11

2,46

1.00/24

0.75/8

1.45/11

0.62/13

27/-5

2,46

1.25/24

1.50/8

1.58/12

0.92/12

2013-02-24

Bordeaux

0-2

Brest

26/6

1,84

1.52/25

1.38/8

1.50/12

1.54/13

25/-11

2,44

1.00/25

0.88/8

1.42/12

0.62/13

2013-03-03

Brest

1-1

Lyon

27/-9

2,42

1.08/26

0.88/8

1.42/12

0.79/14

46/21

2,73

1.96/26

2.00/8

2.23/13

1.69/13

2013-03-09

Brest

0-1

Toulouse

28/-9

2,41

1.07/27

1.00/8

1.38/13

0.79/14

32/0

2,37

1.26/27

1.00/8

1.50/14

1.00/13

2013-03-16

Lorient

4-0

Brest

43/-1

3,11

1.43/28

1.13/8

1.93/14

0.93/14

28/-10

2,36

1.04/28

0.63/8

1.29/14

0.79/14

2013-03-31

Brest

1-2

Lille

28/-14

2,41

1.00/29

0.63/8

1.29/14

0.73/15

41/11

2,45

1.59/29

2.00/8

1.79/14

1.40/15

2013-04-06

Bastia

4-0

Brest

38/-18

3,13

1.20/30

1.38/8

1.57/14

0.88/16

29/-15

2,43

0.97/30

0.63/8

1.20/15

0.73/15

2013-04-13

Brest

0-2

Reims

29/-19

2,48

0.94/31

0.63/8

1.20/15

0.69/16

29/-8

2,13

1.10/31

1.75/8

1.69/16

0.47/15

2013-04-20

Marseille

1-0

Brest

36/4

2,13

1.81/32

1.88/8

2.00/15

1.65/17

29/-21

2,47

0.91/32

0.63/8

1.13/16

0.69/16

2013-04-27

Brest

0-2

Rennes

29/-22

2,42

0.88/33

0.50/8

1.13/16

0.65/17

44/-5

2,82

1.27/33

0.25/8

1.29/17

1.25/16

2013-05-04

Montpellier

2-1

Brest

51/6

2,82

1.41/34

0.88/8

2.00/17

0.82/17

29/-24

2,41

0.85/34

0.13/8

1.06/17

0.65/17

2013-05-11

Brest

0-2

Sochaux

30/-25

2,43

0.83/35

0.00/8

1.06/17

0.61/18

38/-17

2,66

1.06/35

1.25/8

1.28/18

0.82/17

2013-05-18

PSG

3-1

Brest

63/42

2,33

2.14/36

2.50/8

2.22/18

2.06/18

30/-27

2,42

0.81/36

0.00/8

1.00/18

0.61/18

2013-05-26

Brest

1-2

Nancy

31/-29

2,46

0.78/37

0.00/8

1.00/18

0.58/19

36/-21

2,51

0.95/37

1.38/8

1.05/19

0.83/18

2018-10-21

Paris SG

0-1

Brest

17/3

1,11

1.61/28

1.50/8

0.00/13

3.00/15

32/-30

2,47

0.76/38

0.00/8

0.95/19

0.58/19

2018-10-21

Brest

0-1

Paris SG

33/-29

2,44

0.82/39

0.75/8

0.95/19

0.70/20

12/1

1,15

1.50/20

1.50/8

0.00/10

3.00/10

2018-10-21

Evian TG

0-1

Brest

11/3

1,00

1.74/19

1.13/8

0.00/8

3.00/11

33/-30

2,40

0.80/40

0.75/8

0.90/20

0.70/20

2018-10-21

Brest

0-1

Evian TG

34/-29

2,37

0.85/41

0.75/8

0.90/20

0.81/21

9/1

1,00

1.59/17

1.13/8

0.00/8

3.00/9