SELECT * FROM 1_Kampe WHERE LigaID = '218' AND (Home='Lamia' OR Away='Lamia') 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-27 Lamia 0-3 Aris 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 Panathinaikos 3-1 Lamia 1/1 1,00 3.00/1 3.00/1 0.00/0 3.00/1   0/-3 3,00 0.00/1 0.00/1 0.00/1 0.00/0
2018-09-16 Atromitos 1-0 Lamia 2/1 1,50 2.00/2 2.00/2 1.00/1 3.00/1   1/-5 3,50 0.00/2 0.00/2 0.00/1 0.00/1
2018-09-24 Panetolikos 2-2 Lamia 4/0 2,67 1.33/3 1.33/3 1.50/2 1.00/1   1/-6 2,67 0.00/3 0.00/3 0.00/1 0.00/2
2018-10-01 Lamia 0-0 Xanthi FC 3/-6 3,00 0.25/4 0.25/4 0.00/1 0.33/3   4/2 1,50 1.25/4 1.25/4 1.33/3 1.00/1
2018-10-07 Lamia 1-1 OFI Crete 3/-6 2,40 0.40/5 0.40/5 0.50/2 0.33/3   4/-9 3,40 0.20/5 0.20/5 0.00/2 0.33/3
2018-10-20 AEL Larissa 1-2 Lamia 4/-4 1,71 1.29/7 1.29/7 1.50/2 1.20/5   4/-6 2,33 0.50/6 0.50/6 0.67/3 0.33/3
2018-10-27 Lamia 3-2 Levadiakos 6/-5 2,43 0.86/7 0.86/7 0.67/3 1.00/4   4/-8 2,00 0.75/8 0.75/8 1.50/4 0.00/4
2018-11-04 Giannina 0-0 Lamia 7/-9 2,56 1.00/9 1.13/8 1.50/2 0.86/7   9/-4 2,75 1.13/8 1.13/8 1.25/4 1.00/4
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-26 Panionios 1-0 Lamia 13/2 2,18 1.55/11 2.00/8 1.33/6 1.80/5   9/-4 2,20 1.10/10 1.38/8 1.20/5 1.00/5
2018-12-03 Lamia 0-1 PAOK 9/-5 2,09 1.00/11 1.38/8 1.20/5 0.83/6   21/17 2,08 2.83/12 2.75/8 3.00/7 2.60/5
2018-12-08 AEK Athens FC 2-0 Lamia 22/15 2,23 2.00/13 1.75/8 2.17/6 1.86/7   9/-6 2,00 0.92/12 1.25/8 1.00/6 0.83/6
2018-12-16 Olympiacos Piraeus 3-0 Lamia 19/11 1,93 2.14/14 2.13/8 2.38/8 1.83/6   9/-8 2,00 0.85/13 1.13/8 1.00/6 0.71/7
2019-01-14 Aris 1-0 Lamia 20/1 2,60 1.47/15 1.25/8 1.43/7 1.50/8   9/-11 2,07 0.79/14 1.00/8 1.00/6 0.63/8
2019-01-21 Lamia 1-0 Panathinaikos 9/-12 2,00 0.73/15 0.63/8 1.00/6 0.56/9   30/15 2,81 2.00/16 1.63/8 2.56/9 1.29/7
2019-01-27 Lamia 2-1 Atromitos 10/-11 1,94 0.88/16 0.63/8 1.29/7 0.56/9   26/9 2,53 1.76/17 1.13/8 2.00/9 1.50/8
2019-01-30 Lamia 2-1 Apollon Smyrnis 12/-10 2,00 1.00/17 0.88/8 1.50/8 0.56/9   6/-21 1,94 0.35/17 0.63/8 0.63/8 0.11/9
2019-01-30 Lamia 2-1 Smyrnis 14/-9 2,06 1.11/18 1.50/8 1.67/9 0.56/9   6/-21 1,94 0.35/17 0.63/8 0.63/8 0.11/9
2019-02-02 Lamia 0-2 Panetolikos 16/-8 2,11 1.21/19 1.50/8 1.80/10 0.56/9   23/-3 2,58 1.37/19 1.38/8 1.80/10 0.89/9
2019-02-09 Xanthi FC 0-0 Lamia 15/-1 1,55 1.25/20 0.88/8 1.56/9 1.00/11   16/-10 2,10 1.15/20 1.50/8 1.64/11 0.56/9
2019-02-18 OFI Crete 1-3 Lamia 18/-11 2,24 0.86/21 1.13/8 1.27/11 0.40/10   16/-10 2,00 1.14/21 1.63/8 1.64/11 0.60/10
2019-02-24 Lamia 2-1 AEL Larissa 19/-8 2,09 1.23/22 2.00/8 1.64/11 0.82/11   23/-3 2,13 1.22/23 1.25/8 1.58/12 0.82/11
2019-03-03 Levadiakos 1-1 Lamia 13/-15 1,78 0.87/23 1.13/8 1.42/12 0.27/11   21/-7 2,13 1.30/23 2.38/8 1.75/12 0.82/11
2019-03-10 Lamia 1-1 Giannina 22/-7 2,13 1.29/24 2.13/8 1.75/12 0.83/12   18/-15 2,04 1.08/25 1.25/8 1.62/13 0.50/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 Lamia 1-0 Panionios 23/-7 2,04 1.27/26 1.63/8 1.69/13 0.85/13   24/-16 2,37 1.19/27 0.88/8 1.50/14 0.85/13
2019-04-07 PAOK 3-0 Lamia 62/48 2,71 2.79/28 2.75/8 2.86/14 2.71/14   24/-6 2,00 1.33/27 1.63/8 1.79/14 0.85/13
2019-04-14 Lamia 2-2 AEK Athens FC 24/-9 2,04 1.29/28 1.63/8 1.79/14 0.79/14   49/32 2,28 2.14/29 2.00/8 2.40/15 1.86/14
2019-04-21 Lamia 1-3 Olympiacos Piraeus 26/-9 2,10 1.28/29 1.63/8 1.73/15 0.79/14   68/52 2,80 2.50/30 3.00/8 2.69/16 2.29/14
2019-05-04 Apollon Smyrnis 0-3 Lamia 11/-41 2,17 0.34/29 0.13/8 0.43/14 0.27/15   27/-11 2,17 1.23/30 1.25/8 1.63/16 0.79/14
2019-05-04 Smyrnis 0-3 Lamia 11/-41 2,17 0.34/29 0.13/8 0.43/14 0.27/15   30/-8 2,19 1.29/31 1.50/8 1.63/16 0.93/15