SELECT * FROM 1_Kampe WHERE LigaID = '84' 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
2012-08-11 Troyes 0-1 Valenciennes 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
2012-08-18 Valenciennes 0-0 Nice 1/1 1,00 3.00/1 3.00/1 0.00/0 3.00/1   0/-1 1,00 0.00/1 0.00/1 0.00/1 0.00/0
2012-08-25 Valenciennes 3-0 AC Ajaccio 1/1 0,50 2.00/2 2.00/2 1.00/1 3.00/1   1/1 0,50 2.00/2 2.00/2 1.00/1 3.00/1
2012-09-01 Lyon 3-2 Valenciennes 6/4 2,67 2.33/3 2.33/3 3.00/1 2.00/2   4/4 1,33 2.33/3 2.33/3 2.00/2 3.00/1
2012-09-15 Valenciennes 0-0 Bordeaux 6/3 2,25 1.75/4 1.75/4 2.00/2 1.50/2   5/2 2,00 2.00/4 2.00/4 2.00/2 2.00/2
2012-09-22 Brest 2-1 Valenciennes 5/-5 3,00 1.20/5 1.20/5 3.00/2 0.00/3   6/3 1,80 1.60/5 1.60/5 1.67/3 1.50/2
2012-09-30 Valenciennes 4-1 Marseille 7/2 2,00 1.33/6 1.33/6 1.67/3 1.00/3   9/8 1,67 3.00/6 3.00/6 3.00/3 3.00/3
2012-10-06 Toulouse 2-2 Valenciennes 9/2 2,29 1.71/7 1.71/7 1.67/3 1.75/4   11/5 2,43 1.57/7 1.57/7 2.00/4 1.00/3
2012-10-20 Valenciennes 6-1 Lorient 13/5 2,63 1.50/8 1.50/8 2.00/4 1.00/4   14/5 2,88 1.75/8 1.75/8 2.00/4 1.50/4
2012-10-27 Lille 2-1 Valenciennes 11/0 2,44 1.22/9 1.00/8 1.25/4 1.20/5   19/10 3,11 1.67/9 1.50/8 2.20/5 1.00/4
2012-11-03 Valenciennes 3-1 Sochaux 20/9 3,10 1.50/10 1.38/8 2.20/5 0.80/5   8/-6 2,44 0.78/9 0.88/8 0.75/4 0.80/5
2012-11-10 Bastia 2-3 Valenciennes 17/-9 3,91 1.27/11 1.00/8 1.80/5 0.83/6   23/11 3,18 1.64/11 1.38/8 2.33/6 0.80/5
2012-11-17 Valenciennes 1-1 Montpellier 26/12 3,33 1.75/12 1.75/8 2.33/6 1.17/6   17/0 2,83 1.08/12 1.13/8 1.00/6 1.17/6
2012-11-23 St Etienne 1-0 Valenciennes 23/13 2,54 1.69/13 2.00/8 1.86/7 1.50/6   27/12 3,23 1.69/13 1.75/8 2.14/7 1.17/6
2012-12-01 Valenciennes 1-0 Reims 27/11 3,07 1.57/14 1.75/8 2.14/7 1.00/7   13/-1 1,93 1.14/14 0.75/8 1.75/8 0.33/6
2012-12-08 Nancy 1-1 Valenciennes 10/-16 2,40 0.53/15 0.50/8 0.63/8 0.43/7   28/12 2,93 1.67/15 1.75/8 2.25/8 1.00/7
2012-12-11 Valenciennes 0-4 PSG 29/12 2,88 1.63/16 1.75/8 2.25/8 1.00/8   28/16 2,50 1.81/16 1.63/8 1.89/9 1.71/7
2012-12-14 Rennes 2-0 Valenciennes 23/1 2,65 1.53/17 1.63/8 1.63/8 1.44/9   29/8 2,94 1.53/17 1.38/8 2.00/9 1.00/8
2012-12-23 Valenciennes 2-1 Thonon-Evian 29/6 2,89 1.44/18 1.38/8 2.00/9 0.89/9   21/-9 2,83 1.06/18 1.38/8 1.11/9 1.00/9
2013-01-13 Nice 5-0 Valenciennes 26/0 2,74 1.53/19 2.13/8 2.10/10 0.89/9   31/7 2,89 1.53/19 1.38/8 2.10/10 0.89/9
2013-01-19 AC Ajaccio 1-1 Valenciennes 21/-8 2,50 1.10/20 0.75/8 1.33/9 0.91/11   31/2 3,00 1.45/20 1.00/8 2.10/10 0.80/10
2013-01-25 Valenciennes 0-2 Lyon 32/2 2,95 1.43/21 1.00/8 2.10/10 0.82/11   35/17 2,52 2.00/21 2.13/8 2.36/11 1.60/10
2013-02-02 Bordeaux 2-0 Valenciennes 24/9 1,77 1.59/22 1.38/8 1.50/10 1.67/12   32/0 2,91 1.36/22 1.00/8 1.91/11 0.82/11
2013-02-09 Valenciennes 2-1 Brest 32/-2 2,87 1.30/23 0.63/8 1.91/11 0.75/12   23/-10 2,43 1.04/23 0.88/8 1.45/11 0.67/12
2013-02-16 Marseille 1-0 Valenciennes 31/2 2,50 1.79/24 1.75/8 1.82/11 1.77/13   34/-1 2,88 1.38/24 0.88/8 2.00/12 0.75/12
2013-02-23 Valenciennes 0-0 Toulouse 34/-2 2,80 1.32/25 0.88/8 2.00/12 0.69/13   32/0 2,56 1.28/25 1.13/8 1.54/13 1.00/12
2013-03-02 Lorient 1-1 Valenciennes 42/0 3,23 1.50/26 1.13/8 2.00/13 1.00/13   34/-2 2,69 1.31/26 1.00/8 1.92/13 0.69/13
2013-03-09 Valenciennes 1-3 Lille 35/-2 2,67 1.30/27 0.75/8 1.92/13 0.71/14   37/10 2,37 1.59/27 1.75/8 1.92/13 1.29/14
2013-03-16 Sochaux 1-1 Valenciennes 29/-16 2,64 0.96/28 1.00/8 1.21/14 0.71/14   36/-4 2,71 1.25/28 0.75/8 1.79/14 0.71/14
2013-03-30 Valenciennes 3-4 Bastia 37/-4 2,69 1.24/29 0.75/8 1.79/14 0.73/15   34/-19 3,00 1.14/29 1.00/8 1.57/14 0.73/15
2013-04-06 Montpellier 3-1 Valenciennes 44/8 2,67 1.50/30 1.63/8 2.07/15 0.93/15   40/-5 2,83 1.20/30 0.75/8 1.67/15 0.73/15
2013-04-12 Valenciennes 0-0 St Etienne 41/-7 2,87 1.16/31 0.75/8 1.67/15 0.69/16   51/26 2,45 1.71/31 2.00/8 1.88/16 1.53/15
2013-04-21 Reims 0-1 Valenciennes 31/-6 2,13 1.16/32 1.75/8 1.69/16 0.63/16   41/-7 2,78 1.16/32 0.50/8 1.63/16 0.69/16
2013-04-27 Valenciennes 0-0 Nancy 42/-6 2,73 1.21/33 0.88/8 1.63/16 0.82/17   33/-16 2,48 1.03/33 2.00/8 1.18/17 0.88/16
2013-05-05 PSG 1-1 Valenciennes 61/41 2,38 2.15/34 2.38/8 2.29/17 2.00/17   42/-6 2,65 1.21/34 0.88/8 1.59/17 0.82/17
2013-05-11 Valenciennes 4-1 Rennes 43/-6 2,63 1.20/35 0.88/8 1.59/17 0.83/18   46/-6 2,80 1.29/35 0.50/8 1.22/18 1.35/17
2013-05-18 Thonon-Evian 2-0 Valenciennes 43/-8 2,61 1.03/36 1.25/8 1.22/18 0.83/18   47/-3 2,69 1.25/36 1.25/8 1.67/18 0.83/18
2013-05-26 Valenciennes 2-1 Troyes 47/-5 2,68 1.22/37 1.13/8 1.67/18 0.79/19   42/-17 2,73 1.00/37 1.63/8 1.37/19 0.61/18
2018-10-21 Paris SG 0-1 Valenciennes 16/3 1,12 1.62/26 1.50/8 0.00/12 3.00/14   49/-4 2,68 1.26/38 1.50/8 1.74/19 0.79/19
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 Valenciennes 0-1 Paris SG 51/-2 2,60 1.35/40 1.63/8 1.74/19 1.00/21   4/0 1,00 1.50/8 1.50/8 0.00/4 3.00/4
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