SELECT * FROM 1_Kampe WHERE LigaID = '137' AND (Home='Elche' OR Away='Elche') 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 Elche 0-1 Fuenlabrada 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 Huesca 0-1 Elche 12/3 1,75 1.58/12 1.25/8 2.17/6 1.00/6   11/0 1,83 1.33/12 1.50/8 1.00/6 1.67/6
2018-10-21 Elche 0-1 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
2018-10-21 Dep. La Coruna 0-1 Elche 13/-11 2,64 0.71/14 0.63/8 1.00/6 0.50/8   15/0 2,14 1.36/14 1.38/8 1.29/7 1.43/7
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 Malaga 0-1 Elche 11/-4 1,63 0.94/16 1.00/8 1.00/7 0.89/9   19/2 2,25 1.44/16 1.38/8 1.25/8 1.63/8
2018-10-21 Elche 0-1 Racing Santander 22/2 2,47 1.41/17 1.50/8 1.25/8 1.56/9   20/-1 2,41 0.94/17 1.00/8 1.11/9 0.75/8
2018-10-21 Cadiz CF 0-1 Elche 27/12 2,33 2.17/18 1.75/8 2.75/8 1.70/10   24/4 2,44 1.50/18 1.75/8 1.44/9 1.56/9
2018-10-21 Elche 0-1 Las Palmas 24/4 2,32 1.47/19 1.50/8 1.44/9 1.50/10   24/1 2,47 1.47/19 1.25/8 1.70/10 1.22/9
2018-10-21 Elche 0-1 Gijon 11/1 1,91 1.45/11 1.63/8 1.20/5 1.67/6   11/-2 2,18 1.00/11 0.75/8 1.50/6 0.40/5
2018-10-21 Girona 0-1 Elche 13/3 2,30 1.60/10 1.88/8 2.60/5 0.60/5   9/-1 1,90 1.30/10 1.25/8 1.20/5 1.40/5
2018-10-21 Elche 0-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
2018-10-21 Alcorcon 0-1 Elche 1/1 1,00 3.00/1 3.00/1 0.00/0 3.00/1   0/-2 2,00 0.00/1 0.00/1 0.00/1 0.00/0
2018-10-21 Zaragoza 0-1 Elche 3/2 2,00 2.00/2 2.00/2 3.00/1 1.00/1   2/-1 2,50 1.50/2 1.50/2 0.00/1 3.00/1
2018-10-21 Elche 0-1 Lugo 2/-2 2,00 1.00/3 1.00/3 0.00/1 1.50/2   3/-2 2,67 0.67/3 0.67/3 0.50/2 1.00/1
2018-10-21 R. Oviedo 0-1 Elche 5/-3 3,25 0.25/4 0.25/4 1.00/1 0.00/3   3/-2 2,00 1.00/4 1.00/4 0.50/2 1.50/2
2018-10-21 Elche 0-1 Tenerife 5/0 2,00 1.40/5 1.40/5 0.50/2 2.00/3   7/-1 3,00 1.40/5 1.40/5 2.00/2 1.00/3
2018-10-21 Numancia 0-1 Elche 8/1 2,50 1.33/6 1.33/6 2.00/3 0.67/3   6/0 2,00 1.33/6 1.33/6 0.67/3 2.00/3
2018-10-21 Elche 0-1 Ponferradina 7/0 2,00 1.29/7 1.29/7 0.67/3 1.75/4   12/3 3,00 1.43/7 1.43/7 2.00/4 0.67/3
2018-10-21 Extremadura UD 0-1 Elche 6/-3 1,88 0.75/8 0.75/8 0.33/3 1.00/5   8/1 1,88 1.50/8 1.50/8 1.25/4 1.75/4
2018-10-21 Albacete 0-1 Elche 14/-6 1,79 1.42/19 1.38/8 1.22/9 1.60/10   26/3 2,45 1.40/20 1.50/8 1.30/10 1.50/10
2018-10-21 Elche 0-1 Huesca 27/4 2,38 1.48/21 1.88/8 1.30/10 1.64/11   25/7 2,05 1.67/21 1.63/8 2.27/11 1.00/10
2018-10-21 Elche 0-1 Girona 43/7 2,39 1.42/33 1.38/8 1.38/16 1.47/17   40/5 2,27 1.48/33 1.75/8 2.06/17 0.88/16
2018-10-21 Elche 0-1 Dep. La Coruna 44/8 2,35 1.47/34 1.38/8 1.47/17 1.47/17   33/-18 2,47 1.12/34 1.00/8 1.35/17 0.88/17
2018-10-21 Las Palmas 0-1 Elche 36/-3 2,14 1.31/35 1.38/8 1.41/17 1.22/18   44/7 2,31 1.43/35 1.25/8 1.39/18 1.47/17
2018-10-21 Elche 0-1 Cadiz CF 45/7 2,31 1.42/36 1.38/8 1.39/18 1.44/18   46/11 2,25 1.72/36 1.25/8 1.83/18 1.61/18
2018-10-21 Racing Santander 0-1 Elche 36/-14 2,32 0.81/37 0.75/8 0.83/18 0.79/19   45/7 2,24 1.41/37 1.50/8 1.37/19 1.44/18
2018-10-21 Mirandes 0-1 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
2018-10-21 Elche 0-1 Albacete 47/7 2,23 1.41/39 1.13/8 1.37/19 1.45/20   31/-11 1,87 1.18/39 1.38/8 1.05/20 1.32/19
2018-10-21 Fuenlabrada 0-1 Elche 43/6 2,00 1.43/40 1.88/8 1.60/20 1.25/20   49/9 2,23 1.45/40 1.38/8 1.45/20 1.45/20
2018-10-21 Ponferradina 0-1 Elche 36/2 2,19 1.28/32 1.13/8 1.81/16 0.75/16   42/8 2,38 1.47/32 1.75/8 1.38/16 1.56/16
2018-10-21 Elche 0-1 Extremadura UD 41/8 2,39 1.48/31 1.75/8 1.40/15 1.56/16   30/-13 2,35 1.00/31 1.13/8 1.00/16 1.00/15
2018-10-21 Rayo Vallecano 0-1 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
2018-10-21 Gijon 0-1 Elche 20/-3 1,95 1.14/22 1.00/8 1.36/11 0.91/11   28/4 2,36 1.45/22 1.63/8 1.27/11 1.64/11
2018-10-21 Elche 0-1 Alcorcon 28/3 2,30 1.39/23 1.25/8 1.27/11 1.50/12   25/-1 2,22 1.26/23 1.00/8 1.00/12 1.55/11
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 Elche 0-1 Malaga 31/5 2,28 1.44/25 1.50/8 1.25/12 1.62/13   21/-1 1,72 1.12/25 1.50/8 1.33/12 0.92/13
2018-10-21 Lugo 0-1 Elche 23/-14 2,31 0.96/26 0.50/8 1.23/13 0.69/13   33/7 2,27 1.50/26 1.50/8 1.38/13 1.62/13
2018-10-21 Elche 0-1 Zaragoza 35/7 2,33 1.48/27 1.50/8 1.38/13 1.57/14   36/11 2,35 1.69/26 2.13/8 1.79/14 1.58/12
2018-10-21 Tenerife 0-1 Elche 34/-1 2,46 1.18/28 1.75/8 1.29/14 1.07/14   36/6 2,36 1.43/28 1.50/8 1.29/14 1.57/14
2018-10-21 Elche 0-1 Numancia 36/5 2,31 1.38/29 1.13/8 1.29/14 1.47/15   34/3 2,24 1.31/29 0.75/8 1.73/15 0.86/14
2018-10-21 Elche 0-1 R. Oviedo 50/7 2,27 1.41/41 1.38/8 1.45/20 1.38/21   48/-3 2,41 1.29/41 2.00/8 1.52/21 1.05/20