SELECT * FROM 1_Kampe WHERE LigaID = '127' AND (Home='Granada CF' OR Away='Granada CF') 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-17 Villarreal 4-4 Granada CF 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 Granada CF 0-1 Sevilla 4/0 8,00 1.00/1 1.00/1 0.00/0 1.00/1   2/2 2,00 3.00/1 3.00/1 0.00/0 3.00/1
2019-09-01 Espanyol 0-3 Granada CF 0/-2 1,00 0.50/2 0.50/2 0.00/1 1.00/1   4/-1 4,50 0.50/2 0.50/2 0.00/1 1.00/1
2019-09-15 Celta Vigo 0-2 Granada CF 3/-1 2,33 1.33/3 1.33/3 1.50/2 1.00/1   7/2 4,00 1.33/3 1.33/3 0.00/1 2.00/2
2019-09-21 Granada CF 2-0 Barcelona 9/4 3,50 1.75/4 1.75/4 0.00/1 2.33/3   12/5 4,75 1.75/4 1.75/4 3.00/2 0.50/2
2019-09-24 Valladolid 1-1 Granada CF 4/-3 2,20 1.00/5 1.00/5 1.00/1 1.00/4   11/6 3,20 2.00/5 2.00/5 1.50/2 2.33/3
2019-09-28 Granada CF 1-0 Leganes 12/6 3,00 1.83/6 1.83/6 1.50/2 2.00/4   3/-6 2,00 0.33/6 0.33/6 0.25/4 0.50/2
2019-10-05 Real Madrid 4-2 Granada CF 12/6 2,57 2.14/7 2.14/7 2.33/3 2.00/4   13/7 2,71 2.00/7 2.00/7 2.00/3 2.00/4
2019-10-18 Granada CF 1-0 Osasuna 15/5 3,13 1.75/8 1.75/8 2.00/3 1.60/5   7/0 1,75 1.38/8 1.38/8 1.50/4 1.25/4
2019-10-27 Granada CF 1-0 Betis 16/6 2,89 1.89/9 2.00/8 2.25/4 1.60/5   12/-7 3,44 1.00/9 1.13/8 1.60/5 0.25/4
2019-10-31 Getafe 3-1 Granada CF 14/0 2,80 1.30/10 1.50/8 1.60/5 1.00/5   17/7 2,70 2.00/10 2.38/8 2.40/5 1.60/5
2019-11-03 Granada CF 1-2 Real Sociedad 18/5 2,82 1.82/11 2.00/8 2.40/5 1.33/6   18/6 2,73 1.73/11 1.88/8 1.80/5 1.67/6
2019-11-09 Valencia 2-0 Granada CF 17/-1 2,92 1.42/12 1.63/8 1.67/6 1.17/6   19/4 2,83 1.67/12 1.63/8 2.00/6 1.33/6
2019-11-23 Granada CF 1-1 Atl. Madrid 19/2 2,77 1.54/13 1.25/8 2.00/6 1.14/7   15/7 1,77 1.85/13 1.75/8 2.14/7 1.50/6
2019-12-01 Ath Bilbao 2-0 Granada CF 15/6 1,71 1.64/14 1.38/8 2.29/7 1.00/7   20/2 2,71 1.50/14 1.25/8 1.86/7 1.14/7
2019-12-07 Granada CF 3-0 Alaves 20/0 2,67 1.40/15 0.88/8 1.86/7 1.00/8   17/-3 2,47 1.20/15 1.25/8 1.75/8 0.57/7
2019-12-14 Granada CF 1-2 Levante 23/3 2,69 1.50/16 1.25/8 2.00/8 1.00/8   20/-5 2,81 1.25/16 1.13/8 1.75/8 0.75/8
2019-12-20 Eibar 3-0 Granada CF 15/-13 2,53 0.94/17 0.88/8 1.13/8 0.78/9   24/2 2,71 1.41/17 0.88/8 1.78/9 1.00/8
2020-01-05 Granada CF 1-0 Mallorca 24/-1 2,72 1.33/18 0.50/8 1.78/9 0.89/9   18/-14 2,78 0.83/18 0.63/8 1.40/10 0.13/8
2020-01-19 Barcelona 1-0 Granada CF 49/26 3,79 2.11/19 2.25/8 2.78/9 1.50/10   25/0 2,63 1.42/19 0.88/8 1.90/10 0.89/9
2020-01-25 Sevilla 2-0 Granada CF 25/5 2,25 1.75/20 1.75/8 1.67/9 1.82/11   25/-1 2,55 1.35/20 0.88/8 1.90/10 0.80/10
2020-02-01 Granada CF 2-1 Espanyol 25/-3 2,52 1.29/21 0.88/8 1.90/10 0.73/11   17/-21 2,62 0.71/21 0.88/8 0.36/11 1.10/10
2020-02-08 Atl. Madrid 1-0 Granada CF 22/7 1,68 1.64/22 1.38/8 2.00/11 1.27/11   27/-2 2,55 1.36/22 1.13/8 2.00/11 0.73/11
2020-02-15 Granada CF 2-1 Valladolid 27/-3 2,48 1.30/23 1.13/8 2.00/11 0.67/12   19/-6 1,91 1.13/23 1.00/8 1.18/11 1.08/12
2020-02-23 Osasuna 0-3 Granada CF 31/-1 2,63 1.29/24 1.00/8 1.42/12 1.17/12   29/-2 2,50 1.38/24 1.13/8 2.08/12 0.67/12
2020-02-29 Granada CF 0-0 Celta Vigo 32/1 2,52 1.44/25 1.50/8 2.08/12 0.85/13   22/-12 2,24 0.96/25 1.25/8 1.31/13 0.58/12
2020-03-08 Levante 1-1 Granada CF 31/-8 2,69 1.23/26 0.75/8 1.92/12 0.64/14   32/1 2,42 1.42/26 1.63/8 2.00/13 0.85/13
2020-06-12 Granada CF 2-1 Getafe 33/1 2,41 1.41/27 1.38/8 2.00/13 0.86/14   37/12 2,30 1.70/27 2.00/8 1.79/14 1.62/13
2020-06-15 Betis 2-2 Granada CF 38/-7 2,96 1.18/28 0.75/8 1.71/14 0.64/14   35/2 2,43 1.46/28 1.75/8 2.07/14 0.86/14
2020-06-19 Granada CF 0-1 Villarreal 37/2 2,48 1.45/29 1.88/8 2.07/14 0.87/15   46/8 2,90 1.52/29 1.63/8 1.79/14 1.27/15
2020-06-22 Leganes 0-0 Granada CF 23/-21 2,23 0.80/30 0.75/8 1.00/15 0.60/15   37/1 2,43 1.40/30 1.50/8 1.93/15 0.87/15
2020-06-28 Granada CF 1-2 Eibar 37/1 2,35 1.39/31 1.63/8 1.93/15 0.88/16   32/-15 2,55 1.03/31 1.00/8 1.44/16 0.60/15
2020-07-01 Alaves 0-2 Granada CF 32/-16 2,50 1.09/32 1.00/8 1.63/16 0.56/16   38/0 2,38 1.34/32 1.25/8 1.81/16 0.88/16
2020-07-04 Granada CF 2-2 Valencia 40/2 2,36 1.39/33 1.25/8 1.81/16 1.00/17   41/-7 2,70 1.39/33 1.00/8 2.00/17 0.75/16
2020-07-10 Real Sociedad 2-3 Granada CF 51/8 2,76 1.50/34 1.00/8 1.76/17 1.24/17   42/2 2,41 1.38/34 1.25/8 1.76/17 1.00/17
2020-07-13 Granada CF 1-2 Real Madrid 45/3 2,49 1.43/35 1.50/8 1.76/17 1.11/18   64/43 2,43 2.29/35 3.00/8 2.56/18 2.00/17
2020-07-16 Mallorca 1-2 Granada CF 37/-24 2,72 0.89/36 0.88/8 1.50/18 0.28/18   46/2 2,50 1.39/36 1.13/8 1.67/18 1.11/18
2020-07-19 Granada CF 4-0 Ath Bilbao 48/3 2,51 1.43/37 1.38/8 1.67/18 1.21/19   41/7 2,03 1.38/37 1.50/8 1.63/19 1.11/18