SELECT * FROM 1_Kampe WHERE LigaID = '89' AND (Home='Orleans' OR Away='Orleans') 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 Orleans 3-1 Nancy 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-05 Reims 2-0 Orleans 1/1 1,00 3.00/1 3.00/1 0.00/0 3.00/1   3/2 4,00 3.00/1 3.00/1 3.00/1 0.00/0
2017-08-11 Orleans 0-0 AC Ajaccio 3/0 3,00 1.50/2 1.50/2 3.00/1 0.00/1   2/1 1,50 2.00/2 2.00/2 3.00/1 1.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-28 Orleans 2-0 Lens 6/2 2,50 1.75/4 1.75/4 2.00/2 1.50/2   5/-5 3,75 0.00/4 0.00/4 0.00/2 0.00/2
2017-09-08 Le Havre 1-1 Orleans 11/9 2,60 2.40/5 2.40/5 3.00/2 2.00/3   8/4 2,40 2.00/5 2.00/5 2.33/3 1.50/2
2017-09-15 Orleans 3-1 Niort 9/4 2,33 1.83/6 1.83/6 2.33/3 1.33/3   5/-2 2,00 1.33/6 1.33/6 1.75/4 0.50/2
2017-09-19 Paris FC 1-0 Orleans 8/1 2,14 1.86/7 1.86/7 1.75/4 2.00/3   12/6 2,57 2.00/7 2.00/7 2.50/4 1.33/3
2017-09-22 Orleans 1-1 Tours 12/5 2,38 1.75/8 1.75/8 2.50/4 1.00/4   3/-15 2,63 0.13/8 0.13/8 0.00/4 0.25/4
2017-09-29 Orleans 3-4 Valenciennes 13/5 2,33 1.67/9 1.50/8 2.20/5 1.00/4   7/-4 2,00 1.22/9 1.25/8 1.60/5 0.75/4
2017-10-13 Nimes 4-1 Orleans 16/5 2,70 1.60/10 1.63/8 1.40/5 1.80/5   16/4 2,80 1.50/10 1.50/8 1.83/6 1.00/4
2017-10-20 Orleans 1-2 Lorient 17/1 3,00 1.36/11 1.38/8 1.83/6 0.80/5   15/7 2,09 1.73/11 1.75/8 2.00/6 1.40/5
2017-10-27 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
2017-11-03 Orleans 3-3 Sochaux 19/1 2,85 1.38/13 1.00/8 1.57/7 1.17/6   17/-7 3,15 1.54/13 1.50/8 1.71/7 1.33/6
2017-11-17 Quevilly Rouen 1-0 Orleans 11/-16 2,71 0.36/14 0.38/8 0.57/7 0.14/7   22/1 3,07 1.36/14 1.00/8 1.50/8 1.17/6
2017-11-24 Orleans 1-2 Clermont 22/0 2,93 1.27/15 0.63/8 1.50/8 1.00/7   20/10 2,00 1.73/15 1.88/8 2.29/7 1.25/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-12 Orleans 2-0 GFC Ajaccio 23/-5 3,00 1.12/17 0.50/8 1.33/9 0.88/8   12/-8 1,88 1.35/17 1.38/8 1.67/9 1.00/8
2017-12-15 Chateauroux 0-0 Orleans 24/-2 2,78 1.50/18 1.88/8 1.75/8 1.30/10   25/-3 2,94 1.22/18 0.88/8 1.50/10 0.88/8
2018-01-12 Orleans 0-2 Reims 25/-3 2,79 1.21/19 1.00/8 1.50/10 0.89/9   36/24 2,53 2.32/19 2.50/8 2.44/9 2.20/10
2018-01-16 AC Ajaccio 1-1 Orleans 33/13 2,65 1.85/20 1.38/8 2.10/10 1.60/10   25/-5 2,75 1.15/20 1.00/8 1.36/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 Lens 0-1 Orleans 29/5 2,52 1.19/21 1.88/8 1.67/9 0.83/12   28/-6 2,82 1.09/22 0.63/8 1.25/12 0.90/10
2018-02-02 Orleans 2-1 Le Havre 29/-5 2,74 1.17/23 1.00/8 1.25/12 1.09/11   32/13 2,22 1.74/23 1.88/8 2.27/11 1.25/12
2018-02-09 Niort 2-3 Orleans 27/-7 2,54 1.21/24 0.88/8 1.50/12 0.92/12   31/-4 2,75 1.25/24 1.38/8 1.38/13 1.09/11
2018-02-16 Orleans 1-1 Paris FC 34/-3 2,84 1.32/25 1.75/8 1.38/13 1.25/12   30/9 2,04 1.80/25 1.88/8 2.08/13 1.50/12
2018-02-23 Tours 1-1 Orleans 16/-33 2,50 0.38/26 0.63/8 0.54/13 0.23/13   35/-3 2,81 1.31/26 1.50/8 1.36/14 1.25/12
2018-03-02 Valenciennes 0-1 Orleans 33/-9 2,78 1.22/27 1.00/8 1.43/14 1.00/13   36/-3 2,78 1.30/27 1.50/8 1.36/14 1.23/13
2018-03-09 Orleans 1-4 Nimes 37/-2 2,71 1.36/28 1.88/8 1.36/14 1.36/14   55/27 2,96 1.86/28 1.50/8 2.00/15 1.69/13
2018-03-16 Lorient 3-1 Orleans 47/13 2,79 1.72/29 1.75/8 1.93/15 1.50/14   38/-5 2,79 1.31/29 1.75/8 1.27/15 1.36/14
2018-03-30 Orleans 1-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-04-06 Sochaux 3-2 Orleans 41/-9 2,94 1.45/31 1.00/8 1.87/15 1.06/16   40/-7 2,81 1.26/31 1.50/8 1.25/16 1.27/15
2018-04-13 Orleans 2-1 Quevilly Rouen 42/-8 2,88 1.22/32 1.13/8 1.25/16 1.19/16   37/-17 2,84 0.88/32 1.13/8 0.81/16 0.94/16
2018-04-20 Clermont 4-2 Orleans 44/15 2,21 1.67/33 1.75/8 1.94/16 1.41/17   44/-7 2,88 1.27/33 1.13/8 1.35/17 1.19/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 GFC Ajaccio 1-0 Orleans 31/-21 2,37 1.09/35 1.00/8 1.53/17 0.67/18   51/-5 3,06 1.29/35 1.25/8 1.44/18 1.12/17
2018-05-04 Orleans 1-1 Chateauroux 51/-6 3,00 1.25/36 0.88/8 1.44/18 1.06/18   47/0 2,61 1.61/36 1.25/8 1.89/18 1.33/18
2018-05-11 Nancy 3-0 Orleans 36/-18 2,43 0.95/37 0.88/8 1.33/18 0.58/19   52/-6 2,97 1.24/37 1.00/8 1.42/19 1.06/18