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 3/-5 1,83 1.00/6 1.00/6 1.50/2 0.75/4   4/-6 2,33 0.50/6 0.50/6 0.67/3 0.33/3
2018-10-21 Smyrnis 1-3 Lamia 0/0 0,00 0.00/0 0.00/0 0.00/0 0.00/0   6/-5 2,43 0.86/7 0.86/7 0.67/3 1.00/4
2018-10-21 Lamia 1-3 Smyrnis 9/-3 2,63 1.13/8 1.13/8 0.67/3 1.40/5   53/-2 4,00 1.44/27 1.13/8 0.00/14 3.00/13
2018-10-27 Lamia 3-2 Levadiakos 10/-5 2,78 1.00/9 1.13/8 0.50/4 1.40/5   7/-9 2,56 0.67/9 0.75/8 0.75/4 0.60/5
2018-11-04 Giannina 0-0 Lamia 9/-10 2,80 0.90/10 1.13/8 1.00/3 0.86/7   13/-4 3,00 1.20/10 1.50/8 1.00/5 1.40/5
2018-11-11 Lamia 0-0 Asteras Tripolis 13/-4 2,73 1.18/11 1.63/8 1.00/5 1.33/6   11/-5 2,45 0.73/11 1.00/8 0.80/5 0.67/6
2018-11-26 Panionios 1-0 Lamia 15/0 2,50 1.42/12 2.00/8 1.14/7 1.80/5   13/-4 2,50 1.17/12 1.63/8 1.00/6 1.33/6
2018-12-03 Lamia 0-1 PAOK 13/-5 2,38 1.08/13 1.50/8 1.00/6 1.14/7   23/15 2,38 2.62/13 2.38/8 2.57/7 2.67/6
2018-12-08 AEK Athens FC 2-0 Lamia 24/13 2,50 1.86/14 1.63/8 1.86/7 1.86/7   13/-6 2,29 1.00/14 1.38/8 0.86/7 1.14/7
2018-12-16 Olympiacos Piraeus 3-0 Lamia 22/10 2,27 2.00/15 2.13/8 2.00/8 2.00/7   13/-8 2,27 0.93/15 1.00/8 0.86/7 1.00/8
2019-01-14 Aris 1-0 Lamia 22/0 2,75 1.38/16 1.25/8 1.25/8 1.50/8   13/-11 2,31 0.88/16 0.63/8 0.86/7 0.89/9
2019-01-21 Lamia 1-0 Panathinaikos 13/-12 2,24 0.82/17 0.63/8 0.86/7 0.80/10   29/11 2,76 1.88/17 1.25/8 2.22/9 1.50/8
2019-01-27 Lamia 2-1 Atromitos 14/-11 2,17 0.94/18 0.63/8 1.13/8 0.80/10   29/9 2,72 1.78/18 1.13/8 1.80/10 1.75/8
2019-01-30 Lamia 2-1 Apollon Smyrnis 16/-10 2,21 1.05/19 0.88/8 1.33/9 0.80/10   6/-21 1,94 0.35/17 0.63/8 0.63/8 0.11/9
2019-02-02 Lamia 0-2 Panetolikos 18/-9 2,25 1.15/20 1.13/8 1.50/10 0.80/10   25/-4 2,70 1.30/20 1.38/8 1.50/10 1.10/10
2019-02-09 Xanthi FC 0-0 Lamia 19/0 1,81 1.33/21 0.88/8 1.40/10 1.27/11   18/-11 2,24 1.10/21 1.13/8 1.36/11 0.80/10
2019-02-18 OFI Crete 1-3 Lamia 22/-11 2,50 0.91/22 1.13/8 1.18/11 0.64/11   18/-11 2,14 1.09/22 1.25/8 1.36/11 0.82/11
2019-02-24 Lamia 2-1 AEL Larissa 21/-9 2,22 1.17/23 1.63/8 1.36/11 1.00/12   23/-7 2,30 1.09/23 1.00/8 1.33/12 0.82/11
2019-03-03 Levadiakos 1-1 Lamia 16/-16 2,00 0.79/24 1.00/8 1.17/12 0.42/12   23/-8 2,25 1.25/24 2.00/8 1.50/12 1.00/12
2019-03-10 Lamia 1-1 Giannina 24/-8 2,24 1.24/25 2.13/8 1.50/12 1.00/13   19/-17 2,20 0.96/25 0.88/8 1.38/13 0.50/12
2019-03-16 Asteras Tripolis 0-0 Lamia 24/-7 2,12 1.12/26 1.00/8 1.31/13 0.92/13   25/-8 2,23 1.23/26 1.88/8 1.46/13 1.00/13
2019-03-30 Lamia 1-0 Panionios 25/-8 2,15 1.22/27 1.63/8 1.46/13 1.00/14   26/-17 2,56 1.19/27 1.25/8 1.50/14 0.85/13
2019-04-07 PAOK 3-0 Lamia 59/42 2,71 2.68/28 2.50/8 2.64/14 2.71/14   26/-7 2,11 1.29/28 1.63/8 1.57/14 1.00/14
2019-04-14 Lamia 2-2 AEK Athens FC 26/-10 2,14 1.24/29 1.63/8 1.57/14 0.93/15   49/29 2,38 2.03/29 2.00/8 2.20/15 1.86/14
2019-04-21 Lamia 1-3 Olympiacos Piraeus 28/-10 2,20 1.23/30 1.63/8 1.53/15 0.93/15   69/49 2,97 2.40/30 3.00/8 2.50/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   29/-12 2,26 1.19/31 1.25/8 1.44/16 0.93/15