4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Hayes & Yeading United
TEMPORADA 2023/2024
NON LEAGUE PREMIER GRUPO 2
Equipo PJ GF GC Puntos
1 Chesham United Chesham 42 83 46 90
2 AFC Totton AFC Totton 42 89 45 81
3 Salisbury City Salisbury 42 70 46 79
4 Gosport Borough Gosport 42 75 43 78
5 Bracknell Town FC Bracknell 42 84 71 68
6 Merthyr Town Merthyr Town 42 85 59 67
7 Walton & Hersham Walton 42 78 67 65
8 Hungerford Town Hungerford 42 77 70 64
9 Dorchester Town Dorchester 42 66 77 60
10 Hendon Hendon 42 70 65 58
11 Winchester City Winchester 42 63 67 57
12 Basingstoke Town Basingstoke 42 69 83 53
13 Poole Town Poole Town 42 70 76 52
14 Tiverton Town Tiverton 42 64 74 52
15 Sholing Sholing 42 52 63 49
16 Swindon Supermarine Swindon 42 73 92 49
17 Hanwell Town Hanwell Town 42 64 71 48
18 Plymouth Parkway Plymouth 42 60 68 48
19 Beaconsfield Beaconsfield 42 63 78 48
20 Hayes & Yeading United Hayes 42 59 67 46
21 Harrow Borough Harrow 42 60 97 39
22 Didcot Town Didcot Town 42 45 94 28
TEMPORADA 2022/2023
NON LEAGUE PREMIER GRUPO 2
Equipo PJ GF GC Puntos
1 Weston-super-Mare Weston-super 42 89 32 93
2 Bracknell Town FC Bracknell 42 100 53 90
3 Truro City Truro City 42 88 41 89
4 Poole Town Poole Town 42 86 51 80
5 Chesham United Chesham 42 88 57 79
6 Swindon Supermarine Swindon 42 88 66 77
7 Hayes & Yeading United Hayes 42 80 58 71
8 Metropolitan Police Metropolitan 42 61 59 61
9 Merthyr Town Merthyr Town 42 73 64 60
10 Plymouth Parkway Plymouth 42 63 62 58
11 Beaconsfield Beaconsfield 42 75 73 57
12 Tiverton Town Tiverton 42 62 77 55
13 Dorchester Town Dorchester 42 57 79 54
14 Hanwell Town Hanwell Town 42 55 65 50
15 Salisbury City Salisbury 42 55 71 49
16 Winchester City Winchester 42 56 72 48
17 Gosport Borough Gosport 42 58 78 47
18 Hendon Hendon 42 55 81 38
19 Harrow Borough Harrow 42 44 80 37
20 North Leigh North Leigh 42 50 86 34
21 Yate Town Yate Town 42 50 92 34
22 Hartley Wintney Hartley 42 40 76 32
TEMPORADA 2021/2022
NON LEAGUE PREMIER GRUPO 4
Equipo PJ GF GC Puntos
1 Taunton Town Taunton Town 42 83 42 91
2 Hayes & Yeading United Hayes 42 100 39 86
3 Farnborough Farnborough 42 73 44 85
4 Metropolitan Police Metropolitan 42 72 46 81
5 Weston-super-Mare Weston-super 42 72 42 78
6 Chesham United Chesham 42 80 50 77
7 Yate Town Yate Town 42 66 48 72
8 Truro City Truro City 42 62 54 70
9 Gosport Borough Gosport 42 65 56 66
10 Poole Town Poole Town 42 74 69 64
11 Walton Casuals Walton 42 53 61 58
12 Swindon Supermarine Swindon 42 63 63 57
13 Tiverton Town Tiverton 42 61 63 53
14 Harrow Borough Harrow 42 63 77 52
15 Salisbury City Salisbury 42 49 75 48
16 Hendon Hendon 42 58 70 47
17 Beaconsfield Beaconsfield 42 70 92 46
18 Hartley Wintney Hartley 42 56 75 44
19 Dorchester Town Dorchester 42 41 58 41
20 Kings Langley Kings 42 49 68 37
21 Merthyr Town Merthyr Town 42 47 94 26
22 Wimborne Town Wimborne 42 35 106 19
TEMPORADA 2020/2021
NON LEAGUE PREMIER GRUPO 3
Equipo PJ GF GC Puntos
1 Poole Town Poole Town 7 16 7 19
2 Tiverton Town Tiverton 7 21 4 18
3 Salisbury City Salisbury 7 17 7 17
4 Truro City Truro City 8 17 9 16
5 Metropolitan Police Metropolitan 8 14 11 14
6 Swindon Supermarine Swindon 7 12 10 12
7 Chesham United Chesham 7 6 4 12
8 Taunton Town Taunton Town 6 8 5 11
9 Hendon Hendon 8 12 10 11
10 Hayes & Yeading United Hayes 7 11 8 10
11 Gosport Borough Gosport 7 11 9 8
12 Walton Casuals Walton 6 8 13 7
13 Wimborne Town Wimborne 6 5 12 7
14 Hartley Wintney Hartley 6 5 9 6
15 Weston-super-Mare Weston-super 6 8 10 5
16 Harrow Borough Harrow 7 11 14 5
17 Yate Town Yate Town 8 8 17 5
18 Farnborough Farnborough 8 7 16 4
19 Dorchester Town Dorchester 7 5 17 4
20 Beaconsfield Beaconsfield 7 4 14 2
21 Merthyr Town Merthyr Town 0 0 0 0
TEMPORADA 2019/2020
NON LEAGUE PREMIER GRUPO 3
Equipo PJ GF GC Puntos
1 Truro City Truro City 31 65 30 67
2 Chesham United Chesham 33 70 45 64
3 Hayes & Yeading United Hayes 32 65 42 57
4 Swindon Supermarine Swindon 32 50 41 57
5 Tiverton Town Tiverton 29 69 41 55
6 Taunton Town Taunton Town 31 63 53 53
7 Salisbury City Salisbury 30 57 42 51
8 Gosport Borough Gosport 33 35 32 49
9 Poole Town Poole Town 26 45 28 45
10 Weston-super-Mare Weston-super 28 49 45 42
11 Farnborough Farnborough 30 41 43 42
12 Metropolitan Police Metropolitan 29 43 47 40
13 Hendon Hendon 31 48 51 39
14 Merthyr Town Merthyr Town 31 37 37 38
15 Wimborne Town Wimborne 32 39 47 37
16 Hartley Wintney Hartley 27 38 39 36
17 Harrow Borough Harrow 34 44 62 36
18 Blackfield & Langley Blackfield 30 31 48 32
19 Yate Town Yate Town 31 38 56 29
20 Walton Casuals Walton 32 38 69 26
21 Beaconsfield Beaconsfield 31 28 51 25
22 Dorchester Town Dorchester 31 36 80 18
TEMPORADA 2018/2019
NON LEAGUE DIVISION 1 GRUPO 2
Equipo PJ GF GC Puntos
1 Hayes & Yeading United Hayes 38 129 36 93
2 Cheshunt Cheshunt 38 79 43 76
3 Bracknell Town FC Bracknell 38 102 55 75
4 Marlow FC Marlow FC 38 66 37 73
5 Westfield (Surrey) Westfield 38 77 54 70
6 Tooting and Mitcham Tooting 38 66 52 65
7 Ware Ware 38 90 59 63
8 Hanwell Town Hanwell Town 38 71 65 60
9 Waltham Abbey Waltham 38 63 68 56
10 Northwood Northwood 38 65 71 54
11 Ashford Town Ashford Town 38 61 70 51
12 Bedfont Sports Bedfont 38 75 76 48
13 Chipstead Chipstead 38 54 63 45
14 Chalfont St Peter Chalfont 38 52 60 43
15 Uxbridge Uxbridge 38 50 71 42
16 FC Romania FC Romania 38 46 86 36
17 South Park FC South Park 38 47 92 33
18 Hertford Town Hertford 38 55 85 31
19 Molesey FC Molesey FC 38 36 76 28
20 Egham Town Egham Town 38 29 94 18
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 PREMIER GRUPO 2
Equipo PJ GF GC Puntos
1 Chippenham Town Chippenham 46 94 48 101
2 Leamington Leamington 46 74 32 92
3 Merthyr Town Merthyr Town 46 92 43 89
4 Hitchin Town Hitchin Town 46 79 46 85
5 Slough Town Slough Town 46 84 56 85
6 Banbury United Banbury 46 68 40 82
7 Kettering Town Kettering 46 88 66 75
8 Biggleswade Town Biggleswade 46 86 60 74
9 Frome Town Frome Town 46 80 68 73
10 Weymouth Weymouth 46 79 58 66
11 Chesham United Chesham 46 67 62 64
12 Basingstoke Town Basingstoke 46 65 72 62
13 Kings Lynn Town Kings Lynn. 46 60 69 60
14 Stratford Town Stratford 46 64 66 56
15 St Ives Town Ives Town 46 49 70 56
16 Dunstable Town Dunstable 46 46 65 54
17 Redditch United Redditch 46 54 75 50
18 Dorchester Town Dorchester 46 52 82 48
19 St. Neots Town Neots Town 46 66 102 48
20 Kings Langley Kings 46 57 72 47
21 Cambridge City Cambridge 46 47 73 47
22 Cirencester Town Cirencester 46 55 92 42
23 Hayes & Yeading United Hayes 46 48 81 41
24 Cinderford Town Cinderford 46 50 106 28
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
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
Equipo PJ GF GC Puntos
1 Fleetwood Town Fleetwood 46 102 48 103
2 Wrexham AFC Wrexham AFC 46 85 33 98
3 Mansfield Town Mansfield 46 87 48 89
4 York City York City 46 81 45 83
5 Luton Town Luton Town 46 78 42 81
6 Kidderminster Harriers Kidderminste 46 82 63 76
7 Southport Southport 46 72 69 76
8 Gateshead Gateshead 46 69 62 74
9 Cambridge United Cambridge 46 57 41 71
10 Forest Green Rovers Forest Green 46 66 45 70
11 Grimsby Town Grimsby Town 46 79 60 70
12 Braintree Town Braintree 46 76 80 62
13 Barrow Barrow 46 62 76 60
14 Ebbsfleet United Ebbsfleet 46 69 84 54
15 Alfreton Town Alfreton 46 62 86 54
16 Stockport County Stockport 46 58 74 51
17 Lincoln City Lincoln City 46 56 66 49
18 Tamworth Tamworth 46 47 70 48
19 Newport County Newport 46 53 65 47
20 AFC Telford United Telford 46 45 65 46
21 Darlington FC Darlington 46 47 73 46
22 Hayes & Yeading United Hayes 46 58 90 41
23 Kettering Town Kettering 46 40 100 33
24 Bath City Bath City 46 43 89 31
TEMPORADA 2010/2011
NATIONAL LEAGUE
Equipo PJ GF GC Puntos
1 Crawley Town Crawley Town 46 93 30 105
2 AFC Wimbledon Wimbledon 46 83 47 90
3 Luton Town Luton Town 46 85 37 84
4 Wrexham AFC Wrexham AFC 46 66 49 81
5 Fleetwood Town Fleetwood 46 68 42 78
6 Kidderminster Harriers Kidderminste 46 74 60 77
7 Darlington FC Darlington 46 61 42 71
8 York City York City 46 55 50 71
9 Newport County Newport 46 78 60 69
10 Bath City Bath City 46 64 68 63
11 Grimsby Town Grimsby Town 46 72 62 62
12 Rushden & Diamonds Rushden 46 65 62 62
13 Mansfield Town Mansfield 46 73 75 61
14 Kettering Town Kettering 46 64 75 58
15 Gateshead Gateshead 46 65 68 57
16 Hayes & Yeading United Hayes 46 57 81 51
17 Cambridge United Cambridge 46 53 61 50
18 Barrow Barrow 46 52 67 50
19 Tamworth Tamworth 46 62 83 49
20 Forest Green Rovers Forest Green 46 53 72 46
21 Southport Southport 46 56 77 46
22 Altrincham Altrincham 46 47 87 44
23 Eastbourne Borough Eastbourne 46 62 104 39
24 Histon Histon 46 41 90 33
TEMPORADA 2009/2010
NATIONAL LEAGUE
Equipo PJ GF GC Puntos
1 Stevenage Stevenage 44 79 24 99
2 Luton Town Luton Town 44 84 40 88
3 Oxford United Oxford 44 64 31 86
4 Rushden & Diamonds Rushden 44 77 39 79
5 York City York City 44 62 35 78
6 Salisbury City Salisbury 44 58 63 68
7 Kettering Town Kettering 44 51 41 66
8 Crawley Town Crawley Town 44 49 57 66
9 AFC Wimbledon Wimbledon 44 61 47 64
10 Mansfield Town Mansfield 44 69 60 62
11 Cambridge United Cambridge 44 65 53 59
12 Wrexham AFC Wrexham AFC 44 45 39 58
13 Kidderminster Harriers Kidderminste 44 57 52 57
14 Altrincham Altrincham 44 53 51 54
15 Barrow Barrow 44 50 67 52
16 Tamworth Tamworth 44 42 52 49
17 Hayes & Yeading United Hayes 44 58 85 48
18 Histon Histon 44 44 66 46
19 Gateshead Gateshead 44 46 69 46
20 Eastbourne Borough Eastbourne 44 42 71 46
21 Forest Green Rovers Forest Green 44 50 76 45
22 Ebbsfleet United Ebbsfleet 44 50 82 44
23 Grays Athletic Grays 44 35 91 28
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

  USO DE MEMORIA  
8,527,224 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0015
Controller Execution Time ( Home / Category )  0.1464
Total Execution Time  0.1479
  CADENA URL  
/historico/Hayes-Y-Yeading-United
  GET DATOS  
$_GET['/historico/Hayes-Y-Yeading-United']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (29)  
0.0040  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 = 72853
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=5498 AND type_rel = 2
0.0028  SELECT SQL_NO_CACHE res.id as id, res.group_code, res.total_group, res.logo, res.alias FROM (SELECT ct.active_year, ct.id as id, l.year, l.end,l.group_code, l.total_group, ct.logo, ct.alias FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId AND ct.active_year=l.year INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId = '5498' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0021  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 = 72853 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0026  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=5498 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0022  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 (72853,72728,72677,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.0022  SELECT count(id) as num_players from rel_players WHERE league_id = 72853 AND teamId = 5498
0.0030  SELECT count(id) as num_players from rel_players WHERE league_id = 72728 AND teamId = 5498
0.0025  SELECT count(id) as num_players from rel_players WHERE league_id = 72677 AND teamId = 5498
0.0023  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 5498
0.0040  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 = 72853 AND t.round = 42 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0030  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 = 72853 WHERE rp.league_id = 72853 AND rp.teamId = 5498 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.0028  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 = 72853 WHERE rp.league_id = 72853 AND rp.teamId = 5498 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0025  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 = 72853 WHERE rp.league_id = 72853 AND rp.teamId = 5498 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0029  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 = 5498 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0027  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 = 72853 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.0026  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 68451 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.0026  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 63527 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.0024  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 58615 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.0026  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 50619 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027  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 = 44457 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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.0027  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 = 33745 AND t.round = 46 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027  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.0025  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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.0033  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.0027  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.0028  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.0028  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