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
2016-07-29 Troyes 1-3 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
2016-08-05 AC Ajaccio 2-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
2016-08-12 Troyes 1-0 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
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-26 Troyes 1-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
2016-09-12 Strasbourg 2-0 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
2016-09-16 Troyes 1-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
2016-09-20 Nimes 2-2 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
2016-09-23 Troyes 3-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
2016-09-30 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
2016-10-14 Troyes 1-0 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
2016-10-21 Troyes 1-0 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
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 Troyes 2-0 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
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 Troyes 1-0 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
2016-11-29 Brest 2-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
2016-12-09 Troyes 1-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
2016-12-19 Reims 2-0 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
2017-01-13 Troyes 1-2 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
2017-01-20 Laval 1-0 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
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 Lens 0-0 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
2017-02-07 Troyes 4-0 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
2017-02-10 Niort 3-2 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
2017-02-17 Troyes 0-0 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
2017-02-24 Tours 0-0 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
2017-03-04 Troyes 4-0 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
2017-03-10 GFC Ajaccio 3-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
2017-03-17 Bourg en Bresse 2-4 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
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 Valenciennes 2-0 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
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 Clermont 1-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
2017-04-29 Troyes 1-0 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
2017-05-05 Auxerre 2-3 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
2017-05-12 Troyes 2-0 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
2017-05-19 Sochaux 2-3 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