SELECT * FROM 1_Kampe WHERE LigaID = '177' AND (Home='Gefle' OR Away='Gefle') 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
2010-03-15 Gefle 0-0 Elfsborg 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
2010-03-22 Atvidaberg 0-1 Gefle 0/-2 2,00 0.00/1 0.00/1 0.00/0 0.00/1   0/0 0,00 1.00/1 1.00/1 1.00/1 0.00/0
2010-03-22 Atvidabergs 0-1 Gefle 0/-2 2,00 0.00/1 0.00/1 0.00/0 0.00/1   1/1 0,50 2.00/2 2.33/3 1.00/1 3.00/1
2010-03-28 Gefle 1-3 Malmo FF 2/2 0,67 2.33/3 2.33/3 1.00/1 3.00/2   3/3 1,50 2.00/2 2.00/2 3.00/1 1.00/1
2010-04-05 Mjallby 1-3 Gefle 5/5 1,67 2.33/3 2.33/3 3.00/1 2.00/2   3/0 1,50 1.75/4 1.75/4 0.50/2 3.00/2
2010-04-11 Gefle 1-0 AIK 6/2 2,00 2.00/5 2.00/5 0.50/2 3.00/3   1/-3 1,25 0.50/4 0.50/4 0.50/2 0.50/2
2010-04-15 GAIS 2-1 Gefle 5/0 2,00 1.40/5 1.40/5 2.00/2 1.00/3   7/3 1,83 2.17/6 2.17/6 1.33/3 3.00/3
2010-04-19 Gefle 1-3 Orebro 8/2 2,00 1.86/7 1.86/7 1.33/3 2.25/4   6/-1 1,86 1.71/7 1.71/7 1.50/4 2.00/3
2010-04-25 Brommapojkarna 2-1 Gefle 4/1 0,88 1.50/8 1.50/8 1.33/3 1.60/5   9/0 2,25 1.63/8 1.63/8 1.00/4 2.25/4
2010-04-28 Halmstad 1-0 Gefle 14/2 2,60 1.50/10 1.63/8 1.83/6 1.00/4   10/-1 2,33 1.44/9 1.50/8 1.00/4 1.80/5
2010-05-02 Gefle 0-0 Kalmar 10/-2 2,20 1.30/10 1.13/8 1.00/4 1.50/6   12/-4 2,55 0.91/11 1.00/8 0.80/5 1.00/6
2010-05-05 Hacken 0-2 Gefle 13/-1 2,25 1.33/12 0.50/8 1.57/7 1.00/5   10/-2 2,00 1.27/11 0.88/8 1.00/5 1.50/6
2010-05-10 Gefle 1-3 Helsingborg 12/0 2,00 1.42/12 1.25/8 1.00/5 1.71/7   18/15 1,62 2.54/13 2.75/8 3.00/6 2.14/7
2010-05-16 Gefle 0-0 Goteborg 13/-2 2,15 1.31/13 0.88/8 0.83/6 1.71/7   18/2 2,27 0.93/15 1.13/8 1.29/7 0.63/8
2010-05-22 Djurgarden 1-1 Gefle 18/2 2,27 1.40/15 1.63/8 2.13/8 0.57/7   13/-2 2,00 1.29/14 0.63/8 0.86/7 1.71/7
2010-07-18 Trelleborgs 2-1 Gefle 10/-13 2,36 0.86/14 0.75/8 1.57/7 0.14/7   14/-2 2,00 1.27/15 0.75/8 0.86/7 1.63/8
2010-07-18 Trelleborg 2-1 Gefle 10/-13 2,36 0.86/14 0.75/8 1.57/7 0.14/7   15/-3 2,06 1.19/16 0.75/8 0.86/7 1.44/9
2010-07-25 Gefle 1-3 Trelleborgs 16/-4 2,12 1.12/17 0.75/8 0.86/7 1.30/10   12/-12 2,40 1.00/15 1.13/8 1.75/8 0.14/7
2010-07-25 Gefle 1-3 Trelleborg 17/-6 2,22 1.06/18 0.63/8 0.75/8 1.30/10   12/-12 2,40 1.00/15 1.13/8 1.75/8 0.14/7
2010-08-01 Elfsborg 1-0 Gefle 35/11 3,28 1.56/18 1.25/8 2.33/9 0.78/9   18/-8 2,32 1.00/19 0.63/8 0.67/9 1.30/10
2010-08-08 Gefle 4-2 Atvidaberg 18/-9 2,25 0.95/20 0.25/8 0.67/9 1.18/11   14/-13 2,41 0.76/17 0.63/8 0.89/9 0.63/8
2010-08-08 Gefle 4-2 Atvidabergs 22/-7 2,43 1.05/21 0.88/8 0.90/10 1.18/11   14/-13 2,41 0.76/17 0.63/8 0.89/9 0.63/8
2010-08-15 Malmo FF 2-0 Gefle 39/20 2,90 2.25/20 2.25/8 2.82/11 1.56/9   26/-5 2,59 1.14/22 0.88/8 1.09/11 1.18/11
2010-08-21 Gefle 3-3 Mjallby 26/-7 2,57 1.09/23 0.75/8 1.09/11 1.08/12   24/6 2,00 1.52/21 1.75/8 1.60/10 1.45/11
2010-08-29 Gefle 0-2 Hacken 29/-7 2,71 1.08/24 0.88/8 1.08/12 1.08/12   29/-7 2,83 1.17/23 1.00/8 1.33/12 1.00/11
2010-09-11 Helsingborg 3-1 Gefle 35/19 2,13 2.21/24 1.75/8 2.82/11 1.69/13   29/-9 2,68 1.04/25 0.88/8 1.00/13 1.08/12
2010-09-19 Gefle 2-0 Brommapojkarna 30/-11 2,73 1.00/26 0.88/8 1.00/13 1.00/13   18/-21 2,11 0.96/27 0.13/8 1.14/14 0.77/13
2010-09-22 Orebro 3-1 Gefle 37/13 2,35 1.85/26 1.63/8 2.31/13 1.38/13   32/-9 2,70 1.07/27 1.25/8 1.14/14 1.00/13
2010-09-27 Gefle 1-2 Halmstad 33/-11 2,75 1.04/28 1.25/8 1.14/14 0.93/14   27/-8 2,21 1.11/28 0.88/8 1.71/14 0.50/14
2010-10-03 Kalmar 1-1 Gefle 36/-1 2,52 1.34/29 1.13/8 1.57/14 1.13/15   34/-12 2,76 1.00/29 0.88/8 1.07/15 0.93/14
2010-10-16 AIK 2-0 Gefle 28/-11 2,31 1.07/29 0.38/8 1.53/15 0.57/14   35/-12 2,73 1.00/30 0.63/8 1.07/15 0.93/15
2010-10-24 Gefle 1-0 GAIS 35/-14 2,71 0.97/31 0.63/8 1.07/15 0.88/16   24/-8 1,87 1.20/30 1.00/8 1.33/15 1.07/15
2010-10-31 Gefle 2-2 Djurgarden 36/-13 2,66 1.03/32 0.88/8 1.19/16 0.88/16   40/-4 2,63 1.41/32 0.88/8 1.94/16 0.88/16
2010-11-07 Goteborg 2-2 Gefle 46/13 2,39 1.27/33 1.00/8 1.63/16 0.94/17   38/-13 2,70 1.03/33 1.00/8 1.18/17 0.88/16