4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del San Antonio Unido
TEMPORADA 2023/2024
SEGUNDA CHILE
Equipo PJ GF GC Puntos
1 CD Melipilla Melipilla 8 18 5 19
2 Puerto Montt Puerto Montt 8 12 5 17
3 CD Provincial Osorno Provincial 8 13 10 16
4 Concepción Concepción 8 13 9 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 8 10 10 11
10 Lautaro de Buin Lautaro Buin 8 9 12 7
11 Fernández Vial Fernández 9 11 12 6
12 Linares Unido Linares 8 7 12 6
13 Trasandino Trasandino 9 5 16 6
14 Concón National Concón 9 6 15 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 3
Equipo PJ GF GC Puntos
1 Colina Colina 4 7 5 12
2 Fernández Vial Fernández 5 6 4 12
3 San Antonio Unido Antonio 5 6 7 11
4 Independiente Cauquenes Independient 5 6 7 7
5 Lautaro de Buin Lautaro Buin 5 4 6 4
TEMPORADA 2017/2018
TORNEO TRANSICIÓN SEGUNDA CHILE GRUPO 1
Equipo PJ GF GC Puntos
1 Deportes Santa Cruz Deportes 18 30 18 37
2 CDSC Iberia CDSC Iberia 18 24 15 35
3 General Velásquez General 18 25 19 29
4 Independiente Cauquenes Independient 18 32 28 24
5 Colchagua Colchagua 18 27 25 24
6 Deportes Vallenar Deportes 18 24 25 24
7 Fernández Vial Fernández 18 27 24 21
8 San Antonio Unido Antonio 18 17 29 17
9 Malleco Unido Malleco 18 18 27 16
10 Recoleta Recoleta 18 16 30 16
TEMPORADA 2016/2017
TORNEO TRANSICIÓN SEGUNDA CHILE
Equipo PJ GF GC Puntos
1 Deportes Vallenar Deportes 20 26 16 38
2 Naval de Talcahuano Naval 20 24 18 32
3 Deportes Santa Cruz Deportes 20 25 20 31
4 San Antonio Unido Antonio 20 25 23 30
5 Recoleta Recoleta 20 27 23 28
6 Malleco Unido Malleco 20 31 26 27
7 Colchagua Colchagua 20 23 26 27
8 CD Melipilla Melipilla 20 27 26 26
9 Independiente Cauquenes Independient 20 22 24 24
10 Deportes Pintana Deportes 20 17 30 20
11 CD Provincial Osorno Provincial 20 12 27 16
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 2
Equipo PJ GF GC Puntos
1 Puerto Montt Puerto Montt 11 14 8 23
2 San Antonio Unido Antonio 11 15 12 22
3 Deportes Pintana Deportes 11 14 10 21
4 Trasandino Trasandino 11 13 8 17
5 Municipal Mejillones Municipal 11 17 15 16
6 Deportes Valdivia Deportes 11 16 17 15
7 Ovalle Ovalle 11 10 11 15
8 CD Melipilla Melipilla 11 12 11 14
9 Malleco Unido Malleco 11 18 21 11
10 Naval de Talcahuano Naval 11 13 17 10
11 Linares Unido Linares 11 10 14 10
12 Deportes Maipo Quilicura Deportes 11 13 21 7
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

  USO DE MEMORIA  
5,894,672 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.6432
Total Execution Time  0.6452
  CADENA URL  
/historico/San-Antonio-Unido
  GET DATOS  
$_GET['/historico/San-Antonio-Unido']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (39)  
0.0261  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 = 75317
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=64844 AND type_rel = 2
0.0129  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 64844 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0138  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 (57246,118263,245174,662221,776488) ORDER BY n.cover_points DESC, update_date DESC
0.0151  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 = '64844' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0144  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.0158  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=64844 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 (75317,71432,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.0136  SELECT count(id) as num_players from rel_players WHERE league_id = 75317 AND teamId = 64844
0.0142  SELECT count(id) as num_players from rel_players WHERE league_id = 71182 AND teamId = 64844
0.0138  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 64844
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 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.0134  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 = '64844' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0127  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '64844' and rp.type = 4
0.0127  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 = '64844' 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 = 75317 WHERE rp.league_id = 75317 AND rp.teamId = 64844 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.0150  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 = 64844 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0133  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 = 64844 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0129  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 = 64844 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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.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 `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.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 = 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.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 `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.0129  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.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 = 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.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 `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 = 51238 AND t.round = 10 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 `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 = 45187 AND t.round = 10 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0137  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.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 `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 = 34702 AND t.round = 10 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0141  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 = 37459 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0137  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 = 39322 AND t.round = 22 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 = 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.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 `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.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 `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.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 `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.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 `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.0129  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.0129  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.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 `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