SELECT * FROM 1_Kampe WHERE LigaID = '90' 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
2016-07-30 Red Star 0-0 Auxerre 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 Auxerre 1-2 GFC Ajaccio 0/0 0,00 1.00/1 1.00/1 0.00/0 1.00/1   0/0 0,00 1.00/1 1.00/1 1.00/1 0.00/0
2016-08-12 Bourg en Bresse 2-4 Auxerre 0/-1 0,50 0.50/2 0.50/2 1.00/1 0.00/1   1/-1 1,50 0.50/2 0.50/2 0.00/1 1.00/1
2016-08-19 Auxerre 0-1 Clermont 5/1 3,00 1.33/3 1.33/3 0.00/1 2.00/2   1/-3 1,67 0.33/3 0.33/3 0.50/2 0.00/1
2016-08-26 Orleans 0-0 Auxerre 3/0 1,50 1.00/4 1.00/4 1.50/2 0.50/2   5/0 2,50 1.00/4 1.00/4 0.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-17 Brest 1-0 Auxerre 10/3 2,83 1.83/6 1.83/6 2.00/3 1.67/3   5/0 1,67 1.00/6 1.00/6 0.33/3 1.67/3
2016-09-20 AC Ajaccio 2-0 Auxerre 8/-1 2,43 1.14/7 1.14/7 2.00/3 0.50/4   5/-1 1,57 0.86/7 0.86/7 0.33/3 1.25/4
2016-09-23 Auxerre 0-1 Le Havre 5/-3 1,63 0.75/8 0.75/8 0.33/3 1.00/5   8/-1 2,13 1.25/8 1.25/8 1.25/4 1.25/4
2016-09-30 Reims 3-0 Auxerre 11/4 2,00 1.78/9 1.88/8 3.00/4 0.80/5   5/-4 1,56 0.67/9 0.63/8 0.25/4 1.00/5
2016-10-14 Auxerre 2-0 Laval 5/-7 1,70 0.60/10 0.63/8 0.25/4 0.83/6   6/-3 1,50 0.80/10 0.75/8 1.20/5 0.40/5
2016-10-21 Strasbourg 2-1 Auxerre 12/0 2,18 1.27/11 0.88/8 1.60/5 1.00/6   7/-5 1,73 0.82/11 0.63/8 0.80/5 0.83/6
2016-10-29 Auxerre 0-4 Niort 8/-6 1,83 0.75/12 0.63/8 0.80/5 0.71/7   11/-6 2,33 1.17/12 1.50/8 1.33/6 1.00/6
2016-11-04 Amiens 0-0 Auxerre 17/6 2,15 1.69/13 1.50/8 1.50/6 1.86/7   8/-10 2,00 0.69/13 0.50/8 0.67/6 0.71/7
2016-11-18 Auxerre 1-1 Lens 8/-10 1,86 0.71/14 0.50/8 0.67/6 0.75/8   19/6 2,29 1.57/14 1.88/8 1.43/7 1.71/7
2016-11-25 Tours 2-1 Auxerre 17/-11 3,00 0.67/15 0.50/8 0.63/8 0.71/7   9/-10 1,87 0.73/15 0.63/8 0.71/7 0.75/8
2016-11-29 Auxerre 2-0 Nimes 10/-11 1,94 0.69/16 0.63/8 0.71/7 0.67/9   24/5 2,69 1.38/16 1.63/8 1.00/8 1.75/8
2016-12-09 Troyes 1-1 Auxerre 23/6 2,35 1.82/17 2.38/8 2.22/9 1.38/8   12/-9 1,94 0.82/17 1.00/8 1.00/8 0.67/9
2016-12-16 Auxerre 1-1 Valenciennes 13/-9 1,94 0.83/18 1.13/8 1.00/8 0.70/10   27/2 2,89 1.28/18 1.13/8 1.44/9 1.11/9
2017-01-13 GFC Ajaccio 2-0 Auxerre 19/1 1,95 1.26/19 1.25/8 1.44/9 1.10/10   14/-9 1,95 0.84/19 0.88/8 1.00/9 0.70/10
2017-01-20 Auxerre 0-2 Bourg en Bresse 14/-11 1,95 0.80/20 0.88/8 1.00/9 0.64/11   23/0 2,30 1.25/20 1.75/8 1.55/11 0.89/9
2017-01-27 Clermont 0-1 Auxerre 26/4 2,29 1.38/21 1.63/8 1.60/10 1.18/11   14/-13 1,95 0.76/21 0.88/8 0.90/10 0.64/11
2017-02-04 Auxerre 0-2 Orleans 15/-12 1,91 0.86/22 1.13/8 0.90/10 0.83/12   16/-12 2,00 0.82/22 0.88/8 1.33/12 0.20/10
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-10 Auxerre 3-1 Brest 16/-13 1,88 0.92/24 1.38/8 0.82/11 1.00/13   31/8 2,25 1.88/24 2.13/8 1.83/12 1.92/12
2017-02-17 Auxerre 1-0 AC Ajaccio 19/-11 1,96 1.00/25 1.38/8 1.00/12 1.00/13   30/-4 2,56 1.32/25 1.50/8 2.00/13 0.58/12
2017-02-24 Le Havre 1-0 Auxerre 25/1 1,88 1.27/26 0.75/8 1.33/12 1.21/14   20/-10 1,92 1.08/26 1.63/8 1.15/13 1.00/13
2017-03-03 Auxerre 1-2 Reims 20/-11 1,89 1.04/27 1.50/8 1.15/13 0.93/14   28/6 1,85 1.59/27 1.25/8 2.08/13 1.14/14
2017-03-10 Laval 0-0 Auxerre 24/-8 2,00 0.89/28 1.00/8 0.92/13 0.87/15   21/-12 1,93 1.00/28 1.50/8 1.07/14 0.93/14
2017-03-20 Auxerre 0-2 Strasbourg 21/-12 1,86 1.00/29 1.63/8 1.07/14 0.93/15   45/6 2,90 1.59/29 1.63/8 2.13/15 1.00/14
2017-03-31 Niort 1-0 Auxerre 38/-3 2,63 1.43/30 1.63/8 1.73/15 1.13/15   21/-14 1,87 0.97/30 1.25/8 1.00/15 0.93/15
2017-04-07 Auxerre 1-0 Amiens 21/-15 1,84 0.94/31 1.25/8 1.00/15 0.88/16   42/10 2,39 1.55/31 1.63/8 1.56/16 1.53/15
2017-04-15 Lens 0-1 Auxerre 49/13 2,66 1.72/32 2.25/8 1.73/15 1.71/17   22/-14 1,81 1.00/32 1.25/8 1.13/16 0.88/16
2017-04-21 Auxerre 1-1 Tours 23/-13 1,79 1.06/33 1.25/8 1.13/16 1.00/17   46/-5 2,94 1.09/33 1.88/8 1.18/17 1.00/16
2017-04-28 Nimes 0-1 Auxerre 50/15 2,50 1.62/34 2.13/8 1.41/17 1.82/17   24/-13 1,79 1.06/34 1.00/8 1.12/17 1.00/17
2017-05-05 Auxerre 2-3 Troyes 25/-12 1,77 1.11/35 1.38/8 1.12/17 1.11/18   51/12 2,57 1.63/35 2.00/8 2.22/18 1.00/17
2017-05-12 Valenciennes 0-0 Auxerre 44/1 2,42 1.22/36 1.25/8 1.56/18 0.89/18   27/-13 1,86 1.08/36 1.38/8 1.06/18 1.11/18
2017-05-19 Auxerre 1-0 Red Star 27/-13 1,81 1.08/37 1.38/8 1.06/18 1.11/19   36/-19 2,46 0.97/37 0.63/8 1.11/19 0.83/18