4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
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  
5,316,736 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.2584
Total Execution Time  0.2604
  CADENA URL  
/torneo_transicion_primera_b_chile2019/grupo1/historico
  GET DATOS  
$_GET['/torneo_transicion_primera_b_chile2019/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (11)  
0.0135  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 1970 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0130  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 (1305868,1259297,1259030,1258797,1154529) ORDER BY n.cover_points DESC, update_date DESC
0.0131  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 1970 AND group_code = 1 and tables = 1 AND year <= 2019 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
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 = 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.0139  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.0126  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-28 16:17:16' 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-28 16:17:16' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0126  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-28 16:17:16' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0127  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-28 16:17:16' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0275  SELECT *,(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