SELECT * FROM 1_Kampe WHERE LigaID = '89' AND (Home='Auxerre' OR Away='Auxerre') 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-31 Auxerre 1-0 Lens 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 Le Havre 4-1 Auxerre 3/3 3,00 3.00/1 3.00/1 0.00/0 3.00/1   1/1 1,00 3.00/1 3.00/1 3.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 Auxerre 1-3 Orleans 2/-4 2,67 1.00/3 1.00/3 3.00/1 0.00/2   3/0 2,00 1.33/3 1.33/3 2.00/2 0.00/1
2017-08-25 Paris FC 2-1 Auxerre 2/-4 2,00 1.00/4 1.00/4 0.50/2 1.50/2   3/-6 3,00 0.75/4 0.75/4 1.50/2 0.00/2
2017-09-08 Auxerre 1-1 Tours 4/-7 3,00 0.60/5 0.60/5 1.50/2 0.00/3   2/-9 2,60 0.00/5 0.00/5 0.00/3 0.00/2
2017-09-15 Nimes 3-0 Auxerre 7/3 1,83 1.67/6 1.67/6 1.33/3 2.00/3   5/-7 2,83 0.67/6 0.67/6 1.33/3 0.00/3
2017-09-19 Auxerre 1-0 Lorient 5/-10 2,86 0.57/7 0.57/7 1.33/3 0.00/4   13/9 2,43 2.43/7 2.43/7 2.50/4 2.33/3
2017-09-22 Valenciennes 0-2 Auxerre 7/-2 2,00 1.38/8 1.38/8 2.00/4 0.75/4   6/-9 2,63 0.88/8 0.88/8 1.75/4 0.00/4
2017-09-29 Auxerre 2-0 Sochaux 8/-7 2,56 1.11/9 0.88/8 1.75/4 0.60/5   13/-8 3,78 1.22/9 1.00/8 1.20/5 1.25/4
2017-10-13 Brest 1-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
2017-10-20 Auxerre 2-1 Quevilly Rouen 11/-5 2,45 1.27/11 1.38/8 2.00/5 0.67/6   9/-10 2,55 0.45/11 0.38/8 0.67/6 0.20/5
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 Auxerre 0-1 GFC Ajaccio 14/-4 2,46 1.38/13 1.88/8 2.17/6 0.71/7   8/-8 1,85 1.23/13 1.25/8 2.00/7 0.33/6
2017-11-17 Clermont 1-0 Auxerre 19/9 2,07 1.64/14 1.50/8 2.17/6 1.25/8   14/-5 2,36 1.29/14 1.75/8 1.86/7 0.71/7
2017-11-24 Auxerre 1-1 Nancy 14/-6 2,27 1.20/15 1.75/8 1.86/7 0.63/8   19/-2 2,67 1.07/15 1.25/8 1.75/8 0.29/7
2017-11-27 Reims 2-0 Auxerre 27/17 2,31 2.19/16 2.13/8 2.29/7 2.11/9   15/-6 2,25 1.19/16 1.50/8 1.75/8 0.63/8
2017-12-08 Auxerre 1-2 Chateauroux 15/-8 2,24 1.12/17 1.13/8 1.75/8 0.56/9   22/-3 2,76 1.41/17 1.50/8 1.75/8 1.11/9
2017-12-15 AC Ajaccio 3-1 Auxerre 27/10 2,44 1.72/18 1.38/8 2.00/9 1.44/9   16/-9 2,28 1.06/18 0.75/8 1.56/9 0.56/9
2018-01-12 Auxerre 1-1 Le Havre 17/-11 2,37 1.00/19 0.63/8 1.56/9 0.50/10   27/12 2,21 1.79/19 1.88/8 2.33/9 1.30/10
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 Orleans 2-3 Auxerre 26/-5 2,71 1.14/21 0.75/8 1.36/11 0.90/10   23/-6 2,48 1.10/21 0.63/8 1.64/11 0.50/10
2018-01-26 Auxerre 1-1 Paris FC 26/-5 2,59 1.18/22 1.00/8 1.64/11 0.73/11   27/9 2,05 1.86/22 2.00/8 2.25/12 1.40/10
2018-02-02 Tours 0-2 Auxerre 13/-30 2,43 0.39/23 0.50/8 0.64/11 0.17/12   27/-5 2,57 1.17/23 1.13/8 1.58/12 0.73/11
2018-02-12 Auxerre 0-0 Nimes 29/-3 2,54 1.25/24 1.38/8 1.58/12 0.92/12   47/23 2,96 1.83/24 1.63/8 2.00/13 1.64/11
2018-02-17 Lorient 1-3 Auxerre 41/11 2,84 1.64/25 1.50/8 2.00/13 1.25/12   29/-3 2,44 1.24/25 1.50/8 1.54/13 0.92/12
2018-02-23 Auxerre 2-0 Valenciennes 32/-1 2,50 1.31/26 1.88/8 1.54/13 1.08/13   33/-7 2,81 1.27/26 1.00/8 1.43/14 1.08/12
2018-03-09 Auxerre 1-2 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-03-13 Sochaux 0-4 Auxerre 40/-5 3,04 1.54/28 1.63/8 2.08/13 1.07/15   35/0 2,50 1.32/28 2.13/8 1.53/15 1.08/13
2018-03-16 Quevilly Rouen 4-1 Auxerre 30/-20 2,76 0.76/29 0.50/8 0.71/14 0.80/15   39/4 2,55 1.38/29 2.13/8 1.53/15 1.21/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 GFC Ajaccio 3-1 Auxerre 23/-20 2,13 1.03/31 0.25/8 1.33/15 0.75/16   43/3 2,68 1.39/31 2.00/8 1.63/16 1.13/15
2018-04-13 Auxerre 1-2 Clermont 44/1 2,72 1.34/32 1.63/8 1.63/16 1.06/16   42/14 2,19 1.63/32 1.75/8 1.94/16 1.31/16
2018-04-21 Nancy 2-1 Auxerre 30/-17 2,33 0.88/33 0.50/8 1.13/16 0.65/17   45/0 2,73 1.30/33 1.50/8 1.53/17 1.06/16
2018-04-24 Auxerre 1-4 Reims 46/-1 2,74 1.26/34 1.13/8 1.53/17 1.00/17   62/44 2,42 2.36/33 2.63/8 2.50/16 2.24/17
2018-04-27 Chateauroux 1-2 Auxerre 46/1 2,60 1.66/35 1.63/8 2.00/17 1.33/18   47/-4 2,80 1.23/35 0.75/8 1.44/18 1.00/17
2018-05-04 Auxerre 1-1 AC Ajaccio 49/-3 2,81 1.28/36 1.13/8 1.44/18 1.11/18   59/19 2,75 1.83/36 2.25/8 2.39/18 1.28/18
2018-05-11 Lens 2-1 Auxerre 46/-2 2,54 1.08/37 1.13/8 1.33/18 0.84/19   50/-3 2,78 1.27/37 0.88/8 1.42/19 1.11/18