SELECT * FROM 1_Kampe WHERE LigaID = '137' AND (Home='Almeria' OR Away='Almeria') 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-10-21 Almeria 0-1 Albacete 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-10-21 Almeria 0-1 Extremadura UD 18/7 2,42 1.67/12 1.25/8 2.00/5 1.43/7   11/-3 2,08 1.08/12 1.38/8 0.83/6 1.33/6
2018-10-21 R. Oviedo 0-1 Almeria 18/-3 3,00 1.00/13 1.50/8 1.17/6 0.86/7   21/8 2,62 1.77/13 1.25/8 2.17/6 1.43/7
2018-10-21 Almeria 0-1 Zaragoza 21/8 2,43 1.71/14 1.00/8 2.17/6 1.38/8   20/4 2,57 1.57/14 1.00/8 1.75/8 1.33/6
2018-10-21 Elche 0-1 Almeria 18/2 2,27 1.47/15 1.63/8 1.29/7 1.63/8   22/8 2,40 1.67/15 1.00/8 2.00/7 1.38/8
2018-10-21 Almeria 0-1 Numancia 23/8 2,38 1.63/16 1.13/8 2.00/7 1.33/9   19/5 2,06 1.56/16 1.88/8 1.89/9 1.14/7
2018-10-21 Tenerife 0-1 Almeria 20/-1 2,41 1.06/17 0.88/8 0.88/8 1.22/9   25/10 2,35 1.71/17 1.50/8 2.13/8 1.33/9
2018-10-21 Almeria 0-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
2018-10-21 Fuenlabrada 0-1 Almeria 25/5 2,37 1.68/19 1.50/8 2.00/9 1.40/10   31/14 2,53 1.84/19 2.00/8 2.22/9 1.50/10
2018-10-21 Alcorcon 0-1 Almeria 16/1 2,82 1.36/11 1.13/8 0.60/5 2.00/6   16/7 2,27 1.73/11 1.50/8 2.00/5 1.50/6
2018-10-21 Almeria 0-1 Lugo 16/7 2,50 1.80/10 1.75/8 2.25/4 1.50/6   10/-5 2,50 0.90/10 0.88/8 0.83/6 1.00/4
2018-10-21 Dep. La Coruna 0-1 Almeria 11/-6 3,11 0.78/9 0.50/8 1.25/4 0.40/5   16/7 2,78 1.89/9 1.75/8 2.25/4 1.60/5
2018-10-21 Racing Santander 0-1 Almeria 0/-1 1,00 0.00/1 0.00/1 0.00/1 0.00/0   3/3 3,00 3.00/1 3.00/1 3.00/1 0.00/0
2018-10-21 Almeria 0-1 Huesca 4/3 2,50 2.00/2 2.00/2 3.00/1 1.00/1   4/3 2,50 3.00/2 3.00/2 3.00/1 3.00/1
2018-10-21 Malaga 0-1 Almeria 2/0 1,33 1.33/3 1.33/3 1.00/1 1.50/2   5/4 2,00 2.33/3 2.33/3 3.00/2 1.00/1
2018-10-21 Las Palmas 0-1 Almeria 3/-1 1,75 0.75/4 0.75/4 0.50/2 1.00/2   6/5 1,75 2.50/4 2.50/4 3.00/2 2.00/2
2018-10-21 Almeria 0-1 Girona 9/8 2,00 2.60/5 2.60/5 3.00/2 2.33/3   5/0 2,00 1.40/5 1.40/5 2.33/3 0.00/2
2018-10-21 Rayo Vallecano 0-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
2018-10-21 Almeria 0-1 Cadiz CF 13/10 2,29 2.43/7 2.43/7 3.00/3 2.00/4   11/4 2,57 2.29/7 2.29/7 2.50/4 2.00/3
2018-10-21 Gijon 0-1 Almeria 6/0 1,50 1.00/8 1.00/8 1.50/4 0.50/4   14/9 2,38 2.13/8 2.13/8 2.25/4 2.00/4
2018-10-21 Almeria 0-1 Ponferradina 33/14 2,60 1.80/20 2.00/8 2.22/9 1.45/11   26/4 2,40 1.35/20 1.50/8 1.82/11 0.78/9
2018-10-21 Lugo 0-1 Almeria 21/-8 2,38 1.05/21 1.13/8 1.18/11 0.90/10   35/13 2,71 1.71/21 1.63/8 2.00/10 1.45/11
2018-10-21 Zaragoza 0-1 Almeria 49/15 2,52 1.76/33 1.88/8 1.75/16 1.76/17   52/19 2,58 1.61/33 1.00/8 1.69/16 1.53/17
2018-10-21 Almeria 0-1 Alcorcon 54/21 2,56 1.65/34 1.25/8 1.69/16 1.61/18   42/1 2,44 1.32/34 1.38/8 0.94/17 1.71/17
2018-10-21 Mirandes 0-1 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
2018-10-21 Almeria 0-1 Gijon 56/20 2,56 1.58/36 1.38/8 1.59/17 1.58/19   37/5 1,92 1.36/36 1.75/8 1.72/18 1.00/18
2018-10-21 Almeria 0-1 Tenerife 57/21 2,51 1.62/37 1.63/8 1.67/18 1.58/19   45/5 2,30 1.35/37 1.75/8 1.53/19 1.17/18
2018-10-21 Girona 0-1 Almeria 43/5 2,13 1.47/38 1.25/8 2.16/19 0.79/19   58/20 2,53 1.58/38 1.63/8 1.58/19 1.58/19
2018-10-21 Almeria 0-1 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
2018-10-21 Ponferradina 0-1 Almeria 42/-5 2,23 1.20/40 0.88/8 1.65/20 0.75/20   61/20 2,55 1.58/40 1.25/8 1.65/20 1.50/20
2018-10-21 Almeria 0-1 Las Palmas 52/20 2,63 1.66/32 1.00/8 1.80/15 1.53/17   34/-5 2,28 1.22/32 0.63/8 1.31/16 1.13/16
2018-10-21 Albacete 0-1 Almeria 24/-12 1,94 1.13/31 0.88/8 1.13/15 1.13/16   51/19 2,68 1.61/31 1.00/8 1.80/15 1.44/16
2018-10-21 Almeria 0-1 Dep. La Coruna 47/15 2,63 1.57/30 1.00/8 1.71/14 1.44/16   28/-14 2,33 1.17/30 2.13/8 1.40/15 0.93/15
2018-10-21 Almeria 0-1 R. Oviedo 39/17 2,77 1.77/22 1.88/8 2.00/10 1.58/12   27/-6 2,73 1.05/22 1.13/8 1.18/11 0.91/11
2018-10-21 Extremadura UD 0-1 Almeria 19/-11 2,13 0.96/23 1.13/8 0.91/11 1.00/12   41/19 2,74 1.83/23 2.13/8 2.09/11 1.58/12
2018-10-21 Almeria 0-1 Elche 43/20 2,75 1.88/24 2.38/8 2.09/11 1.69/13   29/3 2,29 1.38/24 1.25/8 1.25/12 1.50/12
2018-10-21 Numancia 0-1 Almeria 30/5 2,20 1.44/25 1.38/8 1.85/13 1.00/12   43/18 2,72 1.80/25 2.00/8 1.92/12 1.69/13
2018-10-21 Almeria 0-1 Racing Santander 44/18 2,69 1.77/26 1.75/8 1.92/12 1.64/14   26/-7 2,27 0.81/26 0.63/8 1.08/13 0.54/13
2018-10-21 Huesca 0-1 Almeria 32/6 2,15 1.59/27 1.38/8 2.38/13 0.86/14   44/17 2,63 1.70/27 1.38/8 1.77/13 1.64/14
2018-10-21 Almeria 0-1 Fuenlabrada 46/16 2,71 1.64/28 1.25/8 1.77/13 1.53/15   29/2 2,00 1.36/28 0.63/8 1.50/14 1.21/14
2018-10-21 Cadiz CF 0-1 Almeria 38/11 2,24 1.79/29 1.13/8 2.00/14 1.60/15   46/16 2,62 1.62/29 1.38/8 1.71/14 1.53/15
2018-10-21 Almeria 0-1 Malaga 62/19 2,56 1.54/41 1.25/8 1.65/20 1.43/21   35/2 1,66 1.27/41 1.63/8 1.57/21 0.95/20