4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Puebla de la Calzada
TEMPORADA 2023/2024
1ª EXTREMADURA AUTO. JUVENIL GRUPO 2
Equipo PJ GF GC Puntos
1 CD Badajoz B Badajoz 27 68 44 57
2 FMD Zafra FMD Zafra 27 67 39 56
3 Cpvo Alburquerque Cpvo 27 59 34 54
4 Puebla de la Calzada Puebla 27 59 27 53
5 UC La Estrella Estrella 27 55 35 50
6 Jerez CF Jerez CF 27 78 60 41
7 AP Santa Isabel Santa Isabel 27 54 52 40
8 Hispanolusa Hispanolusa 27 65 55 39
9 Don Bosco B Don Bosco B 27 57 55 38
10 Flecha Negra B Flecha Negra 27 65 55 33
11 CD Guadiana CD Guadiana 27 45 55 33
12 Gevora Gevora 28 49 64 31
13 Cpvo Gran Maestre Cpvo Gran M. 27 37 57 22
14 AD Llerenense Llerenense 27 24 86 17
15 CPvo. Oliva CPvo. Oliva 27 38 102 15
TEMPORADA 2022/2023
2ª EXTREMADURA JUVENIL GRUPO 3
Equipo PJ GF GC Puntos
1 Puebla de la Calzada Puebla 20 104 22 52
2 Sporting Club Garrovilla Sporting 20 50 26 45
3 Academia Extremadura B Academia 20 64 38 43
4 Escuela Futbol Peña El Vall Escuela 20 45 36 31
5 Atletico Romano Atletico 20 44 48 31
6 EMD Talavera Talavera 20 66 48 29
7 Ciudad de Almendralejo Ciudad 20 55 48 27
8 Universidad Popular Pm Cala Universidad 20 31 53 23
9 Puerta Palmas Puerta 20 35 62 14
10 Merida Football Academy Merida 20 24 95 10
11 Trujillanos Club de Futbol Trujillanos 20 51 93 8
12 Emerita Augusta B Emerita 0 0 0 0
TEMPORADA 2021/2022
1ª EXTREMADURA AUTO. JUVENIL GRUPO 2
Equipo PJ GF GC Puntos
1 Gimnastico Don Benito A Gimnastico 24 66 24 56
2 FMD Zafra FMD Zafra 24 52 35 42
3 Talarrubias A Talarrubias 23 45 39 42
4 UD Fuente de Cantos Sub 19 Fuente 24 48 29 40
5 CP Flecha Negra Sub 19 Flecha Negra 24 68 52 40
6 Gevora A Gevora A 23 57 41 40
7 CD Santa Amalia Sub 19 Santa Amalia 24 34 33 36
8 Alburquerque A Alburquerque 24 39 35 32
9 Uc La Estrella A Estrella 24 40 51 31
10 Polideportivo Guareña A Polideportiv 24 55 54 28
11 Guadiana A Guadiana A 24 38 54 23
12 Campanario A Campanario 24 23 85 13
13 Puebla de la Calzada Puebla 24 34 67 12
TEMPORADA 2020/2021
LIGA NACIONAL GRUPO 56
Equipo PJ GF GC Puntos
1 CD Badajoz B Badajoz 23 47 36 36
2 CD Valdelacalzada Sub 19 Valdelacalza 23 30 28 32
3 Chinato A Sub 19 Chinato 23 34 52 29
4 CD Castuera Sub 19 Castuera 23 44 37 28
5 Cacereño Sub 19 Cacereño 23 34 54 26
6 Emérita Augusta Sub 19 Emérita 23 43 58 24
7 Ciudad de Plasencia Ciudad 23 38 66 19
8 Puebla de la Calzada Puebla 23 18 52 16
9 CD Santa Amalia Sub 19 Santa Amalia 23 27 59 13
10 Imperio de Mérida Imperio 23 17 109 4
TEMPORADA 2019/2020
LIGA NACIONAL GRUPO 11
Equipo PJ GF GC Puntos
1 La Cruz Villanovense Sub 19 Cruz 25 68 21 63
2 CD Diocesano Sub 19 Diocesano 25 80 21 59
3 CP Flecha Negra Sub 19 Flecha Negra 25 40 22 53
4 UP Plasencia Sub 19 Plasencia 25 57 29 45
5 Mérida AD Sub 19 Mérida 25 56 35 43
6 CD Valdelacalzada Sub 19 Valdelacalza 25 56 39 40
7 Academia Extremadura Sub 19 Academia 25 49 39 39
8 CD Castuera Sub 19 Castuera 25 43 28 38
9 Don Bosco Sub 19 Bosco 25 47 41 32
10 Moralo CP Sub 19 Moralo 25 34 36 32
11 Chinato A Sub 19 Chinato 25 34 65 28
12 ED Calamonte Sub 19 Calamonte 25 25 47 25
13 CP Sanvicenteño Sub 19 Sanvicenteñ 25 27 83 20
14 Emérita Augusta Sub 19 Emérita 25 38 71 18
15 CD Santa Amalia Sub 19 Santa Amalia 25 16 39 17
16 Puebla de la Calzada Puebla 25 21 75 10
TEMPORADA 2018/2019
2ª ARAGÓN JUVENIL GRUPO 3
Equipo PJ GF GC Puntos
1 Miralbueno Ctrodep Miralbueno 33 122 40 78
2 Utebo CF Utebo CF 33 138 37 77
3 La Cartuja FC Cartuja 33 114 54 72
4 San José UD Sub 19 José 33 107 29 71
5 Villamayor CD Villamayor 33 123 59 69
6 San Juan AD San Juan AD 33 138 57 64
7 Santa Isabel RSD Santa Isabel 33 118 73 60
8 Puebla de la Calzada Puebla 33 78 65 60
9 Garrapinillos Garrapinillo 32 79 74 47
10 Zuera Zuera 33 68 79 42
11 Huracan CD Huracan CD 33 83 99 42
12 Hernan Cortes Junquera B Hernan 33 60 97 38
13 San Gregorio Arrabal C Gregorio 33 89 85 37
14 Olivar Estadio Miralbueno Olivar 33 84 94 35
15 Los Molinos Los Molinos 16 44 66 19
16 Rey Fernando de Aragón Fernando 33 30 159 9
17 Fleta A Fleta A 33 31 188 7
18 Marianistas B Marianistas 33 27 178 6
TEMPORADA 2017/2018
1ª EXTREMADURA AUTO. JUVENIL GRUPO 1
Equipo PJ GF GC Puntos
1 CD Valdelacalzada Sub 19 Valdelacalza 26 89 35 65
2 Puebla de la Calzada Puebla 26 57 30 52
3 Chinato A Sub 19 Chinato 26 65 31 51
4 Miajadas A Miajadas A 26 68 43 50
5 Montehermoso A Montehermoso 26 45 31 42
6 Talavera A Talavera A 26 61 46 39
7 Cacereño At. Veracruz A Cacereño 26 48 47 37
8 Escuela Futbol Peña El Vall Escuela 26 72 48 36
9 Jaraiz A Jaraiz A 26 52 60 34
10 Gevora A Gevora A 26 42 47 31
11 Polideportivo Arroyo A Polideportiv 26 47 56 27
12 Puente San Francisco Sub 19 Puente 26 35 61 25
13 Montijo Sub 19 Montijo 26 27 64 21
14 Coria B Coria B 26 23 132 3
TEMPORADA 2016/2017
LIGA NACIONAL GRUPO 11
Equipo PJ GF GC Puntos
1 Academia Extremadura Sub 19 Academia 30 91 36 69
2 CP Flecha Negra Sub 19 Flecha Negra 30 71 36 57
3 Mérida AD Sub 19 Mérida 30 57 28 55
4 Cacereño Sub 19 Cacereño 30 65 52 52
5 Ciudad de Plasencia Ciudad 30 63 53 51
6 Extremadura UD Sub 19 Extremadura 30 56 43 50
7 CD Badajoz Sub 19 Badajoz 30 46 36 47
8 Cd Diocesano B Diocesano 30 61 52 45
9 UP Plasencia Sub 19 Plasencia 30 53 50 45
10 Olivenza Sub 19 Olivenza 30 42 40 41
11 CD Coria Sub 19 Coria 30 51 59 40
12 CD Castuera Sub 19 Castuera 30 50 58 38
13 Don Bosco Sub 19 Bosco 30 60 66 35
14 Puebla de la Calzada Puebla 30 28 89 17
15 Polideportivo Arroyo A Polideportiv 30 27 81 13
16 Deportivo Pacense Deportivo 30 26 68 13
TEMPORADA 2015/2016
DIVISIÓN DE HONOR GRUPO 5
Equipo PJ GF GC Puntos
1 Atlético Sub 19 Atlético 30 87 23 70
2 Rayo Vallecano Sub 19 Rayo 30 63 28 69
3 Real Madrid Sub 19 Real Madrid 30 86 23 68
4 Getafe Sub 19 Getafe 30 58 27 60
5 Valladolid Sub 19 Valladolid 30 59 34 52
6 Fútbol Peña Sub 19 Fútbol 30 42 48 43
7 Trival Valderas Sub 19 Trival 30 48 61 43
8 CD Diocesano Sub 19 Diocesano 30 43 49 40
9 RSD Alcalá Sub 19 Alcalá 30 39 43 39
10 Leganés Sub 19 Leganés 30 33 41 35
11 Rayo Majadahonda Sub 19 Rayo 30 38 49 35
12 Alcorcón Sub 19 Alcorcón 30 43 47 34
13 UD Sur Sub 19 30 38 54 32
14 Las Rozas CF Sub 19 Rozas 30 36 61 31
15 Flecha Negra Sub 19 Flecha Negra 30 23 74 13
16 Puebla de la Calzada Puebla 30 16 90 9
TEMPORADA 2014/2015
LIGA NACIONAL GRUPO 11
Equipo PJ GF GC Puntos
1 Puebla de la Calzada Puebla 30 71 25 70
2 Atlético San José Prom Atlético 30 65 32 57
3 La Cruz Villanovense Sub 19 Cruz 30 59 34 56
4 Academia Extremadura Sub 19 Academia 30 75 46 54
5 Cd Diocesano B Diocesano 30 66 50 53
6 Don Bosco Sub 19 Bosco 30 65 30 51
7 Moralo CP Sub 19 Moralo 30 57 40 49
8 Deportivo Pacense Deportivo 30 46 34 45
9 UD Fuente de Cantos Sub 19 Fuente 30 63 58 43
10 CP Flecha Negra Sub 19 Flecha Negra 30 48 46 39
11 Mérida AD Sub 19 Mérida 30 57 53 37
12 Ciudad de Plasencia Ciudad 30 31 50 35
13 Cd Don Benito Benito 30 57 45 34
14 Emérita Augusta Sub 19 Emérita 30 39 66 25
15 EF Peña el Valle Peña Valle 30 31 82 18
16 CF Trujillo CF Trujillo 30 15 154 6
TEMPORADA 2012/2013
LIGA NACIONAL GRUPO 11
Equipo PJ GF GC Puntos
1 Mérida AD Sub 19 Mérida 30 61 29 64
2 Don Bosco Sub 19 Bosco 28 72 29 59
3 UP Plasencia Sub 19 Plasencia 28 55 43 54
4 La Cruz Villanovense Sub 19 Cruz 30 58 43 52
5 Flecha Negra Sub 19 Flecha Negra 28 82 39 51
6 Puebla de la Calzada Puebla 28 68 46 45
7 Emérita Augusta Sub 19 Emérita 29 61 46 44
8 Academia Extremadura Sub 19 Academia 28 79 50 43
9 Cp Cacereño Juvenil Cacereño 28 40 45 42
10 Cd Diocesano B Diocesano 29 61 53 41
11 Cd Don Benito Benito 30 37 50 40
12 Atlético San José Prom Atlético 29 55 60 37
13 Moralo CP Sub 19 Moralo 29 54 58 31
14 Ad Cerro Reyes Atlético Cerro Reyes 20 21 34 18
15 Pmd Navalvillar Navalvillar 29 30 68 17
16 Ch San Roque Roque 29 17 158 5

  USO DE MEMORIA  
5,847,632 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1106
Total Execution Time  0.1118
  CADENA URL  
/historico/Ef-Puebla-Calzada-Juvenil
  GET DATOS  
$_GET['/historico/Ef-Puebla-Calzada-Juvenil']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (34)  
0.0034  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 = 'Ef-Puebla-Calzada-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.0018  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=11137 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=11137 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0042  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 = 74715
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=11137 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=836 AND type_rel = 3
0.0023  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 = '11137' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0021  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 = '11137' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0020  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 = 74715 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0022  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=11137 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0019  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 (74715,70128) 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.0019  SELECT count(id) as num_players from rel_players_base WHERE league_id = 74715 AND teamId = 11137
0.0018  SELECT count(id) as num_players from rel_players_base WHERE league_id = 70128 AND teamId = 11137
0.0019  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 = 74715 AND t.round = 29 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0021  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 = '11137' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '11137' and rp.type = 4
0.0020  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 = '11137' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0026  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 = 11137 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0022  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_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 = 74715 AND t.round = 29 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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_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 = 70128 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.0023  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_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 = 66169 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.0021  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 = 59017 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.0022  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_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 = 61008 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.0022  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 = 61852 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.0023  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_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 = 50791 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.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 `tables2019_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 = 44718 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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_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 = 45666 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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_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 = 45837 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 = 39871 AND t.round = 26 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 `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 = 34237 AND t.round = 30 ORDER BY team.conference 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 `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 = 16642 AND t.round = 30 ORDER BY team.conference 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 `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 = 4214 AND t.round = 30 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 `tables2013_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 = 2130 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0019  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 = 74715 ORDER BY nameShow LIMIT 100