SELECT * FROM 1_Kampe WHERE LigaID = '138' 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
2018-08-18 Elche 0-0 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
2018-08-26 Granada CF 1-1 Lugo 0/0 0,00 1.00/1 1.00/1 0.00/0 1.00/1   1/-1 3,00 0.00/1 0.00/1 0.00/1 0.00/0
2018-09-02 Granada CF 2-0 Osasuna 1/0 1,00 1.00/2 1.00/2 1.00/1 1.00/1   1/-1 1,50 0.50/2 0.50/2 1.00/1 0.00/1
2018-09-09 Extremadura UD 1-3 Granada CF 1/-3 1,67 0.33/3 0.33/3 0.00/1 0.50/2   3/2 1,33 1.67/3 1.67/3 2.00/2 1.00/1
2018-09-16 Granada CF 3-0 Rayo Majadahonda 6/4 2,00 2.00/4 2.00/4 2.00/2 2.00/2   3/0 1,50 1.50/4 1.50/4 1.50/2 1.50/2
2018-09-24 Dep. La Coruna 2-1 Granada CF 5/1 1,80 1.60/5 1.60/5 3.00/1 1.25/4   9/7 2,20 2.20/5 2.20/5 2.33/3 2.00/2
2018-09-29 Granada CF 4-2 Cordoba 10/6 2,33 1.83/6 1.83/6 2.33/3 1.33/3   6/-8 3,33 0.50/6 0.50/6 0.75/4 0.00/2
2018-10-07 Reus FCR 1-2 Granada CF 5/-2 1,71 1.14/7 1.14/7 0.67/3 1.50/4   14/8 2,86 2.00/7 2.00/7 2.50/4 1.33/3
2018-10-14 Granada CF 1-0 Mallorca 16/9 2,88 2.13/8 2.13/8 2.50/4 1.75/4   10/3 2,13 1.75/8 1.75/8 2.25/4 1.25/4
2018-10-20 Alcorcon 1-0 Granada CF 7/5 1,00 1.67/9 1.75/8 2.50/4 1.00/5   17/10 2,67 2.22/9 2.38/8 2.60/5 1.75/4
2018-10-21 Reus Deportiu 0-1 Granada CF 9/0 1,00 1.50/18 1.88/8 0.00/9 3.00/9   17/9 2,50 2.00/10 2.25/8 2.60/5 1.40/5
2018-10-21 Granada CF 0-1 Reus Deportiu 18/10 2,36 2.09/11 1.88/8 2.60/5 1.67/6   18/-1 1,00 1.46/37 1.88/8 0.00/19 3.00/18
2018-10-27 Granada CF 1-0 Almeria 18/9 2,25 1.92/12 1.88/8 2.17/6 1.67/6   13/3 1,92 1.42/12 2.00/8 1.67/6 1.17/6
2018-11-04 Zaragoza 0-2 Granada CF 13/-1 2,08 1.08/13 0.75/8 1.00/6 1.14/7   19/10 2,15 2.00/13 1.88/8 2.29/7 1.67/6
2018-11-11 Granada CF 0-0 Numancia 21/12 2,14 2.07/14 2.25/8 2.29/7 1.86/7   13/-3 2,07 1.36/14 1.63/8 1.86/7 0.86/7
2018-11-16 Las Palmas 2-2 Granada CF 18/7 1,93 1.60/15 1.25/8 1.88/8 1.29/7   21/12 2,00 2.00/15 2.00/8 2.13/8 1.86/7
2018-11-23 Granada CF 1-2 Gijon 23/12 2,13 1.94/16 1.75/8 2.13/8 1.75/8   14/0 1,75 1.13/16 0.88/8 1.63/8 0.63/8
2018-12-01 Malaga 0-1 Granada CF 20/8 1,88 1.88/17 1.25/8 2.63/8 1.22/9   24/11 2,18 1.82/17 1.38/8 1.89/9 1.75/8
2018-12-08 Gimnastic 0-1 Granada CF 11/-17 2,17 0.72/18 0.50/8 0.89/9 0.56/9   25/12 2,11 1.89/18 1.75/8 1.89/9 1.89/9
2018-12-15 Granada CF 1-0 R. Oviedo 26/13 2,05 1.95/19 1.75/8 1.89/9 2.00/10   21/-3 2,37 1.37/19 1.38/8 1.50/10 1.22/9
2018-12-21 Tenerife 1-1 Granada CF 16/-7 1,95 1.05/20 1.13/8 1.44/9 0.73/11   27/14 2,00 2.00/20 2.13/8 2.00/10 2.00/10
2019-01-04 Granada CF 1-1 Albacete 28/14 2,00 1.95/21 1.88/8 2.00/10 1.91/11   29/12 2,19 1.90/21 2.50/8 1.82/11 2.00/10
2019-01-11 Cadiz CF 0-0 Granada CF 29/11 2,14 1.59/22 2.25/8 1.91/11 1.27/11   29/14 2,00 1.91/22 1.63/8 1.91/11 1.91/11
2019-01-21 Granada CF 2-1 Elche 29/14 1,91 1.87/23 1.63/8 1.91/11 1.83/12   21/-6 2,09 1.17/23 1.13/8 1.42/12 0.91/11
2019-01-27 Granada CF 0-0 Extremadura UD 31/15 1,96 1.92/24 1.88/8 2.00/12 1.83/12   29/-4 2,58 1.00/24 1.13/8 0.83/12 1.17/12
2019-02-03 Osasuna 1-0 Granada CF 31/6 2,24 1.76/25 2.38/8 2.42/12 1.15/13   31/15 1,88 1.88/25 2.00/8 1.92/13 1.83/12
2019-02-10 Granada CF 0-1 Dep. La Coruna 31/14 1,85 1.81/26 1.63/8 1.92/13 1.69/13   36/17 2,12 1.77/26 1.50/8 2.15/13 1.38/13
2019-02-15 Cordoba 1-2 Granada CF 31/-15 2,85 0.89/27 1.00/8 1.15/13 0.64/14   31/13 1,81 1.74/27 1.25/8 1.79/14 1.69/13
2019-02-24 Granada CF 0-0 Reus FCR 33/14 1,86 1.79/28 1.25/8 1.79/14 1.79/14   16/-13 1,73 0.81/26 0.50/8 0.57/14 1.08/12
2019-03-03 Rayo Majadahonda 0-3 Granada CF 26/-10 2,14 1.14/29 1.25/8 1.36/14 0.93/15   33/14 1,79 1.72/29 1.13/8 1.67/15 1.79/14
2019-03-10 Granada CF 1-0 Zaragoza 36/17 1,83 1.77/30 1.38/8 1.67/15 1.87/15   31/-5 2,23 1.13/30 1.13/8 1.00/15 1.27/15
2019-03-17 Almeria 0-0 Granada CF 33/6 1,94 1.39/31 1.38/8 1.73/15 1.06/16   37/18 1,81 1.81/31 1.63/8 1.75/16 1.87/15
2019-03-24 Granada CF 1-1 Las Palmas 37/18 1,75 1.78/32 1.38/8 1.75/16 1.81/16   35/2 2,13 1.38/32 1.25/8 1.63/16 1.13/16
2019-03-30 Numancia 2-1 Granada CF 36/-5 2,33 1.18/33 1.13/8 1.50/16 0.88/17   38/18 1,76 1.76/33 1.38/8 1.71/17 1.81/16
2019-04-06 Granada CF 1-0 Malaga 39/17 1,79 1.71/34 1.38/8 1.71/17 1.71/17   34/10 1,71 1.71/34 1.38/8 1.82/17 1.59/17
2019-04-12 Gijon 1-0 Granada CF 37/7 1,91 1.49/35 2.00/8 1.65/17 1.33/18   40/18 1,77 1.74/35 1.75/8 1.78/18 1.71/17
2019-04-20 Lugo 1-2 Granada CF 35/-8 2,17 1.03/36 1.00/8 1.11/18 0.94/18   40/17 1,75 1.69/36 1.38/8 1.78/18 1.61/18
2019-04-28 Granada CF 2-0 Gimnastic 42/18 1,78 1.73/37 1.75/8 1.78/18 1.68/19   19/-30 1,84 0.76/37 0.88/8 1.06/18 0.47/19
2019-05-05 R. Oviedo 1-1 Granada CF 41/2 2,11 1.47/38 1.13/8 1.68/19 1.26/19   44/20 1,79 1.76/38 1.75/8 1.84/19 1.68/19
2019-05-10 Granada CF 2-1 Tenerife 45/20 1,79 1.74/39 1.50/8 1.84/19 1.65/20   36/-9 2,08 1.10/39 1.38/8 1.45/20 0.74/19
2019-05-20 Albacete 0-1 Granada CF 52/19 2,13 1.78/40 1.88/8 1.85/20 1.70/20   47/21 1,83 1.78/40 1.75/8 1.90/20 1.65/20
2019-05-26 Granada CF 1-1 Cadiz CF 48/22 1,80 1.80/41 2.00/8 1.90/20 1.71/21   52/18 2,10 1.54/41 1.38/8 1.76/21 1.30/20
2019-06-04 Mallorca 1-1 Granada CF 52/15 2,12 1.60/42 1.63/8 2.14/21 1.05/21   49/22 1,81 1.79/42 2.13/8 1.86/21 1.71/21
2019-06-08 Granada CF 2-1 Alcorcon 50/22 1,81 1.77/43 1.88/8 1.86/21 1.68/22   32/-8 1,67 1.14/43 0.63/8 1.50/22 0.76/21