4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
« Temporada Anterior
Temporada 2019
Temporada Siguiente »
Publicidad 600x120.gif
Apertura Primera B Colombia 2019
2018/2019

Apertura Primera B Colombia 2019

  • Real Cartagena
  • Deportes Quindío
  • Barranquilla
  • Deportivo Pereira
  • Llaneros
  • Boyacá Chicó
  • Internacional de Palmira
  • Leones
  • Fortaleza
  • Real Cundinamarca
  • Tigres FC
  • Bogotá
  • Universitario Popayán
  • Real Santander
  • Atlético Fútbol Club
  • Orsomarso SC
  • Primera B

Apertura Primera B Colombia 2019

La temporada finalizó el Sábado, 04 Mayo 2019.
Resultados
« Jornada Anterior
Jornada 12
Jornada Siguiente »
 
13 Abr 19
21:00 Finalizado 		Bogotá Bogotá 1-0 Real Santander Real Santander más información Jugadas destacadas ...
24' D. Palacio 1-0
 
13 Abr 19
21:30 Finalizado 		Fortaleza Fortaleza 0-0 Tigres FC Tigres FC más información 12
 
14 Abr 19
22:00 Finalizado 		Barranquilla Barranquilla 1-0 Atlético Fútbol Club Atlético Fútbol Club más información Jugadas destacadas 4
7' A. Palmezano 1-0
 
14 Abr 19
22:00 Finalizado 		Llaneros Llaneros 0-1 Real Cundinamarca Real Cundinamarca más información Jugadas destacadas 19
0-1 52' D. Vega
 
14 Abr 19
22:30 Finalizado 		Internacional de Palmira Internacional Palmira 1-0 Universitario Popayán Universitario Popayán más información Jugadas destacadas 21
78' G. Murillo 1-0
90' F. Valencia
90' M. Trejos
90' J. Rentería
90' A. Morales
90' S. Herrera
 
16 Abr 19
01:00 Finalizado 		Boyacá Chicó Boyacá Chicó 0-0 Orsomarso SC Orsomarso SC más información 13
 
16 Abr 19
01:00 Finalizado 		Leones Leones 1-1 Real Cartagena Real Cartagena más información Jugadas destacadas 20
0-1 2' E. Aguilar
15' W. Cruz 1-1
 
16 Abr 19
03:00 Finalizado 		Deportivo Pereira Deportivo Pereira 0-1 Deportes Quindío Deportes Quindío más información Jugadas destacadas 20
0-1 73' E. Guerrero
Clasificación
« Jornada Anterior
Jornada 12
Jornada Siguiente »
Equipos Puntos J. G. E. P. F. C. Forma
1 Real Cartagena Real Cartagena 24 12 7 3 2 20 10
  • VICTORIA
  • Llaneros 0
  • Real Cartagena 2
  • VICTORIA
  • Real Cartagena 2
  • Boyacá Chicó 1
  • DERROTA
  • Bogotá 1
  • Real Cartagena 0
  • VICTORIA
  • Real Cartagena 3
  • Internacional de P. 2
  • EMPATE
  • Leones 1
  • Real Cartagena 1
2 Deportes Quindío Deportes 22 12 6 4 2 18 10
  • EMPATE
  • Deportes Quindío 1
  • Orsomarso SC 1
  • VICTORIA
  • Real Cundinamarca 0
  • Deportes Quindío 1
  • VICTORIA
  • Deportes Quindío 3
  • Tigres FC 1
  • DERROTA
  • Atlético Fútbol Cl. 1
  • Deportes Quindío 0
  • VICTORIA
  • Deportivo Pereira 0
  • Deportes Quindío 1
3 Barranquilla Barranquilla 22 12 6 4 2 15 11
  • VICTORIA
  • Barranquilla 2
  • Real Santander 0
  • VICTORIA
  • Orsomarso SC 1
  • Barranquilla 2
  • VICTORIA
  • Barranquilla 3
  • Real Cundinamarca 0
  • DERROTA
  • Tigres FC 4
  • Barranquilla 0
  • VICTORIA
  • Barranquilla 1
  • Atlético Fútbol Cl. 0
4 Deportivo Pereira Deportivo 21 12 6 3 3 18 6
  • VICTORIA
  • Deportivo Pereira 6
  • Tigres FC 0
  • DERROTA
  • Internacional de P. 2
  • Deportivo Pereira 1
  • VICTORIA
  • Deportivo Pereira 4
  • Atlético Fútbol Cl. 0
  • DERROTA
  • Leones 1
  • Deportivo Pereira 0
  • DERROTA
  • Deportivo Pereira 0
  • Deportes Quindío 1
5 Llaneros Llaneros 20 12 6 2 4 21 18
  • DERROTA
  • Llaneros 0
  • Real Cartagena 2
  • DERROTA
  • Universitario Popa. 3
  • Llaneros 0
  • VICTORIA
  • Llaneros 2
  • Real Santander 0
  • VICTORIA
  • Orsomarso SC 2
  • Llaneros 3
  • DERROTA
  • Llaneros 0
  • Real Cundinamarca 1
6 Boyacá Chicó Boyacá Chicó 19 12 4 7 1 13 8
  • VICTORIA
  • Boyacá Chicó 2
  • Leones 1
  • DERROTA
  • Real Cartagena 2
  • Boyacá Chicó 1
  • VICTORIA
  • Boyacá Chicó 2
  • Universitario Popa. 0
  • VICTORIA
  • Real Santander 0
  • Boyacá Chicó 1
  • EMPATE
  • Boyacá Chicó 0
  • Orsomarso SC 0
7 Internacional de Palmira Internacional 17 12 5 2 5 19 19
  • DERROTA
  • Bogotá 3
  • Internacional de P. 2
  • VICTORIA
  • Internacional de P. 2
  • Deportivo Pereira 1
  • DERROTA
  • Internacional de P. 0
  • Leones 1
  • DERROTA
  • Real Cartagena 3
  • Internacional de P. 2
  • VICTORIA
  • Internacional de P. 1
  • Universitario Popa. 0
8 Leones Leones 17 12 4 5 3 11 11
  • DERROTA
  • Boyacá Chicó 2
  • Leones 1
  • VICTORIA
  • Leones 1
  • Bogotá 0
  • VICTORIA
  • Internacional de P. 0
  • Leones 1
  • VICTORIA
  • Leones 1
  • Deportivo Pereira 0
  • EMPATE
  • Leones 1
  • Real Cartagena 1
9 Fortaleza Fortaleza 16 12 4 4 4 20 18
  • VICTORIA
  • Fortaleza 3
  • Universitario Popa. 1
  • EMPATE
  • Real Santander 2
  • Fortaleza 2
  • EMPATE
  • Fortaleza 2
  • Orsomarso SC 2
  • EMPATE
  • Real Cundinamarca 1
  • Fortaleza 1
  • EMPATE
  • Fortaleza 0
  • Tigres FC 0
10 Real Cundinamarca Real 14 12 3 5 4 11 14
  • EMPATE
  • Real Cundinamarca 1
  • Atlético Fútbol Cl. 1
  • DERROTA
  • Real Cundinamarca 0
  • Deportes Quindío 1
  • DERROTA
  • Barranquilla 3
  • Real Cundinamarca 0
  • EMPATE
  • Real Cundinamarca 1
  • Fortaleza 1
  • VICTORIA
  • Llaneros 0
  • Real Cundinamarca 1
11 Tigres FC Tigres FC 14 12 3 5 4 15 19
  • DERROTA
  • Deportivo Pereira 6
  • Tigres FC 0
  • EMPATE
  • Tigres FC 1
  • Atlético Fútbol Cl. 1
  • DERROTA
  • Deportes Quindío 3
  • Tigres FC 1
  • VICTORIA
  • Tigres FC 4
  • Barranquilla 0
  • EMPATE
  • Fortaleza 0
  • Tigres FC 0
12 Bogotá Bogotá 13 12 3 4 5 9 17
  • VICTORIA
  • Bogotá 3
  • Internacional de P. 2
  • DERROTA
  • Leones 1
  • Bogotá 0
  • VICTORIA
  • Bogotá 1
  • Real Cartagena 0
  • EMPATE
  • Universitario Popa. 0
  • Bogotá 0
  • VICTORIA
  • Bogotá 1
  • Real Santander 0
13 Universitario Popayán Universitario 11 12 2 5 5 11 15
  • DERROTA
  • Fortaleza 3
  • Universitario Popa. 1
  • VICTORIA
  • Universitario Popa. 3
  • Llaneros 0
  • DERROTA
  • Boyacá Chicó 2
  • Universitario Popa. 0
  • EMPATE
  • Universitario Popa. 0
  • Bogotá 0
  • DERROTA
  • Internacional de P. 1
  • Universitario Popa. 0
14 Real Santander Real Santander 8 12 1 5 6 8 16
  • DERROTA
  • Barranquilla 2
  • Real Santander 0
  • EMPATE
  • Real Santander 2
  • Fortaleza 2
  • DERROTA
  • Llaneros 2
  • Real Santander 0
  • DERROTA
  • Real Santander 0
  • Boyacá Chicó 1
  • DERROTA
  • Bogotá 1
  • Real Santander 0
15 Atlético Fútbol Club Atlético 8 12 1 5 6 7 19
  • EMPATE
  • Real Cundinamarca 1
  • Atlético Fútbol Cl. 1
  • EMPATE
  • Tigres FC 1
  • Atlético Fútbol Cl. 1
  • DERROTA
  • Deportivo Pereira 4
  • Atlético Fútbol Cl. 0
  • VICTORIA
  • Atlético Fútbol Cl. 1
  • Deportes Quindío 0
  • DERROTA
  • Barranquilla 1
  • Atlético Fútbol Cl. 0
16 Orsomarso SC Orsomarso SC 7 12 0 7 5 14 19
  • EMPATE
  • Deportes Quindío 1
  • Orsomarso SC 1
  • DERROTA
  • Orsomarso SC 1
  • Barranquilla 2
  • EMPATE
  • Fortaleza 2
  • Orsomarso SC 2
  • DERROTA
  • Orsomarso SC 2
  • Llaneros 3
  • EMPATE
  • Boyacá Chicó 0
  • Orsomarso SC 0
Series Finales : Real Cartagena, Deportes, Barranquilla, Deportivo, Llaneros, Boyacá Chicó , Internacional, Leones
JUGADORES DESTACADOS

INFORMACIÓN

La Categoría Primera B, llamado oficialmente Torneo Postobón por motivos comerciales, es el torneo de segunda división de la División Mayor del Fútbol Colombiano (Dimayor), entidad dependiente de la Federación Colombiana de Fútbol. El torneo es de carácter profesional, comenzó a disputarse en 1991 y el primer torneo fue ganado por el Envigado Fútbol Club.

  USO DE MEMORIA  
6,011,144 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0026
Controller Execution Time ( Home / Category )  0.0964
Total Execution Time  0.0991
  CADENA URL  
/apertura_primera_b_colombia2019/grupo1/jornada12
  GET DATOS  
$_GET['/apertura_primera_b_colombia2019/grupo1/jornada12']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (25)  
0.0018  SELECT type FROM routes WHERE alias = 'apertura_primera_b_colombia2019'
0.0042  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'apertura_primera_b_colombia' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2019 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=196 AND type_rel = 3
0.0024  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 196 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0022  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 (1280990,1223665,1162446,1152331,1076557) ORDER BY n.cover_points DESC, update_date DESC
0.0020  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 = 48673 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0022  SELECT c.id, c.name, c.alias, l.id AS league_id, l.year, l.group_code, l.total_group, c.id AS categoryId, c.stepParent FROM categories AS c INNER JOIN leagues AS l ON c.id=l.categoryId AND c.active_year=l.year WHERE c.id=196 ORDER BY l.group_code ASC
0.0020  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-30 19:23:30' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-30 19:23:30' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-30 19:23:30' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-30 19:23:30' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0024  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'apertura_primera_b_colombia' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2019 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0026  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=48673 AND rel.round=12
0.0019  SELECT count(esl.user_id) as cuenta FROM editor_stats_leagues esl INNER JOIN fa_user u ON u.id = esl.user_id INNER JOIN fa_user_profile up ON up.id = esl.user_id WHERE esl.league_id = 48673 AND esl.points > 0
0.0018  SELECT fau.user_name, c.*, NOW() as difference_time,creation_date FROM (leagues as l) INNER JOIN comments as c ON c.league_id = l.id LEFT JOIN fa_user fau ON fau.id = c.author_id WHERE c.creation_date > "2024-03-31" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 48673 ORDER BY creation_date DESC LIMIT 0, 10
0.0024  SELECT count(c.id) as cuenta FROM (leagues as l) INNER JOIN comments as c ON c.league_id = l.id WHERE c.creation_date > "2024-03-31" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 48673
0.0029  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 `calendars2019` 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` = 48673 AND c.`round` = 12 ORDER BY shedule ASC LIMIT 200
0.0032  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 events2019 ev INNER JOIN events e ON e.id = ev.action INNER JOIN calendars2019 c ON c.id = ev.match_id INNER JOIN rel_players rel ON rel.player_id = ev.player_id AND rel.league_id = 48673 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 (356261,356258,356257,356259,356262,356260,356263,356256) AND ev.action in (1,2,3,4,6,11,12,13,15) ORDER BY ev.minute ASC
0.0024  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 `events2019` e INNER JOIN calendars2019 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 = 12 AND e.real_date IS NOT NULL AND e.league_id = 48673 ORDER BY total DESC LIMIT 40
0.0043  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 = 48673 AND t.round = 11 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  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 = 48673 AND t.round = 12 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0019  SELECT distinct(shedule), round FROM `calendars2019` as c WHERE c.`league_id` = 48673 AND shedule >= '2019/04/01' AND shedule < '2019/05/01' ORDER BY shedule ASC
0.0018  SELECT c.id, 2024 AS year, IF(l.tables = 1 AND t1.points>0,((t1.points / (l.current_round * 3)) + (t2.points / (l.current_round * 3)))/2 * ct.coefficient,0.7 * ct.coefficient) as fcoef FROM `calendars2024` AS c INNER JOIN `leagues` AS l ON c.`league_id` = l.`id` INNER JOIN `categories` AS ct ON ct.`id` = l.`categoryId` LEFT JOIN tables2024 AS t1 ON t1.team = c.team1 AND t1.round = l.current_round LEFT JOIN tables2024 AS t2 ON t2.team = c.team2 AND t2.round = l.current_round WHERE c.`shedule` > '2024-04-30 00:00:00' AND c.`shedule` < '2024-05-04 23:59:59' AND l.id = 48673 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0020  SELECT data1, data2 FROM services_tags WHERE categoryId=196
0.0020  SELECT group_code, extraName from `leagues` WHERE categoryId=196 AND year=2019