SELECT * FROM 1_Kampe WHERE LigaID = '177' 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
2018-10-21 Djurgarden 1-3 Halmstad 42/-4 2,67 1.39/33 1.00/8 1.94/16 0.88/17   34/-10 2,36 1.12/33 1.00/8 1.59/17 0.63/16
2018-10-21 Halmstad 1-3 Hacken 15/1 2,23 1.38/13 1.25/8 2.00/7 0.67/6   13/-3 2,23 1.23/13 0.38/8 1.38/8 1.00/5
2018-10-21 Kalmar 1-3 Halmstad 12/-4 2,33 0.92/12 1.00/8 0.80/5 1.00/7   15/2 2,33 1.50/12 1.63/8 2.00/7 0.80/5
2018-10-21 Brommapojkarna 1-3 Halmstad 6/1 1,10 1.50/10 1.75/8 1.75/4 1.33/6   15/3 2,45 1.64/11 2.00/8 2.00/7 1.00/4
2018-10-21 Halmstad 1-3 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
2018-10-21 Orebro 1-3 Halmstad 9/1 2,13 1.88/8 1.88/8 1.50/4 2.25/4   14/5 2,56 1.67/9 1.75/8 1.83/6 1.33/3
2018-10-21 Halmstad 1-3 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
2018-10-21 AIK 1-3 Halmstad 1/-4 1,20 0.40/5 0.40/5 0.50/2 0.33/3   10/1 2,71 1.29/7 1.29/7 1.60/5 0.50/2
2018-10-21 Halmstad 1-3 Mjallby 9/2 2,67 1.50/6 1.50/6 2.00/4 0.50/2   6/3 2,25 1.75/4 1.75/4 1.50/2 2.00/2
2018-10-21 Malmo FF 1-3 Halmstad 6/5 2,33 2.33/3 2.33/3 3.00/1 2.00/2   8/2 2,80 1.60/5 1.60/5 2.00/4 0.00/1
2018-10-21 Halmstad 1-3 Atvidabergs 4/-2 2,50 1.25/4 1.60/5 1.67/3 0.00/1   0/-3 1,50 0.00/2 0.00/2 0.00/1 0.00/1
2018-10-21 Elfsborg 1-3 Halmstad 0/0 0,00 1.00/1 1.00/1 0.00/0 1.00/1   0/0 0,00 1.00/2 1.00/2 1.00/2 0.00/0
2018-10-21 Halmstad 1-3 Trelleborgs 0/0 0,00 1.00/1 1.00/2 1.00/1 0.00/0   0/0 0,00 0.00/0 0.00/0 0.00/0 0.00/0
2018-10-21 Atvidaberg 1-3 Halmstad 16/-15 2,61 0.72/18 0.50/8 0.89/9 0.56/9   22/-5 2,23 1.14/22 0.63/8 1.82/11 0.45/11
2018-10-21 Trelleborg 1-3 Halmstad 15/-10 2,50 1.13/16 1.50/8 1.75/8 0.50/8   20/-2 2,21 1.26/19 0.75/8 2.00/10 0.44/9
2018-10-21 Halmstad 1-3 Atvidaberg 0/-6 2,00 0.67/3 0.67/3 1.00/2 0.00/1   0/-3 1,50 0.00/2 0.00/2 0.00/1 0.00/1
2018-10-21 Halmstad 1-3 Djurgarden 16/0 2,29 1.29/14 1.13/8 1.75/8 0.67/6   18/4 2,29 1.50/14 1.63/8 2.13/8 0.67/6
2018-10-21 Helsingborg 1-3 Halmstad 21/16 1,73 2.40/15 2.38/8 3.00/6 2.00/9   18/2 2,27 1.40/15 1.50/8 1.89/9 0.67/6
2018-10-21 Halmstad 1-3 Helsingborg 32/-8 2,25 1.16/32 1.38/8 1.69/16 0.63/16   52/28 2,38 2.22/32 2.25/8 2.69/16 1.75/16
2018-10-21 Halmstad 1-3 AIK 31/-7 2,23 1.19/31 1.38/8 1.80/15 0.63/16   30/-9 2,30 1.13/30 0.75/8 1.63/16 0.57/14
2018-10-21 Mjallby 1-3 Halmstad 35/6 2,21 1.38/29 1.00/8 1.57/14 1.20/15   31/-5 2,23 1.23/30 1.50/8 1.80/15 0.67/15
2018-10-21 Halmstad 1-3 Brommapojkarna 29/-7 2,24 1.17/29 1.25/8 1.71/14 0.67/15   20/-23 2,17 0.93/29 0.25/8 1.13/15 0.71/14
2018-10-21 Gefle 1-3 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
2018-10-21 GAIS 1-3 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
2018-10-21 Halmstad 1-3 Orebro 25/-8 2,23 1.12/26 0.63/8 1.77/13 0.46/13   36/13 2,36 1.88/25 1.88/8 2.31/13 1.42/12
2018-10-21 Hacken 1-3 Halmstad 31/-5 2,79 1.25/24 1.25/8 1.33/12 1.17/12   25/-6 2,24 1.16/25 1.00/8 1.77/13 0.50/12
2018-10-21 Halmstad 1-3 Kalmar 23/-7 2,21 1.08/24 0.63/8 1.67/12 0.50/12   28/-5 2,54 1.25/24 1.13/8 1.33/12 1.17/12
2018-10-21 Halmstad 1-3 Malmo FF 23/-5 2,22 1.13/23 0.63/8 1.82/11 0.50/12   41/22 2,86 2.29/21 2.25/8 2.83/12 1.56/9
2018-10-21 Atvidabergs 1-3 Halmstad 16/-15 2,61 0.72/18 0.50/8 0.89/9 0.56/9   21/-5 2,24 1.14/21 0.75/8 1.82/11 0.40/10
2018-10-21 Halmstad 1-3 Elfsborg 20/-3 2,15 1.20/20 0.75/8 2.00/10 0.40/10   36/12 3,16 1.63/19 1.50/8 2.40/10 0.78/9
2018-10-21 Trelleborgs 1-3 Halmstad 15/-10 2,50 1.13/16 1.50/8 1.75/8 0.50/8   20/-1 2,28 1.33/18 1.13/8 2.00/10 0.50/8
2018-10-21 Halmstad 1-3 Goteborg 19/-2 2,35 1.24/17 0.75/8 1.89/9 0.50/8   21/5 2,18 1.06/17 1.25/8 1.50/8 0.67/9
2018-10-21 Goteborg 1-3 Halmstad 18/2 2,13 0.94/16 0.88/8 1.29/7 0.67/9   19/1 2,31 1.31/16 1.13/8 1.89/9 0.57/7
2018-10-21 Halmstad 1-3 Trelleborg 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