SELECT * FROM 1_Kampe WHERE LigaID = '218' 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
2018-08-25 PAOK 1-0 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
2018-09-01 Asteras Tripolis 0-1 AEK Athens FC 0/-1 1,00 0.00/1 0.00/1 0.00/0 0.00/1   2/2 2,00 3.00/1 3.00/1 3.00/1 0.00/0
2018-09-16 Olympiacos Piraeus 2-1 Asteras Tripolis 6/6 3,00 3.00/2 3.00/2 3.00/2 0.00/0   0/-2 1,00 0.00/2 0.00/2 0.00/1 0.00/1
2018-09-22 Asteras Tripolis 2-0 Apollon Smyrnis 1/-3 1,67 0.00/3 0.00/3 0.00/1 0.00/2   1/-3 1,67 0.00/3 0.00/3 0.00/2 0.00/1
2018-09-22 Asteras Tripolis 2-0 Smyrnis 3/-1 1,75 0.75/4 1.20/5 1.50/2 0.00/2   1/-3 1,67 0.00/3 0.00/3 0.00/2 0.00/1
2018-09-30 Aris 2-0 Asteras Tripolis 7/6 2,00 2.25/4 2.25/4 3.00/2 1.50/2   5/1 1,80 1.20/5 1.20/5 2.00/3 0.00/2
2018-10-06 Asteras Tripolis 1-1 Panathinaikos 5/-1 1,83 1.00/6 1.00/6 2.00/3 0.00/3   12/9 3,00 3.00/5 3.00/5 3.00/3 3.00/2
2018-10-22 Atromitos 3-2 Asteras Tripolis 8/7 1,50 2.67/6 2.67/6 2.50/4 3.00/2   6/-1 1,86 1.00/7 1.00/7 1.75/4 0.00/3
2018-10-28 Panetolikos 1-1 Asteras Tripolis 10/2 2,57 1.57/7 1.57/7 1.75/4 1.33/3   8/-2 2,25 0.88/8 0.88/8 1.75/4 0.00/4
2018-11-05 Asteras Tripolis 0-1 Xanthi FC 9/-2 2,22 0.89/9 1.00/8 1.75/4 0.20/5   9/5 1,63 1.88/8 1.88/8 2.00/5 1.67/3
2018-11-11 Lamia 0-0 Asteras Tripolis 9/-4 2,44 1.11/9 1.25/8 1.25/4 1.00/5   9/-3 2,10 0.80/10 1.00/8 1.40/5 0.20/5
2018-11-24 Asteras Tripolis 2-0 AEL Larissa 9/-3 1,91 0.82/11 1.13/8 1.40/5 0.33/6   8/-3 1,73 1.27/11 1.00/8 1.40/5 1.17/6
2018-12-02 Levadiakos 0-2 Asteras Tripolis 9/-10 2,33 0.83/12 0.50/8 1.67/6 0.00/6   11/-1 1,92 1.00/12 1.13/8 1.67/6 0.33/6
2018-12-08 Asteras Tripolis 1-0 Giannina 13/1 1,92 1.15/13 1.13/8 1.67/6 0.71/7   10/-9 2,23 1.08/13 0.63/8 1.60/5 0.75/8
2018-12-15 Asteras Tripolis 2-1 OFI Crete 14/2 1,86 1.29/14 1.50/8 1.86/7 0.71/7   12/-8 2,29 0.86/14 1.25/8 1.14/7 0.57/7
2019-01-13 Asteras Tripolis 0-3 PAOK 16/3 1,93 1.40/15 1.75/8 2.00/8 0.71/7   26/20 2,13 2.87/15 2.75/8 3.00/8 2.71/7
2019-01-20 AEK Athens FC 3-0 Asteras Tripolis 28/21 2,19 2.06/16 1.75/8 2.29/7 1.89/9   16/0 2,00 1.31/16 1.75/8 1.78/9 0.71/7
2019-01-27 Asteras Tripolis 0-2 Olympiacos Piraeus 16/-3 2,06 1.24/17 1.63/8 1.78/9 0.63/8   26/17 2,06 2.29/17 2.50/8 2.44/9 2.13/8
2019-01-30 Panionios 1-0 Asteras Tripolis 19/-6 2,44 1.22/18 1.00/8 1.33/9 1.11/9   16/-5 2,06 1.17/18 1.63/8 1.60/10 0.63/8
2019-02-03 Smyrnis 0-2 Asteras Tripolis 7/-22 2,00 0.33/18 0.63/8 0.63/8 0.10/10   16/-6 2,00 1.11/19 1.50/8 1.60/10 0.56/9
2019-02-03 Apollon Smyrnis 0-2 Asteras Tripolis 7/-22 2,00 0.33/18 0.63/8 0.63/8 0.10/10   18/-4 2,00 1.20/20 1.50/8 1.60/10 0.80/10
2019-02-11 Asteras Tripolis 0-3 Aris 20/-2 2,00 1.29/21 1.50/8 1.60/10 1.00/11   23/3 2,15 1.60/20 1.38/8 1.78/9 1.45/11
2019-02-16 Panathinaikos 1-0 Asteras Tripolis 32/14 2,38 1.76/21 1.13/8 2.40/10 1.18/11   20/-5 2,05 1.23/22 1.13/8 1.45/11 1.00/11
2019-02-23 Asteras Tripolis 1-1 Atromitos 20/-6 2,00 1.17/23 0.75/8 1.45/11 0.92/12   32/12 2,36 1.82/22 1.38/8 2.10/10 1.58/12
2019-03-03 Asteras Tripolis 3-0 Panetolikos 21/-6 2,00 1.17/24 0.88/8 1.42/12 0.92/12   28/-1 2,48 1.43/23 1.13/8 1.83/12 1.00/11
2019-03-09 Xanthi FC 0-0 Asteras Tripolis 16/-1 1,43 1.22/23 1.13/8 1.50/10 1.00/13   24/-3 2,04 1.24/25 1.25/8 1.54/13 0.92/12
2019-03-16 Asteras Tripolis 0-0 Lamia 24/-3 1,96 1.23/26 1.38/8 1.54/13 0.92/13   23/-7 2,12 1.28/25 1.88/8 1.69/13 0.83/12
2019-03-30 AEL Larissa 2-1 Asteras Tripolis 26/-2 2,00 1.22/27 0.88/8 1.69/13 0.79/14   24/-3 1,89 1.22/27 1.50/8 1.50/14 0.92/13
2019-04-07 Asteras Tripolis 0-0 Levadiakos 25/-4 1,93 1.18/28 1.13/8 1.50/14 0.86/14   14/-21 1,81 0.78/27 0.63/8 1.29/14 0.23/13
2019-04-14 Giannina 0-0 Asteras Tripolis 21/-14 1,93 1.10/29 1.13/8 1.57/14 0.67/15   25/-4 1,86 1.17/29 0.88/8 1.47/15 0.86/14
2019-04-21 OFI Crete 1-1 Asteras Tripolis 27/-14 2,27 1.00/30 1.50/8 1.40/15 0.60/15   25/-4 1,80 1.17/30 1.00/8 1.47/15 0.87/15
2019-05-05 Asteras Tripolis 3-0 Panionios 26/-4 1,81 1.16/31 1.13/8 1.47/15 0.88/16   29/-14 2,32 1.32/31 1.88/8 1.69/16 0.93/15