SELECT * FROM 1_Kampe WHERE LigaID = '137' AND (Home='Girona' OR Away='Girona') 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
2019-08-18 Girona 1-1 Gijon 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
2019-08-23 Albacete 1-0 Girona 0/-3 3,00 0.00/1 0.00/1 0.00/0 0.00/1   1/0 2,00 1.00/1 1.00/1 1.00/1 0.00/0
2019-09-01 Girona 1-0 Malaga 1/-1 1,50 0.50/2 0.50/2 1.00/1 0.00/1   2/1 1,50 2.00/2 2.00/2 1.00/1 3.00/1
2019-09-08 Girona 3-1 Rayo Vallecano 2/0 1,33 1.33/3 1.33/3 2.00/2 0.00/1   6/2 3,33 1.67/3 1.67/3 2.00/2 1.00/1
2019-09-14 Cadiz CF 2-0 Girona 9/5 3,25 3.00/4 3.00/4 3.00/2 3.00/2   5/2 2,00 1.75/4 1.75/4 2.33/3 0.00/1
2019-09-17 Almeria 3-1 Girona 9/8 2,00 2.60/5 2.60/5 3.00/2 2.33/3   5/0 2,00 1.40/5 1.40/5 2.33/3 0.00/2
2019-09-22 Girona 1-0 Las Palmas 6/-2 2,33 1.17/6 1.17/6 2.33/3 0.00/3   4/-3 1,83 1.00/6 1.00/6 1.00/4 1.00/2
2019-09-28 Huesca 1-0 Girona 6/2 1,43 1.71/7 1.71/7 2.00/3 1.50/4   7/-1 2,14 1.43/7 1.43/7 2.50/4 0.00/3
2019-10-03 Girona 3-1 Dep. La Coruna 7/-2 2,00 1.25/8 1.25/8 2.50/4 0.00/4   10/-4 3,00 0.88/8 0.88/8 1.25/4 0.50/4
2019-10-06 Racing Santander 0-3 Girona 9/0 2,00 0.89/9 1.00/8 1.00/5 0.75/4   10/0 2,22 1.44/9 1.50/8 2.60/5 0.00/4
2019-10-12 Girona 0-2 Elche 13/3 2,30 1.60/10 1.88/8 2.60/5 0.60/5   9/-1 1,90 1.30/10 1.25/8 1.20/5 1.40/5
2019-10-20 R. Oviedo 4-2 Girona 13/-4 2,73 0.91/11 1.13/8 0.80/5 1.00/6   13/1 2,27 1.45/11 1.50/8 2.17/6 0.60/5
2019-10-27 Girona 0-0 Alcorcon 15/-1 2,58 1.33/12 1.13/8 2.17/6 0.50/6   18/1 2,92 1.33/12 1.25/8 0.67/6 2.00/6
2019-11-03 Extremadura UD 1-3 Girona 13/-4 2,31 1.00/13 1.38/8 0.83/6 1.14/7   15/-1 2,38 1.31/13 1.25/8 2.00/7 0.50/6
2019-11-08 Girona 1-0 Tenerife 18/1 2,50 1.43/14 1.63/8 2.00/7 0.86/7   17/-2 2,57 1.00/14 0.75/8 0.86/7 1.14/7
2019-11-17 Ponferradina 1-1 Girona 22/5 2,60 1.47/15 1.50/8 1.88/8 1.00/7   19/2 2,40 1.53/15 1.63/8 2.13/8 0.86/7
2019-11-24 Girona 2-0 Fuenlabrada 20/2 2,38 1.50/16 1.75/8 2.13/8 0.88/8   22/6 2,38 1.75/16 1.75/8 1.88/8 1.63/8
2019-11-30 Zaragoza 3-3 Girona 22/4 2,35 1.53/17 1.25/8 1.56/9 1.50/8   22/4 2,35 1.59/17 1.75/8 2.22/9 0.88/8
2019-12-08 Girona 3-1 Lugo 25/4 2,56 1.56/18 1.50/8 2.22/9 0.89/9   18/-5 2,28 1.17/18 1.50/8 1.30/10 1.00/8
2019-12-13 Numancia 2-0 Girona 20/1 2,05 1.37/19 1.50/8 1.80/10 0.89/9   28/6 2,63 1.63/19 1.88/8 2.30/10 0.89/9
2019-12-22 Girona 0-3 Mirandes 28/4 2,60 1.55/20 1.88/8 2.30/10 0.80/10   25/-4 2,70 1.40/20 1.75/8 1.82/11 0.89/9
2020-01-05 Rayo Vallecano 1-0 Girona 28/3 2,65 1.25/20 0.75/8 1.44/9 1.09/11   28/1 2,62 1.48/21 1.75/8 2.09/11 0.80/10
2020-01-16 Girona 3-1 Extremadura UD 28/0 2,55 1.41/22 1.38/8 2.09/11 0.73/11   18/-9 2,05 1.00/22 1.13/8 0.91/11 1.09/11
2020-01-19 Tenerife 1-0 Girona 27/-5 2,57 0.96/23 1.00/8 1.00/11 0.92/12   31/2 2,61 1.48/23 1.38/8 2.17/12 0.73/11
2020-01-26 Girona 1-1 R. Oviedo 31/1 2,54 1.42/24 1.25/8 2.17/12 0.67/12   28/-8 2,67 1.00/24 1.13/8 1.17/12 0.83/12
2020-02-02 Fuenlabrada 0-1 Girona 29/4 2,16 1.48/25 1.13/8 1.75/12 1.23/13   32/1 2,52 1.40/25 1.00/8 2.08/13 0.67/12
2020-02-08 Girona 1-0 Huesca 33/2 2,46 1.46/26 1.25/8 2.08/13 0.85/13   32/7 2,19 1.65/26 1.38/8 2.38/13 0.92/13
2020-02-14 Dep. La Coruna 2-2 Girona 25/-12 2,30 1.22/27 2.63/8 1.46/13 1.00/14   34/3 2,41 1.52/27 1.25/8 2.14/14 0.85/13
2020-02-22 Girona 2-0 Ponferradina 36/3 2,46 1.50/28 1.38/8 2.14/14 0.86/14   35/4 2,36 1.32/28 1.25/8 1.73/15 0.85/13
2020-03-01 Mirandes 1-1 Girona 39/-2 2,76 1.31/29 0.88/8 1.60/15 1.00/14   38/5 2,45 1.55/29 1.75/8 2.20/15 0.86/14
2020-03-07 Girona 1-1 Albacete 39/5 2,43 1.53/30 1.88/8 2.20/15 0.87/15   23/-12 2,00 1.17/29 0.88/8 1.13/15 1.21/14
2020-06-13 Las Palmas 0-0 Girona 34/-5 2,35 1.23/31 0.63/8 1.33/15 1.13/16   40/5 2,42 1.52/31 1.63/8 2.13/16 0.87/15
2020-06-16 Girona 0-0 Racing Santander 40/5 2,34 1.50/32 1.75/8 2.13/16 0.88/16   32/-10 2,31 0.88/32 1.00/8 0.94/16 0.81/16
2020-06-19 Elche 1-0 Girona 43/7 2,39 1.42/33 1.38/8 1.38/16 1.47/17   40/5 2,27 1.48/33 1.75/8 2.06/17 0.88/16
2020-06-24 Girona 2-0 Numancia 40/4 2,24 1.44/34 1.38/8 2.06/17 0.82/17   37/-4 2,29 1.12/34 0.13/8 1.53/17 0.71/17
2020-06-28 Malaga 2-0 Girona 29/-2 1,71 1.17/35 1.25/8 1.35/17 1.00/18   42/6 2,23 1.49/35 1.38/8 2.11/18 0.82/17
2020-07-03 Girona 1-0 Zaragoza 42/4 2,22 1.44/36 1.25/8 2.11/18 0.78/18   51/13 2,47 1.69/36 1.63/8 1.56/18 1.83/18
2020-07-06 Gijon 0-0 Girona 37/4 1,89 1.32/37 1.38/8 1.72/18 0.95/19   43/5 2,19 1.49/37 1.25/8 2.16/19 0.78/18
2020-07-09 Girona 1-0 Almeria 43/5 2,13 1.47/38 1.25/8 2.16/19 0.79/19   58/20 2,53 1.58/38 1.63/8 1.58/19 1.58/19
2020-07-12 Lugo 2-2 Girona 37/-13 2,23 1.15/39 1.38/8 1.32/19 1.00/20   44/6 2,10 1.51/39 1.50/8 2.20/20 0.79/19
2020-07-17 Girona 2-1 Cadiz CF 46/6 2,15 1.50/40 1.50/8 2.20/20 0.80/20   49/13 2,13 1.73/40 1.50/8 1.80/20 1.65/20
2020-07-20 Alcorcon 2-0 Girona 50/0 2,44 1.32/41 1.25/8 1.05/20 1.57/21   48/7 2,17 1.54/41 1.75/8 2.24/21 0.80/20