4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2023/2024
Equipo PJ GF GC Puntos
1 La Serena La Serena 9 13 6 22
2 Rangers Talca Rangers 9 12 6 19
3 Deportes Limache Deportes 8 18 8 16
4 Antofagasta Antofagasta 9 15 10 16
5 Barnechea Barnechea 9 14 11 15
6 Recoleta Recoleta 9 12 13 15
7 Magallanes Magallanes 9 13 11 13
8 Deportes Santa Cruz Deportes 9 15 16 13
9 San Luis de Quillota Luis 8 15 17 13
10 San Marcos Arica Marcos Arica 9 13 11 12
11 Santiago Wanderers Santiago 9 13 15 11
12 Santiago Morning Santiago 8 11 10 10
13 Deportes Temuco Deportes 9 9 15 9
14 Univ. Concepción Univ. 8 6 13 9
15 Curicó Unido Curicó 9 7 14 7
16 Unión San Felipe Unión 9 9 19 3
Ver
TEMPORADA 2022/2023
Equipo PJ GF GC Puntos
1 Cobreloa Cobreloa 30 41 30 54
2 Deportes Iquique Deportes 30 54 39 52
3 Santiago Wanderers Santiago 30 37 28 51
4 Deportes Temuco Deportes 30 39 36 50
5 Antofagasta Antofagasta 30 50 38 46
6 San Luis de Quillota Luis 30 43 31 44
7 La Serena La Serena 30 38 39 44
8 Unión San Felipe Unión 30 40 34 41
9 Barnechea Barnechea 30 40 41 41
10 San Marcos Arica Marcos Arica 30 51 52 40
11 Rangers Talca Rangers 30 35 47 36
12 Santiago Morning Santiago 30 32 38 34
13 Univ. Concepción Univ. 30 36 49 34
14 Deportes Santa Cruz Deportes 30 27 36 33
15 Recoleta Recoleta 30 34 43 30
16 Puerto Montt Puerto Montt 30 25 41 30
Ver
TEMPORADA 2021/2022
Equipo PJ GF GC Puntos
1 Magallanes Magallanes 32 61 23 72
2 Cobreloa Cobreloa 32 41 24 68
3 Deportes Copiapó Deportes 32 46 34 52
4 Unión San Felipe Unión 32 38 35 52
5 Puerto Montt Puerto Montt 32 36 31 47
6 Univ. Concepción Univ. 32 42 34 46
7 Rangers Talca Rangers 32 39 40 46
8 Barnechea Barnechea 32 47 43 44
9 Santiago Wanderers Santiago 32 37 37 42
10 Deportes Temuco Deportes 32 31 41 38
11 Deportes Santa Cruz Deportes 32 34 39 36
12 Deportes Iquique Deportes 32 31 38 35
13 Recoleta Recoleta 32 34 41 34
14 Santiago Morning Santiago 32 37 47 34
15 San Luis de Quillota Luis 32 27 42 34
16 CD Melipilla Melipilla 32 30 49 30
17 Fernández Vial Fernández 32 26 39 26
Ver
TEMPORADA 2020/2021
Equipo PJ GF GC Puntos
1 Coquimbo Unido Coquimbo 30 42 22 55
2 Deportes Copiapó Deportes 30 49 36 52
3 Santiago Morning Santiago 30 43 26 51
4 Deportes Temuco Deportes 30 44 28 49
5 Puerto Montt Puerto Montt 30 34 30 48
6 Deportes Santa Cruz Deportes 30 36 37 45
7 Magallanes Magallanes 30 38 34 41
8 Deportes Iquique Deportes 30 52 45 40
9 Fernández Vial Fernández 30 45 39 40
10 San Luis de Quillota Luis 30 33 32 40
11 Unión San Felipe Unión 30 34 40 36
12 Rangers Talca Rangers 30 34 42 35
13 Univ. Concepción Univ. 30 32 37 33
14 Cobreloa Cobreloa 30 35 41 33
15 Barnechea Barnechea 30 28 44 24
16 San Marcos Arica Marcos Arica 30 14 60 16
Ver
TEMPORADA 2019/2020
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
Ver
TEMPORADA 2018/2019
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
Ver
TEMPORADA 2017/2018
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
Ver
TEMPORADA 2016/2017
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

  USO DE MEMORIA  
6,019,768 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0029
Controller Execution Time ( Home / Category )  0.3783
Total Execution Time  0.3812
  CADENA URL  
/torneo_transicion_primera_b_chile2024/grupo1/historico
  GET DATOS  
$_GET['/torneo_transicion_primera_b_chile2024/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (20)  
0.0125  SELECT type FROM routes WHERE alias = 'torneo_transicion_primera_b_chile2024'
0.0253  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'torneo_transicion_primera_b_chile' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2024 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0126  SELECT id,name,alias,stepParent FROM categories WHERE parentId=1970 ORDER BY order_id ASC
0.0126  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 1970 AND group_code = 1 and tables = 1 AND year <= 2024 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
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 = 75087 AND t.round = 10 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 `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 = 70890 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.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 `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 = 66687 AND t.round = 34 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 `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 = 61982 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.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 = 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.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 `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.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 `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.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 = 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.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 05:51:19' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-27 05:51:19' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 05:51:19' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-27 05:51:19' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0159  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId 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 = 75087 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 75087 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0192  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId 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 = 75087 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 75087 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0133  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId 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 = 75087 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 75087 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0135  SELECT *,(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 = 75087 AND t.round = 10 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC