SELECT * FROM 1_Kampe WHERE LigaID = '127' AND (Home='Mallorca' OR Away='Mallorca') 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 Mallorca 2-1 Eibar 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 Mallorca 0-1 Real Sociedad 2/1 3,00 3.00/1 3.00/1 3.00/1 0.00/0   1/0 2,00 1.00/1 1.00/1 0.00/0 1.00/1
2019-09-01 Valencia 2-0 Mallorca 1/-1 1,50 0.50/2 0.50/2 1.00/1 0.00/1   2/0 2,00 1.50/2 1.50/2 1.50/2 0.00/0
2019-09-13 Mallorca 0-0 Ath Bilbao 2/-2 2,00 1.00/3 1.00/3 1.50/2 0.00/1   4/3 1,67 2.33/3 2.33/3 3.00/2 1.00/1
2019-09-22 Getafe 4-2 Mallorca 3/-1 1,75 0.75/4 0.75/4 1.00/2 0.50/2   2/-2 1,50 1.00/4 1.00/4 1.33/3 0.00/1
2019-09-25 Mallorca 0-2 Atl. Madrid 4/-4 2,40 0.80/5 0.80/5 1.33/3 0.00/2   5/1 1,80 2.00/5 2.00/5 2.33/3 1.50/2
2019-09-29 Alaves 2-0 Mallorca 2/-5 1,50 0.83/6 0.83/6 1.33/3 0.33/3   4/-6 2,33 0.67/6 0.67/6 1.00/4 0.00/2
2019-10-06 Mallorca 2-0 Espanyol 4/-8 2,29 0.57/7 0.57/7 1.00/4 0.00/3   4/-8 2,29 0.71/7 0.71/7 0.00/4 1.67/3
2019-10-19 Mallorca 1-0 Real Madrid 6/-6 2,25 0.88/8 0.88/8 1.40/5 0.00/3   16/8 3,00 2.25/8 2.25/8 2.50/4 2.00/4
2019-10-26 Leganes 1-0 Mallorca 4/-10 2,00 0.22/9 0.25/8 0.20/5 0.25/4   7/-5 2,11 1.11/9 0.88/8 1.67/6 0.00/3
2019-10-31 Mallorca 2-2 Osasuna 7/-6 2,00 1.00/10 0.88/8 1.67/6 0.00/4   10/1 1,90 1.40/10 1.25/8 1.80/5 1.00/5
2019-11-03 Valladolid 3-0 Mallorca 11/-3 2,27 1.27/11 1.25/8 1.50/4 1.14/7   9/-6 2,18 1.00/11 1.00/8 1.57/7 0.00/4
2019-11-10 Mallorca 3-1 Villarreal 9/-9 2,25 0.92/12 0.88/8 1.57/7 0.00/5   25/9 3,42 1.50/12 1.63/8 2.00/6 1.00/6
2019-11-22 Levante 2-1 Mallorca 16/0 2,46 1.31/13 1.25/8 1.83/6 0.86/7   12/-7 2,38 1.08/13 1.25/8 1.75/8 0.00/5
2019-11-30 Mallorca 1-2 Betis 13/-8 2,43 1.00/14 1.25/8 1.75/8 0.00/6   17/-7 2,93 1.14/14 1.00/8 1.75/8 0.33/6
2019-12-07 Barcelona 5-2 Mallorca 36/20 3,71 2.21/14 2.63/8 3.00/6 1.63/8   14/-9 2,47 0.93/15 1.25/8 1.56/9 0.00/6
2019-12-15 Celta Vigo 2-2 Mallorca 12/-11 2,19 0.81/16 0.50/8 1.00/8 0.63/8   16/-12 2,75 0.88/16 0.88/8 1.56/9 0.00/7
2019-12-21 Mallorca 0-2 Sevilla 18/-12 2,82 0.88/17 0.63/8 1.56/9 0.13/8   21/4 2,24 1.82/17 1.88/8 1.75/8 1.89/9
2020-01-05 Granada CF 1-0 Mallorca 24/-1 2,72 1.33/18 0.50/8 1.78/9 0.89/9   18/-14 2,78 0.83/18 0.63/8 1.40/10 0.13/8
2020-01-19 Mallorca 4-1 Valencia 18/-15 2,68 0.79/19 0.50/8 1.40/10 0.11/9   29/4 2,84 1.63/19 2.13/8 2.00/10 1.22/9
2020-01-26 Real Sociedad 3-0 Mallorca 33/5 3,05 1.55/20 1.13/8 1.56/9 1.55/11   22/-12 2,80 0.90/20 0.88/8 1.55/11 0.11/9
2020-02-01 Mallorca 0-1 Valladolid 22/-15 2,81 0.86/21 0.50/8 1.55/11 0.10/10   17/-7 1,95 1.05/21 0.63/8 1.20/10 0.91/11
2020-02-09 Espanyol 1-0 Mallorca 18/-22 2,64 0.68/22 0.75/8 0.36/11 1.00/11   22/-16 2,73 0.82/22 0.50/8 1.42/12 0.10/10
2020-02-15 Mallorca 1-0 Alaves 22/-17 2,65 0.78/23 0.50/8 1.42/12 0.09/11   25/-8 2,52 1.17/23 1.13/8 1.58/12 0.73/11
2020-02-21 Betis 3-3 Mallorca 32/-5 2,88 1.21/24 0.88/8 1.67/12 0.75/12   23/-16 2,58 0.88/24 0.88/8 1.54/13 0.09/11
2020-03-01 Mallorca 0-1 Getafe 26/-16 2,72 0.88/25 0.88/8 1.54/13 0.17/12   36/11 2,44 1.68/25 1.50/8 1.85/13 1.50/12
2020-03-07 Eibar 1-2 Mallorca 25/-12 2,48 1.08/25 1.38/8 1.58/12 0.62/13   26/-17 2,65 0.85/26 0.88/8 1.43/14 0.17/12
2020-06-13 Mallorca 0-4 Barcelona 28/-16 2,67 0.93/27 1.25/8 1.43/14 0.38/13   63/32 3,48 2.15/27 2.25/8 2.86/14 1.38/13
2020-06-16 Villarreal 1-0 Mallorca 45/7 2,96 1.46/28 1.63/8 1.69/13 1.27/15   28/-20 2,71 0.89/28 0.88/8 1.33/15 0.38/13
2020-06-19 Mallorca 1-1 Leganes 28/-21 2,66 0.86/29 0.88/8 1.33/15 0.36/14   22/-21 2,24 0.79/29 1.00/8 1.00/15 0.57/14
2020-06-24 Real Madrid 2-0 Mallorca 57/36 2,60 2.17/30 2.00/8 2.47/15 1.87/15   29/-21 2,63 0.87/30 1.00/8 1.31/16 0.36/14
2020-06-27 Ath Bilbao 3-1 Mallorca 33/6 1,94 1.35/31 1.38/8 1.87/15 0.88/16   29/-23 2,61 0.84/31 1.00/8 1.31/16 0.33/15
2020-06-30 Mallorca 5-1 Celta Vigo 30/-25 2,66 0.81/32 0.63/8 1.31/16 0.31/16   31/-6 2,13 1.06/32 1.63/8 1.31/16 0.81/16
2020-07-03 Atl. Madrid 3-0 Mallorca 43/18 2,06 1.79/33 2.00/8 2.19/16 1.41/17   35/-21 2,76 0.88/33 0.88/8 1.41/17 0.31/16
2020-07-09 Mallorca 2-0 Levante 35/-24 2,76 0.85/34 0.88/8 1.41/17 0.29/17   42/-5 2,62 1.26/34 1.38/8 1.71/17 0.82/17
2020-07-12 Sevilla 2-0 Mallorca 51/17 2,43 1.80/35 2.00/8 1.82/17 1.78/18   37/-22 2,74 0.91/35 0.88/8 1.50/18 0.29/17
2020-07-16 Mallorca 1-2 Granada CF 37/-24 2,72 0.89/36 0.88/8 1.50/18 0.28/18   46/2 2,50 1.39/36 1.13/8 1.67/18 1.11/18
2020-07-19 Osasuna 2-2 Mallorca 44/-8 2,59 1.38/37 2.00/8 1.50/18 1.26/19   38/-25 2,73 0.86/37 0.88/8 1.42/19 0.28/18