SELECT * FROM 1_Kampe WHERE LigaID = '36' AND (Home='Mansfield' OR Away='Mansfield') 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 Newport 2-3 Mansfield 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 Mansfield 1-1 Cheltenham 3/1 5,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 Mansfield 1-0 Yeovil 4/1 3,50 2.00/2 2.00/2 1.00/1 3.00/1   3/2 2,00 2.00/2 2.00/2 3.00/1 1.00/1
2016-08-20 Plymouth 2-0 Mansfield 2/-3 2,33 1.00/3 1.00/3 0.00/1 1.50/2   5/2 2,67 2.33/3 2.33/3 2.00/2 3.00/1
2016-08-27 Leyton Orient 1-2 Mansfield 6/3 2,25 1.75/4 1.75/4 1.50/2 2.00/2   5/0 2,50 1.75/4 1.75/4 2.00/2 1.50/2
2016-09-03 Mansfield 0-0 Cambridge Utd 7/1 2,60 2.00/5 2.00/5 2.00/2 2.00/3   3/-6 2,40 0.40/5 0.40/5 0.67/3 0.00/2
2016-09-10 Mansfield 0-1 Barnet 7/1 2,17 1.83/6 1.83/6 1.67/3 2.00/3   5/1 1,80 1.20/5 1.20/5 1.33/3 1.00/2
2016-09-17 Hartlepool 0-0 Mansfield 12/-4 4,00 1.29/7 1.29/7 0.67/3 1.75/4   7/0 2,00 1.57/7 1.57/7 1.25/4 2.00/3
2016-09-24 Mansfield 0-1 Grimsby 7/0 1,75 1.50/8 1.50/8 1.25/4 1.75/4   15/1 3,63 1.25/8 1.25/8 1.50/4 1.00/4
2016-09-27 Accrington 1-1 Mansfield 13/1 2,78 1.56/9 1.38/8 1.50/4 1.60/5   7/-1 1,67 1.33/9 1.13/8 1.00/5 1.75/4
2016-10-01 Crewe 1-1 Mansfield 14/0 2,80 1.60/10 1.50/8 1.80/5 1.40/5   8/-1 1,70 1.30/10 1.13/8 1.00/5 1.60/5
2016-10-08 Mansfield 3-1 Notts Co 9/-1 1,73 1.27/11 0.88/8 1.00/5 1.50/6   17/3 3,10 1.70/10 2.00/8 1.00/5 2.40/5
2016-10-15 Mansfield 1-1 Wycombe 12/1 1,92 1.42/12 1.25/8 1.33/6 1.50/6   13/-3 2,42 1.17/12 1.13/8 2.17/6 0.17/6
2016-10-22 Luton 1-1 Mansfield 23/9 2,85 1.69/13 1.50/8 1.83/6 1.57/7   13/1 1,92 1.38/13 1.00/8 1.29/7 1.50/6
2016-10-29 Mansfield 1-2 Stevenage 14/1 1,93 1.36/14 1.00/8 1.29/7 1.43/7   18/-3 3,00 1.08/13 1.25/8 1.29/7 0.83/6
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 Mansfield 3-1 Crawley 15/-4 2,13 1.19/16 0.88/8 1.13/8 1.25/8   17/-5 2,44 1.25/16 1.13/8 1.50/8 1.00/8
2016-11-22 Mansfield 1-0 Blackpool 18/-2 2,24 1.29/17 1.25/8 1.33/9 1.25/8   29/9 2,88 1.41/17 1.75/8 1.88/8 1.00/9
2016-11-26 Carlisle 5-2 Mansfield 32/11 2,94 1.94/18 2.38/8 2.33/9 1.56/9   19/-1 2,17 1.39/18 1.50/8 1.50/10 1.25/8
2016-12-10 Mansfield 0-0 Colchester 21/-4 2,42 1.32/19 1.38/8 1.50/10 1.11/9   27/1 2,79 1.21/19 1.00/8 1.56/9 0.90/10
2016-12-17 Exeter 2-0 Mansfield 23/-3 2,45 1.15/20 1.63/8 0.22/9 1.91/11   21/-4 2,30 1.30/20 1.13/8 1.45/11 1.11/9
2016-12-26 Mansfield 0-1 Morecambe 21/-6 2,29 1.24/21 1.00/8 1.45/11 1.00/10   24/-14 3,10 1.15/20 0.50/8 0.82/11 1.56/9
2016-12-31 Mansfield 1-1 Doncaster 21/-7 2,23 1.18/22 0.88/8 1.33/12 1.00/10   44/14 3,36 2.05/22 2.38/8 2.45/11 1.64/11
2017-01-02 Blackpool 0-1 Mansfield 36/12 2,61 1.48/23 2.00/8 1.80/10 1.23/13   22/-7 2,22 1.17/23 1.00/8 1.31/13 1.00/10
2017-01-07 Mansfield 3-0 Crewe 23/-6 2,17 1.25/24 1.38/8 1.31/13 1.18/11   24/-7 2,29 1.17/24 0.75/8 1.17/12 1.17/12
2017-01-14 Notts Co 0-0 Mansfield 28/-20 3,04 0.88/25 0.00/8 0.54/13 1.25/12   26/-3 2,20 1.32/25 1.38/8 1.43/14 1.18/11
2017-01-21 Cambridge Utd 1-3 Mansfield 35/9 2,44 1.56/25 2.50/8 1.38/13 1.75/12   26/-3 2,12 1.31/26 1.13/8 1.43/14 1.17/12
2017-01-28 Mansfield 2-0 Leyton Orient 29/-1 2,19 1.37/27 1.50/8 1.43/14 1.31/13   28/-11 2,58 0.96/26 0.88/8 0.71/14 1.25/12
2017-02-04 Barnet 0-2 Mansfield 38/0 2,71 1.46/28 1.38/8 1.29/14 1.64/14   31/1 2,18 1.43/28 1.75/8 1.53/15 1.31/13
2017-02-11 Mansfield 4-0 Hartlepool 33/3 2,17 1.48/29 2.13/8 1.53/15 1.43/14   37/-11 2,93 1.07/29 1.00/8 1.20/15 0.93/14
2017-02-14 Mansfield 4-4 Accrington 37/7 2,23 1.53/30 2.50/8 1.63/16 1.43/14   26/-11 2,25 1.04/28 1.00/8 1.21/14 0.86/14
2017-02-18 Grimsby 3-0 Mansfield 36/-3 2,42 1.32/31 1.38/8 1.27/15 1.38/16   41/7 2,42 1.52/31 2.50/8 1.59/17 1.43/14
2017-02-25 Mansfield 2-1 Newport 41/4 2,44 1.47/32 2.13/8 1.59/17 1.33/15   36/-15 2,72 0.81/32 1.13/8 0.81/16 0.81/16
2017-02-28 Yeovil 0-0 Mansfield 33/-7 2,21 1.18/33 1.00/8 1.53/17 0.81/16   43/5 2,45 1.52/33 2.13/8 1.67/18 1.33/15
2017-03-04 Cheltenham 0-0 Mansfield 38/-8 2,47 1.12/34 1.75/8 1.17/18 1.06/16   43/5 2,38 1.50/34 2.13/8 1.67/18 1.31/16
2017-03-11 Mansfield 0-2 Plymouth 43/5 2,31 1.49/35 1.88/8 1.67/18 1.29/17   54/15 2,66 1.86/35 1.38/8 1.74/19 2.00/16
2017-03-14 Colchester 2-0 Mansfield 51/3 2,75 1.42/36 1.25/8 1.88/17 1.00/19   43/3 2,31 1.44/36 1.50/8 1.58/19 1.29/17
2017-03-18 Mansfield 2-0 Carlisle 43/1 2,30 1.41/37 1.13/8 1.58/19 1.22/18   56/2 2,97 1.59/37 0.88/8 1.74/19 1.44/18
2017-03-25 Morecambe 1-3 Mansfield 45/-13 2,71 1.21/38 0.63/8 1.00/19 1.42/19   45/3 2,29 1.45/38 1.13/8 1.65/20 1.22/18
2017-04-01 Mansfield 1-2 Exeter 48/5 2,33 1.49/39 1.38/8 1.65/20 1.32/19   63/16 2,82 1.51/39 1.25/8 1.21/19 1.80/20
2017-04-08 Doncaster 1-0 Mansfield 80/34 3,15 2.03/40 2.13/8 2.25/20 1.80/20   49/4 2,35 1.45/40 1.38/8 1.57/21 1.32/19
2017-04-14 Wycombe 0-1 Mansfield 52/2 2,49 1.44/41 1.63/8 1.65/20 1.24/21   49/3 2,32 1.41/41 1.00/8 1.57/21 1.25/20
2017-04-17 Mansfield 1-1 Luton 50/4 2,29 1.45/42 1.25/8 1.57/21 1.33/21   60/21 2,36 1.60/42 1.25/8 1.62/21 1.57/21
2017-04-22 Stevenage 0-1 Mansfield 66/8 2,88 1.53/43 1.38/8 1.62/21 1.45/22   51/4 2,28 1.44/43 1.25/8 1.55/22 1.33/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 Crawley 2-2 Mansfield 51/-18 2,67 1.11/45 0.75/8 1.36/22 0.87/23   52/4 2,22 1.44/45 1.63/8 1.48/23 1.41/22