4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
« Temporada Anterior
Temporada 2024
 
Publicidad 600x120.gif
Primera B Chile
2023/2024

Primera B Chile

  • La Serena
  • Rangers Talca
  • Deportes Limache
  • Antofagasta
  • Barnechea
  • Recoleta
  • Magallanes
  • Deportes Santa Cruz
  • San Luis de Quillota
  • San Marcos Arica
  • Santiago Wanderers
  • Santiago Morning
  • Deportes Temuco
  • Univ. Concepción
  • Curicó Unido
  • Unión San Felipe
Resultados
« Jornada Anterior
Jornada 10
Jornada Siguiente »
 
27 Abr 24
Sin comenzar 		Deportes Santa Cruz Deportes Santa Cruz
21:00
 		Antofagasta Antofagasta más información ...
 
27 Abr 24
Sin comenzar 		Curicó Unido Curicó Unido
23:30
 		Deportes Temuco Deportes Temuco más información ...
 
27 Abr 24
Sin comenzar 		Santiago Morning Santiago Morning
23:30
 		Univ. Concepción Univ. Concepción más información ...
 
28 Abr 24
Sin comenzar 		San Marcos Arica San Marcos Arica
02:00
 		Barnechea Barnechea más información ...
 
28 Abr 24
Sin comenzar 		Recoleta Recoleta
18:30
 		Magallanes Magallanes más información ...
 
28 Abr 24
Aplazado 		Santiago Wanderers Santiago Wanderers Apl San Luis de Quillota San Luis de Quillota más información ...
 
29 Abr 24
Sin comenzar 		Unión San Felipe Unión San Felipe
00:00
 		Rangers Talca Rangers Talca más información ...
 
30 Abr 24
Sin comenzar 		Deportes Limache Deportes Limache
02:30
 		La Serena La Serena más información ...
Clasificación
« Jornada Anterior
Jornada 10
Jornada Siguiente »
Equipos Puntos J. G. E. P. F. C. Forma
1 La Serena La Serena 22 9 7 1 1 13 6
  • EMPATE
  • La Serena 0
  • Barnechea 0
  • VICTORIA
  • Curicó Unido 1
  • La Serena 2
  • VICTORIA
  • La Serena 1
  • Univ. Concepción 0
  • VICTORIA
  • San Luis de Quillo. 0
  • La Serena 1
  • VICTORIA
  • La Serena 2
  • Deportes Santa Cru. 1
2 Rangers Talca Rangers Talca 19 9 6 1 2 12 6
  • DERROTA
  • Rangers Talca 2
  • San Luis de Quillo. 4
  • VICTORIA
  • Deportes Temuco 0
  • Rangers Talca 1
  • VICTORIA
  • Rangers Talca 1
  • Santiago Wanderers 0
  • VICTORIA
  • San Marcos Arica 0
  • Rangers Talca 1
  • EMPATE
  • Rangers Talca 0
  • Santiago Morning 0
3 Deportes Limache Deportes Limache 16 8 5 1 2 18 8
  • DERROTA
  • Deportes Limache 0
  • Univ. Concepción 1
  • VICTORIA
  • Unión San Felipe 2
  • Deportes Limache 3
  • VICTORIA
  • Deportes Limache 2
  • Curicó Unido 0
  • VICTORIA
  • Recoleta 0
  • Deportes Limache 3
  • EMPATE
  • Deportes Limache 2
  • Santiago Wanderers 2
4 Antofagasta Antofagasta 16 9 5 1 3 15 10
  • VICTORIA
  • Antofagasta 2
  • San Marcos Arica 1
  • EMPATE
  • San Luis de Quillo. 2
  • Antofagasta 2
  • VICTORIA
  • Antofagasta 4
  • Unión San Felipe 1
  • VICTORIA
  • Santiago Morning 0
  • Antofagasta 1
  • VICTORIA
  • Antofagasta 3
  • Recoleta 0
5 Barnechea Barnechea 15 9 4 3 2 14 11
  • EMPATE
  • La Serena 0
  • Barnechea 0
  • DERROTA
  • Santiago Morning 3
  • Barnechea 1
  • DERROTA
  • Barnechea 2
  • San Luis de Quillo. 3
  • EMPATE
  • Santiago Wanderers 1
  • Barnechea 1
  • VICTORIA
  • Barnechea 1
  • Unión San Felipe 0
6 Recoleta Recoleta 15 9 5 0 4 12 13
  • VICTORIA
  • Recoleta 2
  • Curicó Unido 1
  • VICTORIA
  • Univ. Concepción 0
  • Recoleta 2
  • DERROTA
  • Recoleta 1
  • San Marcos Arica 2
  • DERROTA
  • Recoleta 0
  • Deportes Limache 3
  • DERROTA
  • Antofagasta 3
  • Recoleta 0
7 Magallanes Magallanes 13 9 4 1 4 13 11
  • VICTORIA
  • Magallanes 2
  • Santiago Morning 1
  • VICTORIA
  • Santiago Wanderers 2
  • Magallanes 3
  • VICTORIA
  • Magallanes 4
  • Deportes Santa Cru. 1
  • EMPATE
  • Curicó Unido 0
  • Magallanes 0
  • DERROTA
  • Magallanes 0
  • San Marcos Arica 2
8 Deportes Santa Cruz Deportes Santa. 13 9 4 1 4 15 16
  • DERROTA
  • Deportes Santa Cru. 0
  • Unión San Felipe 2
  • VICTORIA
  • San Marcos Arica 3
  • Deportes Santa Cru. 4
  • DERROTA
  • Magallanes 4
  • Deportes Santa Cru. 1
  • VICTORIA
  • Deportes Santa Cru. 3
  • Univ. Concepción 0
  • DERROTA
  • La Serena 2
  • Deportes Santa Cru. 1
9 San Luis de Quillota Luis Quillota 13 8 4 1 3 15 17
  • VICTORIA
  • Rangers Talca 2
  • San Luis de Quillo. 4
  • EMPATE
  • San Luis de Quillo. 2
  • Antofagasta 2
  • VICTORIA
  • Barnechea 2
  • San Luis de Quillo. 3
  • DERROTA
  • San Luis de Quillo. 0
  • La Serena 1
  • VICTORIA
  • Deportes Temuco 0
  • San Luis de Quillo. 3
10 San Marcos Arica Marcos Arica 12 9 4 0 5 13 11
  • DERROTA
  • Antofagasta 2
  • San Marcos Arica 1
  • DERROTA
  • San Marcos Arica 3
  • Deportes Santa Cru. 4
  • VICTORIA
  • Recoleta 1
  • San Marcos Arica 2
  • DERROTA
  • San Marcos Arica 0
  • Rangers Talca 1
  • VICTORIA
  • Magallanes 0
  • San Marcos Arica 2
11 Santiago Wanderers Santiago 11 9 3 2 4 13 15
  • VICTORIA
  • Santiago Wanderers 2
  • Deportes Temuco 1
  • DERROTA
  • Santiago Wanderers 2
  • Magallanes 3
  • DERROTA
  • Rangers Talca 1
  • Santiago Wanderers 0
  • EMPATE
  • Santiago Wanderers 1
  • Barnechea 1
  • EMPATE
  • Deportes Limache 2
  • Santiago Wanderers 2
12 Santiago Morning Santiago Morning 10 8 3 1 4 11 10
  • DERROTA
  • Magallanes 2
  • Santiago Morning 1
  • VICTORIA
  • Santiago Morning 3
  • Barnechea 1
  • VICTORIA
  • Deportes Temuco 0
  • Santiago Morning 1
  • DERROTA
  • Santiago Morning 0
  • Antofagasta 1
  • EMPATE
  • Rangers Talca 0
  • Santiago Morning 0
13 Deportes Temuco Deportes Temuco 9 9 3 0 6 9 15
  • DERROTA
  • Santiago Wanderers 2
  • Deportes Temuco 1
  • DERROTA
  • Deportes Temuco 0
  • Rangers Talca 1
  • DERROTA
  • Deportes Temuco 0
  • Santiago Morning 1
  • VICTORIA
  • Unión San Felipe 2
  • Deportes Temuco 3
  • DERROTA
  • Deportes Temuco 0
  • San Luis de Quillo. 3
14 Univ. Concepción Univ. 9 8 3 0 5 6 13
  • VICTORIA
  • Deportes Limache 0
  • Univ. Concepción 1
  • DERROTA
  • Univ. Concepción 0
  • Recoleta 2
  • DERROTA
  • La Serena 1
  • Univ. Concepción 0
  • DERROTA
  • Deportes Santa Cru. 3
  • Univ. Concepción 0
  • VICTORIA
  • Univ. Concepción 2
  • Curicó Unido 0
15 Curicó Unido Curicó Unido 7 9 2 1 6 7 14
  • DERROTA
  • Recoleta 2
  • Curicó Unido 1
  • DERROTA
  • Curicó Unido 1
  • La Serena 2
  • DERROTA
  • Deportes Limache 2
  • Curicó Unido 0
  • EMPATE
  • Curicó Unido 0
  • Magallanes 0
  • DERROTA
  • Univ. Concepción 2
  • Curicó Unido 0
16 Unión San Felipe Unión Felipe 3 9 1 0 8 9 19
  • VICTORIA
  • Deportes Santa Cru. 0
  • Unión San Felipe 2
  • DERROTA
  • Unión San Felipe 2
  • Deportes Limache 3
  • DERROTA
  • Antofagasta 4
  • Unión San Felipe 1
  • DERROTA
  • Unión San Felipe 2
  • Deportes Temuco 3
  • DERROTA
  • Barnechea 1
  • Unión San Felipe 0
Ascenso : La Serena
Playoff Ascenso : Rangers Talca
Siguiente Ronda : Deportes Limache, Antofagasta, Barnechea, Recoleta, Magallanes, Deportes Santa.
Descenso : Unión Felipe
JUGADORES DESTACADOS

Primera B Chile

27 Abr 24 21:00
Municipal Joaquín Muñoz García
27 Abr 24 23:30
Municipal De La Pintana
27 Abr 24 23:30
Bicentenario La Granja De Curicó
28 Abr 24 02:00
Carlos Dittborn
28 Abr 24 18:30
Lucio Fariña Fernandez De Quillota

  USO DE MEMORIA  
5,966,248 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.3735
Total Execution Time  0.3753
  CADENA URL  
/torneo_transicion_primera_b_chile
  GET DATOS  
$_GET['/torneo_transicion_primera_b_chile']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (19)  
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1970 AND type_rel = 3
0.0127  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.0128  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.0126  SELECT dt.nameShow,dt.basealias,t.id,t.teamId FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 75087 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0126  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-26 18:37:25' 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-26 18:37:25' 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-26 18:37:25' 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-26 18:37:25' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT max(l.year) as max_year, min(l.year) as min_year FROM leagues l WHERE categoryID = 1970 GROUP BY l.categoryId
0.0126  SELECT l.year FROM leagues AS l WHERE (l.group_code =0 OR l.total_num_tablesR>=1 OR l.total_teamsR >=1 OR l.text_mode != 0) AND l.categoryId=1970 GROUP BY l.year ORDER BY l.year DESC
0.0126  SELECT rel.media_id, rel.team1, rel.team2, m.name, m.type, m.lang, m.location, rel.id AS rel_id, m.url FROM rel_media_match AS rel INNER JOIN media AS m ON m.id=rel.media_id WHERE (m.lang='es' OR m.language='spanish') AND rel.active=1 AND rel.league_id=75087 AND rel.round=10
0.0130  SELECT c.isVideo, c.id,c.team1, c.team2,c.extra,c.datateam1,c.datateam2,c.type, c.shedule, c.r1, c.r2, c.round, c.comments as total_comentarios, dt1.nameShow as team1_name, dt2.nameShow as team2_name, dt1.basealias as basealias1, dt2.basealias as basealias2,c.betId,c.betId_wh,c.betId_bwin,c.betId_marca,c.betId_888, c.betId_sportium, c.betId_marathon, c.finished, c.penaltis1, c.penaltis2, c.prorroga, c.status, c.minute, dt1.stadium as stadium_name FROM `calendars2024` as c INNER JOIN teams t1 ON t1.id = c.team1 AND t1.league_id = c.league_id INNER JOIN teams t2 ON t2.id = c.team2 AND t2.league_id = c.league_id INNER JOIN datateams as dt1 ON dt1.id = t1.teamId INNER JOIN datateams as dt2 ON dt2.id = t2.teamId WHERE c.`league_id` = 75087 AND c.`round` = 10 ORDER BY shedule ASC LIMIT 200
0.0127  SELECT ev.match_id,dp.alias,ev.minute,ev.action,ev.player_id,e.name,e.classf,dp.nick,rel.squadNumber,rel.player_id as playerId,rel.team_id,rel.teamId FROM events2024 ev INNER JOIN events e ON e.id = ev.action INNER JOIN calendars2024 c ON c.id = ev.match_id INNER JOIN rel_players rel ON rel.player_id = ev.player_id AND rel.league_id = 75087 AND (ev.team1id=rel.team_id OR ev.team2id=rel.team_id) INNER JOIN dataplayers dp ON dp.id = rel.player_id WHERE ev.match_id IN (681175,681168,681170,681169,681174,681171,681172,681173) AND ev.action in (1,2,3,4,6,11,12,13,15) ORDER BY ev.minute ASC
0.0132  SELECT (dt1.qod+dt2.qod+dt1.relations+dt2.relations) as total,c.r1,c.r2,e.action,ev.showName as eventName,ev.largeName,ev.main_action,ev.keyname,ev.classf,e.real_date,e.minute, dp.nick,dp.CountryCode,dp.alias,c.datateam1,c.datateam2,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1,dt2.basealias as basealias2,e.player_id,e.match_id FROM `events2024` e INNER JOIN calendars2024 c ON c.id = e.match_id INNER JOIN events ev ON ev.id = e.action INNER JOIN dataplayers dp ON dp.id = e.player_id INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE ev.main_action = 1 AND c.round = 10 AND e.real_date IS NOT NULL AND e.league_id = 75087 ORDER BY total DESC LIMIT 40
0.0254  SELECT c.r1,c.r2,e.action,ev.showName as eventName,ev.largeName,ev.main_action,ev.keyname,ev.classf,e.real_date,e.minute, dp.nick,dp.CountryCode,dp.alias,c.datateam1,c.datateam2,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1,dt2.basealias as basealias2,e.player_id,e.match_id FROM `events2024` e INNER JOIN calendars2024 c ON c.id = e.match_id INNER JOIN events ev ON ev.id = e.action INNER JOIN dataplayers dp ON dp.id = e.player_id INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE ev.show_on = 1 AND e.real_date IS NOT NULL AND e.league_id = 75087 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
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 `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 = 8 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0300  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
0.0126  SELECT data1, data2 FROM services_tags WHERE categoryId=1970
0.0127  SELECT group_code, extraName from `leagues` WHERE categoryId=1970 AND year=2024