SELECT * FROM 1_Kampe WHERE LigaID = '218' AND (Home='OFI Crete' OR Away='OFI Crete') 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-26 Panionios 2-2 OFI Crete 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-03 Panetolikos 2-1 OFI Crete 1/-1 3,00 0.00/1 0.00/1 0.00/1 0.00/0   2/0 4,00 1.00/1 1.00/1 0.00/0 1.00/1
2018-09-15 OFI Crete 1-3 PAOK 3/-1 3,50 0.50/2 0.50/2 0.00/0 0.50/2   2/2 1,00 3.00/2 3.00/2 3.00/1 3.00/1
2018-09-23 Xanthi FC 3-0 OFI Crete 1/-1 1,00 0.67/3 0.67/3 0.50/2 1.00/1   4/-3 3,67 0.33/3 0.33/3 0.00/1 0.50/2
2018-09-29 OFI Crete 0-3 AEK Athens FC 4/-6 3,50 0.25/4 0.25/4 0.00/1 0.33/3   7/5 2,25 2.25/4 2.25/4 3.00/2 1.50/2
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-21 OFI Crete 1-0 Olympiacos Piraeus 5/-9 3,17 0.33/6 0.33/6 0.00/2 0.50/4   10/7 2,17 2.17/6 2.17/6 2.25/4 2.00/2
2018-10-27 AEL Larissa 0-0 OFI Crete 5/-5 1,88 1.13/8 1.13/8 1.00/3 1.20/5   6/-8 2,86 0.71/7 0.71/7 1.00/3 0.50/4
2018-11-04 OFI Crete 0-0 Smyrnis 6/-8 2,50 0.75/8 0.75/8 1.00/3 0.60/5   1/-12 1,75 0.00/8 0.00/8 0.00/4 0.00/4
2018-11-04 OFI Crete 0-0 Apollon Smyrnis 6/-8 2,22 0.78/9 0.88/8 1.00/4 0.60/5   1/-12 1,75 0.00/8 0.00/8 0.00/4 0.00/4
2018-11-10 Levadiakos 2-1 OFI Crete 7/-9 2,30 0.70/10 0.50/8 1.40/5 0.00/5   6/-8 2,00 0.80/10 0.88/8 1.00/5 0.60/5
2018-11-25 OFI Crete 1-2 Aris 7/-9 2,09 0.73/11 0.88/8 1.00/5 0.50/6   14/3 2,27 1.64/11 1.13/8 1.80/5 1.50/6
2018-12-01 Giannina 1-1 OFI Crete 9/-9 2,25 1.08/12 0.88/8 1.75/4 0.75/8   8/-10 2,17 0.67/12 0.88/8 0.83/6 0.50/6
2018-12-09 OFI Crete 3-1 Panathinaikos 9/-10 2,15 0.69/13 1.00/8 0.83/6 0.57/7   26/16 2,77 2.15/13 1.63/8 2.71/7 1.50/6
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-12 OFI Crete 1-1 Panionios 13/-9 2,33 0.80/15 0.88/8 1.14/7 0.50/8   18/-1 2,47 1.40/15 1.38/8 1.50/8 1.29/7
2019-01-20 OFI Crete 3-0 Panetolikos 14/-9 2,31 0.81/16 0.88/8 1.13/8 0.50/8   23/1 2,81 1.56/16 1.63/8 2.13/8 1.00/8
2019-01-27 PAOK 4-0 OFI Crete 32/26 2,24 2.88/17 2.75/8 3.00/9 2.75/8   17/-6 2,35 0.94/17 1.13/8 1.33/9 0.50/8
2019-01-31 OFI Crete 1-1 Atromitos 17/-10 2,44 0.89/18 1.00/8 1.33/9 0.44/9   27/8 2,56 1.67/18 0.75/8 2.00/9 1.33/9
2019-02-03 OFI Crete 0-0 Xanthi FC 18/-10 2,42 0.89/19 1.13/8 1.30/10 0.44/9   15/-1 1,63 1.26/19 0.75/8 1.56/9 1.00/10
2019-02-10 AEK Athens FC 1-0 OFI Crete 35/27 2,15 2.15/20 2.50/8 2.30/10 2.00/10   18/-10 2,30 0.90/20 1.25/8 1.27/11 0.44/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-25 Olympiacos Piraeus 5-1 OFI Crete 41/28 2,45 2.32/22 2.63/8 2.58/12 2.00/10   19/-13 2,32 0.82/22 0.75/8 1.17/12 0.40/10
2019-03-03 OFI Crete 0-0 AEL Larissa 20/-17 2,48 0.78/23 0.75/8 1.17/12 0.36/11   24/-4 2,17 1.17/24 0.88/8 1.58/12 0.75/12
2019-03-10 Smyrnis 0-0 OFI Crete 10/-30 2,17 0.39/23 0.50/8 0.45/11 0.33/12   20/-17 2,38 0.79/24 0.75/8 1.15/13 0.36/11
2019-03-10 Apollon Smyrnis 0-0 OFI Crete 10/-30 2,17 0.39/23 0.50/8 0.45/11 0.33/12   20/-17 2,28 0.80/25 0.63/8 1.15/13 0.42/12
2019-03-17 OFI Crete 2-0 Levadiakos 20/-17 2,19 0.81/26 0.63/8 1.15/13 0.46/13   14/-17 1,80 0.84/25 1.13/8 1.38/13 0.25/12
2019-03-31 Aris 3-1 OFI Crete 41/15 2,48 1.70/27 2.13/8 2.00/13 1.43/14   22/-15 2,19 0.89/27 0.88/8 1.29/14 0.46/13
2019-04-06 OFI Crete 1-0 Giannina 23/-17 2,25 0.86/28 0.75/8 1.29/14 0.43/14   21/-13 1,96 1.14/28 1.13/8 1.57/14 0.71/14
2019-04-14 Panathinaikos 1-3 OFI Crete 41/14 2,34 1.72/29 1.63/8 2.14/14 1.33/15   24/-16 2,21 0.93/29 1.13/8 1.40/15 0.43/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 Atromitos 0-2 OFI Crete 43/16 2,26 1.81/31 1.88/8 2.20/15 1.44/16   28/-14 2,26 1.00/31 1.63/8 1.38/16 0.60/15