4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del CF Talavera

CF Talavera

Entrenador: Luis Ayllón

Temporada 2023/2024
TEMPORADA 2023/2024
SEGUNDA FEDERACIÓN GRUPO 5
Equipo PJ GF GC Puntos
1 Gimnástica Segoviana Gimnástica 32 44 25 58
2 Numancia Numancia 32 50 34 57
3 UD Sanse UD Sanse 32 56 24 55
4 Getafe B Getafe B 32 37 30 53
5 CD Atlético Paso Atlético 32 24 20 50
6 CF Talavera CF Talavera 32 31 25 46
7 CP Cacereño Cacereño 32 38 37 45
8 Unión Adarve Unión 32 41 42 45
9 Villanovense Villanovense 32 32 31 43
10 CD Illescas CD Illescas 32 34 31 43
11 CD Guadalajara Guadalajara 32 40 49 43
12 CD Ursaria CD Ursaria 32 32 37 41
13 CDA Navalcarnero Navalcarnero 32 31 34 40
14 AD Llerenense Llerenense 32 25 33 38
15 CD Badajoz CD Badajoz 32 31 33 37
16 UD San Fernando Fernando 32 26 38 36
17 CD Mensajero Mensajero 32 26 49 25
18 UD Montijo UD Montijo 32 27 53 23
TEMPORADA 2022/2023
PRIMERA FEDERACIÓN GRUPO 1
Equipo PJ GF GC Puntos
1 Racing Ferrol Racing 38 55 25 75
2 Alcorcón Alcorcón 38 53 23 74
3 RM Castilla RM Castilla 38 58 38 69
4 RC Deportivo Deportivo 38 53 29 67
5 Celta Fortuna Celta 38 48 38 59
6 Linares Deportivo Linares 38 53 53 59
7 Unionistas CF Unionistas 38 38 40 56
8 AD Mérida AD Mérida 38 40 37 54
9 Córdoba CF Córdoba CF 38 48 37 54
10 Cultural Leonesa Cultural 38 41 43 48
11 Fuenlabrada Fuenlabrada 38 32 51 46
12 AD Ceuta FC AD Ceuta FC 38 53 52 45
13 San Fernando CD Fernando 38 46 50 45
14 Rayo Majadahonda Rayo 38 42 51 45
15 Algeciras CF Algeciras 38 36 47 44
16 CD Badajoz CD Badajoz 38 35 52 43
17 UD Sanse UD Sanse 38 30 46 43
18 RB Linense RB Linense 38 31 34 42
19 Pontevedra Pontevedra 38 34 53 36
20 CF Talavera CF Talavera 38 36 63 33
TEMPORADA 2021/2022
PRIMERA FEDERACIÓN GRUPO 1
Equipo PJ GF GC Puntos
1 Racing Racing 38 61 31 82
2 RC Deportivo Deportivo 38 59 29 74
3 Racing Ferrol Racing 38 50 26 72
4 Rayo Majadahonda Rayo 38 50 47 62
5 UD Logroñés Logroñés 38 41 37 62
6 Celta Fortuna Celta 38 60 46 61
7 Unionistas CF Unionistas 38 55 37 61
8 Real Unión Club Real Unión 38 51 45 60
9 CD Badajoz CD Badajoz 38 40 30 56
10 UD Sanse UD Sanse 38 40 41 53
11 CD Calahorra Calahorra 38 48 43 52
12 Cultural Leonesa Cultural 38 61 55 49
13 SD Logroñés Logroñés 38 43 43 48
14 Internacional de Madrid Internaciona 38 46 51 46
15 Bilbao Ath. Bilbao Ath. 38 36 46 45
16 CF Talavera CF Talavera 38 39 54 42
17 Zamora Zamora 38 30 48 37
18 Real Valladolid Promesas Real 38 42 64 36
19 Tudelano Tudelano 38 33 54 28
20 Extremadura Extremadura 38 22 80 0
TEMPORADA 2020/2021
SEGUNDA DIVISIÓN B GRUPO 5
Equipo PJ GF GC Puntos
1 UD Sanse UD Sanse 18 22 14 35
2 RM Castilla RM Castilla 18 30 21 32
3 Internacional de Madrid Internaciona 18 24 16 30
4 Rayo Majadahonda Rayo 18 17 16 28
5 Atlético Baleares Atlético 18 26 21 24
6 CDA Navalcarnero Navalcarnero 18 16 18 20
7 Las Rozas Las Rozas 18 16 25 20
8 Atlético B Atlético B 18 15 20 19
9 Poblense Poblense 18 16 21 16
10 Getafe B Getafe B 18 11 21 13
11 CD Badajoz CD Badajoz 18 32 9 41
12 Extremadura Extremadura 18 24 16 31
13 CF Talavera CF Talavera 18 23 19 27
14 Villanovense Villanovense 18 15 8 27
15 CD Don Benito Benito 18 16 21 24
16 AD Mérida AD Mérida 18 12 12 23
17 UD Melilla UD Melilla 18 15 19 23
18 Villarrubia CF Villarrubia 18 17 24 20
19 UD Yugo Socuéllamos Yugo 18 13 25 16
20 CP Villarrobledo Villarrobled 18 15 29 10
TEMPORADA 2019/2020
SEGUNDA DIVISIÓN B GRUPO 4
Equipo PJ GF GC Puntos
1 FC Cartagena Cartagena 28 33 19 54
2 Marbella FC Marbella FC 28 39 20 53
3 CD Badajoz CD Badajoz 28 37 22 49
4 Yeclano Deportivo Yeclano 28 42 33 47
5 Córdoba CF Córdoba CF 28 33 27 45
6 San Fernando CD Fernando 28 39 25 44
7 RB Linense RB Linense 28 27 26 41
8 Real Murcia Real Murcia 28 33 26 39
9 Sevilla At. Sevilla At. 28 31 33 36
10 UCAM Murcia UCAM Murcia 28 29 33 36
11 Cádiz CF Mirandilla Cádiz 28 23 27 36
12 Villarrubia CF Villarrubia 28 34 33 35
13 Recreativo Recreativo 28 30 31 33
14 CD Don Benito Benito 28 32 35 32
15 At. Sanluqueño Sanluqueño 28 20 28 30
16 Algeciras CF Algeciras 28 31 40 29
17 CF Talavera CF Talavera 28 23 33 29
18 Recreativo Granada Recreativo 28 21 35 29
19 AD Mérida AD Mérida 28 28 37 27
20 CP Villarrobledo Villarrobled 28 23 45 22
TEMPORADA 2018/2019
SEGUNDA DIVISIÓN B GRUPO 4
Equipo PJ GF GC Puntos
1 Recreativo Recreativo 38 50 23 78
2 FC Cartagena Cartagena 38 62 27 75
3 UD Melilla UD Melilla 38 55 32 72
4 CD Badajoz CD Badajoz 38 44 31 66
5 UCAM Murcia UCAM Murcia 38 54 40 66
6 UD Ibiza UD Ibiza 38 41 31 63
7 Marbella FC Marbella FC 38 42 33 60
8 San Fernando CD Fernando 38 44 36 60
9 CF Talavera CF Talavera 38 34 34 50
10 Sevilla At. Sevilla At. 38 37 46 48
11 Real Murcia Real Murcia 38 32 32 48
12 RB Linense RB Linense 38 33 33 46
13 At. Sanluqueño Sanluqueño 38 32 48 46
14 Recreativo Granada Recreativo 38 37 42 45
15 CD Don Benito Benito 38 38 49 44
16 Jumilla Jumilla 38 31 42 43
17 Pvo. El Ejido Pvo. Ejido 38 29 47 39
18 Villanovense Villanovense 38 32 40 38
19 At. Malagueño Malagueño 38 27 54 29
20 Almería B Almería B 38 27 61 23
TEMPORADA 2017/2018
SEGUNDA DIVISIÓN B GRUPO 1
Equipo PJ GF GC Puntos
1 Rayo Majadahonda Rayo 38 60 35 70
2 Deportivo Fabril Deportivo 38 46 28 69
3 Fuenlabrada Fuenlabrada 38 56 31 65
4 Celta Fortuna Celta 38 44 32 63
5 Rápido de Bouzas Rápido 38 39 28 61
6 CDA Navalcarnero Navalcarnero 38 44 40 61
7 CF Talavera CF Talavera 38 40 46 56
8 RM Castilla RM Castilla 38 53 37 55
9 Atlético B Atlético B 38 43 46 51
10 UD Sanse UD Sanse 38 45 46 51
11 Unión Adarve Unión 38 43 46 51
12 Ponferradina Ponferradina 38 53 50 48
13 Guijuelo Guijuelo 38 34 34 45
14 Pontevedra Pontevedra 38 45 46 45
15 Real Valladolid Promesas Real 38 41 48 44
16 Coruxo Coruxo 38 37 57 43
17 CD Toledo CD Toledo 38 45 50 41
18 Racing Ferrol Racing 38 38 53 40
19 Gimnástica Segoviana Gimnástica 38 33 50 39
20 CCD Cerceda CCD Cerceda 38 26 62 25
TEMPORADA 2016/2017
TERCERA DIVISIÓN GRUPO 18
Equipo PJ GF GC Puntos
1 CF Talavera CF Talavera 38 89 37 83
2 UB Conquense Conquense 38 74 43 75
3 CP Villarrobledo Villarrobled 38 75 42 70
4 CD Guadalajara Guadalajara 38 64 43 70
5 Villarrubia CF Villarrubia 38 61 38 67
6 UD Almansa UD Almansa 38 68 54 63
7 CD Manchego Ciudad Real Manchego 38 53 40 62
8 CD Quintanar del Rey Quintanar 38 61 52 52
9 CD Azuqueca CD Azuqueca 38 67 57 52
10 CD Madridejos Madridejos 38 43 53 51
11 CD Marchamalo Marchamalo 38 43 49 50
12 Almagro CF Almagro CF 38 44 52 49
13 Atlético Tomelloso Atlético 38 46 53 48
14 Mora CF Mora CF 38 46 66 46
15 Atlético Albacete Atlético 38 49 56 45
16 CD Pedroñeras Pedroñeras 38 46 45 45
17 CD Toledo B CD Toledo B 38 47 61 44
18 CD Illescas CD Illescas 38 56 82 39
19 UD Carrión UD Carrión 38 37 90 26
20 CD Yuncos CD Yuncos 38 24 80 16
TEMPORADA 2015/2016
SEGUNDA DIVISIÓN B GRUPO 2
Equipo PJ GF GC Puntos
1 RM Castilla RM Castilla 38 72 40 80
2 Barakaldo Barakaldo 38 52 24 80
3 UD Yugo Socuéllamos Yugo 38 51 43 64
4 CD Toledo CD Toledo 38 49 33 63
5 Real Unión Club Real Unión 38 59 37 60
6 Sestao River Sestao River 38 38 29 60
7 Real Sociedad B Real 38 58 44 60
8 Arenas de Getxo Arenas Getxo 38 50 43 57
9 SD Amorebieta Amorebieta 38 50 43 56
10 CD Ebro CD Ebro 38 43 37 53
11 Fuenlabrada Fuenlabrada 38 40 40 49
12 SD Gernika SD Gernika 38 41 49 45
13 CD Mensajero Mensajero 38 37 47 44
14 Rayo Majadahonda Rayo 38 42 50 43
15 La Roda CF La Roda CF 38 40 52 43
16 Leioa Leioa 38 37 59 41
17 CD Guadalajara Guadalajara 38 40 56 40
18 CF Talavera CF Talavera 38 42 59 37
19 Portugalete Portugalete 38 29 48 32
20 Getafe B Getafe B 38 43 80 32
TEMPORADA 2014/2015
TERCERA DIVISIÓN GRUPO 18
Equipo PJ GF GC Puntos
1 CF Talavera CF Talavera 38 85 27 84
2 UD Almansa UD Almansa 38 62 32 79
3 CD Quintanar del Rey Quintanar 38 48 19 75
4 Manzanares CF Manzanares 38 59 24 73
5 CD Madridejos Madridejos 38 43 21 72
6 Villarrubia CF Villarrubia 38 50 35 65
7 CD Marchamalo Marchamalo 38 55 51 59
8 Mora CF Mora CF 38 51 39 57
9 CP Villarrobledo Villarrobled 38 58 49 54
10 Puertollano Puertollano 38 54 46 53
11 CD Pedroñeras Pedroñeras 38 45 37 51
12 CD Toledo B CD Toledo B 38 47 55 50
13 Atlético Ibañés Atlético 38 42 40 48
14 Atlético Albacete Atlético 38 59 56 47
15 CD Manchego Ciudad Real Manchego 38 47 57 46
16 Almagro CF Almagro CF 38 43 44 44
17 La Gineta La Gineta 38 39 53 43
18 Daimiel Daimiel 38 39 67 40
19 Gimnástico de Alcázar Gimnástico 38 21 117 11
20 Hellin Deportivo Hellin 38 3 81 2
TEMPORADA 2013/2014
TERCERA DIVISIÓN GRUPO 18
Equipo PJ GF GC Puntos
1 Puertollano Puertollano 38 88 18 98
2 UD Yugo Socuéllamos Yugo 38 72 26 83
3 CP Villarrobledo Villarrobled 38 80 32 76
4 UD Almansa UD Almansa 38 53 36 72
5 CF Talavera CF Talavera 38 72 34 72
6 Villarrubia CF Villarrubia 38 48 56 58
7 CD Pedroñeras Pedroñeras 38 42 50 54
8 La Gineta La Gineta 38 51 55 48
9 Atlético Ibañés Atlético 38 44 50 47
10 Quintanar del Rey Quintanar 38 44 56 47
11 Manzanares CF Manzanares 38 41 46 45
12 Atlético Albacete Atlético 38 45 58 43
13 CD Manchego Ciudad Real Manchego 38 43 54 43
14 Hellin Deportivo Hellin 38 35 40 43
15 Gimnástico de Alcázar Gimnástico 38 46 56 41
16 Mora CF Mora CF 38 37 63 40
17 CD Madridejos Madridejos 38 30 41 38
18 CD Illescas CD Illescas 38 39 59 36
19 CD Azuqueca CD Azuqueca 38 36 53 36
20 EF Zona 5 EF Zona 5 38 34 97 15
TEMPORADA 2012/2013
TERCERA DIVISIÓN GRUPO 18
Equipo PJ GF GC Puntos
1 CD Toledo CD Toledo 38 74 33 83
2 UB Conquense Conquense 38 58 29 71
3 CD Azuqueca CD Azuqueca 38 58 45 69
4 CF Talavera CF Talavera 38 52 31 67
5 Hellín Deportivo Hellín 38 45 24 65
6 CP Villarrobledo Villarrobled 38 63 43 62
7 Gimnástico de Alcázar Gimnástico 38 42 40 60
8 Puertollano Puertollano 38 44 31 53
9 CD Quintanar del Rey Quintanar 38 54 54 50
10 Atlético Albacete Atlético 38 45 44 49
11 CD Illescas CD Illescas 38 49 51 48
12 UD Almansa UD Almansa 38 43 54 48
13 Manzanares CF Manzanares 38 36 40 48
14 Villarrubia CF Villarrubia 38 39 54 43
15 CD Madridejos Madridejos 38 40 51 41
16 Mora CF Mora CF 38 45 54 39
17 CD Manchego Ciudad Real Manchego 38 37 60 35
18 CD Marchamalo Marchamalo 38 45 59 35
19 CD Torrijos CD Torrijos 38 29 64 33
20 UD Talavera UD Talavera 38 39 76 32
TEMPORADA 2011/2012
PREFERENTE C. LA MANCHA GRUPO 2
Equipo PJ GF GC Puntos
1 Mora CF Mora CF 34 82 15 94
2 CF Talavera CF Talavera 34 99 26 87
3 Guadalajara B Guadalajara 34 58 30 66
4 CD Noblejas CD Noblejas 34 66 39 66
5 San Jose Obrero Jose Obrero 33 73 39 62
6 CD Yuncos CD Yuncos 34 47 31 58
7 Cd Villacañas Villacañas 34 48 37 58
8 Torpedo 66 Torpedo 66 34 58 36 51
9 Ad Seseña Ad Seseña 34 58 56 46
10 Cd Sigüenza Sigüenza 34 51 58 44
11 ACDM Horche ACDM Horche 33 51 66 42
12 Illescas B Illescas B 34 40 47 37
13 Dinamo Guadalajara Dinamo 34 41 76 35
14 Cd Sagreño Cd Sagreño 34 31 52 31
15 CD Azuqueca B Azuqueca 34 40 77 27
16 Cd Chozas De Canales Chozas 34 33 79 27
17 At. Consuegra Consuegra 34 18 68 18
18 Fuensalida Fuensalida 34 25 87 13

  USO DE MEMORIA  
7,594,648 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0011
Controller Execution Time ( Home / Category )  0.1239
Total Execution Time  0.1251
  CADENA URL  
/historico/Cf-Talavera-Reina
  GET DATOS  
$_GET['/historico/Cf-Talavera-Reina']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (31)  
0.0041  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 = 73445
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=6159 AND type_rel = 2
0.0021  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 6159 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0023  SELECT /*35 bs_news_model*/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (2599,2827,3254,38546,59186) ORDER BY n.cover_points DESC, update_date DESC
0.0025  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 = '6159' 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 = 73445 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
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 = 72366 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0024  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=6159 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 (74091,73445,72366,71759,71432,67959) 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.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 67959 AND teamId = 6159
0.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 72366 AND teamId = 6159
0.0024  SELECT count(id) as num_players from rel_players WHERE league_id = 71759 AND teamId = 6159
0.0029  SELECT count(id) as num_players from rel_players WHERE league_id = 74091 AND teamId = 6159
0.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 73445 AND teamId = 6159
0.0022  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 6159
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 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 = 72366 AND t.round = 33 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0032  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 = 72366 WHERE rp.league_id = 72366 AND rp.teamId = 6159 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.0029  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 = 72366 WHERE rp.league_id = 72366 AND rp.teamId = 6159 AND (e.action = 4 or e.action = 5) 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 = 72366 WHERE rp.league_id = 72366 AND rp.teamId = 6159 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
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 = 6159 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 72366 AND t.round = 33 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 = 67959 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.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 = 58612 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.0029  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 = 50268 AND t.round = 28 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 `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 = 38806 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 `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 = 33368 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0029  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 = 15376 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 `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 = 3927 AND t.round = 38 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 `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 = 2566 AND t.round = 38 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 `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 = 1951 AND t.round = 38 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 `tables2012` 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 = 1480 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC