SELECT * FROM 1_Kampe WHERE LigaID = '84' AND (Home='Evian TG' OR Away='Evian TG') 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 Bordeaux 0-1 Evian TG 42/8 1,90 1.53/40 1.63/8 1.68/19 1.38/21   0/0 0,00 0.00/0 0.00/0 0.00/0 0.00/0
2018-10-21 Nice 0-1 Evian TG 57/11 2,71 1.68/38 2.00/8 2.00/19 1.37/19   1/1 1,00 3.00/1 1.13/8 0.00/0 3.00/1
2018-10-21 Evian TG 0-1 Troyes 2/2 1,00 3.00/2 1.13/8 0.00/0 3.00/2   44/-19 2,61 0.98/41 1.88/8 1.24/21 0.70/20
2018-10-21 Paris SG 0-1 Evian TG 4/1 1,00 1.71/7 1.50/8 0.00/3 3.00/4   2/1 1,00 2.00/3 1.13/8 0.00/1 3.00/2
2018-10-21 Evian TG 0-1 Nancy 3/2 1,00 2.25/4 1.13/8 0.00/1 3.00/3   38/-22 2,45 0.95/40 1.13/8 0.95/21 0.95/19
2018-10-21 Rennes 0-1 Evian TG 49/-11 2,73 1.23/40 0.88/8 1.15/20 1.30/20   3/1 1,00 1.80/5 1.13/8 0.00/2 3.00/3
2018-10-21 Evian TG 0-1 St Etienne 4/2 1,00 2.00/6 1.13/8 0.00/2 3.00/4   60/26 2,35 1.58/40 1.38/8 1.76/21 1.37/19
2018-10-21 Reims 0-1 Evian TG 35/-8 1,90 1.20/41 1.38/8 1.55/20 0.86/21   4/1 1,00 1.71/7 1.13/8 0.00/3 3.00/4
2018-10-21 Sochaux 0-1 Evian TG 41/-17 2,54 1.05/39 1.63/8 1.15/20 0.95/19   5/2 1,00 1.88/8 1.13/8 0.00/3 3.00/5
2018-10-21 Evian TG 0-1 Lille 6/3 1,00 2.00/9 1.13/8 0.00/3 3.00/6   59/18 2,56 1.59/39 1.38/8 1.70/20 1.47/19
2018-10-21 Evian TG 0-1 Toulouse 6/2 1,00 1.80/10 1.13/8 0.00/4 3.00/6   50/1 2,41 1.32/41 1.88/8 1.33/21 1.30/20
2018-10-21 Montpellier 0-1 Evian TG 56/4 2,63 1.41/41 1.25/8 1.90/20 0.95/21   6/1 1,00 1.64/11 1.13/8 0.00/5 3.00/6
2018-10-21 Evian TG 0-1 Lorient 7/2 1,00 1.75/12 1.13/8 0.00/5 3.00/7   58/-2 2,88 1.37/41 1.13/8 1.71/21 1.00/20
2018-10-21 Marseille 0-1 Evian TG 42/6 2,05 1.87/38 2.13/8 2.11/19 1.63/19   7/1 1,00 1.62/13 1.13/8 0.00/6 3.00/7
2018-10-21 Evian TG 0-1 Bastia 8/2 1,00 1.71/14 1.13/8 0.00/6 3.00/8   50/-16 3,05 1.24/38 1.38/8 1.58/19 0.89/19
2018-10-21 AC Ajaccio 0-1 Evian TG 39/-12 2,37 1.11/38 0.88/8 1.37/19 0.84/19   8/1 1,00 1.60/15 1.13/8 0.00/7 3.00/8
2018-10-21 Evian TG 0-1 Lyon 9/2 1,00 1.69/16 1.13/8 0.00/7 3.00/9   61/22 2,56 1.72/39 1.63/8 1.85/20 1.58/19
2018-10-21 Brest 0-1 Evian TG 34/-29 2,37 0.85/41 0.75/8 0.90/20 0.81/21   9/1 1,00 1.59/17 1.13/8 0.00/8 3.00/9
2018-10-21 Valenciennes 0-1 Evian TG 51/-3 2,56 1.32/41 1.63/8 1.65/20 1.00/21   10/2 1,00 1.67/18 1.13/8 0.00/8 3.00/10
2018-10-21 Evian TG 0-1 Brest 11/3 1,00 1.74/19 1.13/8 0.00/8 3.00/11   33/-30 2,40 0.80/40 0.75/8 0.90/20 0.70/20
2018-10-21 Evian TG 0-1 Valenciennes 11/2 1,00 1.65/20 1.13/8 0.00/9 3.00/11   50/-3 2,64 1.31/39 1.63/8 1.74/19 0.90/20
2018-10-21 Evian TG 0-1 Nice 11/1 1,00 1.57/21 1.13/8 0.00/10 3.00/11   57/10 2,67 1.64/39 1.63/8 1.90/20 1.37/19
2018-10-21 Troyes 0-1 Evian TG 43/-18 2,74 0.97/38 1.50/8 1.37/19 0.58/19   11/0 1,00 1.50/22 1.13/8 0.00/11 3.00/11
2018-10-21 Evian TG 0-1 Paris SG 12/1 1,00 1.57/23 1.13/8 0.00/11 3.00/12   15/2 1,12 1.56/25 1.50/8 0.00/12 3.00/13
2018-10-21 Nancy 0-1 Evian TG 38/-20 2,53 1.00/38 1.38/8 1.05/19 0.95/19   12/0 1,00 1.50/24 1.13/8 0.00/12 3.00/12
2018-10-21 Evian TG 0-1 Rennes 13/1 1,00 1.56/25 1.13/8 0.00/12 3.00/13   48/-11 2,82 1.21/38 0.50/8 1.21/19 1.21/19
2018-10-21 St Etienne 0-1 Evian TG 60/28 2,42 1.66/38 1.63/8 1.95/19 1.37/19   13/0 1,00 1.50/26 1.13/8 0.00/13 3.00/13
2018-10-21 Evian TG 0-1 Reims 14/1 1,00 1.56/27 1.13/8 0.00/13 3.00/14   33/-10 1,95 1.10/39 1.38/8 1.55/20 0.63/19
2018-10-21 Lille 0-1 Evian TG 61/20 2,49 1.66/41 1.38/8 1.70/20 1.62/21   14/0 1,00 1.50/28 1.13/8 0.00/14 3.00/14
2018-10-21 Evian TG 0-1 Sochaux 15/1 1,00 1.55/29 1.13/8 0.00/14 3.00/15   41/-18 2,50 1.03/40 1.63/8 1.10/21 0.95/19
2018-10-21 Toulouse 0-1 Evian TG 50/3 2,49 1.38/39 1.88/8 1.47/19 1.30/20   15/0 1,00 1.50/30 1.13/8 0.00/15 3.00/15
2018-10-21 Evian TG 0-1 Montpellier 16/1 1,00 1.55/31 1.13/8 0.00/15 3.00/16   55/3 2,68 1.38/40 1.25/8 1.90/20 0.85/20
2018-10-21 Lorient 0-1 Evian TG 58/-1 2,93 1.40/40 1.13/8 1.80/20 1.00/20   16/0 1,00 1.50/32 1.13/8 0.00/16 3.00/16
2018-10-21 Evian TG 0-1 Marseille 17/1 1,00 1.55/33 1.13/8 0.00/16 3.00/17   43/6 2,00 1.85/40 1.63/8 2.00/20 1.70/20
2018-10-21 Bastia 0-1 Evian TG 52/-15 2,90 1.29/41 1.63/8 1.50/20 1.10/21   17/0 1,00 1.50/34 1.13/8 0.00/17 3.00/17
2018-10-21 Evian TG 0-1 AC Ajaccio 18/1 1,00 1.54/35 1.13/8 0.00/17 3.00/18   39/-13 2,33 1.08/39 1.00/8 1.30/20 0.84/19
2018-10-21 Lyon 0-1 Evian TG 63/24 2,49 1.78/41 1.63/8 1.85/20 1.71/21   18/0 1,00 1.50/36 1.13/8 0.00/18 3.00/18
2018-10-21 Evian TG 0-1 Bordeaux 19/1 1,00 1.54/37 1.13/8 0.00/18 3.00/19   41/7 1,92 1.49/39 1.63/8 1.68/19 1.30/20