SELECT * FROM 1_Kampe WHERE LigaID = '138' 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
2018-08-19 Mallorca 1-0 Osasuna 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
2018-08-27 Rayo Majadahonda 0-1 Mallorca 1/-1 3,00 0.00/1 0.00/1 0.00/0 0.00/1   1/1 1,00 3.00/1 3.00/1 3.00/1 0.00/0
2018-08-31 Alcorcon 1-0 Mallorca 1/-1 1,50 0.50/2 0.50/2 1.00/1 0.00/1   2/2 1,00 3.00/2 3.00/2 3.00/1 3.00/1
2018-09-07 Mallorca 1-0 Cadiz CF 2/1 1,00 2.00/3 2.00/3 3.00/1 1.50/2   3/1 1,67 1.67/3 1.67/3 2.00/2 1.00/1
2018-09-16 Elche 1-1 Mallorca 1/-3 1,25 0.50/4 0.50/4 0.50/2 0.50/2   3/2 1,00 2.25/4 2.25/4 3.00/2 1.50/2
2018-09-23 Mallorca 1-3 Albacete 4/2 1,20 2.00/5 2.00/5 3.00/2 1.33/3   8/4 2,40 1.80/5 1.80/5 1.67/3 2.00/2
2018-09-29 Lugo 1-1 Mallorca 7/-1 2,50 1.17/6 1.17/6 1.00/3 1.33/3   5/0 1,67 1.67/6 1.67/6 2.00/3 1.33/3
2018-10-06 Mallorca 4-1 Tenerife 6/0 1,71 1.57/7 1.57/7 2.00/3 1.25/4   6/-1 1,86 1.00/7 1.00/7 1.33/3 0.75/4
2018-10-14 Granada CF 1-0 Mallorca 16/9 2,88 2.13/8 2.13/8 2.50/4 1.75/4   10/3 2,13 1.75/8 1.75/8 2.25/4 1.25/4
2018-10-21 Mallorca 0-1 Reus Deportiu 10/2 2,00 1.56/9 1.38/8 2.25/4 1.00/5   14/-2 1,00 1.40/30 1.88/8 0.00/16 3.00/14
2018-10-21 Mallorca 1-1 Extremadura UD 10/1 1,90 1.40/10 1.13/8 1.80/5 1.00/5   12/-2 2,60 1.10/10 1.38/8 0.80/5 1.40/5
2018-10-21 Reus Deportiu 0-1 Mallorca 3/2 1,00 2.25/4 1.88/8 0.00/1 3.00/3   11/1 1,91 1.36/11 1.13/8 1.67/6 1.00/5
2018-10-27 Mallorca 2-2 Las Palmas 12/2 1,83 1.50/12 1.13/8 1.67/6 1.33/6   15/7 1,92 1.75/12 1.63/8 2.00/7 1.40/5
2018-11-04 R. Oviedo 1-1 Mallorca 14/-2 2,31 1.38/13 1.25/8 1.33/6 1.43/7   14/2 2,00 1.46/13 1.13/8 1.57/7 1.33/6
2018-11-11 Mallorca 3-0 Cordoba 15/2 2,00 1.43/14 1.25/8 1.57/7 1.29/7   16/-9 2,93 1.00/14 1.38/8 1.25/8 0.67/6
2018-11-17 Zaragoza 2-2 Mallorca 16/-1 2,20 1.13/15 1.00/8 0.86/7 1.38/8   18/5 2,07 1.53/15 1.50/8 1.75/8 1.29/7
2018-11-25 Mallorca 1-0 Numancia 20/5 2,19 1.50/16 1.25/8 1.75/8 1.25/8   14/-4 2,00 1.25/16 1.25/8 1.63/8 0.88/8
2018-12-01 Reus FCR 0-2 Mallorca 10/-12 2,13 0.87/15 0.63/8 0.86/7 0.88/8   21/6 2,12 1.59/17 1.63/8 1.89/9 1.25/8
2018-12-08 Mallorca 1-2 Malaga 23/8 2,11 1.67/18 1.88/8 1.89/9 1.44/9   20/7 1,83 1.78/18 1.25/8 2.33/9 1.22/9
2018-12-15 Gijon 1-0 Mallorca 18/2 1,79 1.32/19 1.25/8 1.78/9 0.90/10   24/7 2,16 1.58/19 1.88/8 1.70/10 1.44/9
2018-12-21 Mallorca 2-0 Gimnastic 24/6 2,10 1.50/20 1.50/8 1.70/10 1.30/10   12/-17 2,05 0.80/20 0.88/8 0.80/10 0.80/10
2019-01-06 Almeria 2-0 Mallorca 24/2 2,19 1.33/21 1.38/8 1.60/10 1.09/11   26/8 2,10 1.57/21 1.75/8 1.82/11 1.30/10
2019-01-12 Mallorca 1-0 Dep. La Coruna 26/6 2,09 1.50/22 1.63/8 1.82/11 1.18/11   32/15 2,23 1.77/22 1.63/8 2.18/11 1.36/11
2019-01-20 Osasuna 2-0 Mallorca 28/3 2,30 1.65/23 2.00/8 2.36/11 1.00/12   27/7 2,04 1.57/23 1.63/8 1.92/12 1.18/11
2019-01-26 Cadiz CF 1-1 Mallorca 29/11 1,96 1.54/24 1.75/8 1.83/12 1.25/12   27/5 2,04 1.50/24 1.50/8 1.92/12 1.08/12
2019-02-03 Mallorca 2-0 Alcorcon 28/5 2,04 1.48/25 1.25/8 1.92/12 1.08/13   22/4 1,60 1.52/25 0.63/8 2.08/13 0.92/12
2019-02-10 Albacete 2-0 Mallorca 35/13 2,19 1.85/26 1.88/8 1.85/13 1.85/13   30/7 2,04 1.54/26 1.25/8 2.00/13 1.08/13
2019-02-17 Mallorca 3-0 Lugo 30/5 2,04 1.48/27 1.25/8 2.00/13 1.00/14   25/-6 2,07 1.07/27 0.88/8 1.29/14 0.85/13
2019-02-22 Tenerife 2-2 Mallorca 21/-9 1,82 1.07/28 1.13/8 1.50/14 0.64/14   33/8 2,07 1.54/28 1.63/8 2.07/14 1.00/14
2019-03-03 Mallorca 1-1 Elche 35/8 2,14 1.52/29 1.38/8 2.07/14 1.00/15   28/-6 2,14 1.10/29 1.00/8 1.40/15 0.79/14
2019-03-09 Mallorca 1-0 R. Oviedo 36/8 2,13 1.50/30 1.50/8 2.00/15 1.00/15   33/1 2,17 1.57/30 2.13/8 1.73/15 1.40/15
2019-03-17 Las Palmas 1-2 Mallorca 34/3 2,10 1.42/31 1.63/8 1.73/15 1.13/16   37/9 2,10 1.55/31 1.50/8 2.06/16 1.00/15
2019-03-25 Mallorca 3-0 Zaragoza 39/10 2,13 1.59/32 1.88/8 2.06/16 1.13/16   32/-5 2,16 1.16/32 1.38/8 1.13/16 1.19/16
2019-03-31 Cordoba 3-2 Mallorca 36/-22 2,85 0.79/33 0.63/8 1.00/16 0.59/17   42/13 2,15 1.64/33 2.13/8 2.12/17 1.13/16
2019-04-07 Mallorca 0-0 Reus FCR 44/12 2,24 1.59/34 1.75/8 2.12/17 1.06/17   16/-13 1,41 0.66/32 0.00/8 0.47/17 0.87/15
2019-04-14 Numancia 1-1 Mallorca 38/-6 2,34 1.20/35 1.13/8 1.59/17 0.83/18   44/12 2,17 1.54/35 1.75/8 2.00/18 1.06/17
2019-04-20 Mallorca 2-0 Rayo Majadahonda 45/12 2,17 1.53/36 1.50/8 2.00/18 1.06/18   37/-10 2,33 1.19/36 1.63/8 1.39/18 1.00/18
2019-04-27 Malaga 0-1 Mallorca 39/11 1,81 1.65/37 1.13/8 1.72/18 1.58/19   47/14 2,16 1.57/37 1.75/8 2.05/19 1.06/18
2019-05-05 Mallorca 2-1 Gijon 48/15 2,13 1.61/38 2.00/8 2.05/19 1.16/19   39/8 1,84 1.50/38 2.25/8 1.68/19 1.32/19
2019-05-11 Gimnastic 2-1 Mallorca 19/-33 1,82 0.72/39 0.50/8 1.00/19 0.45/20   50/16 2,15 1.64/39 2.00/8 2.10/20 1.16/19
2019-05-19 Mallorca 1-0 Almeria 51/15 2,18 1.60/40 1.63/8 2.10/20 1.10/20   48/9 2,18 1.38/40 1.38/8 1.70/20 1.05/20
2019-05-27 Dep. La Coruna 1-0 Mallorca 47/14 1,95 1.49/41 1.00/8 1.60/20 1.38/21   52/16 2,15 1.63/41 1.63/8 2.14/21 1.10/20
2019-06-04 Mallorca 1-1 Granada CF 52/15 2,12 1.60/42 1.63/8 2.14/21 1.05/21   49/22 1,81 1.79/42 2.13/8 1.86/21 1.71/21
2019-06-08 Extremadura UD 0-0 Mallorca 43/-5 2,12 1.21/43 2.38/8 1.00/21 1.41/22   53/15 2,12 1.58/43 1.75/8 2.09/22 1.05/21