SELECT * FROM 1_Kampe WHERE LigaID = '172' AND (Home='Halmstad' OR Away='Halmstad') 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
2015-04-06 AIK 2-1 Halmstad 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
2015-04-09 Halmstad 0-3 Norrkoping 1/-1 3,00 0.00/1 0.00/1 0.00/0 0.00/1   1/0 2,00 1.00/1 1.00/1 1.00/1 0.00/0
2015-04-12 Halmstad 1-2 Helsingborg 1/-4 3,00 0.00/2 0.00/2 0.00/1 0.00/1   0/0 0,00 1.00/3 1.00/3 1.00/2 1.00/1
2015-04-18 Gefle 0-0 Halmstad 7/4 2,50 2.25/4 2.25/4 3.00/1 2.00/3   2/-5 3,00 0.00/3 0.00/3 0.00/2 0.00/1
2015-04-26 Halmstad 1-0 Elfsborg 2/-5 2,25 0.25/4 0.25/4 0.00/2 0.50/2   10/6 3,50 2.50/4 2.50/4 2.00/2 3.00/2
2015-04-29 Malmo FF 3-1 Halmstad 14/6 3,67 2.00/6 2.00/6 2.00/2 2.00/4   3/-4 2,00 0.80/5 0.80/5 1.00/3 0.50/2
2015-05-04 Halmstad 0-2 Hacken 4/-6 2,33 0.67/6 0.67/6 1.00/3 0.33/3   4/-4 2,00 0.83/6 0.83/6 0.33/3 1.33/3
2015-05-10 Falkenbergs 1-0 Halmstad 8/-5 3,00 0.71/7 0.71/7 1.33/3 0.25/4   4/-8 2,29 0.57/7 0.57/7 0.75/4 0.33/3
2015-05-10 Falkenberg 1-0 Halmstad 8/-5 3,00 0.71/7 0.71/7 1.33/3 0.25/4   4/-9 2,13 0.50/8 0.50/8 0.75/4 0.25/4
2015-05-18 Halmstad 2-3 Djurgarden 4/-10 2,00 0.44/9 0.50/8 0.75/4 0.20/5   23/11 3,50 2.20/10 2.63/8 2.40/5 2.00/5
2015-05-24 Halmstad 1-2 Goteborg 6/-11 2,30 0.40/10 0.50/8 0.60/5 0.20/5   18/13 2,09 2.55/11 2.38/8 2.57/7 2.50/4
2015-05-30 Hammarby 2-2 Halmstad 13/-2 2,55 1.27/11 0.88/8 2.40/5 0.33/6   7/-12 2,36 0.36/11 0.50/8 0.50/6 0.20/5
2015-06-03 Halmstad 1-0 Sundsvall 9/-12 2,50 0.42/12 0.50/8 0.50/6 0.33/6   16/-6 2,92 1.15/13 0.63/8 0.20/5 1.75/8
2015-06-06 Orebro 1-1 Halmstad 11/-13 2,50 0.93/14 1.50/8 1.57/7 0.29/7   10/-11 2,38 0.62/13 0.50/8 0.86/7 0.33/6
2015-07-04 Atvidabergs 0-0 Halmstad 14/-12 3,08 0.38/13 0.25/8 0.83/6 0.00/7   11/-11 2,36 0.64/14 0.63/8 0.86/7 0.43/7
2015-07-04 Atvidaberg 0-0 Halmstad 14/-12 3,08 0.38/13 0.25/8 0.83/6 0.00/7   11/-11 2,20 0.67/15 0.88/8 0.86/7 0.50/8
2015-07-11 Halmstad 1-0 Kalmar 11/-11 2,06 0.69/16 0.88/8 0.86/7 0.56/9   20/2 2,38 1.38/16 1.50/8 1.67/9 1.00/7
2015-07-18 Sundsvall 0-0 Halmstad 20/-10 2,94 1.00/17 0.50/8 0.43/7 1.40/10   12/-10 2,00 0.82/17 1.25/8 1.13/8 0.56/9
2015-07-27 Halmstad 0-1 Gefle 12/-10 1,89 0.83/18 1.38/8 1.13/8 0.60/10   21/-4 2,71 1.35/17 1.13/8 1.71/7 1.10/10
2015-08-02 Elfsborg 2-0 Halmstad 35/12 3,22 1.94/18 1.50/8 2.25/8 1.70/10   12/-11 1,84 0.79/19 1.38/8 1.00/9 0.60/10
2015-08-09 Halmstad 0-0 Atvidabergs 12/-13 1,85 0.75/20 1.25/8 1.00/9 0.55/11   18/-13 2,72 0.50/18 0.63/8 0.80/10 0.13/8
2015-08-09 Halmstad 0-0 Atvidaberg 12/-13 1,76 0.76/21 1.00/8 1.00/10 0.55/11   18/-13 2,72 0.50/18 0.63/8 0.80/10 0.13/8
2015-08-17 Helsingborg 2-0 Halmstad 35/7 2,74 1.61/23 1.88/8 1.82/11 1.42/12   12/-13 1,68 0.77/22 1.00/8 1.00/11 0.55/11
2015-08-23 Halmstad 2-2 Orebro 12/-15 1,70 0.74/23 0.88/8 1.00/11 0.50/12   16/-25 2,59 0.73/22 0.38/8 1.18/11 0.27/11
2015-08-29 Djurgarden 4-2 Halmstad 38/14 2,58 1.83/24 1.50/8 1.92/12 1.75/12   14/-15 1,79 0.75/24 0.88/8 1.00/12 0.50/12
2015-09-14 Hacken 4-1 Halmstad 25/-6 2,33 1.17/24 1.00/8 1.33/12 1.00/12   16/-17 1,96 0.72/25 0.50/8 1.00/12 0.46/13
2015-09-18 Halmstad 0-1 Falkenberg 17/-20 2,08 0.69/26 0.38/8 1.00/12 0.43/14   24/-18 2,87 0.83/23 0.75/8 1.00/12 0.64/11
2015-09-18 Halmstad 0-1 Falkenbergs 17/-21 2,04 0.67/27 0.38/8 0.92/13 0.43/14   24/-18 2,87 0.83/23 0.75/8 1.00/12 0.64/11
2015-09-23 Kalmar 1-0 Halmstad 34/0 2,43 1.21/28 0.75/8 1.50/14 0.93/14   17/-22 2,00 0.64/28 0.38/8 0.86/14 0.43/14
2015-09-26 Halmstad 0-0 Malmo FF 17/-23 1,97 0.62/29 0.25/8 0.86/14 0.40/15   61/23 3,41 1.90/29 2.38/8 2.27/15 1.50/14
2015-10-04 Goteborg 1-1 Halmstad 49/31 2,23 2.20/30 2.75/8 2.53/15 1.87/15   17/-23 1,90 0.63/30 0.25/8 0.87/15 0.40/15
2015-10-18 Halmstad 0-1 AIK 18/-23 1,90 0.65/31 0.38/8 0.87/15 0.44/16   61/24 3,16 2.16/31 2.63/8 2.88/16 1.40/15
2015-10-25 Norrkoping 3-1 Halmstad 61/27 2,97 2.19/32 2.63/8 2.38/16 2.00/16   18/-24 1,88 0.63/32 0.25/8 0.81/16 0.44/16
2015-10-31 Halmstad 2-1 Hammarby 19/-26 1,94 0.61/33 0.25/8 0.81/16 0.41/17   43/5 2,45 1.36/33 1.50/8 1.59/17 1.13/16