4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver jornada
Jornada 1
15 Jul 22 Atlético Fútbol ClubAtlético 0 - 2 Real CartagenaReal 9
10 Jul 22 Atlético HuilaAtlético 3 - 2 Real CundinamarcaReal 27
13 Jul 22 Boyacá Chicó Boyacá 1 - 0 BarranquillaBarranquill 25
10 Jul 22 Cúcuta DeportivoCúcuta 1 - 2 Boca Juniors de CaliBoca 104
09 Jul 22 LeonesLeones 2 - 2 BogotáBogotá 8
11 Jul 22 Orsomarso SCOrsomarso 0 - 4 Deportes QuindíoDeportes 52
09 Jul 22 Real SantanderReal 3 - 1 LlanerosLlaneros 1
09 Jul 22 Tigres FCTigres FC 1 - 0 FortalezaFortaleza 11
Ver jornada
Jornada 2
17 Jul 22 BarranquillaBarranquill 3 - 0 Tigres FCTigres FC 9
18 Jul 22 Boca Juniors de CaliBoca 2 - 1 Orsomarso SCOrsomarso 42
20 Jul 22 BogotáBogotá 0 - 1 Atlético Fútbol ClubAtlético 53
17 Jul 22 Deportes QuindíoDeportes 2 - 0 Real SantanderReal 12
16 Jul 22 FortalezaFortaleza 2 - 2 Cúcuta DeportivoCúcuta 162
16 Jul 22 LlanerosLlaneros 3 - 2 Atlético HuilaAtlético 22
16 Jul 22 Real CartagenaReal 0 - 1 LeonesLeones 54
17 Jul 22 Real CundinamarcaReal 0 - 0 Boyacá Chicó Boyacá 22
Ver jornada
Jornada 3
18 Ago 22 Atlético Fútbol ClubAtlético 1 - 0 Tigres FCTigres FC 64
22 Jul 22 Atlético HuilaAtlético 2 - 3 Real CartagenaReal 40
25 Jul 22 BogotáBogotá 1 - 2 Deportes QuindíoDeportes 52
25 Jul 22 Boyacá Chicó Boyacá 3 - 1 Boca Juniors de CaliBoca 22
24 Jul 22 Cúcuta DeportivoCúcuta 0 - 1 BarranquillaBarranquill 40
26 Jul 22 LeonesLeones 0 - 0 LlanerosLlaneros 66
23 Jul 22 Orsomarso SCOrsomarso 1 - 1 Real CundinamarcaReal 14
23 Jul 22 Real SantanderReal 1 - 0 FortalezaFortaleza 28
Ver jornada
Jornada 4
31 Jul 22 Boca Juniors de CaliBoca 1 - 1 Atlético HuilaAtlético 17
01 Ago 22 Deportes QuindíoDeportes 4 - 3 Real CundinamarcaReal 136
01 Ago 22 FortalezaFortaleza 1 - 2 BogotáBogotá 54
30 Jul 22 LlanerosLlaneros 1 - 1 BarranquillaBarranquill 7
29 Jul 22 Orsomarso SCOrsomarso 0 - 0 Boyacá Chicó Boyacá 72
29 Jul 22 Real CartagenaReal 1 - 2 Cúcuta DeportivoCúcuta 109
30 Jul 22 Real SantanderReal 0 - 1 Atlético Fútbol ClubAtlético 2
30 Jul 22 Tigres FCTigres FC 1 - 1 LeonesLeones 5
Ver jornada
Jornada 5
23 Ago 22 Atlético Fútbol ClubAtlético 1 - 1 Deportes QuindíoDeportes 75
04 Ago 22 Atlético HuilaAtlético 1 - 2 FortalezaFortaleza 84
04 Ago 22 BarranquillaBarranquill 1 - 1 Boca Juniors de CaliBoca 103
05 Ago 22 BogotáBogotá 2 - 1 Cúcuta DeportivoCúcuta 47
04 Ago 22 Boyacá Chicó Boyacá 2 - 2 Tigres FCTigres FC 21
05 Ago 22 LeonesLeones 1 - 1 Real SantanderReal 59
04 Ago 22 Real CartagenaReal 0 - 1 Orsomarso SCOrsomarso 47
04 Ago 22 Real CundinamarcaReal 1 - 1 LlanerosLlaneros 46
Ver jornada
Jornada 6
09 Ago 22 BarranquillaBarranquill 3 - 1 LeonesLeones 84
08 Ago 22 Boca Juniors de CaliBoca 2 - 0 Real CundinamarcaReal 96
09 Ago 22 Cúcuta DeportivoCúcuta 1 - 2 Boyacá Chicó Boyacá 127
07 Ago 22 FortalezaFortaleza 3 - 1 Real CartagenaReal 11
08 Ago 22 LlanerosLlaneros 1 - 0 Atlético Fútbol ClubAtlético 33
07 Ago 22 Orsomarso SCOrsomarso 0 - 2 Atlético HuilaAtlético 28
08 Ago 22 Real SantanderReal 2 - 0 BogotáBogotá 57
09 Ago 22 Tigres FCTigres FC 2 - 0 Deportes QuindíoDeportes 228
Ver jornada
Jornada 7
14 Ago 22 Atlético Fútbol ClubAtlético 2 - 1 Orsomarso SCOrsomarso 1
17 Ago 22 Atlético HuilaAtlético 1 - 1 Boyacá Chicó Boyacá 122
13 Ago 22 BogotáBogotá 1 - 0 BarranquillaBarranquill 10
13 Ago 22 Deportes QuindíoDeportes 1 - 0 FortalezaFortaleza 39
16 Ago 22 LeonesLeones 1 - 1 Cúcuta DeportivoCúcuta 117
13 Ago 22 LlanerosLlaneros 1 - 1 Boca Juniors de CaliBoca 25
17 Ago 22 Real CartagenaReal 2 - 2 Real SantanderReal 35
14 Ago 22 Real CundinamarcaReal 1 - 1 Tigres FCTigres FC 7
Ver jornada
Jornada 8
21 Ago 22 BarranquillaBarranquill 1 - 1 Deportes QuindíoDeportes 24
20 Ago 22 Boca Juniors de CaliBoca 1 - 1 LeonesLeones 22
24 Ago 22 Boyacá Chicó Boyacá 4 - 0 Real CartagenaReal 34
21 Ago 22 Cúcuta DeportivoCúcuta 0 - 0 LlanerosLlaneros 18
21 Ago 22 FortalezaFortaleza 2 - 0 Atlético Fútbol ClubAtlético 13
20 Ago 22 Orsomarso SCOrsomarso 0 - 0 Real SantanderReal 10
24 Ago 22 Tigres FCTigres FC 1 - 2 Atlético HuilaAtlético 68
23 Ago 22 Real CundinamarcaReal 3 - 3 BogotáBogotá 48
Ver jornada
Jornada 9
29 Ago 22 Boca Juniors de CaliBoca 0 - 1 Atlético Fútbol ClubAtlético 26
31 Ago 22 Atlético HuilaAtlético 2 - 0 LlanerosLlaneros 72
29 Ago 22 BogotáBogotá 0 - 1 Tigres FCTigres FC 47
29 Ago 22 Deportes QuindíoDeportes 2 - 0 Orsomarso SCOrsomarso 15
27 Ago 22 FortalezaFortaleza 1 - 0 Boyacá Chicó Boyacá 20
27 Ago 22 LeonesLeones 1 - 0 Real CundinamarcaReal 8
31 Ago 22 Real CartagenaReal 2 - 2 BarranquillaBarranquill 49
27 Ago 22 Real SantanderReal 0 - 1 Cúcuta DeportivoCúcuta 13
Ver jornada
Jornada 10
04 Sep 22 BarranquillaBarranquill 2 - 1 Atlético HuilaAtlético 11
03 Sep 22 Boca Juniors de CaliBoca 1 - 0 Deportes QuindíoDeportes 26
03 Sep 22 Boyacá Chicó Boyacá 1 - 0 Atlético Fútbol ClubAtlético 89
04 Sep 22 Cúcuta DeportivoCúcuta 3 - 0 Orsomarso SCOrsomarso 11
03 Sep 22 LeonesLeones 1 - 1 FortalezaFortaleza 141
03 Sep 22 LlanerosLlaneros 2 - 0 BogotáBogotá ...
03 Sep 22 Tigres FCTigres FC 2 - 2 Real SantanderReal 1
03 Sep 22 Real CundinamarcaReal 1 - 1 Real CartagenaReal 6
Ver jornada
Jornada 11
07 Sep 22 Atlético Fútbol ClubAtlético 4 - 0 LeonesLeones 8
09 Sep 22 Atlético HuilaAtlético 3 - 2 Cúcuta DeportivoCúcuta 100
08 Sep 22 BogotáBogotá 4 - 1 Boca Juniors de CaliBoca 35
09 Sep 22 Deportes QuindíoDeportes 0 - 0 Boyacá Chicó Boyacá 96
07 Sep 22 FortalezaFortaleza 3 - 0 BarranquillaBarranquill 143
07 Sep 22 Orsomarso SCOrsomarso 2 - 2 LlanerosLlaneros 14
07 Sep 22 Real CartagenaReal 0 - 1 Tigres FCTigres FC 43
07 Sep 22 Real SantanderReal 1 - 0 Real CundinamarcaReal 6
Ver jornada
Jornada 12
14 Sep 22 BarranquillaBarranquill 2 - 1 Real SantanderReal 35
10 Sep 22 Boca Juniors de CaliBoca 0 - 0 FortalezaFortaleza 13
13 Sep 22 Boyacá Chicó Boyacá 0 - 2 BogotáBogotá 86
14 Sep 22 Deportes QuindíoDeportes 2 - 0 Cúcuta DeportivoCúcuta 57
13 Sep 22 LeonesLeones 2 - 2 Atlético HuilaAtlético 163
10 Sep 22 LlanerosLlaneros 2 - 0 Real CartagenaReal 2
12 Sep 22 Tigres FCTigres FC 1 - 0 Orsomarso SCOrsomarso 38
10 Sep 22 Real CundinamarcaReal 1 - 0 Atlético Fútbol ClubAtlético 3
Ver jornada
Jornada 13
20 Sep 22 Atlético Fútbol ClubAtlético 3 - 2 BarranquillaBarranquill 79
19 Sep 22 Atlético HuilaAtlético 2 - 0 BogotáBogotá 16
18 Sep 22 Cúcuta DeportivoCúcuta 2 - 1 Real CundinamarcaReal 20
16 Sep 22 FortalezaFortaleza 1 - 0 LlanerosLlaneros 75
18 Sep 22 Orsomarso SCOrsomarso 1 - 4 LeonesLeones 6
20 Sep 22 Real CartagenaReal 3 - 1 Deportes QuindíoDeportes 72
19 Sep 22 Real SantanderReal 0 - 0 Boyacá Chicó Boyacá 130
18 Sep 22 Tigres FCTigres FC 3 - 2 Boca Juniors de CaliBoca 14
Ver jornada
Jornada 14
25 Sep 22 BarranquillaBarranquill 2 - 3 Real CartagenaReal 13
27 Sep 22 Boca Juniors de CaliBoca 0 - 0 Atlético Fútbol ClubAtlético 41
23 Sep 22 BogotáBogotá 1 - 0 Orsomarso SCOrsomarso 34
24 Sep 22 Boyacá Chicó Boyacá 0 - 0 FortalezaFortaleza 159
23 Sep 22 Cúcuta DeportivoCúcuta 0 - 0 Real SantanderReal 89
28 Sep 22 Deportes QuindíoDeportes 1 - 1 Atlético HuilaAtlético 81
24 Sep 22 LlanerosLlaneros 2 - 0 Tigres FCTigres FC 15
24 Sep 22 Real CundinamarcaReal 3 - 3 LeonesLeones 61
Ver jornada
Jornada 15
02 Oct 22 Atlético Fútbol ClubAtlético 0 - 1 Cúcuta DeportivoCúcuta 40
05 Oct 22 LeonesLeones 1 - 1 Boyacá Chicó Boyacá 56
03 Oct 22 LlanerosLlaneros 1 - 0 Deportes QuindíoDeportes 100
30 Sep 22 Orsomarso SCOrsomarso 0 - 4 FortalezaFortaleza 16
01 Oct 22 Real CartagenaReal 0 - 0 Boca Juniors de CaliBoca 52
03 Oct 22 Real SantanderReal 2 - 1 Atlético HuilaAtlético 43
01 Oct 22 Tigres FCTigres FC 2 - 1 BogotáBogotá 67
01 Oct 22 Real CundinamarcaReal 0 - 1 BarranquillaBarranquill 19
Ver jornada
Jornada 16
08 Oct 22 Atlético HuilaAtlético 6 - 0 Atlético Fútbol ClubAtlético 26
08 Oct 22 BarranquillaBarranquill 2 - 0 Orsomarso SCOrsomarso 15
08 Oct 22 Boca Juniors de CaliBoca 2 - 3 Real SantanderReal 19
08 Oct 22 BogotáBogotá 2 - 0 Real CartagenaReal 30
08 Oct 22 Boyacá Chicó Boyacá 1 - 1 LlanerosLlaneros 99
08 Oct 22 Cúcuta DeportivoCúcuta 2 - 1 Tigres FCTigres FC 32
08 Oct 22 Deportes QuindíoDeportes 3 - 2 LeonesLeones 4
08 Oct 22 FortalezaFortaleza 3 - 1 Real CundinamarcaReal 41

Clasificación

Equipo PJ GF GC Puntos
1 Fortaleza Fortaleza 16 23 11 28
2 Deportes Quindío Deportes 16 24 16 28
3 Atlético Huila Atlético 16 32 22 25
4 Barranquilla Barranquilla 16 23 19 25
5 Llaneros Llaneros 16 18 14 25
6 Tigres FC Tigres FC 16 19 19 25
7 Boyacá Chicó Boyacá 16 16 10 24
8 Real Santander Real 16 18 15 24
9 Bogotá Bogotá 16 21 20 23
10 Atlético Fútbol Club Atlético 16 14 18 23
11 Cúcuta Deportivo Cúcuta 16 19 18 22
12 Leones Leones 16 22 24 19
13 Boca Juniors de Cali Boca Juniors 16 17 20 19
14 Real Cartagena Real 16 18 26 16
15 Real Cundinamarca Real 16 18 27 10
16 Orsomarso SC Orsomarso 16 7 30 7

  USO DE MEMORIA  
5,923,408 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.3301
Total Execution Time  0.3321
  CADENA URL  
/clausura_primera_b_colombia2022/grupo1/calendario
  GET DATOS  
$_GET['/clausura_primera_b_colombia2022/grupo1/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (17)  
0.0105  SELECT type FROM routes WHERE alias = 'clausura_primera_b_colombia2022'
0.0214  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'clausura_primera_b_colombia' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2022 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0106  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=197 AND type_rel = 3
0.0108  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 197 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0108  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 (1078402,1077594,1077298,1076577,1027676) ORDER BY n.cover_points DESC, update_date DESC
0.0105  SELECT id,name,alias,stepParent FROM categories WHERE parentId=196 ORDER BY order_id ASC
0.0107  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 = 66315 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0113  SELECT 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, dt1.stadium as stadium_name FROM calendars2022 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 66315 ORDER BY round ASC
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-18 23:51:23' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0106  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-18 23:51:23' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-18 23:51:23' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0106  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-18 23:51:23' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0111  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'clausura_primera_b_colombia' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2022 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0182  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 events2022 e ON e.player_id = p.id AND e.league_id = 66315 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 66315 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.0233  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 events2022 e ON e.player_id = p.id AND e.league_id = 66315 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 66315 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0118  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 events2022 e ON e.player_id = p.id AND e.league_id = 66315 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 66315 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0121  SELECT *,(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 = 66315 AND t.round = 16 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC