4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Deportes Valdivia
TEMPORADA 2023/2024
TERCERA A CHILE
Equipo PJ GF GC Puntos
1 Municipal Salamanca Municipal 3 9 1 9
2 Chimbarongo Chimbarongo 3 5 1 9
3 CDS Constitución Unido Constitució 3 7 4 7
4 Colina Colina 3 6 3 6
5 Deportes Valdivia Deportes 3 6 4 6
6 Colchagua Colchagua 3 4 4 6
7 Municipal Mejillones Municipal 3 2 2 4
8 Deportes Quillón Deportes 3 5 7 4
9 Santiago City Santiago 3 5 5 3
10 Imperial Unido Imperial 3 3 5 3
11 CDSC Iberia CDSC Iberia 3 2 5 1
12 Comunal Cabrero Comunal 3 2 6 1
13 Municipal Puente Alto Municipal 3 2 6 1
14 Unión Compañías Unión 3 3 8 0
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
PRIMERA B CHILE
Equipo PJ GF GC Puntos
1 Ñublense Ñublense 28 51 33 50
2 Unión San Felipe Unión 28 37 25 46
3 Rangers Talca Rangers 28 43 39 45
4 Puerto Montt Puerto Montt 28 36 28 42
5 CD Melipilla Melipilla 28 30 23 42
6 Deportes Temuco Deportes 28 35 34 41
7 San Marcos Arica Marcos Arica 28 27 29 41
8 Magallanes Magallanes 28 31 25 40
9 Deportes Copiapó Deportes 28 48 46 39
10 Cobreloa Cobreloa 28 37 33 36
11 San Luis de Quillota Luis 28 31 35 33
12 Santiago Morning Santiago 28 29 39 31
13 Barnechea Barnechea 28 39 45 30
14 Deportes Valdivia Deportes 28 34 48 28
15 Deportes Santa Cruz Deportes 28 28 54 22
TEMPORADA 2018/2019
PRIMERA B CHILE
Equipo PJ GF GC Puntos
1 Santiago Wanderers Santiago 27 40 26 46
2 La Serena La Serena 27 35 27 43
3 Ñublense Ñublense 27 38 32 42
4 Barnechea Barnechea 27 26 27 40
5 Cobreloa Cobreloa 26 40 33 39
6 CD Melipilla Melipilla 26 33 26 39
7 Unión San Felipe Unión 27 30 30 39
8 Deportes Temuco Deportes 27 31 24 38
9 Deportes Copiapó Deportes 26 28 21 38
10 Puerto Montt Puerto Montt 27 36 29 37
11 Deportes Santa Cruz Deportes 27 32 37 37
12 Santiago Morning Santiago 26 26 32 34
13 Rangers Talca Rangers 27 28 36 28
14 San Luis de Quillota Luis 26 25 37 27
15 Magallanes Magallanes 26 23 33 25
16 Deportes Valdivia Deportes 27 30 51 19
TEMPORADA 2017/2018
PRIMERA B CHILE
Equipo PJ GF GC Puntos
1 Coquimbo Unido Coquimbo 30 47 31 57
2 Cobreloa Cobreloa 30 43 31 52
3 Cobresal Cobresal 30 44 30 51
4 Deportes Valdivia Deportes 30 45 37 47
5 Santiago Wanderers Santiago 30 41 43 46
6 Santiago Morning Santiago 30 34 36 45
7 Unión San Felipe Unión 30 32 28 42
8 Rangers Talca Rangers 30 33 34 40
9 Barnechea Barnechea 30 38 38 39
10 CD Melipilla Melipilla 30 39 41 39
11 Puerto Montt Puerto Montt 30 31 33 35
12 La Serena La Serena 30 37 41 35
13 Magallanes Magallanes 30 37 41 34
14 Deportes Copiapó Deportes 30 36 44 34
15 Ñublense Ñublense 30 27 35 33
16 San Marcos Arica Marcos Arica 30 28 49 32
TEMPORADA 2016/2017
PRIMERA B CHILE
Equipo PJ GF GC Puntos
1 Unión La Calera Unión 15 25 11 34
2 Deportes Copiapó Deportes 15 24 18 26
3 Cobreloa Cobreloa 15 30 28 23
4 Coquimbo Unido Coquimbo 15 18 16 22
5 Barnechea Barnechea 15 26 25 22
6 Magallanes Magallanes 15 18 19 21
7 Puerto Montt Puerto Montt 15 18 20 21
8 Cobresal Cobresal 15 23 20 20
9 Unión San Felipe Unión 15 14 14 20
10 San Marcos Arica Marcos Arica 15 20 21 20
11 La Serena La Serena 15 20 20 19
12 Ñublense Ñublense 15 11 13 18
13 CDSC Iberia CDSC Iberia 15 25 28 18
14 Santiago Morning Santiago 15 17 23 17
15 Deportes Valdivia Deportes 15 11 17 15
16 Rangers Talca Rangers 15 14 21 13
TEMPORADA 2015/2016
SEGUNDA CHILE GRUPO 2
Equipo PJ GF GC Puntos
1 Deportes Valdivia Deportes 10 21 9 25
2 Deportes Santa Cruz Deportes 10 13 7 16
3 San Antonio Unido Antonio 10 11 8 13
4 Deportes Pintana Deportes 10 11 17 12
5 Trasandino Trasandino 10 10 17 7
6 Naval de Talcahuano Naval 10 13 21 7
TEMPORADA 2014/2015
SEGUNDA CHILE GRUPO 4
Equipo PJ GF GC Puntos
1 Puerto Montt Puerto Montt 11 25 15 25
2 San Antonio Unido Antonio 11 21 16 23
3 Malleco Unido Malleco 11 26 16 21
4 Deportes Valdivia Deportes 11 29 17 20
5 CD Melipilla Melipilla 11 20 16 17
6 Ovalle Ovalle 11 19 15 17
7 Naval de Talcahuano Naval 11 14 17 14
8 Trasandino Trasandino 11 12 17 12
9 Deportes Pintana Deportes 11 20 26 11
10 Municipal Mejillones Municipal 11 14 22 8
11 Linares Unido Linares 11 12 22 8
12 Deportes Maipo Quilicura Deportes 11 13 26 8
TEMPORADA 2013/2014
SEGUNDA CHILE
Equipo PJ GF GC Puntos
1 CDSC Iberia CDSC Iberia 22 59 24 48
2 San Antonio Unido Antonio 22 47 27 47
3 Puerto Montt Puerto Montt 22 42 18 46
4 CD Melipilla Melipilla 22 29 19 35
5 Deportes Valdivia Deportes 22 34 28 33
6 Trasandino Trasandino 22 42 39 33
7 Linares Unido Linares 22 35 34 33
8 Audax Italiano II Audax 22 39 32 29
9 Malleco Unido Malleco 22 26 32 28
10 Unión Española II Unión 22 36 54 20
11 Colo Colo II Colo Colo 22 28 63 14
12 Ñublense II Ñublense 22 18 65 8
TEMPORADA 2012/2013
SEGUNDA CHILE
Equipo PJ GF GC Puntos
1 CDSC Iberia CDSC Iberia 22 40 21 48
2 Trasandino Trasandino 22 36 24 43
3 Audax Italiano II Audax 22 51 34 42
4 Deportes Temuco Deportes 22 45 30 42
5 San Antonio Unido Antonio 22 39 27 37
6 Colo Colo II Colo Colo 22 38 31 36
7 Puerto Montt Puerto Montt 22 33 25 30
8 Deportes Valdivia Deportes 22 26 29 26
9 Linares Unido Linares 22 35 39 24
10 Ñublense II Ñublense 22 28 57 17
11 CD Melipilla Melipilla 22 31 55 15
12 Unión Española II Unión 22 24 54 14
TEMPORADA 2011/2012
TERCERA A CHILE GRUPO 2
Equipo PJ GF GC Puntos
1 Provincial Talagante Provincial 6 11 2 15
2 San Antonio Unido Antonio 6 14 5 13
3 Enfoque Enfoque 6 5 11 4
4 Deportes Maipo Quilicura Deportes 6 4 16 3
5 Trasandino Trasandino 6 7 6 11
6 Deportes Valdivia Deportes 6 9 8 9
7 Linares Unido Linares 6 10 9 8
8 Colchagua Colchagua 6 3 6 5

  USO DE MEMORIA  
6,125,376 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1053
Total Execution Time  0.1065
  CADENA URL  
/historico/Deportes-Valdivia
  GET DATOS  
$_GET['/historico/Deportes-Valdivia']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (31)  
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=64848 AND type_rel = 2
0.0020  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 64848 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0022  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 (127418,235342,271169,673850) ORDER BY n.cover_points DESC, update_date DESC
0.0026  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 = '64848' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
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 = '64848' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0017  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '64848' 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 = '64848' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0021  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 = 75528 WHERE rp.league_id = 75528 AND rp.teamId = 64848 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.0021  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 = 75528 WHERE rp.league_id = 75528 AND rp.teamId = 64848 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0020  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 = 75528 WHERE rp.league_id = 75528 AND rp.teamId = 64848 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0025  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 = 64848 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 75528 AND t.round = 6 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 `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.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 `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.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 = 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.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` 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 = 55380 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.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 `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 = 48775 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 `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 = 42541 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0031  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 = 33434 AND t.round = 15 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027  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 = 36662 AND t.round = 15 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027  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 = 38842 AND t.round = 15 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027  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 = 15520 AND t.round = 26 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 = 21320 AND t.round = 10 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 `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 = 15507 AND t.round = 5 ORDER BY team.conference 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 `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 = 15510 AND t.round = 11 ORDER BY team.conference 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 `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 = 15511 AND t.round = 5 ORDER BY team.conference 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 `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 = 15513 AND t.round = 16 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 `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 = 24341 AND t.round = 22 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 `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 = 24344 AND t.round = 22 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 `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 = 24726 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  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 = 24727 AND t.round = 6 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC