SELECT * FROM 1_Kampe WHERE LigaID = '286' AND (Home='Gent' OR Away='Gent') 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-10-21 Gent 1-3 KV Mechelen 47/16 2,52 1.71/31 1.88/8 2.47/15 1.00/16   45/10 2,58 1.68/31 1.63/8 2.13/16 1.20/15
2018-10-21 KV Mechelen 1-3 Gent 17/0 2,62 1.23/13 1.25/8 1.17/6 1.29/7   20/8 2,67 1.75/12 1.63/8 3.00/6 0.50/6
2018-10-21 Gent 1-3 St. Liege 19/7 2,82 1.64/11 1.63/8 3.00/5 0.50/6   25/16 2,83 1.83/12 2.13/8 2.29/7 1.20/5
2018-10-21 Eupen 1-3 Gent 15/-15 4,09 0.64/11 0.50/8 1.00/4 0.43/7   17/8 2,60 1.80/10 1.75/8 3.00/5 0.60/5
2018-10-21 Gent 1-3 Waregem 14/5 2,56 1.67/9 1.75/8 3.00/4 0.60/5   20/13 2,70 2.30/10 2.13/8 2.20/5 2.40/5
2018-10-21 Club Brugge KV 1-3 Gent 12/3 2,33 1.44/9 1.25/8 2.33/3 1.00/6   14/6 2,75 1.88/8 1.88/8 3.00/4 0.75/4
2018-10-21 Gent 1-3 St. Truiden 12/5 2,71 1.71/7 1.71/7 3.00/3 0.75/4   11/1 2,63 1.25/8 1.25/8 2.00/5 0.00/3
2018-10-21 Oostende 1-3 Gent 10/2 2,57 1.86/7 1.86/7 3.00/4 0.33/3   12/6 3,00 2.00/6 2.00/6 3.00/3 1.00/3
2018-10-21 Gent 1-3 Lokeren 9/3 3,00 1.80/5 1.80/5 3.00/2 1.00/3   5/-1 2,20 1.20/5 1.20/5 2.00/3 0.00/2
2018-10-21 Anderlecht 1-3 Gent 9/5 3,25 2.00/4 2.00/4 3.00/1 1.67/3   7/3 2,75 2.00/4 2.00/4 3.00/2 1.00/2
2018-10-21 Gent 1-3 Westerlo 3/1 1,67 1.67/3 1.67/3 3.00/1 1.00/2   3/-4 3,33 0.33/3 0.33/3 0.50/2 0.00/1
2018-10-21 Charleroi 1-3 Gent 3/3 1,00 3.00/3 3.00/3 3.00/2 3.00/1   2/1 1,50 2.00/2 2.00/2 3.00/1 1.00/1
2018-10-21 Gent 1-3 Genk 1/0 2,00 1.00/1 1.00/1 0.00/0 1.00/1   2/1 3,00 3.00/1 3.00/1 3.00/1 0.00/0
2018-10-21 Kortrijk 1-3 Gent 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-10-21 Beveren 1-3 Gent 26/-11 2,25 1.07/28 1.38/8 1.29/14 0.86/14   44/15 2,43 1.67/30 1.88/8 2.47/15 0.87/15
2018-10-21 Gent 1-3 Waasland-Beveren 22/8 2,57 1.71/14 1.88/8 3.00/7 0.43/7   14/-9 2,85 1.00/13 1.38/8 1.71/7 0.17/6
2018-10-21 Mouscron 1-3 Gent 16/-9 2,73 0.80/15 0.75/8 0.57/7 1.00/8   24/10 2,53 1.80/15 1.88/8 3.00/8 0.43/7
2018-10-21 Waasland-Beveren 1-3 Gent 26/-11 2,25 1.07/28 1.38/8 1.29/14 0.86/14   41/14 2,34 1.62/29 1.50/8 2.47/15 0.71/14
2018-10-21 Gent 1-3 Mouscron 38/12 2,29 1.57/28 1.13/8 2.43/14 0.71/14   26/-26 2,69 0.66/29 0.75/8 0.73/15 0.57/14
2018-10-21 St. Liege 1-3 Gent 45/14 2,71 1.50/28 1.25/8 2.00/13 1.07/15   37/12 2,30 1.59/27 1.00/8 2.43/14 0.69/13
2018-10-21 Gent 1-3 Eupen 37/13 2,35 1.65/26 1.13/8 2.62/13 0.69/13   36/-28 3,70 0.78/27 0.50/8 1.00/14 0.54/13
2018-10-21 Waregem 1-3 Gent 40/15 2,50 1.92/26 1.63/8 2.08/13 1.77/13   36/13 2,36 1.68/25 1.13/8 2.62/13 0.67/12
2018-10-21 Gent 1-3 Club Brugge KV 34/11 2,38 1.63/24 1.13/8 2.58/12 0.67/12   47/29 2,60 2.08/25 2.75/8 2.69/13 1.42/12
2018-10-21 Lokeren 1-3 Gent 22/-6 2,08 1.08/24 1.63/8 1.45/11 0.77/13   34/11 2,48 1.65/23 1.38/8 2.58/12 0.64/11
2018-10-21 Gent 1-3 Charleroi 33/10 2,55 1.59/22 1.38/8 2.55/11 0.64/11   26/7 1,96 1.74/23 1.63/8 2.17/12 1.27/11
2018-10-21 Genk 1-3 Gent 25/-7 2,85 1.30/20 1.00/8 1.91/11 0.56/9   33/12 2,57 1.67/21 1.75/8 2.55/11 0.70/10
2018-10-21 Gent 1-3 Anderlecht 31/13 2,45 1.75/20 1.75/8 2.80/10 0.70/10   41/20 3,10 1.75/20 1.38/8 2.10/10 1.40/10
2018-10-21 St. Truiden 1-3 Gent 22/-5 2,58 1.00/19 0.88/8 1.50/10 0.44/9   30/15 2,37 1.84/19 2.13/8 2.80/10 0.78/9
2018-10-21 Gent 1-3 Oostende 29/15 2,39 1.89/18 2.00/8 3.00/9 0.78/9   36/15 3,17 1.89/18 2.13/8 2.60/10 1.00/8
2018-10-21 Westerlo 1-3 Gent 19/-20 3,41 0.76/17 0.75/8 1.00/8 0.56/9   29/15 2,53 1.94/17 2.25/8 3.00/9 0.75/8
2018-10-21 Gent 1-3 Kortrijk 26/12 2,50 1.88/16 1.88/8 3.00/8 0.75/8   27/4 3,13 1.56/16 1.38/8 2.14/7 1.11/9
2018-10-21 Gent 1-3 Beveren 20/6 2,62 1.62/13 1.50/8 3.00/6 0.43/7   14/-9 2,85 1.00/13 1.38/8 1.71/7 0.17/6