SELECT * FROM 1_Kampe WHERE LigaID = '167' AND (Home='Kalmar' OR Away='Kalmar') 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 Elfsborg 1-3 Kalmar 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
2018-10-21 Ostersunds 1-3 Kalmar 65/6 4,00 1.65/31 1.50/8 0.00/14 3.00/17   3/2 4,00 3.00/1 1.13/8 0.00/0 3.00/1
2018-10-21 Kalmar 1-3 Ostersunds 6/4 4,00 3.00/2 1.13/8 0.00/0 3.00/2   1/-2 4,00 0.00/1 1.50/8 0.00/1 0.00/0
2018-10-21 Varbergs 1-3 Kalmar 1/-2 4,00 0.00/1 1.50/8 0.00/1 0.00/0   7/2 4,00 2.00/3 1.13/8 0.00/1 3.00/2
2018-10-21 Falkenbergs 1-3 Kalmar 22/4 4,00 1.80/10 1.88/8 0.00/4 3.00/6   10/4 4,00 2.25/4 1.13/8 0.00/1 3.00/3
2018-10-21 Kalmar 1-3 Varbergs 13/6 4,00 2.40/5 1.13/8 0.00/1 3.00/4   73/-2 4,00 1.46/37 1.50/8 0.00/19 3.00/18
2018-10-21 Kalmar 1-3 Falkenbergs 14/4 4,00 2.00/6 1.13/8 0.00/2 3.00/4   0/0 0,00 0.00/0 0.00/0 0.00/0 0.00/0
2018-10-21 Hammarby 1-3 Kalmar 15/2 4,00 1.71/7 1.88/8 0.00/3 3.00/4   15/2 4,00 1.71/7 1.13/8 0.00/3 3.00/4
2018-10-21 Kalmar 1-3 Norrkoping 18/4 4,00 1.88/8 1.13/8 0.00/3 3.00/5   16/0 4,00 1.50/8 1.50/8 0.00/4 3.00/4
2018-10-21 Hacken 1-3 Kalmar 19/2 4,00 1.67/9 1.50/8 0.00/4 3.00/5   19/2 4,00 1.67/9 1.13/8 0.00/4 3.00/5
2018-10-21 Kalmar 1-3 Djurgarden 22/4 4,00 1.80/10 1.13/8 0.00/4 3.00/6   17/-2 4,00 1.33/9 1.13/8 0.00/5 3.00/4
2018-10-21 Kalmar 1-3 Sirius 23/2 4,00 1.64/11 1.13/8 0.00/5 3.00/6   29/-2 4,00 1.40/15 1.88/8 0.00/8 3.00/7
2018-10-21 AIK 1-3 Kalmar 24/0 4,00 1.50/12 1.13/8 0.00/6 3.00/6   24/0 4,00 1.50/12 1.13/8 0.00/6 3.00/6
2018-10-21 Kalmar 1-3 Mjallby 27/2 4,00 1.62/13 1.13/8 0.00/6 3.00/7   23/-6 4,00 1.15/13 1.13/8 0.00/8 3.00/5
2018-10-21 Kalmar 1-3 Varbergs 28/0 4,00 1.50/14 1.13/8 0.00/7 3.00/7   54/-4 4,00 1.39/28 1.50/8 0.00/15 3.00/13
2018-10-21 Djurgarden 1-3 Kalmar 28/0 4,00 1.50/14 1.13/8 0.00/7 3.00/7   29/-2 4,00 1.40/15 1.13/8 0.00/8 3.00/7
2018-10-21 Falkenbergs 1-3 Kalmar 55/2 4,00 1.56/27 1.88/8 0.00/13 3.00/14   32/0 4,00 1.50/16 1.13/8 0.00/8 3.00/8
2018-10-21 Kalmar 1-3 Helsingborg 35/2 4,00 1.59/17 1.13/8 0.00/8 3.00/9   24/0 4,00 1.50/12 1.13/8 0.00/6 3.00/6
2020-06-14 Norrkoping 2-1 Kalmar 34/4 4,00 1.69/16 1.50/8 0.00/7 3.00/9   36/0 4,00 1.50/18 1.13/8 0.00/9 3.00/9
2020-06-18 Kalmar 4-0 Helsingborg 37/-1 3,95 1.42/19 1.13/8 0.00/9 2.70/10   28/-3 3,93 1.40/15 1.13/8 0.00/8 3.00/7
2020-06-21 Falkenberg 0-2 Kalmar 2/1 1,50 2.00/2 2.00/2 1.00/1 3.00/1   41/3 3,95 1.50/20 1.13/8 0.30/10 2.70/10
2020-06-28 Djurgarden 5-0 Kalmar 37/-6 3,81 1.29/21 1.13/8 0.00/11 2.70/10   43/5 3,86 1.57/21 1.50/8 0.30/10 2.73/11
2020-07-01 Kalmar 1-2 Ostersund 43/0 3,91 1.50/22 1.50/8 0.30/10 2.50/12   2/-6 2,50 0.25/4 0.25/4 0.00/2 0.50/2
2020-07-06 Varberg 1-0 Kalmar 9/3 3,00 1.40/5 1.40/5 1.50/2 1.33/3   44/-1 3,87 1.43/23 1.13/8 0.27/11 2.50/12
2020-07-13 Kalmar 1-2 Elfsborg 44/-2 3,75 1.38/24 0.75/8 0.27/11 2.31/13   34/2 3,30 1.55/20 2.00/8 0.50/10 2.60/10
2020-07-16 Kalmar 1-2 Hammarby 45/-3 3,72 1.32/25 0.75/8 0.25/12 2.31/13   38/-3 3,43 1.39/23 1.00/8 0.58/12 2.27/11
2020-07-19 Malmo FF 2-1 Kalmar 47/3 3,50 1.54/26 1.63/8 0.62/13 2.46/13   46/-4 3,69 1.27/26 0.75/8 0.23/13 2.31/13
2020-07-23 Kalmar 1-1 Sirius 47/-5 3,67 1.22/27 0.75/8 0.23/13 2.14/14   49/5 3,58 1.62/26 1.88/8 0.62/13 2.62/13
2020-07-27 Mjallby 2-2 Kalmar 43/-8 3,48 1.37/27 1.63/8 0.46/13 2.21/14   48/-5 3,61 1.21/28 0.50/8 0.29/14 2.14/14
2020-08-02 Kalmar 0-0 AIK 50/-5 3,62 1.21/29 0.25/8 0.29/14 2.07/15   41/-10 3,41 1.22/27 0.75/8 0.36/14 2.15/13
2020-08-06 Kalmar 0-3 Orebro 50/-5 3,50 1.20/30 0.38/8 0.33/15 2.07/15   43/-7 3,21 1.28/29 1.00/8 0.53/15 2.07/14
2020-08-09 Hacken 0-2 Kalmar 59/13 3,50 1.60/30 1.75/8 1.13/15 2.07/15   50/-8 3,48 1.16/31 0.38/8 0.31/16 2.07/15
2020-08-13 Kalmar 1-1 Goteborg 52/-6 3,44 1.22/32 0.75/8 0.31/16 2.13/16   47/-3 3,34 1.31/29 0.75/8 0.47/15 2.21/14
2020-08-17 Ostersund 2-0 Kalmar 12/-6 2,00 1.00/15 1.00/8 0.29/7 1.63/8   53/-6 3,39 1.21/33 0.88/8 0.35/17 2.13/16
2020-08-24 Kalmar 1-4 Mjallby 53/-8 3,35 1.18/34 0.88/8 0.35/17 2.00/17   53/-7 3,42 1.33/33 0.88/8 0.71/17 2.00/16
2020-08-30 Hammarby 3-3 Kalmar 53/-2 3,27 1.45/33 1.50/8 0.81/16 2.06/17   54/-11 3,40 1.14/35 0.88/8 0.33/18 2.00/17
2020-09-09 Helsingborg 1-1 Kalmar 46/-12 3,25 1.16/32 1.00/8 0.75/16 1.56/16   57/-11 3,47 1.14/36 0.88/8 0.33/18 1.94/18
2020-09-14 Kalmar 0-2 Norrkoping 58/-11 3,43 1.14/37 0.88/8 0.33/18 1.89/19   74/14 3,83 1.60/35 0.63/8 1.06/17 2.11/18
2020-09-20 Goteborg 1-2 Kalmar 55/-6 3,31 1.26/35 1.00/8 0.41/17 2.06/18   58/-13 3,39 1.11/38 0.75/8 0.32/19 1.89/19
2020-09-28 Kalmar 1-1 Varberg 60/-12 3,38 1.15/39 1.13/8 0.32/19 1.95/20   31/-2 3,05 1.24/21 1.25/8 1.55/11 0.90/10
2020-10-04 Kalmar 0-4 Malmo FF 61/-12 3,35 1.15/40 0.88/8 0.35/20 1.95/20   78/21 3,38 1.78/40 1.63/8 1.33/21 2.26/19
2020-10-18 Elfsborg 3-1 Kalmar 64/5 3,32 1.54/37 0.75/8 0.89/18 2.16/19   61/-16 3,37 1.12/41 0.75/8 0.33/21 1.95/20
2020-10-25 Kalmar 0-0 Falkenberg 62/-18 3,38 1.10/42 0.75/8 0.33/21 1.86/21   26/-16 2,83 0.79/24 0.75/8 0.83/12 0.75/12
2020-11-01 Sirius 2-2 Kalmar 75/1 3,55 1.50/42 1.00/8 0.95/20 2.00/22   62/-18 3,30 1.09/43 0.88/8 0.36/22 1.86/21
2020-11-08 Orebro 0-1 Kalmar 66/-5 3,19 1.40/43 2.00/8 1.09/22 1.71/21   64/-18 3,32 1.09/44 0.88/8 0.36/22 1.82/22
2020-11-22 Kalmar 0-3 Djurgarden 65/-17 3,27 1.13/45 1.13/8 0.36/22 1.87/23   77/8 3,24 1.47/45 1.38/8 0.92/24 2.10/21
2020-11-30 AIK 0-1 Kalmar 58/-6 2,77 1.34/44 2.13/8 0.87/23 1.86/21   65/-20 3,26 1.11/46 1.13/8 0.35/23 1.87/23
2020-12-06 Kalmar 0-0 Hacken 66/-19 3,21 1.15/47 1.13/8 0.35/23 1.92/24   80/18 3,09 1.63/46 1.63/8 1.35/23 1.91/23