4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Central Cordoba SdE II
TEMPORADA 2022/2023
TORNEO PROYECCIÓN
Equipo PJ GF GC Puntos
1 Vélez Sarsfield II Vélez 27 59 16 68
2 Belgrano II Belgrano II 27 40 20 54
3 Racing Club II Racing Club 27 33 25 52
4 River Plate II River Plate 27 44 29 51
5 Lanús II Lanús II 27 35 29 47
6 Argentinos Juniors II Argentinos 27 40 23 45
7 Talleres Córdoba II Talleres 27 41 35 45
8 San Lorenzo II Lorenzo 27 29 25 45
9 Independiente II Independient 27 43 28 43
10 Tigre II Tigre II 27 37 25 43
11 Rosario Central II Rosario 27 45 37 42
12 Newells Old Boys II Newells Boys 27 30 19 39
13 Estudiantes La Plata II Estudiantes 27 32 27 39
14 Boca Juniors II Boca Juniors 27 26 21 39
15 Defensa y Justicia II Defensa 27 41 40 35
16 Banfield II Banfield II 27 31 39 35
17 CA Huracán II Huracán 27 32 34 34
18 Instituto AC Córdoba II Instituto 27 29 33 34
19 Colón II Colón II 27 23 33 34
20 Central Cordoba SdE II Central 27 34 52 31
21 Platense II Platense II 27 27 40 30
22 Arsenal de Sarandí II Arsenal 27 26 33 26
23 Sarmiento II Sarmiento 27 26 36 26
24 Unión Santa Fe II Unión Santa 27 32 46 26
25 Gimnasia La Plata II Gimnasia 27 23 39 26
26 Atl. Tucumán II Atl. 27 27 50 24
27 Barracas Central II Barracas 27 23 40 23
28 Godoy Cruz II Godoy Cruz 27 18 52 14
TEMPORADA 2021/2022
TORNEO PROYECCIÓN
Equipo PJ GF GC Puntos
1 Boca Juniors II Boca Juniors 27 48 20 57
2 Vélez Sarsfield II Vélez 27 49 18 56
3 Tigre II Tigre II 27 33 25 48
4 CA Huracán II Huracán 27 52 41 45
5 Newells Old Boys II Newells Boys 27 37 27 44
6 River Plate II River Plate 27 31 29 44
7 Gimnasia La Plata II Gimnasia 27 48 34 43
8 Independiente II Independient 27 39 31 43
9 Argentinos Juniors II Argentinos 27 36 28 43
10 Lanús II Lanús II 27 41 41 42
11 Rosario Central II Rosario 27 51 36 41
12 Defensa y Justicia II Defensa 27 27 32 38
13 Talleres Córdoba II Talleres 27 42 40 37
14 San Lorenzo II Lorenzo 27 33 34 37
15 Unión Santa Fe II Unión Santa 27 24 25 36
16 Colón II Colón II 27 35 40 36
17 Racing Club II Racing Club 27 37 33 33
18 Godoy Cruz II Godoy Cruz 27 34 35 33
19 Platense II Platense II 27 25 26 33
20 Banfield II Banfield II 27 25 32 32
21 Estudiantes La Plata II Estudiantes 27 24 29 31
22 Arsenal de Sarandí II Arsenal 27 24 26 30
23 Central Cordoba SdE II Central 27 25 37 30
24 Sarmiento II Sarmiento 27 21 38 30
25 Atl. Tucumán II Atl. 27 30 44 26
26 Aldosivi II Aldosivi II 27 37 56 25
27 Patronato II Patronato 27 21 40 25
28 Barracas Central II Barracas 27 18 50 23
TEMPORADA 2020/2021
TORNEO PROYECCIÓN
Equipo PJ GF GC Puntos
1 Boca Juniors II Boca Juniors 25 63 23 52
2 Colón II Colón II 25 28 16 47
3 Rosario Central II Rosario 25 49 30 45
4 Gimnasia La Plata II Gimnasia 25 44 32 45
5 Platense II Platense II 25 42 31 42
6 Argentinos Juniors II Argentinos 25 33 26 40
7 Estudiantes La Plata II Estudiantes 25 38 34 39
8 Lanús II Lanús II 25 36 31 36
9 Vélez Sarsfield II Vélez 24 31 29 36
10 Newells Old Boys II Newells Boys 25 31 28 35
11 Atl. Tucumán II Atl. 25 27 25 32
12 San Lorenzo II Lorenzo 25 29 31 32
13 Independiente II Independient 25 23 25 32
14 Sarmiento II Sarmiento 25 34 39 32
15 River Plate II River Plate 25 30 35 32
16 Talleres Córdoba II Talleres 24 26 27 30
17 Arsenal de Sarandí II Arsenal 25 23 27 30
18 Godoy Cruz II Godoy Cruz 25 25 32 30
19 Banfield II Banfield II 25 27 36 30
20 Defensa y Justicia II Defensa 25 28 37 29
21 Racing Club II Racing Club 25 29 35 27
22 Aldosivi II Aldosivi II 25 25 33 27
23 CA Huracán II Huracán 25 20 30 27
24 Patronato II Patronato 25 29 42 26
25 Unión Santa Fe II Unión Santa 25 21 33 23
26 Central Cordoba SdE II Central 25 21 45 19
TEMPORADA 2019/2020
TORNEO PROYECCIÓN
Equipo PJ GF GC Puntos
1 Lanús II Lanús II 23 41 25 46
2 Independiente II Independient 23 32 20 41
3 River Plate II River Plate 23 42 20 40
4 Estudiantes La Plata II Estudiantes 23 29 21 40
5 Boca Juniors II Boca Juniors 23 32 18 39
6 Vélez Sarsfield II Vélez 23 38 27 39
7 Arsenal de Sarandí II Arsenal 23 29 26 35
8 Gimnasia La Plata II Gimnasia 23 29 27 35
9 San Lorenzo II Lorenzo 23 31 25 33
10 Defensa y Justicia II Defensa 23 25 25 30
11 Banfield II Banfield II 23 31 32 30
12 Argentinos Juniors II Argentinos 23 28 32 30
13 Godoy Cruz II Godoy Cruz 23 28 26 29
14 Patronato II Patronato 23 26 27 29
15 Racing Club II Racing Club 23 18 27 29
16 Unión Santa Fe II Unión Santa 23 25 27 27
17 Talleres Córdoba II Talleres 23 27 33 27
18 Newells Old Boys II Newells Boys 23 30 32 26
19 CA Huracán II Huracán 23 30 34 26
20 Central Cordoba SdE II Central 23 30 38 26
21 Rosario Central II Rosario 23 24 35 26
22 Colón II Colón II 23 29 31 25
23 Atl. Tucumán II Atl. 23 21 35 17
24 Aldosivi II Aldosivi II 23 16 48 14

  USO DE MEMORIA  
5,669,528 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0014
Controller Execution Time ( Home / Category )  0.0773
Total Execution Time  0.0787
  CADENA URL  
/historico/Club-Atletico-Central-Cordoba-Sde-B
  GET DATOS  
$_GET['/historico/Club-Atletico-Central-Cordoba-Sde-B']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (17)  
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=123343 AND type_rel = 2
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2169 AND type_rel = 3
0.0024  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 = '123343' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0024  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=123343 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 (75197,70911) 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.0027  SELECT count(id) as num_players from rel_players WHERE league_id = 70911 AND teamId = 123343
0.0029  SELECT count(id) as num_players from rel_players WHERE league_id = 75197 AND teamId = 123343
0.0020  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 = '123343' 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 = '123343' 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 = '123343' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0036  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 = 75197 WHERE rp.league_id = 75197 AND rp.teamId = 123343 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.0033  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 = 75197 WHERE rp.league_id = 75197 AND rp.teamId = 123343 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 = 75197 WHERE rp.league_id = 75197 AND rp.teamId = 123343 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0021  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 = 123343 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0040  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 = 70911 AND t.round = 27 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 `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 = 67747 AND t.round = 27 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 = 63375 AND t.round = 25 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC