SELECT * FROM 1_Kampe WHERE LigaID = '290' 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
2012-07-29 Gent 2-0 Lierse 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
2012-08-05 Waregem 3-1 Gent 1/1 1,00 3.00/1 3.00/1 0.00/0 3.00/1   2/2 2,00 3.00/1 3.00/1 3.00/1 0.00/0
2012-08-12 Gent 1-1 Leuven 3/0 3,00 1.50/2 1.50/2 3.00/1 0.00/1   4/-3 5,50 0.50/2 0.50/2 1.00/1 0.00/1
2012-08-18 Beveren 0-2 Gent 2/-4 2,67 0.33/3 0.33/3 1.00/1 0.00/2   4/0 2,67 1.33/3 1.33/3 2.00/2 0.00/1
2012-08-18 Waasland-Beveren 0-2 Gent 2/-4 2,67 0.33/3 0.33/3 1.00/1 0.00/2   6/2 2,50 1.75/4 2.00/5 2.00/2 1.50/2
2012-08-26 Gent 2-1 Lokeren 8/4 2,40 2.00/5 2.00/5 2.00/2 2.00/3   8/2 3,50 1.75/4 1.75/4 2.00/2 1.50/2
2012-09-01 Charleroi 1-1 Gent 5/-8 3,60 0.60/5 0.60/5 0.00/2 1.00/3   10/5 2,50 2.17/6 2.17/6 2.33/3 2.00/3
2012-09-15 Gent 0-2 KV Mechelen 11/5 2,43 2.00/7 2.00/7 2.33/3 1.75/4   10/-2 3,14 0.86/7 0.86/7 1.33/3 0.50/4
2012-09-21 St. Liege 1-2 Gent 19/5 4,13 1.63/8 1.63/8 2.25/4 1.00/4   11/3 2,38 1.75/8 1.75/8 1.75/4 1.75/4
2012-09-30 Gent 2-2 Club Brugge KV 13/4 2,44 1.89/9 1.75/8 1.75/4 2.00/5   25/15 3,89 2.56/9 2.50/8 3.00/5 2.00/4
2012-10-05 Beerschot AC 2-2 Gent 13/0 2,89 1.44/9 1.63/8 2.00/5 0.75/4   15/4 2,60 1.80/10 1.88/8 1.60/5 2.00/5
2012-10-20 Gent 0-1 Kortrijk 17/4 2,73 1.73/11 1.88/8 1.60/5 1.83/6   14/3 2,27 1.82/11 2.00/8 1.83/6 1.80/5
2012-10-27 Gent 2-0 Mons 17/3 2,58 1.58/12 1.50/8 1.33/6 1.83/6   24/1 3,92 1.33/12 1.38/8 1.67/6 1.00/6
2012-10-30 Anderlecht 5-0 Gent 22/10 2,62 1.92/13 1.75/8 2.67/6 1.29/7   19/5 2,54 1.69/13 1.50/8 1.57/7 1.83/6
2012-11-03 Gent 1-2 Genk 19/0 2,71 1.57/14 1.13/8 1.57/7 1.57/7   22/6 2,71 1.64/14 1.63/8 1.88/8 1.33/6
2012-11-10 Cercle Brugge KSV 2-2 Gent 15/-19 3,27 0.47/15 0.75/8 0.86/7 0.13/8   20/-1 2,73 1.47/15 1.00/8 1.38/8 1.57/7
2012-11-17 Lierse 2-0 Gent 17/-10 2,75 0.88/16 0.63/8 0.88/8 0.88/8   22/-1 2,81 1.44/16 1.13/8 1.38/8 1.50/8
2012-11-24 Gent 0-1 Waregem 22/-3 2,76 1.35/17 0.75/8 1.38/8 1.33/9   29/11 2,76 1.94/17 2.13/8 1.56/9 2.38/8
2012-12-01 Leuven 1-1 Gent 38/10 3,67 1.56/18 1.75/8 1.80/10 1.25/8   22/-4 2,67 1.28/18 0.63/8 1.22/9 1.33/9
2012-12-08 Gent 0-2 Waasland-Beveren 23/-4 2,63 1.26/19 0.63/8 1.22/9 1.30/10   16/-18 2,78 0.78/18 0.88/8 0.78/9 0.78/9
2012-12-08 Gent 0-2 Beveren 23/-6 2,60 1.20/20 0.25/8 1.10/10 1.30/10   16/-18 2,78 0.78/18 0.88/8 0.78/9 0.78/9
2012-12-15 Lokeren 2-2 Gent 35/9 3,05 1.80/20 2.25/8 1.80/10 1.80/10   23/-8 2,57 1.14/21 0.25/8 1.00/11 1.30/10
2012-12-22 Gent 1-2 Charleroi 25/-8 2,64 1.14/22 0.38/8 1.00/11 1.27/11   19/-18 2,67 1.05/21 1.13/8 1.10/10 1.00/11
2012-12-26 KV Mechelen 1-0 Gent 30/-2 2,70 1.17/23 1.13/8 1.18/11 1.17/12   26/-9 2,65 1.09/23 0.38/8 0.92/12 1.27/11
2013-01-19 Gent 0-0 St. Liege 26/-10 2,58 1.04/24 0.25/8 0.92/12 1.17/12   50/21 3,29 1.83/24 2.38/8 2.25/12 1.42/12
2013-01-27 Club Brugge KV 0-0 Gent 60/23 4,04 1.88/24 2.50/8 2.00/12 1.75/12   26/-10 2,48 1.04/25 0.38/8 0.92/13 1.17/12
2013-02-02 Gent 2-1 Beerschot AC 26/-10 2,38 1.04/26 0.50/8 0.92/13 1.15/13   24/-27 3,00 0.76/25 0.25/8 0.92/13 0.58/12
2013-02-09 Kortrijk 1-0 Gent 32/4 2,22 1.41/27 0.88/8 1.85/13 1.00/14   28/-9 2,41 1.11/27 0.75/8 1.07/14 1.15/13
2013-02-16 Mons 0-2 Gent 48/1 3,39 1.50/28 1.75/8 1.64/14 1.36/14   28/-10 2,36 1.07/28 0.75/8 1.07/14 1.07/14
2013-02-23 Gent 2-0 Cercle Brugge KSV 30/-8 2,34 1.14/29 1.13/8 1.07/14 1.20/15   30/-28 3,14 0.54/28 0.38/8 0.93/14 0.14/14
2013-03-09 Genk 3-2 Gent 57/18 3,20 1.70/30 1.88/8 2.07/15 1.33/15   32/-6 2,33 1.20/30 1.38/8 1.20/15 1.20/15
2013-03-16 Gent 1-1 Anderlecht 34/-7 2,42 1.16/31 1.38/8 1.20/15 1.13/16   72/45 3,19 2.32/31 2.13/8 2.56/16 2.07/15