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

Wealdstone

Entrenador: Sam Cox

Temporada 2023/2024
TEMPORADA 2023/2024
NATIONAL LEAGUE
Equipo PJ GF GC Puntos
1 Chesterfield Chesterfield 46 106 65 98
2 Barnet Barnet 46 91 60 86
3 Bromley Bromley 46 73 49 81
4 Altrincham Altrincham 46 84 59 77
5 Solihull Moors Solihull 46 71 62 76
6 Gateshead Gateshead 46 88 64 75
7 FC Halifax Town Halifax Town 46 58 50 71
8 Aldershot Town Aldershot 46 74 83 69
9 Southend United Southend 46 70 45 65
10 Oldham Athletic AFC Oldham 46 63 60 63
11 Rochdale Rochdale 46 69 64 62
12 Hartlepool United Hartlepool 46 70 82 60
13 Eastleigh Eastleigh 46 73 87 59
14 Maidenhead United Maidenhead 46 60 67 58
15 Dagenham & Redbridge Dagenham 46 69 63 56
16 Wealdstone Wealdstone 46 60 72 56
17 Woking Woking 46 49 55 55
18 Fylde Fylde 46 74 82 55
19 Ebbsfleet United Ebbsfleet 46 59 74 54
20 York City York City 46 55 69 53
21 Boreham Wood Boreham Wood 46 59 73 52
22 Kidderminster Harriers Kidderminste 46 40 59 46
23 Dorking Wanderers Dorking 46 54 85 45
24 Oxford City Oxford City 46 54 94 33
TEMPORADA 2022/2023
NATIONAL LEAGUE
Equipo PJ GF GC Puntos
1 Wrexham AFC Wrexham AFC 46 116 43 111
2 Notts County Notts County 46 117 42 107
3 Chesterfield Chesterfield 46 81 52 84
4 Woking Woking 46 71 48 82
5 Barnet Barnet 46 75 67 74
6 Boreham Wood Boreham Wood 46 52 40 72
7 Bromley Bromley 46 68 53 71
8 Southend United Southend 46 57 45 69
9 Eastleigh Eastleigh 46 56 57 67
10 Dagenham & Redbridge Dagenham 46 61 72 63
11 FC Halifax Town Halifax Town 46 49 48 61
12 Oldham Athletic AFC Oldham 46 63 64 61
13 Wealdstone Wealdstone 46 57 72 60
14 Gateshead Gateshead 46 67 62 59
15 Solihull Moors Solihull 46 62 66 58
16 Dorking Wanderers Dorking 46 67 91 57
17 Altrincham Altrincham 46 68 82 56
18 Aldershot Town Aldershot 46 64 76 53
19 York City York City 46 55 63 51
20 Maidenhead United Maidenhead 46 47 66 50
21 Torquay United Torquay 46 58 80 48
22 Yeovil Town Yeovil Town 46 35 60 40
23 Scunthorpe United Scunthorpe 46 49 87 34
24 Maidstone United Maidstone 46 45 104 25
TEMPORADA 2021/2022
NATIONAL LEAGUE
Equipo PJ GF GC Puntos
1 Stockport County Stockport 44 87 38 94
2 Wrexham AFC Wrexham AFC 44 91 46 88
3 Solihull Moors Solihull 44 83 45 87
4 FC Halifax Town Halifax Town 44 62 35 84
5 Notts County Notts County 44 81 52 82
6 Grimsby Town Grimsby Town 44 68 46 77
7 Chesterfield Chesterfield 44 69 51 74
8 Dagenham & Redbridge Dagenham 44 80 53 73
9 Boreham Wood Boreham Wood 44 49 40 67
10 Bromley Bromley 44 61 53 67
11 Torquay United Torquay 44 66 54 66
12 Yeovil Town Yeovil Town 44 43 46 59
13 Southend United Southend 44 45 61 58
14 Altrincham Altrincham 44 62 69 55
15 Woking Woking 44 59 61 53
16 Wealdstone Wealdstone 44 51 65 53
17 Maidenhead United Maidenhead 44 48 67 51
18 Barnet Barnet 44 59 89 50
19 Eastleigh Eastleigh 44 52 74 46
20 Aldershot Town Aldershot 44 46 73 43
21 Kings Lynn Town Kings Lynn. 44 47 79 34
22 Weymouth Weymouth 44 40 88 28
23 Dover Athletic Dover 44 37 101 1
TEMPORADA 2020/2021
NATIONAL LEAGUE
Equipo PJ GF GC Puntos
1 Sutton United Sutton 42 72 36 84
2 Torquay United Torquay 42 68 39 80
3 Stockport County Stockport 42 69 32 77
4 Hartlepool United Hartlepool 42 66 43 76
5 Notts County Notts County 42 62 41 70
6 Chesterfield Chesterfield 42 60 43 69
7 Bromley Bromley 42 63 53 69
8 Wrexham AFC Wrexham AFC 42 64 43 68
9 Eastleigh Eastleigh 42 49 40 66
10 FC Halifax Town Halifax Town 42 63 54 65
11 Solihull Moors Solihull 42 58 48 64
12 Dagenham & Redbridge Dagenham 42 53 48 60
13 Maidenhead United Maidenhead 42 62 60 56
14 Boreham Wood Boreham Wood 42 52 48 55
15 Aldershot Town Aldershot 42 59 66 52
16 Yeovil Town Yeovil Town 42 58 68 52
17 Altrincham Altrincham 42 46 60 47
18 Weymouth Weymouth 42 45 71 39
19 Wealdstone Wealdstone 42 49 99 37
20 Woking Woking 42 42 69 33
21 Kings Lynn Town Kings Lynn. 42 50 98 31
22 Barnet Barnet 42 37 88 31
23 Dover Athletic Dover 0 0 0 0
TEMPORADA 2019/2020
NATIONAL LEAGUE SOUTH
Equipo PJ GF GC Puntos
1 Wealdstone Wealdstone 33 69 35 70
2 Havant & Waterlooville Havant 34 64 37 67
3 Weymouth Weymouth 35 60 35 63
4 Bath City Bath City 35 50 37 63
5 Slough Town Slough Town 35 51 38 60
6 Dartford Dartford 34 60 46 56
7 Dorking Wanderers Dorking 35 58 56 50
8 Hampton & Richmond Hampton 33 51 50 47
9 Maidstone United Maidstone 33 48 44 45
10 Chelmsford City Chelmsford 34 55 56 44
11 Hemel Hempstead Town Hemel 34 36 43 44
12 Chippenham Town Chippenham 35 39 45 42
13 Welling United Welling 34 38 46 42
14 Oxford City Oxford City 34 47 60 42
15 Eastbourne Borough Eastbourne 33 38 54 38
16 Dulwich Hamlet FC Dulwich 35 51 50 37
17 Concord Rangers Concord 32 44 48 37
18 Billericay Town Billericay 32 46 55 37
19 St. Albans City Albans City 35 41 54 37
20 Tonbridge Angels Tonbridge 31 46 54 36
21 Braintree Town Braintree 35 44 67 35
22 Hungerford Town Hungerford 33 38 64 28
TEMPORADA 2018/2019
NATIONAL LEAGUE SOUTH
Equipo PJ GF GC Puntos
1 Torquay United Torquay 42 93 41 88
2 Woking Woking 42 76 49 78
3 Welling United Welling 42 70 47 76
4 Concord Rangers Concord 42 69 48 73
5 Chelmsford City Chelmsford 42 68 50 72
6 Bath City Bath City 41 57 36 68
7 Wealdstone Wealdstone 42 62 50 66
8 Billericay Town Billericay 42 72 65 65
9 St. Albans City Albans City 42 67 64 64
10 Dartford Dartford 42 52 58 64
11 Slough Town Slough Town 42 56 50 63
12 Oxford City Oxford City 42 64 63 56
13 Chippenham Town Chippenham 42 57 64 55
14 Dulwich Hamlet FC Dulwich 42 52 65 49
15 Hampton & Richmond Hampton 41 49 65 49
16 Hemel Hempstead Town Hemel 42 52 67 48
17 Gloucester City Gloucester 42 35 54 47
18 Eastbourne Borough Eastbourne 42 52 65 42
19 Hungerford Town Hungerford 42 45 72 42
20 Truro City Truro City 42 63 87 39
21 East Thurrock United FC East 42 42 63 37
22 Weston-super-Mare Weston-super 42 50 80 35
TEMPORADA 2017/2018
NATIONAL LEAGUE SOUTH
Equipo PJ GF GC Puntos
1 Havant & Waterlooville Havant 42 70 30 86
2 Dartford Dartford 42 81 44 86
3 Chelmsford City Chelmsford 42 68 45 74
4 Hampton & Richmond Hampton 42 58 37 72
5 Hemel Hempstead Town Hemel 42 71 51 70
6 Braintree Town Braintree 42 73 55 69
7 Truro City Truro City 42 71 55 69
8 St. Albans City Albans City 42 71 58 65
9 Bath City Bath City 42 64 48 63
10 Welling United Welling 42 68 59 61
11 Wealdstone Wealdstone 42 64 62 59
12 Weston-super-Mare Weston-super 42 66 73 55
13 Chippenham Town Chippenham 42 64 70 54
14 Gloucester City Gloucester 42 56 70 53
15 East Thurrock United FC East 42 68 84 50
16 Oxford City Oxford City 42 60 69 49
17 Concord Rangers Concord 42 46 62 46
18 Eastbourne Borough Eastbourne 42 57 80 46
19 Hungerford Town Hungerford 42 45 68 43
20 Poole Town Poole Town 42 47 73 42
21 Whitehawk Whitehawk 42 51 89 34
22 Bognor Regis Town Bognor Regis 42 41 78 27
TEMPORADA 2016/2017
NATIONAL LEAGUE SOUTH
Equipo PJ GF GC Puntos
1 Maidenhead United Maidenhead 42 93 29 98
2 Ebbsfleet United Ebbsfleet 42 96 30 96
3 Chelmsford City Chelmsford 42 89 47 82
4 Dartford Dartford 41 80 43 81
5 Hampton & Richmond Hampton 43 84 56 72
6 Poole Town Poole Town 42 63 49 71
7 Hungerford Town Hungerford 42 67 49 70
8 Wealdstone Wealdstone 42 62 58 66
9 Bath City Bath City 42 71 52 62
10 St. Albans City Albans City 42 72 66 59
11 Eastbourne Borough Eastbourne 41 80 67 58
12 Hemel Hempstead Town Hemel 42 74 83 57
13 East Thurrock United FC East 42 73 65 56
14 Oxford City Oxford City 42 48 73 52
15 Weston-super-Mare Weston-super 42 63 69 48
16 Welling United Welling 42 64 69 43
17 Whitehawk Whitehawk 42 51 72 43
18 Concord Rangers Concord 42 57 75 42
19 Truro City Truro City 43 53 102 40
20 Gosport Borough Gosport 42 45 101 36
21 Bishops Stortford Bishops 42 29 104 27
22 Margate Margate 42 26 81 25
TEMPORADA 2015/2016
NATIONAL LEAGUE SOUTH
Equipo PJ GF GC Puntos
1 Sutton United Sutton 42 83 32 90
2 Ebbsfleet United Ebbsfleet 42 73 36 84
3 Maidstone United Maidstone 42 55 40 77
4 Truro City Truro City 42 62 55 65
5 Whitehawk Whitehawk 42 75 62 64
6 Hemel Hempstead Town Hemel 42 72 66 61
7 Maidenhead United Maidenhead 42 66 62 59
8 Dartford Dartford 42 58 56 59
9 Gosport Borough Gosport 42 53 63 56
10 Concord Rangers Concord 42 66 68 55
11 Bishops Stortford Bishops 42 56 63 55
12 Oxford City Oxford City 42 70 60 54
13 Wealdstone Wealdstone 42 63 64 53
14 Bath City Bath City 42 50 61 53
15 Chelmsford City Chelmsford 42 66 64 52
16 Weston-super-Mare Weston-super 42 63 76 51
17 Eastbourne Borough Eastbourne 42 60 63 50
18 St. Albans City Albans City 42 58 65 49
19 Margate Margate 42 51 73 47
20 Havant & Waterlooville Havant 42 52 75 47
21 Hayes & Yeading United Hayes 42 51 76 46
22 Basingstoke Town Basingstoke 42 46 69 38
TEMPORADA 2014/2015
NATIONAL LEAGUE SOUTH
Equipo PJ GF GC Puntos
1 Bromley Bromley 40 79 46 77
2 Boreham Wood Boreham Wood 40 79 44 75
3 Basingstoke Town Basingstoke 40 67 43 73
4 Whitehawk Whitehawk 40 62 47 72
5 Havant & Waterlooville Havant 40 61 41 70
6 Gosport Borough Gosport 40 63 40 67
7 Concord Rangers Concord 40 60 44 65
8 Ebbsfleet United Ebbsfleet 40 60 41 60
9 Hemel Hempstead Town Hemel 40 64 60 60
10 Chelmsford City Chelmsford 40 65 71 56
11 Eastbourne Borough Eastbourne 40 51 50 55
12 Wealdstone Wealdstone 40 56 56 54
13 St. Albans City Albans City 40 53 53 54
14 Bath City Bath City 40 59 57 53
15 Sutton United Sutton 40 50 54 50
16 Bishops Stortford Bishops 40 55 69 46
17 Weston-super-Mare Weston-super 40 55 86 44
18 Maidenhead United Maidenhead 40 54 70 43
19 Hayes & Yeading United Hayes 40 39 58 42
20 Farnborough Farnborough 40 42 101 30
21 Staines Town Staines Town 40 39 82 25
TEMPORADA 2013/2014
NON LEAGUE PREMIER GRUPO 1
Equipo PJ GF GC Puntos
1 Maidstone United Maidstone 32 69 34 66
2 Dulwich Hamlet FC Dulwich 31 69 41 64
3 Wealdstone Wealdstone 28 65 31 58
4 Kingstonian Kingstonian 30 60 30 58
5 Bognor Regis Town Bognor Regis 30 71 47 57
6 AFC Hornchurch Hornchurch 29 55 33 57
7 Lowestoft Town Lowestoft 31 52 31 53
8 Bury Town Bury Town 30 48 46 46
9 Lewes Lewes 29 48 37 43
10 Hampton & Richmond Hampton 29 46 44 41
11 Margate Margate 30 46 50 41
12 Leiston Leiston 31 50 57 41
13 Hendon Hendon 29 59 50 40
14 Billericay Town Billericay 27 44 44 39
15 Canvey Island Canvey 32 41 49 38
16 Wingate & Finchley Wingate 29 47 47 37
17 Metropolitan Police Metropolitan 30 32 40 36
18 Harrow Borough Harrow 30 42 50 33
19 Thamesmead Town FC Thamesmead 33 47 72 32
20 East Thurrock United FC East 29 42 53 29
21 Grays Athletic Grays 25 36 46 28
22 Enfield Town Enfield Town 29 40 70 24
23 Carshalton Athletic Carshalton 29 26 63 17
24 Cray Wanderers Cray 30 25 95 14
TEMPORADA 2012/2013
NON LEAGUE PREMIER GRUPO 5
Equipo PJ GF GC Puntos
1 Concord Rangers Concord 2 4 2 6
2 Lowestoft Town Lowestoft 2 2 2 3
3 Wealdstone Wealdstone 1 1 2 0
4 East Thurrock United FC East 1 0 1 0
TEMPORADA 2011/2012
NON LEAGUE PREMIER GRUPO 5
Equipo PJ GF GC Puntos
1 AFC Hornchurch Hornchurch 2 5 2 6
2 Lowestoft Town Lowestoft 2 3 3 3
3 Wealdstone Wealdstone 1 1 2 0
4 Bury Town Bury Town 1 1 3 0
TEMPORADA 2010/2011
NON LEAGUE PREMIER GRUPO 2
Equipo PJ GF GC Puntos
1 Sutton United Sutton 42 76 33 87
2 Tonbridge Angels Tonbridge 42 71 45 76
3 Bury Town Bury Town 42 67 49 76
4 Lowestoft Town Lowestoft 42 68 30 75
5 Harrow Borough Harrow 42 77 51 73
6 Canvey Island Canvey 42 69 51 73
7 Kingstonian Kingstonian 42 66 50 72
8 Concord Rangers Concord 42 72 55 71
9 Cray Wanderers Cray 42 72 46 69
10 AFC Hornchurch Hornchurch 42 58 46 69
11 Billericay Town Billericay 42 56 45 69
12 Wealdstone Wealdstone 42 58 54 58
13 Carshalton Athletic Carshalton 42 49 57 52
14 Tooting and Mitcham Tooting 42 63 85 49
15 Hendon Hendon 42 61 81 46
16 Margate Margate 42 52 64 45
17 Horsham Horsham 42 43 77 44
18 Hastings United Hastings 42 50 65 38
19 Aveley Aveley 42 35 62 38
20 Maidstone United Maidstone 42 43 75 37
21 Croydon Athletic Croydon 42 44 95 34
22 Folkestone Invicta Folkestone 42 34 68 27
TEMPORADA 2009/2010
NON LEAGUE PREMIER GRUPO 1
Equipo PJ GF GC Puntos
1 Dartford Dartford 42 101 45 93
2 Sutton United Sutton 42 65 45 75
3 Aveley Aveley 42 83 62 70
4 Boreham Wood Boreham Wood 42 54 44 68
5 Kingstonian Kingstonian 42 73 69 68
6 Wealdstone Wealdstone 42 65 65 65
7 Hastings United Hastings 42 68 56 63
8 Tonbridge Angels Tonbridge 42 69 67 62
9 AFC Hornchurch Hornchurch 42 51 47 61
10 Hendon Hendon 42 61 59 60
11 Horsham Horsham 42 65 67 56
12 Tooting and Mitcham Tooting 42 60 64 55
13 Billericay Town Billericay 42 44 42 54
14 Harrow Borough Harrow 42 66 63 53
15 Cray Wanderers Cray 42 54 70 51
16 Canvey Island Canvey 42 57 62 50
17 Carshalton Athletic Carshalton 42 58 64 49
18 Maidstone United Maidstone 42 39 57 49
19 Margate Margate 42 49 71 45
20 Ashford Town Ashford Town 42 62 80 44
21 Waltham Abbey Waltham 42 49 74 44
22 Bognor Regis Town Bognor Regis 42 45 65 41
TEMPORADA 2008/2009
NON LEAGUE PREMIER GRUPO 2
Equipo PJ GF GC Puntos
1 Dover Athletic Dover 42 91 34 104
2 Staines Town Staines Town 42 75 41 82
3 Tonbridge Angels Tonbridge 42 82 54 73
4 Carshalton Athletic Carshalton 41 63 62 67
5 Sutton United Sutton 41 56 52 66
6 AFC Hornchurch Hornchurch 42 60 51 65
7 Wealdstone Wealdstone 42 70 56 62
8 Dartford Dartford 42 62 49 62
9 Tooting and Mitcham Tooting 42 57 57 58
10 Ashford Town Ashford Town 42 64 66 56
11 Billericay Town Billericay 42 54 66 56
12 Canvey Island Canvey 42 65 70 55
13 Horsham Horsham 42 49 60 55
14 Harrow Borough Harrow 42 56 73 54
15 Maidstone United Maidstone 42 46 51 53
16 Hendon Hendon 42 69 65 51
17 Hastings United Hastings 42 52 68 49
18 Boreham Wood Boreham Wood 42 48 61 48
19 Margate Margate 42 51 64 46
20 Harlow Town Harlow Town 42 61 77 45
21 Heybridge Swifts Heybridge 42 41 63 41
22 Ramsgate Ramsgate 42 47 79 35
TEMPORADA 2007/2008
NON LEAGUE PREMIER GRUPO 1
Equipo PJ GF GC Puntos
1 Chelmsford City Chelmsford 42 84 39 87
2 AFC Wimbledon Wimbledon 42 81 47 75
3 Staines Town Staines Town 41 84 54 75
4 AFC Hornchurch Hornchurch 42 68 44 70
5 Ramsgate Ramsgate 42 67 53 68
6 Ashford Town Ashford Town 42 79 65 66
7 Hendon Hendon 42 79 67 65
8 Margate Margate 43 75 70 65
9 Tonbridge Angels Tonbridge 42 77 57 63
10 Billericay Town Billericay 42 66 57 60
11 Horsham Horsham 42 63 63 59
12 Hastings United Hastings 43 59 67 56
13 Wealdstone Wealdstone 42 68 75 54
14 Harlow Town Harlow Town 41 56 51 52
15 Heybridge Swifts Heybridge 41 60 63 52
16 Harrow Borough Harrow 41 61 73 52
17 East Thurrock United FC East 43 49 68 52
18 Boreham Wood Boreham Wood 41 55 69 50
19 Carshalton Athletic Carshalton 43 52 66 50
20 Folkestone Invicta Folkestone 43 50 71 50
21 Maidstone United Maidstone 41 55 79 49
22 Leyton FC Leyton FC 43 37 127 16
TEMPORADA 2006/2007
NON LEAGUE PREMIER GRUPO 3
Equipo PJ GF GC Puntos
1 Bath City Bath City 42 84 29 91
2 Team Bath Team Bath 42 66 42 78
3 Kings Lynn Town Kings Lynn. 42 69 40 76
4 Maidenhead United Maidenhead 42 58 36 70
5 Hemel Hempstead Town Hemel 42 79 60 69
6 Halesowen Town Halesowen 42 66 53 67
7 Chippenham Town Chippenham 42 61 56 66
8 Stamford Stamford 42 65 62 59
9 Mangotsfield United Mangotsfield 42 44 45 58
10 Gloucester City Gloucester 42 67 70 58
11 Hitchin Town Hitchin Town 42 55 68 57
12 Merthyr Tydfil FC Merthyr 42 47 46 56
13 Banbury United Banbury 42 60 64 55
14 Yate Town Yate Town 42 59 71 54
15 Tiverton Town Tiverton 42 56 67 50
16 Cheshunt Cheshunt 42 56 71 49
17 Rugby Town Rugby Town 42 58 79 49
18 Clevedon Town Clevedon 42 60 61 48
19 Wealdstone Wealdstone 42 69 82 48
20 Corby Town Corby Town 42 52 69 39
21 Cirencester Town Cirencester 42 46 76 39
22 Northwood Northwood 42 44 74 34

  USO DE MEMORIA  
8,528,712 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0028
Controller Execution Time ( Home / Category )  0.8413
Total Execution Time  0.8442
  CADENA URL  
/historico/Wealdstone
  GET DATOS  
$_GET['/historico/Wealdstone']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (45)  
0.0158  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 = 'Wealdstone' 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=11173 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=11173 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=11173 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=11173 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=11173 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0293  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 = 72111
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=11173 AND type_rel = 2
0.0153  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 = '11173' ORDER BY l.year DESC,cat.coefficient DESC
0.0151  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 = '11173' 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 = '11173' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0147  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 = 72111 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0152  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=11173 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0146  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 (72728,72677,72111,71432) 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.0152  SELECT count(id) as num_players from rel_players WHERE league_id = 72111 AND teamId = 11173
0.0169  SELECT count(id) as num_players from rel_players WHERE league_id = 72728 AND teamId = 11173
0.0169  SELECT count(id) as num_players from rel_players WHERE league_id = 72677 AND teamId = 11173
0.0151  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 11173
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 = '11173' 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 = '11173' 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 = '11173' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0163  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 = 72111 WHERE rp.league_id = 72111 AND rp.teamId = 11173 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.0162  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 = 72111 WHERE rp.league_id = 72111 AND rp.teamId = 11173 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0159  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 = 72111 WHERE rp.league_id = 72111 AND rp.teamId = 11173 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0152  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 = 11173 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 72111 AND t.round = 46 ORDER BY team.conference ASC,t.position 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 `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 = 68217 AND t.round = 46 ORDER BY team.conference ASC,t.position 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 `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 = 63246 AND t.round = 46 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 `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 = 58730 AND t.round = 46 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0153  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 = 50297 AND t.round = 35 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0155  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 = 44238 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0153  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 = 38705 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 = 33912 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 `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 = 15426 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 `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 = 3895 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 `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 = 3476 AND t.round = 46 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 `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 = 24447 AND t.round = 42 ORDER BY team.conference 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 `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 = 24453 AND t.round = 2 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 `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 = 24434 AND t.round = 42 ORDER BY team.conference 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 `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 = 24441 AND t.round = 2 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 `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 = 24422 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 `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 = 24413 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 `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 = 24406 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0153  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 = 24398 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0153  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 = 24386 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC