SELECT * FROM 1_Kampe WHERE LigaID = '90' 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
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 Brest 2-1 Orleans 0/0 0,00 1.00/1 1.00/1 0.00/0 1.00/1   0/-1 1,00 0.00/1 0.00/1 0.00/1 0.00/0
2016-08-12 Orleans 2-0 AC Ajaccio 1/-2 2,00 0.00/2 0.00/2 0.00/1 0.00/1   2/1 1,50 2.00/2 2.00/2 3.00/1 1.00/1
2016-08-19 Sochaux 0-0 Orleans 5/3 2,33 2.33/3 2.33/3 1.00/1 3.00/2   3/0 2,00 1.00/3 1.00/3 1.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 Laval 3-1 Orleans 1/-4 1,20 0.40/5 0.40/5 0.50/2 0.33/3   3/0 1,20 1.00/5 1.00/5 1.33/3 0.50/2
2016-09-16 Orleans 3-1 Strasbourg 4/-2 1,67 0.83/6 0.83/6 1.33/3 0.33/3   8/5 1,83 2.00/6 2.00/6 2.33/3 1.67/3
2016-09-20 Lens 4-2 Orleans 7/1 1,86 1.14/7 1.14/7 0.67/3 1.50/4   7/0 2,00 1.14/7 1.14/7 1.75/4 0.33/3
2016-09-23 Orleans 1-2 Amiens 9/-2 2,50 1.00/8 1.00/8 1.75/4 0.25/4   10/5 2,14 2.00/7 2.00/7 2.00/4 2.00/3
2016-09-30 Niort 1-0 Orleans 7/-6 2,22 0.89/9 0.88/8 0.50/4 1.20/5   10/-3 2,56 0.89/9 1.00/8 1.40/5 0.25/4
2016-10-14 Orleans 0-0 Tours 10/-4 2,40 0.80/10 1.00/8 1.40/5 0.20/5   11/-10 3,20 0.60/10 0.50/8 0.33/6 1.00/4
2016-10-21 GFC Ajaccio 2-0 Orleans 9/0 1,64 1.27/11 1.13/8 0.80/5 1.67/6   10/-4 2,18 0.82/11 0.75/8 1.33/6 0.20/5
2016-10-28 Orleans 1-1 Troyes 10/-6 2,17 0.75/12 0.63/8 1.33/6 0.17/6   16/3 2,42 1.75/12 1.88/8 2.00/7 1.40/5
2016-11-04 Bourg en Bresse 0-0 Orleans 13/-4 2,31 1.08/13 1.50/8 1.29/7 0.83/6   11/-6 2,15 0.77/13 0.63/8 1.29/7 0.17/6
2016-11-18 Orleans 2-1 Nimes 11/-6 2,00 0.79/14 0.75/8 1.29/7 0.29/7   20/3 2,64 1.36/14 1.75/8 0.71/7 2.00/7
2016-11-25 Orleans 0-2 Valenciennes 13/-5 2,07 0.93/15 0.75/8 1.50/8 0.29/7   23/0 3,07 1.20/15 1.00/8 1.50/8 0.86/7
2016-11-29 Red Star 1-0 Orleans 13/-8 2,13 0.94/16 0.63/8 1.13/8 0.75/8   13/-7 2,06 0.88/16 0.75/8 1.33/9 0.29/7
2016-12-12 Orleans 2-2 Reims 13/-8 2,00 0.82/17 0.75/8 1.33/9 0.25/8   19/4 2,00 1.71/17 1.63/8 2.63/8 0.89/9
2016-12-16 Clermont 3-0 Orleans 17/-1 1,94 1.22/18 1.13/8 1.44/9 1.00/9   15/-8 2,11 0.83/18 0.88/8 1.30/10 0.25/8
2017-01-13 Orleans 0-1 Brest 15/-11 2,16 0.79/19 0.75/8 1.30/10 0.22/9   26/5 2,47 1.84/19 1.63/8 1.90/10 1.78/9
2017-01-20 AC Ajaccio 1-0 Orleans 22/-4 2,40 1.20/20 1.13/8 1.70/10 0.70/10   15/-12 2,10 0.75/20 0.75/8 1.18/11 0.22/9
2017-01-27 Orleans 1-0 Sochaux 15/-13 2,05 0.71/21 0.63/8 1.18/11 0.20/10   24/5 2,05 1.57/21 1.75/8 1.64/11 1.50/10
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 Orleans 2-1 Laval 18/-10 2,00 0.91/23 0.88/8 1.33/12 0.45/11   18/-5 1,78 0.96/23 1.00/8 1.00/11 0.92/12
2017-02-13 Strasbourg 3-2 Orleans 32/3 2,65 1.57/23 2.00/8 2.09/11 1.08/12   20/-9 2,04 1.00/24 1.25/8 1.46/13 0.45/11
2017-02-20 Orleans 2-1 Lens 22/-10 2,16 0.96/25 1.25/8 1.46/13 0.42/12   33/7 2,36 1.60/25 1.38/8 1.67/12 1.54/13
2017-02-24 Amiens 0-2 Orleans 39/15 2,42 1.62/26 1.75/8 1.69/13 1.54/13   24/-9 2,19 1.04/26 1.50/8 1.57/14 0.42/12
2017-03-04 Orleans 1-1 Niort 26/-7 2,19 1.11/27 1.88/8 1.57/14 0.62/13   34/-5 2,70 1.33/27 1.38/8 1.64/14 1.00/13
2017-03-10 Tours 3-1 Orleans 32/-15 2,82 0.82/28 0.63/8 0.79/14 0.86/14   27/-7 2,18 1.11/28 2.00/8 1.53/15 0.62/13
2017-03-17 Orleans 1-1 GFC Ajaccio 28/-9 2,24 1.07/29 2.00/8 1.53/15 0.57/14   32/1 2,17 1.38/29 1.25/8 1.67/15 1.07/14
2017-03-31 Troyes 4-2 Orleans 42/10 2,47 1.57/30 1.50/8 2.07/15 1.07/15   29/-9 2,23 1.07/30 1.75/8 1.50/16 0.57/14
2017-04-07 Orleans 1-0 Bourg en Bresse 31/-11 2,35 1.03/31 1.38/8 1.50/16 0.53/15   43/-1 2,81 1.32/31 1.25/8 1.50/16 1.13/15
2017-04-14 Nimes 2-0 Orleans 47/13 2,53 1.59/32 1.88/8 1.31/16 1.88/16   32/-10 2,31 1.09/32 1.38/8 1.59/17 0.53/15
2017-04-21 Valenciennes 4-0 Orleans 40/-2 2,48 1.21/33 1.25/8 1.50/16 0.94/17   32/-12 2,30 1.06/33 1.38/8 1.59/17 0.50/16
2017-04-28 Orleans 4-0 Red Star 32/-16 2,35 1.03/34 1.00/8 1.59/17 0.47/17   35/-15 2,50 1.00/34 0.75/8 1.11/18 0.88/16
2017-05-05 Reims 0-2 Orleans 41/8 2,11 1.57/35 1.50/8 1.88/17 1.28/18   36/-12 2,40 1.09/35 1.00/8 1.67/18 0.47/17
2017-05-12 Orleans 2-2 Clermont 38/-10 2,39 1.14/36 1.25/8 1.67/18 0.61/18   43/-3 2,47 1.17/36 1.00/8 1.06/18 1.28/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