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
2018-10-21 Cittadella 0-1 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
2018-10-21 Empoli 0-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
2018-10-21 Salernitana 0-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
2018-10-21 Ascoli 0-1 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
2018-10-21 Crotone 0-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
2018-10-21 Ascoli 0-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
2018-10-21 Perugia 0-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
2018-10-21 Ascoli 0-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
2018-10-21 Chievo 0-1 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
2018-10-21 Ascoli 0-1 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
2018-10-21 Cremonese 0-1 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
2018-10-21 Ascoli 0-1 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
2018-10-21 Juve Stabia 0-1 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
2018-10-21 Ascoli 0-1 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
2018-10-21 Frosinone 0-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
2018-10-21 Ascoli 0-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
2018-10-21 Ascoli 1-3 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
2018-10-21 Pisa 1-3 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
2018-10-21 Ascoli 0-1 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
2018-10-21 Pordenone 0-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
2018-10-21 Ascoli 0-1 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
2018-10-21 Ascoli 0-1 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
2018-10-21 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
2018-10-21 Ascoli 0-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
2018-10-21 Venezia 0-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
2018-10-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
2018-10-21 Entella 0-1 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
2018-10-21 Ascoli 0-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
2018-10-21 Pescara 0-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
2018-10-21 Ascoli 0-1 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
2018-10-21 Spezia 0-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
2018-10-21 Ascoli 0-1 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
2018-10-21 Livorno 0-1 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
2018-10-21 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
2018-10-21 Trapani 0-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
2018-10-21 Benevento 0-1 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
2018-10-21 Ascoli 0-1 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
2018-10-21 Ascoli 1-3 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