SELECT * FROM 1_Kampe WHERE LigaID = '137' AND (Home='Mirandes' OR Away='Mirandes') 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-24 Mirandes 1-2 Cadiz CF 2/0 4,00 1.00/1 1.00/1 0.00/0 1.00/1   3/2 4,00 3.00/1 3.00/1 3.00/1 0.00/0
2019-08-31 Numancia 2-0 Mirandes 2/-2 3,00 0.00/2 0.00/2 0.00/1 0.00/1   3/-1 3,50 0.50/2 0.50/2 0.00/1 1.00/1
2019-09-08 Mirandes 2-1 R. Oviedo 3/-3 3,00 0.33/3 0.33/3 0.00/1 0.50/2   4/-2 3,33 0.33/3 0.33/3 1.00/1 0.00/2
2019-09-14 Mirandes 1-1 Malaga 5/-2 3,00 1.00/4 1.00/4 1.50/2 0.50/2   2/-1 1,25 1.00/4 1.00/4 0.50/2 1.50/2
2019-09-17 Racing Santander 4-0 Mirandes 4/-4 2,40 0.40/5 0.40/5 0.33/3 0.50/2   6/-2 2,80 1.00/5 1.00/5 1.33/3 0.50/2
2019-09-20 Mirandes 2-2 Alcorcon 6/-6 3,00 0.83/6 0.83/6 1.33/3 0.33/3   10/2 3,00 1.67/6 1.67/6 1.00/3 2.33/3
2019-09-29 Dep. La Coruna 1-1 Mirandes 9/-4 3,14 0.86/7 0.86/7 1.33/3 0.50/4   8/-6 3,14 0.86/7 0.86/7 1.25/4 0.33/3
2019-10-02 Mirandes 1-1 Lugo 9/-6 3,00 0.88/8 0.88/8 1.25/4 0.50/4   9/-3 2,63 1.00/8 1.00/8 1.00/5 1.00/3
2019-10-05 Ponferradina 2-0 Mirandes 12/0 2,67 1.11/9 1.25/8 1.60/5 0.50/4   10/-6 2,89 0.89/9 0.88/8 1.20/5 0.50/4
2019-10-13 Mirandes 2-1 Fuenlabrada 10/-8 2,80 0.80/10 0.88/8 1.20/5 0.40/5   12/4 2,22 1.89/9 1.75/8 2.00/4 1.80/5
2019-10-20 Zaragoza 1-2 Mirandes 16/6 2,36 1.73/11 1.50/8 1.83/6 1.60/5   12/-7 2,82 1.00/11 1.25/8 1.50/6 0.40/5
2019-10-26 Mirandes 0-0 Tenerife 14/-6 2,83 1.17/12 1.25/8 1.50/6 0.83/6   17/-2 3,00 1.00/12 1.00/8 0.83/6 1.17/6
2019-11-03 Elche 4-2 Mirandes 11/-2 1,85 1.23/13 1.13/8 1.00/6 1.43/7   14/-6 2,62 1.15/13 1.25/8 1.43/7 0.83/6
2019-11-09 Mirandes 2-0 Extremadura UD 16/-8 2,86 1.07/14 1.25/8 1.43/7 0.71/7   14/-6 2,43 0.93/14 1.25/8 0.71/7 1.14/7
2019-11-17 Mirandes 2-1 Las Palmas 18/-6 2,80 1.20/15 1.50/8 1.63/8 0.71/7   16/-3 2,33 1.27/15 1.63/8 1.38/8 1.14/7
2019-11-24 Albacete 1-2 Mirandes 11/-5 1,69 1.56/16 1.63/8 1.43/7 1.67/9   20/-5 2,81 1.31/16 1.75/8 1.78/9 0.71/7
2019-11-30 Mirandes 0-0 Gijon 22/-4 2,82 1.41/17 2.00/8 1.78/9 1.00/8   17/-2 2,12 1.06/17 0.88/8 1.33/9 0.75/8
2019-12-07 Almeria 3-1 Mirandes 28/12 2,44 1.78/18 1.75/8 2.13/8 1.50/10   22/-4 2,67 1.39/18 2.13/8 1.70/10 1.00/8
2019-12-14 Mirandes 2-0 Huesca 23/-6 2,74 1.32/19 1.75/8 1.70/10 0.89/9   23/8 2,00 1.68/19 1.63/8 2.20/10 1.11/9
2019-12-22 Girona 0-3 Mirandes 28/4 2,60 1.55/20 1.88/8 2.30/10 0.80/10   25/-4 2,70 1.40/20 1.75/8 1.82/11 0.89/9
2020-01-04 Mirandes 0-0 Racing Santander 28/-1 2,71 1.48/21 2.00/8 1.82/11 1.10/10   23/-5 2,43 0.86/21 0.88/8 1.09/11 0.60/10
2020-01-15 Cadiz CF 3-3 Mirandes 31/12 2,27 2.00/22 1.25/8 2.30/10 1.75/12   28/-1 2,59 1.45/22 2.13/8 1.75/12 1.10/10
2020-01-26 Malaga 2-2 Mirandes 19/-1 1,63 1.13/24 1.50/8 1.36/11 0.92/13   31/-1 2,74 1.43/23 1.88/8 1.75/12 1.09/11
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 Gijon 2-2 Mirandes 23/-4 1,92 1.19/26 1.50/8 1.62/13 0.77/13   33/-1 2,68 1.40/25 1.38/8 1.69/13 1.08/12
2020-02-16 Mirandes 1-1 Albacete 35/-1 2,73 1.38/26 1.38/8 1.69/13 1.08/13   19/-13 1,96 1.12/26 0.38/8 1.00/13 1.23/13
2020-02-19 Mirandes 1-1 Zaragoza 36/-1 2,70 1.37/27 1.50/8 1.64/14 1.08/13   38/12 2,37 1.74/27 2.13/8 1.79/14 1.69/13
2020-02-23 Extremadura UD 3-2 Mirandes 24/-13 2,18 0.96/28 1.13/8 0.93/14 1.00/14   37/-1 2,68 1.36/28 1.25/8 1.60/15 1.08/13
2020-03-01 Mirandes 1-1 Girona 39/-2 2,76 1.31/29 0.88/8 1.60/15 1.00/14   38/5 2,45 1.55/29 1.75/8 2.20/15 0.86/14
2020-03-08 Alcorcon 1-2 Mirandes 37/2 2,40 1.37/30 1.63/8 1.07/15 1.67/15   40/-2 2,73 1.30/30 0.88/8 1.56/16 1.00/14
2020-06-14 Mirandes 2-1 Numancia 42/-1 2,74 1.35/31 1.13/8 1.56/16 1.13/15   35/0 2,26 1.23/31 0.63/8 1.63/16 0.80/15
2020-06-18 Huesca 1-2 Mirandes 42/9 2,34 1.66/32 1.63/8 2.38/16 0.94/16   44/0 2,75 1.41/32 1.38/8 1.65/17 1.13/15
2020-06-21 Mirandes 1-2 Ponferradina 46/1 2,76 1.45/33 1.63/8 1.65/17 1.25/16   38/3 2,21 1.33/33 1.50/8 1.88/17 0.75/16
2020-06-24 Tenerife 4-1 Mirandes 38/0 2,24 1.26/34 1.75/8 1.47/17 1.06/17   47/0 2,76 1.41/34 1.50/8 1.56/18 1.25/16
2020-06-28 Mirandes 2-2 Almeria 48/-3 2,83 1.37/35 1.38/8 1.56/18 1.18/17   54/20 2,51 1.60/35 1.25/8 1.59/17 1.61/18
2020-07-01 R. Oviedo 1-0 Mirandes 40/-6 2,39 1.14/36 1.50/8 1.28/18 1.00/18   50/-3 2,86 1.36/36 1.38/8 1.53/19 1.18/17
2020-07-04 Fuenlabrada 2-2 Mirandes 39/4 2,00 1.35/37 1.38/8 1.56/18 1.16/19   50/-4 2,81 1.32/37 1.38/8 1.53/19 1.11/18
2020-07-07 Mirandes 1-0 Elche 52/-4 2,84 1.32/38 1.38/8 1.53/19 1.11/19   47/8 2,26 1.45/38 1.50/8 1.37/19 1.53/19
2020-07-11 Las Palmas 1-0 Mirandes 41/-2 2,15 1.28/39 1.50/8 1.47/19 1.10/20   53/-3 2,79 1.36/39 1.38/8 1.60/20 1.11/19
2020-07-17 Mirandes 1-0 Dep. La Coruna 53/-4 2,75 1.33/40 1.00/8 1.60/20 1.05/20   41/-17 2,48 1.20/40 1.50/8 1.45/20 0.95/20
2020-07-20 Lugo 2-1 Mirandes 41/-12 2,29 1.20/41 1.50/8 1.30/20 1.10/21   54/-3 2,71 1.37/41 1.00/8 1.67/21 1.05/20