SELECT * FROM 1_Kampe WHERE LigaID = '117' AND (Home='Ascoli' OR Away='Ascoli') 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
2019-08-24 Ascoli 3-1 Trapani 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
2019-09-01 Frosinone 2-1 Ascoli 0/-3 3,00 0.00/1 0.00/1 0.00/0 0.00/1   3/2 4,00 3.00/1 3.00/1 3.00/1 0.00/0
2019-09-14 Ascoli 2-0 Livorno 4/1 3,50 1.50/2 1.50/2 3.00/1 0.00/1   0/-2 1,00 0.00/2 0.00/2 0.00/1 0.00/1
2019-09-21 Juve Stabia 1-5 Ascoli 1/-3 1,67 0.33/3 0.33/3 0.00/1 0.50/2   6/3 3,00 2.00/3 2.00/3 3.00/2 0.00/1
2019-09-24 Ascoli 3-0 Spezia 11/7 3,75 2.25/4 2.25/4 3.00/2 1.50/2   6/1 2,75 1.00/4 1.00/4 0.50/2 1.50/2
2019-09-30 Cremonese 1-0 Ascoli 5/-2 2,40 1.40/5 1.40/5 1.50/2 1.33/3   14/10 3,60 2.40/5 2.40/5 3.00/3 1.50/2
2019-10-06 Ascoli 0-2 Pescara 14/9 3,17 2.00/6 2.00/6 3.00/3 1.00/3   9/-3 3,50 1.17/6 1.17/6 1.33/3 1.00/3
2019-10-20 Chievo 2-0 Ascoli 12/2 3,14 1.43/7 1.43/7 1.00/3 1.75/4   14/7 3,00 1.71/7 1.71/7 2.25/4 1.00/3
2019-10-25 Ascoli 2-1 Entella 14/5 2,88 1.50/8 1.50/8 2.25/4 0.75/4   7/-1 1,88 1.50/8 1.50/8 1.75/4 1.25/4
2019-10-29 Perugia 1-1 Ascoli 10/1 2,11 1.67/9 1.50/8 2.50/4 1.00/5   16/6 2,89 1.67/9 1.50/8 2.40/5 0.75/4
2019-11-02 Ascoli 1-1 Venezia 17/6 2,80 1.60/10 1.63/8 2.40/5 0.80/5   11/-1 2,30 1.20/10 1.13/8 0.80/5 1.60/5
2019-11-08 Crotone 3-1 Ascoli 18/6 2,73 1.64/11 1.63/8 1.83/6 1.40/5   18/6 2,73 1.55/11 1.38/8 2.17/6 0.80/5
2019-11-24 Ascoli 3-2 Cosenza 19/4 2,83 1.42/12 1.00/8 2.17/6 0.67/6   12/0 2,00 1.00/12 1.38/8 1.00/6 1.00/6
2019-11-30 Salernitana 1-1 Ascoli 14/-1 2,23 1.38/13 1.00/8 1.50/6 1.29/7   22/5 3,00 1.54/13 1.00/8 2.29/7 0.67/6
2019-12-07 Empoli 2-1 Ascoli 16/-3 2,50 1.29/14 0.50/8 1.71/7 0.86/7   23/5 2,93 1.50/14 1.13/8 2.29/7 0.71/7
2019-12-14 Ascoli 1-0 Cittadella 24/4 2,93 1.40/15 1.13/8 2.29/7 0.63/8   18/1 2,33 1.67/15 1.63/8 1.75/8 1.57/7
2019-12-22 Pordenone 2-1 Ascoli 24/6 2,63 1.75/16 2.13/8 2.50/8 1.00/8   25/5 2,81 1.50/16 1.50/8 2.38/8 0.63/8
2019-12-26 Ascoli 1-0 Pisa 26/4 2,82 1.41/17 1.13/8 2.38/8 0.56/9   24/1 2,76 1.35/17 1.63/8 1.56/9 1.13/8
2019-12-29 Benevento 4-0 Ascoli 30/21 2,17 2.39/18 2.75/8 2.78/9 2.00/9   27/5 2,72 1.50/18 1.38/8 2.44/9 0.56/9
2020-01-18 Trapani 3-1 Ascoli 19/-17 2,89 0.79/19 1.13/8 0.78/9 0.80/10   27/1 2,79 1.42/19 1.25/8 2.44/9 0.50/10
2020-01-26 Ascoli 0-1 Frosinone 28/-1 2,85 1.35/20 1.25/8 2.44/9 0.45/11   24/5 2,15 1.40/20 1.38/8 2.10/10 0.70/10
2020-02-01 Livorno 0-3 Ascoli 18/-15 2,43 0.62/21 0.38/8 1.00/10 0.27/11   28/-2 2,76 1.29/21 0.88/8 2.20/10 0.45/11
2020-02-07 Ascoli 2-2 Juve Stabia 31/1 2,77 1.36/22 1.13/8 2.20/10 0.67/12   24/-7 2,50 1.27/22 1.75/8 1.58/12 0.90/10
2020-02-15 Spezia 3-1 Ascoli 32/8 2,43 1.61/23 2.25/8 1.75/12 1.45/11   33/1 2,83 1.35/23 1.25/8 2.09/11 0.67/12
2020-03-01 Pescara 2-1 Ascoli 36/-1 2,92 1.28/25 1.25/8 1.31/13 1.25/12   34/-1 2,88 1.29/24 0.88/8 2.09/11 0.62/13
2020-03-04 Ascoli 1-1 Chievo 35/-2 2,88 1.24/25 0.88/8 2.09/11 0.57/14   31/5 2,19 1.42/26 1.50/8 1.62/13 1.23/13
2020-03-08 Entella 3-0 Ascoli 32/-4 2,52 1.30/27 0.75/8 1.69/13 0.93/14   36/-2 2,85 1.23/26 0.63/8 2.00/12 0.57/14
2020-06-17 Ascoli 1-3 Cremonese 36/-5 2,85 1.19/27 0.63/8 2.00/12 0.53/15   28/-4 2,22 1.11/27 1.00/8 1.46/13 0.79/14
2020-06-21 Ascoli 0-1 Perugia 37/-7 2,89 1.14/28 0.63/8 1.85/13 0.53/15   29/-7 2,32 1.29/28 1.13/8 1.60/15 0.92/13
2020-06-26 Venezia 2-1 Ascoli 26/-7 2,03 1.14/29 1.13/8 0.79/14 1.47/15   37/-8 2,83 1.10/29 0.63/8 1.71/14 0.53/15
2020-06-29 Ascoli 1-1 Crotone 38/-9 2,83 1.07/30 0.25/8 1.71/14 0.50/16   48/14 2,73 1.70/30 2.13/8 2.07/15 1.33/15
2020-07-03 Cosenza 0-1 Ascoli 35/-3 2,35 1.00/31 1.38/8 0.93/15 1.06/16   39/-9 2,81 1.06/31 0.25/8 1.67/15 0.50/16
2020-07-10 Ascoli 3-2 Salernitana 40/-8 2,75 1.13/32 0.63/8 1.67/15 0.65/17   42/4 2,50 1.47/32 1.38/8 2.06/16 0.88/16
2020-07-13 Ascoli 1-0 Empoli 43/-7 2,82 1.18/33 1.00/8 1.75/16 0.65/17   38/2 2,24 1.45/33 1.50/8 1.71/17 1.19/16
2020-07-17 Cittadella 1-2 Ascoli 43/2 2,47 1.53/34 1.50/8 1.29/17 1.76/17   44/-6 2,76 1.24/34 1.25/8 1.82/17 0.65/17
2020-07-24 Ascoli 2-2 Pordenone 46/-5 2,77 1.29/35 1.63/8 1.82/17 0.78/18   43/2 2,40 1.57/35 1.63/8 2.06/18 1.06/17
2020-07-27 Pisa 1-0 Ascoli 47/3 2,53 1.39/36 1.75/8 1.78/18 1.00/18   48/-5 2,81 1.28/36 1.75/8 1.78/18 0.78/18
2020-07-31 Ascoli 2-4 Benevento 48/-6 2,76 1.24/37 1.75/8 1.78/18 0.74/19   63/38 2,38 2.24/37 1.38/8 2.42/19 2.06/18