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
2018-10-21 AC Ajaccio 0-1 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
2018-10-21 Tours 0-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
2018-10-21 Clermont 0-1 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
2018-10-21 Tours 0-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
2018-10-21 Sochaux 0-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
2018-10-21 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
2018-10-21 Red Star 0-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
2018-10-21 Tours 0-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
2018-10-21 Orleans 0-1 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
2018-10-21 Tours 0-1 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
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 Tours 0-1 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
2018-10-21 Tours 0-1 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
2018-10-21 Amiens 0-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
2018-10-21 Tours 0-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
2018-10-21 Niort 0-1 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
2018-10-21 Tours 0-1 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
2018-10-21 Lens 0-1 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
2018-10-21 Le Havre 0-1 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
2018-10-21 Tours 0-1 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
2018-10-21 Tours 0-1 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
2018-10-21 Laval 0-1 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
2018-10-21 Tours 0-1 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
2018-10-21 Auxerre 0-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
2018-10-21 Tours 0-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
2018-10-21 Brest 0-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
2018-10-21 Tours 0-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
2018-10-21 Valenciennes 0-1 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
2018-10-21 Tours 0-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
2018-10-21 GFC Ajaccio 0-1 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
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 Strasbourg 0-1 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
2018-10-21 Bourg en Bresse 0-1 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
2018-10-21 Nimes 0-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
2018-10-21 Tours 0-1 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
2018-10-21 Reims 0-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
2018-10-21 Tours 0-1 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
2018-10-21 Tours 0-1 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