SELECT * FROM 1_Kampe WHERE LigaID = '36' AND (Home='Colchester' OR Away='Colchester') 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 Hartlepool 1-1 Colchester 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 Colchester 2-0 Cambridge Utd 1/0 2,00 1.00/1 1.00/1 0.00/0 1.00/1   1/0 2,00 1.00/1 1.00/1 1.00/1 0.00/0
2016-08-16 Colchester 3-2 Grimsby 3/2 2,00 2.00/2 2.00/2 3.00/1 1.00/1   3/1 2,50 1.50/2 1.50/2 3.00/1 0.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 Wycombe 0-2 Colchester 3/0 1,50 1.25/4 1.25/4 2.00/2 0.50/2   6/1 2,75 1.75/4 1.75/4 3.00/2 0.50/2
2016-09-03 Colchester 2-3 Exeter 8/3 2,60 2.00/5 2.00/5 3.00/2 1.33/3   3/-4 2,00 0.60/5 0.60/5 0.00/3 1.50/2
2016-09-10 Colchester 3-2 Blackpool 10/2 3,00 1.67/6 1.67/6 2.00/3 1.33/3   7/3 1,83 1.33/6 1.33/6 1.33/3 1.33/3
2016-09-17 Barnet 1-1 Colchester 6/2 1,67 1.50/6 1.50/6 1.33/3 1.67/3   13/3 3,29 1.86/7 1.86/7 2.25/4 1.33/3
2016-09-24 Colchester 1-2 Accrington 14/3 3,13 1.75/8 1.75/8 2.25/4 1.25/4   11/0 2,75 1.38/8 1.38/8 1.50/4 1.25/4
2016-09-27 Crawley 1-1 Colchester 11/-1 2,56 1.56/9 1.38/8 1.75/4 1.40/5   15/2 3,11 1.56/9 1.63/8 1.80/5 1.25/4
2016-10-01 Carlisle 2-0 Colchester 14/3 2,50 1.60/10 1.50/8 1.80/5 1.40/5   16/2 3,00 1.50/10 1.38/8 1.80/5 1.20/5
2016-10-08 Colchester 0-0 Newport 16/0 2,91 1.36/11 1.00/8 1.80/5 1.00/6   10/-5 2,78 0.67/9 0.75/8 0.50/4 0.80/5
2016-10-15 Doncaster 1-0 Colchester 25/9 3,42 1.92/12 2.00/8 2.33/6 1.50/6   16/0 2,67 1.33/12 1.13/8 1.67/6 1.00/6
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 Plymouth 2-1 Colchester 24/12 2,57 2.29/14 2.50/8 2.00/7 2.57/7   18/-1 2,64 1.21/14 0.88/8 1.57/7 0.86/7
2016-11-12 Colchester 0-3 Leyton Orient 19/-2 2,67 1.13/15 0.50/8 1.57/7 0.75/8   16/-4 2,40 1.00/15 0.50/8 0.38/8 1.71/7
2016-11-19 Yeovil 2-1 Colchester 16/-5 2,31 1.31/16 1.75/8 1.63/8 1.00/8   19/-5 2,69 1.06/16 0.38/8 1.38/8 0.75/8
2016-11-22 Cheltenham 0-3 Colchester 19/-3 2,41 1.06/17 1.38/8 1.22/9 0.88/8   20/-6 2,71 1.00/17 0.38/8 1.38/8 0.67/9
2016-11-26 Colchester 4-0 Crewe 23/-3 2,72 1.11/18 0.63/8 1.38/8 0.90/10   22/1 2,39 1.44/18 1.25/8 1.44/9 1.44/9
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 Colchester 2-1 Notts Co 27/1 2,65 1.20/20 1.00/8 1.56/9 0.91/11   24/-10 2,90 1.10/20 0.63/8 0.64/11 1.67/9
2016-12-26 Luton 0-1 Colchester 31/12 2,38 1.67/21 1.63/8 1.60/10 1.73/11   29/2 2,67 1.29/21 1.38/8 1.70/10 0.91/11
2016-12-31 Stevenage 2-4 Colchester 33/-1 3,05 1.36/22 1.63/8 0.91/11 1.82/11   30/3 2,59 1.36/22 1.63/8 1.70/10 1.08/12
2017-01-02 Colchester 2-0 Cheltenham 34/5 2,74 1.43/23 2.00/8 1.70/10 1.23/13   24/-11 2,57 0.91/23 0.50/8 0.85/13 1.00/10
2017-01-07 Colchester 4-1 Carlisle 36/7 2,71 1.50/24 2.38/8 1.82/11 1.23/13   45/14 3,17 1.92/24 1.88/8 2.25/12 1.58/12
2017-01-14 Newport 1-1 Colchester 28/-16 3,00 0.71/24 0.00/8 0.55/11 0.85/13   40/10 2,80 1.56/25 2.75/8 1.92/12 1.23/13
2017-01-21 Exeter 3-0 Colchester 36/9 2,52 1.44/25 2.50/8 0.73/11 2.00/14   41/10 2,77 1.54/26 2.50/8 1.92/12 1.21/14
2017-02-04 Blackpool 1-1 Colchester 38/11 2,50 1.38/26 1.50/8 1.58/12 1.21/14   41/7 2,78 1.48/27 2.13/8 1.92/12 1.13/15
2017-02-11 Colchester 2-1 Barnet 42/7 2,75 1.46/28 2.13/8 1.92/12 1.13/16   38/-2 2,69 1.41/29 1.38/8 1.20/15 1.64/14
2017-02-14 Colchester 2-3 Crawley 44/8 2,76 1.52/29 2.13/8 2.00/13 1.13/16   34/-10 2,69 1.24/29 0.88/8 1.85/13 0.75/16
2017-02-18 Accrington 2-1 Colchester 30/-11 2,45 1.03/29 1.13/8 1.21/14 0.87/15   46/7 2,83 1.47/30 1.75/8 1.86/14 1.13/16
2017-02-21 Colchester 1-0 Wycombe 47/6 2,84 1.42/31 1.38/8 1.86/14 1.06/17   39/0 2,52 1.48/31 1.00/8 2.00/15 1.00/16
2017-02-25 Colchester 2-1 Hartlepool 48/7 2,78 1.47/32 1.38/8 1.93/15 1.06/17   38/-18 2,94 1.00/32 0.63/8 1.19/16 0.81/16
2017-02-28 Grimsby 1-0 Colchester 39/-1 2,39 1.33/33 1.00/8 1.38/16 1.29/17   50/8 2,79 1.52/33 1.38/8 2.00/16 1.06/17
2017-03-04 Cambridge Utd 1-1 Colchester 43/3 2,52 1.39/33 0.88/8 1.24/17 1.56/16   50/7 2,74 1.47/34 1.25/8 2.00/16 1.00/18
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 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 Crewe 2-0 Colchester 41/-13 2,57 1.14/37 1.63/8 1.17/18 1.11/19   53/5 2,73 1.46/37 1.25/8 1.94/18 1.00/19
2017-03-25 Colchester 2-1 Luton 53/3 2,71 1.42/38 1.25/8 1.94/18 0.95/20   55/20 2,37 1.58/38 1.38/8 1.58/19 1.58/19
2017-04-01 Notts Co 3-1 Colchester 43/-22 2,77 1.18/39 2.00/8 1.10/20 1.26/19   55/4 2,72 1.46/39 1.63/8 2.00/19 0.95/20
2017-04-08 Colchester 4-0 Stevenage 56/2 2,75 1.43/40 1.25/8 2.00/19 0.90/21   65/13 2,93 1.63/40 2.38/8 1.70/20 1.55/20
2017-04-14 Colchester 1-1 Doncaster 60/6 2,78 1.46/41 1.25/8 2.05/20 0.90/21   81/35 3,10 2.05/41 2.38/8 2.29/21 1.80/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 Colchester 0-0 Plymouth 62/6 2,74 1.44/43 1.38/8 2.00/21 0.91/22   68/24 2,60 1.91/43 2.13/8 1.77/22 2.05/21
2017-04-29 Leyton Orient 1-3 Colchester 45/-36 2,86 0.82/44 0.50/8 0.59/22 1.05/22   62/6 2,68 1.43/44 1.50/8 1.95/22 0.91/22
2017-05-06 Colchester 2-0 Yeovil 65/8 2,71 1.47/45 1.50/8 1.95/22 1.00/23   49/-13 2,47 1.11/45 0.75/8 1.39/23 0.82/22