SELECT * FROM 1_Kampe WHERE LigaID = '117' AND (Home='Pescara' OR Away='Pescara') 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 Pescara 0-1 Frosinone 46/-6 2,88 1.21/34 0.75/8 1.47/17 0.94/17   37/5 2,03 1.53/34 0.75/8 2.00/17 1.06/17
2018-10-21 Pescara 0-1 Venezia 24/3 3,21 1.43/14 1.63/8 1.57/7 1.29/7   14/-2 2,14 1.21/14 1.13/8 1.00/7 1.43/7
2018-10-21 Perugia 0-1 Pescara 14/-3 2,38 1.46/13 1.00/8 1.83/6 1.14/7   23/5 3,15 1.54/13 1.63/8 1.57/7 1.50/6
2018-10-21 Pescara 0-1 Cremonese 22/5 3,25 1.58/12 1.50/8 1.67/6 1.50/6   9/-6 2,00 1.25/12 1.13/8 1.67/6 0.83/6
2018-10-21 Empoli 0-1 Pescara 14/2 2,36 1.55/11 1.50/8 2.20/5 1.00/6   20/4 3,27 1.45/11 1.25/8 1.67/6 1.20/5
2018-10-21 Pescara 0-1 Pisa 17/1 3,30 1.30/10 1.25/8 1.40/5 1.20/5   14/3 2,50 1.30/10 1.13/8 1.60/5 1.00/5
2018-10-21 Juve Stabia 0-1 Pescara 8/-9 2,78 0.78/9 0.88/8 0.75/4 0.80/5   16/2 3,33 1.44/9 1.63/8 1.40/5 1.50/4
2018-10-21 Pescara 0-1 Benevento 12/-2 3,25 1.25/8 1.25/8 1.00/4 1.50/4   11/8 1,75 2.25/8 2.25/8 2.50/4 2.00/4
2018-10-21 Pescara 0-1 Spezia 11/-1 3,29 1.43/7 1.43/7 1.33/3 1.50/4   8/-5 3,00 0.57/7 0.57/7 0.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 Pescara 0-1 Crotone 9/0 3,60 1.40/5 1.40/5 2.00/2 1.00/3   5/2 1,60 1.60/5 1.60/5 1.67/3 1.50/2
2018-10-21 Cittadella 0-1 Pescara 3/-5 2,75 0.75/4 0.75/4 1.50/2 0.00/2   8/1 3,75 1.75/4 1.75/4 2.00/2 1.50/2
2018-10-21 Pescara 0-1 Entella 7/1 4,33 2.00/3 2.00/3 3.00/1 1.50/2   3/3 1,00 3.00/3 3.00/3 3.00/2 3.00/1
2018-10-21 Cosenza 0-1 Pescara 0/-1 0,50 0.50/2 0.50/2 0.00/1 1.00/1   5/0 5,00 1.50/2 1.50/2 3.00/1 0.00/1
2018-10-21 Pescara 0-1 Pordenone 1/-2 4,00 0.00/1 0.00/1 0.00/0 0.00/1   3/3 3,00 3.00/1 3.00/1 3.00/1 0.00/0
2018-10-21 Salernitana 0-1 Pescara 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 Chievo 1-3 Pescara 47/9 2,30 1.43/37 1.38/8 1.72/18 1.16/19   47/-7 2,81 1.17/36 0.88/8 1.44/18 0.89/18
2018-10-21 Pescara 1-3 Livorno / /0 / / /   / /0 / / /
2018-10-21 Frosinone 0-1 Pescara 19/5 2,20 1.53/15 2.13/8 2.43/7 0.75/8   26/3 3,27 1.40/15 1.38/8 1.50/8 1.29/7
2018-10-21 Pescara 0-1 Trapani 26/1 3,19 1.31/16 1.38/8 1.50/8 1.13/8   16/-14 2,88 0.81/16 1.00/8 0.75/8 0.88/8
2018-10-21 Venezia 0-1 Pescara 31/-6 2,06 1.21/33 1.13/8 0.88/16 1.53/17   45/-6 2,91 1.21/33 1.00/8 1.47/17 0.94/16
2018-10-21 Pescara 0-1 Perugia 43/-6 2,88 1.22/32 0.88/8 1.50/16 0.94/16   31/-9 2,22 1.25/32 0.88/8 1.47/17 1.00/15
2018-10-21 Cremonese 0-1 Pescara 34/-5 2,35 1.10/31 1.38/8 1.27/15 0.94/16   43/-5 2,94 1.26/31 0.88/8 1.50/16 1.00/15
2018-10-21 Pescara 0-1 Empoli 42/-5 2,97 1.27/30 0.75/8 1.53/15 1.00/15   33/-2 2,27 1.37/30 1.75/8 1.63/16 1.07/14
2018-10-21 Pisa 0-1 Pescara 36/0 2,48 1.28/29 1.38/8 1.53/15 1.00/14   41/-4 2,97 1.31/29 1.13/8 1.53/15 1.07/14
2018-10-21 Pescara 0-1 Juve Stabia 38/-6 2,93 1.25/28 1.13/8 1.43/14 1.07/14   35/-8 2,79 1.29/28 1.13/8 1.73/15 0.77/13
2018-10-21 Benevento 0-1 Pescara 50/35 2,41 2.44/27 2.50/8 2.57/14 2.31/13   38/-2 2,89 1.30/27 1.13/8 1.43/14 1.15/13
2018-10-21 Spezia 0-1 Pescara 37/8 2,54 1.58/26 2.13/8 1.85/13 1.31/13   38/0 2,92 1.35/26 1.25/8 1.43/14 1.25/12
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 Crotone 0-1 Pescara 37/7 2,79 1.54/24 1.88/8 2.00/12 1.08/12   35/2 2,83 1.33/24 1.38/8 1.31/13 1.36/11
2018-10-21 Pescara 0-1 Cittadella 34/3 2,83 1.39/23 1.38/8 1.42/12 1.36/11   28/0 2,43 1.43/23 1.00/8 1.25/12 1.64/11
2018-10-21 Entella 0-1 Pescara 26/2 2,27 1.41/22 1.50/8 1.90/10 1.00/12   34/5 2,86 1.45/22 1.50/8 1.42/12 1.50/10
2018-10-21 Pescara 0-1 Cosenza 32/4 2,86 1.38/21 1.13/8 1.27/11 1.50/10   23/-2 2,29 0.95/21 1.00/8 1.00/10 0.91/11
2018-10-21 Pordenone 0-1 Pescara 29/4 2,70 1.75/20 2.00/8 2.60/10 0.90/10   30/2 2,90 1.30/20 0.88/8 1.27/11 1.33/9
2018-10-21 Pescara 0-1 Salernitana 29/3 2,89 1.37/19 1.25/8 1.40/10 1.33/9   27/2 2,74 1.37/19 1.00/8 1.78/9 1.00/10
2018-10-21 Pescara 0-1 Chievo 29/3 3,06 1.39/18 1.50/8 1.44/9 1.33/9   24/2 2,56 1.39/18 1.00/8 1.67/9 1.11/9
2018-10-21 Livorno 0-1 Pescara 13/-12 2,24 0.65/17 0.50/8 1.13/8 0.22/9   27/1 3,12 1.29/17 1.13/8 1.44/9 1.13/8
2018-10-21 Trapani 1-3 Pescara 41/-17 2,83 0.97/35 1.25/8 1.24/17 0.72/18   47/-6 2,86 1.20/35 0.88/8 1.44/18 0.94/17