SELECT * FROM 1_Kampe WHERE LigaID = '89' AND (Home='Bourg en Bresse' OR Away='Bourg en Bresse') 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 Sochaux 2-0 Bourg en Bresse 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 Bourg en Bresse 1-2 Paris FC 0/-2 2,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 Quevilly Rouen 1-4 Bourg en Bresse 2/0 2,00 1.00/2 1.00/2 1.00/1 1.00/1   1/-3 2,50 0.00/2 0.00/2 0.00/1 0.00/1
2017-08-18 Reims 3-0 Bourg en Bresse 4/4 1,33 3.00/3 3.00/3 3.00/1 3.00/2   5/0 3,33 1.00/3 1.00/3 0.00/1 1.50/2
2017-08-25 Bourg en Bresse 2-0 GFC Ajaccio 5/-3 3,25 0.75/4 0.75/4 0.00/1 1.00/3   2/1 0,75 1.50/4 1.50/4 2.00/2 1.00/2
2017-09-08 Clermont 4-1 Bourg en Bresse 4/2 1,20 1.60/5 1.60/5 1.50/2 1.67/3   7/-1 3,00 1.20/5 1.20/5 1.50/2 1.00/3
2017-09-15 Bourg en Bresse 3-0 Chateauroux 8/-4 3,33 1.00/6 1.00/6 1.50/2 0.75/4   12/3 3,50 2.00/6 2.00/6 2.00/3 2.00/3
2017-09-19 Nancy 2-1 Bourg en Bresse 7/-2 2,29 0.86/7 0.86/7 1.67/3 0.25/4   11/-1 3,29 1.29/7 1.29/7 2.00/3 0.75/4
2017-09-22 Bourg en Bresse 2-1 Le Havre 12/-2 3,25 1.13/8 1.13/8 2.00/3 0.60/5   13/9 2,13 2.00/8 2.00/8 2.50/4 1.50/4
2017-09-29 AC Ajaccio 2-0 Bourg en Bresse 17/8 2,89 1.89/9 2.00/8 2.25/4 1.60/5   14/-1 3,22 1.33/9 1.50/8 2.25/4 0.60/5
2017-10-13 Bourg en Bresse 0-6 Lens 14/-3 3,10 1.20/10 1.50/8 2.25/4 0.50/6   11/-6 2,80 0.60/10 0.75/8 1.20/5 0.00/5
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 Bourg en Bresse 1-1 Auxerre 14/-11 3,25 1.00/12 1.13/8 1.80/5 0.43/7   13/-4 2,50 1.42/12 1.75/8 2.17/6 0.67/6
2017-11-03 Tours 3-2 Bourg en Bresse 5/-21 2,38 0.15/13 0.25/8 0.00/6 0.29/7   15/-11 3,15 1.00/13 0.88/8 1.67/6 0.43/7
2017-11-17 Bourg en Bresse 1-3 Valenciennes 17/-12 3,29 0.93/14 0.88/8 1.67/6 0.38/8   16/-3 2,50 1.29/14 1.25/8 1.50/8 1.00/6
2017-11-24 Nimes 4-0 Bourg en Bresse 31/15 3,13 1.87/15 1.88/8 2.00/8 1.71/7   18/-14 3,33 0.87/15 0.50/8 1.43/7 0.38/8
2017-11-28 Bourg en Bresse 4-0 Orleans 18/-18 3,38 0.81/16 0.50/8 1.43/7 0.33/9   23/-1 2,94 1.19/16 0.63/8 1.33/9 1.00/7
2017-12-08 Brest 3-0 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
2017-12-15 Bourg en Bresse 2-2 Lorient 22/-17 3,39 0.89/18 0.50/8 1.63/8 0.30/10   29/10 2,67 1.78/18 1.75/8 2.10/10 1.38/8
2018-01-12 Paris FC 2-0 Bourg en Bresse 22/6 2,00 1.79/19 1.75/8 2.10/10 1.44/9   24/-17 3,42 0.89/19 0.63/8 1.56/9 0.30/10
2018-01-16 Bourg en Bresse 3-5 Quevilly Rouen 24/-19 3,35 0.85/20 0.63/8 1.56/9 0.27/11   19/-15 2,65 0.75/20 1.25/8 1.00/10 0.50/10
2018-01-19 Bourg en Bresse 0-2 Reims 27/-21 3,57 0.81/21 0.50/8 1.40/10 0.27/11   39/27 2,43 2.38/21 2.50/8 2.50/10 2.27/11
2018-01-26 GFC Ajaccio 1-2 Bourg en Bresse 18/-9 2,05 1.36/22 1.38/8 1.73/11 1.00/11   27/-23 3,50 0.77/22 0.50/8 1.27/11 0.27/11
2018-02-02 Bourg en Bresse 0-2 Clermont 29/-22 3,48 0.87/23 0.88/8 1.27/11 0.50/12   29/9 2,13 1.52/23 1.13/8 1.82/11 1.25/12
2018-02-09 Chateauroux 3-1 Bourg en Bresse 31/-1 2,63 1.58/24 1.88/8 1.73/11 1.46/13   29/-24 3,42 0.83/24 0.88/8 1.17/12 0.50/12
2018-02-16 Bourg en Bresse 3-2 Nancy 30/-26 3,44 0.80/25 0.50/8 1.17/12 0.46/13   26/-8 2,40 1.00/25 1.00/8 1.15/13 0.83/12
2018-02-23 Le Havre 0-0 Bourg en Bresse 36/12 2,31 1.65/26 1.50/8 2.33/12 1.07/14   33/-25 3,50 0.88/26 0.88/8 1.31/13 0.46/13
2018-03-02 Bourg en Bresse 5-4 AC Ajaccio 33/-25 3,37 0.89/27 0.88/8 1.31/13 0.50/14   44/13 2,78 1.78/27 1.75/8 2.21/14 1.31/13
2018-03-12 Lens 0-1 Bourg en Bresse 34/3 2,32 1.11/28 0.88/8 1.23/13 1.00/15   38/-24 3,57 0.96/28 1.25/8 1.43/14 0.50/14
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 Auxerre 3-1 Bourg en Bresse 40/1 2,63 1.33/30 1.75/8 1.53/15 1.13/15   39/-24 3,40 1.00/30 1.63/8 1.33/15 0.67/15
2018-04-06 Bourg en Bresse 1-1 Tours 40/-26 3,42 0.97/31 1.25/8 1.33/15 0.63/16   24/-30 2,52 0.58/31 1.13/8 0.69/16 0.47/15
2018-04-13 Valenciennes 2-2 Bourg en Bresse 38/-14 2,81 1.13/32 0.88/8 1.25/16 1.00/16   41/-26 3,38 0.97/32 1.38/8 1.31/16 0.63/16
2018-04-20 Bourg en Bresse 2-2 Nimes 43/-26 3,39 0.97/33 1.50/8 1.31/16 0.65/17   65/33 2,94 1.94/33 2.38/8 1.94/17 1.94/16
2018-04-24 Orleans 5-1 Bourg en Bresse 46/-9 2,97 1.24/34 1.00/8 1.35/17 1.12/17   45/-26 3,41 0.97/34 1.25/8 1.29/17 0.65/17
2018-04-27 Bourg en Bresse 2-4 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-05-04 Lorient 6-0 Bourg en Bresse 55/12 2,72 1.64/36 1.50/8 1.94/18 1.33/18   48/-32 3,56 0.92/36 0.75/8 1.22/18 0.61/18
2018-05-11 Bourg en Bresse 2-1 Sochaux 48/-38 3,62 0.89/37 0.38/8 1.22/18 0.58/19   50/-10 2,97 1.43/37 1.25/8 1.68/19 1.17/18