SELECT * FROM 1_Kampe WHERE LigaID = '36' AND (Home='Crewe' OR Away='Crewe') 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-10-21 Stevenage 0-1 Crewe 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-10-21 Crewe 0-1 Yeovil 17/0 2,62 1.46/13 1.63/8 1.67/6 1.29/7   13/-6 2,46 1.23/13 1.50/8 1.71/7 0.67/6
2018-10-21 Leyton Orient 0-1 Crewe 16/-2 2,43 1.07/14 0.63/8 0.43/7 1.71/7   17/-1 2,50 1.36/14 1.25/8 1.43/7 1.29/7
2018-10-21 Crewe 0-1 Plymouth 19/1 2,47 1.47/15 1.25/8 1.43/7 1.50/8   26/13 2,60 2.33/15 2.50/8 2.13/8 2.57/7
2018-10-21 Barnet 0-1 Crewe 22/-3 2,94 1.25/16 1.25/8 1.25/8 1.25/8   20/0 2,50 1.38/16 0.88/8 1.25/8 1.50/8
2018-10-21 Crewe 0-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
2018-10-21 Colchester 0-1 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
2018-10-21 Crewe 0-1 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
2018-10-21 Cambridge Utd 0-1 Crewe 26/3 2,45 1.40/20 1.88/8 1.10/10 1.70/10   22/-5 2,45 1.30/20 1.00/8 1.30/10 1.30/10
2018-10-21 Crewe 0-1 Carlisle 23/-6 2,48 1.24/21 0.88/8 1.30/10 1.18/11   40/15 3,10 2.00/21 2.13/8 2.45/11 1.50/10
2018-10-21 Notts Co 0-1 Crewe 19/0 3,17 1.42/12 1.63/8 0.83/6 2.00/6   16/0 2,67 1.50/12 1.50/8 1.67/6 1.33/6
2018-10-21 Luton 0-1 Crewe 20/8 2,91 1.64/11 1.38/8 2.00/5 1.33/6   15/0 2,73 1.55/11 1.50/8 1.67/6 1.40/5
2018-10-21 Crewe 0-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
2018-10-21 Crewe 0-1 Portsmouth 2/1 3,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
2018-10-21 Crewe 0-1 Hartlepool 2/1 1,50 2.00/2 2.00/2 1.00/1 3.00/1   3/1 2,50 2.00/2 2.00/2 1.00/1 3.00/1
2018-10-21 Newport 0-1 Crewe 4/-1 3,00 1.00/3 1.00/3 0.00/1 1.50/2   5/1 3,00 1.67/3 1.67/3 1.00/2 3.00/1
2018-10-21 Cheltenham 0-1 Crewe 3/-1 1,75 0.75/4 0.75/4 0.50/2 1.00/2   6/1 2,75 1.50/4 1.50/4 1.00/2 2.00/2
2018-10-21 Crewe 0-1 Doncaster 6/-1 2,60 1.20/5 1.20/5 1.00/2 1.33/3   9/4 2,80 2.00/5 2.00/5 2.33/3 1.50/2
2018-10-21 Crewe 0-1 Exeter 8/0 2,67 1.50/6 1.50/6 1.67/3 1.33/3   6/-3 2,50 1.00/6 1.00/6 0.00/3 2.00/3
2018-10-21 Grimsby 0-1 Crewe 15/3 3,86 1.43/7 1.43/7 2.00/3 1.00/4   10/2 2,57 1.71/7 1.71/7 2.00/4 1.33/3
2018-10-21 Crewe 0-1 Blackpool 12/4 2,50 1.88/8 1.88/8 2.00/4 1.75/4   11/2 2,50 1.13/8 1.13/8 1.25/4 1.00/4
2018-10-21 Wycombe 0-1 Crewe 7/-7 2,33 0.89/9 1.00/8 1.75/4 0.20/5   13/4 2,44 1.78/9 1.63/8 1.80/5 1.75/4
2018-10-21 Crewe 0-1 Accrington 24/-6 2,45 1.23/22 1.00/8 1.27/11 1.18/11   20/-9 2,23 0.95/22 0.13/8 1.09/11 0.82/11
2018-10-21 Morecambe 0-1 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
2018-10-21 Crawley 0-1 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
2018-10-21 Crewe 0-1 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
2018-10-21 Carlisle 0-1 Crewe 56/0 2,95 1.55/38 0.88/8 1.74/19 1.37/19   43/-11 2,55 1.18/38 1.63/8 1.26/19 1.11/19
2018-10-21 Crewe 0-1 Cambridge Utd 45/-9 2,54 1.23/39 1.63/8 1.26/19 1.20/20   48/4 2,36 1.38/39 1.38/8 1.15/20 1.63/19
2018-10-21 Accrington 0-1 Crewe 51/2 2,50 1.38/40 2.50/8 1.55/20 1.20/20   46/-10 2,55 1.20/40 1.50/8 1.20/20 1.20/20
2018-10-21 Crewe 0-1 Notts Co 48/-11 2,61 1.17/41 1.50/8 1.20/20 1.14/21   48/-19 2,80 1.27/41 2.25/8 1.19/21 1.35/20
2018-10-21 Yeovil 0-1 Crewe 43/-14 2,38 1.10/42 0.75/8 1.33/21 0.86/21   50/-11 2,64 1.17/42 1.63/8 1.19/21 1.14/21
2018-10-21 Crewe 0-1 Leyton Orient 50/-14 2,65 1.14/43 1.25/8 1.19/21 1.09/22   45/-33 2,86 0.84/43 0.50/8 0.59/22 1.10/21
2018-10-21 Plymouth 0-1 Crewe 68/24 2,55 1.89/44 1.88/8 1.77/22 2.00/22   53/-11 2,66 1.18/44 1.63/8 1.27/22 1.09/22
2018-10-21 Crewe 0-1 Newport 37/-15 2,54 1.11/35 1.38/8 1.24/17 1.00/18   37/-20 2,76 0.76/34 0.88/8 0.76/17 0.76/17
2018-10-21 Portsmouth 0-1 Crewe 49/19 2,39 1.70/33 1.75/8 1.88/16 1.53/17   36/-16 2,59 1.06/34 1.00/8 1.24/17 0.88/17
2018-10-21 Hartlepool 0-1 Crewe 39/-19 2,94 0.97/33 0.63/8 1.19/16 0.76/17   36/-12 2,55 1.09/33 1.00/8 1.24/17 0.94/16
2018-10-21 Mansfield 0-1 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
2018-10-21 Crewe 0-1 Luton 24/-10 2,32 1.12/25 0.63/8 1.17/12 1.08/13   34/12 2,33 1.58/24 1.38/8 1.58/12 1.58/12
2018-10-21 Doncaster 0-1 Crewe 52/19 3,27 2.12/26 2.38/8 2.54/13 1.69/13   25/-11 2,35 1.08/26 0.25/8 1.08/13 1.08/13
2018-10-21 Crewe 0-1 Cheltenham 26/-13 2,41 1.04/27 0.25/8 1.08/13 1.00/14   28/-11 2,58 0.92/26 0.75/8 0.93/15 0.91/11
2018-10-21 Exeter 0-1 Crewe 44/15 2,61 1.61/28 2.75/8 1.08/13 2.07/15   26/-13 2,32 1.04/28 0.38/8 1.07/14 1.00/14
2018-10-21 Crewe 0-1 Grimsby 26/-17 2,38 1.00/29 0.38/8 1.07/14 0.93/15   36/2 2,41 1.38/29 1.75/8 1.27/15 1.50/14
2018-10-21 Crewe 0-1 Wycombe 31/-12 2,47 1.07/30 0.63/8 1.20/15 0.93/15   37/2 2,48 1.59/29 1.50/8 2.14/14 1.07/15
2018-10-21 Blackpool 0-1 Crewe 43/12 2,47 1.37/30 1.00/8 1.50/14 1.25/16   33/-11 2,48 1.13/31 1.00/8 1.31/16 0.93/15
2018-10-21 Crewe 0-1 Stevenage 35/-11 2,53 1.13/32 1.00/8 1.31/16 0.94/16   50/1 3,09 1.44/32 2.00/8 1.38/16 1.50/16
2018-10-21 Crewe 0-1 Barnet 54/-12 2,67 1.16/45 1.25/8 1.27/22 1.04/23   56/-4 2,58 1.27/45 1.13/8 1.17/23 1.36/22