SELECT * FROM 1_Kampe WHERE LigaID = '5' 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
2018-08-04 Portsmouth 1-0 Luton 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-08-11 Blackpool 1-2 Portsmouth 0/0 0,00 1.00/1 1.00/1 0.00/0 1.00/1   1/1 1,00 3.00/1 3.00/1 3.00/1 0.00/0
2018-08-18 Portsmouth 4-1 Oxford Utd 3/2 2,00 3.00/2 3.00/2 3.00/1 3.00/1   0/-6 3,00 0.00/2 0.00/2 0.00/1 0.00/1
2018-08-21 Bristol Rovers 1-2 Portsmouth 4/-1 3,00 1.00/3 1.00/3 0.00/1 1.50/2   7/5 3,00 3.00/3 3.00/3 3.00/2 3.00/1
2018-08-25 Doncaster 0-0 Portsmouth 6/3 2,25 1.75/4 1.75/4 2.00/2 1.50/2   9/6 3,00 3.00/4 3.00/4 3.00/2 3.00/2
2018-09-01 Portsmouth 3-0 Plymouth 9/6 2,40 2.60/5 2.60/5 3.00/2 2.33/3   4/-6 2,80 0.40/5 0.40/5 0.67/3 0.00/2
2018-09-08 Portsmouth 1-1 Shrewsbury 12/9 2,50 2.67/6 2.67/6 3.00/3 2.33/3   4/-3 1,83 0.50/6 0.50/6 0.67/3 0.33/3
2018-09-15 Peterborough 1-2 Portsmouth 19/12 3,71 2.71/7 2.71/7 2.33/3 3.00/4   13/9 2,43 2.43/7 2.43/7 2.50/4 2.33/3
2018-09-22 Portsmouth 2-2 Wycombe 15/10 2,50 2.50/8 2.50/8 2.50/4 2.50/4   7/-4 2,25 0.88/8 0.88/8 0.75/4 1.00/4
2018-09-29 Rochdale 1-3 Portsmouth 14/-6 3,78 1.22/9 1.00/8 0.75/4 1.60/5   17/10 2,67 2.33/9 2.25/8 2.20/5 2.50/4
2018-10-02 Coventry 0-1 Portsmouth 8/-3 1,90 1.20/10 1.38/8 1.40/5 1.00/5   20/12 2,80 2.40/10 2.25/8 2.20/5 2.60/5
2018-10-06 Portsmouth 0-2 Gillingham 21/13 2,64 2.45/11 2.25/8 2.20/5 2.67/6   13/-7 3,30 0.80/10 0.25/8 0.80/5 0.80/5
2018-10-13 AFC Wimbledon 1-2 Portsmouth 9/-7 2,08 0.92/12 0.75/8 0.67/6 1.17/6   21/11 2,58 2.25/12 1.88/8 1.83/6 2.67/6
2018-10-20 Portsmouth 1-0 Fleetwood 23/12 2,62 2.31/13 2.13/8 1.83/6 2.71/7   21/9 2,54 1.54/13 1.50/8 1.29/7 1.83/6
2018-10-23 Portsmouth 2-2 Burton 24/13 2,50 2.36/14 2.13/8 2.00/7 2.71/7   16/-1 2,54 1.31/13 1.75/8 1.86/7 0.67/6
2018-10-27 Accrington 1-1 Portsmouth 19/2 2,40 1.73/15 2.00/8 1.71/7 1.75/8   26/13 2,60 2.27/15 2.13/8 1.88/8 2.71/7
2018-11-03 Bradford City 0-1 Portsmouth 12/-18 2,63 0.63/16 0.50/8 0.50/8 0.75/8   27/13 2,56 2.19/16 1.88/8 1.88/8 2.50/8
2018-11-24 Scunthorpe 1-2 Portsmouth 28/-10 3,67 1.17/18 0.88/8 1.11/9 1.22/9   28/14 2,47 2.24/17 2.13/8 1.88/8 2.56/9
2018-11-27 Portsmouth 2-0 Walsall 30/15 2,50 2.28/18 2.13/8 1.88/8 2.60/10   21/-5 2,47 1.42/19 1.00/8 1.20/10 1.67/9
2018-12-08 Portsmouth 2-0 Southend 32/17 2,47 2.32/19 2.13/8 2.00/9 2.60/10   25/-1 2,55 1.30/20 1.13/8 1.30/10 1.30/10
2018-12-11 Portsmouth 1-2 Charlton 34/19 2,45 2.35/20 2.50/8 2.10/10 2.60/10   32/8 2,80 1.70/20 2.00/8 2.00/10 1.40/10
2018-12-15 Barnsley 1-1 Portsmouth 34/14 2,70 1.75/20 1.25/8 2.11/9 1.45/11   35/18 2,48 2.24/21 2.13/8 1.91/11 2.60/10
2018-12-22 Portsmouth 3-1 Sunderland 36/18 2,45 2.18/22 1.88/8 1.91/11 2.45/11   41/22 3,00 2.15/20 2.50/8 2.20/10 2.10/10
2018-12-26 Gillingham 2-0 Portsmouth 33/-5 3,09 1.09/23 1.25/8 1.00/11 1.17/12   39/20 2,52 2.22/23 2.13/8 2.00/12 2.45/11
2018-12-29 Fleetwood 2-5 Portsmouth 33/8 2,42 1.38/24 1.25/8 1.83/12 0.92/12   39/18 2,50 2.13/24 2.00/8 2.00/12 2.25/12
2019-01-01 Portsmouth 2-1 AFC Wimbledon 44/21 2,68 2.16/25 2.00/8 2.00/12 2.31/13   19/-16 2,16 0.88/25 1.38/8 0.92/13 0.83/12
2019-01-12 Portsmouth 0-1 Blackpool 46/22 2,69 2.19/26 2.00/8 2.08/13 2.31/13   26/1 2,04 1.40/25 0.88/8 1.62/13 1.17/12
2019-01-19 Oxford Utd 2-1 Portsmouth 33/-10 2,81 1.00/27 1.13/8 1.38/13 0.64/14   46/21 2,63 2.11/27 1.63/8 1.93/14 2.31/13
2019-01-29 Luton 3-2 Portsmouth 55/30 2,76 2.03/29 2.25/8 2.57/14 1.53/15   47/20 2,64 2.04/28 1.25/8 1.93/14 2.14/14
2019-02-02 Portsmouth 1-1 Doncaster 49/19 2,72 1.97/29 1.25/8 1.93/14 2.00/15   51/14 3,14 1.64/28 1.75/8 1.86/14 1.43/14
2019-02-09 Plymouth 1-1 Portsmouth 39/-13 2,94 1.16/31 2.00/8 1.40/15 0.94/16   50/19 2,70 1.93/30 1.25/8 1.87/15 2.00/15
2019-02-16 Southend 3-3 Portsmouth 40/-1 2,53 1.22/32 0.88/8 1.19/16 1.25/16   51/19 2,68 1.90/31 1.00/8 1.87/15 1.94/16
2019-02-19 Portsmouth 1-1 Bristol Rovers 54/19 2,78 1.88/32 1.13/8 1.87/15 1.88/17   30/-4 2,06 1.06/31 1.63/8 0.88/16 1.27/15
2019-02-23 Portsmouth 0-0 Barnsley 55/19 2,76 1.85/33 0.88/8 1.81/16 1.88/17   59/31 2,64 2.00/33 2.50/8 2.29/17 1.69/16
2019-03-02 Portsmouth 5-1 Bradford City 55/19 2,68 1.82/34 0.63/8 1.76/17 1.88/17   38/-17 2,74 0.97/34 0.75/8 1.18/17 0.76/17
2019-03-09 Charlton 2-1 Portsmouth 51/16 2,46 1.71/35 1.63/8 2.06/17 1.39/18   60/23 2,77 1.86/35 1.00/8 1.83/18 1.88/17
2019-03-12 Walsall 2-3 Portsmouth 39/-16 2,61 1.17/36 0.88/8 1.22/18 1.11/18   61/22 2,78 1.81/36 1.00/8 1.83/18 1.78/18
2019-03-16 Portsmouth 2-0 Scunthorpe 64/23 2,84 1.84/37 1.38/8 1.83/18 1.84/19   46/-16 2,92 1.19/37 1.25/8 1.26/19 1.11/18
2019-03-23 Shrewsbury 0-2 Portsmouth 42/-8 2,42 1.13/38 1.50/8 1.63/19 0.63/19   66/25 2,82 1.87/38 1.63/8 1.89/19 1.84/19
2019-04-06 Wycombe 2-3 Portsmouth 48/-12 2,77 1.13/39 0.13/8 1.53/19 0.75/20   68/27 2,79 1.90/39 1.88/8 1.89/19 1.90/20
2019-04-13 Portsmouth 4-1 Rochdale 71/28 2,85 1.93/40 2.13/8 1.89/19 1.95/21   50/-29 3,15 1.10/41 1.38/8 1.05/21 1.15/20
2019-04-19 Burton 1-2 Portsmouth 60/12 2,57 1.43/42 2.13/8 1.67/21 1.19/21   75/31 2,90 1.95/41 2.38/8 1.95/20 1.95/21
2019-04-22 Portsmouth 2-1 Coventry 77/32 2,90 1.98/42 2.63/8 1.95/20 2.00/22   52/3 2,35 1.49/43 1.75/8 1.50/22 1.48/21
2019-04-27 Sunderland 1-1 Portsmouth 77/35 2,77 1.95/43 1.88/8 2.05/22 1.86/21   79/33 2,91 2.00/43 2.63/8 2.00/21 2.00/22
2019-04-30 Portsmouth 2-3 Peterborough 80/33 2,89 1.98/44 2.75/8 2.00/21 1.96/23   65/6 2,82 1.50/44 1.38/8 1.41/22 1.59/22
2019-05-04 Portsmouth 1-1 Accrington 82/32 2,93 1.93/45 2.38/8 1.91/22 1.96/23   50/-16 2,58 1.20/45 1.25/8 1.17/23 1.23/22