SELECT * FROM 1_Kampe WHERE LigaID = '167' AND (Home='AIK' OR Away='AIK') 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

AIK

1-3

Djurgarden

0/0

0,00

0.00/0

0.00/0

0.00/0

0.00/0

20/0

4,00

1.50/10

1.13/8

0.00/5

3.00/5

2018-10-21

Varbergs

1-3

AIK

6/-4

4,00

0.75/4

1.50/8

0.00/3

3.00/1

1/-2

4,00

0.00/1

1.13/8

0.00/1

0.00/0

2018-10-21

AIK

1-3

Ostersunds

4/0

4,00

1.50/2

1.13/8

0.00/1

3.00/1

42/4

4,00

1.65/20

1.50/8

0.00/9

3.00/11

2018-10-21

Falkenbergs

1-3

AIK

66/4

4,00

1.59/32

1.88/8

0.00/15

3.00/17

5/-2

4,00

1.00/3

1.13/8

0.00/2

3.00/1

2018-10-21

AIK

1-3

Falkenbergs

8/0

4,00

1.50/4

1.13/8

0.00/2

3.00/2

4/0

4,00

1.50/2

1.88/8

0.00/1

3.00/1

2018-10-21

AIK

1-3

Varbergs

9/-2

4,00

1.20/5

1.13/8

0.00/3

3.00/2

19/-6

4,00

1.09/11

1.50/8

0.00/7

3.00/4

2018-10-21

Ostersunds

1-3

AIK

78/4

4,00

1.58/38

1.50/8

0.00/18

3.00/20

10/-4

4,00

1.00/6

1.13/8

0.00/4

3.00/2

2018-10-21

Hacken

1-3

AIK

15/2

4,00

1.71/7

1.50/8

0.00/3

3.00/4

13/-2

4,00

1.29/7

1.13/8

0.00/4

3.00/3

2018-10-21

AIK

1-3

Sirius

16/0

4,00

1.50/8

1.13/8

0.00/4

3.00/4

14/-4

4,00

1.13/8

1.88/8

0.00/5

3.00/3

2018-10-21

Mjallby

1-3

AIK

22/-4

4,00

1.25/12

1.13/8

0.00/7

3.00/5

17/-2

4,00

1.33/9

1.13/8

0.00/5

3.00/4

2018-10-21

AIK

1-3

Ostersunds

20/0

4,00

1.50/10

1.13/8

0.00/5

3.00/5

46/4

4,00

1.64/22

1.50/8

0.00/10

3.00/12

2018-10-21

Helsingborg

1-3

AIK

18/4

4,00

1.88/8

1.13/8

0.00/3

3.00/5

21/-2

4,00

1.36/11

1.13/8

0.00/6

3.00/5

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

AIK

1-3

Goteborg

25/-2

4,00

1.38/13

1.13/8

0.00/7

3.00/6

20/0

4,00

1.50/10

1.88/8

0.00/5

3.00/5

2018-10-21

AIK

1-3

Malmo FF

26/-4

4,00

1.29/14

1.13/8

0.00/8

3.00/6

31/2

4,00

1.60/15

1.50/8

0.00/7

3.00/8

2018-10-21

Orebro

1-3

AIK

30/4

4,00

1.71/14

1.50/8

0.00/6

3.00/8

27/-6

4,00

1.20/15

1.13/8

0.00/9

3.00/6

2020-06-14

Orebro

0-2

AIK

33/-2

4,00

1.41/17

1.50/8

0.00/9

3.00/8

30/-4

4,00

1.31/16

1.13/8

0.00/9

3.00/7

2020-06-17

AIK

1-4

Norrkoping

32/-2

3,88

1.41/17

1.50/8

0.00/9

3.00/8

36/5

3,94

1.76/17

1.88/8

0.38/8

3.00/9

2020-06-21

Hammarby

0-2

AIK

36/2

3,89

1.56/18

2.00/8

0.33/9

2.78/9

33/-5

3,94

1.33/18

1.50/8

0.00/10

3.00/8

2020-06-28

AIK

2-2

Malmo FF

35/-3

3,84

1.42/19

1.88/8

0.00/10

3.00/9

41/2

3,81

1.52/21

1.75/8

0.36/11

2.80/10

2020-07-02

Goteborg

1-0

AIK

37/2

3,79

1.53/19

1.38/8

0.11/9

2.80/10

37/-3

3,85

1.40/20

2.00/8

0.09/11

3.00/9

2020-07-05

AIK

1-1

Falkenberg

37/-4

3,71

1.33/21

1.25/8

0.09/11

2.70/10

4/-4

2,40

0.80/5

0.80/5

0.33/3

1.50/2

2020-07-12

Helsingborg

2-0

AIK

30/-9

3,45

1.15/20

0.63/8

0.10/10

2.20/10

38/-4

3,64

1.32/22

1.38/8

0.17/12

2.70/10

2020-07-15

AIK

1-0

Sirius

38/-6

3,57

1.26/23

1.00/8

0.17/12

2.45/11

45/4

3,58

1.63/24

1.50/8

0.42/12

2.83/12

2020-07-19

Varberg

2-2

AIK

11/4

2,25

1.63/8

1.63/8

2.25/4

1.00/4

39/-5

3,46

1.33/24

1.38/8

0.38/13

2.45/11

2020-07-22

Hacken

4-0

AIK

52/10

3,62

1.58/26

1.63/8

0.83/12

2.21/14

41/-5

3,48

1.32/25

1.13/8

0.38/13

2.33/12

2020-07-26

AIK

0-1

Djurgarden

41/-9

3,50

1.27/26

1.13/8

0.38/13

2.15/13

47/-1

3,39

1.36/28

1.38/8

0.53/15

2.31/13

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

AIK

1-2

Elfsborg

41/-10

3,29

1.21/28

0.75/8

0.36/14

2.07/14

48/3

3,58

1.62/26

1.88/8

0.77/13

2.46/13

2020-08-09

Mjallby

3-1

AIK

47/-8

3,40

1.33/30

1.13/8

0.53/15

2.13/15

42/-11

3,28

1.17/29

0.75/8

0.33/15

2.07/14

2020-08-13

AIK

0-1

Ostersund

43/-13

3,30

1.13/30

0.63/8

0.33/15

1.93/15

11/-7

2,07

0.86/14

1.00/8

0.29/7

1.43/7

2020-08-16

Falkenberg

1-1

AIK

17/-8

2,80

0.80/15

0.88/8

0.43/7

1.13/8

43/-14

3,23

1.10/31

0.63/8

0.31/16

1.93/15

2020-08-23

AIK

2-0

Helsingborg

44/-14

3,19

1.09/32

0.38/8

0.31/16

1.88/16

43/-12

3,27

1.13/30

0.88/8

0.60/15

1.67/15

2020-08-30

AIK

0-1

Hacken

46/-12

3,15

1.15/33

0.63/8

0.47/17

1.88/16

65/15

3,38

1.68/34

2.00/8

1.18/17

2.18/17

2020-09-13

Malmo FF

0-0

AIK

74/18

3,51

1.78/37

2.13/8

1.26/19

2.33/18

46/-13

3,09

1.12/34

0.63/8

0.44/18

1.88/16

2020-09-20

AIK

3-0

Hammarby

46/-13

3,00

1.11/35

0.75/8

0.44/18

1.82/17

62/2

3,39

1.47/36

1.63/8

0.83/18

2.11/18

2020-09-28

AIK

1-0

Mjallby

49/-10

3,00

1.17/36

1.00/8

0.58/19

1.82/17

63/-4

3,42

1.37/38

1.50/8

0.80/20

2.00/18

2020-10-04

Ostersund

1-2

AIK

21/-1

1,95

1.36/22

2.25/8

0.91/11

1.82/11

50/-9

2,95

1.22/37

1.38/8

0.70/20

1.82/17

2020-10-18

AIK

2-0

Goteborg

52/-8

2,95

1.26/38

1.75/8

0.70/20

1.89/18

57/-6

3,16

1.26/38

1.13/8

0.53/19

2.00/19

2020-10-26

Norrkoping

2-2

AIK

83/18

3,70

1.65/40

1.38/8

1.00/19

2.24/21

54/-6

2,92

1.31/39

2.13/8

0.81/21

1.89/18

2020-10-29

Sirius

0-0

AIK

75/1

3,63

1.51/41

1.25/8

0.95/19

2.00/22

56/-6

2,95

1.30/40

2.13/8

0.81/21

1.84/19

2020-11-02

AIK

1-0

Varberg

56/-6

2,88

1.29/41

1.88/8

0.81/21

1.80/20

33/-5

2,84

1.12/25

1.00/8

1.38/13

0.83/12

2020-11-08

Djurgarden

0-1

AIK

77/9

3,30

1.50/44

1.50/8

0.96/23

2.10/21

57/-5

2,83

1.33/42

2.25/8

0.91/22

1.80/20

2020-11-22

AIK

0-2

Orebro

58/-4

2,79

1.37/43

2.50/8

0.91/22

1.86/21

66/-6

3,14

1.36/44

1.63/8

1.04/23

1.71/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

Elfsborg

2-2

AIK

75/11

3,23

1.65/43

1.88/8

1.19/21

2.09/22

58/-7

2,73

1.31/45

1.75/8

0.83/24

1.86/21