4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Bedford Town
TEMPORADA 2023/2024
NON LEAGUE DIVISION 1 GRUPO 7
Equipo PJ GF GC Puntos
1 Biggleswade Town Biggleswade 36 78 39 72
2 Bedford Town Bedford Town 36 77 37 69
3 Ware Ware 36 69 60 62
4 Waltham Abbey Waltham 36 70 55 61
5 AFC Dunstable Dunstable 36 75 66 61
6 Cirencester Town Cirencester 36 66 44 57
7 Stotfold FC Stotfold FC 36 67 56 55
8 Welwyn Garden City Welwyn 36 79 79 54
9 Hadley Hadley 35 62 60 52
10 Biggleswade Biggleswade 36 62 58 48
11 Kings Langley Kings 36 71 74 48
12 Barton Rovers Barton 36 58 65 44
13 Kidlington Kidlington 36 49 60 44
14 Hertford Town Hertford 36 55 72 44
15 Aylesbury United Aylesbury 36 61 74 43
16 North Leigh North Leigh 35 52 78 43
17 Leighton Town Leighton 36 51 62 42
18 Thame United FC Thame United 36 51 70 37
19 Kempston Rovers Kempston 36 36 80 29
TEMPORADA 2022/2023
NON LEAGUE PREMIER GRUPO 1
Equipo PJ GF GC Puntos
1 Tamworth Tamworth 42 93 40 89
2 Coalville Town Coalville 42 92 42 89
3 Leiston Leiston 42 84 47 85
4 Nuneaton Town Nuneaton 42 67 45 79
5 Rushall Olympic Rushall 42 71 52 73
6 Mickleover Sports FC Mickleover 42 82 66 72
7 Ilkeston Town FC Ilkeston 42 79 66 61
8 Barwell Barwell 42 69 63 61
9 Redditch United Redditch 42 57 59 61
10 Stourbridge Stourbridge 42 69 56 59
11 Alvechurch FC Alvechurch 42 63 65 59
12 Hitchin Town Hitchin Town 42 52 60 59
13 Royston Town Royston Town 42 63 73 55
14 Stratford Town Stratford 42 58 70 52
15 Basford United Basford 42 49 62 52
16 St Ives Town Ives Town 42 64 72 50
17 Needham Market Needham 42 46 54 48
18 Bromsgrove Sporting Bromsgrove 42 58 78 48
19 Kings Langley Kings 42 45 69 39
20 Hednesford Town Hednesford 42 45 76 31
21 Rushden & Diamonds Rushden 42 40 87 31
22 Bedford Town Bedford Town 42 49 93 30
TEMPORADA 2021/2022
NON LEAGUE DIVISION 1 GRUPO 7
Equipo PJ GF GC Puntos
1 Bedford Town Bedford Town 38 100 28 91
2 Berkhamsted Berkhamsted 38 64 29 81
3 AFC Dunstable Dunstable 38 64 33 73
4 Ware Ware 38 90 47 71
5 Welwyn Garden City Welwyn 38 80 48 71
6 North Leigh North Leigh 38 69 42 68
7 Harlow Town Harlow Town 38 71 49 61
8 Thame United FC Thame United 38 64 45 60
9 Biggleswade Biggleswade 38 62 56 60
10 St. Neots Town Neots Town 38 57 53 53
11 Waltham Abbey Waltham 38 64 64 52
12 FC Romania FC Romania 38 71 83 48
13 Didcot Town Didcot Town 38 50 69 47
14 Aylesbury United Aylesbury 38 64 70 43
15 Barton Rovers Barton 38 47 63 41
16 Hertford Town Hertford 38 58 82 36
17 Kidlington Kidlington 38 47 86 35
18 Kempston Rovers Kempston 38 50 102 29
19 Colney Heath Colney Heath 38 35 92 23
20 Wantage Town Wantage Town 38 37 103 20
TEMPORADA 2020/2021
NON LEAGUE DIVISION 1 GRUPO 6
Equipo PJ GF GC Puntos
1 Barton Rovers Barton 0 0 0 0
2 AFC Dunstable Dunstable 0 0 0 0
3 Bedford Town Bedford Town 0 0 0 0
4 Bedworth United Bedworth 0 0 0 0
5 Kempston Rovers Kempston 0 0 0 0
6 North Leigh North Leigh 0 0 0 0
7 Welwyn Garden City Welwyn 0 0 0 0
8 Yaxley FC Yaxley FC 0 0 0 0
9 Aylesbury United Aylesbury 0 0 0 0
10 Coleshill Town FC Coleshill 0 0 0 0
11 Wantage Town Wantage Town 0 0 0 0
12 Berkhamsted Berkhamsted 0 0 0 0
13 Biggleswade Biggleswade 0 0 0 0
14 Corby Town Corby Town 0 0 0 0
15 Daventry Town Daventry 0 0 0 0
16 Didcot Town Didcot Town 0 0 0 0
17 Halesowen Town Halesowen 0 0 0 0
18 St. Neots Town Neots Town 0 0 0 0
19 Thame United FC Thame United 0 0 0 0
20 Kidlington Kidlington 0 0 0 0
TEMPORADA 2019/2020
NON LEAGUE DIVISION 1 GRUPO 6
Equipo PJ GF GC Puntos
1 Berkhamsted Berkhamsted 28 69 24 64
2 Halesowen Town Halesowen 27 72 19 63
3 Corby Town Corby Town 28 64 26 59
4 Welwyn Garden City Welwyn 28 59 34 51
5 Aylesbury United Aylesbury 29 49 30 49
6 Biggleswade Biggleswade 27 44 33 44
7 Barton Rovers Barton 29 65 55 44
8 Bedworth United Bedworth 27 46 44 44
9 Yaxley FC Yaxley FC 29 55 55 42
10 North Leigh North Leigh 27 50 50 42
11 Thame United FC Thame United 27 52 35 41
12 Bedford Town Bedford Town 29 49 54 40
13 Daventry Town Daventry 28 42 48 40
14 Coleshill Town FC Coleshill 28 50 47 36
15 Kidlington Kidlington 28 34 48 33
16 AFC Dunstable Dunstable 28 50 54 31
17 Didcot Town Didcot Town 27 20 44 25
18 St. Neots Town Neots Town 28 33 59 21
19 Kempston Rovers Kempston 27 25 68 14
20 Wantage Town Wantage Town 27 16 117 4
TEMPORADA 2018/2019
NON LEAGUE DIVISION 1 GRUPO 4
Equipo PJ GF GC Puntos
1 Peterborough Sports Peterborough 38 109 28 95
2 Bromsgrove Sporting Bromsgrove 38 108 44 87
3 Corby Town Corby Town 38 106 60 77
4 Bedford Town Bedford Town 38 84 52 65
5 Sutton Coldfield Town Sutton 38 65 49 62
6 Berkhamsted Berkhamsted 38 68 53 59
7 Didcot Town Didcot Town 38 69 61 58
8 Thame United FC Thame United 38 60 61 57
9 Coleshill Town FC Coleshill 38 60 58 56
10 AFC Dunstable Dunstable 38 58 71 55
11 Yaxley FC Yaxley FC 38 72 92 49
12 Cambridge City Cambridge 38 58 54 47
13 Welwyn Garden City Welwyn 38 52 64 43
14 Kempston Rovers Kempston 38 58 75 43
15 Aylesbury United Aylesbury 38 62 86 42
16 Barton Rovers Barton 38 45 68 41
17 North Leigh North Leigh 38 67 106 34
18 Kidlington Kidlington 38 43 82 34
19 Aylesbury Aylesbury 38 42 79 31
20 Dunstable Town Dunstable 38 49 92 31
TEMPORADA 2017/2018
NON LEAGUE DIVISION 1 GRUPO 5
Equipo PJ GF GC Puntos
1 Beaconsfield Beaconsfield 42 99 46 92
2 Rushden & Diamonds Rushden 42 92 25 91
3 Hayes & Yeading United Hayes 42 103 49 83
4 Hartley Wintney Hartley 42 96 53 82
5 AFC Dunstable Dunstable 42 80 37 79
6 Cambridge City Cambridge 42 99 53 77
7 Kempston Rovers Kempston 42 80 68 73
8 Bedford Town Bedford Town 42 70 48 72
9 Chalfont St Peter Chalfont 42 56 39 72
10 Moneyfields Moneyfields 42 79 63 69
11 Thame United FC Thame United 42 84 78 64
12 Ashford Town Ashford Town 42 81 68 56
13 Aylesbury United Aylesbury 42 52 73 55
14 Marlow FC Marlow FC 42 54 75 49
15 Uxbridge Uxbridge 42 58 87 49
16 Egham Town Egham Town 42 54 88 48
17 Northwood Northwood 42 54 71 41
18 Hanwell Town Hanwell Town 42 48 88 34
19 Fleet Town Fleet Town 42 38 86 34
20 Barton Rovers Barton 42 39 86 33
21 Aylesbury Aylesbury 42 40 88 33
22 Arlesey Town Arlesey Town 42 36 123 14
TEMPORADA 2016/2017
NON LEAGUE DIVISION 1 GRUPO 3
Equipo PJ GF GC Puntos
1 Royston Town Royston Town 42 121 45 105
2 Farnborough Farnborough 42 96 51 90
3 Barton Rovers Barton 42 91 66 77
4 Marlow FC Marlow FC 42 65 43 77
5 Egham Town Egham Town 42 79 51 74
6 Kempston Rovers Kempston 42 82 61 73
7 AFC Dunstable Dunstable 42 85 53 71
8 Bedford Town Bedford Town 42 76 58 67
9 Potters Bar Town Potters Town 42 71 61 62
10 Ashford Town Ashford Town 42 73 71 59
11 Kidlington Kidlington 42 70 79 59
12 Hanwell Town Hanwell Town 42 64 67 58
13 Aylesbury United Aylesbury 42 58 68 55
14 Fleet Town Fleet Town 42 72 81 50
15 Beaconsfield Beaconsfield 42 81 85 48
16 Uxbridge Uxbridge 42 67 80 47
17 Arlesey Town Arlesey Town 42 52 69 47
18 Chalfont St Peter Chalfont 42 49 77 47
19 Aylesbury Aylesbury 42 54 75 44
20 Northwood Northwood 42 57 88 39
21 Histon Histon 42 54 93 34
22 Petersfield Town Petersfield 42 32 127 9
TEMPORADA 2015/2016
NON LEAGUE DIVISION 1 GRUPO 3
Equipo PJ GF GC Puntos
1 Kings Langley Kings 42 83 44 87
2 Egham Town Egham Town 42 81 39 83
3 Royston Town Royston Town 42 99 55 80
4 St Ives Town Ives Town 42 72 39 78
5 Rushden & Diamonds Rushden 42 81 44 77
6 Chalfont St Peter Chalfont 42 76 71 71
7 Northwood Northwood 42 62 49 69
8 Aylesbury Aylesbury 42 72 52 68
9 Beaconsfield Beaconsfield 42 77 54 67
10 Godalming Town Godalming 42 51 45 67
11 Ware Ware 42 67 69 63
12 Potters Bar Town Potters Town 42 62 64 58
13 Petersfield Town Petersfield 42 71 80 55
14 Bedford Town Bedford Town 42 57 60 49
15 Uxbridge Uxbridge 42 59 71 48
16 Fleet Town Fleet Town 42 64 78 48
17 Arlesey Town Arlesey Town 42 48 87 47
18 Barton Rovers Barton 42 51 75 42
19 Aylesbury United Aylesbury 42 45 81 40
20 Hanwell Town Hanwell Town 42 38 64 39
21 Leighton Town Leighton 42 47 86 35
22 North Greenford United North 42 51 107 24
TEMPORADA 2014/2015
NON LEAGUE DIVISION 1 GRUPO 5
Equipo PJ GF GC Puntos
1 Kettering Town Kettering 39 86 35 88
2 Aylesbury Aylesbury 39 79 45 77
3 Bedworth United Bedworth 37 75 44 75
4 Royston Town Royston Town 39 66 54 74
5 Rugby Town Rugby Town 39 77 45 73
6 Barton Rovers Barton 39 79 49 72
7 Hanwell Town Hanwell Town 38 65 53 64
8 Godalming Town Godalming 39 62 60 57
9 St Ives Town Ives Town 39 66 73 56
10 Northwood Northwood 38 57 54 55
11 Uxbridge Uxbridge 39 67 62 53
12 Aylesbury United Aylesbury 39 63 75 52
13 Marlow FC Marlow FC 39 51 56 50
14 Potters Bar Town Potters Town 39 61 65 48
15 Egham Town Egham Town 39 57 74 48
16 Chalfont St Peter Chalfont 39 58 64 45
17 Bedford Town Bedford Town 39 59 68 45
18 Leighton Town Leighton 39 46 64 39
19 Daventry Town Daventry 39 44 74 38
20 Beaconsfield Beaconsfield 39 59 72 37
21 AFC Hayes AFC Hayes 39 40 82 28
22 North Greenford United North 39 44 93 25
TEMPORADA 2013/2014
NON LEAGUE PREMIER GRUPO 3
Equipo PJ GF GC Puntos
1 Hemel Hempstead Town Hemel 31 101 28 72
2 Chesham United Chesham 31 73 34 62
3 St. Albans City Albans City 30 69 35 61
4 Cambridge City Cambridge 28 63 31 61
5 Stourbridge Stourbridge 31 83 35 57
6 Bideford Bideford 33 62 44 53
7 Poole Town Poole Town 23 50 26 50
8 Corby Town Corby Town 29 42 38 45
9 Arlesey Town Arlesey Town 33 58 56 45
10 Hitchin Town Hitchin Town 30 43 35 44
11 Hungerford Town Hungerford 26 47 32 42
12 Biggleswade Town Biggleswade 29 55 41 42
13 Weymouth Weymouth 30 43 58 41
14 Banbury United Banbury 31 49 65 41
15 Truro City Truro City 31 45 60 39
16 Burnham Burnham 31 43 59 38
17 Frome Town Frome Town 32 42 59 37
18 Redditch United Redditch 29 43 64 37
19 Chippenham Town Chippenham 30 41 65 32
20 St. Neots Town Neots Town 32 48 56 32
21 AFC Totton AFC Totton 27 34 86 15
22 Bedford Town Bedford Town 32 34 90 14
23 Bashley Bashley 27 21 81 9
24 Hinckley United Hinckley 10 9 20 6
TEMPORADA 2012/2013
NON LEAGUE PREMIER GRUPO 3
Equipo PJ GF GC Puntos
1 Leamington Leamington 42 85 46 95
2 Stourbridge Stourbridge 42 94 42 83
3 Chesham United Chesham 42 69 48 75
4 Hemel Hempstead Town Hemel 42 95 72 72
5 Gosport Borough Gosport 42 78 43 70
6 Arlesey Town Arlesey Town 42 70 51 69
7 Barwell Barwell 42 67 50 69
8 Cambridge City Cambridge 42 63 57 66
9 Weymouth Weymouth 42 59 71 62
10 Bedford Town Bedford Town 42 61 56 61
11 St. Albans City Albans City 42 81 71 60
12 St. Neots Town Neots Town 42 77 77 52
13 Hitchin Town Hitchin Town 42 62 68 52
14 AFC Totton AFC Totton 42 62 84 52
15 Chippenham Town Chippenham 42 63 67 51
16 Banbury United Banbury 42 60 75 51
17 Bashley Bashley 42 47 63 49
18 Frome Town Frome Town 42 40 55 45
19 Redditch United Redditch 42 32 65 43
20 Bideford Bideford 42 58 73 42
21 Bedworth United Bedworth 42 39 73 42
22 Kettering Town Kettering 42 47 102 32
TEMPORADA 2011/2012
NON LEAGUE PREMIER GRUPO 2
Equipo PJ GF GC Puntos
1 Brackley Town Brackley 42 92 48 85
2 Oxford City Oxford City 42 68 41 77
3 AFC Totton AFC Totton 42 81 43 74
4 Chesham United Chesham 42 76 53 73
5 Cambridge City Cambridge 42 78 52 72
6 Stourbridge Stourbridge 42 67 45 72
7 Leamington Leamington 42 60 47 69
8 St. Albans City Albans City 42 72 77 62
9 Barwell Barwell 42 70 61 61
10 Bedford Town Bedford Town 42 60 69 55
11 Chippenham Town Chippenham 42 55 53 53
12 Frome Town Frome Town 42 44 49 52
13 Bashley Bashley 42 58 74 52
14 Hitchin Town Hitchin Town 42 54 57 51
15 Redditch United Redditch 42 45 50 51
16 Banbury United Banbury 42 54 61 49
17 Weymouth Weymouth 42 54 75 48
18 Arlesey Town Arlesey Town 42 43 60 47
19 Hemel Hempstead Town Hemel 42 46 66 44
20 Evesham United Evesham 42 49 71 44
21 Swindon Supermarine Swindon 42 50 86 44
22 Cirencester Town Cirencester 42 40 78 30
TEMPORADA 2010/2011
NON LEAGUE PREMIER GRUPO 1
Equipo PJ GF GC Puntos
1 Truro City Truro City 38 85 33 81
2 Salisbury City Salisbury 39 82 44 79
3 Hednesford Town Hednesford 38 74 38 77
4 Cambridge City Cambridge 38 72 39 76
5 Leamington Leamington 38 62 35 72
6 Chesham United Chesham 38 61 29 70
7 Chippenham Town Chippenham 38 52 38 65
8 Stourbridge Stourbridge 38 64 57 59
9 Brackley Town Brackley 38 65 45 55
10 Swindon Supermarine Swindon 39 53 57 55
11 Bashley Bashley 38 53 57 49
12 Evesham United Evesham 38 52 47 48
13 Cirencester Town Cirencester 38 58 65 46
14 Oxford City Oxford City 38 43 51 42
15 Hemel Hempstead Town Hemel 38 46 56 41
16 Banbury United Banbury 38 44 62 41
17 Weymouth Weymouth 38 50 82 41
18 Bedford Town Bedford Town 38 40 74 34
19 Didcot Town Didcot Town 38 39 66 31
20 Tiverton Town Tiverton 38 33 76 28
21 Halesowen Town Halesowen 38 24 101 23
TEMPORADA 2009/2010
NON LEAGUE PREMIER GRUPO 3
Equipo PJ GF GC Puntos
1 Farnborough Farnborough 42 100 44 93
2 Nuneaton Town Nuneaton 42 90 37 88
3 Halesowen Town Halesowen 42 84 53 80
4 Chippenham Town Chippenham 42 67 43 74
5 Hednesford Town Hednesford 42 79 51 73
6 Brackley Town Brackley 42 83 61 72
7 Cambridge City Cambridge 42 73 44 71
8 Bashley Bashley 42 79 61 71
9 Stourbridge Stourbridge 42 80 65 70
10 Leamington Leamington 42 84 75 65
11 Truro City Truro City 42 78 65 62
12 Banbury United Banbury 42 53 67 55
13 Oxford City Oxford City 42 65 67 54
14 Merthyr Tydfil FC Merthyr 42 62 73 47
15 Swindon Supermarine Swindon 42 48 76 44
16 Didcot Town Didcot Town 42 56 70 41
17 Evesham United Evesham 42 35 52 41
18 Bedford Town Bedford Town 42 50 88 37
19 Tiverton Town Tiverton 42 35 61 36
20 Hemel Hempstead Town Hemel 42 50 81 34
21 Clevedon Town Clevedon 42 48 92 29
22 Rugby Town Rugby Town 42 41 114 20
TEMPORADA 2008/2009
NON LEAGUE PREMIER GRUPO 1
Equipo PJ GF GC Puntos
1 Corby Town Corby Town 42 85 38 84
2 Farnborough Farnborough 42 67 36 83
3 Gloucester City Gloucester 42 80 45 75
4 Hemel Hempstead Town Hemel 42 71 48 70
5 Cambridge City Cambridge 41 61 40 70
6 Chippenham Town Chippenham 42 64 51 68
7 Oxford City Oxford City 42 76 55 67
8 Merthyr Tydfil FC Merthyr 42 66 55 67
9 Halesowen Town Halesowen 42 65 73 63
10 Evesham United Evesham 42 48 39 61
11 Brackley Town Brackley 42 69 62 57
12 Tiverton Town Tiverton 42 51 50 57
13 Swindon Supermarine Swindon 42 59 61 57
14 Bashley Bashley 42 52 58 57
15 Bedford Town Bedford Town 41 44 54 50
16 Stourbridge Stourbridge 42 62 78 50
17 Rugby Town Rugby Town 42 63 71 43
18 Clevedon Town Clevedon 43 52 82 43
19 Banbury United Banbury 42 43 83 41
20 Hitchin Town Hitchin Town 42 57 79 40
21 Yate Town Yate Town 43 56 92 39
22 Mangotsfield United Mangotsfield 42 39 80 36
TEMPORADA 2007/2008
NON LEAGUE PREMIER GRUPO 3
Equipo PJ GF GC Puntos
TEMPORADA 2006/2007
NATIONAL LEAGUE SOUTH
Equipo PJ GF GC Puntos
1 Histon Histon 42 85 44 94
2 Salisbury City Salisbury 42 65 37 75
3 Braintree Town Braintree 42 51 38 74
4 Havant & Waterlooville Havant 42 75 46 73
5 Bishops Stortford Bishops 42 72 61 73
6 Newport County Newport 42 83 57 70
7 Eastbourne Borough Eastbourne 42 58 42 69
8 Welling United Welling 42 65 51 69
9 Lewes Lewes 42 67 52 62
10 Fisher FC Fisher FC 42 77 77 56
11 Farnborough Farnborough 42 59 52 55
12 Bognor Regis Town Bognor Regis 42 56 62 52
13 Cambridge City Cambridge 42 44 52 52
14 Sutton United Sutton 42 58 63 51
15 Eastleigh Eastleigh 42 48 53 48
16 Yeading Yeading 42 56 78 45
17 Dorchester Town Dorchester 42 49 77 45
18 Thurrock Thurrock 42 58 79 44
19 Basingstoke Town Basingstoke 42 46 58 43
20 Hayes FC Hayes FC 42 47 73 43
21 Weston-super-Mare Weston-super 42 49 77 35
22 Bedford Town Bedford Town 42 43 82 31
TEMPORADA 2005/2006
NON LEAGUE PREMIER GRUPO 1
Equipo PJ GF GC Puntos
1 Salisbury City Salisbury 42 84 27 95
2 Bath City Bath City 42 66 33 83
3 Kings Lynn Town Kings Lynn. 42 73 41 82
4 Chippenham Town Chippenham 42 69 45 77
5 Bedford Town Bedford Town 42 69 53 76
6 Yate Town Yate Town 41 78 71 68
7 Banbury United Banbury 42 66 61 62
8 Halesowen Town Halesowen 41 54 44 60
9 Merthyr Tydfil FC Merthyr 42 62 58 60
10 Mangotsfield United Mangotsfield 41 67 64 58
11 Grantham Town Grantham 42 49 49 56
12 Tiverton Town Tiverton 42 69 65 52
13 Hitchin Town Hitchin Town 42 60 76 51
14 Rugby Town Rugby Town 42 58 66 50
15 Gloucester City Gloucester 41 55 61 49
16 Cheshunt Cheshunt 42 57 70 48
17 Cirencester Town Cirencester 42 49 68 46
18 Team Bath Team Bath 42 52 71 45
19 Northwood Northwood 42 53 88 42
20 Evesham United Evesham 42 46 58 41
21 Aylesbury United Aylesbury 42 43 69 39
22 Chesham United Chesham 42 43 84 36
TEMPORADA 2004/2005
NON LEAGUE PREMIER GRUPO 2
Equipo PJ GF GC Puntos
1 Histon Histon 42 93 57 78
2 Chippenham Town Chippenham 42 81 55 75
3 Merthyr Tydfil FC Merthyr 42 62 47 71
4 Hednesford Town Hednesford 42 68 40 70
5 Bedford Town Bedford Town 42 70 52 69
6 Bath City Bath City 42 57 43 69
7 Tiverton Town Tiverton 42 70 55 67
8 Cirencester Town Cirencester 41 60 52 65
9 Kings Lynn Town Kings Lynn. 43 79 69 64
10 Halesowen Town Halesowen 41 62 52 63
11 Aylesbury United Aylesbury 43 67 67 63
12 Grantham Town Grantham 41 57 53 58
13 Chesham United Chesham 41 82 82 56
14 Team Bath Team Bath 41 54 66 54
15 Gloucester City Gloucester 42 63 61 53
16 Rugby Town Rugby Town 42 48 60 51
17 Banbury United Banbury 42 56 69 48
18 Hitchin Town Hitchin Town 42 55 77 48
19 Hemel Hempstead Town Hemel 42 60 88 43
20 Dunstable Town Dunstable 42 56 98 39
21 Stamford Stamford 41 40 57 36
22 Solihull Borough Solihull 42 45 85 34

  USO DE MEMORIA  
8,658,640 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.9162
Total Execution Time  0.9175
  CADENA URL  
/historico/Bedford-Town
  GET DATOS  
$_GET['/historico/Bedford-Town']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (50)  
0.0160  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 = 'Bedford-Town' AND l.year = 2024 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.0145  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=10860 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  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=10860 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  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=10860 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  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=10860 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  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=10860 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0292  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 = 72986
0.0153  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 = 72677
0.0146  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=10860 AND type_rel = 2
0.0156  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 = '10860' ORDER BY l.year DESC,cat.coefficient DESC
0.0149  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 = '10860' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0150  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 = '10860' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0164  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 = 72677 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0150  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 = 72986 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0156  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=10860 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0149  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 (72986,72728,72677,71432,68450) 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.0155  SELECT count(id) as num_players from rel_players WHERE league_id = 68450 AND teamId = 10860
0.0146  SELECT count(id) as num_players from rel_players WHERE league_id = 72986 AND teamId = 10860
0.0147  SELECT count(id) as num_players from rel_players WHERE league_id = 72728 AND teamId = 10860
0.0145  SELECT count(id) as num_players from rel_players WHERE league_id = 72677 AND teamId = 10860
0.0146  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 10860
0.0151  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM `tables2024` 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 = 72986 AND t.round = 38 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0146  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 = '10860' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0145  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '10860' and rp.type = 4
0.0146  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 = '10860' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0147  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 events2024 e ON e.player_id = p.id AND e.league_id = 72986 WHERE rp.league_id = 72986 AND rp.teamId = 10860 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.0149  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 events2024 e ON e.player_id = p.id AND e.league_id = 72986 WHERE rp.league_id = 72986 AND rp.teamId = 10860 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0150  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 events2024 e ON e.player_id = p.id AND e.league_id = 72986 WHERE rp.league_id = 72986 AND rp.teamId = 10860 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0175  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 = 10860 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0158  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 `tables2024` 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 = 72986 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0154  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 `tables2023` 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 = 68450 AND t.round = 42 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151  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 `tables2022` 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 = 63534 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 `tables2021` 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 = 58744 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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 `tables2020` 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 = 50971 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150  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 `tables2019` 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 = 44459 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0154  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 `tables2018` 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 = 39172 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0152  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 = 33754 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0156  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 `tables2016` 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 = 15615 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0156  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 = 4400 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0158  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 = 3474 AND t.round = 46 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0161  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 = 24450 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0169  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 = 24430 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0167  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 = 24420 AND t.round = 40 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0173  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 = 24418 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0171  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 = 24405 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0154  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 = 24401 AND t.round = 43 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0167  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 `tables2007` 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 = 12907 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0166  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 = 24375 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0152  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 = 24368 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147  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 = 72986 ORDER BY nameShow LIMIT 100