SELECT * FROM 1_Kampe WHERE LigaID = '120' AND (Home='Ternana' OR Away='Ternana') 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-09-03 Cittadella 2-0 Ternana 2/1 3,00 3.00/1 3.00/1 0.00/0 3.00/1   0/0 0,00 0.00/0 0.00/0 0.00/0 0.00/0
2016-09-07 Ternana 1-0 Pisa 0/-2 2,00 0.00/1 0.00/1 0.00/0 0.00/1   1/1 1,00 3.00/1 3.00/1 3.00/1 0.00/0
2016-09-11 Ternana 1-1 Spezia 1/-1 1,50 1.50/2 1.50/2 3.00/1 0.00/1   1/0 1,00 1.00/2 1.00/2 1.00/1 1.00/1
2016-09-17 Perugia 1-1 Ternana 2/-1 1,67 0.67/3 0.67/3 0.00/1 1.00/2   2/-1 1,67 1.33/3 1.33/3 2.00/2 0.00/1
2016-09-20 Ternana 0-0 Bari 3/-1 1,75 1.25/4 1.25/4 2.00/2 0.50/2   4/1 1,75 1.75/4 1.75/4 1.50/2 2.00/2
2016-09-24 Latina 1-1 Ternana 5/-4 2,80 0.60/5 0.60/5 1.00/2 0.33/3   3/-1 1,40 1.20/5 1.20/5 1.67/3 0.50/2
2016-10-01 Ternana 0-3 Verona 4/-1 1,50 1.17/6 1.17/6 1.67/3 0.67/3   13/7 3,17 2.17/6 2.17/6 3.00/3 1.33/3
2016-10-09 Pro Vercelli 1-0 Ternana 8/-5 3,00 0.86/7 0.86/7 1.33/3 0.50/4   4/-4 1,71 1.00/7 1.00/7 1.25/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 Ternana 1-1 Cesena 6/-5 1,89 0.89/9 1.00/8 1.25/4 0.60/5   7/0 1,40 1.20/10 1.00/8 1.67/6 0.50/4
2016-10-25 Avellino 1-0 Ternana 6/-7 1,90 0.90/10 1.00/8 1.60/5 0.20/5   7/-5 1,90 0.90/10 0.75/8 1.20/5 0.60/5
2016-10-29 Ternana 4-3 Novara 7/-6 1,82 0.82/11 0.63/8 1.20/5 0.50/6   10/-2 2,00 1.27/11 1.25/8 2.33/6 0.00/5
2016-11-07 Ternana 0-1 Benevento 11/-5 2,25 1.00/12 0.88/8 1.50/6 0.50/6   17/7 2,08 1.54/13 1.38/8 2.33/6 0.86/7
2016-11-13 Salernitana 4-2 Ternana 12/-2 2,00 1.00/13 1.25/8 1.50/6 0.57/7   11/-6 2,15 0.92/13 0.75/8 1.29/7 0.50/6
2016-11-19 Ternana 3-0 Entella 13/-8 2,43 0.86/14 0.63/8 1.29/7 0.43/7   22/8 2,57 1.64/14 1.88/8 2.43/7 0.86/7
2016-11-26 Frosinone 1-1 Ternana 22/7 2,31 1.94/16 2.75/8 2.38/8 1.50/8   16/-5 2,47 1.00/15 1.00/8 1.50/8 0.43/7
2016-12-03 Ternana 1-0 Brescia 17/-5 2,44 1.00/16 1.13/8 1.50/8 0.50/8   23/-4 2,94 1.29/17 1.25/8 1.89/9 0.63/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-10 AC Carpi 1-1 Ternana 18/4 1,88 1.59/17 1.38/8 1.63/8 1.56/9   19/-4 2,33 1.11/18 1.50/8 1.67/9 0.56/9
2016-12-17 Ternana 1-2 L.R. Vicenza 20/-4 2,32 1.11/19 1.50/8 1.67/9 0.60/10   12/-14 2,00 0.95/19 1.00/8 0.80/10 1.11/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-30 Ternana 0-1 Ascoli 21/-9 2,43 1.00/21 1.13/8 1.50/10 0.55/11   22/-1 2,14 1.29/21 1.25/8 1.20/10 1.36/11
2017-01-21 Pisa 1-0 Ternana 8/-5 0,95 1.00/22 0.75/8 1.50/10 0.58/12   21/-10 2,36 0.95/22 1.13/8 1.36/11 0.55/11
2017-01-28 Ternana 1-0 Cittadella 21/-11 2,30 0.91/23 0.75/8 1.36/11 0.50/12   33/5 2,65 1.61/23 1.13/8 2.00/12 1.18/11
2017-02-04 Spezia 2-0 Ternana 20/0 1,67 1.29/24 1.25/8 1.69/13 0.82/11   22/-10 2,25 1.00/24 1.00/8 1.50/12 0.50/12
2017-02-12 Ternana 0-1 Perugia 22/-12 2,24 0.96/25 0.63/8 1.50/12 0.46/13   32/5 2,36 1.40/25 1.25/8 1.54/13 1.25/12
2017-02-18 Bari 3-1 Ternana 27/3 1,96 1.42/26 1.38/8 2.00/14 0.75/12   22/-13 2,19 0.92/26 0.50/8 1.38/13 0.46/13
2017-02-25 Ternana 0-1 Latina 23/-15 2,26 0.89/27 0.38/8 1.38/13 0.43/14   27/-7 2,26 0.96/27 0.75/8 1.31/13 0.64/14
2017-02-28 Verona 2-0 Ternana 45/14 2,71 1.68/28 1.13/8 2.21/14 1.14/14   23/-16 2,21 0.86/28 0.38/8 1.29/14 0.43/14
2017-03-04 Ternana 1-2 Pro Vercelli 23/-18 2,21 0.83/29 0.38/8 1.29/14 0.40/15   25/-12 2,14 1.03/29 1.00/8 1.38/16 0.62/13
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-19 Cesena 1-0 Ternana 38/-1 2,41 1.16/32 1.25/8 1.67/15 0.71/17   26/-18 2,26 0.87/31 0.75/8 1.31/16 0.40/15
2017-03-26 Ternana 4-1 Avellino 26/-19 2,22 0.84/32 0.38/8 1.31/16 0.38/16   31/-11 2,28 1.19/32 1.50/8 1.63/16 0.75/16
2017-04-01 Novara 1-2 Ternana 38/4 2,18 1.48/33 2.00/8 2.06/17 0.88/16   30/-16 2,30 0.91/33 0.75/8 1.41/17 0.38/16
2017-04-04 Benevento 2-1 Ternana 49/16 2,34 1.60/35 1.00/8 2.11/18 1.06/17   32/-15 2,32 0.97/34 1.13/8 1.41/17 0.53/17
2017-04-08 Ternana 1-0 Salernitana 33/-16 2,34 0.94/35 1.13/8 1.41/17 0.50/18   38/2 2,11 1.31/35 1.75/8 1.56/18 1.06/17
2017-04-17 Entella 1-1 Ternana 51/9 2,51 1.43/37 1.50/8 2.22/18 0.68/19   34/-15 2,31 1.00/36 1.50/8 1.50/18 0.50/18
2017-04-22 Ternana 2-0 Frosinone 35/-15 2,30 1.00/37 1.63/8 1.50/18 0.53/19   49/13 2,24 1.74/38 1.25/8 2.11/19 1.37/19
2017-04-25 Brescia 2-1 Ternana 42/-13 2,49 1.03/39 1.00/8 1.58/19 0.50/20   37/-13 2,29 1.05/38 2.00/8 1.58/19 0.53/19
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-04-29 Ternana 0-0 AC Carpi 38/-14 2,25 1.03/40 1.50/8 1.55/20 0.50/20   36/-3 1,97 1.42/38 1.38/8 1.58/19 1.26/19
2017-05-06 L.R. Vicenza 0-1 Ternana 33/-17 2,02 1.02/41 1.00/8 1.05/20 1.00/21   38/-14 2,20 1.02/41 1.50/8 1.52/21 0.50/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 Ascoli 1-2 Ternana 46/-3 2,21 1.21/43 1.38/8 1.19/21 1.23/22   41/-12 2,19 1.12/43 1.88/8 1.59/22 0.62/21