SELECT * FROM 1_Kampe WHERE LigaID = '89' AND (Home='Valenciennes' OR Away='Valenciennes') 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
2017-07-28 Valenciennes 1-1 GFC 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
2017-08-04 Chateauroux 0-1 Valenciennes 3/1 5,00 3.00/1 3.00/1 0.00/0 3.00/1   1/0 2,00 1.00/1 1.00/1 1.00/1 0.00/0
2017-08-11 Valenciennes 0-0 Clermont 2/1 1,50 2.00/2 2.00/2 1.00/1 3.00/1   2/2 1,00 2.00/2 2.00/2 3.00/1 1.00/1
2017-08-18 Le Havre 1-0 Valenciennes 10/9 3,67 3.00/3 3.00/3 3.00/1 3.00/2   2/1 1,00 1.67/3 1.67/3 1.00/2 3.00/1
2017-08-25 Valenciennes 4-1 Niort 2/0 1,00 1.25/4 1.25/4 1.00/2 1.50/2   4/3 1,25 2.00/4 2.00/4 2.33/3 1.00/1
2017-09-08 Nancy 3-0 Valenciennes 4/-3 2,20 0.60/5 0.60/5 1.00/2 0.33/3   6/3 1,80 1.60/5 1.60/5 1.67/3 1.50/2
2017-09-15 Valenciennes 1-0 Lens 6/0 2,00 1.33/6 1.33/6 1.67/3 1.00/3   7/-8 3,67 0.00/6 0.00/6 0.00/3 0.00/3
2017-09-19 AC Ajaccio 3-0 Valenciennes 8/0 2,29 1.57/7 1.57/7 2.00/3 1.25/4   7/1 1,86 1.57/7 1.57/7 2.00/4 1.00/3
2017-09-22 Valenciennes 0-2 Auxerre 7/-2 2,00 1.38/8 1.38/8 2.00/4 0.75/4   6/-9 2,63 0.88/8 0.88/8 1.75/4 0.00/4
2017-09-29 Orleans 3-4 Valenciennes 13/5 2,33 1.67/9 1.50/8 2.20/5 1.00/4   7/-4 2,00 1.22/9 1.25/8 1.60/5 0.75/4
2017-10-13 Valenciennes 2-0 Tours 11/-3 2,50 1.40/10 1.25/8 1.60/5 1.20/5   5/-16 2,60 0.20/10 0.25/8 0.00/5 0.40/5
2017-10-20 Paris FC 3-2 Valenciennes 12/2 2,00 1.82/11 2.00/8 2.17/6 1.40/5   13/-1 2,45 1.55/11 1.50/8 1.83/6 1.20/5
2017-10-28 Valenciennes 1-2 Nimes 15/-2 2,67 1.42/12 1.50/8 1.83/6 1.00/6   24/12 3,00 1.83/12 2.25/8 1.86/7 1.80/5
2017-11-03 Valenciennes 0-0 Brest 16/-3 2,69 1.31/13 1.13/8 1.57/7 1.00/6   17/1 2,54 1.62/13 1.75/8 1.29/7 2.00/6
2017-11-17 Bourg en Bresse 1-3 Valenciennes 17/-12 3,29 0.93/14 0.88/8 1.67/6 0.38/8   16/-3 2,50 1.29/14 1.25/8 1.50/8 1.00/6
2017-11-24 Valenciennes 4-2 Lorient 19/-1 2,60 1.40/15 1.25/8 1.50/8 1.29/7   24/12 2,40 1.93/15 1.50/8 2.25/8 1.57/7
2017-11-28 Sochaux 3-1 Valenciennes 22/-7 3,19 1.50/16 1.63/8 1.88/8 1.13/8   23/1 2,81 1.50/16 1.63/8 1.67/9 1.29/7
2017-12-08 Valenciennes 1-1 Quevilly Rouen 24/-1 2,88 1.41/17 1.63/8 1.67/9 1.13/8   16/-13 2,65 0.65/17 0.75/8 1.11/9 0.13/8
2017-12-16 Reims 5-1 Valenciennes 31/20 2,33 2.28/18 2.13/8 2.38/8 2.20/10   25/-1 2,83 1.39/18 1.38/8 1.60/10 1.13/8
2018-01-12 Valenciennes 1-2 Chateauroux 26/-5 3,00 1.32/19 1.00/8 1.60/10 1.00/9   24/-2 2,63 1.47/19 1.63/8 1.67/9 1.30/10
2018-01-16 Clermont 3-0 Valenciennes 24/6 2,10 1.50/20 1.13/8 1.78/9 1.27/11   27/-6 3,00 1.25/20 1.00/8 1.45/11 1.00/9
2018-01-19 Valenciennes 1-1 Le Havre 27/-9 3,00 1.19/21 1.00/8 1.45/11 0.90/10   29/12 2,19 1.71/21 1.63/8 2.20/10 1.27/11
2018-01-26 Niort 1-2 Valenciennes 25/-7 2,59 1.18/22 0.88/8 1.64/11 0.73/11   28/-9 2,95 1.18/22 1.00/8 1.42/12 0.90/10
2018-02-02 Valenciennes 0-1 Nancy 30/-8 2,96 1.26/23 1.00/8 1.42/12 1.09/11   24/-8 2,43 0.96/23 0.75/8 1.25/12 0.64/11
2018-02-10 Lens 1-1 Valenciennes 30/3 2,38 1.08/24 1.50/8 1.36/11 0.85/13   30/-9 2,88 1.21/24 0.63/8 1.31/13 1.09/11
2018-02-16 Valenciennes 2-0 AC Ajaccio 31/-9 2,84 1.20/25 0.75/8 1.31/13 1.08/12   41/14 2,72 1.80/25 2.13/8 2.15/13 1.42/12
2018-02-23 Auxerre 2-0 Valenciennes 32/-1 2,50 1.31/26 1.88/8 1.54/13 1.08/13   33/-7 2,81 1.27/26 1.00/8 1.43/14 1.08/12
2018-03-02 Valenciennes 0-1 Orleans 33/-9 2,78 1.22/27 1.00/8 1.43/14 1.00/13   36/-3 2,78 1.30/27 1.50/8 1.36/14 1.23/13
2018-03-16 Valenciennes 2-4 Paris FC 33/-10 2,71 1.18/28 1.00/8 1.33/15 1.00/13   34/9 2,03 1.69/29 1.38/8 2.00/15 1.36/14
2018-03-30 Nimes 1-0 Valenciennes 61/32 3,00 1.93/30 1.88/8 2.00/15 1.87/15   35/-12 2,83 1.14/29 1.00/8 1.25/16 1.00/13
2018-04-03 Tours 1-2 Valenciennes 23/-29 2,50 0.60/30 1.13/8 0.73/15 0.47/15   35/-13 2,77 1.10/30 0.88/8 1.25/16 0.93/14
2018-04-06 Brest 3-1 Valenciennes 42/5 2,55 1.55/31 1.38/8 1.33/15 1.75/16   37/-12 2,77 1.16/31 0.88/8 1.25/16 1.07/15
2018-04-13 Valenciennes 2-2 Bourg en Bresse 38/-14 2,81 1.13/32 0.88/8 1.25/16 1.00/16   41/-26 3,38 0.97/32 1.38/8 1.31/16 0.63/16
2018-04-20 Lorient 0-1 Valenciennes 53/12 2,85 1.70/33 1.88/8 2.06/17 1.31/16   40/-14 2,85 1.12/33 0.88/8 1.24/17 1.00/16
2018-04-24 Valenciennes 2-2 Sochaux 41/-13 2,79 1.18/34 0.88/8 1.24/17 1.12/17   47/-6 2,94 1.53/34 1.13/8 1.88/17 1.18/17
2018-04-27 Quevilly Rouen 2-2 Valenciennes 40/-22 2,91 0.83/35 0.88/8 0.76/17 0.89/18   43/-13 2,83 1.17/35 1.00/8 1.22/18 1.12/17
2018-05-04 Valenciennes 1-3 Reims 45/-13 2,86 1.17/36 1.13/8 1.22/18 1.11/18   69/48 2,50 2.33/36 2.63/8 2.39/18 2.28/18
2018-05-11 GFC Ajaccio 3-4 Valenciennes 32/-24 2,38 1.11/37 1.25/8 1.61/18 0.63/19   46/-15 2,89 1.14/37 1.13/8 1.16/19 1.11/18