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

Primera B Chile

  • La Serena
  • Rangers Talca
  • Barnechea
  • Deportes Limache
  • Antofagasta
  • Deportes Santa Cruz
  • Recoleta
  • Magallanes
  • Santiago Morning
  • San Luis de Quillota
  • San Marcos Arica
  • Santiago Wanderers
  • Deportes Temuco
  • Univ. Concepción
  • Curicó Unido
  • Unión San Felipe
 
27 Abr 24
21:00 Finalizado
Deportes Santa Cruz Deportes Santa Cruz 2-1 Antofagasta Antofagasta más información Jugadas destacadas 4
23' D. González 1-0
30' C. Muñoz 2-0
57' G. Espinoza
2-1 67' F. Álvarez
 
27 Abr 24
23:30 Finalizado
Curicó Unido Curicó Unido 0-0 Deportes Temuco Deportes Temuco más información 26
 
27 Abr 24
23:30 Finalizado
Santiago Morning Santiago Morning 2-1 Univ. Concepción Univ. Concepción más información Jugadas destacadas 8
64' R. Paredes 1-0
1-1 79' M. Donoso
81' O. Ortega 2-1
 
28 Abr 24
02:00 Finalizado
San Marcos Arica San Marcos Arica 1-4 Barnechea Barnechea más información Jugadas destacadas 5
0-1 24' B. Sagredo
0-2 63' G. Alucema
0-3 72' C. Pardo
88' S. Pérez 1-3
1-4 90' J. Romo
 
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 1
 
30 Abr 24
Sin comenzar
Deportes Limache Deportes Limache
02:30
La Serena La Serena más información ...
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 Barnechea Barnechea 18 10 5 3 2 18 12
  • 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
  • VICTORIA
  • San Marcos Arica 1
  • Barnechea 4
4 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
5 Antofagasta Antofagasta 16 10 5 1 4 16 12
  • 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
  • DERROTA
  • Deportes Santa Cru. 2
  • Antofagasta 1
6 Deportes Santa Cruz Deportes Santa. 16 10 5 1 4 17 17
  • 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
  • VICTORIA
  • Deportes Santa Cru. 2
  • Antofagasta 1
7 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
8 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
9 Santiago Morning Santiago Morning 13 9 4 1 4 13 11
  • 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
  • VICTORIA
  • Santiago Morning 2
  • Univ. Concepción 1
10 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
11 San Marcos Arica Marcos Arica 12 10 4 0 6 14 15
  • 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
  • DERROTA
  • San Marcos Arica 1
  • Barnechea 4
12 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
13 Deportes Temuco Deportes Temuco 10 10 3 1 6 9 15
  • 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
  • EMPATE
  • Curicó Unido 0
  • Deportes Temuco 0
14 Univ. Concepción Univ. 9 9 3 0 6 7 15
  • 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
  • DERROTA
  • Santiago Morning 2
  • Univ. Concepción 1
15 Curicó Unido Curicó Unido 8 10 2 2 6 7 14
  • 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
  • EMPATE
  • Curicó Unido 0
  • Deportes Temuco 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 : Barnechea, Deportes Limache, Antofagasta, Deportes Santa., Recoleta, Magallanes
Descenso : Unión Felipe
JUGADORES DESTACADOS

Primera B Chile

28 Abr 24 02:00
Carlos Dittborn
28 Abr 24 18:30
Lucio Fariña Fernandez De Quillota
28 Abr 24 22:00
Elías Figueroa Brander
29 Abr 24 00:01
Estadio Municipal De San Felipe
30 Abr 24 02:30
Ángel Navarrete Candia

  USO DE MEMORIA  
5,995,840 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.3291
Total Execution Time  0.3310
  CADENA URL  
/torneo_transicion_primera_b_chile/grupo1
  GET DATOS  
$_GET['/torneo_transicion_primera_b_chile/grupo1']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (13)  
0.0144  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1970 AND type_rel = 3
0.0146  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.0147  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.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-28 02:05:44' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0147  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-28 02:05:44' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0146  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-28 02:05:44' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0147  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-28 02:05:44' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0170  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.0174  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.0166  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 = 9 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0337  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.0147  SELECT data1, data2 FROM services_tags WHERE categoryId=1970
0.0151  SELECT group_code, extraName from `leagues` WHERE categoryId=1970 AND year=2024