SELECT * FROM 1_Kampe WHERE LigaID = '90' AND (Home='Red Star' OR Away='Red Star') 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 Clermont 0-0 Red Star 0/-2 2,00 0.00/1 0.00/1 0.00/0 0.00/1   0/0 0,00 1.00/1 1.00/1 1.00/1 0.00/0
2016-08-12 Red Star 0-3 Brest 0/0 0,00 1.00/2 1.00/2 1.00/1 1.00/1   2/1 1,50 2.00/2 2.00/2 3.00/1 1.00/1
2016-08-22 Reims 2-1 Red Star 2/1 1,00 1.67/3 1.67/3 3.00/1 1.00/2   0/-3 1,00 0.67/3 0.67/3 0.50/2 1.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-09 AC Ajaccio 1-2 Red Star 6/0 2,40 1.40/5 1.40/5 3.00/2 0.33/3   1/-4 1,20 0.60/5 0.60/5 0.67/3 0.50/2
2016-09-16 Red Star 1-0 Laval 3/-3 1,50 1.00/6 1.00/6 0.67/3 1.33/3   4/-2 1,67 0.83/6 0.83/6 1.33/3 0.33/3
2016-09-19 Strasbourg 0-0 Red Star 9/3 2,14 1.71/7 1.71/7 2.33/3 1.25/4   4/-2 1,43 1.29/7 1.29/7 1.25/4 1.33/3
2016-09-23 Red Star 0-1 Niort 4/-2 1,25 1.25/8 1.25/8 1.25/4 1.25/4   6/-7 2,38 0.63/8 0.63/8 0.50/4 0.75/4
2016-09-30 Lens 2-0 Red Star 13/4 2,44 1.56/9 1.63/8 1.25/4 1.80/5   4/-3 1,22 1.11/9 1.13/8 1.00/5 1.25/4
2016-10-14 Red Star 3-3 Nimes 4/-5 1,30 1.00/10 1.00/8 1.00/5 1.00/5   13/2 2,40 1.30/10 1.50/8 0.60/5 2.00/5
2016-10-24 Amiens 0-0 Red Star 17/7 2,45 1.91/11 2.13/8 1.60/5 2.17/6   7/-5 1,73 1.00/11 1.13/8 1.00/6 1.00/5
2016-10-28 Red Star 3-1 Tours 7/-5 1,58 1.00/12 1.25/8 1.00/6 1.00/6   15/-7 3,08 0.83/12 0.63/8 0.71/7 1.00/5
2016-11-04 GFC Ajaccio 2-1 Red Star 11/1 1,62 1.31/13 1.00/8 1.17/6 1.43/7   10/-3 1,77 1.15/13 1.50/8 1.29/7 1.00/6
2016-11-18 Red Star 1-2 Troyes 11/-4 1,86 1.07/14 1.13/8 1.29/7 0.86/7   19/5 2,36 1.79/14 2.25/8 2.13/8 1.33/6
2016-11-25 Bourg en Bresse 4-1 Red Star 16/-4 2,40 1.07/15 1.25/8 1.25/8 0.86/7   12/-5 1,93 1.00/15 0.75/8 1.13/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-09 Red Star 2-2 Valenciennes 14/-7 2,06 1.06/17 1.00/8 1.33/9 0.75/8   25/2 2,82 1.29/17 1.38/8 1.44/9 1.13/8
2016-12-16 Sochaux 2-0 Red Star 18/4 1,78 1.61/18 1.75/8 1.56/9 1.67/9   16/-7 2,17 1.06/18 1.13/8 1.30/10 0.75/8
2017-01-13 Red Star 1-3 Clermont 16/-9 2,16 1.00/19 1.00/8 1.30/10 0.67/9   20/2 2,00 1.32/19 1.50/8 1.60/10 1.00/9
2017-01-23 Brest 0-1 Red Star 27/6 2,40 1.90/20 1.63/8 1.90/10 1.90/10   17/-11 2,25 0.95/20 0.88/8 1.18/11 0.67/9
2017-01-30 Red Star 0-1 Reims 18/-10 2,19 1.05/21 0.88/8 1.18/11 0.90/10   23/5 1,95 1.62/21 1.38/8 2.50/10 0.82/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 Red Star 2-0 AC Ajaccio 19/-11 2,13 1.00/23 1.00/8 1.08/12 0.91/11   27/-3 2,48 1.30/23 1.38/8 1.92/12 0.64/11
2017-02-10 Laval 1-1 Red Star 19/-6 1,83 0.92/24 1.00/8 1.00/11 0.85/13   21/-9 2,13 1.08/24 1.38/8 1.23/13 0.91/11
2017-02-17 Red Star 1-1 Strasbourg 22/-9 2,12 1.08/25 1.13/8 1.23/13 0.92/12   35/4 2,75 1.63/24 2.00/8 2.17/12 1.08/12
2017-02-24 Niort 2-3 Red Star 32/-4 2,62 1.38/26 1.38/8 1.77/13 1.00/13   23/-9 2,12 1.08/26 1.13/8 1.21/14 0.92/12
2017-03-03 Red Star 2-3 Lens 26/-8 2,22 1.15/27 1.50/8 1.21/14 1.08/13   36/8 2,37 1.59/27 1.38/8 1.77/13 1.43/14
2017-03-10 Nimes 2-0 Red Star 40/10 2,50 1.50/28 2.00/8 1.07/14 1.93/14   28/-9 2,32 1.11/28 1.50/8 1.13/15 1.08/13
2017-03-17 Red Star 0-1 Amiens 28/-11 2,31 1.07/29 1.13/8 1.13/15 1.00/14   41/10 2,48 1.55/29 1.63/8 1.67/15 1.43/14
2017-03-31 Tours 3-1 Red Star 39/-9 2,90 0.97/30 1.13/8 0.93/15 1.00/15   28/-12 2,27 1.03/30 1.13/8 1.06/16 1.00/14
2017-04-08 Red Star 0-3 GFC Ajaccio 29/-14 2,32 1.00/31 1.00/8 1.06/16 0.93/15   35/0 2,26 1.32/31 1.25/8 1.56/16 1.07/15
2017-04-14 Troyes 3-2 Red Star 46/10 2,56 1.56/32 1.38/8 2.13/16 1.00/16   29/-17 2,34 0.97/32 0.63/8 1.00/17 0.93/15
2017-04-21 Red Star 4-1 Bourg en Bresse 31/-18 2,42 0.94/33 0.50/8 1.00/17 0.88/16   43/-4 2,73 1.24/33 1.13/8 1.41/17 1.06/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 Valenciennes 0-0 Red Star 44/1 2,49 1.23/35 1.50/8 1.59/17 0.89/18   35/-19 2,54 0.97/35 0.38/8 1.11/18 0.82/17
2017-05-12 Red Star 1-1 Sochaux 35/-19 2,47 0.97/36 0.50/8 1.11/18 0.83/18   35/-4 2,06 1.25/36 0.88/8 1.28/18 1.22/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