SELECT * FROM 1_Kampe WHERE LigaID = '90' AND (Home='Troyes' OR Away='Troyes') 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
2018-10-21 Sochaux 0-1 Troyes 36/-4 2,05 1.24/37 1.00/8 1.28/18 1.21/19   56/15 2,62 1.70/37 2.38/8 2.26/19 1.11/18
2018-10-21 Troyes 0-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
2018-10-21 Brest 0-1 Troyes 22/3 2,56 1.75/16 1.63/8 1.88/8 1.63/8   22/7 2,31 1.94/16 2.75/8 2.22/9 1.57/7
2018-10-21 Troyes 0-1 Clermont 21/6 2,40 1.87/15 2.50/8 2.13/8 1.57/7   16/0 2,13 1.33/15 1.13/8 1.50/8 1.14/7
2018-10-21 Red Star 0-1 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
2018-10-21 Troyes 0-1 Valenciennes 17/3 2,38 1.69/13 1.88/8 2.00/7 1.33/6   20/2 2,92 1.31/13 1.13/8 1.57/7 1.00/6
2018-10-21 Orleans 0-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
2018-10-21 Troyes 0-1 Bourg en Bresse 15/2 2,55 1.64/11 1.88/8 1.83/6 1.40/5   12/-4 2,55 1.00/11 1.25/8 1.00/6 1.00/5
2018-10-21 Troyes 0-1 GFC Ajaccio 14/1 2,70 1.50/10 1.88/8 1.60/5 1.40/5   9/1 1,70 1.40/10 1.25/8 0.80/5 2.00/5
2018-10-21 Amiens 0-1 Troyes 13/6 2,22 2.00/9 2.13/8 2.00/4 2.00/5   13/0 2,89 1.33/9 1.50/8 1.60/5 1.00/4
2018-10-21 Troyes 0-1 Tours 10/-2 2,75 1.13/8 1.13/8 1.25/4 1.00/4   10/-5 3,13 0.75/8 0.75/8 0.40/5 1.33/3
2018-10-21 Nimes 0-1 Troyes 9/0 2,57 1.14/7 1.14/7 0.33/3 1.75/4   8/-2 2,57 1.14/7 1.14/7 1.25/4 1.00/3
2018-10-21 Troyes 0-1 Niort 7/-2 2,67 1.17/6 1.17/6 1.33/3 1.00/3   5/-7 2,83 0.50/6 0.50/6 0.33/3 0.67/3
2018-10-21 Strasbourg 0-1 Troyes 6/3 1,80 1.80/5 1.80/5 2.00/2 1.67/3   7/0 2,80 1.40/5 1.40/5 1.33/3 1.50/2
2018-10-21 Troyes 0-1 Lens 6/0 3,00 1.50/4 1.50/4 1.50/2 1.50/2   4/1 1,75 1.25/4 1.25/4 0.50/2 2.00/2
2018-10-21 Le Havre 0-1 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
2018-10-21 Troyes 0-1 Laval 2/-3 3,50 0.00/2 0.00/2 0.00/1 0.00/1   1/0 1,00 1.00/2 1.00/2 1.00/1 1.00/1
2018-10-21 AC Ajaccio 0-1 Troyes 0/0 0,00 1.00/1 1.00/1 0.00/0 1.00/1   1/-2 4,00 0.00/1 0.00/1 0.00/1 0.00/0
2018-10-21 Reims 0-1 Troyes 21/4 2,11 1.67/18 1.38/8 2.63/8 0.90/10   24/6 2,33 1.78/18 2.13/8 2.10/10 1.38/8
2018-10-21 Troyes 0-1 AC Ajaccio 24/4 2,32 1.68/19 1.75/8 2.10/10 1.22/9   20/-5 2,37 1.11/19 0.75/8 1.70/10 0.44/9
2018-10-21 Troyes 0-1 Reims 54/13 2,64 1.67/36 2.00/8 2.22/18 1.11/18   41/6 2,11 1.53/36 1.13/8 1.78/18 1.28/18
2018-10-21 Auxerre 0-1 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
2018-10-21 Troyes 0-1 Brest 50/11 2,62 1.59/34 1.75/8 2.18/17 1.00/17   48/11 2,50 1.74/34 1.38/8 1.71/17 1.76/17
2018-10-21 Clermont 0-1 Troyes 40/1 2,39 1.24/33 1.38/8 1.13/16 1.35/17   49/11 2,64 1.61/33 1.75/8 2.18/17 1.00/16
2018-10-21 Troyes 0-1 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
2018-10-21 Valenciennes 0-1 Troyes 36/-6 2,52 1.10/31 0.63/8 1.40/15 0.81/16   46/12 2,58 1.61/31 1.75/8 2.13/16 1.07/15
2018-10-21 Troyes 0-1 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
2018-10-21 Bourg en Bresse 0-1 Troyes 38/0 2,62 1.31/29 1.25/8 1.60/15 1.00/14   38/8 2,34 1.52/29 1.50/8 2.07/15 0.93/14
2018-10-21 GFC Ajaccio 0-1 Troyes 29/-1 2,11 1.32/28 1.25/8 1.57/14 1.07/14   37/10 2,29 1.57/28 1.50/8 2.07/15 1.00/13
2018-10-21 Troyes 0-1 Amiens 33/6 2,22 1.52/27 1.13/8 2.00/14 1.00/13   39/13 2,41 1.56/27 1.63/8 1.57/14 1.54/13
2018-10-21 Tours 0-1 Troyes 30/-15 2,88 0.81/26 0.75/8 0.77/13 0.85/13   33/6 2,31 1.54/26 1.00/8 2.00/14 1.00/12
2018-10-21 Troyes 0-1 Nimes 33/6 2,40 1.56/25 1.00/8 2.08/13 1.00/12   38/9 2,68 1.48/25 1.88/8 1.08/13 1.92/12
2018-10-21 Niort 0-1 Troyes 29/-4 2,58 1.38/24 1.13/8 1.67/12 1.08/12   31/7 2,29 1.63/24 1.00/8 2.08/13 1.09/11
2018-10-21 Troyes 0-1 Strasbourg 27/3 2,22 1.57/23 1.00/8 2.00/12 1.09/11   32/7 2,59 1.64/22 2.00/8 2.09/11 1.18/11
2018-10-21 Lens 0-1 Troyes 30/5 2,50 1.59/22 1.63/8 1.60/10 1.58/12   27/3 2,32 1.59/22 1.25/8 2.00/12 1.10/10
2018-10-21 Troyes 0-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
2018-10-21 Laval 0-1 Troyes 16/-6 1,90 0.85/20 1.13/8 0.78/9 0.91/11   25/3 2,35 1.60/20 1.38/8 1.91/11 1.22/9
2018-10-21 Troyes 0-1 Sochaux 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