SELECT * FROM 1_Kampe WHERE LigaID = '90' AND (Home='Tours' OR Away='Tours') 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 Tours 0-0 AC Ajaccio 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 Lens 2-2 Tours 0/0 0,00 1.00/1 1.00/1 0.00/0 1.00/1   0/0 0,00 1.00/1 1.00/1 1.00/1 0.00/0
2016-08-12 Tours 1-3 Strasbourg 2/0 2,00 1.00/2 1.00/2 1.00/1 1.00/1   1/1 0,50 2.00/2 2.00/2 3.00/1 1.00/1
2016-08-19 Niort 1-4 Tours 1/-2 1,33 0.67/3 0.67/3 1.00/1 0.50/2   3/-2 2,67 0.67/3 0.67/3 0.50/2 1.00/1
2016-08-26 Tours 1-1 Reims 7/1 3,25 1.25/4 1.25/4 0.50/2 2.00/2   4/2 1,50 2.00/4 2.00/4 3.00/2 1.00/2
2016-09-09 Amiens 3-1 Tours 7/3 2,20 2.00/5 2.00/5 2.00/2 2.00/3   8/1 3,00 1.20/5 1.20/5 0.67/3 2.00/2
2016-09-16 Tours 1-3 Nimes 9/-1 3,17 1.00/6 1.00/6 0.67/3 1.33/3   6/-2 2,33 0.83/6 0.83/6 0.33/3 1.33/3
2016-09-20 Tours 0-2 Bourg en Bresse 10/-3 3,29 0.86/7 0.86/7 0.50/4 1.33/3   8/-4 2,86 0.86/7 0.86/7 1.25/4 0.33/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 Tours 0-3 GFC Ajaccio 11/-7 3,22 0.67/9 0.63/8 0.40/5 1.00/4   6/-2 1,56 1.22/9 1.25/8 0.80/5 1.75/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 Tours 4-1 Valenciennes 11/-10 2,91 0.64/11 0.63/8 0.33/6 1.00/5   17/6 2,55 1.55/11 1.50/8 1.83/6 1.20/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 Tours 0-1 Brest 16/-9 3,15 0.77/13 0.50/8 0.71/7 0.83/6   19/6 2,46 1.92/13 1.75/8 2.14/7 1.67/6
2016-11-18 Sochaux 2-1 Tours 13/1 1,79 1.36/14 1.13/8 1.43/7 1.29/7   16/-10 3,00 0.71/14 0.50/8 0.63/8 0.83/6
2016-11-25 Tours 2-1 Auxerre 17/-11 3,00 0.67/15 0.50/8 0.63/8 0.71/7   9/-10 1,87 0.73/15 0.63/8 0.71/7 0.75/8
2016-11-29 Clermont 0-0 Tours 16/-1 2,06 1.25/16 1.13/8 1.50/8 1.00/8   19/-10 3,00 0.81/16 0.88/8 0.89/9 0.71/7
2016-12-09 Tours 1-1 Laval 19/-10 2,82 0.82/17 1.00/8 0.89/9 0.75/8   11/-6 1,65 0.82/17 0.88/8 0.75/8 0.89/9
2016-12-16 Le Havre 0-2 Tours 19/4 1,89 1.50/18 1.38/8 1.50/8 1.50/10   20/-10 2,78 0.83/18 1.13/8 0.90/10 0.75/8
2017-01-13 Tours 2-3 Lens 22/-8 2,74 0.95/19 1.38/8 0.90/10 1.00/9   25/7 2,26 1.68/19 1.88/8 1.78/9 1.60/10
2017-01-27 Tours 0-0 Niort 24/-9 2,85 0.90/20 1.00/8 0.82/11 1.00/9   26/-2 2,57 1.38/21 1.50/8 1.55/11 1.20/10
2017-02-03 Reims 1-1 Tours 24/6 1,91 1.68/22 1.38/8 2.50/10 1.00/12   24/-9 2,71 0.90/21 1.13/8 0.83/12 1.00/9
2017-02-07 Tours 0-3 Amiens 25/-9 2,68 0.91/22 1.25/8 0.83/12 1.00/10   31/8 2,35 1.52/23 1.38/8 1.58/12 1.45/11
2017-02-10 Nimes 1-1 Tours 37/9 2,71 1.50/24 1.75/8 1.08/12 1.92/12   25/-12 2,70 0.87/23 1.25/8 0.77/13 1.00/10
2017-02-17 Bourg en Bresse 3-2 Tours 30/-1 2,44 1.28/25 1.50/8 1.62/13 0.92/12   26/-12 2,67 0.88/24 1.00/8 0.77/13 1.00/11
2017-02-21 Strasbourg 4-2 Tours 36/4 2,72 1.60/25 1.75/8 2.17/12 1.08/13   28/-13 2,76 0.84/25 0.88/8 0.77/13 0.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-03 GFC Ajaccio 2-2 Tours 27/-1 2,04 1.33/27 1.50/8 1.62/13 1.07/14   30/-15 2,78 0.81/27 0.50/8 0.79/14 0.85/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 Valenciennes 0-4 Tours 36/-1 2,52 1.17/29 0.75/8 1.50/14 0.87/15   35/-13 2,86 0.90/29 0.88/8 0.93/15 0.86/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-07 Brest 1-1 Tours 42/9 2,42 1.77/31 1.38/8 1.87/15 1.69/16   42/-7 2,94 1.03/31 1.50/8 1.06/16 1.00/15
2017-04-14 Tours 3-1 Sochaux 43/-7 2,91 1.03/32 1.50/8 1.06/16 1.00/16   31/-1 1,97 1.31/32 1.13/8 1.44/16 1.19/16
2017-04-21 Auxerre 1-1 Tours 23/-13 1,79 1.06/33 1.25/8 1.13/16 1.00/17   46/-5 2,94 1.09/33 1.88/8 1.18/17 1.00/16
2017-04-28 Tours 3-0 Clermont 47/-5 2,91 1.09/34 2.00/8 1.18/17 1.00/17   41/1 2,38 1.24/34 1.50/8 1.12/17 1.35/17
2017-05-05 Laval 1-3 Tours 31/-13 2,14 0.86/35 0.75/8 1.00/17 0.72/18   50/-2 2,91 1.14/35 2.25/8 1.28/18 1.00/17
2017-05-12 Tours 0-4 Le Havre 53/0 2,94 1.19/36 2.50/8 1.28/18 1.11/18   31/1 1,69 1.33/36 1.13/8 1.50/18 1.17/18
2017-05-19 AC Ajaccio 3-2 Tours 44/-12 2,70 1.22/37 1.00/8 1.89/18 0.58/19   53/-4 2,97 1.16/37 2.13/8 1.21/19 1.11/18