SELECT * FROM 1_Kampe WHERE LigaID = '126' AND (Home='Triestina' OR Away='Triestina') 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
2010-08-22 Triestina 1-1 AlbinoLeffe 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
2010-08-26 Novara 2-0 Triestina 1/0 2,00 1.00/1 1.00/1 0.00/0 1.00/1   1/0 2,00 1.00/1 1.00/1 1.00/1 0.00/0
2010-09-05 Triestina 1-0 Pescara 1/-2 2,00 0.50/2 0.50/2 1.00/1 0.00/1   2/0 1,33 1.00/3 1.00/3 1.00/2 1.00/1
2010-09-11 Empoli 1-1 Triestina 3/1 1,67 1.67/3 1.67/3 1.00/1 2.00/2   2/-1 1,67 1.33/3 1.33/3 2.00/2 0.00/1
2010-09-18 Triestina 0-0 Padova 3/-1 1,75 1.25/4 1.25/4 2.00/2 0.50/2   10/7 2,60 1.60/5 1.60/5 2.33/3 0.50/2
2010-09-27 Modena 2-2 Triestina 4/-8 2,67 1.17/6 1.17/6 3.00/2 0.25/4   3/-1 1,40 1.20/5 1.20/5 1.67/3 0.50/2
2010-10-02 Triestina 3-0 Crotone 5/-1 1,83 1.17/6 1.17/6 1.67/3 0.67/3   8/4 1,71 1.57/7 1.57/7 2.33/3 1.00/4
2010-10-09 Triestina 0-0 ACN Siena 8/2 2,00 1.43/7 1.43/7 2.00/4 0.67/3   11/7 2,14 2.43/7 2.43/7 3.00/4 1.67/3
2010-10-09 Triestina 0-0 Siena 8/2 1,75 1.38/8 1.38/8 1.80/5 0.67/3   13/8 2,25 2.50/8 2.50/8 3.00/5 1.67/3
2010-10-13 Piacenza 2-2 Triestina 6/-10 2,20 0.30/10 0.25/8 0.40/5 0.20/5   8/2 1,56 1.33/9 1.38/8 1.67/6 0.67/3
2010-10-16 Triestina 0-4 Reggina 10/2 1,80 1.30/10 1.50/8 1.67/6 0.75/4   15/3 2,70 1.70/10 2.00/8 2.60/5 0.80/5
2010-10-16 Triestina 0-4 Reggio Calabria 10/-2 2,00 1.18/11 1.00/8 1.43/7 0.75/4   14/4 2,67 1.89/9 2.00/8 2.60/5 1.00/4
2010-10-23 Varese 4-0 Triestina 9/-1 1,90 1.10/10 0.88/8 1.40/5 0.80/5   10/-6 2,17 1.08/12 1.00/8 1.25/8 0.75/4
2010-10-30 Frosinone 1-0 Triestina 12/-3 2,25 1.08/12 1.00/8 1.17/6 1.00/6   10/-10 2,31 1.00/13 0.88/8 1.25/8 0.60/5
2010-11-05 Triestina 0-1 Atalanta 10/-11 2,21 0.93/14 0.75/8 1.25/8 0.50/6   18/6 2,14 1.57/14 1.75/8 2.14/7 1.00/7
2010-11-09 Livorno 1-3 Triestina 24/10 2,53 1.67/15 2.25/8 1.88/8 1.43/7   10/-12 2,13 0.87/15 0.38/8 1.11/9 0.50/6
2010-11-13 Triestina 0-0 Portogruaro 13/-10 2,25 1.00/16 0.63/8 1.11/9 0.86/7   11/-10 2,13 0.87/15 0.38/8 1.71/7 0.13/8
2010-11-20 Sassuolo 0-0 Triestina 20/-5 2,81 0.94/16 1.00/8 1.25/8 0.63/8   13/-10 2,12 1.00/17 0.63/8 1.10/10 0.86/7
2010-11-27 Triestina 0-1 Grosseto 13/-10 2,00 1.00/18 0.63/8 1.10/10 0.88/8   17/-8 2,47 0.88/17 0.50/8 1.56/9 0.13/8
2010-12-04 Cittadella 4-1 Triestina 21/-8 2,63 1.00/19 1.75/8 1.22/9 0.80/10   13/-11 1,95 0.95/19 0.63/8 1.00/11 0.88/8
2010-12-13 Triestina 0-1 Torino 14/-14 2,10 0.90/20 0.63/8 1.00/11 0.78/9   24/0 2,40 1.40/20 1.50/8 1.91/11 0.78/9
2010-12-18 L.R. Vicenza 2-0 Triestina 26/-5 2,71 1.29/21 1.38/8 2.10/10 0.55/11   14/-15 2,05 0.86/21 0.63/8 0.92/12 0.78/9
2011-01-08 Triestina 2-0 Ascoli 14/-17 2,05 0.82/22 0.63/8 0.92/12 0.70/10   23/-6 2,36 1.27/22 1.75/8 1.55/11 1.00/11
2011-01-15 AlbinoLeffe 1-1 Triestina 30/-9 3,00 1.13/23 1.38/8 1.70/10 0.69/13   16/-15 2,04 0.91/23 1.00/8 1.08/13 0.70/10
2011-01-24 Triestina 1-1 Novara 17/-15 2,04 0.92/24 0.75/8 1.08/13 0.73/11   45/25 2,71 1.96/24 1.38/8 2.50/12 1.42/12
2011-01-29 Pescara 0-0 Triestina 28/-1 2,28 1.28/25 1.50/8 1.75/12 0.85/13   18/-15 2,04 0.92/25 0.75/8 1.07/14 0.73/11
2011-02-05 Triestina 1-2 Empoli 18/-15 1,96 0.92/26 0.75/8 1.07/14 0.75/12   29/7 2,04 1.36/25 0.63/8 1.62/13 1.08/12
2011-02-12 Padova 0-1 Triestina 44/11 2,75 1.39/28 1.50/8 2.21/14 0.57/14   19/-16 2,00 0.89/27 0.75/8 1.00/15 0.75/12
2011-02-19 Triestina 2-2 Modena 20/-15 1,96 0.96/28 1.13/8 1.00/15 0.92/13   28/-14 2,41 1.03/29 1.25/8 1.33/15 0.71/14
2011-02-26 Crotone 2-1 Triestina 24/-6 1,80 1.10/30 0.88/8 1.43/14 0.81/16   22/-15 2,03 0.97/29 1.25/8 1.00/16 0.92/13
2011-03-01 Siena 1-0 Triestina 46/21 2,37 1.87/30 1.63/8 2.53/15 1.20/15   23/-16 2,07 0.93/30 1.25/8 1.00/16 0.86/14
2011-03-01 ACN Siena 1-0 Triestina 44/20 2,43 1.86/28 1.88/8 2.50/14 1.21/14   23/-17 2,03 0.90/31 0.75/8 1.00/16 0.80/15
2011-03-05 Triestina 0-1 Piacenza 23/-18 2,00 0.88/32 0.75/8 1.00/16 0.75/16   46/-4 2,91 1.24/33 2.38/8 1.47/17 1.00/16
2011-03-12 Reggina 1-1 Triestina 35/4 2,06 1.47/32 1.63/8 1.81/16 1.13/16   23/-19 1,97 0.85/33 0.63/8 0.94/17 0.75/16
2011-03-12 Reggio Calabria 1-1 Triestina 34/5 2,10 1.53/30 1.63/8 1.87/15 1.20/15   24/-19 1,97 0.85/34 0.75/8 0.94/17 0.76/17
2011-03-19 Triestina 1-1 Varese 25/-19 1,97 0.86/35 0.75/8 0.94/17 0.78/18   39/17 1,85 1.70/33 1.38/8 2.18/17 1.19/16
2011-03-27 Triestina 2-2 Frosinone 26/-19 1,97 0.86/36 0.50/8 0.94/18 0.78/18   35/-18 2,51 0.91/35 1.13/8 1.22/18 0.59/17
2011-04-02 Atalanta 4-0 Triestina 42/18 1,78 1.81/37 1.75/8 2.11/19 1.50/18   28/-19 2,03 0.86/37 0.50/8 0.95/19 0.78/18
2011-04-09 Triestina 0-0 Livorno 28/-23 2,08 0.84/38 0.50/8 0.95/19 0.74/19   45/0 2,37 1.32/38 1.00/8 1.37/19 1.26/19
2011-04-16 Portogruaro 1-2 Triestina 33/-20 2,26 1.00/38 1.25/8 1.32/19 0.68/19   28/-23 2,03 0.85/39 0.63/8 0.95/20 0.74/19
2011-04-22 Triestina 2-1 Sassuolo 30/-22 2,05 0.90/40 1.00/8 0.95/20 0.85/20   39/-7 2,18 1.18/39 1.00/8 1.58/19 0.80/20
2011-04-30 Grosseto 2-0 Triestina 40/-12 2,30 1.13/40 0.75/8 1.63/19 0.67/21   32/-21 2,07 0.95/41 1.38/8 1.05/21 0.85/20
2011-05-07 Triestina 3-2 Cittadella 32/-23 2,07 0.93/42 1.25/8 1.05/21 0.81/21   45/-7 2,31 1.14/42 1.50/8 1.19/21 1.10/21
2011-05-14 Torino 2-0 Triestina 51/1 2,35 1.35/43 1.50/8 1.62/21 1.09/22   35/-22 2,14 0.98/43 1.50/8 1.14/22 0.81/21
2011-05-21 Triestina 0-1 L.R. Vicenza 35/-24 2,14 0.95/44 1.38/8 1.14/22 0.77/22   46/-15 2,43 1.16/44 0.63/8 1.68/22 0.64/22
2011-05-29 Ascoli 3-0 Triestina 46/-8 2,22 1.33/45 1.88/8 1.82/22 0.87/23   35/-25 2,11 0.93/45 1.25/8 1.09/23 0.77/22