SELECT * FROM 1_Kampe WHERE LigaID = '137' AND (Home='Huesca' OR Away='Huesca') 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 Las Palmas 0-1 Huesca 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 Tenerife 0-1 Huesca 17/-2 2,77 1.00/13 0.75/8 0.83/6 1.14/7   14/5 1,77 1.69/13 1.63/8 2.29/7 1.00/6
2018-10-21 Huesca 0-1 R. Oviedo 14/5 1,64 1.64/14 1.75/8 2.29/7 1.00/7   18/-3 2,79 1.00/14 1.50/8 1.14/7 0.86/7
2018-10-21 Fuenlabrada 0-1 Huesca 19/5 2,20 1.67/15 1.38/8 1.71/7 1.63/8   17/7 1,80 1.73/15 1.75/8 2.38/8 1.00/7
2018-10-21 Huesca 0-1 Ponferradina 19/6 2,00 1.63/16 1.38/8 2.38/8 0.88/8   23/5 2,56 1.44/16 1.63/8 1.78/9 1.00/7
2018-10-21 Alcorcon 0-1 Huesca 21/3 2,29 1.47/17 1.63/8 1.25/8 1.67/9   21/8 2,00 1.71/17 1.75/8 2.44/9 0.88/8
2018-10-21 Huesca 0-1 Rayo Vallecano 23/10 2,00 1.78/18 1.75/8 2.44/9 1.11/9   25/1 2,72 1.17/18 1.00/8 1.44/9 0.89/9
2018-10-21 Mirandes 0-1 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
2018-10-21 Lugo 0-1 Huesca 10/-5 2,27 0.91/11 1.00/8 0.83/6 1.00/5   10/4 1,45 1.73/11 1.63/8 2.17/6 1.20/5
2018-10-21 Huesca 0-1 Racing Santander 9/4 1,40 1.80/10 1.50/8 2.40/5 1.20/5   9/-3 2,10 0.80/10 0.88/8 0.83/6 0.75/4
2018-10-21 Huesca 0-1 Malaga 7/2 1,33 1.67/9 1.50/8 2.25/4 1.20/5   6/-2 1,56 0.89/9 0.63/8 0.75/4 1.00/5
2018-10-21 Huesca 0-1 Dep. La Coruna 1/1 1,00 3.00/1 3.00/1 0.00/0 3.00/1   3/1 5,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 Huesca 0-1 Gijon 4/2 2,00 2.00/3 2.00/3 3.00/1 1.50/2   4/2 2,00 1.67/3 1.67/3 2.00/2 1.00/1
2018-10-21 Numancia 0-1 Huesca 4/0 2,00 1.00/4 1.00/4 1.50/2 0.50/2   5/3 1,75 2.25/4 2.25/4 3.00/2 1.50/2
2018-10-21 Huesca 0-1 Albacete 5/2 1,60 1.80/5 1.80/5 3.00/2 1.00/3   2/-7 2,20 1.20/5 1.20/5 1.50/2 1.00/3
2018-10-21 Extremadura UD 0-1 Huesca 4/-4 2,00 0.50/6 0.50/6 0.50/2 0.50/4   5/1 1,50 1.50/6 1.50/6 2.00/3 1.00/3
2018-10-21 Huesca 0-1 Girona 6/2 1,43 1.71/7 1.71/7 2.00/3 1.50/4   7/-1 2,14 1.43/7 1.43/7 2.50/4 0.00/3
2018-10-21 Cadiz CF 0-1 Huesca 13/5 2,63 2.38/8 2.38/8 2.50/4 2.25/4   7/3 1,38 1.88/8 1.88/8 2.25/4 1.50/4
2018-10-21 Huesca 0-1 Zaragoza 23/6 2,00 1.60/20 1.63/8 2.20/10 1.00/10   30/8 2,60 1.65/20 1.75/8 1.64/11 1.67/9
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 Albacete 0-1 Huesca 25/-12 1,88 1.15/33 1.25/8 1.06/16 1.24/17   43/8 2,36 1.61/33 1.25/8 2.24/17 0.94/16
2018-10-21 Huesca 0-1 Cadiz CF 45/8 2,41 1.59/34 1.38/8 2.24/17 0.94/17   45/13 2,26 1.79/34 1.50/8 1.94/17 1.65/17
2018-10-21 Zaragoza 0-1 Huesca 51/14 2,51 1.74/35 1.75/8 1.65/17 1.83/18   46/8 2,40 1.57/35 1.50/8 2.17/18 0.94/17
2018-10-21 Huesca 0-1 Las Palmas 47/9 2,36 1.61/36 1.50/8 2.17/18 1.06/18   37/-3 2,14 1.31/36 1.38/8 1.39/18 1.22/18
2018-10-21 Dep. La Coruna 0-1 Huesca 37/-16 2,43 1.22/37 1.38/8 1.44/18 1.00/19   48/10 2,32 1.65/37 1.88/8 2.21/19 1.06/18
2018-10-21 Huesca 0-1 Alcorcon 49/9 2,34 1.61/38 1.75/8 2.21/19 1.00/19   49/3 2,50 1.39/38 1.50/8 1.05/19 1.74/19
2018-10-21 Racing Santander 0-1 Huesca 37/-16 2,31 0.77/39 0.25/8 0.79/19 0.75/20   51/10 2,36 1.64/39 1.75/8 2.25/20 1.00/19
2018-10-21 Huesca 0-1 Numancia 51/9 2,33 1.60/40 1.38/8 2.25/20 0.95/20   43/-6 2,30 1.18/40 1.13/8 1.75/20 0.60/20
2018-10-21 Huesca 0-1 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
2018-10-21 Malaga 0-1 Huesca 27/0 1,74 1.23/31 1.50/8 1.47/15 1.00/16   39/7 2,29 1.61/31 1.38/8 2.38/16 0.80/15
2018-10-21 Huesca 0-1 Fuenlabrada 37/5 2,30 1.57/30 1.38/8 2.33/15 0.80/15   32/1 2,10 1.30/30 0.50/8 1.40/15 1.20/15
2018-10-21 Huesca 0-1 Tenerife 26/7 2,05 1.64/22 1.63/8 2.27/11 1.00/11   26/-4 2,55 1.00/22 1.00/8 1.00/11 1.00/11
2018-10-21 R. Oviedo 0-1 Huesca 27/-8 2,70 1.00/23 1.13/8 1.18/11 0.83/12   28/8 2,09 1.70/23 1.63/8 2.33/12 1.00/11
2018-10-21 Huesca 0-1 Lugo 29/8 2,08 1.67/24 1.75/8 2.33/12 1.00/12   22/-12 2,33 1.04/24 0.63/8 1.23/13 0.82/11
2018-10-21 Ponferradina 0-1 Huesca 31/2 2,40 1.28/25 1.13/8 1.69/13 0.83/12   31/9 2,12 1.72/25 1.75/8 2.38/13 1.00/12
2018-10-21 Girona 0-1 Huesca 33/2 2,46 1.46/26 1.25/8 2.08/13 0.85/13   32/7 2,19 1.65/26 1.38/8 2.38/13 0.92/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 Rayo Vallecano 0-1 Huesca 33/5 2,26 1.33/27 1.50/8 1.62/13 1.07/14   35/7 2,25 1.64/28 1.75/8 2.43/14 0.86/14
2018-10-21 Huesca 0-1 Extremadura UD 35/5 2,24 1.59/29 1.38/8 2.43/14 0.80/15   27/-12 2,28 1.03/29 1.13/8 1.07/15 1.00/14
2018-10-21 Gijon 0-1 Huesca 40/3 1,88 1.32/41 1.13/8 1.75/20 0.90/21   54/12 2,34 1.63/41 1.75/8 2.29/21 0.95/20