SELECT * FROM 1_Kampe WHERE LigaID = '90' AND (Home='Le Havre' OR Away='Le Havre') 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-29 Orleans 0-1 Le Havre 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 Le Havre 1-0 Nimes 1/1 1,00 3.00/1 3.00/1 0.00/0 3.00/1   0/0 0,00 1.00/1 1.00/1 1.00/1 0.00/0
2016-08-12 GFC Ajaccio 1-1 Le Havre 2/1 1,50 2.00/2 2.00/2 1.00/1 3.00/1   2/2 1,00 3.00/2 3.00/2 3.00/1 3.00/1
2016-08-19 Le Havre 1-3 Troyes 3/2 1,33 2.33/3 2.33/3 3.00/1 2.00/2   3/-2 2,67 1.00/3 1.00/3 1.50/2 0.00/1
2016-08-27 Red Star 0-0 Le Havre 1/-4 1,50 0.50/4 0.50/4 0.50/2 0.50/2   4/0 2,00 1.75/4 1.75/4 1.50/2 2.00/2
2016-09-10 Le Havre 2-2 Valenciennes 4/0 1,60 1.60/5 1.60/5 1.50/2 1.67/3   6/3 1,80 1.60/5 1.60/5 2.33/3 0.50/2
2016-09-16 Bourg en Bresse 2-1 Le Havre 6/-5 2,83 0.50/6 0.50/6 0.67/3 0.33/3   6/0 2,00 1.50/6 1.50/6 1.33/3 1.67/3
2016-09-20 Le Havre 1-1 Brest 7/-1 2,14 1.29/7 1.29/7 1.33/3 1.25/4   11/4 2,57 2.00/7 2.00/7 2.25/4 1.67/3
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-10-03 Le Havre 2-1 Sochaux 9/0 2,00 1.44/9 1.25/8 1.25/4 1.60/5   10/4 1,78 1.67/9 1.50/8 1.40/5 2.00/4
2016-10-14 Clermont 1-3 Le Havre 9/0 1,80 1.30/10 1.50/8 1.20/5 1.40/5   11/1 2,10 1.60/10 1.25/8 1.60/5 1.60/5
2016-10-21 Le Havre 2-0 AC Ajaccio 14/3 2,27 1.73/11 1.50/8 1.60/5 1.83/6   12/1 2,09 1.36/11 1.38/8 2.17/6 0.40/5
2016-10-28 Reims 1-0 Le Havre 15/6 2,00 1.67/12 1.50/8 3.00/5 0.71/7   16/5 2,25 1.83/12 1.88/8 1.83/6 1.83/6
2016-11-04 Laval 0-2 Le Havre 9/-4 1,69 0.85/13 1.13/8 1.00/6 0.71/7   16/4 2,15 1.69/13 1.75/8 1.83/6 1.57/7
2016-11-19 Le Havre 0-0 Amiens 18/6 2,14 1.79/14 2.00/8 1.83/6 1.75/8   17/6 2,00 1.64/14 1.25/8 1.43/7 1.86/7
2016-11-25 Lens 1-0 Le Havre 20/6 2,27 1.53/15 1.88/8 1.43/7 1.63/8   18/6 2,00 1.73/15 2.13/8 1.71/7 1.75/8
2016-11-29 Le Havre 0-1 Strasbourg 18/5 1,94 1.63/16 2.00/8 1.71/7 1.56/9   18/0 2,25 1.44/16 1.25/8 1.75/8 1.13/8
2016-12-09 Niort 1-1 Le Havre 21/0 2,47 1.41/17 2.00/8 1.50/8 1.33/9   18/4 1,88 1.53/17 1.63/8 1.50/8 1.56/9
2016-12-16 Le Havre 0-2 Tours 19/4 1,89 1.50/18 1.38/8 1.50/8 1.50/10   20/-10 2,78 0.83/18 1.13/8 0.90/10 0.75/8
2017-01-13 Nimes 0-0 Le Havre 27/3 2,68 1.32/19 1.38/8 0.89/9 1.70/10   19/2 1,89 1.42/19 1.00/8 1.33/9 1.50/10
2017-01-20 Le Havre 1-2 GFC Ajaccio 19/2 1,80 1.40/20 0.75/8 1.33/9 1.45/11   21/3 1,95 1.35/20 1.25/8 1.60/10 1.10/10
2017-01-27 Troyes 2-1 Le Havre 25/2 2,29 1.52/21 1.25/8 1.91/11 1.10/10   20/1 1,86 1.33/21 0.75/8 1.20/10 1.45/11
2017-02-03 Le Havre 1-1 Red Star 21/0 1,91 1.27/22 0.38/8 1.20/10 1.33/12   18/-11 2,14 1.00/22 0.88/8 1.08/12 0.90/10
2017-02-06 Valenciennes 0-0 Le Havre 30/2 2,52 1.26/23 1.38/8 1.45/11 1.08/12   22/0 1,91 1.26/23 0.38/8 1.18/11 1.33/12
2017-02-10 Le Havre 3-0 Bourg en Bresse 22/0 1,83 1.25/24 0.50/8 1.18/11 1.31/13   30/2 2,42 1.33/24 1.63/8 1.62/13 1.00/11
2017-02-18 Brest 2-0 Le Havre 32/6 2,32 1.80/25 1.75/8 1.83/12 1.77/13   25/3 1,88 1.32/25 0.88/8 1.33/12 1.31/13
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 Sochaux 0-1 Le Havre 26/2 1,85 1.41/27 0.75/8 1.46/13 1.36/14   26/2 1,85 1.33/27 1.13/8 1.46/13 1.21/14
2017-03-10 Le Havre 0-1 Clermont 27/3 1,82 1.39/28 1.38/8 1.46/13 1.33/15   32/1 2,25 1.21/28 0.75/8 1.29/14 1.14/14
2017-03-17 AC Ajaccio 0-0 Le Havre 32/-7 2,45 1.28/29 1.25/8 1.93/14 0.67/15   27/2 1,79 1.34/29 1.38/8 1.36/14 1.33/15
2017-03-31 Le Havre 1-1 Reims 27/2 1,73 1.33/30 1.50/8 1.36/14 1.31/16   33/8 1,93 1.63/30 1.50/8 2.00/15 1.27/15
2017-04-07 Le Havre 2-0 Laval 28/2 1,74 1.32/31 1.50/8 1.33/15 1.31/16   25/-11 1,97 0.87/31 0.63/8 0.93/15 0.81/16
2017-04-14 Amiens 2-0 Le Havre 42/9 2,34 1.50/32 1.25/8 1.56/16 1.44/16   30/4 1,75 1.38/32 1.75/8 1.44/16 1.31/16
2017-04-24 Le Havre 1-0 Lens 30/2 1,76 1.33/33 1.38/8 1.44/16 1.24/17   49/12 2,61 1.67/33 1.88/8 1.63/16 1.71/17
2017-04-28 Strasbourg 2-0 Le Havre 56/13 2,91 1.74/34 2.00/8 2.24/17 1.24/17   31/3 1,74 1.38/34 1.75/8 1.53/17 1.24/17
2017-05-05 Le Havre 0-0 Niort 31/1 1,74 1.34/35 1.38/8 1.53/17 1.17/18   42/-10 2,69 1.34/35 1.38/8 1.61/18 1.06/17
2017-05-12 Tours 0-4 Le Havre 53/0 2,94 1.19/36 2.50/8 1.28/18 1.11/18   31/1 1,69 1.33/36 1.13/8 1.50/18 1.17/18
2017-05-19 Le Havre 4-1 Orleans 35/5 1,76 1.38/37 1.50/8 1.50/18 1.26/19   40/-10 2,43 1.14/37 1.38/8 1.63/19 0.61/18