4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Recoleta

Recoleta

Entrenador: Luis Landeros

Temporada 2023/2024
TEMPORADA 2023/2024
PRIMERA B CHILE
Equipo PJ GF GC Puntos
1 Rangers Talca Rangers 10 14 7 22
2 La Serena La Serena 10 13 7 22
3 Deportes Limache Deportes 9 19 8 19
4 Barnechea Barnechea 10 18 12 18
5 Antofagasta Antofagasta 10 16 12 16
6 Magallanes Magallanes 10 14 11 16
7 Deportes Santa Cruz Deportes 10 17 17 16
8 Recoleta Recoleta 10 12 14 15
9 Santiago Morning Santiago 9 13 11 13
10 San Luis de Quillota Luis 8 15 17 13
11 San Marcos Arica Marcos Arica 10 14 15 12
12 Santiago Wanderers Santiago 9 13 15 11
13 Deportes Temuco Deportes 10 9 15 10
14 Univ. Concepción Univ. 9 7 15 9
15 Curicó Unido Curicó 10 7 14 8
16 Unión San Felipe Unión 10 10 21 3
TEMPORADA 2022/2023
PRIMERA B CHILE GRUPO 1
Equipo PJ GF GC Puntos
1 Cobreloa Cobreloa 30 41 30 54
2 Deportes Iquique Deportes 30 54 39 52
3 Santiago Wanderers Santiago 30 37 28 51
4 Deportes Temuco Deportes 30 39 36 50
5 Antofagasta Antofagasta 30 50 38 46
6 San Luis de Quillota Luis 30 43 31 44
7 La Serena La Serena 30 38 39 44
8 Unión San Felipe Unión 30 40 34 41
9 Barnechea Barnechea 30 40 41 41
10 San Marcos Arica Marcos Arica 30 51 52 40
11 Rangers Talca Rangers 30 35 47 36
12 Santiago Morning Santiago 30 32 38 34
13 Univ. Concepción Univ. 30 36 49 34
14 Deportes Santa Cruz Deportes 30 27 36 33
15 Recoleta Recoleta 30 34 43 30
16 Puerto Montt Puerto Montt 30 25 41 30
TEMPORADA 2021/2022
PRIMERA B CHILE
Equipo PJ GF GC Puntos
1 Magallanes Magallanes 32 61 23 72
2 Cobreloa Cobreloa 32 41 24 68
3 Deportes Copiapó Deportes 32 46 34 52
4 Unión San Felipe Unión 32 38 35 52
5 Puerto Montt Puerto Montt 32 36 31 47
6 Univ. Concepción Univ. 32 42 34 46
7 Rangers Talca Rangers 32 39 40 46
8 Barnechea Barnechea 32 47 43 44
9 Santiago Wanderers Santiago 32 37 37 42
10 Deportes Temuco Deportes 32 31 41 38
11 Deportes Santa Cruz Deportes 32 34 39 36
12 Deportes Iquique Deportes 32 31 38 35
13 Recoleta Recoleta 32 34 41 34
14 Santiago Morning Santiago 32 37 47 34
15 San Luis de Quillota Luis 32 27 42 34
16 CD Melipilla Melipilla 32 30 49 30
17 Fernández Vial Fernández 32 26 39 26
TEMPORADA 2020/2021
SEGUNDA CHILE
Equipo PJ GF GC Puntos
1 Recoleta Recoleta 22 38 24 48
2 CDSC Iberia CDSC Iberia 22 34 26 40
3 Deportes Limache Deportes 22 36 22 35
4 Independiente Cauquenes Independient 22 38 32 32
5 Lautaro de Buin Lautaro Buin 22 32 30 32
6 General Velásquez General 22 33 33 31
7 San Antonio Unido Antonio 22 34 36 30
8 Deportes Valdivia Deportes 22 29 27 27
9 Rodelindo Román Rodelindo 22 23 34 27
10 Concepción Concepción 22 22 29 23
11 Colina Colina 22 19 31 19
12 Colchagua Colchagua 22 23 37 18
TEMPORADA 2019/2020
SEGUNDA CHILE
Equipo PJ GF GC Puntos
1 Lautaro de Buin Lautaro Buin 22 36 18 47
2 Fernández Vial Fernández 22 37 19 45
3 Recoleta Recoleta 22 44 34 37
4 General Velásquez General 22 29 22 33
5 Colchagua Colchagua 22 23 28 29
6 CDSC Iberia CDSC Iberia 22 27 24 28
7 San Antonio Unido Antonio 22 23 25 28
8 Independiente Cauquenes Independient 22 24 27 28
9 Colina Colina 22 30 39 25
10 Deportes Vallenar Deportes 22 17 30 23
11 Concepción Concepción 22 23 30 21
12 Linares Unido Linares 22 19 36 18
TEMPORADA 2018/2019
SEGUNDA CHILE GRUPO 2
Equipo PJ GF GC Puntos
1 San Marcos Arica Marcos Arica 6 8 4 17
2 Colchagua Colchagua 6 9 5 16
3 Recoleta Recoleta 6 11 12 10
4 Deportes Vallenar Deportes 6 6 7 10
5 General Velásquez General 6 5 7 9
6 CDSC Iberia CDSC Iberia 6 9 13 7
TEMPORADA 2017/2018
TORNEO TRANSICIÓN SEGUNDA CHILE GRUPO 3
Equipo PJ GF GC Puntos
1 San Antonio Unido Antonio 8 10 7 16
2 Fernández Vial Fernández 8 8 7 14
3 Deportes Vallenar Deportes 8 11 15 14
4 Recoleta Recoleta 8 7 7 12
5 Malleco Unido Malleco 8 10 10 11
TEMPORADA 2016/2017
TORNEO TRANSICIÓN SEGUNDA CHILE
Equipo PJ GF GC Puntos
1 Deportes Vallenar Deportes 20 26 16 38
2 Naval de Talcahuano Naval 20 24 18 32
3 Deportes Santa Cruz Deportes 20 25 20 31
4 San Antonio Unido Antonio 20 25 23 30
5 Recoleta Recoleta 20 27 23 28
6 Malleco Unido Malleco 20 31 26 27
7 Colchagua Colchagua 20 23 26 27
8 CD Melipilla Melipilla 20 27 26 26
9 Independiente Cauquenes Independient 20 22 24 24
10 Deportes Pintana Deportes 20 17 30 20
11 CD Provincial Osorno Provincial 20 12 27 16
TEMPORADA 2015/2016
TERCERA A CHILE
Equipo PJ GF GC Puntos
1 CD Provincial Osorno Provincial 28 56 30 59
2 Real San Joaquín Real 28 60 34 57
3 Recoleta Recoleta 28 64 47 56
4 Fernández Vial Fernández 28 60 42 50
5 Lautaro de Buin Lautaro Buin 28 56 42 48
6 Estación Central Estación 28 49 40 46
7 Deportes Rengo Deportes 28 55 59 42
8 Deportes Limache Deportes 28 41 47 37
9 Colina Colina 28 34 39 36
10 General Velásquez General 28 47 47 35
11 Chimbarongo Chimbarongo 28 43 48 32
12 Gasparín FC Gasparín 28 38 48 31
13 Tomás Greig Tomás Greig 28 45 54 30
14 Provincial Talagante Provincial 28 49 57 26
15 Juventud Salvador Juventud 28 22 85 6

  USO DE MEMORIA  
5,735,872 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.5257
Total Execution Time  0.5270
  CADENA URL  
/historico/Deportes-Recoleta
  GET DATOS  
$_GET['/historico/Deportes-Recoleta']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (26)  
0.0148  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=88936 AND type_rel = 2
0.0154  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 88936 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0151  SELECT /*35 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 (688361) ORDER BY n.cover_points DESC, update_date DESC
0.0166  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 = '88936' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0157  SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 75087 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0163  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=88936 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0153  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 (75877,75087) 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.0151  SELECT count(id) as num_players from rel_players WHERE league_id = 75087 AND teamId = 88936
0.0146  SELECT count(id) as num_players from rel_players WHERE league_id = 75877 AND teamId = 88936
0.0149  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 = '88936' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0146  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '88936' and rp.type = 4
0.0147  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 = '88936' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0160  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 = 75087 WHERE rp.league_id = 75087 AND rp.teamId = 88936 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.0153  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 = 75087 WHERE rp.league_id = 75087 AND rp.teamId = 88936 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0150  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 = 75087 WHERE rp.league_id = 75087 AND rp.teamId = 88936 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0148  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 = 88936 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0150  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 = 70890 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0294  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 = 66687 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0161  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 = 62761 AND t.round = 22 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0161  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 = 55634 AND t.round = 22 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0160  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 = 49421 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0157  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 = 51224 AND t.round = 10 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0159  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 `tables2018` 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 = 43305 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0158  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 `tables2018` 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 = 45187 AND t.round = 10 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0160  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 `tables2017` 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 = 39322 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0165  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 `tables2016` 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 = 15514 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC