SELECT * FROM 1_Kampe WHERE LigaID = '117' AND (Home='Spezia' OR Away='Spezia') 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 Spezia 0-1 Venezia 52/14 2,65 1.65/34 1.88/8 1.94/17 1.35/17   32/-6 2,06 1.21/34 1.13/8 0.88/17 1.53/17
2018-10-21 Spezia 0-1 Livorno 18/-1 2,64 1.14/14 1.50/8 1.14/7 1.14/7   12/-7 2,21 0.79/14 0.88/8 1.29/7 0.29/7
2018-10-21 Cosenza 0-1 Spezia 14/-1 2,23 0.92/13 1.25/8 1.00/6 0.86/7   17/-1 2,69 1.15/13 1.38/8 1.14/7 1.17/6
2018-10-21 Spezia 0-1 Frosinone 15/-3 2,75 1.00/12 1.00/8 0.83/6 1.17/6   13/1 2,08 1.42/12 1.63/8 2.33/6 0.50/6
2018-10-21 Pisa 0-1 Spezia 14/0 2,55 1.18/11 0.75/8 1.60/5 0.83/6   13/-2 2,55 1.09/11 1.13/8 0.83/6 1.40/5
2018-10-21 Spezia 0-1 Chievo 13/-2 2,80 1.10/10 1.00/8 0.80/5 1.40/5   17/5 2,90 1.70/10 2.00/8 1.80/5 1.60/5
2018-10-21 Empoli 0-1 Spezia 13/4 2,44 1.78/9 1.63/8 2.50/4 1.20/5   12/-2 2,89 1.11/9 0.88/8 0.80/5 1.50/4
2018-10-21 Spezia 0-1 Juve Stabia 10/-4 3,00 0.88/8 0.88/8 0.25/4 1.50/4   8/-7 2,88 0.88/8 0.88/8 0.75/4 1.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 Spezia 0-1 Benevento 8/-4 3,33 0.67/6 0.67/6 0.33/3 1.00/3   9/6 2,00 2.00/6 2.00/6 2.33/3 1.67/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 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 Spezia 0-1 Perugia 4/1 2,33 1.00/3 1.00/3 0.00/1 1.50/2   3/2 1,33 2.33/3 2.33/3 2.00/2 3.00/1
2018-10-21 Pordenone 0-1 Spezia 5/1 4,50 1.50/2 1.50/2 3.00/1 0.00/1   4/2 3,00 1.50/2 1.50/2 0.00/1 3.00/1
2018-10-21 Spezia 0-1 Crotone 3/3 3,00 3.00/1 3.00/1 0.00/0 3.00/1   0/0 0,00 1.00/1 1.00/1 1.00/1 0.00/0
2018-10-21 Cittadella 0-1 Spezia 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 Salernitana 1-3 Spezia 52/4 2,70 1.41/37 1.13/8 2.00/18 0.84/19   52/13 2,46 1.57/37 1.38/8 1.79/19 1.33/18
2018-10-21 Spezia 1-3 Entella 52/13 2,53 1.58/36 1.63/8 1.83/18 1.33/18   44/-3 2,53 1.31/36 1.13/8 1.67/18 0.94/18
2018-10-21 Venezia 0-1 Spezia 16/-2 2,27 1.20/15 1.13/8 1.00/7 1.38/8   20/1 2,60 1.27/15 1.88/8 1.38/8 1.14/7
2018-10-21 Entella 0-1 Spezia 18/1 2,06 1.47/17 1.63/8 2.13/8 0.89/9   20/1 2,44 1.25/16 1.63/8 1.38/8 1.13/8
2018-10-21 Livorno 0-1 Spezia 27/-26 2,42 0.64/33 0.88/8 0.69/16 0.59/17   51/13 2,70 1.61/33 1.50/8 1.94/17 1.25/16
2018-10-21 Spezia 0-1 Cosenza 46/9 2,59 1.56/32 1.25/8 1.88/16 1.25/16   35/-4 2,31 0.97/32 1.00/8 0.88/16 1.06/16
2018-10-21 Frosinone 0-1 Spezia 33/6 1,94 1.55/31 1.38/8 2.00/15 1.13/16   45/10 2,58 1.61/31 1.63/8 1.88/16 1.33/15
2018-10-21 Spezia 0-1 Pisa 44/11 2,57 1.67/30 2.00/8 2.00/15 1.33/15   38/1 2,50 1.33/30 1.38/8 1.63/16 1.00/14
2018-10-21 Chievo 0-1 Spezia 35/7 2,17 1.45/29 1.50/8 1.71/14 1.20/15   41/9 2,52 1.62/29 2.00/8 2.00/15 1.21/14
2018-10-21 Spezia 0-1 Empoli 40/8 2,57 1.57/28 2.00/8 1.93/14 1.21/14   33/-1 2,39 1.43/28 2.13/8 1.67/15 1.15/13
2018-10-21 Juve Stabia 0-1 Spezia 32/-10 2,74 1.22/27 1.13/8 1.64/14 0.77/13   39/10 2,52 1.63/27 2.38/8 1.93/14 1.31/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 Benevento 0-1 Spezia 45/32 2,32 2.40/25 2.50/8 2.54/13 2.25/12   36/10 2,48 1.64/25 2.50/8 1.85/13 1.42/12
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 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 Spezia 0-1 Cremonese 29/7 2,32 1.55/22 2.25/8 1.64/11 1.45/11   17/-9 1,95 1.05/22 0.75/8 1.45/11 0.64/11
2018-10-21 Perugia 0-1 Spezia 27/-1 2,50 1.50/22 1.38/8 1.91/11 1.09/11   26/4 2,29 1.48/21 2.00/8 1.64/11 1.30/10
2018-10-21 Spezia 0-1 Pordenone 25/3 2,35 1.40/20 2.00/8 1.50/10 1.30/10   29/2 2,67 1.67/21 1.63/8 2.36/11 0.90/10
2018-10-21 Crotone 0-1 Spezia 32/10 2,70 1.70/20 1.63/8 2.10/10 1.30/10   23/2 2,32 1.32/19 1.63/8 1.50/10 1.11/9
2018-10-21 Spezia 0-1 Cittadella 22/2 2,33 1.33/18 1.63/8 1.56/9 1.11/9   22/-1 2,37 1.53/19 1.50/8 1.50/10 1.56/9
2018-10-21 Spezia 0-1 Salernitana 20/1 2,29 1.24/17 1.38/8 1.38/8 1.11/9   26/3 2,72 1.44/18 1.38/8 1.78/9 1.11/9
2018-10-21 Cremonese 1-3 Spezia 38/-2 2,23 1.26/35 1.75/8 1.47/17 1.06/18   52/13 2,60 1.60/35 1.50/8 1.83/18 1.35/17