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

2016-08-06

Stevenage

1-2

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

2016-08-13

Crewe

0-0

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

2016-08-16

Crewe

3-3

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

2016-08-20

Newport

1-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

2016-08-27

Cheltenham

2-0

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

2016-09-03

Crewe

2-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

2016-09-10

Crewe

2-0

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

2016-09-17

Grimsby

0-2

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

2016-09-24

Crewe

1-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

2016-09-27

Wycombe

5-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

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

Luton

1-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

2016-10-15

Notts Co

1-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

2016-10-22

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

2016-10-29

Leyton Orient

0-2

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

2016-11-12

Crewe

1-2

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

2016-11-19

Barnet

0-0

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

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

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

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

Cambridge Utd

2-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

2016-12-26

Crewe

1-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

2016-12-31

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

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

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

Crewe

1-2

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

2017-01-21

Doncaster

3-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

2017-01-28

Crewe

0-0

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

2017-02-04

Exeter

4-0

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

2017-02-11

Crewe

5-0

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

2017-02-14

Crewe

2-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

2017-02-18

Blackpool

2-2

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

2017-02-25

Crewe

1-2

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

2017-02-28

Hartlepool

4-0

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

2017-03-04

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

2017-03-11

Crewe

1-2

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

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

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

Carlisle

0-2

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

2017-04-01

Crewe

1-2

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

2017-04-08

Accrington

3-2

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

2017-04-14

Crewe

2-2

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

2017-04-17

Yeovil

3-0

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

2017-04-22

Crewe

3-0

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

2017-04-29

Plymouth

2-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

2017-05-06

Crewe

4-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