SELECT * FROM 1_Kampe WHERE LigaID = '130' 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
2016-08-20 Granada CF 1-1 Villarreal 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-28 Las Palmas 5-1 Granada CF 4/2 6,00 3.00/1 3.00/1 0.00/0 3.00/1   1/0 2,00 1.00/1 1.00/1 1.00/1 0.00/0
2016-09-11 Granada CF 1-2 Eibar 2/-4 4,00 0.50/2 0.50/2 1.00/1 0.00/1   2/0 2,00 1.50/2 1.50/2 3.00/1 0.00/1
2016-09-16 Betis 2-2 Granada CF 5/-3 4,33 1.33/3 1.33/3 1.00/1 1.50/2   3/-5 3,67 0.33/3 0.33/3 0.50/2 0.00/1
2016-09-21 Granada CF 1-2 Ath Bilbao 5/-5 3,75 0.50/4 0.50/4 0.50/2 0.50/2   4/0 2,00 1.50/4 1.50/4 1.50/2 1.50/2
2016-09-26 Alaves 3-1 Granada CF 4/0 1,60 1.20/5 1.20/5 1.00/2 1.33/3   6/-6 3,60 0.40/5 0.40/5 0.33/3 0.50/2
2016-10-01 Granada CF 0-1 Leganes 7/-8 3,67 0.33/6 0.33/6 0.33/3 0.33/3   6/-4 2,67 1.17/6 1.17/6 0.33/3 2.00/3
2016-10-15 Atl. Madrid 7-1 Granada CF 14/12 2,29 2.14/7 2.14/7 2.33/3 2.00/4   7/-9 3,29 0.29/7 0.29/7 0.25/4 0.33/3
2016-10-22 Granada CF 0-0 Gijon 8/-15 3,88 0.25/8 0.25/8 0.25/4 0.25/4   7/-11 3,13 0.88/8 0.88/8 1.50/4 0.25/4
2016-10-29 Barcelona 1-0 Granada CF 29/17 4,56 2.11/9 2.00/8 1.75/4 2.40/5   8/-15 3,44 0.33/9 0.25/8 0.40/5 0.25/4
2016-11-05 Granada CF 1-1 Dep. La Coruna 8/-16 3,20 0.30/10 0.25/8 0.40/5 0.20/5   7/-8 2,20 0.90/10 0.63/8 1.40/5 0.40/5
2016-11-20 Valencia 1-1 Granada CF 15/-6 3,27 0.91/11 1.25/8 0.60/5 1.17/6   9/-16 3,09 0.36/11 0.38/8 0.50/6 0.20/5
2016-11-27 Celta Vigo 3-1 Granada CF 18/-4 3,33 1.42/12 2.00/8 2.00/6 0.83/6   10/-16 3,00 0.42/12 0.38/8 0.50/6 0.33/6
2016-12-03 Granada CF 2-1 Sevilla 11/-18 3,08 0.38/13 0.38/8 0.50/6 0.29/7   24/6 3,23 2.08/13 2.00/8 2.57/7 1.50/6
2016-12-09 Malaga 1-1 Granada CF 23/2 3,14 1.43/14 1.88/8 2.29/7 0.57/7   13/-17 3,07 0.57/14 0.75/8 0.86/7 0.29/7
2016-12-17 Granada CF 0-2 Real Sociedad 14/-17 3,00 0.60/15 0.88/8 0.86/7 0.38/8   26/5 3,13 1.73/15 2.00/8 2.13/8 1.29/7
2017-01-07 Real Madrid 5-0 Granada CF 40/26 3,60 2.47/15 2.75/8 2.50/8 2.43/7   14/-19 2,94 0.56/16 0.88/8 0.75/8 0.38/8
2017-01-15 Granada CF 1-1 Osasuna 14/-24 3,06 0.53/17 0.75/8 0.75/8 0.33/9   16/-21 3,12 0.47/17 0.25/8 0.33/9 0.63/8
2017-01-21 Espanyol 3-1 Granada CF 22/-3 2,61 1.28/18 1.50/8 1.22/9 1.33/9   15/-24 3,00 0.56/18 0.88/8 0.78/9 0.33/9
2017-01-28 Villarreal 2-0 Granada CF 26/12 2,11 1.63/19 1.13/8 2.00/10 1.22/9   16/-26 3,05 0.53/19 0.75/8 0.78/9 0.30/10
2017-02-06 Granada CF 1-0 Las Palmas 16/-28 3,00 0.50/20 0.63/8 0.78/9 0.27/11   31/0 3,10 1.40/20 1.50/8 2.09/11 0.56/9
2017-02-13 Eibar 4-0 Granada CF 32/3 2,90 1.52/21 1.38/8 1.82/11 1.20/10   17/-27 2,90 0.62/21 1.00/8 1.00/10 0.27/11
2017-02-17 Granada CF 4-1 Betis 17/-31 2,95 0.59/22 0.63/8 1.00/10 0.25/12   21/-10 2,48 1.14/21 1.25/8 1.50/12 0.67/9
2017-02-26 Ath Bilbao 3-1 Granada CF 28/0 2,43 1.52/23 1.50/8 2.25/12 0.73/11   21/-28 3,04 0.70/23 0.88/8 1.18/11 0.25/12
2017-03-01 Granada CF 2-1 Alaves 22/-30 3,08 0.67/24 0.88/8 1.18/11 0.23/13   24/-5 2,21 1.38/24 1.50/8 1.25/12 1.50/12
2017-03-04 Leganes 1-0 Granada CF 20/-20 2,40 0.84/25 0.63/8 0.83/12 0.85/13   24/-29 3,08 0.76/25 1.25/8 1.33/12 0.23/13
2017-03-11 Granada CF 0-1 Atl. Madrid 24/-30 3,00 0.73/26 1.13/8 1.33/12 0.21/14   48/26 2,69 1.88/26 1.88/8 2.23/13 1.54/13
2017-03-19 Gijon 3-1 Granada CF 28/-28 3,11 0.67/27 0.63/8 0.85/13 0.50/14   24/-31 2,93 0.70/27 1.13/8 1.23/13 0.21/14
2017-04-02 Granada CF 1-4 Barcelona 25/-33 2,96 0.68/28 1.13/8 1.23/13 0.20/15   81/56 3,79 2.25/28 2.63/8 2.36/14 2.14/14
2017-04-05 Dep. La Coruna 0-0 Granada CF 31/-15 2,66 0.93/29 1.00/8 1.36/14 0.53/15   26/-36 3,03 0.66/29 0.75/8 1.14/14 0.20/15
2017-04-09 Granada CF 1-3 Valencia 26/-36 2,93 0.67/30 0.88/8 1.14/14 0.25/16   44/-9 3,23 1.20/30 1.63/8 1.60/15 0.80/15
2017-04-16 Granada CF 0-3 Celta Vigo 27/-38 2,97 0.65/31 0.50/8 1.07/15 0.25/16   45/-6 3,20 1.37/30 1.00/8 1.87/15 0.87/15
2017-04-21 Sevilla 2-0 Granada CF 56/17 2,97 1.94/32 1.25/8 2.40/15 1.53/17   27/-41 2,97 0.63/32 0.50/8 1.00/16 0.25/16
2017-04-25 Granada CF 0-2 Malaga 27/-43 2,94 0.61/33 0.13/8 1.00/16 0.24/17   38/-11 2,64 1.09/33 1.25/8 1.63/16 0.59/17
2017-04-29 Real Sociedad 2-1 Granada CF 52/5 2,91 1.71/34 1.25/8 1.82/17 1.59/17   27/-45 2,91 0.59/34 0.13/8 0.94/17 0.24/17
2017-05-06 Granada CF 0-4 Real Madrid 28/-46 2,91 0.57/35 0.13/8 0.94/17 0.22/18   92/53 3,85 2.38/34 2.38/8 2.39/18 2.38/16
2017-05-13 Osasuna 2-1 Granada CF 38/-50 3,50 0.53/36 1.00/8 0.56/18 0.50/18   28/-50 2,94 0.56/36 0.13/8 0.89/18 0.22/18
2017-05-19 Granada CF 1-2 Espanyol 29/-51 2,95 0.54/37 0.13/8 0.89/18 0.21/19   47/-2 2,59 1.43/37 1.25/8 1.53/19 1.33/18