4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Wycombe Wanderers

Wycombe Wanderers

Entrenador: Matt Bloomfield

Temporada 2016/2017
TEMPORADA 2016/2017
LEAGUE TWO
Equipo PJ GF GC Puntos
1 Portsmouth Portsmouth 46 79 40 87
2 Plymouth Argyle Plymouth 46 71 46 87
3 Doncaster Rovers Doncaster 46 85 55 85
4 Luton Town Luton Town 46 70 43 77
5 Exeter City Exeter City 46 75 56 71
6 Carlisle United Carlisle 46 69 68 71
7 Blackpool Blackpool 46 69 46 70
8 Colchester United Colchester 46 67 57 69
9 Wycombe Wanderers Wycombe 46 58 53 69
10 Stevenage Stevenage 46 67 63 67
11 Cambridge United Cambridge 46 58 50 66
12 Mansfield Town Mansfield 46 54 50 66
13 Accrington Stanley Accrington 46 59 56 65
14 Grimsby Town Grimsby Town 46 59 63 62
15 Barnet Barnet 46 57 64 57
16 Notts County Notts County 46 54 76 56
17 Crewe Alexandra Crewe 46 58 67 55
18 Morecambe Morecambe 46 53 73 52
19 Crawley Town Crawley Town 46 53 71 51
20 Yeovil Town Yeovil Town 46 49 64 50
21 Cheltenham Town Cheltenham 46 49 69 50
22 Newport County Newport 46 51 73 48
23 Hartlepool United Hartlepool 46 54 75 46
24 Leyton Orient Leyton 46 47 87 36
TEMPORADA 2015/2016
LEAGUE TWO
Equipo PJ GF GC Puntos
1 Northampton Northampton 46 82 46 99
2 Oxford United Oxford 46 84 41 86
3 Bristol Rovers Bristol 46 77 46 85
4 Accrington Stanley Accrington 46 74 48 85
5 Plymouth Argyle Plymouth 46 72 46 81
6 Portsmouth Portsmouth 46 75 44 78
7 AFC Wimbledon Wimbledon 46 64 50 75
8 Leyton Orient Leyton 46 60 61 69
9 Cambridge United Cambridge 46 66 55 68
10 Carlisle United Carlisle 46 67 62 67
11 Luton Town Luton Town 46 63 61 66
12 Mansfield Town Mansfield 46 61 53 64
13 Wycombe Wanderers Wycombe 46 45 44 64
14 Exeter City Exeter City 46 63 65 64
15 Barnet Barnet 46 67 68 62
16 Hartlepool United Hartlepool 46 49 72 51
17 Notts County Notts County 46 54 83 51
18 Stevenage Stevenage 46 52 67 48
19 Yeovil Town Yeovil Town 46 43 59 48
20 Crawley Town Crawley Town 46 45 78 47
21 Morecambe Morecambe 46 69 91 46
22 Newport County Newport 46 43 64 43
23 Dagenham & Redbridge Dagenham 46 46 81 34
24 York City York City 46 51 87 34
TEMPORADA 2014/2015
LEAGUE TWO
Equipo PJ GF GC Puntos
1 Burton Albion Burton 46 69 39 94
2 Shrewsbury Town Shrewsbury 46 67 31 89
3 Bury Bury 46 60 40 85
4 Wycombe Wanderers Wycombe 46 67 45 84
5 Southend United Southend 46 54 38 84
6 Stevenage Stevenage 46 62 54 72
7 Plymouth Argyle Plymouth 46 55 37 71
8 Luton Town Luton Town 46 54 44 68
9 Newport County Newport 46 51 54 65
10 Exeter City Exeter City 46 61 65 64
11 Morecambe Morecambe 46 53 52 63
12 Northampton Northampton 46 67 62 61
13 Oxford United Oxford 46 50 49 61
14 Dagenham & Redbridge Dagenham 46 58 59 59
15 AFC Wimbledon Wimbledon 46 54 60 58
16 Portsmouth Portsmouth 46 52 54 57
17 Accrington Stanley Accrington 46 58 77 56
18 York City York City 46 46 51 52
19 Cambridge United Cambridge 46 61 66 51
20 Carlisle United Carlisle 46 56 74 50
21 Mansfield Town Mansfield 46 38 62 48
22 Hartlepool United Hartlepool 46 39 70 45
23 Cheltenham Town Cheltenham 46 40 67 41
24 Tranmere Rovers Tranmere 46 45 67 39
TEMPORADA 2013/2014
LEAGUE TWO
Equipo PJ GF GC Puntos
1 Chesterfield Chesterfield 46 71 40 84
2 Scunthorpe United Scunthorpe 46 68 44 81
3 Rochdale Rochdale 46 69 48 81
4 Fleetwood Town Fleetwood 46 66 52 76
5 Southend United Southend 46 56 39 72
6 Burton Albion Burton 46 47 42 72
7 York City York City 46 52 41 71
8 Oxford United Oxford 46 53 50 62
9 Dagenham & Redbridge Dagenham 46 53 59 60
10 Plymouth Argyle Plymouth 46 51 58 60
11 Mansfield Town Mansfield 46 49 58 60
12 Bury Bury 46 59 51 59
13 Portsmouth Portsmouth 46 56 66 59
14 Newport County Newport 46 56 59 58
15 Accrington Stanley Accrington 46 54 56 57
16 AFC Wimbledon Wimbledon 46 49 57 56
17 Exeter City Exeter City 46 54 57 55
18 Cheltenham Town Cheltenham 46 53 63 55
19 Morecambe Morecambe 46 52 64 54
20 Hartlepool United Hartlepool 46 50 56 53
21 Northampton Northampton 46 42 57 53
22 Wycombe Wanderers Wycombe 46 46 54 50
23 Bristol Rovers Bristol 46 43 54 50
24 Torquay United Torquay 46 42 66 45
TEMPORADA 2012/2013
LEAGUE TWO
Equipo PJ GF GC Puntos
1 Gillingham Gillingham 46 66 39 83
2 Rotherham United Rotherham 46 74 59 79
3 Port Vale Port Vale 46 87 52 78
4 Burton Albion Burton 46 71 66 76
5 Cheltenham Town Cheltenham 46 58 51 75
6 Northampton Northampton 46 64 55 73
7 Bradford City Bradford 46 63 52 69
8 Chesterfield Chesterfield 46 60 45 67
9 Oxford United Oxford 46 60 61 65
10 Exeter City Exeter City 46 63 62 64
11 Southend United Southend 46 61 55 61
12 Rochdale Rochdale 46 68 70 61
13 Fleetwood Town Fleetwood 46 55 57 60
14 Bristol Rovers Bristol 46 60 69 60
15 Wycombe Wanderers Wycombe 46 50 60 60
16 Morecambe Morecambe 46 55 61 58
17 York City York City 46 50 60 55
18 Accrington Stanley Accrington 46 51 68 54
19 Torquay United Torquay 46 55 62 53
20 AFC Wimbledon Wimbledon 46 54 76 53
21 Plymouth Argyle Plymouth 46 46 55 52
22 Dagenham & Redbridge Dagenham 46 55 62 51
23 Barnet Barnet 46 48 59 51
24 Aldershot Town Aldershot 46 42 60 48
TEMPORADA 2011/2012
LEAGUE ONE
Equipo PJ GF GC Puntos
1 Charlton Athletic Charlton 46 82 36 101
2 Sheffield Wednesday Sheffield 46 81 48 93
3 Sheffield United Sheffield 46 92 51 90
4 Huddersfield Town Huddersfield 46 79 47 81
5 Milton Keynes Dons Milton 46 84 47 80
6 Stevenage Stevenage 46 69 44 73
7 Notts County Notts County 46 75 63 73
8 Carlisle United Carlisle 46 65 66 69
9 Brentford Brentford 46 63 52 67
10 Colchester United Colchester 46 61 66 59
11 AFC Bournemouth Bournemouth 46 48 52 58
12 Tranmere Rovers Tranmere 46 49 53 56
13 Hartlepool United Hartlepool 46 50 55 56
14 Bury Bury 46 60 79 56
15 Preston North End Preston 46 54 68 54
16 Oldham Athletic AFC Oldham 46 50 66 54
17 Yeovil Town Yeovil Town 46 59 80 54
18 Scunthorpe United Scunthorpe 46 55 59 52
19 Walsall Walsall 46 51 57 50
20 Leyton Orient Leyton 46 48 75 50
21 Wycombe Wanderers Wycombe 46 65 88 43
22 Chesterfield Chesterfield 46 56 81 42
23 Exeter City Exeter City 46 46 75 42
24 Rochdale Rochdale 46 47 81 38
TEMPORADA 2010/2011
LEAGUE TWO
Equipo PJ GF GC Puntos
1 Chesterfield Chesterfield 46 85 51 86
2 Bury Bury 46 82 50 81
3 Wycombe Wanderers Wycombe 46 69 50 80
4 Shrewsbury Town Shrewsbury 46 72 49 79
5 Accrington Stanley Accrington 46 73 55 73
6 Torquay United Torquay 46 74 53 69
7 Stevenage Stevenage 46 62 45 69
8 Gillingham Gillingham 46 67 57 68
9 Rotherham United Rotherham 46 75 60 66
10 Crewe Alexandra Crewe 46 87 65 65
11 Port Vale Port Vale 46 54 49 65
12 Oxford United Oxford 46 58 60 63
13 Southend United Southend 46 62 56 61
14 Aldershot Town Aldershot 46 54 54 61
15 Macclesfield Town Macclesfield 46 59 73 55
16 Hereford United Hereford 46 50 66 53
17 Northampton Northampton 46 63 71 52
18 Cheltenham Town Cheltenham 46 56 77 52
19 Bradford City Bradford 46 43 68 52
20 Burton Albion Burton 46 56 70 51
21 Morecambe Morecambe 46 54 73 51
22 Barnet Barnet 46 58 77 48
23 Lincoln City Lincoln City 46 45 81 47
24 Stockport County Stockport 46 48 96 41
TEMPORADA 2009/2010
LEAGUE ONE
Equipo PJ GF GC Puntos
1 Colchester United Colchester 1 7 1 3
2 Gillingham Gillingham 1 5 0 3
3 Brentford Brentford 1 3 1 3
4 Yeovil Town Yeovil Town 1 2 0 3
5 Charlton Athletic Charlton 1 3 2 3
6 Leeds United Leeds United 1 2 1 3
7 Leyton Orient Leyton 1 2 1 3
8 Walsall Walsall 1 1 0 3
9 Huddersfield Town Huddersfield 1 2 2 1
10 Southend United Southend 1 2 2 1
11 Millwall Millwall 1 1 1 1
12 Southampton Southampton 1 1 1 1
13 Hartlepool United Hartlepool 1 0 0 1
14 Milton Keynes Dons Milton 1 0 0 1
15 Oldham Athletic AFC Oldham 1 0 0 1
16 Stockport County Stockport 1 0 0 1
17 Wycombe Wanderers Wycombe 1 2 3 0
18 Bristol Rovers Bristol 1 1 2 0
19 Exeter City Exeter City 1 1 2 0
20 Brighton & Hove Albion Brighton 1 0 1 0
21 Carlisle United Carlisle 1 1 3 0
22 Tranmere Rovers Tranmere 1 0 2 0
23 Swindon Town Swindon Town 1 0 5 0
24 Norwich City Norwich City 1 1 7 0
TEMPORADA 2008/2009
LEAGUE TWO
Equipo PJ GF GC Puntos
1 Brentford Brentford 46 65 36 85
2 Exeter City Exeter City 46 65 50 79
3 Wycombe Wanderers Wycombe 46 54 33 78
4 Bury Bury 46 63 43 78
5 Rotherham United Rotherham 46 60 46 75
6 Gillingham Gillingham 46 58 55 75
7 Darlington FC Darlington 46 61 44 72
8 Rochdale Rochdale 46 70 59 70
9 Shrewsbury Town Shrewsbury 46 61 44 69
10 Dagenham & Redbridge Dagenham 46 77 53 68
11 Bradford City Bradford 46 66 55 67
12 AFC Bournemouth Bournemouth 46 59 51 63
13 Chesterfield Chesterfield 46 62 57 63
14 Morecambe Morecambe 46 53 56 63
15 Lincoln City Lincoln City 46 53 52 59
16 Luton Town Luton Town 46 58 65 56
17 Aldershot Town Aldershot 46 59 80 54
18 Accrington Stanley Accrington 46 42 59 50
19 Barnet Barnet 46 56 74 48
20 Port Vale Port Vale 46 44 66 48
21 Notts County Notts County 46 49 69 47
22 Macclesfield Town Macclesfield 46 45 77 47
23 Grimsby Town Grimsby Town 46 51 69 41
24 Chester Chester 46 43 81 37
TEMPORADA 2007/2008
LEAGUE TWO
Equipo PJ GF GC Puntos
1 Milton Keynes Dons Milton 46 82 37 97
2 Peterborough United Peterborough 46 84 43 92
3 Hereford United Hereford 46 72 41 88
4 Stockport County Stockport 46 72 54 82
5 Rochdale Rochdale 46 77 54 80
6 Darlington FC Darlington 46 67 40 78
7 Wycombe Wanderers Wycombe 46 56 42 78
8 Rotherham United Rotherham 46 62 58 74
9 Chesterfield Chesterfield 46 76 56 69
10 Bradford City Bradford 46 63 61 62
11 Morecambe Morecambe 46 59 63 60
12 Barnet Barnet 46 56 63 60
13 Bury Bury 46 58 61 59
14 Brentford Brentford 46 52 70 59
15 Lincoln City Lincoln City 46 61 77 58
16 Grimsby Town Grimsby Town 46 55 66 55
17 Accrington Stanley Accrington 46 49 83 51
18 Shrewsbury Town Shrewsbury 46 56 65 50
19 Macclesfield Town Macclesfield 46 47 64 50
20 Dagenham & Redbridge Dagenham 46 49 70 49
21 Notts County Notts County 46 37 53 48
22 Chester Chester 46 51 68 47
23 Mansfield Town Mansfield 46 48 68 42
24 Wrexham AFC Wrexham AFC 46 38 70 40
TEMPORADA 2006/2007
LEAGUE TWO
Equipo PJ GF GC Puntos
1 Walsall Walsall 46 66 34 89
2 Hartlepool United Hartlepool 46 65 40 88
3 Swindon Town Swindon Town 46 58 38 85
4 Milton Keynes Dons Milton 46 76 58 84
5 Lincoln City Lincoln City 46 70 59 74
6 Bristol Rovers Bristol 46 49 42 72
7 Shrewsbury Town Shrewsbury 46 68 46 71
8 Stockport County Stockport 46 65 54 71
9 Rochdale Rochdale 46 70 50 66
10 Peterborough United Peterborough 46 70 61 65
11 Darlington FC Darlington 46 52 56 65
12 Wycombe Wanderers Wycombe 46 52 47 62
13 Notts County Notts County 46 55 53 62
14 Barnet Barnet 46 55 70 59
15 Grimsby Town Grimsby Town 46 57 73 59
16 Hereford United Hereford 46 45 53 55
17 Mansfield Town Mansfield 46 58 63 54
18 Chester Chester 46 40 48 53
19 Wrexham AFC Wrexham AFC 46 43 65 51
20 Accrington Stanley Accrington 46 70 81 50
21 Bury Bury 46 46 61 50
22 Macclesfield Town Macclesfield 46 55 77 48
23 Boston United Boston 46 51 80 46
24 Torquay United Torquay 46 36 63 35
TEMPORADA 2005/2006
LEAGUE TWO
Equipo PJ GF GC Puntos
1 Carlisle United Carlisle 46 84 42 86
2 Northampton Northampton 46 63 37 83
3 Leyton Orient Leyton 46 67 51 81
4 Grimsby Town Grimsby Town 46 64 44 78
5 Cheltenham Town Cheltenham 46 65 53 72
6 Wycombe Wanderers Wycombe 46 72 56 71
7 Lincoln City Lincoln City 46 65 53 66
8 Darlington FC Darlington 46 58 52 63
9 Peterborough United Peterborough 46 57 49 62
10 Shrewsbury Town Shrewsbury 46 55 55 61
11 Boston United Boston 46 50 60 61
12 Bristol Rovers Bristol 46 59 67 60
13 Wrexham AFC Wrexham AFC 46 61 54 59
14 Rochdale Rochdale 46 66 69 56
15 Chester Chester 46 53 59 54
16 Mansfield Town Mansfield 46 59 66 54
17 Macclesfield Town Macclesfield 46 60 71 54
18 Barnet Barnet 46 44 57 54
19 Bury Bury 46 45 57 53
20 Torquay United Torquay 46 53 66 52
21 Notts County Notts County 46 48 63 52
22 Stockport County Stockport 46 57 78 52
23 Oxford United Oxford 46 43 57 49
24 Rushden & Diamonds Rushden 46 44 76 45
TEMPORADA 2004/2005
LEAGUE TWO
Equipo PJ GF GC Puntos
1 Yeovil Town Yeovil Town 46 90 65 83
2 Scunthorpe United Scunthorpe 46 69 42 80
3 Swansea City Swansea City 46 62 43 80
4 Southend United Southend 46 65 46 78
5 Macclesfield Town Macclesfield 46 60 49 75
6 Lincoln City Lincoln City 46 64 47 72
7 Northampton Northampton 46 62 51 72
8 Darlington FC Darlington 46 57 49 72
9 Rochdale Rochdale 46 54 48 66
10 Wycombe Wanderers Wycombe 46 58 52 65
11 Leyton Orient Leyton 46 65 67 63
12 Bristol Rovers Bristol 46 60 57 60
13 Mansfield Town Mansfield 46 56 56 60
14 Cheltenham Town Cheltenham 46 51 54 60
15 Oxford United Oxford 46 50 63 59
16 Boston United Boston 46 62 58 58
17 Bury Bury 46 54 54 58
18 Grimsby Town Grimsby Town 46 51 52 58
19 Notts County Notts County 46 46 62 52
20 Chester Chester 46 43 69 52
21 Shrewsbury Town Shrewsbury 46 48 53 49
22 Rushden & Diamonds Rushden 46 42 63 44
23 Cambridge United Cambridge 46 39 62 40
24 Kidderminster Harriers Kidderminste 46 39 85 38
TEMPORADA 2003/2004
LEAGUE ONE
Equipo PJ GF GC Puntos
1 Plymouth Argyle Plymouth 46 85 41 90
2 Queens Park Rangers Queens Park 46 80 45 83
3 Bristol City Bristol City 46 58 37 82
4 Brighton & Hove Albion Brighton 46 64 43 77
5 Swindon Town Swindon Town 46 76 58 73
6 Hartlepool United Hartlepool 46 76 61 73
7 Port Vale Port Vale 46 73 63 73
8 Tranmere Rovers Tranmere 46 59 56 67
9 AFC Bournemouth Bournemouth 46 56 51 66
10 Luton Town Luton Town 46 69 66 66
11 Colchester United Colchester 46 52 56 64
12 Barnsley Barnsley 46 54 58 62
13 Wrexham AFC Wrexham AFC 46 50 60 60
14 Blackpool Blackpool 46 58 65 59
15 Oldham Athletic AFC Oldham 46 66 60 57
16 Sheffield Wednesday Sheffield 46 48 64 53
17 Brentford Brentford 46 52 69 53
18 Peterborough United Peterborough 46 58 58 52
19 Stockport County Stockport 46 62 70 52
20 Chesterfield Chesterfield 46 49 71 51
21 Grimsby Town Grimsby Town 46 55 81 50
22 Rushden & Diamonds Rushden 46 60 74 48
23 Notts County Notts County 46 50 78 42
24 Wycombe Wanderers Wycombe 46 50 75 37
TEMPORADA 2002/2003
LEAGUE ONE
Equipo PJ GF GC Puntos
1 Wigan Athletic Wigan 46 68 25 100
2 Crewe Alexandra Crewe 46 76 40 86
3 Bristol City Bristol City 46 79 48 83
4 Queens Park Rangers Queens Park 46 69 45 83
5 Oldham Athletic AFC Oldham 46 68 38 82
6 Cardiff City Cardiff City 46 68 43 81
7 Tranmere Rovers Tranmere 46 66 57 80
8 Plymouth Argyle Plymouth 46 63 52 65
9 Luton Town Luton Town 46 67 62 65
10 Swindon Town Swindon Town 46 59 63 60
11 Peterborough United Peterborough 46 51 54 58
12 Colchester United Colchester 46 52 56 58
13 Blackpool Blackpool 46 56 64 58
14 Stockport County Stockport 46 65 70 55
15 Notts County Notts County 46 62 70 55
16 Brentford Brentford 46 47 56 54
17 Port Vale Port Vale 46 54 70 53
18 Wycombe Wanderers Wycombe 46 59 66 52
19 Barnsley Barnsley 46 51 64 52
20 Chesterfield Chesterfield 46 43 73 50
21 Cheltenham Town Cheltenham 46 53 68 48
22 Huddersfield Town Huddersfield 46 39 61 45
23 Mansfield Town Mansfield 46 66 97 44
24 Northampton Northampton 46 40 79 39
TEMPORADA 2001/2002
LEAGUE ONE
Equipo PJ GF GC Puntos
1 Brighton & Hove Albion Brighton 46 66 42 90
2 Reading Reading 46 70 43 84
3 Brentford Brentford 46 77 43 83
4 Cardiff City Cardiff City 46 75 50 83
5 Stoke City Stoke City 46 67 40 80
6 Huddersfield Town Huddersfield 46 65 47 78
7 Bristol City Bristol City 46 68 53 73
8 Queens Park Rangers Queens Park 46 60 49 71
9 Oldham Athletic AFC Oldham 46 77 65 70
10 Wigan Athletic Wigan 46 66 51 64
11 Wycombe Wanderers Wycombe 46 58 64 64
12 Tranmere Rovers Tranmere 46 63 60 63
13 Swindon Town Swindon Town 46 46 56 59
14 Port Vale Port Vale 46 51 62 58
15 Colchester United Colchester 46 65 76 57
16 Blackpool Blackpool 46 66 69 56
17 Peterborough United Peterborough 46 64 59 55
18 Chesterfield Chesterfield 46 53 65 52
19 Notts County Notts County 46 59 71 50
20 Northampton Northampton 46 54 79 49
21 AFC Bournemouth Bournemouth 46 56 71 44
22 Bury Bury 46 43 75 44
23 Wrexham AFC Wrexham AFC 46 56 89 43
24 Cambridge United Cambridge 46 47 93 34
TEMPORADA 2000/2001
LEAGUE ONE
Equipo PJ GF GC Puntos
1 Millwall Millwall 46 89 38 93
2 Rotherham United Rotherham 46 79 55 91
3 Reading Reading 46 86 52 86
4 Walsall Walsall 46 79 50 81
5 Stoke City Stoke City 46 74 49 77
6 Wigan Athletic Wigan 46 53 42 75
7 AFC Bournemouth Bournemouth 46 79 55 73
8 Notts County Notts County 46 62 66 69
9 Bristol City Bristol City 46 70 56 68
10 Wrexham AFC Wrexham AFC 46 65 71 63
11 Port Vale Port Vale 46 55 49 62
12 Peterborough United Peterborough 46 61 66 59
13 Wycombe Wanderers Wycombe 46 46 53 59
14 Brentford Brentford 46 56 70 59
15 Oldham Athletic AFC Oldham 46 53 65 58
16 Bury Bury 46 45 59 58
17 Colchester United Colchester 46 55 59 57
18 Northampton Northampton 46 46 59 57
19 Cambridge United Cambridge 46 61 77 53
20 Swindon Town Swindon Town 46 47 65 52
21 Bristol Rovers Bristol 46 53 57 51
22 Luton Town Luton Town 46 52 80 40
23 Swansea City Swansea City 46 47 73 37
24 Oxford City Oxford City 46 53 100 27
TEMPORADA 1999/2000
LEAGUE ONE
Equipo PJ GF GC Puntos
1 Preston North End Preston 46 74 37 95
2 Burnley Burnley 46 69 47 88
3 Gillingham Gillingham 46 79 48 85
4 Wigan Athletic Wigan 46 72 38 83
5 Millwall Millwall 46 76 50 82
6 Stoke City Stoke City 46 68 42 82
7 Bristol Rovers Bristol 46 69 45 80
8 Notts County Notts County 46 61 55 65
9 Bristol City Bristol City 46 59 57 64
10 Reading Reading 46 57 63 62
11 Wrexham AFC Wrexham AFC 46 52 61 62
12 Wycombe Wanderers Wycombe 46 56 53 61
13 Luton Town Luton Town 46 61 65 61
14 Oldham Athletic AFC Oldham 46 50 55 60
15 Bury Bury 46 61 64 57
16 AFC Bournemouth Bournemouth 46 59 62 57
17 Brentford Brentford 46 47 61 52
18 Colchester United Colchester 46 59 82 52
19 Cambridge United Cambridge 46 64 65 48
20 Oxford City Oxford City 46 43 73 45
21 Cardiff City Cardiff City 46 45 67 44
22 Blackpool Blackpool 46 49 77 41
23 Scunthorpe United Scunthorpe 46 40 74 39
24 Chesterfield Chesterfield 46 34 63 36
TEMPORADA 1998/1999
LEAGUE ONE
Equipo PJ GF GC Puntos
1 Fulham Fulham 46 79 32 101
2 Walsall Walsall 46 63 47 87
3 Manchester City Manchester 46 69 33 82
4 Gillingham Gillingham 46 76 44 80
5 Preston North End Preston 46 78 50 79
6 Wigan Athletic Wigan 46 75 49 76
7 AFC Bournemouth Bournemouth 46 63 41 76
8 Stoke City Stoke City 46 59 63 69
9 Chesterfield Chesterfield 46 46 45 64
10 Millwall Millwall 46 52 59 62
11 Reading Reading 46 54 63 61
12 Luton Town Luton Town 46 51 60 58
13 Bristol Rovers Bristol 46 65 56 56
14 Blackpool Blackpool 46 44 54 56
15 Burnley Burnley 46 54 73 55
16 Notts County Notts County 46 53 61 54
17 Wrexham AFC Wrexham AFC 46 43 62 53
18 Colchester United Colchester 46 52 70 52
19 Wycombe Wanderers Wycombe 46 52 58 51
20 Oldham Athletic AFC Oldham 46 48 66 51
21 York City York City 46 56 80 50
22 Northampton Northampton 46 43 57 48
23 Lincoln City Lincoln City 46 42 74 46
24 Macclesfield Town Macclesfield 46 43 63 43
TEMPORADA 1997/1998
LEAGUE ONE
Equipo PJ GF GC Puntos
1 Watford Watford 43 66 38 86
2 Bristol City Bristol City 39 58 31 73
3 Grimsby Town Grimsby Town 42 51 31 68
4 Fulham Fulham 37 49 31 64
5 Northampton Northampton 41 46 34 61
6 Bristol Rovers Bristol 40 57 51 61
7 Gillingham Gillingham 39 47 38 60
8 Wrexham AFC Wrexham AFC 41 49 49 57
9 Chesterfield Chesterfield 38 40 33 55
10 Blackpool Blackpool 42 53 62 55
11 Oldham Athletic AFC Oldham 41 51 46 53
12 Wigan Athletic Wigan 41 57 63 52
13 Wycombe Wanderers Wycombe 40 48 51 51
14 AFC Bournemouth Bournemouth 36 42 39 50
15 York City York City 38 42 46 49
16 Walsall Walsall 40 38 45 48
17 Preston North End Preston 38 45 48 46
18 Burnley Burnley 42 51 61 46
19 Plymouth Argyle Plymouth 42 52 63 46
20 Brentford Brentford 39 41 61 43
21 Millwall Millwall 37 31 43 42
22 Carlisle United Carlisle 40 54 61 41
23 Southend United Southend 41 37 67 38
24 Luton Town Luton Town 35 42 55 37

  USO DE MEMORIA  
9,677,664 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0021
Controller Execution Time ( Home / Category )  0.2316
Total Execution Time  0.2338
  CADENA URL  
/historico/Wycombe-Wanderers/2017
  GET DATOS  
$_GET['/historico/Wycombe-Wanderers/2017']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (56)  
0.0053  SELECT dt.*,c.active_year,l.year,l.table_suffix, c.ctype, l.id as league_id,t.id as id,t.manager,t.name as nameOriginal,dt.id as teamId,cou.Name as cou_name,cou.Continent,cou.Region FROM `leagues_webci` as l INNER JOIN `teams` as t ON l.id = t.league_id INNER JOIN `datateams` as dt ON dt.id = t.teamId INNER JOIN `categories_webci` as c ON c.id = l.categoryId LEFT JOIN country cou ON LOWER(cou.Code2) = dt.CountryCode WHERE dt.basealias = 'Wycombe-Wanderers' AND l.year = 2017 ORDER BY c.top DESC, c.ctype != 12 DESC, c.troncal DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, c.coefficient DESC, l.id ASC
0.0018  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=9204 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=9204 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=9204 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=9204 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=9204 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=9204 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=9204 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0027  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 30629
0.0022  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 33979
0.0023  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 33348
0.0023  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 34032
0.0024  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 37221
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=9204 AND type_rel = 2
0.0021  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 9204 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0022  SELECT /*35 bs_news_model*/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (32931,39007,48055,53884,68701) ORDER BY n.cover_points DESC, update_date DESC
0.0039  SELECT cat.logo,cat.official,cat.location,dt.nameShow,dt.basealias,t.teamId,l.year,t.qod,cat.coefficient,cat.active_year,cat.name,l.group_code,l.total_group,cat.alias,l.categoryId,l.year,l.id as league_id FROM datateams dt INNER JOIN teams t ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories cat ON cat.id = l.categoryId WHERE dt.id = '9204' ORDER BY l.year DESC,cat.coefficient DESC
0.0029  SELECT cat.logo,cat.official,cat.location,dt.nameShow,dt.basealias,t.teamId,l.year,t.qod,cat.coefficient,cat.active_year,cat.name,l.group_code,l.total_group,cat.alias,l.categoryId,l.year,l.id as league_id FROM datateams dt INNER JOIN teams t ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories cat ON cat.id = l.categoryId WHERE dt.id = '9204' AND l.year = 2017 ORDER BY l.year DESC,cat.coefficient DESC
0.0028  SELECT SQL_NO_CACHE res.id as id, res.group_code, res.total_group, res.logo, res.alias FROM (SELECT ct.active_year, ct.id as id, l.year, l.end,l.group_code, l.total_group, ct.logo, ct.alias FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId AND ct.active_year=l.year INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId = '9204' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0022  SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 33348 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0019  SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 30629 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0022  SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 34032 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0039  SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 33979 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0041  SELECT t.id as team_id, ct.id, l.id as idLeague, l.year, ct.name, l.start_date, l.end_date FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId=9204 AND l.year in (2016,2017,2018) ORDER BY l.id DESC, l.year DESC ;
0.0019  SELECT ct.id, ct.alias, ct.name AS name, ct.active_year, ct.coefficient AS coefficient, l.id AS league_id, l.year, l.total_group FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId WHERE l.id IN (38990,38989,38752,38701,38427) ORDER BY ct.ctype != 12 DESC, ct.troncal DESC, ct.coefficient DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, ct.coefficient DESC, l.group_code ASC
0.0024  SELECT count(id) as num_players from rel_players WHERE league_id = 38701 AND teamId = 9204
0.0028  SELECT count(id) as num_players from rel_players WHERE league_id = 38989 AND teamId = 9204
0.0026  SELECT count(id) as num_players from rel_players WHERE league_id = 38752 AND teamId = 9204
0.0028  SELECT count(id) as num_players from rel_players WHERE league_id = 38990 AND teamId = 9204
0.0121  SELECT count(id) as num_players from rel_players WHERE league_id = 38427 AND teamId = 9204
0.0041  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM `tables2017` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 30629 AND t.round = 46 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0020  SELECT p.* FROM `rel_pictures` as rp INNER JOIN `pictures` as p ON p.id = rp.id_picture INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '9204' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0017  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '9204' and rp.type = 4
0.0020  SELECT p.* FROM `rel_videos` as rp INNER JOIN `videos` as p ON p.id = rp.id_video INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '9204' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0047  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2017 e ON e.player_id = p.id AND e.league_id = 30629 WHERE rp.league_id = 30629 AND rp.teamId = 9204 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0037  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2017 e ON e.player_id = p.id AND e.league_id = 30629 WHERE rp.league_id = 30629 AND rp.teamId = 9204 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0031  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2017 e ON e.player_id = p.id AND e.league_id = 30629 WHERE rp.league_id = 30629 AND rp.teamId = 9204 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0032  SELECT l.id,t.league_id,l.legend,l.year,c.name,l.total_teams,c.alias,l.group_code,l.total_group,l.current_round, l.table_suffix FROM teams t INNER JOIN leagues l ON t.league_id = l.id INNER JOIN categories c ON c.id = l.categoryId WHERE c.troncal = 1 AND t.teamId = 9204 AND l.year <= 2017 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0041  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2017` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 30629 AND t.round = 46 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2015` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 3889 AND t.round = 46 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2014` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 2439 AND t.round = 46 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2013` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 1918 AND t.round = 46 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2012` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 1317 AND t.round = 46 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2011` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 1073 AND t.round = 46 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2010` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 2600 AND t.round = 1 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2009` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 443 AND t.round = 46 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2008` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 491 AND t.round = 46 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2006` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 493 AND t.round = 46 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2005` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 494 AND t.round = 46 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2004` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 480 AND t.round = 46 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2003` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 481 AND t.round = 46 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0034  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2002` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 482 AND t.round = 46 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2001` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 483 AND t.round = 46 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2000` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 484 AND t.round = 46 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1999` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 485 AND t.round = 46 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  SELECT dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 30629 ORDER BY nameShow LIMIT 100