SELECT * FROM 1_Kampe WHERE LigaID = '120' 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
2016-08-28 Novara 2-2 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
2016-09-04 Trapani 1-1 Pro Vercelli 2/0 4,00 1.00/1 1.00/1 0.00/0 1.00/1   1/0 2,00 1.00/1 1.00/1 1.00/1 0.00/0
2016-09-10 Avellino 0-0 Trapani 1/-2 2,00 0.50/2 0.50/2 1.00/1 0.00/1   3/0 3,00 1.00/2 1.00/2 1.00/1 1.00/1
2016-09-17 Trapani 1-1 Ascoli 3/0 2,00 1.00/3 1.00/3 1.00/1 1.00/2   2/0 2,00 1.00/2 1.00/2 1.00/1 1.00/1
2016-09-20 Trapani 0-0 Spezia 4/0 2,00 1.00/4 1.00/4 1.00/2 1.00/2   4/1 1,75 1.50/4 1.50/4 2.00/2 1.00/2
2016-09-24 Salernitana 2-0 Trapani 4/-2 2,00 0.60/5 0.60/5 0.50/2 0.67/3   4/0 1,60 1.00/5 1.00/5 1.00/3 1.00/2
2016-10-01 Trapani 0-2 Cittadella 4/-2 1,67 0.83/6 0.83/6 1.00/3 0.67/3   13/7 3,17 2.50/6 2.50/6 2.00/3 3.00/3
2016-10-09 Latina 2-0 Trapani 8/-4 2,86 0.71/7 0.71/7 1.00/3 0.50/4   4/-4 1,71 0.71/7 0.71/7 0.75/4 0.67/3
2016-10-17 Trapani 2-2 Ternana 4/-6 1,75 0.63/8 0.63/8 0.75/4 0.50/4   4/-5 1,63 0.88/8 0.88/8 1.25/4 0.50/4
2016-10-22 Bari 3-0 Trapani 7/-5 2,11 1.11/9 1.25/8 1.00/4 1.20/5   6/-6 2,00 0.67/9 0.63/8 0.80/5 0.50/4
2016-10-25 Trapani 1-0 Benevento 6/-9 2,10 0.60/10 0.50/8 0.80/5 0.40/5   16/7 2,27 1.55/11 1.50/8 2.20/5 1.00/6
2016-10-30 Verona 2-0 Trapani 25/16 3,09 2.18/11 2.50/8 2.60/5 1.83/6   7/-8 2,00 0.82/11 0.75/8 1.17/6 0.40/5
2016-11-05 Trapani 0-1 L.R. Vicenza 7/-10 2,00 0.75/12 0.63/8 1.17/6 0.33/6   8/-14 2,31 0.77/13 0.75/8 0.57/7 1.00/6
2016-11-13 Perugia 1-1 Trapani 17/5 2,07 1.57/14 2.00/8 1.43/7 1.71/7   7/-11 1,92 0.69/13 0.50/8 1.00/7 0.33/6
2016-11-21 Trapani 1-1 Spal 8/-11 1,93 0.71/14 0.63/8 1.00/7 0.43/7   26/8 2,93 1.80/15 2.38/8 2.38/8 1.14/7
2016-11-26 Pisa 1-0 Trapani 7/-4 1,13 1.00/16 0.38/8 1.43/7 0.67/9   9/-11 1,93 0.73/15 0.75/8 1.00/8 0.43/7
2016-12-02 Trapani 0-1 Carpi 9/-12 1,88 0.69/16 0.75/8 1.00/8 0.38/8   17/3 1,94 1.50/16 1.38/8 1.63/8 1.38/8
2016-12-02 Trapani 0-1 AC Carpi 9/-13 1,82 0.65/17 0.63/8 0.89/9 0.38/8   17/3 1,94 1.50/16 1.38/8 1.63/8 1.38/8
2016-12-10 Entella 2-2 Trapani 24/5 2,53 1.47/17 1.63/8 2.25/8 0.78/9   9/-14 1,78 0.61/18 0.63/8 0.80/10 0.38/8
2016-12-16 Trapani 1-4 Frosinone 11/-14 1,89 0.63/19 0.38/8 0.80/10 0.44/9   24/5 2,26 1.74/19 2.13/8 2.00/10 1.44/9
2016-12-24 Cesena 3-1 Trapani 21/1 2,05 1.10/20 1.13/8 1.90/10 0.30/10   12/-17 2,05 0.60/20 0.38/8 0.73/11 0.44/9
2016-12-30 Trapani 0-0 Brescia 13/-19 2,14 0.57/21 0.38/8 0.73/11 0.40/10   26/-4 2,67 1.29/21 1.38/8 1.91/11 0.60/10
2017-01-21 Trapani 2-1 Novara 13/-19 2,05 0.59/22 0.38/8 0.75/12 0.40/10   28/1 2,50 1.41/22 1.75/8 2.17/12 0.50/10
2017-01-28 Pro Vercelli 1-3 Trapani 20/-6 2,09 1.14/22 1.25/8 1.75/12 0.40/10   15/-18 2,09 0.70/23 0.63/8 0.92/13 0.40/10
2017-02-06 Trapani 0-0 Avellino 18/-16 2,17 0.79/24 1.00/8 0.92/13 0.64/11   20/-11 2,13 1.08/24 1.13/8 1.58/12 0.58/12
2017-02-11 Ascoli 2-2 Trapani 26/0 2,17 1.33/24 1.75/8 1.20/10 1.43/14   18/-16 2,08 0.80/25 1.13/8 0.93/14 0.64/11
2017-02-18 Spezia 2-2 Trapani 24/4 1,69 1.42/26 1.75/8 1.79/14 1.00/12   20/-16 2,15 0.81/26 1.25/8 0.93/14 0.67/12
2017-02-25 Trapani 1-0 Salernitana 22/-16 2,22 0.81/27 1.25/8 0.93/14 0.69/13   30/-2 2,30 1.19/27 1.38/8 1.50/14 0.85/13
2017-02-28 Cittadella 3-2 Trapani 36/-1 2,61 1.39/28 1.00/8 1.79/14 1.00/14   23/-15 2,18 0.89/28 1.63/8 1.07/15 0.69/13
2017-03-04 Trapani 1-1 Latina 25/-16 2,28 0.86/29 1.63/8 1.07/15 0.64/14   29/-6 2,21 1.03/29 1.00/8 1.29/14 0.80/15
2017-03-12 Ternana 2-1 Trapani 24/-19 2,23 0.80/30 0.38/8 1.20/15 0.40/15   26/-16 2,27 0.87/30 1.63/8 1.06/16 0.64/14
2017-03-18 Trapani 4-0 Bari 27/-17 2,29 0.84/31 1.25/8 1.06/16 0.60/15   37/7 2,16 1.58/31 2.13/8 2.18/17 0.86/14
2017-03-25 Benevento 1-3 Trapani 45/16 2,24 1.61/33 1.13/8 2.24/17 0.94/16   31/-13 2,34 0.91/32 1.25/8 1.18/17 0.60/15
2017-04-01 Trapani 0-2 Verona 34/-11 2,39 0.97/33 1.50/8 1.18/17 0.75/16   50/17 2,52 1.70/33 1.25/8 2.12/17 1.25/16
2017-04-04 L.R. Vicenza 0-1 Trapani 27/-17 2,03 1.00/35 0.88/8 1.06/17 0.94/18   34/-13 2,38 0.94/34 1.38/8 1.11/18 0.75/16
2017-04-08 Trapani 3-0 Perugia 35/-12 2,34 1.00/35 1.63/8 1.11/18 0.88/17   46/12 2,22 1.47/36 1.75/8 1.61/18 1.33/18
2017-04-17 Spal 2-1 Trapani 64/29 2,68 1.89/37 2.00/8 2.22/18 1.58/19   38/-9 2,36 1.06/36 1.63/8 1.21/19 0.88/17
2017-04-22 Trapani 1-0 Pisa 39/-10 2,38 1.03/37 1.63/8 1.21/19 0.83/18   22/-6 1,32 1.00/38 0.50/8 1.21/19 0.79/19
2017-04-25 Carpi 2-1 Trapani 34/-4 1,95 1.38/37 1.38/8 1.50/18 1.26/19   40/-9 2,34 1.08/38 1.88/8 1.30/20 0.83/18
2017-04-25 AC Carpi 2-1 Trapani 34/-4 1,95 1.38/37 1.38/8 1.50/18 1.26/19   41/-10 2,36 1.05/39 1.50/8 1.30/20 0.79/19
2017-04-29 Trapani 2-0 Entella 42/-11 2,38 1.03/40 1.50/8 1.30/20 0.75/20   52/6 2,45 1.35/40 1.00/8 2.05/20 0.65/20
2017-05-06 Frosinone 1-0 Trapani 54/15 2,27 1.76/41 1.50/8 2.15/20 1.38/21   44/-9 2,37 1.07/41 1.50/8 1.38/21 0.75/20
2017-05-13 Trapani 1-2 Cesena 44/-10 2,33 1.05/42 1.50/8 1.38/21 0.71/21   52/4 2,38 1.31/42 1.88/8 1.71/21 0.90/21
2017-05-18 Brescia 2-1 Trapani 50/-11 2,58 1.12/43 1.63/8 1.62/21 0.64/22   45/-11 2,35 1.02/43 1.13/8 1.32/22 0.71/21