SELECT * FROM 1_Kampe WHERE LigaID = '325' 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
2021-07-24 Valenciennes 0-0 Niort 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
2021-07-31 Guingamp 1-1 Valenciennes 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
2021-08-07 Valenciennes 0-3 Nimes 1/0 1,00 1.00/2 1.00/2 1.00/1 1.00/1   3/1 2,50 2.00/2 2.00/2 3.00/1 1.00/1
2021-08-14 Nancy 0-1 Valenciennes 2/-5 3,00 0.33/3 0.33/3 0.00/1 0.50/2   1/-3 1,67 0.67/3 0.67/3 0.50/2 1.00/1
2021-08-21 Valenciennes 1-4 Rodez 2/-2 1,50 1.25/4 1.25/4 0.50/2 2.00/2   2/-3 1,75 1.25/4 1.25/4 2.00/2 0.50/2
2021-08-28 Toulouse 1-0 Valenciennes 12/8 3,20 2.60/5 2.60/5 2.00/2 3.00/3   3/-5 2,20 1.00/5 1.00/5 0.33/3 2.00/2
2021-09-11 Valenciennes 1-2 Quevilly Rouen 3/-6 2,00 0.83/6 0.83/6 0.33/3 1.33/3   7/-1 2,50 1.17/6 1.17/6 1.00/3 1.33/3
2021-09-18 Pau FC 1-1 Valenciennes 8/4 1,71 1.86/7 1.86/7 2.25/4 1.33/3   4/-7 2,14 0.71/7 0.71/7 0.25/4 1.33/3
2021-09-21 Valenciennes 2-1 Bastia 5/-7 2,13 0.75/8 0.75/8 0.25/4 1.25/4   6/-3 1,88 0.88/8 0.88/8 1.00/4 0.75/4
2021-09-24 Dijon 0-1 Valenciennes 11/-4 2,89 1.11/9 1.25/8 1.40/5 0.75/4   7/-6 2,22 1.00/9 1.00/8 0.80/5 1.25/4
2021-10-02 Caen 1-2 Valenciennes 12/2 2,20 1.40/10 1.00/8 1.20/5 1.60/5   8/-5 2,10 1.20/10 1.25/8 0.80/5 1.60/5
2021-10-16 Valenciennes 1-3 Dunkerque 10/-4 2,18 1.36/11 1.63/8 0.80/5 1.83/6   9/-6 2,18 0.82/11 1.00/8 0.83/6 0.80/5
2021-10-23 Amiens 3-0 Valenciennes 11/-5 2,25 0.75/12 0.75/8 0.50/6 1.00/6   11/-6 2,33 1.25/12 1.25/8 0.67/6 1.83/6
2021-11-01 Valenciennes 1-2 Auxerre 11/-9 2,38 1.15/13 1.25/8 0.67/6 1.57/7   19/6 2,46 1.77/13 1.88/8 2.00/7 1.50/6
2021-11-06 Le Havre 0-0 Valenciennes 14/6 1,57 1.71/14 1.88/8 2.00/7 1.43/7   12/-10 2,43 1.07/14 1.25/8 0.57/7 1.57/7
2021-11-20 Valenciennes 1-0 Grenoble 12/-10 2,27 1.07/15 1.38/8 0.57/7 1.50/8   15/-3 2,20 1.40/15 1.75/8 2.00/8 0.71/7
2021-12-03 AC Ajaccio 0-0 Valenciennes 18/10 1,63 1.94/16 1.63/8 2.38/8 1.50/8   13/-9 2,19 1.19/16 1.63/8 0.88/8 1.50/8
2021-12-11 Valenciennes 1-4 Paris FC 13/-9 2,06 1.18/17 1.38/8 0.88/8 1.44/9   20/5 2,06 1.76/17 1.75/8 1.88/8 1.67/9
2021-12-21 Sochaux 1-1 Valenciennes 19/4 1,89 1.78/18 1.50/8 1.89/9 1.67/9   14/-12 2,22 1.11/18 1.00/8 0.78/9 1.44/9
2022-01-08 Valenciennes 1-1 Guingamp 15/-12 2,21 1.11/19 0.75/8 0.78/9 1.40/10   23/-4 2,63 1.26/19 1.25/8 1.56/9 1.00/10
2022-01-28 Nimes 2-1 Valenciennes 24/-1 2,45 1.30/20 1.50/8 1.20/10 1.40/10   16/-12 2,20 1.10/20 0.88/8 0.80/10 1.40/10
2022-02-01 Valenciennes 6-1 Nancy 17/-13 2,24 1.05/21 0.88/8 0.80/10 1.27/11   16/-22 2,57 0.71/21 0.88/8 0.90/10 0.55/11
2022-02-05 Rodez 0-0 Valenciennes 20/-3 1,95 1.27/22 1.13/8 1.30/10 1.25/12   23/-8 2,45 1.14/22 1.25/8 1.00/11 1.27/11
2022-02-12 Valenciennes 1-3 Toulouse 23/-8 2,35 1.13/23 1.25/8 1.00/11 1.25/12   49/29 3,00 1.96/23 1.88/8 2.08/12 1.82/11
2022-02-19 Quevilly Rouen 1-1 Valenciennes 22/-11 2,29 1.17/24 1.38/8 1.27/11 1.08/13   24/-10 2,42 1.08/24 0.88/8 0.92/12 1.25/12
2022-02-26 Valenciennes 1-0 Pau FC 25/-10 2,40 1.08/25 0.88/8 0.92/12 1.23/13   27/-1 2,20 1.40/25 1.38/8 1.92/13 0.83/12
2022-03-05 Bastia 1-1 Valenciennes 26/0 2,00 1.12/26 1.25/8 1.46/13 0.77/13   26/-9 2,35 1.15/26 1.25/8 1.08/13 1.23/13
2022-03-12 Valenciennes 0-0 Dijon 27/-9 2,33 1.15/27 1.25/8 1.08/13 1.21/14   31/-5 2,48 1.22/27 1.25/8 1.43/14 1.00/13
2022-03-15 Valenciennes 1-1 Caen 27/-9 2,25 1.14/28 1.25/8 1.07/14 1.21/14   37/6 2,43 1.25/28 1.63/8 1.47/15 1.00/13
2022-03-19 Dunkerque 1-2 Valenciennes 22/-13 1,97 1.03/29 1.50/8 1.33/15 0.71/14   28/-9 2,24 1.14/29 1.38/8 1.07/15 1.21/14
2022-04-02 Valenciennes 0-2 Amiens 30/-8 2,27 1.20/30 1.38/8 1.07/15 1.33/15   37/4 2,33 1.23/30 1.50/8 1.63/16 0.79/14
2022-04-09 Auxerre 1-0 Valenciennes 48/14 2,65 1.77/31 2.13/8 1.67/15 1.88/16   30/-10 2,26 1.16/31 1.25/8 1.00/16 1.33/15
2022-04-16 Valenciennes 0-1 Le Havre 30/-11 2,22 1.13/32 1.25/8 1.00/16 1.25/16   32/-2 2,06 1.38/32 1.13/8 1.35/17 1.40/15
2022-04-19 Grenoble 3-0 Valenciennes 26/-14 2,00 1.09/33 1.38/8 1.31/16 0.88/17   30/-12 2,18 1.09/33 1.13/8 0.94/17 1.25/16
2022-04-22 Valenciennes 0-0 AC Ajaccio 30/-15 2,21 1.06/34 0.75/8 0.94/17 1.18/17   35/18 1,53 1.97/34 2.38/8 2.12/17 1.82/17
2022-04-30 Paris FC 1-1 Valenciennes 49/16 2,34 1.80/35 1.38/8 2.12/17 1.50/18   30/-15 2,14 1.06/35 0.75/8 0.94/18 1.18/17
2022-05-07 Valenciennes 1-0 Sochaux 31/-15 2,14 1.06/36 0.75/8 0.94/18 1.17/18   45/14 2,11 1.86/36 2.50/8 1.94/18 1.78/18
2022-05-14 Niort 1-2 Valenciennes 38/-2 2,11 1.24/37 1.25/8 1.44/18 1.05/19   32/-14 2,11 1.11/37 1.00/8 1.05/19 1.17/18