SELECT * FROM 1_Kampe WHERE LigaID = '117' AND (Home='Trapani' OR Away='Trapani') 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 Pisa 0-1 Trapani 43/3 2,44 1.38/34 1.75/8 1.71/17 1.06/17   39/-16 2,76 1.00/34 1.63/8 1.24/17 0.76/17
2018-10-21 Benevento 0-1 Trapani 20/12 2,00 2.21/14 2.38/8 2.71/7 1.71/7   15/-7 2,64 0.93/14 1.13/8 0.86/7 1.00/7
2018-10-21 Trapani 0-1 Chievo 14/-8 2,77 0.77/13 1.13/8 0.50/6 1.00/7   19/4 2,62 1.62/13 1.88/8 2.00/6 1.29/7
2018-10-21 Livorno 0-1 Trapani 11/-6 2,33 0.83/12 0.88/8 1.50/6 0.17/6   12/-9 2,75 0.58/12 0.88/8 0.50/6 0.67/6
2018-10-21 Trapani 0-1 Cosenza 10/-9 2,64 0.55/11 0.75/8 0.40/5 0.67/6   10/0 1,82 1.00/11 1.25/8 1.00/6 1.00/5
2018-10-21 Pordenone 0-1 Trapani 15/2 2,80 1.50/10 1.50/8 2.20/5 0.80/5   9/-8 2,60 0.60/10 0.75/8 0.40/5 0.80/5
2018-10-21 Frosinone 0-1 Trapani 8/-4 2,22 1.11/9 1.25/8 2.00/4 0.40/5   9/-5 2,56 0.67/9 0.75/8 0.40/5 1.00/4
2018-10-21 Trapani 0-1 Empoli 7/-5 2,38 0.63/8 0.63/8 0.25/4 1.00/4   11/4 2,25 1.88/8 1.88/8 2.50/4 1.25/4
2018-10-21 Entella 0-1 Trapani 6/-1 1,86 1.57/7 1.57/7 2.00/3 1.25/4   6/-5 2,43 0.57/7 0.57/7 0.25/4 1.00/3
2018-10-21 Trapani 0-1 Juve Stabia 5/-4 2,33 0.67/6 0.67/6 0.33/3 1.00/3   2/-10 2,33 0.17/6 0.17/6 0.00/3 0.33/3
2018-10-21 Spezia 0-1 Trapani 6/-2 2,80 0.80/5 0.80/5 0.50/2 1.00/3   1/-6 1,60 0.20/5 0.20/5 0.33/3 0.00/2
2018-10-21 Trapani 0-1 Cremonese 1/-6 2,00 0.00/4 0.00/4 0.00/2 0.00/2   5/-2 3,00 1.50/4 1.50/4 1.50/2 1.50/2
2018-10-21 Trapani 0-1 Salernitana 1/-5 2,33 0.00/3 0.00/3 0.00/1 0.00/2   4/1 2,33 2.00/3 2.00/3 1.50/2 3.00/1
2018-10-21 Cittadella 0-1 Trapani 1/-6 4,00 0.00/2 0.00/2 0.00/1 0.00/1   1/-3 2,50 0.00/2 0.00/2 0.00/1 0.00/1
2018-10-21 Trapani 0-1 Venezia 1/-2 4,00 0.00/1 0.00/1 0.00/0 0.00/1   1/-1 3,00 0.00/1 0.00/1 0.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 Trapani 1-3 Crotone 44/-15 2,78 1.08/37 1.75/8 1.33/18 0.84/19   58/21 2,64 1.81/36 2.00/8 2.16/19 1.41/17
2018-10-21 Perugia 1-3 Trapani 36/-8 2,22 1.25/36 1.13/8 1.44/18 1.06/18   42/-16 2,78 1.03/36 1.50/8 1.33/18 0.72/18
2018-10-21 Trapani 0-1 Pisa 15/-12 2,80 0.87/15 1.13/8 0.86/7 0.88/8   20/1 2,60 1.33/15 1.38/8 1.75/8 0.86/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 Trapani 0-1 Benevento 37/-18 2,79 0.94/33 1.38/8 1.13/16 0.76/17   57/38 2,30 2.33/33 2.13/8 2.53/17 2.13/16
2018-10-21 Chievo 0-1 Trapani 39/7 2,22 1.44/32 1.50/8 1.69/16 1.19/16   36/-18 2,81 0.94/32 1.38/8 1.13/16 0.75/16
2018-10-21 Trapani 0-1 Livorno 36/-18 2,90 0.97/31 1.38/8 1.20/15 0.75/16   26/-25 2,48 0.68/31 0.88/8 0.73/15 0.63/16
2018-10-21 Cosenza 0-1 Trapani 33/-3 2,30 1.00/30 1.25/8 0.93/14 1.06/16   34/-18 2,87 0.97/30 1.25/8 1.20/15 0.73/15
2018-10-21 Trapani 0-1 Pordenone 31/-21 2,86 0.90/29 0.88/8 1.07/14 0.73/15   37/3 2,45 1.59/29 1.38/8 2.07/15 1.07/14
2018-10-21 Trapani 0-1 Frosinone 31/-21 2,96 0.89/28 0.88/8 1.08/13 0.73/15   33/10 2,00 1.68/28 2.38/8 2.14/14 1.21/14
2018-10-21 Empoli 0-1 Trapani 32/-1 2,41 1.44/27 2.00/8 1.71/14 1.15/13   30/-21 3,00 0.89/27 1.13/8 1.08/13 0.71/14
2018-10-21 Trapani 0-1 Entella 26/-24 2,92 0.81/26 0.75/8 0.92/12 0.71/14   31/-1 2,42 1.35/26 1.13/8 1.69/13 1.00/13
2018-10-21 Juve Stabia 0-1 Trapani 29/-9 2,68 1.28/25 1.50/8 1.69/13 0.83/12   24/-24 2,88 0.80/25 0.75/8 0.92/12 0.69/13
2018-10-21 Trapani 0-1 Spezia 23/-24 2,92 0.79/24 0.75/8 0.91/11 0.69/13   35/10 2,50 1.67/24 2.50/8 1.85/13 1.45/11
2018-10-21 Cremonese 0-1 Trapani 19/-10 2,09 1.00/23 0.75/8 1.45/11 0.58/12   23/-19 2,83 0.83/23 0.75/8 0.91/11 0.75/12
2018-10-21 Salernitana 0-1 Trapani 32/4 2,73 1.50/22 1.75/8 1.90/10 1.17/12   23/-18 2,91 0.86/22 0.75/8 0.91/11 0.82/11
2018-10-21 Trapani 0-1 Cittadella 23/-15 2,90 0.90/21 1.13/8 1.00/10 0.82/11   24/-2 2,38 1.43/21 1.13/8 1.36/11 1.50/10
2018-10-21 Venezia 0-1 Trapani 18/-4 2,00 1.15/20 0.88/8 0.89/9 1.36/11   22/-15 2,95 0.90/20 1.38/8 1.00/10 0.80/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 Crotone 0-1 Trapani 28/6 2,78 1.56/18 1.25/8 2.00/9 1.11/9   19/-14 2,89 0.83/18 1.13/8 0.78/9 0.89/9
2018-10-21 Trapani 0-1 Perugia 17/-14 2,82 0.82/17 1.00/8 0.75/8 0.89/9   22/0 2,59 1.53/17 1.38/8 2.00/9 1.00/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