SELECT * FROM 1_Kampe WHERE LigaID = '36' AND (Home='Morecambe' OR Away='Morecambe') 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 Grimsby 2-0 Morecambe 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 Morecambe 2-1 Blackpool 0/-2 2,00 0.00/1 0.00/1 0.00/0 0.00/1   2/2 2,00 3.00/1 3.00/1 3.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 Yeovil 0-1 Morecambe 3/1 1,67 1.33/3 1.33/3 3.00/1 0.50/2   4/1 2,33 2.00/3 2.00/3 3.00/2 0.00/1
2016-08-27 Accrington 2-3 Morecambe 5/-2 3,00 1.00/4 1.00/4 1.50/2 0.50/2   5/2 2,00 2.25/4 2.25/4 3.00/2 1.50/2
2016-09-03 Morecambe 1-2 Leyton Orient 8/3 2,60 2.40/5 2.40/5 3.00/2 2.00/3   7/2 2,40 1.40/5 1.40/5 1.00/3 2.00/2
2016-09-10 Morecambe 1-5 Doncaster 9/2 2,67 2.00/6 2.00/6 2.00/3 2.00/3   10/3 2,83 1.67/6 1.67/6 2.33/3 1.00/3
2016-09-17 Cambridge Utd 1-2 Morecambe 4/-7 2,14 0.43/7 0.43/7 0.67/3 0.25/4   10/-2 3,14 1.71/7 1.71/7 1.50/4 2.00/3
2016-09-24 Morecambe 2-3 Crawley 12/-1 3,13 1.88/8 1.88/8 1.50/4 2.25/4   8/-2 2,25 1.38/8 1.38/8 1.75/4 1.00/4
2016-09-27 Barnet 2-2 Morecambe 8/-2 2,25 1.25/8 1.25/8 1.25/4 1.25/4   14/-2 3,33 1.67/9 1.88/8 1.20/5 2.25/4
2016-10-08 Morecambe 0-3 Carlisle 16/-2 3,40 1.60/10 1.63/8 1.20/5 2.00/5   16/5 2,45 1.73/11 1.75/8 2.00/6 1.40/5
2016-10-11 Notts Co 1-2 Morecambe 18/1 3,18 1.55/11 2.00/8 1.00/5 2.00/6   16/-5 3,36 1.45/11 1.25/8 1.00/6 2.00/5
2016-10-15 Morecambe 0-2 Stevenage 18/-4 3,33 1.58/12 1.25/8 1.00/6 2.17/6   15/-4 3,09 1.00/11 1.25/8 1.50/6 0.40/5
2016-10-22 Colchester 2-2 Morecambe 16/-1 2,54 1.23/13 0.75/8 1.67/6 0.86/7   18/-6 3,23 1.46/13 0.88/8 0.86/7 2.17/6
2016-10-29 Morecambe 0-3 Exeter 20/-6 3,29 1.43/14 1.00/8 0.86/7 2.00/7   13/-6 2,29 0.93/14 0.88/8 0.14/7 1.71/7
2016-11-12 Wycombe 2-0 Morecambe 16/-5 2,47 1.07/15 1.38/8 1.86/7 0.38/8   20/-9 3,27 1.33/15 1.00/8 0.75/8 2.00/7
2016-11-19 Morecambe 0-2 Luton 20/-11 3,19 1.25/16 0.63/8 0.75/8 1.75/8   25/10 2,50 1.69/16 1.75/8 1.88/8 1.50/8
2016-11-22 Crewe 2-1 Morecambe 20/0 2,35 1.35/17 0.88/8 1.25/8 1.44/9   20/-13 3,12 1.18/17 0.63/8 0.67/9 1.75/8
2016-11-26 Morecambe 2-1 Plymouth 21/-14 3,11 1.11/18 0.50/8 0.67/9 1.56/9   28/9 2,61 2.11/18 2.00/8 1.70/10 2.63/8
2016-12-17 Morecambe 1-2 Cheltenham 23/-13 3,11 1.21/19 0.88/8 0.90/10 1.56/9   21/-10 2,60 0.90/20 1.00/8 1.00/11 0.78/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-30 Hartlepool 3-2 Morecambe 28/-10 3,00 1.05/22 0.88/8 1.00/11 1.09/11   25/-13 3,00 1.24/21 0.88/8 0.82/11 1.70/10
2017-01-02 Morecambe 0-0 Crewe 27/-14 3,09 1.18/22 0.75/8 0.82/11 1.55/11   24/-7 2,39 1.17/23 0.63/8 1.17/12 1.18/11
2017-01-07 Morecambe 4-1 Notts Co 27/-14 2,96 1.17/23 0.88/8 0.83/12 1.55/11   27/-17 2,96 0.92/24 0.00/8 0.54/13 1.36/11
2017-01-14 Carlisle 1-1 Morecambe 46/11 3,24 1.84/25 1.50/8 2.25/12 1.46/13   31/-11 3,04 1.25/24 1.25/8 1.00/13 1.55/11
2017-02-04 Doncaster 1-1 Morecambe 58/24 3,29 2.18/28 2.75/8 2.57/14 1.79/14   32/-11 3,00 1.24/25 1.38/8 1.00/13 1.50/12
2017-02-07 Leyton Orient 0-1 Morecambe 29/-14 2,57 0.89/28 0.50/8 0.67/15 1.15/13   33/-11 2,96 1.23/26 1.50/8 1.00/13 1.46/13
2017-02-11 Morecambe 2-0 Cambridge Utd 34/-10 2,89 1.30/27 1.50/8 1.00/13 1.57/14   36/4 2,43 1.39/28 1.38/8 1.20/15 1.62/13
2017-02-14 Morecambe 0-1 Barnet 36/-8 2,86 1.36/28 1.88/8 1.14/14 1.57/14   39/-3 2,70 1.37/30 1.00/8 1.20/15 1.53/15
2017-02-18 Crawley 1-3 Morecambe 37/-9 2,77 1.30/30 1.25/8 1.85/13 0.88/17   36/-9 2,79 1.31/29 1.50/8 1.07/15 1.57/14
2017-02-21 Newport 1-1 Morecambe 35/-15 2,74 0.81/31 1.00/8 0.80/15 0.81/16   39/-7 2,83 1.37/30 1.88/8 1.07/15 1.67/15
2017-02-25 Morecambe 1-0 Grimsby 40/-7 2,81 1.35/31 1.88/8 1.07/15 1.63/16   39/0 2,44 1.38/32 1.38/8 1.38/16 1.38/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 Blackpool 3-1 Morecambe 49/12 2,61 1.33/33 1.13/8 1.44/16 1.24/17   42/-6 2,73 1.39/33 1.88/8 1.19/16 1.59/17
2017-03-11 Morecambe 1-3 Yeovil 43/-8 2,76 1.35/34 1.75/8 1.19/16 1.50/18   33/-11 2,20 1.14/35 1.00/8 1.42/19 0.81/16
2017-03-14 Morecambe 0-1 Newport 44/-10 2,80 1.31/35 1.38/8 1.12/17 1.50/18   39/-19 2,77 0.83/35 0.88/8 0.76/17 0.89/18
2017-03-18 Plymouth 1-0 Morecambe 57/17 2,62 1.86/37 1.13/8 1.74/19 2.00/18   44/-11 2,75 1.28/36 1.00/8 1.06/18 1.50/18
2017-03-21 Morecambe 1-2 Accrington 44/-12 2,70 1.24/37 1.00/8 1.06/18 1.42/19   45/-2 2,56 1.25/36 2.00/8 1.50/18 1.00/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 Cheltenham 3-1 Morecambe 39/-16 2,41 1.00/39 1.25/8 1.10/20 0.89/19   46/-15 2,74 1.18/39 0.50/8 0.95/20 1.42/19
2017-04-08 Morecambe 1-1 Hartlepool 47/-17 2,78 1.15/40 0.13/8 0.95/20 1.35/20   49/-18 2,90 1.03/40 1.13/8 1.25/20 0.80/20
2017-04-14 Stevenage 0-1 Morecambe 65/9 2,95 1.59/41 2.00/8 1.70/20 1.48/21   48/-17 2,76 1.15/41 0.13/8 0.95/21 1.35/20
2017-04-17 Morecambe 1-1 Colchester 49/-16 2,71 1.19/42 0.50/8 0.95/21 1.43/21   61/6 2,76 1.45/42 1.38/8 2.00/21 0.90/21
2017-04-22 Exeter 3-1 Morecambe 67/16 2,74 1.51/43 1.38/8 1.24/21 1.77/22   50/-16 2,70 1.19/43 0.63/8 0.95/22 1.43/21
2017-04-29 Morecambe 1-1 Wycombe 51/-18 2,73 1.16/44 0.63/8 0.95/22 1.36/22   56/4 2,45 1.48/44 1.75/8 1.64/22 1.32/22
2017-05-06 Luton 3-1 Morecambe 67/25 2,42 1.64/45 1.88/8 1.68/22 1.61/23   52/-18 2,71 1.16/45 0.75/8 0.96/23 1.36/22