SELECT * FROM 1_Kampe WHERE LigaID = '218' AND (Home='Xanthi FC' OR Away='Xanthi FC') 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 Xanthi FC 0-1 Panathinaikos 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 Atromitos 0-0 Xanthi FC 2/1 3,00 3.00/1 3.00/1 0.00/0 3.00/1   0/-1 1,00 0.00/1 0.00/1 0.00/1 0.00/0
2018-09-16 Xanthi FC 1-1 Panetolikos 0/-1 0,50 0.50/2 0.50/2 0.00/1 1.00/1   3/0 3,00 1.50/2 1.50/2 1.50/2 0.00/0
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-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-08 Xanthi FC 1-0 AEL Larissa 4/2 1,20 1.20/5 1.20/5 1.33/3 1.00/2   3/-4 2,00 1.20/5 1.20/5 1.50/2 1.00/3
2018-10-21 Smyrnis 1-3 Xanthi FC 1/-2 4,00 0.00/1 1.13/8 0.00/1 0.00/0   5/3 1,17 1.50/6 1.50/6 1.75/4 1.00/2
2018-10-21 Levadiakos 1-2 Xanthi FC 3/-10 2,29 0.43/7 0.75/8 1.00/3 0.00/4   8/5 1,57 1.71/7 1.88/8 1.75/4 1.67/3
2018-10-21 Xanthi FC 1-3 Smyrnis 10/6 1,75 1.88/8 1.88/8 1.75/4 2.00/4   32/0 4,00 1.50/16 1.13/8 0.00/8 3.00/8
2018-10-29 Xanthi FC 2-1 Giannina 11/4 2,00 1.67/9 1.88/8 1.40/5 2.00/4   8/-9 2,78 1.00/9 1.13/8 1.00/3 1.00/6
2018-11-05 Asteras Tripolis 0-1 Xanthi FC 11/-4 2,60 0.80/10 1.00/8 1.00/4 0.67/6   13/5 2,10 1.80/10 2.13/8 1.67/6 2.00/4
2018-11-10 Xanthi FC 0-1 Panionios 14/6 2,00 1.91/11 2.38/8 1.67/6 2.20/5   14/-1 2,64 1.27/11 1.63/8 1.14/7 1.50/4
2018-11-24 PAOK 2-0 Xanthi FC 21/13 2,42 2.58/12 2.38/8 2.50/6 2.67/6   14/5 1,92 1.75/12 2.00/8 1.43/7 2.20/5
2018-12-02 AEK Athens FC 2-0 Xanthi FC 22/11 2,54 1.77/13 1.38/8 1.67/6 1.86/7   14/3 1,92 1.62/13 1.88/8 1.43/7 1.83/6
2018-12-09 Xanthi FC 1-1 Olympiacos Piraeus 14/1 1,93 1.50/14 1.50/8 1.43/7 1.57/7   21/10 2,29 2.07/14 2.00/8 2.00/8 2.17/6
2018-12-16 Apollon Smyrnis 1-0 Xanthi FC 5/-18 2,15 0.15/13 0.25/8 0.17/6 0.14/7   15/1 1,93 1.47/15 1.63/8 1.38/8 1.57/7
2019-01-13 Panathinaikos 2-2 Xanthi FC 27/11 2,69 1.94/16 1.50/8 2.38/8 1.50/8   15/0 1,88 1.38/16 1.25/8 1.38/8 1.38/8
2019-01-20 Xanthi FC 2-1 Atromitos 17/0 2,00 1.35/17 1.00/8 1.38/8 1.33/9   28/10 2,71 1.88/17 1.25/8 1.80/10 2.00/7
2019-01-26 Panetolikos 0-0 Xanthi FC 25/-3 2,94 1.39/18 1.25/8 1.75/8 1.10/10   19/1 2,06 1.44/18 1.00/8 1.56/9 1.33/9
2019-01-31 Xanthi FC 0-1 Aris 19/1 1,95 1.42/19 0.75/8 1.56/9 1.30/10   23/0 2,42 1.37/19 1.38/8 1.44/9 1.30/10
2019-02-03 OFI Crete 0-0 Xanthi FC 22/-10 2,70 0.95/20 1.13/8 1.20/10 0.70/10   19/0 1,90 1.35/20 0.75/8 1.40/10 1.30/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-17 AEL Larissa 1-1 Xanthi FC 22/-7 2,32 1.09/22 0.88/8 1.36/11 0.82/11   19/0 1,73 1.32/22 1.00/8 1.36/11 1.27/11
2019-02-24 Xanthi FC 0-0 Levadiakos 20/0 1,74 1.30/23 1.00/8 1.36/11 1.25/12   16/-16 2,09 0.83/23 1.00/8 1.17/12 0.45/11
2019-03-02 Giannina 0-0 Xanthi FC 19/-17 2,29 0.96/24 0.75/8 1.42/12 0.50/12   20/0 1,67 1.25/24 1.00/8 1.25/12 1.25/12
2019-03-09 Xanthi FC 0-0 Asteras Tripolis 20/0 1,60 1.24/25 1.00/8 1.25/12 1.23/13   24/-7 2,20 1.12/25 0.88/8 1.31/13 0.92/12
2019-03-17 Panionios 1-0 Xanthi FC 25/-18 2,62 1.12/26 0.88/8 1.38/13 0.85/13   20/0 1,54 1.23/26 0.75/8 1.23/13 1.23/13
2019-03-31 Xanthi FC 1-2 PAOK 20/-1 1,52 1.19/27 0.63/8 1.23/13 1.14/14   57/41 2,70 2.67/27 2.50/8 2.64/14 2.69/13
2019-04-07 Xanthi FC 1-3 AEK Athens FC 21/-2 1,57 1.14/28 0.63/8 1.14/14 1.14/14   46/27 2,32 2.00/28 1.75/8 2.20/15 1.77/13
2019-04-14 Olympiacos Piraeus 4-0 Xanthi FC 65/45 2,93 2.38/29 2.63/8 2.47/15 2.29/14   22/-4 1,66 1.10/29 0.50/8 1.07/15 1.14/14
2019-04-21 Xanthi FC 2-0 Apollon Smyrnis 22/-8 1,73 1.07/30 0.38/8 1.07/15 1.07/15   11/-39 2,18 0.36/28 0.13/8 0.43/14 0.29/14
2019-05-05 Aris 7-2 Xanthi FC 43/8 2,52 1.58/31 1.63/8 1.73/15 1.44/16   24/-6 1,74 1.13/31 0.63/8 1.19/16 1.07/15