SELECT * FROM 1_Kampe WHERE LigaID = '120' AND (Home='Carpi' OR Away='Carpi') 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 L.R. Vicenza 0-2 Carpi 0/-2 2,00 0.00/1 0.00/2 0.00/1 0.00/0   0/0 0,00 0.00/0 0.00/0 0.00/0 0.00/0
2016-09-04 Carpi 1-1 Benevento 2/2 2,00 3.00/1 3.00/1 0.00/0 3.00/1   3/2 2,00 2.00/2 1.67/3 3.00/1 1.00/1
2016-09-09 Cesena 1-0 Carpi 2/1 1,50 2.00/2 2.33/3 2.00/2 0.00/0   3/2 2,00 2.00/2 2.00/2 1.00/1 3.00/1
2016-09-16 Carpi 0-0 Frosinone 3/1 1,67 1.33/3 1.33/3 1.00/1 1.50/2   4/1 1,75 1.75/4 1.60/5 3.00/2 0.50/2
2016-09-20 Brescia 2-2 Carpi 6/1 2,20 1.20/5 1.17/6 1.67/3 0.50/2   3/1 1,25 1.25/4 1.25/4 1.00/2 1.50/2
2016-09-24 Carpi 2-1 Entella 5/1 1,80 1.20/5 1.20/5 1.00/2 1.33/3   6/1 2,20 1.60/5 1.60/5 2.33/3 0.50/2
2016-10-03 Carpi 1-1 Pisa 7/2 2,00 1.50/6 1.50/6 1.67/3 1.33/3   4/2 1,00 1.83/6 1.83/6 3.00/3 0.67/3
2016-10-09 Spezia 0-1 Carpi 7/4 1,43 1.86/7 1.86/7 2.33/3 1.50/4   8/2 2,00 1.43/7 1.43/7 1.50/4 1.33/3
2016-10-15 Carpi 2-0 Latina 9/3 1,88 1.63/8 1.63/8 1.50/4 1.75/4   10/-2 2,75 1.00/8 1.00/8 1.50/4 0.50/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 Perugia 0-2 Carpi 12/5 1,90 1.60/10 1.88/8 2.00/5 1.20/5   12/3 2,10 1.60/10 1.50/8 1.80/5 1.40/5
2016-10-29 Carpi 0-2 Ascoli 14/5 2,09 1.73/11 1.88/8 1.80/5 1.67/6   8/-4 1,82 1.00/11 1.00/8 1.00/6 1.00/5
2016-11-05 Pro Vercelli 0-0 Carpi 12/-8 2,67 1.08/12 1.38/8 1.83/6 0.33/6   14/3 2,08 1.58/12 1.75/8 1.50/6 1.67/6
2016-11-13 Carpi 1-1 Avellino 14/3 1,92 1.54/13 1.75/8 1.50/6 1.57/7   7/-10 1,85 0.92/13 1.25/8 1.57/7 0.17/6
2016-11-19 Bari 2-0 Carpi 14/-2 2,14 1.21/14 1.13/8 1.57/7 0.86/7   15/3 1,93 1.50/14 1.50/8 1.43/7 1.57/7
2016-11-26 Carpi 2-0 Cittadella 15/1 1,93 1.40/15 1.38/8 1.43/7 1.38/8   27/11 2,87 1.87/15 1.25/8 1.88/8 1.86/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-10 Carpi 1-1 Ternana 18/4 1,88 1.59/17 1.38/8 1.63/8 1.56/9   18/-4 2,35 1.12/17 1.38/8 1.67/9 0.50/8
2016-12-17 Salernitana 1-2 Carpi 21/0 2,33 1.17/18 1.25/8 1.63/8 0.80/10   19/4 1,89 1.56/18 1.50/8 1.56/9 1.56/9
2016-12-24 Carpi 1-1 Verona 21/5 1,95 1.63/19 1.50/8 1.56/9 1.70/10   37/14 3,00 1.90/20 1.13/8 2.30/10 1.50/10
2016-12-30 Novara 2-1 Carpi 26/0 2,48 1.33/21 1.75/8 2.09/11 0.50/10   22/5 1,95 1.60/20 1.63/8 1.50/10 1.70/10
2017-01-21 Carpi 0-0 L.R. Vicenza 23/4 2,00 1.52/21 1.50/8 1.50/10 1.55/11   16/-11 1,87 1.13/23 1.63/8 1.00/11 1.25/12
2017-01-28 Benevento 3-0 Carpi 32/15 2,04 1.71/24 1.75/8 2.50/12 0.92/12   23/4 1,91 1.50/22 1.50/8 1.45/11 1.55/11
2017-02-05 Carpi 1-2 Cesena 23/1 1,96 1.43/23 1.50/8 1.45/11 1.42/12   31/1 2,44 1.20/25 1.75/8 1.92/12 0.54/13
2017-02-11 Frosinone 1-0 Carpi 34/8 2,40 1.80/25 1.63/8 2.17/12 1.46/13   24/0 2,00 1.38/24 1.13/8 1.33/12 1.42/12
2017-02-18 Carpi 2-1 Brescia 24/-1 1,96 1.32/25 0.75/8 1.33/12 1.31/13   29/-8 2,54 1.12/26 0.88/8 1.69/13 0.54/13
2017-02-25 Entella 2-0 Carpi 37/3 2,63 1.30/27 1.13/8 2.08/12 0.67/15   26/0 2,00 1.38/26 1.00/8 1.46/13 1.31/13
2017-02-28 Pisa 0-0 Carpi 16/-2 1,21 1.14/28 1.38/8 1.54/13 0.80/15   26/-2 2,00 1.33/27 0.63/8 1.46/13 1.21/14
2017-03-04 Carpi 1-0 Spezia 26/-2 1,93 1.32/28 0.63/8 1.46/13 1.20/15   29/4 1,86 1.41/29 1.75/8 1.81/16 0.92/13
2017-03-11 Latina 0-1 Carpi 30/-6 2,20 1.03/30 1.00/8 1.29/14 0.81/16   27/-1 1,90 1.38/29 1.00/8 1.57/14 1.20/15
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-26 Carpi 0-0 Perugia 29/-3 1,97 1.39/31 1.25/8 1.47/15 1.31/16   43/11 2,27 1.45/33 1.38/8 1.56/16 1.35/17
2017-04-01 Ascoli 1-2 Carpi 38/-3 2,39 1.24/33 1.00/8 1.27/15 1.22/18   29/-3 1,91 1.38/32 1.38/8 1.44/16 1.31/16
2017-04-04 Carpi 0-0 Pro Vercelli 31/-2 1,94 1.42/33 1.75/8 1.44/16 1.41/17   29/-10 2,00 1.15/34 1.63/8 1.44/18 0.81/16
2017-04-08 Avellino 1-0 Carpi 34/-13 2,31 1.20/35 1.13/8 1.71/17 0.72/18   31/-2 1,88 1.41/34 1.50/8 1.41/17 1.41/17
2017-04-17 Carpi 2-0 Bari 31/-3 1,86 1.37/35 1.50/8 1.41/17 1.33/18   39/3 2,08 1.47/36 1.25/8 2.16/19 0.71/17
2017-04-22 Cittadella 4-1 Carpi 50/4 2,53 1.50/38 2.00/8 2.00/19 1.00/19   33/-1 1,86 1.42/36 1.75/8 1.50/18 1.33/18
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-29 Ternana 0-0 Carpi 38/-14 2,31 1.03/39 1.63/8 1.58/19 0.50/20   36/-3 1,97 1.42/38 1.38/8 1.58/19 1.26/19
2017-05-06 Carpi 2-0 Salernitana 36/-3 1,92 1.41/39 1.50/8 1.58/19 1.25/20   41/0 2,05 1.28/40 1.50/8 1.52/21 1.00/19
2017-05-13 Verona 1-1 Carpi 64/24 2,54 1.78/41 2.13/8 2.10/20 1.48/21   38/-1 1,93 1.45/40 1.75/8 1.65/20 1.25/20
2017-05-18 Carpi 2-0 Novara 39/-1 1,93 1.44/41 1.50/8 1.65/20 1.24/21   50/1 2,36 1.40/42 1.25/8 1.77/22 1.00/20