SELECT * FROM 1_Kampe WHERE LigaID = '137' AND (Home='Rayo Vallecano' OR Away='Rayo Vallecano') 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 Rayo Vallecano 2-2 Mirandes 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-25 Gijon 1-1 Rayo Vallecano 1/0 2,00 1.00/1 1.00/1 0.00/0 1.00/1   2/0 4,00 1.00/1 1.00/1 1.00/1 0.00/0
2019-09-01 Rayo Vallecano 3-1 Dep. La Coruna 3/0 3,00 1.00/2 1.00/2 1.00/1 1.00/1   4/-1 4,50 1.50/2 1.50/2 3.00/1 0.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-13 Rayo Vallecano 2-0 Racing Santander 7/0 3,50 1.25/4 1.25/4 2.00/2 0.50/2   4/-2 2,50 0.50/4 0.50/4 0.33/3 1.00/1
2019-09-17 Malaga 1-1 Rayo Vallecano 3/-1 1,40 1.00/5 1.00/5 0.50/2 1.33/3   9/2 3,20 1.60/5 1.60/5 2.33/3 0.50/2
2019-09-21 Rayo Vallecano 1-1 Almeria 10/2 3,00 1.50/6 1.50/6 2.33/3 0.67/3   12/10 2,33 2.67/6 2.67/6 3.00/3 2.33/3
2019-09-28 Fuenlabrada 2-2 Rayo Vallecano 8/3 2,17 2.17/6 2.17/6 2.00/2 2.25/4   11/2 2,86 1.43/7 1.43/7 2.00/4 0.67/3
2019-10-01 Rayo Vallecano 1-1 Alcorcon 13/2 3,00 1.38/8 1.38/8 2.00/4 0.75/4   12/0 3,00 1.38/8 1.38/8 0.75/4 2.00/4
2019-10-05 Elche 1-1 Rayo Vallecano 8/-1 1,89 1.33/9 1.50/8 1.25/4 1.40/5   14/2 2,89 1.33/9 1.38/8 1.80/5 0.75/4
2019-10-11 Rayo Vallecano 2-1 Tenerife 15/2 2,80 1.30/10 1.38/8 1.80/5 0.80/5   13/-1 2,70 1.10/10 1.00/8 0.80/5 1.40/5
2019-10-19 Extremadura UD 0-3 Rayo Vallecano 11/0 2,00 1.18/11 1.50/8 1.00/5 1.33/6   17/3 2,82 1.45/11 1.38/8 2.00/6 0.80/5
2019-10-26 Rayo Vallecano 1-3 Ponferradina 20/6 2,83 1.58/12 1.75/8 2.00/6 1.17/6   16/2 2,50 1.25/12 1.25/8 1.71/7 0.60/5
2019-11-03 Lugo 1-0 Rayo Vallecano 14/-6 2,62 1.00/13 0.88/8 1.14/7 0.83/6   21/4 2,92 1.46/13 1.38/8 1.71/7 1.17/6
2019-11-10 Rayo Vallecano 1-1 Cadiz CF 21/3 2,79 1.36/14 1.25/8 1.71/7 1.00/7   23/12 2,43 2.43/14 2.38/8 2.71/7 2.14/7
2019-11-16 Numancia 2-2 Rayo Vallecano 17/5 1,93 1.60/15 1.88/8 2.00/8 1.14/7   22/3 2,73 1.33/15 1.25/8 1.63/8 1.00/7
2019-11-23 Rayo Vallecano 0-1 Zaragoza 24/3 2,81 1.31/16 1.25/8 1.63/8 1.00/8   21/3 2,44 1.44/16 0.88/8 1.56/9 1.29/7
2019-12-01 R. Oviedo 2-1 Rayo Vallecano 20/-7 2,76 0.88/17 1.13/8 1.13/8 0.67/9   24/2 2,71 1.24/17 1.13/8 1.44/9 1.00/8
2019-12-07 Huesca 0-2 Rayo Vallecano 23/10 2,00 1.78/18 1.75/8 2.44/9 1.11/9   25/1 2,72 1.17/18 1.00/8 1.44/9 0.89/9
2019-12-21 Las Palmas 1-1 Rayo Vallecano 27/2 2,60 1.55/20 1.63/8 1.70/10 1.40/10   27/3 2,68 1.26/19 1.00/8 1.44/9 1.10/10
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-15 Rayo Vallecano 1-0 Lugo 29/4 2,57 1.33/21 1.13/8 1.60/10 1.09/11   21/-12 2,45 1.00/22 0.75/8 1.08/12 0.90/10
2020-01-18 Ponferradina 1-1 Rayo Vallecano 29/4 2,35 1.35/23 1.13/8 1.75/12 0.91/11   30/5 2,50 1.41/22 1.50/8 1.73/11 1.09/11
2020-01-26 Rayo Vallecano 1-1 Extremadura UD 31/5 2,48 1.39/23 1.50/8 1.73/11 1.08/12   20/-12 2,17 0.92/24 0.75/8 0.83/12 1.00/12
2020-02-02 Mirandes 0-0 Rayo Vallecano 33/-1 2,79 1.42/24 1.63/8 1.75/12 1.08/12   32/5 2,46 1.38/24 1.50/8 1.67/12 1.08/12
2020-02-09 Rayo Vallecano 1-1 R. Oviedo 32/5 2,36 1.36/25 1.63/8 1.67/12 1.08/13   32/-6 2,69 1.08/26 1.25/8 1.31/13 0.85/13
2020-02-16 Tenerife 0-0 Rayo Vallecano 34/-1 2,56 1.19/27 1.75/8 1.31/13 1.07/14   33/5 2,35 1.35/26 1.75/8 1.62/13 1.08/13
2020-02-23 Rayo Vallecano 2-0 Huesca 33/5 2,26 1.33/27 1.50/8 1.62/13 1.07/14   35/7 2,25 1.64/28 1.75/8 2.43/14 0.86/14
2020-02-29 Albacete 1-1 Rayo Vallecano 22/-12 2,00 1.18/28 0.75/8 1.14/14 1.21/14   35/7 2,25 1.39/28 1.75/8 1.71/14 1.07/14
2020-03-08 Rayo Vallecano 2-3 Elche 36/7 2,24 1.38/29 1.50/8 1.71/14 1.07/15   38/7 2,30 1.43/30 1.38/8 1.40/15 1.47/15
2020-06-10 Rayo Vallecano 0-0 Albacete 38/6 2,33 1.33/30 1.13/8 1.60/15 1.07/15   24/-12 2,00 1.17/30 0.88/8 1.13/15 1.20/15
2020-06-14 Cadiz CF 1-1 Rayo Vallecano 41/12 2,26 1.81/31 1.38/8 2.07/15 1.56/16   38/6 2,26 1.29/31 1.00/8 1.50/16 1.07/15
2020-06-17 Rayo Vallecano 1-0 Fuenlabrada 39/6 2,25 1.28/32 1.00/8 1.50/16 1.06/16   33/0 2,06 1.31/32 0.63/8 1.50/16 1.13/16
2020-06-20 Dep. La Coruna 3-3 Rayo Vallecano 30/-18 2,36 1.12/33 1.25/8 1.38/16 0.88/17   40/7 2,21 1.33/33 1.25/8 1.59/17 1.06/16
2020-06-25 Rayo Vallecano 1-1 Gijon 43/7 2,32 1.32/34 1.25/8 1.59/17 1.06/17   34/3 1,91 1.32/34 1.75/8 1.65/17 1.00/17
2020-06-29 Alcorcon 3-2 Rayo Vallecano 43/2 2,40 1.37/35 1.75/8 0.94/17 1.78/18   44/7 2,31 1.31/35 1.25/8 1.56/18 1.06/17
2020-07-02 Rayo Vallecano 0-0 Malaga 46/6 2,39 1.28/36 0.88/8 1.56/18 1.00/18   31/0 1,72 1.22/36 1.25/8 1.44/18 1.00/18
2020-07-06 Zaragoza 2-4 Rayo Vallecano 51/12 2,43 1.65/37 1.25/8 1.56/18 1.74/19   46/6 2,32 1.27/37 0.88/8 1.53/19 1.00/18
2020-07-09 Rayo Vallecano 3-2 Numancia 50/8 2,42 1.32/38 1.25/8 1.53/19 1.11/19   40/-6 2,26 1.16/38 0.75/8 1.68/19 0.63/19
2020-07-13 Almeria 3-2 Rayo Vallecano 58/19 2,49 1.54/39 1.25/8 1.58/19 1.50/20   53/9 2,49 1.36/39 1.63/8 1.60/20 1.11/19
2020-07-17 Rayo Vallecano 2-2 Las Palmas 55/8 2,55 1.33/40 1.50/8 1.60/20 1.05/20   42/-1 2,13 1.33/40 1.75/8 1.55/20 1.10/20
2020-07-20 Racing Santander 1-2 Rayo Vallecano 38/-16 2,24 0.80/41 0.50/8 0.90/20 0.71/21   57/8 2,59 1.32/41 1.25/8 1.57/21 1.05/20