4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Crystal Palace Sub 18
TEMPORADA 2023/2024
PREMIER LEAGUE SUB 18 GRUPO 2
Equipo PJ GF GC Puntos
1 Chelsea Sub 18 Chelsea 21 67 33 51
2 West Ham Sub 18 West 22 66 44 46
3 Arsenal Sub 18 Arsenal 22 76 38 44
4 Fulham Sub 18 Fulham 23 61 48 41
5 Tottenham Hotspur Sub 18 Tottenham 22 67 53 39
6 Crystal Palace Sub 18 Crystal 22 56 44 38
7 Brighton & Hove Sub 18 Brighton 22 51 51 31
8 Leicester Sub 18 Leicester 22 39 48 25
9 West Bromwich Albion Sub 18 West 22 40 59 25
10 Southampton Sub 18 Southampton 22 43 53 20
11 Aston Villa Sub 18 Aston Villa 21 44 60 17
12 Norwich City Sub 18 Norwich City 22 37 74 16
13 Reading Sub 18 Reading 21 22 64 11
TEMPORADA 2022/2023
PREMIER LEAGUE SUB 18 GRUPO 2
Equipo PJ GF GC Puntos
1 West Ham Sub 18 West 22 75 32 57
2 Fulham Sub 18 Fulham 22 70 39 40
3 Crystal Palace Sub 18 Crystal 22 60 41 39
4 Chelsea Sub 18 Chelsea 22 54 42 37
5 Tottenham Hotspur Sub 18 Tottenham 22 51 45 36
6 Brighton & Hove Sub 18 Brighton 22 32 48 29
7 West Bromwich Albion Sub 18 West 22 32 42 24
8 Southampton Sub 18 Southampton 22 45 58 24
9 Leicester Sub 18 Leicester 22 34 50 24
10 Aston Villa Sub 18 Aston Villa 22 43 63 24
11 Arsenal Sub 18 Arsenal 22 43 51 23
12 Norwich City Sub 18 Norwich City 22 32 60 16
TEMPORADA 2021/2022
PREMIER LEAGUE SUB 18 GRUPO 2
Equipo PJ GF GC Puntos
1 Southampton Sub 18 Southampton 26 80 34 62
2 West Ham Sub 18 West 26 70 25 58
3 Crystal Palace Sub 18 Crystal 26 61 31 53
4 Arsenal Sub 18 Arsenal 26 58 43 48
5 Leicester Sub 18 Leicester 26 47 31 47
6 Fulham Sub 18 Fulham 26 53 30 46
7 Chelsea Sub 18 Chelsea 26 66 49 46
8 Brighton & Hove Sub 18 Brighton 26 57 58 33
9 Tottenham Hotspur Sub 18 Tottenham 26 52 66 31
10 West Bromwich Albion Sub 18 West 26 42 63 29
11 Reading Sub 18 Reading 26 36 62 24
12 Aston Villa Sub 18 Aston Villa 26 44 69 20
13 Birmingham City Sub 18 Birmingham 26 29 76 14
14 Norwich City Sub 18 Norwich City 26 20 78 10
TEMPORADA 2020/2021
PREMIER LEAGUE SUB 18 GRUPO 2
Equipo PJ GF GC Puntos
1 Fulham Sub 18 Fulham 24 75 23 56
2 Crystal Palace Sub 18 Crystal 24 67 32 56
3 Brighton & Hove Sub 18 Brighton 24 61 37 45
4 Arsenal Sub 18 Arsenal 24 52 45 40
5 Aston Villa Sub 18 Aston Villa 24 45 52 38
6 Tottenham Hotspur Sub 18 Tottenham 24 52 37 37
7 Chelsea Sub 18 Chelsea 24 57 43 36
8 Norwich City Sub 18 Norwich City 24 58 58 29
9 West Bromwich Albion Sub 18 West 24 49 64 28
10 West Ham Sub 18 West 24 35 57 25
11 Reading Sub 18 Reading 24 53 81 20
12 Leicester Sub 18 Leicester 25 40 81 18
13 Southampton Sub 18 Southampton 25 43 77 16
TEMPORADA 2019/2020
PROFESSIONAL DEVELOPMENT LEAGUE SUB 18
Equipo PJ GF GC Puntos
1 Wigan Athletic Sub 18 Wigan 24 65 29 57
2 Sheffield United Sub 18 Sheffield 20 50 27 42
3 Barnsley Sub 18 Barnsley 22 34 30 36
4 Burnley Sub 18 Burnley 23 36 39 34
5 Nottingham Forest Sub 18 Nottingham 23 30 36 29
6 Crewe Alexandra Sub 18 Crewe 23 38 45 25
7 Hull City Sub 18 Hull City 24 38 51 25
8 Sheffield Wednesday Sub 18 Sheffield 21 27 28 23
9 Bolton Wanderers Sub 18 Bolton 22 37 62 22
10 Leeds United Sub 18 Leeds United 22 36 44 21
11 Birmingham City Sub 18 Birmingham 21 30 46 21
12 Millwall Sub 18 Millwall 19 61 26 43
13 Bristol City Sub 18 Bristol City 22 53 41 40
14 Charlton Athletic Sub 18 Charlton 20 42 21 39
15 Watford Sub 18 Watford 20 47 37 37
16 Crystal Palace Sub 18 Crystal 19 45 25 34
17 Ipswich Town Sub 18 Ipswich Town 20 42 39 28
18 Cardiff City Sub 18 Cardiff City 21 43 45 22
19 Coventry City Sub 18 Coventry 21 32 64 17
20 Colchester United Sub 18 Colchester 18 33 55 16
21 Queens Park Rangers Sub 18 Queens Park 21 31 60 15
TEMPORADA 2018/2019
PROFESSIONAL DEVELOPMENT LEAGUE SUB 18
Equipo PJ GF GC Puntos
1 Sheffield Wednesday Sub 18 Sheffield 28 69 22 59
2 Leeds United Sub 18 Leeds United 28 66 37 59
3 Nottingham Forest Sub 18 Nottingham 28 59 33 50
4 Sheffield United Sub 18 Sheffield 28 48 38 50
5 Burnley Sub 18 Burnley 28 64 54 49
6 Barnsley Sub 18 Barnsley 28 47 45 41
7 Birmingham City Sub 18 Birmingham 28 55 57 39
8 Hull City Sub 18 Hull City 28 44 51 29
9 Bolton Wanderers Sub 18 Bolton 28 49 72 26
10 Crewe Alexandra Sub 18 Crewe 28 43 77 26
11 Cardiff City Sub 18 Cardiff City 28 61 31 54
12 Ipswich Town Sub 18 Ipswich Town 28 68 52 53
13 Millwall Sub 18 Millwall 28 62 40 45
14 Queens Park Rangers Sub 18 Queens Park 28 53 51 42
15 Crystal Palace Sub 18 Crystal 28 51 54 38
16 Charlton Athletic Sub 18 Charlton 28 46 46 35
17 Bristol City Sub 18 Bristol City 28 42 50 35
18 Watford Sub 18 Watford 28 50 63 31
19 Coventry City Sub 18 Coventry 28 33 69 24
20 Colchester United Sub 18 Colchester 28 34 102 8
TEMPORADA 2017/2018
PROFESSIONAL DEVELOPMENT LEAGUE SUB 18
Equipo PJ GF GC Puntos
1 Leeds United Sub 18 Leeds United 30 72 39 60
2 Bolton Wanderers Sub 18 Bolton 30 84 53 58
3 Sheffield Wednesday Sub 18 Sheffield 30 81 42 54
4 Nottingham Forest Sub 18 Nottingham 30 75 54 51
5 Burnley Sub 18 Burnley 30 66 60 49
6 Birmingham City Sub 18 Birmingham 30 72 63 46
7 Sheffield United Sub 18 Sheffield 30 42 62 38
8 Hull City Sub 18 Hull City 30 57 78 38
9 Crewe Alexandra Sub 18 Crewe 30 62 58 37
10 Huddersfield Town Sub 18 Huddersfield 30 49 87 32
11 Barnsley Sub 18 Barnsley 30 46 63 31
12 Crystal Palace Sub 18 Crystal 29 63 29 59
13 Charlton Athletic Sub 18 Charlton 29 77 55 55
14 Cardiff City Sub 18 Cardiff City 29 65 48 48
15 Watford Sub 18 Watford 29 65 48 47
16 Millwall Sub 18 Millwall 29 66 57 47
17 Queens Park Rangers Sub 18 Queens Park 29 65 73 41
18 Bristol City Sub 18 Bristol City 29 44 54 31
19 Ipswich Town Sub 18 Ipswich Town 29 42 72 27
20 Colchester United Sub 18 Colchester 29 47 92 22
21 Coventry City Sub 18 Coventry 29 29 82 10
TEMPORADA 2016/2017
PROFESSIONAL DEVELOPMENT LEAGUE SUB 18
Equipo PJ GF GC Puntos
1 Sheffield United Sub 18 Sheffield 28 68 32 63
2 Sheffield Wednesday Sub 18 Sheffield 28 62 46 49
3 Nottingham Forest Sub 18 Nottingham 28 73 53 46
4 Bolton Wanderers Sub 18 Bolton 28 57 48 44
5 Huddersfield Town Sub 18 Huddersfield 28 60 49 42
6 Crewe Alexandra Sub 18 Crewe 28 56 55 40
7 Barnsley Sub 18 Barnsley 28 51 58 37
8 Leeds United Sub 18 Leeds United 28 42 49 32
9 Birmingham City Sub 18 Birmingham 28 40 46 30
10 Hull City Sub 18 Hull City 28 39 62 28
11 Coventry City Sub 18 Coventry 28 76 30 65
12 Charlton Athletic Sub 18 Charlton 28 67 33 61
13 Crystal Palace Sub 18 Crystal 28 59 53 43
14 Ipswich Town Sub 18 Ipswich Town 28 54 49 41
15 Millwall Sub 18 Millwall 28 50 58 35
16 Watford Sub 18 Watford 28 30 40 32
17 Bristol City Sub 18 Bristol City 28 39 55 30
18 Cardiff City Sub 18 Cardiff City 28 41 73 30
19 Colchester United Sub 18 Colchester 28 38 69 23
20 Queens Park Rangers Sub 18 Queens Park 28 39 83 17
TEMPORADA 2015/2016
PROFESSIONAL DEVELOPMENT LEAGUE SUB 18
Equipo PJ GF GC Puntos
1 Nottingham Forest Sub 18 Nottingham 30 78 35 71
2 Sheffield United Sub 18 Sheffield 30 68 39 59
3 Huddersfield Town Sub 18 Huddersfield 29 70 49 56
4 Crewe Alexandra Sub 18 Crewe 30 70 52 56
5 Birmingham City Sub 18 Birmingham 29 66 53 47
6 Sheffield Wednesday Sub 18 Sheffield 29 58 44 45
7 Coventry City Sub 18 Coventry 28 64 72 44
8 Bolton Wanderers Sub 18 Bolton 30 51 54 43
9 Leeds United Sub 18 Leeds United 29 50 52 37
10 Hull City Sub 18 Hull City 30 36 82 25
11 Barnsley Sub 18 Barnsley 30 46 83 15
12 Watford Sub 18 Watford 29 42 23 56
13 Charlton Athletic Sub 18 Charlton 29 64 35 51
14 Crystal Palace Sub 18 Crystal 29 54 43 45
15 Ipswich Town Sub 18 Ipswich Town 29 57 56 39
16 Cardiff City Sub 18 Cardiff City 29 48 52 37
17 Millwall Sub 18 Millwall 29 30 41 37
18 Colchester United Sub 18 Colchester 29 48 53 35
19 Brentford Sub 18 Brentford 29 49 71 26
20 Queens Park Rangers Sub 18 Queens Park 29 41 82 24
21 Bristol City Sub 18 Bristol City 29 38 57 22
TEMPORADA 2014/2015
PROFESSIONAL DEVELOPMENT LEAGUE SUB 18
Equipo PJ GF GC Puntos
1 Huddersfield Town Sub 18 Huddersfield 26 50 31 52
2 Nottingham Forest Sub 18 Nottingham 26 52 25 50
3 Birmingham City Sub 18 Birmingham 26 49 33 41
4 Coventry City Sub 18 Coventry 26 51 38 40
5 Sheffield Wednesday Sub 18 Sheffield 26 37 38 37
6 Leeds United Sub 18 Leeds United 26 39 40 31
7 Crewe Alexandra Sub 18 Crewe 26 40 50 31
8 Barnsley Sub 18 Barnsley 26 26 38 31
9 Sheffield United Sub 18 Sheffield 26 37 59 27
10 Charlton Athletic Sub 18 Charlton 27 61 37 56
11 Brentford Sub 18 Brentford 27 55 36 54
12 Ipswich Town Sub 18 Ipswich Town 27 49 45 45
13 Crystal Palace Sub 18 Crystal 27 54 41 38
14 Swansea City Sub 18 Swansea City 27 54 43 36
15 Cardiff City Sub 18 Cardiff City 27 52 53 36
16 Queens Park Rangers Sub 18 Queens Park 27 45 78 31
17 Bristol City Sub 18 Bristol City 27 36 56 28
18 Millwall Sub 18 Millwall 27 41 54 27
19 Colchester United Sub 18 Colchester 27 37 70 23
TEMPORADA 2013/2014
PROFESSIONAL DEVELOPMENT LEAGUE SUB 18
Equipo PJ GF GC Puntos
1 Huddersfield Town Sub 18 Huddersfield 26 67 36 57
2 Crewe Alexandra Sub 18 Crewe 26 64 51 44
3 Birmingham City Sub 18 Birmingham 26 55 47 41
4 Barnsley Sub 18 Barnsley 26 46 42 41
5 Leeds United Sub 18 Leeds United 26 48 44 36
6 Coventry City Sub 18 Coventry 26 50 54 35
7 Sheffield United Sub 18 Sheffield 26 44 49 33
8 Nottingham Forest Sub 18 Nottingham 26 41 53 33
9 Derby County Sub 18 Derby County 26 44 52 30
10 Sheffield Wednesday Sub 18 Sheffield 26 44 48 27
11 Charlton Athletic Sub 18 Charlton 26 49 31 48
12 Queens Park Rangers Sub 18 Queens Park 26 51 31 47
13 Cardiff City Sub 18 Cardiff City 26 50 42 40
14 Brighton & Hove Sub 18 Brighton 26 42 44 39
15 Crystal Palace Sub 18 Crystal 26 51 55 34
16 Bristol City Sub 18 Bristol City 26 27 45 34
17 Ipswich Town Sub 18 Ipswich Town 26 39 42 29
18 Millwall Sub 18 Millwall 26 42 48 29
19 Brentford Sub 18 Brentford 26 37 55 27
20 Swansea City Sub 18 Swansea City 26 35 57 21

  USO DE MEMORIA  
6,752,064 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.6561
Total Execution Time  0.6572
  CADENA URL  
/historico/Crystal-Palace-Sub18
  GET DATOS  
$_GET['/historico/Crystal-Palace-Sub18']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (35)  
0.0156  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 = 'Crystal-Palace-Sub18' 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=60407 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0148  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=60407 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=60407 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=60407 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0146  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=60407 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0146  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=60407 AND type_rel = 2
0.0164  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 = '60407' ORDER BY l.year DESC,cat.coefficient DESC
0.0167  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 = '60407' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0167  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 = '60407' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0157  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 = 73464 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0165  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=60407 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0157  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 (75672,74630,73464) 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.0163  SELECT count(id) as num_players from rel_players WHERE league_id = 73464 AND teamId = 60407
0.0161  SELECT count(id) as num_players from rel_players WHERE league_id = 75672 AND teamId = 60407
0.0160  SELECT count(id) as num_players from rel_players WHERE league_id = 74630 AND teamId = 60407
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 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 = 73464 AND t.round = 24 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 = '60407' 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 = '60407' and rp.type = 4
0.0147  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 = '60407' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0156  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 = 73464 WHERE rp.league_id = 73464 AND rp.teamId = 60407 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.0154  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 = 73464 WHERE rp.league_id = 73464 AND rp.teamId = 60407 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0153  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 = 73464 WHERE rp.league_id = 73464 AND rp.teamId = 60407 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 = 60407 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 73464 AND t.round = 24 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0159  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 = 68466 AND t.round = 22 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0163  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 = 63653 AND t.round = 26 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0164  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 = 58678 AND t.round = 26 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 `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 = 51560 AND t.round = 25 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 = 49650 AND t.round = 28 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 `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 = 49652 AND t.round = 34 ORDER BY team.conference 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 `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 = 49651 AND t.round = 28 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 `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 = 15610 AND t.round = 31 ORDER BY team.conference 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 `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 = 9248 AND t.round = 28 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 `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 = 49663 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC