SELECT * FROM 1_Kampe WHERE LigaID = '138' AND (Home='Alcorcon' OR Away='Alcorcon') 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-18 Alcorcon 1-1 Gijon 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-24 Malaga 1-0 Alcorcon 2/1 3,00 3.00/1 3.00/1 0.00/0 3.00/1   1/0 2,00 1.00/1 1.00/1 1.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-09 Cordoba 0-0 Alcorcon 5/-5 5,00 0.33/3 0.33/3 0.50/2 0.00/1   2/0 1,33 1.33/3 1.33/3 2.00/2 0.00/1
2018-09-15 Alcorcon 1-0 Dep. La Coruna 2/0 1,00 1.25/4 1.25/4 2.00/2 0.50/2   5/2 2,00 2.00/4 2.00/4 3.00/1 1.67/3
2018-09-23 Cadiz CF 0-2 Alcorcon 4/0 1,60 1.20/5 1.20/5 2.00/2 0.67/3   3/1 1,00 1.60/5 1.60/5 2.33/3 0.50/2
2018-09-30 Alcorcon 2-0 R. Oviedo 5/3 1,17 1.83/6 1.83/6 2.33/3 1.33/3   9/0 3,00 1.50/6 1.50/6 0.67/3 2.33/3
2018-10-06 Las Palmas 0-0 Alcorcon 11/7 2,14 2.00/7 2.00/7 2.50/4 1.33/3   7/5 1,29 2.00/7 2.00/7 2.50/4 1.33/3
2018-10-15 Gimnastic 0-0 Alcorcon 5/-8 2,25 0.75/8 0.75/8 1.00/4 0.50/4   7/5 1,13 1.88/8 1.88/8 2.50/4 1.25/4
2018-10-20 Alcorcon 1-0 Granada CF 7/5 1,00 1.67/9 1.75/8 2.50/4 1.00/5   17/10 2,67 2.22/9 2.38/8 2.60/5 1.75/4
2018-10-21 Reus Deportiu 0-1 Alcorcon 11/-2 1,00 1.38/24 1.88/8 0.00/13 3.00/11   8/6 1,00 1.80/10 2.13/8 2.60/5 1.00/5
2018-10-21 Alcorcon 0-1 Reus Deportiu 9/7 1,00 1.91/11 2.00/8 2.60/5 1.33/6   3/1 1,00 1.80/5 1.88/8 0.00/2 3.00/3
2018-10-27 Tenerife 3-2 Alcorcon 9/-4 1,83 1.00/12 1.13/8 1.00/5 1.00/7   9/6 1,00 1.75/12 2.00/8 2.17/6 1.33/6
2018-11-04 Alcorcon 2-0 Rayo Majadahonda 11/5 1,31 1.62/13 1.63/8 2.17/6 1.14/7   10/-6 2,00 1.23/13 1.25/8 1.43/7 1.00/6
2018-11-10 Lugo 0-1 Alcorcon 12/-2 1,86 1.14/14 1.13/8 1.00/7 1.29/7   13/7 1,36 1.71/14 1.63/8 2.29/7 1.14/7
2018-11-18 Alcorcon 1-0 Elche 14/8 1,33 1.80/15 1.63/8 2.29/7 1.38/8   13/-6 2,13 1.20/15 1.63/8 1.50/8 0.86/7
2018-11-25 Alcorcon 2-0 Zaragoza 15/9 1,31 1.88/16 1.88/8 2.38/8 1.38/8   18/-1 2,31 1.13/16 1.00/8 0.88/8 1.38/8
2018-12-02 Albacete 2-1 Alcorcon 22/9 2,06 1.76/17 2.13/8 1.63/8 1.89/9   17/11 1,35 1.94/17 2.25/8 2.44/9 1.38/8
2018-12-09 Alcorcon 0-1 Reus FCR 18/10 1,44 1.83/18 1.88/8 2.44/9 1.22/9   10/-14 2,13 0.81/16 0.63/8 0.75/8 0.88/8
2018-12-16 Osasuna 2-1 Alcorcon 22/3 2,16 1.53/19 2.13/8 2.22/9 0.90/10   18/9 1,42 1.74/19 1.88/8 2.20/10 1.22/9
2018-12-23 Alcorcon 1-1 Numancia 19/8 1,50 1.65/20 1.50/8 2.20/10 1.10/10   20/-3 2,15 1.20/20 1.00/8 1.60/10 0.80/10
2019-01-05 Extremadura UD 3-0 Alcorcon 25/-5 2,62 0.95/21 1.00/8 0.70/10 1.18/11   20/8 1,52 1.62/21 1.63/8 2.09/11 1.10/10
2019-01-13 Alcorcon 0-0 Almeria 20/5 1,59 1.55/22 1.25/8 2.09/11 1.00/11   26/4 2,18 1.41/22 1.38/8 1.73/11 1.09/11
2019-01-20 Gijon 2-0 Alcorcon 21/2 1,74 1.30/23 1.50/8 1.73/11 0.92/12   20/5 1,52 1.52/23 1.00/8 2.00/12 1.00/11
2019-01-27 Alcorcon 2-1 Cordoba 20/3 1,54 1.46/24 0.63/8 2.00/12 0.92/12   27/-14 2,83 0.88/24 0.88/8 1.25/12 0.50/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 Alcorcon 1-2 Cadiz CF 22/2 1,62 1.46/26 0.63/8 2.08/13 0.85/13   31/10 2,00 1.46/26 1.13/8 1.77/13 1.15/13
2019-02-16 R. Oviedo 1-0 Alcorcon 31/0 2,30 1.56/27 2.00/8 1.69/13 1.43/14   23/1 1,67 1.41/27 0.63/8 1.93/14 0.85/13
2019-02-23 Alcorcon 2-0 Las Palmas 23/0 1,64 1.36/28 0.63/8 1.93/14 0.79/14   32/4 2,14 1.43/28 1.63/8 1.79/14 1.07/14
2019-03-04 Dep. La Coruna 2-2 Alcorcon 38/18 2,00 1.76/29 1.63/8 2.07/14 1.47/15   25/2 1,66 1.41/29 0.88/8 2.00/15 0.79/14
2019-03-10 Rayo Majadahonda 2-0 Alcorcon 26/-13 2,17 1.10/30 1.13/8 1.27/15 0.93/15   27/2 1,73 1.40/30 1.00/8 2.00/15 0.80/15
2019-03-16 Alcorcon 1-1 Tenerife 27/0 1,74 1.35/31 0.88/8 2.00/15 0.75/16   24/-9 1,84 1.03/31 0.88/8 1.44/16 0.60/15
2019-03-23 Elche 3-1 Alcorcon 30/-6 2,06 1.13/32 1.13/8 1.50/16 0.75/16   28/0 1,75 1.34/32 1.00/8 1.94/16 0.75/16
2019-03-31 Alcorcon 0-0 Lugo 29/-2 1,82 1.30/33 0.63/8 1.94/16 0.71/17   29/-12 2,12 0.97/33 0.38/8 1.12/17 0.81/16
2019-04-07 Alcorcon 0-1 Albacete 29/-2 1,76 1.29/34 0.75/8 1.88/17 0.71/17   43/17 2,03 1.76/34 1.50/8 1.88/17 1.65/17
2019-04-14 Zaragoza 0-2 Alcorcon 38/-5 2,31 1.17/35 1.00/8 1.24/17 1.11/18   29/-3 1,74 1.26/35 0.75/8 1.78/18 0.71/17
2019-04-19 Alcorcon 1-4 Malaga 31/-1 1,75 1.31/36 1.13/8 1.78/18 0.83/18   35/8 1,72 1.61/36 0.88/8 1.72/18 1.50/18
2019-04-28 Reus FCR 0-0 Alcorcon 16/-13 1,29 0.60/35 0.00/8 0.44/18 0.76/17   32/-4 1,84 1.27/37 0.75/8 1.68/19 0.83/18
2019-05-04 Alcorcon 0-0 Osasuna 32/-4 1,79 1.24/38 0.63/8 1.68/19 0.79/19   53/19 2,29 2.00/38 2.38/8 2.63/19 1.37/19
2019-05-11 Numancia 2-0 Alcorcon 41/-8 2,31 1.13/39 0.75/8 1.47/19 0.80/20   32/-4 1,74 1.23/39 0.75/8 1.65/20 0.79/19
2019-05-18 Alcorcon 0-1 Extremadura UD 32/-6 1,75 1.20/40 0.63/8 1.65/20 0.75/20   41/-7 2,23 1.13/40 1.88/8 1.00/20 1.25/20
2019-05-26 Almeria 0-0 Alcorcon 48/8 2,15 1.34/41 1.25/8 1.70/20 1.00/21   32/-7 1,73 1.17/41 0.63/8 1.57/21 0.75/20
2019-06-01 Alcorcon 0-1 Gimnastic 32/-7 1,69 1.17/42 0.63/8 1.57/21 0.76/21   27/-33 2,07 0.76/42 1.00/8 1.10/21 0.43/21
2019-06-08 Granada CF 2-1 Alcorcon 50/22 1,81 1.77/43 1.88/8 1.86/21 1.68/22   32/-8 1,67 1.14/43 0.63/8 1.50/22 0.76/21