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

2016-08-06

Portsmouth

1-1

Carlisle

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

2016-08-13

Crewe

0-0

Portsmouth

2/1

3,00

3.00/1

3.00/1

0.00/0

3.00/1

1/0

2,00

1.00/1

1.00/1

1.00/1

0.00/0

2016-08-16

Morecambe

2-0

Portsmouth

2/-1

2,50

1.50/2

1.50/2

3.00/1

0.00/1

1/0

1,00

1.00/2

1.00/2

1.00/1

1.00/1

2016-08-20

Portsmouth

2-0

Colchester

1/-2

1,33

0.67/3

0.67/3

1.00/1

0.50/2

6/3

3,00

2.33/3

2.33/3

3.00/2

1.00/1

2016-08-27

Exeter

0-1

Portsmouth

3/-3

2,25

0.75/4

0.75/4

0.00/2

1.50/2

3/0

1,50

1.25/4

1.25/4

2.00/2

0.50/2

2016-09-03

Portsmouth

3-0

Crawley

4/1

1,40

1.60/5

1.60/5

2.00/2

1.33/3

5/0

2,00

1.60/5

1.60/5

1.33/3

2.00/2

2016-09-10

Portsmouth

4-2

Wycombe

7/4

1,67

1.83/6

1.83/6

2.33/3

1.33/3

4/-5

2,17

0.83/6

0.83/6

1.33/3

0.33/3

2016-09-17

Accrington

1-0

Portsmouth

10/-1

3,00

1.14/7

1.14/7

1.00/3

1.25/4

11/6

2,29

2.00/7

2.00/7

2.50/4

1.33/3

2016-09-24

Portsmouth

5-1

Barnet

11/5

2,13

1.75/8

1.75/8

2.50/4

1.00/4

7/2

1,71

1.43/7

1.43/7

1.25/4

1.67/3

2016-09-27

Blackpool

3-1

Portsmouth

12/2

2,44

1.11/9

0.88/8

1.25/4

1.00/5

16/9

2,56

1.89/9

2.00/8

2.60/5

1.00/4

2016-10-01

Portsmouth

1-2

Doncaster

17/7

2,70

1.70/10

1.88/8

2.60/5

0.80/5

20/7

3,30

1.70/10

2.00/8

2.20/5

1.20/5

2016-10-08

Leyton Orient

0-1

Portsmouth

12/-2

2,36

1.09/11

1.00/8

0.60/5

1.50/6

18/6

2,73

1.55/11

1.88/8

2.17/6

0.80/5

2016-10-15

Plymouth

2-2

Portsmouth

19/10

2,33

2.33/12

2.75/8

2.17/6

2.50/6

19/7

2,58

1.67/12

1.88/8

2.17/6

1.17/6

2016-10-22

Portsmouth

1-2

Notts Co

21/7

2,69

1.62/13

1.63/8

2.17/6

1.14/7

20/0

3,08

1.38/13

1.38/8

0.86/7

2.00/6

2016-10-29

Cambridge Utd

0-1

Portsmouth

13/-5

2,21

1.14/14

1.63/8

1.14/7

1.14/7

22/6

2,71

1.50/14

1.25/8

1.86/7

1.14/7

2016-11-12

Portsmouth

4-0

Mansfield

23/7

2,60

1.60/15

1.25/8

1.86/7

1.38/8

15/0

2,00

1.27/15

1.00/8

1.13/8

1.43/7

2016-11-19

Cheltenham

1-1

Portsmouth

18/-3

2,44

1.06/16

1.25/8

1.25/8

0.88/8

27/11

2,69

1.69/16

1.63/8

2.00/8

1.38/8

2016-11-22

Luton

1-3

Portsmouth

27/12

2,47

1.76/17

1.75/8

1.88/8

1.67/9

28/11

2,65

1.65/17

1.38/8

2.00/8

1.33/9

2016-11-26

Portsmouth

1-2

Stevenage

31/13

2,72

1.72/18

1.75/8

2.00/8

1.50/10

23/-1

2,94

1.31/16

1.38/8

1.25/8

1.38/8

2016-12-10

Grimsby

0-1

Portsmouth

27/2

2,74

1.37/19

1.25/8

1.22/9

1.50/10

32/12

2,74

1.63/19

1.75/8

1.78/9

1.50/10

2016-12-17

Portsmouth

0-0

Hartlepool

33/13

2,65

1.70/20

1.75/8

1.78/9

1.64/11

28/-9

3,25

1.10/20

0.75/8

1.10/10

1.10/10

2016-12-26

Newport

2-3

Portsmouth

23/-9

2,75

0.85/20

1.25/8

0.67/9

1.00/11

33/13

2,52

1.67/21

1.75/8

1.70/10

1.64/11

2016-12-30

Yeovil

0-0

Portsmouth

25/-1

2,32

1.32/22

1.25/8

1.67/12

0.90/10

36/14

2,64

1.73/22

2.13/8

1.70/10

1.75/12

2017-01-02

Portsmouth

1-0

Luton

36/14

2,52

1.70/23

1.88/8

1.70/10

1.69/13

34/13

2,39

1.65/23

1.75/8

1.58/12

1.73/11

2017-01-05

Doncaster

3-1

Portsmouth

46/15

3,21

2.04/24

2.38/8

2.50/12

1.58/12

37/15

2,46

1.75/24

1.88/8

1.82/11

1.69/13

2017-01-14

Portsmouth

2-1

Leyton Orient

38/13

2,52

1.68/25

1.75/8

1.82/11

1.57/14

27/-10

2,56

1.00/25

0.88/8

0.71/14

1.36/11

2017-01-28

Portsmouth

0-1

Exeter

40/14

2,54

1.73/26

1.75/8

1.92/12

1.57/14

39/12

2,54

1.50/26

2.50/8

0.92/12

2.00/14

2017-02-04

Wycombe

1-0

Portsmouth

36/4

2,52

1.59/27

1.88/8

2.08/13

1.14/14

40/13

2,48

1.67/27

1.75/8

1.77/13

1.57/14

2017-02-11

Portsmouth

2-0

Accrington

40/12

2,43

1.61/28

1.38/8

1.77/13

1.47/15

26/-9

2,26

1.07/27

1.00/8

1.21/14

0.92/13

2017-02-14

Portsmouth

2-0

Blackpool

42/14

2,41

1.66/29

1.63/8

1.86/14

1.47/15

43/14

2,48

1.41/29

1.38/8

1.50/14

1.33/15

2017-02-18

Barnet

1-1

Portsmouth

40/-2

2,65

1.42/31

1.38/8

1.20/15

1.63/16

44/16

2,40

1.70/30

1.63/8

1.93/15

1.47/15

2017-02-25

Carlisle

0-3

Portsmouth

56/11

3,16

1.81/32

1.50/8

2.00/16

1.63/16

45/16

2,39

1.68/31

1.63/8

1.93/15

1.44/16

2017-02-28

Portsmouth

1-1

Morecambe

48/19

2,41

1.72/32

1.63/8

1.93/15

1.53/17

41/-6

2,75

1.41/32

1.88/8

1.19/16

1.63/16

2017-03-04

Portsmouth

0-1

Crewe

49/19

2,39

1.70/33

1.75/8

1.88/16

1.53/17

36/-16

2,59

1.06/34

1.00/8

1.24/17

0.88/17

2017-03-07

Crawley

0-2

Portsmouth

41/-11

2,74

1.26/34

1.00/8

1.56/16

1.00/18

49/18

2,35

1.65/34

1.38/8

1.76/17

1.53/17

2017-03-11

Colchester

0-4

Portsmouth

51/7

2,71

1.46/35

1.38/8

2.00/16

1.00/19

51/20

2,34

1.69/35

1.75/8

1.76/17

1.61/18

2017-03-14

Portsmouth

4-0

Grimsby

55/24

2,39

1.72/36

2.13/8

1.76/17

1.68/19

44/2

2,39

1.39/36

1.38/8

1.39/18

1.39/18

2017-03-18

Stevenage

3-0

Portsmouth

61/9

3,05

1.57/37

2.38/8

1.56/18

1.58/19

59/28

2,43

1.76/37

2.13/8

1.83/18

1.68/19

2017-03-25

Portsmouth

2-1

Newport

59/25

2,45

1.71/38

1.75/8

1.83/18

1.60/20

42/-20

2,74

0.87/38

1.00/8

0.74/19

1.00/19

2017-04-01

Hartlepool

0-2

Portsmouth

49/-16

2,92

1.05/39

1.25/8

1.32/19

0.80/20

61/26

2,46

1.74/39

2.00/8

1.89/19

1.60/20

2017-04-08

Portsmouth

3-1

Yeovil

63/28

2,45

1.78/40

2.00/8

1.89/19

1.67/21

42/-11

2,38

1.15/40

1.00/8

1.33/21

0.95/19

2017-04-14

Portsmouth

1-1

Plymouth

66/30

2,49

1.80/41

2.25/8

1.95/20

1.67/21

61/19

2,51

1.90/41

2.00/8

1.71/21

2.10/20

2017-04-17

Notts Co

1-3

Portsmouth

50/-19

2,83

1.26/42

2.00/8

1.19/21

1.33/21

67/30

2,48

1.79/42

2.38/8

1.90/21

1.67/21

2017-04-22

Portsmouth

2-1

Cambridge Utd

70/32

2,51

1.81/43

2.38/8

1.90/21

1.73/22

55/8

2,37

1.47/43

1.63/8

1.32/22

1.62/21

2017-04-29

Mansfield

0-1

Portsmouth

52/5

2,25

1.48/44

1.63/8

1.55/22

1.41/22

72/33

2,52

1.84/44

2.38/8

1.95/22

1.73/22

2017-05-06

Portsmouth

6-1

Cheltenham

73/34

2,49

1.87/45

2.38/8

1.95/22

1.78/23

48/-15

2,47

1.11/45

1.38/8

1.35/23

0.86/22