SELECT * FROM 1_Kampe WHERE LigaID = '117' AND (Home='Cremonese' OR Away='Cremonese') 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 Perugia 0-1 Cremonese 34/-10 2,29 1.21/34 1.00/8 1.47/17 0.94/17   38/-2 2,29 1.26/34 2.00/8 1.47/17 1.06/17
2018-10-21 Chievo 0-1 Cremonese 19/3 2,50 1.50/14 1.75/8 2.00/6 1.13/8   10/-6 1,86 1.21/14 0.88/8 1.57/7 0.86/7
2018-10-21 Cremonese 0-1 Livorno 10/-6 2,00 1.23/13 1.13/8 1.67/6 0.86/7   12/-7 2,38 0.77/13 0.75/8 1.29/7 0.17/6
2018-10-21 Pescara 0-1 Cremonese 22/5 3,25 1.58/12 1.50/8 1.67/6 1.50/6   9/-6 2,00 1.25/12 1.13/8 1.67/6 0.83/6
2018-10-21 Cremonese 0-1 Salernitana 8/-7 2,09 1.09/11 1.13/8 1.40/5 0.83/6   14/2 2,36 1.64/11 1.50/8 1.50/6 1.80/5
2018-10-21 Cosenza 0-1 Cremonese 8/-2 1,80 0.80/10 0.88/8 0.60/5 1.00/5   8/-5 2,10 1.20/10 1.13/8 1.40/5 1.00/5
2018-10-21 Benevento 0-1 Cremonese 11/4 2,00 2.00/9 2.13/8 2.50/4 1.60/5   8/-3 2,11 1.33/9 1.13/8 1.40/5 1.25/4
2018-10-21 Cremonese 0-1 Frosinone 7/-3 2,13 1.38/8 1.38/8 1.50/4 1.25/4   7/-4 2,25 1.13/8 1.13/8 2.00/4 0.25/4
2018-10-21 Empoli 0-1 Cremonese 10/4 2,29 2.00/7 2.00/7 3.00/3 1.25/4   6/-3 2,14 1.43/7 1.43/7 1.50/4 1.33/3
2018-10-21 Cremonese 0-1 Cittadella 6/-1 2,17 1.67/6 1.67/6 2.00/3 1.33/3   6/-3 2,50 1.50/6 1.50/6 2.00/3 1.00/3
2018-10-21 Cremonese 0-1 Ascoli 5/-2 2,40 1.40/5 1.40/5 1.50/2 1.33/3   14/10 3,60 2.40/5 2.40/5 3.00/3 1.50/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 Cremonese 0-1 Crotone 3/-3 3,00 1.00/3 1.00/3 0.00/1 1.50/2   2/1 1,00 1.67/3 1.67/3 1.00/2 3.00/1
2018-10-21 Pisa 0-1 Cremonese 2/2 1,00 2.00/2 2.00/2 1.00/1 3.00/1   2/0 2,00 1.50/2 1.50/2 0.00/1 3.00/1
2018-10-21 Cremonese 0-1 Entella 2/1 3,00 3.00/1 3.00/1 0.00/0 3.00/1   1/1 1,00 3.00/1 3.00/1 3.00/1 0.00/0
2018-10-21 Venezia 0-1 Cremonese 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 Cremonese 1-3 Pordenone 40/-1 2,19 1.30/37 1.88/8 1.44/18 1.16/19   46/2 2,43 1.54/37 1.38/8 2.00/19 1.06/18
2018-10-21 Juve Stabia 1-3 Cremonese 45/-13 2,86 1.14/36 0.63/8 1.67/18 0.61/18   38/-2 2,17 1.25/36 1.50/8 1.44/18 1.06/18
2018-10-21 Cremonese 0-1 Perugia 10/-7 1,80 1.13/15 0.88/8 1.57/7 0.75/8   19/-1 2,60 1.53/15 1.13/8 1.88/8 1.14/7
2018-10-21 Cremonese 0-1 Juve Stabia 12/-6 1,88 1.25/16 1.13/8 1.75/8 0.75/8   19/-8 2,71 1.18/17 1.63/8 1.44/9 0.88/8
2018-10-21 Cremonese 0-1 Chievo 37/-3 2,33 1.21/33 1.63/8 1.38/16 1.06/17   40/7 2,21 1.42/33 1.25/8 1.65/17 1.19/16
2018-10-21 Livorno 0-1 Cremonese 26/-25 2,41 0.66/32 0.88/8 0.73/15 0.59/17   35/-4 2,31 1.16/32 1.38/8 1.38/16 0.94/16
2018-10-21 Cremonese 0-1 Pescara 34/-5 2,35 1.10/31 1.38/8 1.27/15 0.94/16   43/-5 2,94 1.26/31 0.88/8 1.50/16 1.00/15
2018-10-21 Salernitana 0-1 Cremonese 37/3 2,37 1.43/30 1.25/8 2.07/14 0.88/16   31/-5 2,23 1.10/30 1.25/8 1.27/15 0.93/15
2018-10-21 Cremonese 0-1 Cosenza 31/-3 2,24 1.14/29 1.25/8 1.36/14 0.93/15   31/-5 2,31 0.93/29 0.88/8 0.93/14 0.93/15
2018-10-21 Cremonese 0-1 Benevento 31/-2 2,29 1.18/28 1.25/8 1.46/13 0.93/15   54/39 2,46 2.46/28 2.75/8 2.60/15 2.31/13
2018-10-21 Frosinone 0-1 Cremonese 33/12 2,00 1.74/27 2.50/8 2.31/13 1.21/14   26/-6 2,23 1.04/26 0.75/8 1.46/13 0.62/13
2018-10-21 Cremonese 0-1 Empoli 24/-5 2,12 1.08/25 0.75/8 1.58/12 0.62/13   29/-2 2,31 1.38/26 1.75/8 1.71/14 1.00/12
2018-10-21 Cittadella 0-1 Cremonese 33/4 2,48 1.56/25 1.63/8 1.38/13 1.75/12   24/-5 2,21 1.08/24 0.75/8 1.58/12 0.58/12
2018-10-21 Ascoli 0-1 Cremonese 36/-5 2,85 1.19/27 0.63/8 2.00/12 0.53/15   28/-4 2,22 1.11/27 1.00/8 1.46/13 0.79/14
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 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 Crotone 0-1 Cremonese 34/7 2,77 1.55/22 1.50/8 1.91/11 1.18/11   17/-8 2,00 1.10/21 0.88/8 1.45/11 0.70/10
2018-10-21 Cremonese 0-1 Pisa 14/-7 1,75 1.15/20 1.00/8 1.60/10 0.70/10   26/0 2,48 1.24/21 1.13/8 1.45/11 1.00/10
2018-10-21 Entella 0-1 Cremonese 25/3 2,35 1.50/20 1.75/8 2.00/9 1.09/11   13/-7 1,74 1.16/19 1.25/8 1.60/10 0.67/9
2018-10-21 Cremonese 0-1 Venezia 13/-7 1,83 1.17/18 1.13/8 1.67/9 0.67/9   18/-4 2,11 1.16/19 1.13/8 0.89/9 1.40/10
2018-10-21 Pordenone 0-1 Cremonese 26/3 2,72 1.72/18 2.00/8 2.56/9 0.89/9   13/-6 1,88 1.24/17 1.13/8 1.67/9 0.75/8
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