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

Bromley

Entrenador: Andy Woodman

Temporada 2019/2020
TEMPORADA 2019/2020
NATIONAL LEAGUE
Equipo PJ GF GC Puntos
1 Barrow Barrow 37 68 39 70
2 Harrogate Town Harrogate 37 61 44 66
3 Notts County Notts County 38 61 38 63
4 Yeovil Town Yeovil Town 37 61 44 60
5 Boreham Wood Boreham Wood 37 55 40 60
6 FC Halifax Town Halifax Town 37 50 49 58
7 Barnet Barnet 35 52 42 54
8 Stockport County Stockport 39 51 54 58
9 Solihull Moors Solihull 38 48 37 55
10 Woking Woking 38 50 55 55
11 Dover Athletic Dover 38 49 49 54
12 Hartlepool United Hartlepool 39 56 50 55
13 Bromley Bromley 38 57 52 52
14 Torquay United Torquay 36 56 61 48
15 Sutton United Sutton 38 47 42 50
16 Eastleigh Eastleigh 37 43 55 46
17 Dagenham & Redbridge Dagenham 37 40 44 44
18 Aldershot Town Aldershot 39 43 55 46
19 Wrexham AFC Wrexham AFC 37 46 49 43
20 Chesterfield Chesterfield 38 55 65 44
21 Maidenhead United Maidenhead 38 44 58 41
22 Ebbsfleet United Ebbsfleet 39 47 68 42
23 Fylde Fylde 37 44 60 39
24 Chorley Chorley 38 31 65 26
TEMPORADA 2018/2019
NATIONAL LEAGUE
Equipo PJ GF GC Puntos
1 Leyton Orient Leyton 46 73 35 89
2 Solihull Moors Solihull 46 73 43 86
3 Salford City Salford City 46 77 45 85
4 Wrexham AFC Wrexham AFC 46 58 39 84
5 Fylde Fylde 46 72 41 81
6 Harrogate Town Harrogate 46 78 57 74
7 Eastleigh Eastleigh 46 62 63 74
8 Ebbsfleet United Ebbsfleet 46 64 50 67
9 Gateshead Gateshead 46 52 48 66
10 Sutton United Sutton 46 55 60 65
11 Barrow Barrow 46 52 51 64
12 Bromley Bromley 46 68 69 60
13 Barnet Barnet 46 45 50 60
14 Dover Athletic Dover 46 58 64 60
15 Chesterfield Chesterfield 46 55 53 59
16 FC Halifax Town Halifax Town 46 44 43 59
17 Hartlepool United Hartlepool 46 56 62 59
18 Dagenham & Redbridge Dagenham 46 50 56 56
19 Maidenhead United Maidenhead 46 45 70 54
20 Boreham Wood Boreham Wood 46 53 65 52
21 Aldershot Town Aldershot 46 38 67 44
22 Braintree Town Braintree 46 48 78 41
23 Havant & Waterlooville Havant 46 62 84 40
24 Maidstone United Maidstone 46 37 82 34
TEMPORADA 2017/2018
NATIONAL LEAGUE
Equipo PJ GF GC Puntos
1 Macclesfield Town Macclesfield 46 67 46 92
2 Tranmere Rovers Tranmere 46 78 46 82
3 Sutton United Sutton 46 67 53 79
4 Boreham Wood Boreham Wood 46 64 47 75
5 Aldershot Town Aldershot 46 64 52 75
6 Ebbsfleet United Ebbsfleet 46 64 50 74
7 Fylde Fylde 46 82 56 73
8 Dover Athletic Dover 46 62 44 73
9 Bromley Bromley 46 75 58 70
10 Wrexham AFC Wrexham AFC 46 49 39 70
11 Dagenham & Redbridge Dagenham 46 69 62 68
12 Maidenhead United Maidenhead 46 65 66 64
13 Leyton Orient Leyton 46 58 56 60
14 Eastleigh Eastleigh 46 65 72 56
15 Hartlepool United Hartlepool 46 53 63 56
16 FC Halifax Town Halifax Town 46 48 58 55
17 Gateshead Gateshead 46 62 58 54
18 Solihull Moors Solihull 46 49 60 54
19 Maidstone United Maidstone 46 52 64 54
20 Barrow Barrow 46 51 63 49
21 Woking Woking 46 55 76 48
22 Torquay United Torquay 46 45 73 42
23 Chester Chester 46 42 79 37
24 Guiseley Guiseley 46 44 89 33
TEMPORADA 2016/2017
NATIONAL LEAGUE
Equipo PJ GF GC Puntos
1 Lincoln City Lincoln City 46 83 40 99
2 Tranmere Rovers Tranmere 46 79 39 95
3 Forest Green Rovers Forest Green 46 88 56 86
4 Dagenham & Redbridge Dagenham 46 79 53 84
5 Aldershot Town Aldershot 46 66 37 82
6 Dover Athletic Dover 46 85 63 79
7 Barrow Barrow 46 72 53 75
8 Gateshead Gateshead 46 72 51 70
9 Macclesfield Town Macclesfield 46 64 57 68
10 Bromley Bromley 46 59 66 62
11 Boreham Wood Boreham Wood 46 49 48 58
12 Sutton United Sutton 46 61 63 58
13 Wrexham AFC Wrexham AFC 46 47 61 58
14 Maidstone United Maidstone 46 59 75 58
15 Eastleigh Eastleigh 46 56 63 57
16 Solihull Moors Solihull 46 62 75 55
17 Torquay United Torquay 46 54 61 53
18 Woking Woking 46 66 80 53
19 Chester Chester 46 63 71 52
20 Guiseley Guiseley 46 50 67 51
21 York City York City 46 55 70 50
22 Braintree Town Braintree 46 51 76 48
23 Southport Southport 46 52 97 39
24 North Ferriby United North 46 32 82 39
TEMPORADA 2015/2016
NATIONAL LEAGUE
Equipo PJ GF GC Puntos
1 Cheltenham Town Cheltenham 46 87 30 101
2 Forest Green Rovers Forest Green 46 69 42 89
3 Braintree Town Braintree 46 56 38 81
4 Grimsby Town Grimsby Town 46 82 45 80
5 Dover Athletic Dover 46 75 53 80
6 Tranmere Rovers Tranmere 46 61 44 78
7 Eastleigh Eastleigh 46 64 53 75
8 Wrexham AFC Wrexham AFC 46 71 55 69
9 Gateshead Gateshead 46 59 70 67
10 Macclesfield Town Macclesfield 46 60 48 66
11 Barrow Barrow 46 64 71 65
12 Woking Woking 46 71 68 61
13 Lincoln City Lincoln City 46 69 68 61
14 Bromley Bromley 46 66 72 60
15 Aldershot Town Aldershot 46 54 72 56
16 Southport Southport 46 52 65 55
17 Chester Chester 46 67 70 54
18 Torquay United Torquay 46 54 76 51
19 Boreham Wood Boreham Wood 46 44 49 50
20 Guiseley Guiseley 46 47 70 49
21 FC Halifax Town Halifax Town 46 54 82 48
22 Altrincham Altrincham 46 48 73 44
23 Kidderminster Harriers Kidderminste 46 49 71 40
24 Welling United Welling 46 35 73 35
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
NATIONAL LEAGUE SOUTH
Equipo PJ GF GC Puntos
1 Eastleigh Eastleigh 42 71 40 86
2 Sutton United Sutton 42 77 39 81
3 Bromley Bromley 42 82 50 80
4 Ebbsfleet United Ebbsfleet 42 67 40 74
5 Dover Athletic Dover 42 63 38 69
6 Havant & Waterlooville Havant 42 57 43 69
7 Bath City Bath City 42 64 52 66
8 Staines Town Staines Town 42 56 57 63
9 Concord Rangers Concord 42 58 59 61
10 Eastbourne Borough Eastbourne 42 55 59 58
11 Weston-super-Mare Weston-super 42 50 55 57
12 Gosport Borough Gosport 42 46 51 55
13 Boreham Wood Boreham Wood 42 65 55 53
14 Basingstoke Town Basingstoke 42 55 56 53
15 Bishops Stortford Bishops 42 63 68 52
16 Farnborough Farnborough 42 62 78 50
17 Chelmsford City Chelmsford 42 57 77 49
18 Maidenhead United Maidenhead 42 55 69 46
19 Whitehawk Whitehawk 42 56 71 46
20 Hayes & Yeading United Hayes 42 45 52 45
21 Tonbridge Angels Tonbridge 42 43 77 40
22 Dorchester Town Dorchester 42 33 94 31
TEMPORADA 2012/2013
NATIONAL LEAGUE SOUTH
Equipo PJ GF GC Puntos
1 Welling United Welling 42 90 44 86
2 Salisbury City Salisbury 42 80 47 82
3 Dover Athletic Dover 42 69 44 76
4 Eastleigh Eastleigh 43 80 62 73
5 Chelmsford City Chelmsford 42 70 56 72
6 Sutton United Sutton 42 66 49 70
7 Weston-super-Mare Weston-super 41 60 54 66
8 Dorchester Town Dorchester 42 59 62 65
9 Boreham Wood Boreham Wood 42 59 46 62
10 Havant & Waterlooville Havant 42 68 60 58
11 Bath City Bath City 41 59 57 54
12 Eastbourne Borough Eastbourne 42 42 52 51
13 Farnborough Farnborough 42 76 75 50
14 Basingstoke Town Basingstoke 42 63 73 48
15 Bromley Bromley 42 54 69 48
16 Tonbridge Angels Tonbridge 42 56 77 48
17 Staines Town Staines Town 42 61 78 47
18 Hayes & Yeading United Hayes 41 63 88 47
19 Maidenhead United Maidenhead 43 64 69 45
20 AFC Hornchurch Hornchurch 42 47 64 44
21 Billericay Town Billericay 43 63 90 43
22 Truro City Truro City 42 57 90 25
TEMPORADA 2011/2012
NATIONAL LEAGUE SOUTH
Equipo PJ GF GC Puntos
1 Woking Woking 42 92 41 97
2 Dartford Dartford 42 89 40 88
3 Welling United Welling 42 79 47 81
4 Sutton United Sutton 42 68 53 74
5 Basingstoke Town Basingstoke 42 65 50 71
6 Chelmsford City Chelmsford 42 67 44 67
7 Dover Athletic Dover 42 62 49 66
8 Boreham Wood Boreham Wood 42 66 58 61
9 Tonbridge Angels Tonbridge 42 70 67 57
10 Salisbury City Salisbury 42 55 54 57
11 Dorchester Town Dorchester 42 58 65 56
12 Eastleigh Eastleigh 42 57 63 54
13 Weston-super-Mare Weston-super 42 58 71 51
14 Truro City Truro City 42 65 80 48
15 Staines Town Staines Town 42 53 63 46
16 Farnborough Farnborough 42 52 79 46
17 Bromley Bromley 42 52 66 45
18 Eastbourne Borough Eastbourne 42 54 69 45
19 Havant & Waterlooville Havant 42 64 75 44
20 Maidenhead United Maidenhead 42 49 74 43
21 Hampton & Richmond Hampton 42 53 69 42
22 Thurrock Thurrock 42 33 84 26
TEMPORADA 2010/2011
NATIONAL LEAGUE SOUTH
Equipo PJ GF GC Puntos
1 Braintree Town Braintree 42 78 33 89
2 Farnborough Farnborough 42 83 47 82
3 Ebbsfleet United Ebbsfleet 42 75 51 78
4 Chelmsford City Chelmsford 42 82 50 77
5 Woking Woking 42 62 42 76
6 Welling United Welling 42 81 47 75
7 Dover Athletic Dover 42 80 51 74
8 Eastleigh Eastleigh 42 74 53 72
9 Havant & Waterlooville Havant 42 56 51 58
10 Dartford Dartford 42 60 60 57
11 Bromley Bromley 42 49 61 57
12 Weston-super-Mare Weston-super 42 56 67 53
13 Basingstoke Town Basingstoke 42 50 63 49
14 Boreham Wood Boreham Wood 42 56 67 47
15 Staines Town Staines Town 42 48 63 47
16 Bishops Stortford Bishops 42 48 79 45
17 Dorchester Town Dorchester 42 49 59 44
18 Hampton & Richmond Hampton 42 43 60 42
19 Maidenhead United Maidenhead 42 43 70 40
20 Thurrock Thurrock 42 50 77 37
21 Lewes Lewes 42 34 70 36
22 St. Albans City Albans City 42 39 75 24
TEMPORADA 2009/2010
NATIONAL LEAGUE SOUTH
Equipo PJ GF GC Puntos
1 Newport County Newport 42 93 26 103
2 Dover Athletic Dover 42 66 47 75
3 Chelmsford City Chelmsford 42 62 48 75
4 Bath City Bath City 42 66 46 72
5 Woking Woking 42 57 44 72
6 Havant & Waterlooville Havant 42 65 44 71
7 Braintree Town Braintree 42 56 41 71
8 Staines Town Staines Town 42 59 40 67
9 Welling United Welling 42 66 51 63
10 Thurrock Thurrock 42 66 60 61
11 Eastleigh Eastleigh 42 71 66 60
12 Bromley Bromley 42 68 64 55
13 St. Albans City Albans City 42 45 55 55
14 Hampton & Richmond Hampton 42 56 66 51
15 Basingstoke Town Basingstoke 42 49 68 49
16 Maidenhead United Maidenhead 42 52 59 48
17 Dorchester Town Dorchester 42 56 74 48
18 Bishops Stortford Bishops 42 48 59 47
19 Lewes Lewes 42 49 63 42
20 Worcester City Worcester 42 48 60 40
21 Weston-super-Mare Weston-super 42 48 93 23
22 Weymouth Weymouth 42 31 103 22
TEMPORADA 2008/2009
NATIONAL LEAGUE SOUTH
Equipo PJ GF GC Puntos
1 AFC Wimbledon Wimbledon 42 86 36 88
2 Hampton & Richmond Hampton 42 74 37 85
3 Eastleigh Eastleigh 42 69 49 83
4 Hayes & Yeading United Hayes 42 74 43 81
5 Chelmsford City Chelmsford 42 72 52 77
6 Maidenhead United Maidenhead 42 57 46 71
7 Welling United Welling 42 61 44 68
8 Bath City Bath City 42 56 45 68
9 Bishops Stortford Bishops 42 60 60 59
10 Newport County Newport 42 50 51 59
11 Team Bath Team Bath 42 62 64 55
12 St. Albans City Albans City 42 56 50 54
13 Bromley Bromley 42 60 64 54
14 Braintree Town Braintree 42 57 54 52
15 Havant & Waterlooville Havant 42 59 58 48
16 Worcester City Worcester 42 38 53 47
17 Weston-super-Mare Weston-super 42 43 68 47
18 Basingstoke Town Basingstoke 42 36 55 46
19 Dorchester Town Dorchester 42 39 61 42
20 Thurrock Thurrock 42 54 60 40
21 Bognor Regis Town Bognor Regis 42 33 68 24
22 Fisher FC Fisher FC 42 22 100 18
TEMPORADA 2007/2008
NATIONAL LEAGUE SOUTH
Equipo PJ GF GC Puntos
1 Lewes Lewes 42 81 39 89
2 Eastbourne Borough Eastbourne 42 83 38 80
3 Hampton & Richmond Hampton 42 87 49 77
4 Fisher FC Fisher FC 42 65 61 71
5 Braintree Town Braintree 42 52 42 69
6 Eastleigh Eastleigh 42 76 62 67
7 Havant & Waterlooville Havant 42 59 53 67
8 Bath City Bath City 42 59 36 66
9 Newport County Newport 42 64 49 66
10 Bishops Stortford Bishops 42 72 60 64
11 Bromley Bromley 42 77 66 64
12 Thurrock Thurrock 42 63 64 63
13 Hayes & Yeading United Hayes 42 67 73 54
14 Cambridge City Cambridge 42 71 72 52
15 Basingstoke Town Basingstoke 42 54 75 50
16 Welling United Welling 42 41 64 46
17 Maidenhead United Maidenhead 42 56 59 45
18 Bognor Regis Town Bognor Regis 42 49 67 44
19 St. Albans City Albans City 42 43 69 42
20 Weston-super-Mare Weston-super 42 52 85 37
21 Dorchester Town Dorchester 42 36 70 34
22 Sutton United Sutton 42 32 86 24
TEMPORADA 2006/2007
NON LEAGUE PREMIER GRUPO 1
Equipo PJ GF GC Puntos
1 Hampton & Richmond Hampton 42 77 53 82
2 Bromley Bromley 42 83 43 80
3 AFC Wimbledon Wimbledon 42 76 37 78
4 Chelmsford City Chelmsford 42 96 51 77
5 Billericay Town Billericay 41 69 39 77
6 Margate Margate 42 79 48 71
7 Horsham Horsham 43 72 57 71
8 Boreham Wood Boreham Wood 41 66 45 66
9 Ramsgate Ramsgate 43 63 65 65
10 Heybridge Swifts Heybridge 42 57 40 64
11 Tonbridge Angels Tonbridge 43 75 74 64
12 Staines Town Staines Town 42 64 64 57
13 Hendon Hendon 42 53 64 54
14 Carshalton Athletic Carshalton 41 51 57 51
15 Leyton FC Leyton FC 42 55 77 49
16 East Thurrock United FC East 42 56 70 48
17 Ashford Town Ashford Town 41 55 66 46
18 Folkestone Invicta Folkestone 42 45 66 46
19 Harrow Borough Harrow 41 59 70 42
20 Walton & Hersham Walton 43 40 84 36
21 Worthing Worthing 41 56 80 35
22 Slough Town Slough Town 42 26 123 18
TEMPORADA 2005/2006
NON LEAGUE PREMIER GRUPO 2
Equipo PJ GF GC Puntos
1 Braintree Town Braintree 42 74 32 94
2 Heybridge Swifts Heybridge 42 70 46 87
3 Fisher Athletic FC Fisher 42 84 46 85
4 AFC Wimbledon Wimbledon 42 67 36 77
5 Hampton & Richmond Hampton 42 73 53 75
6 Staines Town Staines Town 42 74 56 70
7 Billericay Town Billericay 42 69 45 69
8 Worthing Worthing 42 71 59 67
9 Walton & Hersham Walton 42 55 50 64
10 Chelmsford City Chelmsford 42 56 62 64
11 Bromley Bromley 42 57 49 62
12 East Thurrock United FC East 42 59 60 59
13 Folkestone Invicta Folkestone 42 47 51 58
14 Margate Margate 42 49 55 50
15 Leyton FC Leyton FC 42 57 60 48
16 Harrow Borough Harrow 42 56 73 48
17 Slough Town Slough Town 41 60 72 46
18 Wealdstone Wealdstone 42 68 82 44
19 Hendon Hendon 42 44 64 39
20 Maldon & Tiptree Maldon 42 41 73 35
21 Windsor & Eton FC Windsor Eton 41 33 71 31
22 Redbridge Redbridge 42 28 97 14
TEMPORADA 2004/2005
NON LEAGUE DIVISION 1 GRUPO 1
Equipo PJ GF GC Puntos
1 AFC Wimbledon Wimbledon 42 91 33 97
2 Walton & Hersham Walton 42 69 34 88
3 Horsham Horsham 42 90 61 78
4 Bromley Bromley 42 69 44 75
5 Metropolitan Police Metropolitan 42 72 51 74
6 Leatherhead Leatherhead 42 73 55 73
7 Cray Wanderers Cray 41 93 53 70
8 Tooting and Mitcham Tooting 42 92 60 69
9 Burgess Hill Town Burgess Hill 42 73 62 63
10 Whyteleafe Whyteleafe 41 58 59 63
11 Hastings United Hastings 41 54 55 56
12 Croydon Athletic Croydon 42 66 65 55
13 Corinthian-Casuals Corinthian-C 42 56 64 54
14 Bashley Bashley 42 68 74 52
15 Dulwich Hamlet FC Dulwich 42 61 64 44
16 Molesey FC Molesey FC 42 46 70 44
17 Banstead Athletic Banstead 42 50 64 40
18 Newport Isle of Wight FC Newport Isle 42 50 88 40
19 Fleet Town Fleet Town 42 47 86 38
20 Ashford Town Kent Ashford Town 41 47 83 36
21 Dorking Wanderers Dorking 42 43 89 35
22 Croydon Croydon 42 37 91 25

  USO DE MEMORIA  
8,431,456 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0016
Controller Execution Time ( Home / Category )  0.8794
Total Execution Time  0.8810
  CADENA URL  
/historico/Bromley/2020
  GET DATOS  
$_GET['/historico/Bromley/2020']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (44)  
0.0162  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 = 'Bromley' AND l.year = 2020 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=5536 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=5536 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=5536 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=5536 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=5536 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=5536 AND type_rel = 2
0.0147  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 5536 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0147  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 (41176,705406) ORDER BY n.cover_points DESC, update_date 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 = '5536' AND l.year = 2020 ORDER BY l.year DESC,cat.coefficient DESC
0.0152  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 = '5536' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0148  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 = 50119 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0169  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 = 50606 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0177  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=5536 AND l.year in (2019,2020,2021) ORDER BY l.id DESC, l.year DESC ;
0.0153  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 (62806,58730,58520,58519,49506) 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.0179  SELECT count(id) as num_players from rel_players WHERE league_id = 58730 AND teamId = 5536
0.0195  SELECT count(id) as num_players from rel_players WHERE league_id = 58520 AND teamId = 5536
0.0187  SELECT count(id) as num_players from rel_players WHERE league_id = 58519 AND teamId = 5536
0.0167  SELECT count(id) as num_players from rel_players WHERE league_id = 62806 AND teamId = 5536
0.0185  SELECT count(id) as num_players from rel_players WHERE league_id = 49506 AND teamId = 5536
0.0296  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 50119 AND t.round = 39 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0156  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 = '5536' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0148  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '5536' and rp.type = 4
0.0157  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 = '5536' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0215  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 events2020 e ON e.player_id = p.id AND e.league_id = 50119 WHERE rp.league_id = 50119 AND rp.teamId = 5536 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.0205  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 events2020 e ON e.player_id = p.id AND e.league_id = 50119 WHERE rp.league_id = 50119 AND rp.teamId = 5536 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0195  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 events2020 e ON e.player_id = p.id AND e.league_id = 50119 WHERE rp.league_id = 50119 AND rp.teamId = 5536 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0182  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 = 5536 AND l.year <= 2020 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0170  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 = 50119 AND t.round = 39 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 `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 = 44236 AND t.round = 46 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 = 38702 AND t.round = 46 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 `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 = 33342 AND t.round = 46 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0170  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 = 15152 AND t.round = 46 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 `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.0179  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 = 2512 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0170  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 = 2012 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0165  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 = 1631 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0172  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 = 1284 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 `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 = 12910 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 `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 = 12909 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 = 12908 AND t.round = 42 ORDER BY team.conference 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 `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 = 24383 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 `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 = 24377 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0146  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 = 50119 ORDER BY nameShow LIMIT 100