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

Alzira Sub 19

Entrenador: Guillem Beltran Gonzalvo

Temporada 2023/2024
TEMPORADA 2023/2024
DIVISIÓN DE HONOR GRUPO 7
Equipo PJ GF GC Puntos
1 Levante Sub 19 Levante 28 63 17 70
2 Atlético Madrileño Sub 19 Atlético 28 57 27 58
3 Elche Sub 19 Elche 28 65 26 57
4 Villarreal Sub 19 Villarreal 28 66 35 55
5 Valencia Sub 19 Valencia 28 66 31 47
6 Alboraya Sub 19 Alboraya 28 41 35 47
7 CD Roda Sub 19 Roda 28 47 46 41
8 Real Murcia Sub 19 Real Murcia 28 45 58 40
9 Kelme Sub 19 Kelme 28 29 37 34
10 UCAM Murcia Sub 19 UCAM Murcia 28 37 36 34
11 Albacete Sub 19 Albacete 28 41 50 32
12 Alzira Sub 19 Alzira 28 31 43 30
13 FC Cartagena Sub 19 Cartagena 28 34 47 28
14 Patacona Sub 19 Patacona 28 24 48 22
15 Ranero Sub 19 Ranero 28 23 68 18
16 EFB Miguelturra Sub 19 Miguelturra 28 19 84 10
TEMPORADA 2022/2023
DIVISIÓN DE HONOR GRUPO 7
Equipo PJ GF GC Puntos
1 Valencia Sub 19 Valencia 30 82 22 73
2 Atlético Madrileño Sub 19 Atlético 30 78 24 73
3 Villarreal Sub 19 Villarreal 30 84 22 71
4 Elche Sub 19 Elche 30 51 33 59
5 Levante Sub 19 Levante 30 48 28 55
6 Albacete Sub 19 Albacete 30 42 43 41
7 CD Roda Sub 19 Roda 30 34 45 39
8 Alzira Sub 19 Alzira 30 43 47 37
9 FC Cartagena Sub 19 Cartagena 30 30 50 33
10 Real Murcia Sub 19 Real Murcia 30 26 40 32
11 UCAM Murcia Sub 19 UCAM Murcia 30 32 51 32
12 Alboraya Sub 19 Alboraya 30 32 36 31
13 Castellón Sub 19 Castellón 30 33 61 29
14 Hércules Sub 19 Hércules 30 23 43 25
15 CF Inter San José Sub 19 Inter José 30 27 64 25
16 CD Toledo Sub 19 Toledo 30 22 78 16
TEMPORADA 2021/2022
DIVISIÓN DE HONOR GRUPO 7
Equipo PJ GF GC Puntos
1 Valencia Sub 19 Valencia 36 89 23 91
2 Levante Sub 19 Levante 36 72 25 77
3 Villarreal Sub 19 Villarreal 36 70 32 71
4 CD Roda Sub 19 Roda 36 65 41 66
5 Alboraya Sub 19 Alboraya 36 54 39 59
6 Albacete Sub 19 Albacete 36 52 36 57
7 Atlético Madrileño Sub 19 Atlético 36 53 49 56
8 Alzira Sub 19 Alzira 36 33 34 53
9 Elche Sub 19 Elche 36 39 28 53
10 Real Murcia Sub 19 Real Murcia 36 40 37 50
11 FC Cartagena Sub 19 Cartagena 36 38 52 49
12 CF Inter San José Sub 19 Inter José 36 49 63 46
13 Torre Levante Sub 19 Torre 36 36 42 46
14 UB Conquense Sub 19 Conquense 36 37 49 41
15 La Nucia Sub 19 Nucia 36 40 58 37
16 Kelme Sub 19 Kelme 36 29 54 30
17 Cartagena FC Sub 19 Cartagena 36 30 72 28
18 Talavera de la Reina Sub 19 Talavera 36 36 71 24
19 Unión Archena Sub 19 Unión 36 24 81 17
TEMPORADA 2020/2021
DIVISIÓN DE HONOR GRUPO 27
Equipo PJ GF GC Puntos
1 Levante Sub 19 Levante 23 44 14 57
2 Valencia Sub 19 Valencia 23 44 17 55
3 Villarreal Sub 19 Villarreal 23 52 19 52
4 Atlético Madrileño Sub 19 Atlético 23 45 20 50
5 Elche Sub 19 Elche 23 36 19 41
6 Albacete Sub 19 Albacete 23 42 35 35
7 Unión Archena Sub 19 Unión 23 33 45 33
8 Kelme Sub 19 Kelme 23 26 33 33
9 CD Roda Sub 19 Roda 23 31 30 31
10 Alzira Sub 19 Alzira 23 32 36 28
TEMPORADA 2019/2020
DIVISIÓN DE HONOR GRUPO 7
Equipo PJ GF GC Puntos
1 Villarreal Sub 19 Villarreal 25 67 19 61
2 Levante Sub 19 Levante 25 49 14 59
3 CD Roda Sub 19 Roda 25 46 17 56
4 Valencia Sub 19 Valencia 25 58 20 54
5 Atlético Madrileño Sub 19 Atlético 25 39 27 38
6 Elche Sub 19 Elche 25 41 26 37
7 Albacete Sub 19 Albacete 25 36 37 31
8 Alboraya Sub 19 Alboraya 25 29 42 30
9 Patacona Sub 19 Patacona 25 34 33 29
10 Torre Levante Sub 19 Torre 25 28 44 29
11 UCAM Murcia Sub 19 UCAM Murcia 25 18 30 28
12 Lorca CFB Sub 19 Lorca 25 22 44 27
13 Real Murcia Sub 19 Real Murcia 25 21 46 24
14 CD Toledo Sub 19 Toledo 25 15 46 21
15 Alzira Sub 19 Alzira 25 14 35 20
16 Hércules Sub 19 Hércules 25 17 54 12
TEMPORADA 2018/2019
DIVISIÓN DE HONOR GRUPO 7
Equipo PJ GF GC Puntos
1 Villarreal Sub 19 Villarreal 30 81 23 68
2 Levante Sub 19 Levante 30 60 20 67
3 Valencia Sub 19 Valencia 30 61 28 61
4 Atlético Madrileño Sub 19 Atlético 30 57 36 59
5 CD Roda Sub 19 Roda 30 55 32 56
6 Alzira Sub 19 Alzira 30 32 36 41
7 Alboraya Sub 19 Alboraya 30 37 33 37
8 Albacete Sub 19 Albacete 30 43 51 36
9 Real Murcia Sub 19 Real Murcia 30 41 60 35
10 Torre Levante Sub 19 Torre 30 34 42 35
11 Elche Sub 19 Elche 30 35 44 35
12 Lorca CFB Sub 19 Lorca 30 26 37 34
13 Kelme Sub 19 Kelme 30 21 53 31
14 Ranero Sub 19 Ranero 30 24 45 27
15 Ciudad de Cuenca CF Ciudad 30 36 70 25
16 Ràcing Algemesí CF Sub 19 Ràcing 30 22 55 18
TEMPORADA 2017/2018
LIGA NACIONAL GRUPO 8
Equipo PJ GF GC Puntos
1 Levante Sub 19 B Levante 33 78 29 73
2 Villarreal Sub 19 B Villarreal 34 80 37 68
3 Valencia Sub 19 B Valencia 34 73 35 64
4 Ràcing Algemesí CF Sub 19 Ràcing 34 42 33 60
5 Alzira Sub 19 Alzira 34 53 43 59
6 CF Inter San José Sub 19 Inter José 34 54 33 55
7 C.D. Acero 'A' C.D. Acero 34 56 46 52
8 Elche Sub 19 B Elche 34 52 45 51
9 C.D. Don Bosco A C.D. Bosco 34 55 56 50
10 Denia Sub 19 Denia 34 41 55 41
11 C.D. Alcoyano 'A' C.D. 33 32 42 40
12 Castellón Sub 19 Castellón 34 43 48 38
13 Kelme C.F. 'B' Kelme C.F. 34 37 39 37
14 CF Benidorm Sub 19 Benidorm 34 40 55 36
15 Onda A Onda A 34 33 65 36
16 Huracán Valencia Sub 19 Huracán 34 30 61 33
17 C.F. Celtic Elche 'A' C.F. Celtic 34 39 57 32
18 Club La Vall A Club Vall 34 37 96 18
TEMPORADA 2016/2017
LIGA NACIONAL GRUPO 8
Equipo PJ GF GC Puntos
1 Valencia Sub 19 B Valencia 34 86 24 86
2 Villarreal Sub 19 B Villarreal 34 74 20 76
3 Levante Sub 19 B Levante 34 58 23 76
4 Torre Levante Sub 19 Torre 34 52 21 67
5 Alboraia A Alboraia A 34 65 42 59
6 Denia Sub 19 Denia 34 50 40 53
7 Elche Sub 19 B Elche 34 47 50 50
8 Club La Vall A Club Vall 34 41 60 45
9 Ràcing Algemesí CF Sub 19 Ràcing 34 39 45 42
10 C.D. Alcoyano 'A' C.D. 34 37 46 39
11 Alzira Sub 19 Alzira 34 37 47 39
12 C.F. Celtic Elche 'A' C.F. Celtic 34 39 46 38
13 C.D. Don Bosco A C.D. Bosco 34 51 62 38
14 C.D. Acero 'A' C.D. Acero 34 32 49 34
15 Alginet A Alginet A 34 44 63 32
16 Huracán B Huracán B 34 40 76 29
17 UE L'Alcúdia Sub 19 L'Alcúdia 34 25 53 28
18 Lliria A Lliria A 34 25 75 25
TEMPORADA 2015/2016
LIGA NACIONAL GRUPO 8
Equipo PJ GF GC Puntos
1 Valencia Sub 19 B Valencia 34 73 18 83
2 Elche Sub 19 B Elche 34 60 26 72
3 Kelme Sub 19 Kelme 34 42 17 70
4 Levante Sub 19 B Levante 34 50 22 65
5 Hércules Sub 19 Hércules 34 60 37 60
6 Villarreal Sub 19 B Villarreal 34 49 42 53
7 Alboraia A Alboraia A 34 48 37 50
8 UE L'Alcúdia Sub 19 L'Alcúdia 34 43 38 45
9 C.F. Celtic Elche 'A' C.F. Celtic 34 50 53 42
10 Huracán B Huracán B 34 32 42 41
11 C.D. Acero 'A' C.D. Acero 34 36 54 40
12 Alzira Sub 19 Alzira 34 40 58 35
13 Ràcing Algemesí CF Sub 19 Ràcing 34 41 60 34
14 C.D. Don Bosco A C.D. Bosco 34 42 54 31
15 Fc Jove Español Jove 34 32 51 31
16 E-1 Valencia Valencia 34 38 67 27
17 Tavernes Blanques C.F. 'A' Tavernes 34 35 63 27
18 Torre Levante Sub 19 B Torre 34 33 65 26
TEMPORADA 2014/2015
1ª VALENCIA JUVENIL GRUPO 3
Equipo PJ GF GC Puntos
1 Alzira Sub 19 Alzira 30 90 37 74
2 Alboraya U.D. 'C' Alboraya 30 68 28 62
3 C. Torrent A Torrent 30 70 41 55
4 Torrent CF Sub 19 Torrent 30 58 38 53
5 Cheste Cheste 30 53 52 50
6 C. Valencia A Valencia 30 62 51 45
7 Avant Aldaia A Avant Aldaia 30 48 43 45
8 Huracan V. C Huracan 30 44 35 44
9 Cracks B Cracks B 30 52 62 41
10 C.D. Buñol 'A' C.D. Buñol 30 32 54 41
11 C.D. Serranos 'A' C.D. 30 60 57 37
12 Paterna CF Sub 19 Paterna 30 36 55 31
13 C.D. Utiel 'A' C.D. Utiel 30 38 56 28
14 A. Walter A A. Walter A 30 54 79 27
15 Paterna A Paterna A 30 39 69 25
16 Monte Sion A Monte Sion 30 42 89 17

  USO DE MEMORIA  
6,259,096 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0021
Controller Execution Time ( Home / Category )  0.5688
Total Execution Time  0.5709
  CADENA URL  
/historico/Ud-Alzira-A-Juvenil
  GET DATOS  
$_GET['/historico/Ud-Alzira-A-Juvenil']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (34)  
0.0136  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 = 'Ud-Alzira-A-Juvenil' 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.0125  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=45911 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0128  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=45911 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0134  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=45911 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0130  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=45911 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0281  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 = 73336
0.0149  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 = 73416
0.0124  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=45911 AND type_rel = 2
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=156 AND type_rel = 3
0.0132  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 = '45911' ORDER BY l.year DESC,cat.coefficient DESC
0.0129  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 = '45911' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0130  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 = '45911' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0128  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=45911 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0126  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 (73416,73247) 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.0128  SELECT count(id) as num_players from rel_players WHERE league_id = 73247 AND teamId = 45911
0.0127  SELECT count(id) as num_players from rel_players WHERE league_id = 73416 AND teamId = 45911
0.0126  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 = '45911' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0127  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '45911' and rp.type = 4
0.0127  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 = '45911' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0138  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 = 73247 WHERE rp.league_id = 73247 AND rp.teamId = 45911 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.0145  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 = 73247 WHERE rp.league_id = 73247 AND rp.teamId = 45911 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0139  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 = 73247 WHERE rp.league_id = 73247 AND rp.teamId = 45911 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0132  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 = 45911 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0129  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 = 73247 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  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 = 68519 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.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 `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 = 63686 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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 = 58887 AND t.round = 18 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 = 61978 AND t.round = 5 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 = 50497 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133  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 = 44580 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132  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_base` 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 = 39223 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  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_base` 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 = 34234 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 = 16662 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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_base` 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 = 7073 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC