SELECT * FROM 1_Kampe WHERE LigaID = '177' AND (Home='GAIS' OR Away='GAIS') 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 GAIS 0-0 Malmo FF 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-21 Mjallby 3-0 GAIS 0/0 0,00 1.00/1 1.00/1 0.00/0 1.00/1   0/0 0,00 1.00/1 1.00/1 1.00/1 0.00/0
2010-03-29 GAIS 3-1 AIK 0/-3 1,50 0.50/2 0.50/2 1.00/1 0.00/1   0/0 0,00 1.00/2 1.00/2 1.00/1 1.00/1
2010-04-06 Brommapojkarna 1-0 GAIS 0/-1 0,33 0.67/3 0.67/3 1.00/1 0.50/2   3/-1 2,33 1.33/3 1.33/3 2.00/2 0.00/1
2010-04-12 Orebro 0-2 GAIS 5/0 2,00 1.80/5 1.80/5 2.00/3 1.50/2   3/-2 2,00 1.00/4 1.00/4 2.00/2 0.00/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-18 Halmstad 3-0 GAIS 11/2 2,50 1.50/8 1.50/8 1.60/5 1.33/3   7/1 2,17 1.67/6 1.67/6 2.33/3 1.00/3
2010-04-25 GAIS 2-2 Kalmar 7/-2 2,29 1.43/7 1.43/7 2.33/3 0.75/4   6/-7 2,11 0.67/9 0.75/8 0.25/4 1.00/5
2010-04-28 Hacken 0-2 GAIS 13/3 2,30 1.60/10 1.25/8 1.83/6 1.25/4   9/-2 2,50 1.38/8 1.38/8 2.00/4 0.75/4
2010-05-03 GAIS 0-0 Helsingborg 11/0 2,44 1.56/9 1.63/8 2.00/4 1.20/5   16/14 1,64 2.64/11 2.50/8 3.00/5 2.33/6
2010-05-06 Djurgarden 1-1 GAIS 17/5 2,42 1.67/12 2.25/8 2.29/7 0.80/5   11/0 2,20 1.50/10 1.75/8 1.80/5 1.20/5
2010-05-10 GAIS 0-0 Goteborg 12/0 2,18 1.45/11 1.50/8 1.80/5 1.17/6   18/2 2,62 0.92/13 0.88/8 1.33/6 0.57/7
2010-05-16 GAIS 0-2 Elfsborg 12/0 2,00 1.42/12 1.63/8 1.67/6 1.17/6   30/12 3,20 1.60/15 1.88/8 2.50/8 0.57/7
2010-05-22 Trelleborg 2-0 GAIS 8/-15 2,38 0.69/13 0.75/8 1.33/6 0.14/7   12/-2 2,00 1.31/13 1.25/8 1.43/7 1.17/6
2010-05-22 Trelleborgs 2-0 GAIS 8/-15 2,38 0.69/13 0.75/8 1.33/6 0.14/7   12/-4 2,00 1.21/14 0.88/8 1.43/7 1.00/7
2010-07-18 GAIS 0-0 Atvidabergs 12/-6 2,00 1.13/15 0.88/8 1.43/7 0.88/8   14/-10 2,71 0.86/14 1.25/8 1.14/7 0.57/7
2010-07-18 GAIS 0-0 Atvidaberg 12/-6 1,88 1.13/16 0.63/8 1.38/8 0.88/8   14/-10 2,71 0.86/14 1.25/8 1.14/7 0.57/7
2010-07-24 Atvidaberg 0-1 GAIS 14/-10 2,53 0.87/15 1.38/8 1.14/7 0.63/8   12/-6 1,76 1.12/17 0.63/8 1.33/9 0.88/8
2010-07-24 Atvidabergs 0-1 GAIS 14/-10 2,53 0.87/15 1.38/8 1.14/7 0.63/8   13/-5 1,72 1.22/18 1.13/8 1.33/9 1.11/9
2010-08-01 Malmo FF 1-0 GAIS 35/16 3,00 2.17/18 2.00/8 2.80/10 1.38/8   14/-4 1,68 1.32/19 1.13/8 1.33/9 1.30/10
2010-08-07 GAIS 3-2 Mjallby 14/-5 1,65 1.25/20 1.00/8 1.33/9 1.18/11   21/6 1,89 1.53/19 1.75/8 1.44/9 1.60/10
2010-08-14 AIK 1-0 GAIS 20/-2 2,10 1.25/20 2.00/8 1.82/11 0.56/9   17/-4 1,81 1.33/21 1.38/8 1.50/10 1.18/11
2010-08-23 GAIS 1-1 Brommapojkarna 17/-5 1,77 1.27/22 1.38/8 1.50/10 1.08/12   17/-8 2,00 1.19/21 0.88/8 1.60/10 0.82/11
2010-08-27 GAIS 0-1 Djurgarden 18/-5 1,78 1.26/23 1.50/8 1.45/11 1.08/12   26/1 2,32 1.45/22 1.38/8 1.75/12 1.10/10
2010-09-13 Goteborg 2-1 GAIS 31/9 2,30 1.22/23 1.75/8 1.60/10 0.92/13   18/-6 1,75 1.21/24 1.38/8 1.33/12 1.08/12
2010-09-18 Kalmar 3-1 GAIS 32/-3 2,58 1.27/26 1.13/8 1.46/13 1.08/13   19/-7 1,80 1.16/25 1.25/8 1.33/12 1.00/13
2010-09-22 GAIS 1-1 Halmstad 20/-9 1,88 1.12/26 0.88/8 1.33/12 0.93/14   26/-8 2,22 1.11/27 0.75/8 1.71/14 0.46/13
2010-09-29 GAIS 2-1 Hacken 21/-9 1,89 1.11/27 0.63/8 1.31/13 0.93/14   35/-4 2,74 1.26/27 1.00/8 1.36/14 1.15/13
2010-10-02 Helsingborg 0-1 GAIS 43/21 2,32 2.21/28 2.00/8 2.85/13 1.67/15   23/-8 1,93 1.18/28 1.00/8 1.43/14 0.93/14
2010-10-20 GAIS 0-1 Orebro 24/-7 1,90 1.24/29 1.00/8 1.43/14 1.07/15   42/15 2,38 1.86/29 1.63/8 2.40/15 1.29/14
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-30 GAIS 1-3 Trelleborgs 24/-9 1,84 1.16/31 0.88/8 1.33/15 1.00/16   35/-6 2,71 1.36/28 1.75/8 1.93/14 0.79/14
2010-10-30 GAIS 1-3 Trelleborg 25/-11 1,91 1.13/32 0.88/8 1.25/16 1.00/16   35/-6 2,71 1.36/28 1.75/8 1.93/14 0.79/14
2010-11-07 Elfsborg 1-0 GAIS 64/20 3,27 1.58/33 1.25/8 2.31/16 0.88/17   26/-13 1,97 1.09/33 0.88/8 1.18/17 1.00/16