SELECT * FROM 1_Kampe WHERE LigaID = '120' AND (Home='Spal' OR Away='Spal') 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-27 Benevento 2-0 Spal 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 Spal 3-0 L.R. Vicenza 0/-2 2,00 0.00/1 0.00/1 0.00/0 0.00/1   0/-4 2,00 0.00/2 0.00/2 0.00/2 0.00/0
2016-09-10 Ascoli 1-1 Spal 1/0 2,00 1.00/1 1.00/1 0.00/0 1.00/1   3/1 2,50 1.50/2 1.50/2 3.00/1 0.00/1
2016-09-17 Spal 2-2 Entella 4/1 2,33 1.33/3 1.33/3 3.00/1 0.50/2   2/0 1,33 1.33/3 1.33/3 2.00/2 0.00/1
2016-09-20 Spal 1-3 Verona 6/1 2,75 1.25/4 1.25/4 2.00/2 0.50/2   8/3 3,25 1.75/4 1.75/4 3.00/2 0.50/2
2016-09-26 Perugia 1-0 Spal 4/-2 2,00 0.60/5 0.60/5 0.50/2 0.67/3   7/-1 3,00 1.00/5 1.00/5 1.33/3 0.50/2
2016-10-01 Spal 3-2 Salernitana 7/-2 2,67 0.83/6 0.83/6 1.33/3 0.33/3   6/0 2,00 1.00/6 1.00/6 1.33/3 0.67/3
2016-10-09 Pisa 0-1 Spal 6/2 1,25 1.63/8 1.63/8 3.00/3 0.80/5   10/-1 3,00 1.14/7 1.14/7 1.75/4 0.33/3
2016-10-14 Cesena 1-1 Spal 6/0 1,33 1.22/9 1.25/8 1.80/5 0.50/4   11/0 2,75 1.38/8 1.38/8 1.75/4 1.00/4
2016-10-22 Spal 3-1 AC Carpi 12/0 2,67 1.33/9 1.50/8 1.75/4 1.00/5   11/5 1,89 1.78/9 1.63/8 1.80/5 1.75/4
2016-10-22 Spal 3-1 Carpi 15/2 2,80 1.50/10 1.75/8 2.00/5 1.00/5   11/5 1,89 1.78/9 1.63/8 1.80/5 1.75/4
2016-10-25 Frosinone 2-1 Spal 12/1 2,09 1.45/11 1.25/8 2.00/5 1.00/6   18/4 2,91 1.64/11 1.75/8 2.17/6 1.00/5
2016-10-31 Spal 3-0 Avellino 19/3 2,92 1.50/12 1.63/8 2.17/6 0.83/6   7/-6 1,82 1.09/11 1.25/8 1.83/6 0.20/5
2016-11-05 Novara 0-1 Spal 13/-3 2,42 1.17/12 1.25/8 2.33/6 0.00/6   22/6 2,92 1.62/13 2.00/8 2.29/7 0.83/6
2016-11-12 Spal 3-2 Brescia 23/7 2,79 1.71/14 2.38/8 2.29/7 1.14/7   20/0 2,86 1.36/14 1.50/8 1.75/8 0.83/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 Spal 0-0 Latina 27/8 2,88 1.75/16 2.13/8 2.38/8 1.13/8   17/-5 2,44 1.06/16 1.13/8 1.57/7 0.67/9
2016-12-03 Cittadella 1-2 Spal 27/7 2,76 1.65/17 1.25/8 1.88/8 1.44/9   27/8 2,71 1.71/17 2.13/8 2.22/9 1.13/8
2016-12-10 Spal 2-1 Spezia 29/9 2,72 1.78/18 2.13/8 2.22/9 1.33/9   14/0 1,56 1.28/18 1.25/8 1.50/10 1.00/8
2016-12-17 Pro Vercelli 3-1 Spal 14/-9 1,95 1.00/19 0.75/8 1.50/10 0.44/9   31/10 2,74 1.84/19 2.13/8 2.30/10 1.33/9
2016-12-24 Spal 4-0 Ternana 32/8 2,80 1.75/20 2.13/8 2.30/10 1.20/10   21/-5 2,35 1.05/20 1.13/8 1.50/10 0.60/10
2016-12-29 Bari 1-1 Spal 23/4 2,00 1.48/21 1.88/8 2.09/11 0.80/10   36/12 2,86 1.81/21 2.13/8 2.36/11 1.20/10
2017-01-21 Spal 2-0 Benevento 37/12 2,82 1.77/22 1.88/8 2.36/11 1.18/11   29/14 2,00 1.73/22 1.88/8 2.45/11 1.00/11
2017-01-28 L.R. Vicenza 1-1 Spal 16/-11 1,79 1.13/24 1.63/8 1.00/11 1.23/13   39/14 2,78 1.83/23 1.88/8 2.42/12 1.18/11
2017-02-04 Spal 1-1 Ascoli 40/14 2,75 1.79/24 1.88/8 2.42/12 1.17/12   25/0 2,17 1.35/23 1.63/8 1.20/10 1.46/13
2017-02-11 Entella 0-3 Spal 37/6 2,72 1.36/25 1.13/8 2.27/11 0.64/14   41/14 2,72 1.76/25 1.88/8 2.31/13 1.17/12
2017-02-20 Verona 0-0 Spal 45/15 2,88 1.77/26 1.50/8 2.31/13 1.23/13   44/17 2,73 1.81/26 1.88/8 2.31/13 1.31/13
2017-02-25 Spal 2-0 Perugia 44/17 2,63 1.78/27 1.63/8 2.31/13 1.29/14   33/6 2,22 1.44/27 1.25/8 1.50/14 1.38/13
2017-02-28 Salernitana 1-2 Spal 30/-3 2,25 1.14/28 1.38/8 1.50/14 0.79/14   46/19 2,61 1.82/28 2.00/8 2.36/14 1.29/14
2017-03-04 Spal 1-1 Pisa 48/20 2,62 1.86/29 2.00/8 2.36/14 1.40/15   16/-2 1,13 1.13/30 1.50/8 1.47/15 0.80/15
2017-03-11 Spal 2-0 Cesena 49/20 2,60 1.83/30 2.00/8 2.27/15 1.40/15   38/1 2,42 1.19/31 1.38/8 1.67/15 0.75/16
2017-03-18 Carpi 1-4 Spal 28/0 1,87 1.43/30 1.25/8 1.57/14 1.31/16   51/22 2,58 1.87/31 2.00/8 2.31/16 1.40/15
2017-03-18 AC Carpi 1-4 Spal 28/0 1,87 1.43/30 1.25/8 1.57/14 1.31/16   55/25 2,66 1.91/32 2.50/8 2.31/16 1.50/16
2017-03-26 Spal 0-2 Frosinone 59/28 2,73 1.94/33 2.50/8 2.31/16 1.59/17   42/12 2,18 1.82/33 1.88/8 2.29/17 1.31/16
2017-03-31 Avellino 1-0 Spal 32/-14 2,36 1.15/33 1.38/8 1.63/16 0.71/17   59/26 2,71 1.88/34 2.13/8 2.18/17 1.59/17
2017-04-04 Spal 2-0 Novara 59/25 2,66 1.83/35 2.00/8 2.18/17 1.50/18   39/3 2,21 1.44/34 1.88/8 1.94/18 0.88/16
2017-04-09 Brescia 1-3 Spal 40/-12 2,56 1.00/36 0.88/8 1.59/17 0.47/19   61/27 2,64 1.86/36 2.00/8 2.22/18 1.50/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 Latina 1-2 Spal 32/-14 2,05 0.87/38 0.25/8 1.00/19 0.74/19   66/30 2,68 1.92/38 2.25/8 2.26/19 1.58/19
2017-04-25 Spal 2-1 Cittadella 68/31 2,69 1.95/39 2.25/8 2.26/19 1.65/20   54/7 2,59 1.54/39 2.00/8 2.05/20 1.00/19
2017-04-29 Spezia 0-0 Spal 37/1 1,83 1.35/40 1.25/8 1.90/20 0.80/20   70/32 2,70 1.98/40 2.25/8 2.30/20 1.65/20
2017-05-07 Spal 0-0 Pro Vercelli 70/32 2,63 1.95/41 2.00/8 2.30/20 1.62/21   32/-9 1,78 1.20/41 1.63/8 1.43/21 0.95/20
2017-05-13 Ternana 2-1 Spal 39/-13 2,17 1.07/42 1.50/8 1.52/21 0.62/21   70/32 2,57 1.93/42 2.13/8 2.24/21 1.62/21
2017-05-18 Spal 2-1 Bari 71/31 2,58 1.88/43 2.13/8 2.24/21 1.55/22   40/-4 1,95 1.30/43 0.38/8 1.91/22 0.67/21