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
2010-03-14 Halmstad 0-0 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
2010-03-22 Elfsborg 6-0 Halmstad 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-28 Halmstad 4-0 Atvidaberg 0/-6 3,00 0.50/2 0.50/2 1.00/1 0.00/1   0/-3 1,50 0.00/2 0.00/2 0.00/1 0.00/1
2010-04-06 Malmo FF 1-1 Halmstad 6/5 2,33 2.33/3 2.33/3 3.00/1 2.00/2   4/-2 3,33 1.33/3 1.33/3 2.00/2 0.00/1
2010-04-11 Halmstad 1-2 Mjallby 5/-2 3,00 1.25/4 1.25/4 2.00/2 0.50/2   6/3 2,25 1.75/4 1.75/4 1.50/2 2.00/2
2010-04-14 AIK 0-1 Halmstad 1/-4 1,20 0.40/5 0.40/5 0.50/2 0.33/3   6/-3 3,00 1.00/5 1.00/5 1.33/3 0.50/2
2010-04-18 Halmstad 3-0 GAIS 7/-2 2,67 1.33/6 1.33/6 1.33/3 1.33/3   7/1 2,17 1.67/6 1.67/6 2.33/3 1.00/3
2010-04-25 Orebro 3-0 Halmstad 7/-1 2,14 1.71/7 1.71/7 1.00/3 2.25/4   10/1 2,71 1.57/7 1.57/7 1.75/4 1.33/3
2010-04-28 Halmstad 1-0 Gefle 10/-2 2,75 1.38/8 1.38/8 1.75/4 1.00/4   9/-2 2,50 1.25/8 1.25/8 1.00/4 1.50/4
2010-05-02 Brommapojkarna 1-0 Halmstad 5/0 1,11 1.33/9 1.50/8 1.75/4 1.00/5   11/-1 2,56 1.56/9 1.63/8 2.00/5 1.00/4
2010-05-05 Kalmar 1-0 Halmstad 11/-4 2,60 0.90/10 1.00/8 0.80/5 1.00/5   11/-2 2,40 1.40/10 1.63/8 2.00/5 0.80/5
2010-05-09 Halmstad 1-2 Hacken 11/-3 2,27 1.27/11 1.25/8 2.00/5 0.67/6   9/-5 2,09 1.09/11 0.38/8 1.17/6 1.00/5
2010-05-15 Halmstad 2-0 Djurgarden 12/-4 2,33 1.17/12 1.13/8 1.67/6 0.67/6   13/0 2,17 1.25/12 1.63/8 1.83/6 0.67/6
2010-05-22 Helsingborg 2-1 Halmstad 18/13 1,77 2.46/13 2.38/8 3.00/6 2.00/7   14/-2 2,31 1.31/13 1.50/8 1.86/7 0.67/6
2010-07-17 Goteborg 3-0 Halmstad 16/4 2,00 1.07/14 1.25/8 1.29/7 0.86/7   15/-3 2,36 1.21/14 1.13/8 1.86/7 0.57/7
2010-07-25 Halmstad 1-0 Goteborg 15/-6 2,40 1.13/15 0.75/8 1.86/7 0.50/8   19/7 2,07 1.20/15 1.25/8 1.50/8 0.86/7
2010-08-02 Trelleborg 1-0 Halmstad 15/-10 2,50 1.13/16 1.50/8 1.75/8 0.50/8   16/-5 2,31 1.25/16 1.13/8 2.00/8 0.50/8
2010-08-08 Halmstad 1-3 Elfsborg 16/-6 2,24 1.18/17 0.75/8 2.00/8 0.44/9   31/9 3,12 1.59/17 1.50/8 2.33/9 0.75/8
2010-08-16 Atvidaberg 1-1 Halmstad 16/-15 2,61 0.72/18 0.50/8 0.89/9 0.56/9   17/-8 2,33 1.11/18 0.75/8 1.78/9 0.44/9
2010-08-23 Halmstad 0-2 Malmo FF 18/-8 2,32 1.11/19 0.88/8 1.78/9 0.50/10   36/18 2,84 2.21/19 2.25/8 2.80/10 1.56/9
2010-08-29 Halmstad 2-1 Kalmar 18/-10 2,30 1.05/20 0.88/8 1.60/10 0.50/10   24/-5 2,65 1.25/20 1.25/8 1.30/10 1.20/10
2010-09-10 Hacken 2-0 Halmstad 25/-6 2,67 1.24/21 1.38/8 1.20/10 1.27/11   20/-9 2,33 1.14/21 0.88/8 1.73/11 0.50/10
2010-09-19 Halmstad 1-1 Orebro 20/-11 2,32 1.09/22 0.88/8 1.73/11 0.45/11   30/7 2,41 1.73/22 1.63/8 2.18/11 1.27/11
2010-09-22 GAIS 1-1 Halmstad 19/-8 2,00 1.09/23 0.88/8 1.36/11 0.83/12   21/-11 2,30 1.09/23 1.00/8 1.67/12 0.45/11
2010-09-27 Gefle 1-2 Halmstad 26/-11 2,63 0.96/24 0.88/8 1.08/12 0.83/12   22/-11 2,29 1.08/24 0.75/8 1.67/12 0.50/12
2010-10-03 Halmstad 2-0 Brommapojkarna 24/-10 2,32 1.16/25 1.13/8 1.67/12 0.69/13   18/-16 2,08 0.96/25 0.25/8 1.31/13 0.58/12
2010-10-17 Mjallby 2-0 Halmstad 31/6 2,15 1.38/26 1.25/8 1.62/13 1.15/13   26/-8 2,31 1.23/26 1.50/8 1.77/13 0.69/13
2010-10-25 Halmstad 1-2 AIK 26/-10 2,30 1.19/27 1.38/8 1.77/13 0.64/14   24/-10 2,15 1.04/27 0.75/8 1.43/14 0.62/13
2010-10-31 Halmstad 2-4 Helsingborg 27/-11 2,32 1.14/28 1.38/8 1.64/14 0.64/14   45/21 2,46 2.18/28 1.88/8 2.64/14 1.71/14
2010-11-07 Djurgarden 0-2 Halmstad 35/-5 2,59 1.38/29 1.38/8 1.79/14 1.00/15   29/-13 2,45 1.10/29 1.00/8 1.53/15 0.64/14
2018-10-21 Halmstad 1-3 Trelleborgs 31/-11 2,43 1.17/30 1.38/8 1.53/15 0.80/15   57/-2 4,00 1.45/29 1.88/8 0.00/15 3.00/14
2018-10-21 Halmstad 1-3 Atvidabergs 32/-13 2,48 1.13/31 1.13/8 1.44/16 0.80/15   22/-4 4,00 1.25/12 1.88/8 0.00/7 3.00/5
2018-10-21 Atvidabergs 1-3 Halmstad 52/0 4,00 1.50/26 1.88/8 0.00/13 3.00/13   33/-15 2,53 1.09/32 1.13/8 1.35/17 0.80/15
2018-10-21 Trelleborgs 1-3 Halmstad 56/0 4,00 1.50/28 1.88/8 0.00/14 3.00/14   36/-13 2,58 1.15/33 1.13/8 1.35/17 0.94/16