SELECT * FROM 1_Kampe WHERE LigaID = '89' 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
2018-10-21 Chateauroux 0-1 Brest 48/0 2,59 1.59/37 1.38/8 1.89/18 1.32/19   56/15 2,62 1.73/37 2.13/8 1.68/19 1.78/18
2018-10-21 Brest 0-1 Bourg en Bresse 22/1 2,53 1.65/17 1.38/8 1.50/8 1.78/9   22/-14 3,41 0.94/17 0.50/8 1.63/8 0.33/9
2018-10-21 Clermont 0-1 Brest 22/11 2,06 1.81/16 1.88/8 2.29/7 1.44/9   20/0 2,50 1.56/16 1.13/8 1.50/8 1.63/8
2018-10-21 Brest 0-1 Sochaux 19/-1 2,60 1.47/15 1.13/8 1.29/7 1.63/8   22/-6 3,33 1.60/15 1.63/8 1.88/8 1.29/7
2018-10-21 Lorient 0-1 Brest 20/10 2,14 1.86/14 1.50/8 2.14/7 1.57/7   17/1 2,36 1.57/14 1.50/8 1.29/7 1.86/7
2018-10-21 Valenciennes 0-1 Brest 16/-3 2,69 1.31/13 1.13/8 1.57/7 1.00/6   17/1 2,54 1.62/13 1.75/8 1.29/7 2.00/6
2018-10-21 Brest 0-1 Orleans 17/2 2,67 1.75/12 2.13/8 1.50/6 2.00/6   18/0 3,00 1.25/12 1.00/8 1.57/7 0.80/5
2018-10-21 Nimes 0-1 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
2018-10-21 Brest 0-1 Auxerre 16/6 2,60 2.00/10 2.50/8 1.60/5 2.40/5   10/-5 2,50 1.30/10 1.25/8 2.00/5 0.60/5
2018-10-21 Tours 0-1 Brest 4/-15 2,56 0.22/9 0.25/8 0.00/4 0.40/5   14/5 2,56 1.89/9 2.13/8 1.60/5 2.25/4
2018-10-21 Brest 0-1 Paris FC 13/5 2,63 2.00/8 2.00/8 1.75/4 2.25/4   9/2 2,00 2.00/8 2.00/8 2.00/5 2.00/3
2018-10-21 Niort 0-1 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
2018-10-21 Brest 0-1 Le Havre 10/2 3,00 1.67/6 1.67/6 1.33/3 2.00/3   12/9 2,50 2.17/6 2.17/6 2.33/3 2.00/3
2018-10-21 Reims 0-1 Brest 8/6 2,00 2.40/5 2.40/5 3.00/2 2.00/3   9/1 3,40 1.40/5 1.40/5 1.33/3 1.50/2
2018-10-21 Brest 0-1 Nancy 7/0 3,50 1.00/4 1.00/4 0.50/2 1.50/2   3/-2 2,00 0.75/4 0.75/4 1.00/2 0.50/2
2018-10-21 Lens 0-1 Brest 3/-3 3,00 0.00/3 0.00/3 0.00/1 0.00/2   3/-2 2,67 0.33/3 0.33/3 0.50/2 0.00/1
2018-10-21 Brest 0-1 GFC Ajaccio 3/-2 4,00 0.00/2 0.00/2 0.00/1 0.00/1   1/0 1,00 1.00/2 1.00/2 1.00/1 1.00/1
2018-10-21 AC Ajaccio 0-1 Brest 0/0 0,00 1.00/1 1.00/1 0.00/0 1.00/1   2/-1 5,00 0.00/1 0.00/1 0.00/1 0.00/0
2018-10-21 Quevilly Rouen 0-1 Brest 17/-13 2,61 0.67/18 0.88/8 1.11/9 0.22/9   25/4 2,56 1.72/18 1.38/8 1.67/9 1.78/9
2018-10-21 Brest 0-1 AC Ajaccio 29/7 2,68 1.79/19 1.63/8 1.67/9 1.90/10   30/12 2,53 1.79/19 1.38/8 2.10/10 1.44/9
2018-10-21 Brest 0-1 Quevilly Rouen 54/13 2,64 1.69/36 2.13/8 1.61/18 1.78/18   42/-22 2,94 0.83/36 1.00/8 0.78/18 0.89/18
2018-10-21 Bourg en Bresse 0-1 Brest 46/-30 3,49 0.94/35 1.13/8 1.29/17 0.61/18   50/11 2,54 1.66/35 1.75/8 1.61/18 1.71/17
2018-10-21 Brest 0-1 Clermont 49/10 2,59 1.62/34 1.75/8 1.53/17 1.71/17   48/17 2,32 1.71/34 2.00/8 2.00/17 1.41/17
2018-10-21 Sochaux 0-1 Brest 46/-6 2,97 1.55/33 1.38/8 1.94/16 1.18/17   48/10 2,61 1.64/33 2.00/8 1.53/17 1.75/16
2018-10-21 Brest 0-1 Lorient 45/7 2,59 1.59/32 1.63/8 1.44/16 1.75/16   53/15 2,84 1.75/32 1.88/8 2.06/17 1.40/15
2018-10-21 Brest 0-1 Valenciennes 42/5 2,55 1.55/31 1.38/8 1.33/15 1.75/16   37/-12 2,77 1.16/31 0.88/8 1.25/16 1.07/15
2018-10-21 Orleans 0-1 Brest 39/-7 2,83 1.27/30 1.75/8 1.27/15 1.27/15   41/5 2,57 1.57/30 1.38/8 1.33/15 1.80/15
2018-10-21 Brest 0-1 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-10-21 Auxerre 0-1 Brest 34/1 2,48 1.37/27 2.25/8 1.64/14 1.08/13   39/6 2,57 1.57/28 1.25/8 1.43/14 1.71/14
2018-10-21 Brest 0-1 Tours 38/8 2,52 1.63/27 1.25/8 1.54/13 1.71/14   17/-33 2,48 0.41/27 0.75/8 0.57/14 0.23/13
2018-10-21 Paris FC 0-1 Brest 31/9 2,04 1.77/26 1.88/8 2.08/13 1.46/13   37/7 2,58 1.58/26 1.25/8 1.54/13 1.62/13
2018-10-21 Brest 0-1 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-10-21 Le Havre 0-1 Brest 33/12 2,25 1.67/24 1.50/8 2.27/11 1.15/13   35/6 2,67 1.58/24 1.63/8 1.42/12 1.75/12
2018-10-21 Brest 0-1 Reims 35/6 2,78 1.61/23 1.88/8 1.45/11 1.75/12   41/28 2,35 2.30/23 2.63/8 2.27/11 2.33/12
2018-10-21 Nancy 0-1 Brest 22/-8 2,36 0.95/22 0.75/8 1.27/11 0.64/11   33/6 2,73 1.64/22 1.75/8 1.45/11 1.82/11
2018-10-21 Brest 0-1 Lens 32/6 2,76 1.67/21 1.75/8 1.50/10 1.82/11   28/5 2,55 1.20/20 1.88/8 1.67/9 0.82/11
2018-10-21 GFC Ajaccio 0-1 Brest 13/-13 2,05 1.21/19 1.00/8 1.67/9 0.80/10   31/6 2,80 1.70/20 1.63/8 1.50/10 1.90/10
2018-10-21 Brest 0-1 Chateauroux 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