SELECT * FROM 1_Kampe WHERE LigaID = '130' AND (Home='Real Madrid' OR Away='Real Madrid') 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-21 Real Sociedad 0-3 Real Madrid 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-27 Real Madrid 2-1 Celta Vigo 3/3 3,00 3.00/1 3.00/1 0.00/0 3.00/1   0/-1 1,00 0.00/1 0.00/1 0.00/1 0.00/0
2016-09-10 Real Madrid 5-2 Osasuna 5/4 3,00 3.00/2 3.00/2 3.00/1 3.00/1   1/-2 2,00 0.50/2 0.50/2 0.00/1 1.00/1
2016-09-18 Espanyol 0-2 Real Madrid 7/-2 5,33 0.67/3 0.67/3 1.00/1 0.50/2   10/7 4,33 3.00/3 3.00/3 3.00/2 3.00/1
2016-09-21 Real Madrid 1-1 Villarreal 12/9 3,75 3.00/4 3.00/4 3.00/2 3.00/2   5/3 1,75 2.00/4 2.00/4 2.00/2 2.00/2
2016-09-24 Las Palmas 2-2 Real Madrid 12/3 4,20 1.80/5 1.80/5 3.00/2 1.00/3   13/9 3,40 2.60/5 2.60/5 2.33/3 3.00/2
2016-10-02 Real Madrid 1-1 Eibar 15/9 3,50 2.33/6 2.33/6 2.33/3 2.33/3   8/2 2,33 1.67/6 1.67/6 2.33/3 1.00/3
2016-10-15 Betis 1-6 Real Madrid 8/-4 2,86 1.14/7 1.14/7 1.67/3 0.75/4   16/9 3,29 2.14/7 2.14/7 2.00/4 2.33/3
2016-10-23 Real Madrid 2-1 Ath Bilbao 22/14 3,75 2.25/8 2.25/8 2.00/4 2.50/4   13/3 2,88 1.88/8 1.88/8 2.25/4 1.50/4
2016-10-29 Alaves 1-4 Real Madrid 9/-2 2,22 1.11/9 1.13/8 1.50/4 0.80/5   24/15 3,67 2.33/9 2.25/8 2.20/5 2.50/4
2016-11-06 Real Madrid 3-0 Leganes 28/18 3,80 2.40/10 2.25/8 2.20/5 2.60/5   9/-10 2,80 1.00/10 0.75/8 0.20/5 1.80/5
2016-11-19 Atl. Madrid 0-3 Real Madrid 25/17 3,00 1.91/11 2.00/8 2.60/5 1.33/6   31/21 3,73 2.45/11 2.25/8 2.33/6 2.60/5
2016-11-26 Real Madrid 2-1 Gijon 34/24 3,67 2.50/12 2.25/8 2.33/6 2.67/6   11/-14 3,00 0.75/12 0.25/8 1.17/6 0.33/6
2016-12-03 Barcelona 1-1 Real Madrid 33/19 3,62 2.08/13 2.13/8 1.83/6 2.29/7   36/25 3,62 2.54/13 2.50/8 2.43/7 2.67/6
2016-12-10 Real Madrid 3-2 Dep. La Coruna 37/25 3,50 2.43/14 2.50/8 2.43/7 2.43/7   18/-6 3,00 0.93/14 1.00/8 1.43/7 0.43/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 Sevilla 2-1 Real Madrid 36/15 3,35 2.12/17 2.00/8 2.63/8 1.67/9   45/31 3,69 2.50/16 2.75/8 2.56/9 2.43/7
2017-01-21 Real Madrid 2-1 Malaga 46/30 3,65 2.35/17 2.38/8 2.56/9 2.13/8   26/-5 3,17 1.17/18 1.13/8 1.89/9 0.44/9
2017-01-29 Real Madrid 3-0 Real Sociedad 48/31 3,61 2.39/18 2.38/8 2.60/10 2.13/8   31/6 2,95 1.84/19 2.00/8 2.00/10 1.67/9
2017-02-11 Osasuna 1-3 Real Madrid 23/-23 3,29 0.48/21 0.38/8 0.36/11 0.60/10   51/34 3,58 2.42/19 2.38/8 2.64/11 2.13/8
2017-02-18 Real Madrid 2-0 Espanyol 54/36 3,60 2.45/20 2.38/8 2.64/11 2.22/9   30/1 2,68 1.45/22 1.63/8 1.42/12 1.50/10
2017-02-22 Valencia 2-1 Real Madrid 31/-9 3,23 1.05/22 1.38/8 1.10/10 1.00/12   56/38 3,52 2.48/21 2.38/8 2.67/12 2.22/9
2017-02-26 Villarreal 2-3 Real Madrid 30/15 1,96 1.70/23 1.63/8 2.00/12 1.36/11   57/37 3,50 2.36/22 2.25/8 2.67/12 2.00/10
2017-03-01 Real Madrid 3-3 Las Palmas 60/38 3,57 2.39/23 2.25/8 2.67/12 2.09/11   32/-4 2,83 1.17/24 0.88/8 1.77/13 0.45/11
2017-03-04 Eibar 1-4 Real Madrid 41/8 2,96 1.56/25 2.00/8 2.00/13 1.08/12   63/38 3,67 2.33/24 2.00/8 2.54/13 2.09/11
2017-03-12 Real Madrid 2-1 Betis 67/41 3,72 2.36/25 2.38/8 2.54/13 2.17/12   28/-14 2,69 1.08/26 0.88/8 1.29/14 0.83/12
2017-03-18 Ath Bilbao 1-2 Real Madrid 34/4 2,37 1.63/27 1.88/8 2.36/14 0.85/13   69/42 3,69 2.38/26 2.38/8 2.57/14 2.17/12
2017-04-02 Real Madrid 3-0 Alaves 71/43 3,67 2.41/27 2.38/8 2.57/14 2.23/13   29/-4 2,21 1.43/28 2.00/8 1.36/14 1.50/14
2017-04-05 Leganes 2-4 Real Madrid 23/-19 2,24 0.93/29 1.13/8 1.00/14 0.87/15   74/46 3,64 2.43/28 2.38/8 2.60/15 2.23/13
2017-04-08 Real Madrid 1-1 Atl. Madrid 78/48 3,72 2.45/29 2.38/8 2.60/15 2.29/14   55/32 2,60 2.03/30 2.38/8 2.33/15 1.73/15
2017-04-15 Gijon 2-3 Real Madrid 32/-29 3,00 0.71/31 0.75/8 0.93/15 0.50/16   79/48 3,67 2.40/30 2.50/8 2.50/16 2.29/14
2017-04-23 Real Madrid 2-3 Barcelona 82/49 3,71 2.42/31 2.50/8 2.50/16 2.33/15   91/61 3,78 2.25/32 2.25/8 2.44/16 2.06/16
2017-04-26 Dep. La Coruna 2-6 Real Madrid 35/-16 2,61 0.94/33 1.00/8 1.44/16 0.47/17   84/48 3,75 2.34/32 2.38/8 2.35/17 2.33/15
2017-04-29 Real Madrid 2-1 Valencia 90/52 3,88 2.36/33 2.38/8 2.35/17 2.38/16   49/-10 3,18 1.18/34 1.38/8 1.47/17 0.88/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-14 Real Madrid 4-1 Sevilla 96/57 3,86 2.40/35 2.38/8 2.39/18 2.41/17   63/18 3,00 1.92/36 1.50/8 2.39/18 1.44/18
2017-05-17 Celta Vigo 1-4 Real Madrid 50/-13 3,14 1.22/36 0.38/8 1.65/17 0.84/19   100/60 3,89 2.42/36 2.38/8 2.42/19 2.41/17
2017-05-21 Malaga 0-2 Real Madrid 49/-4 2,76 1.24/37 2.38/8 1.78/18 0.74/19   104/63 3,92 2.43/37 2.38/8 2.42/19 2.44/18