4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Colchagua
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
TERCERA A CHILE GRUPO 2
Equipo PJ GF GC Puntos
1 Provincial Ovalle Provincial 14 18 6 30
2 Concón National Concón 14 29 23 25
3 Santiago City Santiago 14 23 15 24
4 Colina Colina 14 14 13 19
5 Unión Compañías Unión 14 19 21 17
6 Colchagua Colchagua 14 13 24 14
7 Provincial Ranco Provincial 14 11 14 13
8 Municipal Puente Alto Municipal 14 16 27 11
TEMPORADA 2021/2022
TERCERA A CHILE GRUPO 1
Equipo PJ GF GC Puntos
1 Provincial Ovalle Provincial 14 43 11 34
2 Colina Colina 14 28 16 29
3 Municipal Santiago Municipal 14 19 16 23
4 Unión Compañías Unión 14 27 20 19
5 Municipal Salamanca Municipal 14 17 19 17
6 Quintero Unido Quintero 14 16 27 12
7 Municipal Mejillones Municipal 14 12 35 11
8 La Pintana Unida Pintana 14 17 35 8
9 Linares Unido Linares 14 21 12 26
10 Deportes Rengo Deportes 14 18 19 22
11 Provincial Ranco Provincial 14 13 12 19
12 CD Provincial Osorno Provincial 14 13 12 18
13 Deportes Quillón Deportes 14 16 21 18
14 Rancagua Sur Rancagua 14 11 14 16
15 Colchagua Colchagua 14 13 12 15
16 Lota Schwager Lota 14 14 17 15
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
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 3
Equipo PJ GF GC Puntos
1 Malleco Unido Malleco 12 21 18 51
2 Ovalle Ovalle 12 17 16 48
3 Lota Schwager Lota 12 18 13 44
4 Municipal Mejillones Municipal 12 14 16 44
5 Colchagua Colchagua 12 24 9 43
6 CD Melipilla Melipilla 12 10 13 43
7 Linares Unido Linares 12 12 31 22
TEMPORADA 2013/2014
TERCERA A CHILE
Equipo PJ GF GC Puntos
1 Colchagua Colchagua 26 58 20 68
2 Deportes Santa Cruz Deportes 26 59 22 59
3 Provincial Marga Marga Provincial 26 51 33 46
4 Tomás Greig Tomás Greig 26 50 37 43
5 Deportes Vallenar Deportes 26 48 38 42
6 Independiente Cauquenes Independient 26 46 30 41
7 Provincial Talagante Provincial 26 48 42 31
8 Deportes Limache Deportes 26 47 51 31
9 Unión Casablanca Unión 26 35 47 31
10 Estación Central Estación 26 37 45 30
11 Deportes Rengo Deportes 26 43 67 28
12 General Velásquez General 26 29 43 27
13 Enfoque Enfoque 26 16 55 14
14 Pudahuel Barrancas Pudahuel 26 32 69 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
TEMPORADA 2011/2012
TERCERA A CHILE GRUPO 1
Equipo PJ GF GC Puntos
1 San Antonio Unido Antonio 12 18 16 19
2 Enfoque Enfoque 12 20 19 19
3 Provincial Talagante Provincial 12 18 17 19
4 Deportes Maipo Quilicura Deportes 12 12 13 19
5 Municipal Mejillones Municipal 12 20 15 17
6 Ovalle Ovalle 12 15 13 17
7 Deportes Pintana Deportes 12 15 25 8
8 Colchagua Colchagua 12 20 8 28
9 Linares Unido Linares 12 16 8 26
10 Trasandino Trasandino 12 21 17 18
11 Deportes Valdivia Deportes 12 12 11 16
12 CCD Arturo Fernández Vial Arturo 12 15 17 14
13 Unión Santa María Unión Santa 12 10 20 8
14 Deportes Rengo Deportes 12 12 25 6

  USO DE MEMORIA  
5,788,968 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.5485
Total Execution Time  0.5497
  CADENA URL  
/historico/Colchagua
  GET DATOS  
$_GET['/historico/Colchagua']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (34)  
0.0135  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 = 'Colchagua' 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.0125  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=66108 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=66108 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=66108 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0135  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 = '66108' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0134  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 = '66108' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0145  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=66108 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0136  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 (75877,75528) 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.0132  SELECT count(id) as num_players from rel_players WHERE league_id = 75528 AND teamId = 66108
0.0130  SELECT count(id) as num_players from rel_players WHERE league_id = 75877 AND teamId = 66108
0.0127  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 = 66108 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.0127  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 = 66108 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0127  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 = 66108 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0138  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 = 66108 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0138  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 = 3 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0142  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 = 67542 AND t.round = 14 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0146  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 = 72961 AND t.round = 14 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0142  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 = 64126 AND t.round = 14 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 = 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.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 `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.0127  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.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 `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.0127  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.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.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 `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.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 `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.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 `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.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 `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 = 21329 AND t.round = 14 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 `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.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 = 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.0127  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 = 24723 AND t.round = 6 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 `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
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 `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