SELECT * FROM 1_Kampe WHERE LigaID = '36' AND (Home='Crawley' OR Away='Crawley') 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 Crawley 1-0 Wycombe 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 Doncaster 1-1 Crawley 2/-1 5,00 0.00/1 0.00/1 0.00/0 0.00/1   1/1 1,00 3.00/1 3.00/1 3.00/1 0.00/0
2016-08-16 Exeter 0-1 Crawley 1/-3 2,50 0.00/2 0.00/2 0.00/1 0.00/1   2/1 1,50 2.00/2 2.00/2 3.00/1 1.00/1
2016-08-20 Crawley 1-1 Barnet 3/2 1,33 2.33/3 2.33/3 3.00/1 2.00/2   4/2 2,00 1.67/3 1.67/3 2.00/2 1.00/1
2016-08-27 Crawley 1-3 Notts Co 4/2 1,50 2.00/4 2.00/4 2.00/2 2.00/2   4/-2 2,50 1.00/4 1.00/4 0.50/2 1.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 Stevenage 2-1 Crawley 12/-1 4,17 1.17/6 1.17/6 2.00/3 0.33/3   5/-3 2,17 1.33/6 1.33/6 1.33/3 1.33/3
2016-09-17 Crawley 2-0 Luton 6/-4 2,29 1.14/7 1.14/7 1.33/3 1.00/4   15/8 3,14 1.86/7 1.86/7 1.75/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 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 Crawley 1-0 Blackpool 12/-1 2,50 1.50/10 1.38/8 1.60/5 1.40/5   15/4 2,60 1.30/10 1.25/8 1.60/5 1.00/5
2016-10-08 Hartlepool 1-1 Crawley 17/-1 3,18 1.36/11 1.25/8 0.80/5 1.83/6   13/0 2,36 1.64/11 1.38/8 1.83/6 1.40/5
2016-10-15 Cheltenham 2-1 Crawley 13/-3 2,42 0.83/12 0.88/8 1.00/6 0.67/6   14/0 2,33 1.58/12 1.38/8 1.83/6 1.33/6
2016-10-22 Crawley 0-0 Accrington 15/-1 2,38 1.46/13 1.38/8 1.83/6 1.14/7   18/1 2,69 1.46/13 1.88/8 1.57/7 1.33/6
2016-10-29 Carlisle 3-1 Crawley 24/10 2,71 2.00/14 2.25/8 2.14/7 1.86/7   15/-1 2,21 1.43/14 1.50/8 1.71/7 1.14/7
2016-11-12 Crawley 1-3 Cambridge Utd 16/-3 2,33 1.33/15 1.50/8 1.71/7 1.00/8   13/-6 2,13 1.07/15 1.63/8 1.00/8 1.14/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-26 Crawley 3-2 Grimsby 18/-7 2,53 1.18/17 0.75/8 1.50/8 0.89/9   25/3 2,61 1.44/18 1.25/8 1.22/9 1.67/9
2016-12-03 Yeovil 5-0 Crawley 19/-4 2,33 1.39/18 1.88/8 1.78/9 1.00/9   21/-6 2,67 1.28/18 1.00/8 1.67/9 0.89/9
2016-12-10 Crewe 0-2 Crawley 22/-3 2,47 1.37/19 1.13/8 1.44/9 1.30/10   21/-11 2,79 1.21/19 0.63/8 1.67/9 0.80/10
2016-12-17 Crawley 3-1 Newport 23/-9 2,75 1.30/20 0.88/8 1.67/9 1.00/11   22/-7 2,68 0.89/19 1.25/8 0.67/9 1.10/10
2016-12-26 Leyton Orient 3-2 Crawley 22/-5 2,33 1.00/21 1.13/8 0.55/11 1.50/10   26/-7 2,81 1.38/21 1.25/8 1.80/10 1.00/11
2016-12-31 Plymouth 2-0 Crawley 35/11 2,68 2.05/22 1.63/8 1.75/12 2.40/10   28/-8 2,91 1.32/22 1.13/8 1.80/10 0.92/12
2017-01-02 Crawley 2-0 Yeovil 28/-10 2,87 1.26/23 1.13/8 1.80/10 0.85/13   25/-1 2,22 1.30/23 1.25/8 1.62/13 0.90/10
2017-01-14 Crawley 1-0 Hartlepool 30/-8 2,83 1.33/24 1.50/8 1.91/11 0.85/13   33/-10 3,04 1.08/25 1.00/8 1.08/13 1.08/12
2017-01-28 Notts Co 2-1 Crawley 28/-22 2,89 0.85/27 0.13/8 0.57/14 1.15/13   31/-7 2,76 1.40/25 1.88/8 2.00/12 0.85/13
2017-02-04 Crawley 1-2 Stevenage 32/-8 2,77 1.35/26 1.50/8 2.00/12 0.79/14   42/-4 3,14 1.29/28 1.13/8 1.14/14 1.43/14
2017-02-07 Blackpool 0-0 Crawley 39/11 2,48 1.37/27 1.25/8 1.54/13 1.21/14   33/-9 2,78 1.30/27 1.50/8 1.85/13 0.79/14
2017-02-11 Luton 2-1 Crawley 42/14 2,41 1.59/29 1.38/8 1.57/14 1.60/15   33/-9 2,68 1.29/28 1.25/8 1.85/13 0.80/15
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 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-25 Wycombe 1-2 Crawley 39/-1 2,47 1.44/32 0.63/8 2.00/15 0.94/17   38/-11 2,81 1.26/31 1.25/8 1.71/14 0.88/17
2017-02-28 Crawley 1-2 Exeter 40/-10 2,81 1.31/32 1.25/8 1.71/14 1.00/18   53/16 2,73 1.55/33 1.88/8 1.19/16 1.88/17
2017-03-04 Crawley 0-0 Doncaster 41/-11 2,82 1.27/33 0.88/8 1.60/15 1.00/18   66/24 3,18 2.00/34 1.63/8 2.29/17 1.71/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 Barnet 2-2 Crawley 43/-4 2,57 1.31/35 0.75/8 1.12/17 1.50/18   41/-13 2,71 1.23/35 1.00/8 1.47/17 1.00/18
2017-03-14 Crawley 0-3 Crewe 43/-13 2,75 1.22/36 1.00/8 1.47/17 1.00/19   38/-16 2,56 1.08/36 1.25/8 1.17/18 1.00/18
2017-03-18 Grimsby 1-1 Crawley 44/-2 2,43 1.35/37 1.25/8 1.39/18 1.32/19   43/-16 2,76 1.19/37 1.00/8 1.39/18 1.00/19
2017-03-25 Crawley 3-0 Leyton Orient 44/-16 2,74 1.18/38 0.75/8 1.39/18 1.00/20   41/-26 2,84 0.84/38 0.75/8 0.50/20 1.22/18
2017-04-01 Newport 1-0 Crawley 43/-21 2,74 0.85/39 1.00/8 0.74/19 0.95/20   47/-13 2,74 1.23/39 1.13/8 1.47/19 1.00/20
2017-04-08 Crawley 1-2 Plymouth 47/-14 2,70 1.20/40 0.75/8 1.47/19 0.95/21   59/18 2,50 1.88/40 1.63/8 1.71/21 2.05/19
2017-04-14 Crawley 0-0 Cheltenham 48/-15 2,71 1.17/41 0.75/8 1.40/20 0.95/21   45/-14 2,54 1.05/41 1.00/8 1.19/21 0.90/20
2017-04-17 Accrington 1-0 Crawley 54/3 2,50 1.40/42 2.25/8 1.62/21 1.19/21   48/-15 2,64 1.17/42 0.75/8 1.38/21 0.95/21
2017-04-22 Crawley 3-3 Carlisle 48/-16 2,60 1.14/43 0.75/8 1.38/21 0.91/22   61/-1 2,86 1.49/43 0.75/8 1.55/22 1.43/21
2017-04-29 Cambridge Utd 2-0 Crawley 56/7 2,39 1.43/44 1.63/8 1.32/22 1.55/22   51/-16 2,68 1.14/44 0.75/8 1.36/22 0.91/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