SELECT * FROM 1_Kampe WHERE LigaID = '89' AND (Home='Sochaux' OR Away='Sochaux') 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 Sochaux 2-0 Bourg en Bresse 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 Quevilly Rouen 1-1 Sochaux 1/0 2,00 1.00/1 1.00/1 0.00/0 1.00/1   2/2 2,00 3.00/1 3.00/1 3.00/1 0.00/0
2017-08-12 Sochaux 3-2 Lens 3/2 2,00 2.00/2 2.00/2 3.00/1 1.00/1   1/-2 2,00 0.00/2 0.00/2 0.00/1 0.00/1
2017-08-18 Nancy 2-2 Sochaux 1/-2 1,33 0.67/3 0.67/3 1.00/1 0.50/2   6/3 3,00 2.33/3 2.33/3 3.00/2 1.00/1
2017-08-25 Sochaux 1-5 Chateauroux 8/3 3,25 2.00/4 2.00/4 3.00/2 1.00/2   4/-2 2,50 1.50/4 1.50/4 1.50/2 1.50/2
2017-09-08 GFC Ajaccio 0-1 Sochaux 2/-1 1,00 1.20/5 1.20/5 2.00/2 0.67/3   9/-1 3,80 1.60/5 1.60/5 2.00/3 1.00/2
2017-09-16 Sochaux 2-4 Reims 10/0 3,33 1.83/6 1.83/6 2.00/3 1.67/3   8/5 1,83 2.00/6 2.00/6 2.00/3 2.00/3
2017-09-19 Le Havre 1-0 Sochaux 12/8 2,29 1.86/7 1.86/7 2.33/3 1.50/4   12/-2 3,71 1.57/7 1.57/7 1.50/4 1.67/3
2017-09-22 Sochaux 1-6 AC Ajaccio 12/-3 3,38 1.38/8 1.38/8 1.50/4 1.25/4   11/3 2,38 1.75/8 1.75/8 2.25/4 1.25/4
2017-09-29 Auxerre 2-0 Sochaux 8/-7 2,56 1.11/9 0.88/8 1.75/4 0.60/5   13/-8 3,78 1.22/9 1.00/8 1.20/5 1.25/4
2017-10-13 Sochaux 1-0 Paris FC 13/-10 3,60 1.10/10 0.88/8 1.20/5 1.00/5   12/3 2,10 2.00/10 2.00/8 2.17/6 1.75/4
2017-10-20 Tours 0-1 Sochaux 5/-18 2,55 0.18/11 0.25/8 0.00/5 0.33/6   14/-9 3,36 1.27/11 0.88/8 1.50/6 1.00/5
2017-10-27 Sochaux 2-1 Niort 15/-8 3,17 1.42/12 1.13/8 1.50/6 1.33/6   15/1 2,42 1.50/12 1.25/8 1.86/7 1.00/5
2017-11-03 Orleans 3-3 Sochaux 19/1 2,85 1.38/13 1.00/8 1.57/7 1.17/6   17/-7 3,15 1.54/13 1.50/8 1.71/7 1.33/6
2017-11-17 Sochaux 2-1 Nimes 20/-7 3,36 1.50/14 1.25/8 1.71/7 1.29/7   30/16 3,14 2.00/14 2.25/8 2.00/8 2.00/6
2017-11-24 Brest 1-0 Sochaux 19/-1 2,60 1.47/15 1.13/8 1.29/7 1.63/8   22/-6 3,33 1.60/15 1.63/8 1.88/8 1.29/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 Lorient 2-1 Sochaux 27/9 2,65 1.71/17 1.38/8 2.00/9 1.38/8   25/-5 3,24 1.59/17 2.00/8 2.00/9 1.13/8
2017-12-15 Clermont 0-2 Sochaux 24/8 2,22 1.61/18 1.50/8 2.00/8 1.30/10   26/-6 3,22 1.50/18 2.00/8 2.00/9 1.00/9
2018-01-12 Sochaux 0-1 Quevilly Rouen 28/-4 3,16 1.58/19 2.00/8 2.00/9 1.20/10   18/-16 2,74 0.63/19 0.88/8 1.00/10 0.22/9
2018-01-19 Sochaux 1-0 Nancy 28/-5 3,05 1.50/20 1.63/8 1.80/10 1.20/10   22/-7 2,43 1.00/21 0.88/8 1.27/11 0.70/10
2018-01-26 Chateauroux 1-1 Sochaux 29/-2 2,73 1.55/22 1.75/8 1.80/10 1.33/12   29/-4 2,95 1.57/21 1.63/8 1.91/11 1.20/10
2018-01-30 Lens 0-1 Sochaux 29/4 2,45 1.14/22 1.75/8 1.50/10 0.83/12   30/-4 2,91 1.55/22 1.63/8 1.91/11 1.18/11
2018-02-02 Sochaux 4-1 GFC Ajaccio 31/-3 2,83 1.61/23 1.63/8 1.91/11 1.33/12   19/-10 2,09 1.30/23 1.25/8 1.58/12 1.00/11
2018-02-09 Reims 3-0 Sochaux 41/28 2,25 2.25/24 2.38/8 2.27/11 2.23/13   35/0 2,92 1.67/24 2.00/8 2.00/12 1.33/12
2018-02-16 Sochaux 3-2 Le Havre 35/-3 2,92 1.60/25 1.63/8 2.00/12 1.23/13   34/13 2,20 1.72/25 1.50/8 2.33/12 1.15/13
2018-02-23 AC Ajaccio 3-2 Sochaux 41/12 2,69 1.73/26 1.75/8 2.15/13 1.31/13   38/-2 3,00 1.65/26 2.00/8 2.08/13 1.23/13
2018-03-10 Paris FC 2-0 Sochaux 32/7 2,04 1.64/28 1.13/8 1.93/14 1.36/14   40/-3 3,07 1.59/27 1.63/8 2.08/13 1.14/14
2018-03-13 Sochaux 0-4 Auxerre 40/-5 3,04 1.54/28 1.63/8 2.08/13 1.07/15   35/0 2,50 1.32/28 2.13/8 1.53/15 1.08/13
2018-03-16 Sochaux 0-0 Tours 40/-9 3,07 1.48/29 1.25/8 1.93/14 1.07/15   20/-31 2,54 0.50/28 1.00/8 0.57/14 0.43/14
2018-03-30 Niort 1-1 Sochaux 34/-12 2,67 1.17/30 1.13/8 1.20/15 1.13/15   40/-9 2,97 1.47/30 1.25/8 1.87/15 1.07/15
2018-04-06 Sochaux 3-2 Orleans 41/-9 2,94 1.45/31 1.00/8 1.87/15 1.06/16   40/-7 2,81 1.26/31 1.50/8 1.25/16 1.27/15
2018-04-13 Nimes 0-2 Sochaux 65/35 2,97 2.00/32 2.50/8 2.06/16 1.94/16   44/-8 3,00 1.50/32 1.00/8 1.94/16 1.06/16
2018-04-20 Sochaux 1-1 Brest 46/-6 2,97 1.55/33 1.38/8 1.94/16 1.18/17   48/10 2,61 1.64/33 2.00/8 1.53/17 1.75/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 Sochaux 0-2 Lorient 49/-6 2,97 1.51/35 1.25/8 1.88/17 1.17/18   53/10 2,74 1.60/35 1.50/8 1.94/18 1.24/17
2018-05-04 Sochaux 1-3 Clermont 49/-8 2,94 1.47/36 1.25/8 1.78/18 1.17/18   49/16 2,28 1.64/36 1.38/8 1.94/18 1.33/18
2018-05-11 Bourg en Bresse 2-1 Sochaux 48/-38 3,62 0.89/37 0.38/8 1.22/18 0.58/19   50/-10 2,97 1.43/37 1.25/8 1.68/19 1.17/18