4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del General Velásquez
TEMPORADA 2023/2024
SEGUNDA CHILE
Equipo PJ GF GC Puntos
1 CD Melipilla Melipilla 9 21 6 22
2 Puerto Montt Puerto Montt 9 13 5 20
3 CD Provincial Osorno Provincial 9 13 11 16
4 Concepción Concepción 9 14 12 15
5 General Velásquez General 8 14 11 14
6 San Antonio Unido Antonio 9 12 15 14
7 Real San Joaquín Real 8 7 7 12
8 Deportes Rengo Deportes 8 13 11 11
9 Provincial Ovalle Provincial 9 10 12 11
10 Linares Unido Linares 9 9 12 9
11 Lautaro de Buin Lautaro Buin 8 9 12 7
12 Concón National Concón 9 7 15 7
13 Fernández Vial Fernández 9 11 12 6
14 Trasandino Trasandino 9 5 17 5
TEMPORADA 2022/2023
SEGUNDA CHILE
Equipo PJ GF GC Puntos
1 Deportes Limache Deportes 26 45 18 61
2 CD Melipilla Melipilla 26 41 28 47
3 Fernández Vial Fernández 26 26 19 40
4 San Antonio Unido Antonio 26 32 32 40
5 Lautaro de Buin Lautaro Buin 26 34 33 37
6 CD Provincial Osorno Provincial 26 27 28 34
7 Trasandino Trasandino 26 32 35 34
8 Concepción Concepción 26 31 36 31
9 General Velásquez General 26 20 27 29
10 Real San Joaquín Real 26 25 35 29
11 Deportes Rengo Deportes 26 32 35 26
12 Deportes Valdivia Deportes 26 25 36 26
13 Linares Unido Linares 26 27 37 25
14 CDSC Iberia CDSC Iberia 26 37 35 22
TEMPORADA 2021/2022
SEGUNDA CHILE
Equipo PJ GF GC Puntos
1 San Marcos Arica Marcos Arica 22 34 15 43
2 General Velásquez General 22 25 20 36
3 Deportes Valdivia Deportes 22 29 25 35
4 Lautaro de Buin Lautaro Buin 22 29 34 32
5 Real San Joaquín Real 22 28 37 30
6 San Antonio Unido Antonio 22 22 19 29
7 Trasandino Trasandino 22 27 25 29
8 CDSC Iberia CDSC Iberia 22 18 18 28
9 Deportes Limache Deportes 22 26 28 28
10 Concepción Concepción 22 20 25 26
11 Rodelindo Román Rodelindo 22 27 25 24
12 Independiente Cauquenes Independient 22 20 34 21
TEMPORADA 2020/2021
SEGUNDA CHILE
Equipo PJ GF GC Puntos
1 Recoleta Recoleta 22 38 24 48
2 CDSC Iberia CDSC Iberia 22 34 26 40
3 Deportes Limache Deportes 22 36 22 35
4 Independiente Cauquenes Independient 22 38 32 32
5 Lautaro de Buin Lautaro Buin 22 32 30 32
6 General Velásquez General 22 33 33 31
7 San Antonio Unido Antonio 22 34 36 30
8 Deportes Valdivia Deportes 22 29 27 27
9 Rodelindo Román Rodelindo 22 23 34 27
10 Concepción Concepción 22 22 29 23
11 Colina Colina 22 19 31 19
12 Colchagua Colchagua 22 23 37 18
TEMPORADA 2019/2020
SEGUNDA CHILE
Equipo PJ GF GC Puntos
1 Lautaro de Buin Lautaro Buin 22 36 18 47
2 Fernández Vial Fernández 22 37 19 45
3 Recoleta Recoleta 22 44 34 37
4 General Velásquez General 22 29 22 33
5 Colchagua Colchagua 22 23 28 29
6 CDSC Iberia CDSC Iberia 22 27 24 28
7 San Antonio Unido Antonio 22 23 25 28
8 Independiente Cauquenes Independient 22 24 27 28
9 Colina Colina 22 30 39 25
10 Deportes Vallenar Deportes 22 17 30 23
11 Concepción Concepción 22 23 30 21
12 Linares Unido Linares 22 19 36 18
TEMPORADA 2018/2019
SEGUNDA CHILE GRUPO 2
Equipo PJ GF GC Puntos
1 San Marcos Arica Marcos Arica 6 8 4 17
2 Colchagua Colchagua 6 9 5 16
3 Recoleta Recoleta 6 11 12 10
4 Deportes Vallenar Deportes 6 6 7 10
5 General Velásquez General 6 5 7 9
6 CDSC Iberia CDSC Iberia 6 9 13 7
TEMPORADA 2017/2018
TORNEO TRANSICIÓN SEGUNDA CHILE GRUPO 2
Equipo PJ GF GC Puntos
1 Deportes Santa Cruz Deportes 8 8 5 19
2 General Velásquez General 8 11 8 15
3 Independiente Cauquenes Independient 8 14 10 14
4 CDSC Iberia CDSC Iberia 8 12 11 13
5 Colchagua Colchagua 8 6 17 5
TEMPORADA 2016/2017
TERCERA A CHILE
Equipo PJ GF GC Puntos
1 General Velásquez General 28 51 25 60
2 Fernández Vial Fernández 28 53 19 57
3 Deportes Rengo Deportes 28 55 32 57
4 Colina Colina 28 57 35 57
5 Real San Joaquín Real 28 63 44 46
6 Lautaro de Buin Lautaro Buin 28 44 40 45
7 Deportes Limache Deportes 28 46 38 42
8 Tomás Greig Tomás Greig 28 47 42 42
9 Linares Unido Linares 28 45 35 36
10 Municipal Salamanca Municipal 28 51 57 34
11 Estación Central Estación 28 39 43 30
12 Provincial Ovalle Provincial 28 29 50 30
13 Municipal Mejillones Municipal 28 34 59 23
14 Gasparín FC Gasparín 28 29 60 15
15 Chimbarongo Chimbarongo 28 20 84 13
TEMPORADA 2015/2016
TERCERA A CHILE
Equipo PJ GF GC Puntos
1 CD Provincial Osorno Provincial 28 56 30 59
2 Real San Joaquín Real 28 60 34 57
3 Recoleta Recoleta 28 64 47 56
4 Fernández Vial Fernández 28 60 42 50
5 Lautaro de Buin Lautaro Buin 28 56 42 48
6 Estación Central Estación 28 49 40 46
7 Deportes Rengo Deportes 28 55 59 42
8 Deportes Limache Deportes 28 41 47 37
9 Colina Colina 28 34 39 36
10 General Velásquez General 28 47 47 35
11 Chimbarongo Chimbarongo 28 43 48 32
12 Gasparín FC Gasparín 28 38 48 31
13 Tomás Greig Tomás Greig 28 45 54 30
14 Provincial Talagante Provincial 28 49 57 26
15 Juventud Salvador Juventud 28 22 85 6
TEMPORADA 2014/2015
TERCERA A CHILE
Equipo PJ GF GC Puntos
1 Independiente Cauquenes Independient 28 67 33 63
2 Deportes Vallenar Deportes 28 57 30 58
3 Tomás Greig Tomás Greig 28 76 48 57
4 Real San Joaquín Real 28 64 36 54
5 Lautaro de Buin Lautaro Buin 28 52 33 47
6 Deportes Rengo Deportes 28 52 35 46
7 Estación Central Estación 28 50 37 43
8 Gasparín FC Gasparín 28 54 49 43
9 General Velásquez General 28 41 35 42
10 Chimbarongo Chimbarongo 28 45 51 37
11 Juventud Salvador Juventud 28 36 47 28
12 Provincial Talagante Provincial 28 26 46 26
13 Deportes Limache Deportes 28 27 52 22
14 Unión Casablanca Unión 28 29 67 16
15 Provincial Marga Marga Provincial 28 26 103 5
TEMPORADA 2013/2014
TORNEO DE TRANSICIÓN TERCERA A CHILE GRUPO 1
Equipo PJ GF GC Puntos
1 Deportes Maipo Quilicura Deportes 12 24 12 24
2 Municipal Mejillones Municipal 12 26 15 22
3 Provincial Talagante Provincial 12 20 15 20
4 Defensor Casablanca Defensor 12 20 18 20
5 Tomás Greig Tomás Greig 12 23 24 15
6 Pudahuel Barrancas Pudahuel 12 13 29 10
7 Jugendland Jugendland 12 10 23 7
8 Fernández Vial Fernández 12 18 10 26
9 Deportes Pintana Deportes 12 22 15 23
10 Enfoque Enfoque 12 10 8 18
11 Colchagua Colchagua 12 20 20 15
12 Deportes Santa Cruz Deportes 12 17 21 13
13 Independiente Cauquenes Independient 12 17 22 13
14 General Velásquez General 12 13 21 8
TEMPORADA 2012/2013
TERCERA A CHILE GRUPO 1
Equipo PJ GF GC Puntos
1 Deportes Maipo Quilicura Deportes 8 20 7 18
2 Provincial Talagante Provincial 8 11 9 16
3 Enfoque Enfoque 8 11 11 11
4 Pudahuel Barrancas Pudahuel 8 11 13 9
5 Defensor Casablanca Defensor 8 10 23 2
6 Fernández Vial Fernández 6 10 5 13
7 Colchagua Colchagua 6 9 4 12
8 Deportes Santa Cruz Deportes 6 6 8 9
9 General Velásquez General 6 2 10 1
10 Malleco Unido Malleco 0 0 0 0

  USO DE MEMORIA  
5,871,448 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  5.3245
Total Execution Time  5.3257
  CADENA URL  
/historico/General-Velasquez
  GET DATOS  
$_GET['/historico/General-Velasquez']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (38)  
0.2599  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 = 'General-Velasquez' 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=64853 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=64853 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0021  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=64853 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1809 AND type_rel = 3
0.1818  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 1809 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0740  SELECT /*53 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 (1113283,1094524,1027300,964735,913477) ORDER BY n.cover_points DESC, update_date DESC
0.1678  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 = '64853' ORDER BY l.year DESC,cat.coefficient DESC
0.1129  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 = '64853' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.2141  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 = '64853' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0265  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 = 75317 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.1977  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=64853 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0167  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 (75317,71182) 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.2894  SELECT count(id) as num_players from rel_players WHERE league_id = 75317 AND teamId = 64853
0.4960  SELECT count(id) as num_players from rel_players WHERE league_id = 71182 AND teamId = 64853
0.0823  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 = 75317 AND t.round = 9 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0486  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 = '64853' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0151  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '64853' and rp.type = 4
0.0021  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 = '64853' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.5113  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 = 75317 WHERE rp.league_id = 75317 AND rp.teamId = 64853 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.4878  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 = 75317 WHERE rp.league_id = 75317 AND rp.teamId = 64853 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.3565  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 = 75317 WHERE rp.league_id = 75317 AND rp.teamId = 64853 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.1660  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 = 64853 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.1638  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 = 75317 AND t.round = 9 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0529  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 = 71103 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.0406  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 = 67084 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.1672  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 = 62761 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.1457  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 = 55634 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.0212  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 = 49421 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0318  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 = 51224 AND t.round = 10 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0804  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 = 43305 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0470  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 = 45186 AND t.round = 10 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.1037  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 = 30390 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.1211  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 = 15514 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.1862  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 = 38298 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.2055  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 = 24638 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.1143  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 = 24772 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0820  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 = 24722 AND t.round = 10 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC