SELECT * FROM 1_Kampe WHERE LigaID = '80' AND (Home='St Etienne' OR Away='St Etienne') 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
2016-08-13 Bordeaux 3-2 St Etienne 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
2016-08-21 St Etienne 3-1 Montpellier 2/-1 5,00 0.00/1 0.00/1 0.00/0 0.00/1   1/1 1,00 3.00/1 3.00/1 3.00/1 0.00/0
2016-08-28 St Etienne 0-0 Toulouse 5/1 4,50 1.50/2 1.50/2 3.00/1 0.00/1   4/3 2,50 2.00/2 2.00/2 3.00/1 1.00/1
2016-09-09 PSG 1-1 St Etienne 5/2 2,67 2.00/3 2.00/3 3.00/1 1.50/2   5/1 3,00 1.33/3 1.33/3 2.00/2 0.00/1
2016-09-18 St Etienne 1-0 Bastia 6/1 2,75 1.25/4 1.25/4 2.00/2 0.50/2   5/1 2,25 1.50/4 1.50/4 1.50/2 1.50/2
2016-09-21 Nantes 0-0 St Etienne 2/-4 1,60 0.80/5 0.80/5 0.00/2 1.33/3   7/2 2,40 1.60/5 1.60/5 2.33/3 0.50/2
2016-09-25 St Etienne 3-1 Lille 7/2 2,00 1.50/6 1.50/6 2.33/3 0.67/3   6/-5 2,83 0.67/6 0.67/6 1.00/3 0.33/3
2016-10-02 Lyon 2-0 St Etienne 13/4 3,14 1.43/7 1.43/7 2.00/3 1.00/4   10/4 2,29 1.71/7 1.71/7 2.50/4 0.67/3
2016-10-16 St Etienne 1-1 Dijon 10/2 2,25 1.50/8 1.50/8 2.50/4 0.50/4   11/-2 3,00 1.00/8 1.00/8 1.60/5 0.00/3
2016-10-23 Caen 0-2 St Etienne 9/-8 2,89 1.11/9 0.88/8 2.25/4 0.20/5   11/2 2,22 1.44/9 1.63/8 2.20/5 0.50/4
2016-10-29 St Etienne 1-1 Monaco 13/4 2,20 1.60/10 1.63/8 2.20/5 1.00/5   29/15 4,30 2.20/10 2.25/8 2.60/5 1.80/5
2016-11-06 Metz 0-0 St Etienne 11/-10 2,91 1.18/11 0.88/8 1.20/5 1.17/6   14/4 2,18 1.55/11 1.63/8 2.00/6 1.00/5
2016-11-20 St Etienne 0-1 Nice 14/4 2,00 1.50/12 1.63/8 2.00/6 1.00/6   24/15 2,75 2.42/12 2.38/8 2.71/7 2.00/5
2016-11-27 Angers 1-2 St Etienne 12/0 1,85 1.38/13 1.50/8 1.83/6 1.00/7   14/3 1,92 1.38/13 1.25/8 1.71/7 1.00/6
2016-11-30 St Etienne 0-0 Marseille 16/4 2,00 1.50/14 1.50/8 1.71/7 1.29/7   13/-4 2,14 1.21/14 1.50/8 2.14/7 0.29/7
2016-12-04 Rennes 2-0 St Etienne 16/-3 2,33 1.60/15 1.75/8 2.50/8 0.57/7   16/4 1,87 1.47/15 1.25/8 1.63/8 1.29/7
2016-12-11 St Etienne 1-0 Guingamp 16/2 1,88 1.38/16 1.25/8 1.63/8 1.13/8   21/6 2,25 1.63/16 1.88/8 2.13/8 1.13/8
2016-12-17 Lorient 2-1 St Etienne 18/-14 2,94 0.71/17 0.75/8 1.25/8 0.22/9   17/3 1,82 1.47/17 1.50/8 1.78/9 1.13/8
2016-12-21 St Etienne 0-0 Nancy 18/2 1,89 1.39/18 1.13/8 1.78/9 1.00/9   15/-8 2,11 1.11/18 1.75/8 1.44/9 0.78/9
2017-01-13 Lille 1-1 St Etienne 18/-7 2,26 1.11/19 1.38/8 1.60/10 0.56/9   18/2 1,79 1.37/19 1.13/8 1.70/10 1.00/9
2017-01-22 St Etienne 2-1 Angers 19/2 1,80 1.35/20 1.13/8 1.70/10 1.00/10   16/-9 2,05 1.00/20 0.38/8 1.30/10 0.70/10
2017-01-29 Toulouse 0-3 St Etienne 22/-1 2,14 1.24/21 0.88/8 1.90/10 0.64/11   21/3 1,86 1.43/21 1.50/8 1.82/11 1.00/10
2017-02-05 St Etienne 2-0 Lyon 24/6 1,91 1.50/22 1.50/8 1.82/11 1.18/11   40/15 3,10 1.76/21 1.88/8 1.91/11 1.60/10
2017-02-08 Nice 1-0 St Etienne 38/20 2,43 2.13/23 1.63/8 2.50/12 1.73/11   26/8 1,91 1.57/23 1.75/8 1.92/12 1.18/11
2017-02-12 St Etienne 4-0 Lorient 26/7 1,88 1.50/24 1.75/8 1.92/12 1.08/12   27/-20 3,08 0.92/24 1.25/8 1.42/12 0.42/12
2017-02-19 Montpellier 2-1 St Etienne 36/-6 3,12 1.16/25 1.25/8 1.83/12 0.54/13   30/11 1,96 1.56/25 1.75/8 2.00/13 1.08/12
2017-02-26 St Etienne 0-1 Caen 31/10 2,00 1.50/26 1.75/8 2.00/13 1.00/13   26/-17 2,65 1.08/26 1.25/8 1.77/13 0.38/13
2017-03-04 Bastia 0-0 St Etienne 24/-14 2,30 0.89/27 0.50/8 1.21/14 0.54/13   31/9 1,96 1.44/27 1.63/8 1.86/14 1.00/13
2017-03-12 St Etienne 2-2 Metz 31/9 1,89 1.43/28 1.63/8 1.86/14 1.00/14   26/-25 2,85 1.15/27 1.38/8 1.54/13 0.79/14
2017-03-19 Dijon 0-1 St Etienne 38/-8 2,90 0.97/29 0.88/8 1.43/14 0.53/15   33/9 1,97 1.41/29 1.38/8 1.80/15 1.00/14
2017-04-09 St Etienne 1-1 Nantes 34/10 1,93 1.47/30 1.38/8 1.80/15 1.13/15   30/-15 2,42 1.32/31 1.88/8 1.38/16 1.27/15
2017-04-16 Marseille 4-0 St Etienne 44/6 2,56 1.50/32 1.50/8 2.13/16 0.88/16   35/10 1,94 1.45/31 1.13/8 1.75/16 1.13/15
2017-04-23 St Etienne 1-1 Rennes 35/6 2,00 1.41/32 1.13/8 1.75/16 1.06/16   31/-6 2,06 1.30/33 1.25/8 1.94/17 0.63/16
2017-04-29 Guingamp 0-2 St Etienne 40/-7 2,56 1.29/34 1.25/8 2.06/16 0.61/18   36/6 2,00 1.39/33 0.88/8 1.71/17 1.06/16
2017-05-05 St Etienne 2-2 Bordeaux 38/8 2,00 1.44/34 1.25/8 1.71/17 1.18/17   49/10 2,51 1.60/35 1.75/8 1.78/18 1.41/17
2017-05-14 St Etienne 0-5 PSG 40/8 2,06 1.43/35 1.38/8 1.67/18 1.18/17   77/51 2,86 2.31/36 2.63/8 2.44/18 2.17/18
2017-05-17 Monaco 2-0 St Etienne 102/73 3,64 2.47/36 3.00/8 2.72/18 2.22/18   40/3 2,14 1.39/36 1.25/8 1.58/19 1.18/17
2017-05-20 Nancy 3-1 St Etienne 26/-25 2,08 0.86/37 0.50/8 1.17/18 0.58/19   40/1 2,14 1.35/37 1.13/8 1.58/19 1.11/18
2018-10-21 Paris SG 0-1 St Etienne 7/-1 1,00 1.40/15 1.88/8 0.00/8 3.00/7   41/-1 2,18 1.32/38 0.75/8 1.58/19 1.05/19
2018-10-21 St Etienne 0-1 Paris SG 42/0 2,15 1.36/39 1.00/8 1.58/19 1.15/20   9/-2 1,00 1.35/20 1.88/8 0.00/11 3.00/9