4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Boca Juniors de Cali

Boca Juniors de Cali

Entrenador: Jose Rodríguez

Temporada 2023/2024
TEMPORADA 2023/2024
APERTURA PRIMERA B COLOMBIA
Equipo PJ GF GC Puntos
1 Atlético Huila Atlético 12 21 4 33
2 Cúcuta Deportivo Cúcuta 13 18 11 25
3 Llaneros Llaneros 12 19 9 23
4 Tigres FC Tigres FC 13 18 10 22
5 Real Cartagena Real 12 15 8 20
6 Unión Magdalena Unión 12 20 16 19
7 Orsomarso SC Orsomarso 13 19 16 19
8 Deportes Quindío Deportes 12 15 13 17
9 Real Cundinamarca Real 13 19 19 16
10 Barranquilla Barranquilla 13 15 16 15
11 Boca Juniors de Cali Boca Juniors 13 11 16 15
12 Leones Leones 13 16 19 13
13 Internacional de Palmira Internaciona 13 13 17 13
14 Bogotá Bogotá 13 13 30 10
15 Real Santander Real 12 13 23 8
16 Atlético Fútbol Club Atlético 13 5 23 5
TEMPORADA 2022/2023
CLAUSURA PRIMERA B COLOMBIA
Equipo PJ GF GC Puntos
1 Fortaleza Fortaleza 16 24 9 39
2 Llaneros Llaneros 16 19 10 27
3 Cúcuta Deportivo Cúcuta 16 22 15 27
4 Real Cartagena Real 16 20 15 27
5 Barranquilla Barranquilla 16 20 19 26
6 Leones Leones 16 28 23 24
7 Atlético Fútbol Club Atlético 16 19 19 24
8 Boca Juniors de Cali Boca Juniors 16 13 14 22
9 Patriotas Boyacá Patriotas 16 19 19 21
10 Real Santander Real 16 18 19 21
11 Deportes Quindío Deportes 16 13 18 18
12 Internacional de Palmira Internaciona 16 17 15 17
13 Bogotá Bogotá 16 11 17 16
14 Orsomarso SC Orsomarso 16 11 20 15
15 Real Cundinamarca Real 16 13 19 14
16 Tigres FC Tigres FC 16 12 28 9
TEMPORADA 2021/2022
APERTURA PRIMERA B COLOMBIA
Equipo PJ GF GC Puntos
1 Leones Leones 14 21 10 27
2 Fortaleza Fortaleza 14 26 17 25
3 Deportes Quindío Deportes 14 17 8 25
4 Real Cartagena Real 14 19 16 25
5 Tigres FC Tigres FC 14 16 12 22
6 Boyacá Chicó Boyacá 14 18 16 22
7 Llaneros Llaneros 14 14 12 22
8 Bogotá Bogotá 14 17 16 22
9 Real Cundinamarca Real 14 15 12 21
10 Orsomarso SC Orsomarso 14 14 20 18
11 Atlético Fútbol Club Atlético 14 10 14 14
12 Real Santander Real 14 13 21 11
13 Barranquilla Barranquilla 14 13 23 10
14 Atlético Huila Atlético 14 7 14 9
15 Boca Juniors de Cali Boca Juniors 14 10 19 8
TEMPORADA 2020/2021
CLAUSURA PRIMERA B COLOMBIA
Equipo PJ GF GC Puntos
1 Leones Leones 14 25 12 29
2 Bogotá Bogotá 14 18 9 28
3 Boyacá Chicó Boyacá 14 15 6 28
4 Fortaleza Fortaleza 14 24 10 26
5 Unión Magdalena Unión 14 24 17 25
6 Internacional de Palmira Internaciona 14 19 13 25
7 Llaneros Llaneros 14 20 15 23
8 Real Cartagena Real 14 17 14 20
9 Atlético Fútbol Club Atlético 14 17 20 19
10 Barranquilla Barranquilla 14 13 19 15
11 Orsomarso SC Orsomarso 14 14 22 15
12 Real Santander Real 14 15 24 10
13 Real Cundinamarca Real 14 13 23 8
14 Boca Juniors de Cali Boca Juniors 14 8 25 7
15 Tigres FC Tigres FC 14 6 19 6
TEMPORADA 2019/2020
CLAUSURA PRIMERA B COLOMBIA
Equipo PJ GF GC Puntos
1 Fortaleza Fortaleza 0 0 0 0
2 Atlético Huila Atlético 0 0 0 0
3 Internacional de Palmira Internaciona 0 0 0 0
4 Atlético Fútbol Club Atlético 0 0 0 0
5 Barranquilla Barranquilla 0 0 0 0
6 Real Cundinamarca Real 0 0 0 0
7 Llaneros Llaneros 0 0 0 0
8 Tigres FC Tigres FC 0 0 0 0
9 Unión Magdalena Unión 0 0 0 0
10 Deportes Quindío Deportes 0 0 0 0
11 Orsomarso SC Orsomarso 0 0 0 0
12 Boca Juniors de Cali Boca Juniors 0 0 0 0
13 Real Cartagena Real 0 0 0 0
14 Real Santander Real 0 0 0 0
15 Bogotá Bogotá 0 0 0 0
16 Leones Leones 0 0 0 0
TEMPORADA 2018/2019
CLAUSURA PRIMERA B COLOMBIA
Equipo PJ GF GC Puntos
1 Deportes Quindío Deportes 15 21 12 29
2 Boyacá Chicó Boyacá 15 25 19 27
3 Bogotá Bogotá 15 19 14 26
4 Internacional de Palmira Internaciona 15 24 19 25
5 Deportivo Pereira Deportivo 15 13 9 25
6 Real Cartagena Real 15 20 19 24
7 Fortaleza Fortaleza 15 18 15 22
8 Tigres FC Tigres FC 15 17 14 21
9 Leones Leones 15 19 17 21
10 Real Santander Real 15 16 17 20
11 Llaneros Llaneros 15 12 15 19
12 Real Cundinamarca Real 15 14 19 19
13 Atlético Fútbol Club Atlético 15 15 13 18
14 Boca Juniors de Cali Boca Juniors 15 15 25 11
15 Barranquilla Barranquilla 15 10 21 11
16 Orsomarso SC Orsomarso 15 13 23 8

  USO DE MEMORIA  
5,577,488 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1054
Total Execution Time  0.1066
  CADENA URL  
/historico/Boca-Juniors-De-Cali
  GET DATOS  
$_GET['/historico/Boca-Juniors-De-Cali']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (30)  
0.0031  SELECT dt.*,c.active_year,l.year,l.table_suffix, c.ctype, l.id as league_id,t.id as id,t.manager,t.name as nameOriginal,dt.id as teamId,cou.Name as cou_name,cou.Continent,cou.Region FROM `leagues_webci` as l INNER JOIN `teams` as t ON l.id = t.league_id INNER JOIN `datateams` as dt ON dt.id = t.teamId INNER JOIN `categories_webci` as c ON c.id = l.categoryId LEFT JOIN country cou ON LOWER(cou.Code2) = dt.CountryCode WHERE dt.basealias = 'Boca-Juniors-De-Cali' AND l.year = 2024 ORDER BY c.top DESC, c.ctype != 12 DESC, c.troncal DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, c.coefficient DESC, l.id ASC
0.0019  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=121414 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=121414 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=121414 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=121414 AND type_rel = 2
0.0027  SELECT cat.logo,cat.official,cat.location,dt.nameShow,dt.basealias,t.teamId,l.year,t.qod,cat.coefficient,cat.active_year,cat.name,l.group_code,l.total_group,cat.alias,l.categoryId,l.year,l.id as league_id FROM datateams dt INNER JOIN teams t ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories cat ON cat.id = l.categoryId WHERE dt.id = '121414' ORDER BY l.year DESC,cat.coefficient DESC
0.0024  SELECT cat.logo,cat.official,cat.location,dt.nameShow,dt.basealias,t.teamId,l.year,t.qod,cat.coefficient,cat.active_year,cat.name,l.group_code,l.total_group,cat.alias,l.categoryId,l.year,l.id as league_id FROM datateams dt INNER JOIN teams t ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories cat ON cat.id = l.categoryId WHERE dt.id = '121414' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0022  SELECT SQL_NO_CACHE res.id as id, res.group_code, res.total_group, res.logo, res.alias FROM (SELECT ct.active_year, ct.id as id, l.year, l.end,l.group_code, l.total_group, ct.logo, ct.alias FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId AND ct.active_year=l.year INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId = '121414' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0026  SELECT t.id as team_id, ct.id, l.id as idLeague, l.year, ct.name, l.start_date, l.end_date FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId=121414 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0020  SELECT ct.id, ct.alias, ct.name AS name, ct.active_year, ct.coefficient AS coefficient, l.id AS league_id, l.year, l.total_group FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId WHERE l.id IN (75230,74958,74303,71993) ORDER BY ct.ctype != 12 DESC, ct.troncal DESC, ct.coefficient DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, ct.coefficient DESC, l.group_code ASC
0.0024  SELECT count(id) as num_players from rel_players WHERE league_id = 74958 AND teamId = 121414
0.0022  SELECT count(id) as num_players from rel_players WHERE league_id = 71993 AND teamId = 121414
0.0024  SELECT count(id) as num_players from rel_players WHERE league_id = 75230 AND teamId = 121414
0.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 74303 AND teamId = 121414
0.0023  SELECT p.* FROM `rel_pictures` as rp INNER JOIN `pictures` as p ON p.id = rp.id_picture INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '121414' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '121414' and rp.type = 4
0.0021  SELECT p.* FROM `rel_videos` as rp INNER JOIN `videos` as p ON p.id = rp.id_video INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '121414' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0035  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 74958 WHERE rp.league_id = 74958 AND rp.teamId = 121414 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0031  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 74958 WHERE rp.league_id = 74958 AND rp.teamId = 121414 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0025  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 74958 WHERE rp.league_id = 74958 AND rp.teamId = 121414 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0023  SELECT l.id,t.league_id,l.legend,l.year,c.name,l.total_teams,c.alias,l.group_code,l.total_group,l.current_round, l.table_suffix FROM teams t INNER JOIN leagues l ON t.league_id = l.id INNER JOIN categories c ON c.id = l.categoryId WHERE c.troncal = 1 AND t.teamId = 121414 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0022  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 `tables2023` 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 = 70905 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
0.0024  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 `tables2023` 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 = 71993 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
0.0022  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 `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
0.0025  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 `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 = 66308 AND t.round = 15 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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 `tables2021` 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 = 60997 AND t.round = 15 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 `tables2021` 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 = 63326 AND t.round = 15 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 `tables2020` 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 = 53797 AND t.round = 17 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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 `tables2020` 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 = 53812 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.0024  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 = 48674 AND t.round = 15 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC