4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Emérita Augusta
TEMPORADA 2023/2024
2ª REGIONAL EXTREMADURA GRUPO 5
Equipo PJ GF GC Puntos
1 UD Bienvenida Bienvenida 20 65 18 45
2 Club Promesas Belenense Club 20 33 11 39
3 Atlético Torremejía Atlético 20 53 22 38
4 CD Berlanga CD Berlanga 20 25 15 37
5 Hernando De Soto Hernando 20 35 22 34
6 Monesterio Monesterio 20 37 31 34
7 EMD Aceuchal B Aceuchal 20 30 28 26
8 Emérita Augusta Emérita 20 27 25 21
9 Athletic Fregenal Athletic 20 18 30 19
10 UD Fornacense Fornacense 20 35 35 16
11 Oliva 2023 Oliva 2023 20 9 130 3
TEMPORADA 2022/2023
2ª REGIONAL EXTREMADURA GRUPO 3
Equipo PJ GF GC Puntos
1 Emérita Augusta Emérita 20 57 26 42
2 Atlético Torremejía Atlético 20 52 28 42
3 Barbaño Barbaño 20 55 29 35
4 Trujillanos Club de Futbol Trujillanos 20 44 31 35
5 Metelinense Metelinense 19 38 26 32
6 Don Álvaro B Álvaro 19 39 30 30
7 CD Zarceño CD Zarceño 20 39 39 27
8 CD Almoharín Almoharín 20 44 43 26
9 Talleres Anglo Talleres 18 27 33 23
10 Madroñera Olimpia Madroñera 20 17 77 10
11 Alange CD Alange CD 20 21 71 7
12 AD Santa Quiteria Santa 0 0 0 0
TEMPORADA 2021/2022
2ª REGIONAL EXTREMADURA GRUPO 3
Equipo PJ GF GC Puntos
1 Valdehornillo Valdehornill 22 64 17 54
2 Atletico Vivero FC Atletico 22 61 24 52
3 Racing Merida City Racing 22 59 29 46
4 Emérita Augusta Emérita 22 59 31 38
5 CD Zarceño CD Zarceño 22 50 35 34
6 Talleres Anglo Talleres 22 30 36 32
7 Ad Entrerríos Entrerríos 22 43 45 30
8 Trujillanos Club de Futbol Trujillanos 22 39 41 28
9 CD La Haba CD La Haba 22 26 44 23
10 CD Almoharín Almoharín 22 23 63 12
11 EF Vegas Altas Vegas Altas 22 16 67 8
12 CF Pizarro CF Pizarro 22 27 65 7
TEMPORADA 2020/2021
2ª REGIONAL EXTREMADURA GRUPO 4
Equipo PJ GF GC Puntos
1 EMD Solana EMD Solana 22 60 31 49
2 Barbaño Barbaño 22 62 26 47
3 Sport Club La Garrovilla Sport Club. 20 57 24 43
4 Peña el Valle Peña Valle 22 39 40 37
5 Emérita Augusta Emérita 22 46 33 35
6 Obandina AD Obandina AD 21 46 25 34
7 Atletico Vivero FC Atletico 21 47 32 34
8 Puebla de La Calzada B Puebla 22 40 36 28
9 La Roca A La Roca A 21 27 58 19
10 Calamonte UD B Calamonte 20 19 56 16
11 Trujillanos Club de Futbol Trujillanos 22 28 68 13
12 CF Pizarro CF Pizarro 21 23 65 11
TEMPORADA 2019/2020
2ª REGIONAL EXTREMADURA GRUPO 3
Equipo PJ GF GC Puntos
1 EF Puebla de la Calzada Puebla 20 49 18 42
2 UD La Cruz Villanovense Cruz 20 53 25 40
3 Barbaño Barbaño 20 50 20 39
4 Emérita Augusta Emérita 20 32 20 39
5 Sport Club La Garrovilla Sport Club. 20 29 19 39
6 Peña el Valle Peña Valle 20 44 21 37
7 Trujillanos Club de Futbol Trujillanos 20 29 29 33
8 Obandina AD Obandina AD 20 30 31 26
9 Valdehornillo Valdehornill 20 31 50 25
10 Metelinense Metelinense 20 29 37 20
11 Ad Entrerríos Entrerríos 20 19 34 19
12 Santa Quiteria A Santa 20 18 43 18
13 La Roca A La Roca A 20 19 41 14
14 Calamonte UD B Calamonte 20 16 60 4
TEMPORADA 2018/2019
1ª REGIONAL EXTREMADURA GRUPO 3
Equipo PJ GF GC Puntos
1 UD Fuente de Cantos Fuente 30 69 32 70
2 Campanario Campanario 30 63 30 64
3 CD Zafra CD Zafra 30 63 28 63
4 UC La Estrella Estrella 30 66 38 61
5 Villafranca Villafranca 30 64 31 60
6 Guareña Guareña 30 46 50 46
7 CD Don Álvaro Álvaro 30 67 55 44
8 CD Berlanga CD Berlanga 30 54 59 36
9 CP Gran Maestre Gran Maestre 30 51 45 35
10 Gimnástico Don Benito Gimnástico 30 43 58 35
11 Ilipense-Zalamea S. Ilipense-Zal 30 38 59 34
12 Atlético Torremejía Atlético 30 50 73 32
13 UD Frexnense Frexnense 30 23 46 28
14 UD Fornacense Fornacense 30 35 63 28
15 Sp Ribereña Ribereña 30 34 69 25
16 Emérita Augusta Emérita 30 28 58 22
TEMPORADA 2017/2018
1ª REGIONAL EXTREMADURA GRUPO 1
Equipo PJ GF GC Puntos
1 Montehermoso Montehermoso 30 58 12 71
2 Miajadas Miajadas 30 61 23 65
3 Chinato Chinato 30 47 26 54
4 Hernán Cortés Hernán 30 42 26 51
5 Moraleja Moraleja 30 41 36 49
6 Talayuela Talayuela 30 59 53 42
7 CD Don Álvaro Álvaro 30 52 53 40
8 Las Hurdes CF Hurdes 30 47 46 38
9 Olympic Peleño Olympic 30 54 56 38
10 Ciudad De Plasencia Ciudad 30 36 45 38
11 Malpartida Malpartida 30 46 51 35
12 AD San Jorge Jorge 30 51 57 35
13 Piornal Piornal 30 37 55 33
14 Torviscal Torviscal 30 42 60 31
15 Emérita Augusta Emérita 30 44 60 26
16 Plus Ultra A Plus Ultra 30 33 91 16
TEMPORADA 2016/2017
1ª REGIONAL EXTREMADURA GRUPO 3
Equipo PJ GF GC Puntos
1 Castuera Castuera 30 50 10 69
2 CD San Serván Serván 30 48 27 57
3 Emérita Augusta Emérita 30 62 32 56
4 CD Don Álvaro Álvaro 30 53 45 50
5 CD Quintana CD Quintana 30 46 44 47
6 Usagre Usagre 30 45 39 46
7 Almendralejo A Almendralejo 30 49 46 46
8 Villafranca Villafranca 29 44 35 45
9 Campanario Campanario 30 46 43 43
10 CD Berlanga CD Berlanga 30 57 63 40
11 Guareña Guareña 30 41 48 32
12 AD Llerenense Llerenense 30 43 55 31
13 Sp Ribereña Ribereña 30 40 55 29
14 Ilipense-Zalamea S. Ilipense-Zal 30 31 50 28
15 UD Fornacense Fornacense 29 46 57 27
16 CD Talarrubias Talarrubias 30 27 79 23
TEMPORADA 2015/2016
PREFERENTE EXTREMADURA GRUPO 2
Equipo PJ GF GC Puntos
1 UD Montijo UD Montijo 30 60 27 66
2 Guadiana Guadiana 30 64 28 64
3 Racing Valverdeño Racing 30 64 30 60
4 Emérita Augusta Emérita 30 68 31 54
5 UD Talavera UD Talavera 30 51 38 50
6 CP Cheles CP Cheles 30 36 31 50
7 EMD Aceuchal Aceuchal 30 47 36 49
8 Guareña Guareña 30 44 38 44
9 CD Badajoz B Badajoz 30 50 59 39
10 EF Puebla de la Calzada Puebla 30 31 37 36
11 CD Gévora CD Gévora 30 39 40 36
12 CD Don Álvaro Álvaro 30 48 49 33
13 CP Oliva CP Oliva 30 36 52 32
14 CF San Jorge Jorge 30 34 73 25
15 Cd Belenense Belenense 30 20 60 18
16 Monesterio Monesterio 30 29 92 14
TEMPORADA 2014/2015
PREFERENTE EXTREMADURA GRUPO 2
Equipo PJ GF GC Puntos
1 EMD Aceuchal Aceuchal 30 63 17 70
2 Emérita Augusta Emérita 30 62 35 59
3 Valdelacalzada Valdelacalza 29 39 15 58
4 Racing Valverdeño Racing 30 55 30 56
5 CD San Serván Serván 30 54 31 56
6 Guadiana Guadiana 29 56 28 55
7 UD Montijo UD Montijo 30 51 40 42
8 CF San Jorge Jorge 30 42 49 42
9 CP Oliva CP Oliva 30 31 19 41
10 CD Gévora CD Gévora 30 36 40 41
11 CP Cheles CP Cheles 30 34 44 39
12 Alburquerque Alburquerque 30 22 47 35
13 EF Puebla de la Calzada Puebla 30 22 36 27
14 UD Talavera UD Talavera 30 27 48 26
15 AD Santa Quiteria Santa 30 20 48 21
16 EMD Solana EMD Solana 30 24 111 7
TEMPORADA 2013/2014
PREFERENTE EXTREMADURA GRUPO 2
Equipo PJ GF GC Puntos
1 CD Badajoz CD Badajoz 30 76 16 73
2 Calamonte Calamonte 30 76 26 67
3 CP Oliva CP Oliva 30 44 24 56
4 Emérita Augusta Emérita 30 51 28 56
5 SP Cerro Reyes Cerro Reyes 30 47 23 50
6 CD San Serván Serván 30 45 39 46
7 Valdelacalzada Valdelacalza 30 32 33 44
8 CD Vadesa CD Vadesa 30 39 46 38
9 Guadiana Guadiana 30 47 49 37
10 EF Puebla de la Calzada Puebla 30 41 43 37
11 Nueva Ciudad Nueva Ciudad 30 31 44 37
12 UD Talavera UD Talavera 30 39 46 36
13 EMD Solana EMD Solana 30 31 49 29
14 UD Frexnense Frexnense 30 33 59 27
15 CP Cheles CP Cheles 30 26 67 23
16 San Francisco de Olivenza Francisco 30 25 91 5
TEMPORADA 2010/2011
PREFERENTE EXTREMADURA GRUPO 2
Equipo PJ GF GC Puntos
1 Pueblonuevo Pueblonuevo 38 74 26 86
2 Villafranca Villafranca 38 77 39 79
3 EF Puebla de la Calzada Puebla 38 58 29 71
4 CP Oliva CP Oliva 38 63 37 69
5 Fuente de Cantos Fuente 38 68 52 67
6 Montijo Montijo 38 53 47 59
7 Racing Valverdeño Racing 38 73 60 57
8 Calamonte Calamonte 38 47 50 53
9 UC La Estrella Estrella 38 51 51 51
10 Emérita Augusta Emérita 38 55 57 50
11 Nueva Ciudad Nueva Ciudad 38 52 58 49
12 Monesterio Monesterio 38 55 54 47
13 Cd Burguillos Burguillos 38 58 69 47
14 CD Azuaga CD Azuaga 38 67 63 46
15 UD Talavera UD Talavera 38 39 52 46
16 La Albuera-Faesal Albuera-Faes 38 47 59 44
17 Guadiana Guadiana 38 48 65 41
18 Gran Maestre Gran Maestre 38 53 76 36
19 San Francisco de Olivenza Francisco 38 43 82 28
20 CF San Jorge Jorge 38 41 96 24

  USO DE MEMORIA  
6,084,184 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0016
Controller Execution Time ( Home / Category )  0.5520
Total Execution Time  0.5536
  CADENA URL  
/historico/Emerita-Augusta
  GET DATOS  
$_GET['/historico/Emerita-Augusta']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (33)  
0.0140  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 = 'Emerita-Augusta' 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.0126  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=5178 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0129  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=5178 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0262  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 = 73799
0.0128  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=5178 AND type_rel = 2
0.0137  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 = '5178' ORDER BY l.year DESC,cat.coefficient DESC
0.0140  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 = '5178' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0142  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 = '5178' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0138  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 = 73799 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0143  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=5178 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0131  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 (73799) 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.0137  SELECT count(id) as num_players from rel_players WHERE league_id = 73799 AND teamId = 5178
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 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 = 73799 AND t.round = 22 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0127  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 = '5178' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0125  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '5178' and rp.type = 4
0.0128  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 = '5178' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0137  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 = 73799 WHERE rp.league_id = 73799 AND rp.teamId = 5178 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.0135  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 = 73799 WHERE rp.league_id = 73799 AND rp.teamId = 5178 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0134  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 = 73799 WHERE rp.league_id = 73799 AND rp.teamId = 5178 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 = 5178 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 73799 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.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 = 69356 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.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 `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 = 63835 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.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 `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 = 59818 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.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 `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 = 51343 AND t.round = 20 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 `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 = 44630 AND t.round = 30 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 `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 = 39344 AND t.round = 30 ORDER BY team.conference 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 `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 = 34429 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0135  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 = 16717 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0136  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 = 4100 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0136  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 = 2691 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0134  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 = 1223 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0137  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 = 73799 ORDER BY nameShow LIMIT 100