SELECT * FROM 1_Kampe WHERE LigaID = '121' 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
2015-09-06 Trapani 3-0 Ternana 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
2015-09-12 Ternana 1-1 Cagliari 0/-3 3,00 0.00/1 0.00/1 0.00/0 0.00/1   4/4 4,00 3.00/1 3.00/1 3.00/1 0.00/0
2015-09-18 Modena 1-0 Ternana 0/-3 1,50 0.00/2 0.00/2 0.00/1 0.00/1   1/-3 2,50 0.50/2 0.50/2 1.00/1 0.00/1
2015-09-21 Ternana 2-3 Livorno 1/-4 2,00 0.33/3 0.33/3 1.00/1 0.00/2   9/7 3,67 3.00/3 3.00/3 3.00/2 3.00/1
2015-09-26 Salernitana 2-1 Ternana 6/0 3,00 1.25/4 1.25/4 1.50/2 1.00/2   3/-5 2,75 0.25/4 0.25/4 0.50/2 0.00/2
2015-10-03 Ternana 2-0 Novara 4/-6 2,80 0.20/5 0.20/5 0.50/2 0.00/3   3/-2 1,60 1.00/5 1.00/5 1.33/3 0.50/2
2015-10-11 Spezia 1-0 Ternana 9/3 2,50 1.83/6 1.83/6 2.00/2 1.75/4   6/-4 2,67 0.67/6 0.67/6 1.33/3 0.00/3
2015-10-17 Ternana 3-0 Bari 6/-5 2,43 0.57/7 0.57/7 1.33/3 0.00/4   10/1 2,71 2.00/7 2.00/7 2.50/4 1.33/3
2015-10-24 Ternana 0-1 Perugia 9/-2 2,50 0.88/8 0.88/8 1.75/4 0.00/4   4/-1 1,13 0.88/8 0.88/8 1.50/4 0.25/4
2015-10-27 Latina 1-2 Ternana 12/2 2,44 1.44/9 1.50/8 1.75/4 1.20/5   9/-3 2,33 0.78/9 0.88/8 1.40/5 0.00/4
2015-10-31 Ternana 0-3 Avellino 11/-2 2,40 1.00/10 1.13/8 1.40/5 0.60/5   14/-2 3,00 1.00/10 0.88/8 1.60/5 0.40/5
2015-11-07 Pescara 1-2 Ternana 15/2 2,55 1.64/11 1.75/8 2.60/5 0.83/6   11/-5 2,45 0.91/11 1.13/8 1.17/6 0.60/5
2015-11-15 Ternana 1-2 Entella 13/-4 2,50 1.08/12 1.50/8 1.17/6 1.00/6   9/-3 1,75 1.17/12 1.38/8 1.83/6 0.50/6
2015-11-21 Crotone 3-0 Ternana 22/9 2,69 1.92/13 1.88/8 2.67/6 1.29/7   14/-5 2,54 1.00/13 1.50/8 1.00/7 1.00/6
2015-11-28 Ternana 2-0 L.R. Vicenza 14/-8 2,57 0.93/14 1.13/8 1.00/7 0.86/7   19/3 2,50 1.36/14 1.13/8 1.14/7 1.57/7
2015-12-05 Pro Vercelli 1-2 Ternana 12/-2 1,73 1.33/15 1.88/8 1.63/8 1.00/7   16/-6 2,53 1.07/15 1.50/8 1.25/8 0.86/7
2015-12-08 Ascoli 1-0 Ternana 11/-12 2,13 0.88/16 0.50/8 1.38/8 0.38/8   18/-5 2,56 1.19/16 1.50/8 1.25/8 1.13/8
2015-12-12 Ternana 4-0 Como 18/-6 2,47 1.12/17 1.50/8 1.25/8 1.00/9   14/-15 2,53 0.59/17 0.50/8 0.44/9 0.75/8
2015-12-19 Cesena 4-0 Ternana 23/6 2,22 1.56/18 1.00/8 2.44/9 0.67/9   22/-2 2,56 1.22/18 1.50/8 1.44/9 1.00/9
2015-12-23 Ternana 1-1 Lanciano 22/-6 2,63 1.16/19 1.50/8 1.44/9 0.90/10   17/-11 2,37 0.79/19 0.63/8 1.44/9 0.20/10
2015-12-27 Brescia 0-0 Ternana 31/5 2,85 1.70/20 2.13/8 2.33/9 1.18/11   23/-6 2,60 1.15/20 1.25/8 1.40/10 0.90/10
2016-01-16 Ternana 1-0 Trapani 23/-6 2,48 1.14/21 1.38/8 1.40/10 0.91/11   24/-2 2,38 1.38/21 1.63/8 1.91/11 0.80/10
2016-01-23 Cagliari 1-0 Ternana 43/22 2,91 2.09/22 1.75/8 2.82/11 1.36/11   24/-5 2,41 1.23/22 1.75/8 1.55/11 0.91/11
2016-01-30 Ternana 2-1 Modena 24/-6 2,35 1.17/23 1.38/8 1.55/11 0.83/12   20/-6 2,00 1.09/23 1.25/8 1.92/12 0.18/11
2016-02-06 Livorno 1-0 Ternana 30/-3 2,63 1.13/24 0.75/8 1.42/12 0.83/12   26/-5 2,38 1.25/24 1.38/8 1.67/12 0.83/12
2016-02-13 Ternana 4-0 Salernitana 26/-6 2,32 1.20/25 1.38/8 1.67/12 0.77/13   26/-9 2,44 0.96/25 0.88/8 1.50/12 0.46/13
2016-02-20 Novara 1-2 Ternana 35/14 2,15 1.69/26 1.00/8 2.17/12 1.29/14   30/-2 2,38 1.27/26 1.38/8 1.77/13 0.77/13
2016-02-27 Ternana 1-2 Spezia 32/-1 2,41 1.33/27 1.75/8 1.77/13 0.93/14   30/-2 2,30 1.48/27 1.88/8 1.86/14 1.08/13
2016-03-01 Bari 4-0 Ternana 31/0 2,21 1.46/28 0.75/8 2.00/14 0.93/14   33/-2 2,43 1.29/28 1.63/8 1.64/14 0.93/14
2016-03-05 Perugia 1-0 Ternana 27/0 1,86 1.28/29 0.88/8 1.53/15 1.00/14   33/-6 2,48 1.24/29 1.50/8 1.64/14 0.87/15
2016-03-12 Ternana 0-0 Latina 33/-7 2,43 1.20/30 1.13/8 1.64/14 0.81/16   31/-5 2,23 1.13/30 1.13/8 1.47/15 0.80/15
2016-03-21 Avellino 0-2 Ternana 45/1 2,87 1.39/31 1.00/8 1.80/15 1.00/16   33/-7 2,35 1.19/31 1.25/8 1.60/15 0.81/16
2016-03-26 Ternana 1-0 Pescara 35/-5 2,34 1.25/32 1.25/8 1.60/15 0.94/17   50/5 2,97 1.53/32 0.38/8 1.94/16 1.13/16
2016-04-02 Entella 2-2 Ternana 40/8 2,18 1.52/33 2.00/8 2.06/17 0.94/16   36/-4 2,30 1.30/33 1.63/8 1.69/16 0.94/17
2016-04-09 Ternana 1-2 Crotone 38/-4 2,35 1.29/34 1.38/8 1.69/16 0.94/18   53/25 2,38 2.06/34 1.88/8 2.47/17 1.65/17
2016-04-16 L.R. Vicenza 2-1 Ternana 35/-11 2,31 1.09/35 1.00/8 1.06/17 1.11/18   39/-5 2,37 1.26/35 1.00/8 1.59/17 0.94/18
2016-04-19 Ternana 2-2 Pro Vercelli 40/-6 2,39 1.22/36 1.00/8 1.59/17 0.89/19   35/-9 2,19 1.11/36 1.38/8 1.39/18 0.83/18
2016-04-23 Ternana 1-3 Ascoli 42/-6 2,43 1.22/37 1.13/8 1.56/18 0.89/19   39/-17 2,57 1.14/37 0.88/8 1.58/19 0.67/18
2016-05-01 Como 1-2 Ternana 33/-27 2,45 0.76/38 0.75/8 0.84/19 0.68/19   43/-8 2,47 1.18/38 1.13/8 1.47/19 0.89/19
2016-05-07 Ternana 1-1 Cesena 45/-7 2,49 1.23/39 1.38/8 1.47/19 1.00/20   53/18 2,26 1.56/39 1.38/8 2.35/20 0.74/19
2016-05-14 Lanciano 1-1 Ternana 40/-13 2,33 1.15/40 0.63/8 1.70/20 0.60/20   46/-7 2,48 1.23/40 1.13/8 1.45/20 1.00/20
2016-05-20 Ternana 3-2 Brescia 47/-7 2,46 1.22/41 0.88/8 1.45/20 1.00/21   53/-8 2,78 1.32/41 0.50/8 1.90/21 0.70/20