SELECT * FROM 1_Kampe WHERE LigaID = '222' AND (Home='Asteras Tripolis' OR Away='Asteras Tripolis') 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
2014-08-24 Giannina 3-1 Asteras Tripolis 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
2014-08-31 Asteras Tripolis 2-1 Levadiakos 1/-2 4,00 0.00/1 0.00/1 0.00/0 0.00/1   1/0 2,00 1.00/1 1.00/1 1.00/1 0.00/0
2014-09-14 Panionios 2-1 Asteras Tripolis 3/0 3,00 1.50/2 1.50/2 3.00/1 0.00/1   3/-1 3,50 1.50/2 1.50/2 3.00/1 0.00/1
2014-09-21 Asteras Tripolis 1-0 Kalloni 4/-2 3,33 1.00/3 1.00/3 3.00/1 0.00/2   4/3 1,67 2.33/3 2.33/3 3.00/2 1.00/1
2014-09-27 Platanias FC 0-1 Asteras Tripolis 5/-3 3,25 0.75/4 0.75/4 0.00/2 1.50/2   5/-1 2,75 1.50/4 1.50/4 3.00/2 0.00/2
2014-10-18 Asteras Tripolis 1-1 Panetolikos 6/0 2,40 1.80/5 1.80/5 3.00/2 1.00/3   2/-2 1,20 0.60/5 0.60/5 0.50/2 0.67/3
2014-10-26 OFI Crete 2-3 Asteras Tripolis 4/-5 2,17 1.50/6 1.50/6 2.00/3 1.00/3   7/0 2,33 1.67/6 1.67/6 2.33/3 1.00/3
2014-11-01 Asteras Tripolis 0-0 Olympiacos Piraeus 10/1 2,71 1.86/7 1.86/7 2.33/3 1.50/4   14/9 2,71 2.29/7 2.29/7 3.00/4 1.33/3
2014-11-10 Atromitos 4-3 Asteras Tripolis 5/-1 1,38 1.38/8 1.38/8 2.00/4 0.75/4   10/1 2,38 1.75/8 1.75/8 2.00/4 1.50/4
2014-11-30 Ergotelis 1-4 Asteras Tripolis 11/-6 3,11 0.67/9 0.75/8 0.40/5 1.00/4   13/0 2,89 1.56/9 1.75/8 2.00/4 1.20/5
2014-12-04 Niki Volos 0-2 Asteras Tripolis 4/-16 2,40 0.40/10 0.50/8 1.00/4 0.00/6   17/3 3,10 1.70/10 1.75/8 2.00/4 1.50/6
2014-12-07 Asteras Tripolis 1-1 Panathinaikos 19/5 3,00 1.82/11 2.13/8 2.00/4 1.71/7   15/5 2,27 2.00/11 2.25/8 2.40/5 1.67/6
2014-12-14 Asteras Tripolis 2-0 Veria 20/5 2,92 1.75/12 1.88/8 1.80/5 1.71/7   18/1 2,92 1.75/12 1.50/8 2.67/6 0.83/6
2014-12-17 Panthrakikos 1-1 Asteras Tripolis 9/-13 2,38 0.77/13 0.63/8 1.80/5 0.13/8   22/7 2,85 1.85/13 1.88/8 2.00/6 1.71/7
2014-12-21 Asteras Tripolis 2-1 Xanthi FC 23/7 2,79 1.79/14 1.88/8 2.00/6 1.63/8   25/5 3,21 1.71/14 2.25/8 2.71/7 0.71/7
2015-01-03 Kerkyra 1-0 Asteras Tripolis 16/-4 2,40 1.20/15 1.00/8 1.63/8 0.71/7   25/8 2,80 1.87/15 1.88/8 2.14/7 1.63/8
2015-01-10 Asteras Tripolis 3-0 PAOK 25/7 2,69 1.75/16 1.75/8 2.14/7 1.44/9   36/17 3,44 2.31/16 1.88/8 2.44/9 2.14/7
2015-01-14 Asteras Tripolis 2-2 Giannina 28/10 2,71 1.82/17 2.13/8 2.25/8 1.44/9   20/5 2,06 1.47/17 1.50/8 2.00/9 0.88/8
2015-01-18 Levadiakos 3-1 Asteras Tripolis 16/-2 2,00 0.88/17 1.00/8 0.89/9 0.88/8   30/10 2,78 1.78/18 1.88/8 2.11/9 1.44/9
2015-01-24 Asteras Tripolis 2-0 Panionios 31/8 2,84 1.68/19 1.50/8 2.11/9 1.30/10   18/-9 2,50 0.89/18 0.63/8 1.67/9 0.11/9
2015-01-31 Kalloni 1-0 Asteras Tripolis 16/-3 1,75 1.20/20 0.63/8 1.67/9 0.82/11   33/10 2,80 1.75/20 1.75/8 2.20/10 1.30/10
2015-02-04 Asteras Tripolis 1-0 Platanias FC 33/9 2,71 1.67/21 1.38/8 2.20/10 1.18/11   17/-6 1,90 1.05/21 0.88/8 1.40/10 0.73/11
2015-02-08 Asteras Tripolis - Niki Volos / /0 / / /   / /0 / / /
2015-02-14 Panetolikos 2-0 Asteras Tripolis 32/14 2,17 1.65/23 1.75/8 1.91/11 1.42/12   34/10 2,64 1.73/22 1.63/8 2.27/11 1.18/11
2015-02-22 Asteras Tripolis 6-1 OFI Crete 34/8 2,61 1.65/23 1.25/8 2.27/11 1.08/12   21/-21 2,86 0.91/22 0.75/8 1.45/11 0.36/11
2015-03-07 Asteras Tripolis 1-0 Atromitos 40/13 2,79 1.71/24 1.63/8 2.33/12 1.08/12   25/6 1,91 1.48/23 1.38/8 2.20/10 0.92/13
2015-03-14 PAOK 0-0 Asteras Tripolis 47/10 3,36 1.88/25 1.25/8 2.17/12 1.62/13   41/14 2,72 1.76/25 1.63/8 2.38/13 1.08/12
2015-03-19 Olympiacos Piraeus 2-0 Asteras Tripolis 55/39 2,84 2.32/25 2.38/8 2.62/13 2.00/12   41/14 2,62 1.73/26 1.63/8 2.38/13 1.08/13
2015-03-22 Asteras Tripolis 2-1 Ergotelis 41/12 2,59 1.67/27 1.63/8 2.38/13 1.00/14   27/-26 2,96 0.81/27 0.88/8 0.77/13 0.86/14
2015-04-04 Panathinaikos 2-2 Asteras Tripolis 47/22 2,57 2.07/28 2.25/8 2.79/14 1.36/14   43/13 2,61 1.71/28 1.63/8 2.43/14 1.00/14
2015-04-20 Veria 4-0 Asteras Tripolis 38/-13 2,97 1.23/30 0.88/8 1.80/15 0.67/15   45/13 2,66 1.69/29 1.75/8 2.43/14 1.00/15
2015-04-26 Asteras Tripolis 2-1 Panthrakikos 45/9 2,70 1.63/30 1.38/8 2.43/14 0.94/16   28/-14 2,33 1.13/30 1.25/8 1.87/15 0.40/15
2015-05-03 Xanthi FC 0-0 Asteras Tripolis 41/2 2,58 1.39/31 1.25/8 1.88/16 0.87/15   47/10 2,71 1.68/31 1.75/8 2.47/15 0.94/16
2015-05-10 Asteras Tripolis 2-0 Kerkyra 47/10 2,63 1.66/32 1.50/8 2.47/15 0.94/17   36/0 2,25 1.28/32 1.38/8 1.75/16 0.81/16