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

¿Falta algún dato de este equipo?

Si tienes datos del equipo que no se encuentran en la página nos encantaría que los compartas con nosotros. Un editor de la página validará los datos y en el plazo de tiempo más breve posible completarán los datos actuales con los enviados.

Información sobre Deportes Limache

Enviar Datos
Información
Otros Datos
  • Marca de Ropa Penalty
Internet

Información sobre el estadio

  • Nombre del estadio Ángel Navarrete Candia
  • Capacidad 1500
Ángel Navarrete Candia

Histórico de participación

Tercera A Chile
10 veces
(2020, 2020, 2019, 2019, 2018, 2018, 2017, 2016, 2015, 2014)
Copa Chile
4 veces
(2023, 2022, 2021, 2019)
Segunda Chile
3 veces
(2023, 2022, 2021)
Primera B Chile
1 vez
(2024)

Partidos del Deportes Limache

Ir al LIVESCORE
Primera B Chile Primera B Chile »
25 Ago 24  en 3 meses Deportes Limache
-
 Recoleta 0
18 Ago 24  en 3 meses Curicó Unido
-
 Deportes Limache 0
11 Ago 24  en 3 meses Deportes Limache
-
 Unión San Felipe 0
04 Ago 24  en 3 meses Univ. Concepción
-
 Deportes Limache 0
31 Jul 24  en 3 meses Deportes Limache
-
 San Luis de Quillota 0
28 Jul 24  en 3 meses Rangers Talca
-
 Deportes Limache 0
21 Jul 24  en 2 meses Deportes Limache
-
 Deportes Temuco 0
14 Jul 24  en 2 meses Santiago Morning
-
 Deportes Limache 0
04 Jun 24  en 1 mes Deportes Limache
00:00
 Barnechea 1
27 May 24  en 29 días Deportes Santa Cruz
02:00
 Deportes Limache 0
21 May 24  en 23 días Deportes Limache
02:30
 San Marcos Arica 0
16 May 24  en 18 días Deportes Limache
01:00
 Santiago Morning 0
11 May 24  en 14 días Magallanes
21:00
 Deportes Limache 0
05 May 24  en 8 días Antofagasta
18:30
 Deportes Limache 0
30 Abr 24  en 2 días Deportes Limache
02:30
 La Serena 0
21 Abr 24  Finalizado Deportes Limache
2 - 2
 Santiago WanderersTarjeta Roja 14
12 Abr 24  Finalizado Recoleta
0 - 3
 Deportes Limache 38
06 Abr 24  Finalizado Deportes Limache
2 - 0
 Curicó Unido 6
29 Mar 24  Finalizado Unión San Felipe
2 - 3
 Deportes Limache 2
25 Mar 24  Finalizado Deportes Limache
0 - 1
 Univ. Concepción 33
16 Mar 24  Finalizado Tarjeta RojaSan Luis de Quillota
0 - 5
 Deportes Limache 12
08 Mar 24  Finalizado Deportes Limache
0 - 1
 Rangers Talca 24
02 Mar 24  Finalizado Deportes Temuco
2 - 3
 Deportes Limache 6

Plantilla del Deportes Limache Temporada 2023/2024

Jugador Edad Origen Altura Peso Goles Tarjetas rojas Tarjetas amarillas
Portero
12 21 cl - - - - -
25 35 ar 185 85 - - 4
1 25 cl - - - - -
Defensa
3 33 ar 185 - - - -
18 27 cl 174 - - - -
6 41 cl 174 72 - - -
13 19 cl 176 - 1 - -
4 26 cl 180 72 - - -
2 27 ar 185 73 2 - 3
27 18 - - - - -
Centrocampista
10 32 cl 174 70 - - 5
20 23 cl 178 73 - - 1
16 25 cl 173 74 - - 1
7 30 ar 166 68 4 - 1
5 38 cl 178 75 - - 2
21 cl - - - - -
21 24 ps - - - - -
14 24 cl 170 - - - -
8 30 cl 168 61 - - 3
19 cl 167 - - - -
19 cl - - - - -
15 25 cl - - - - -
20 ar - - - - -
Delantero
24 23 cl - - - - -
19 29 cl 176 64 2 - 2
17 37 cl 177 71 2 - -
11 26 cl 182 73 - - -
22 20 cl - - - - -
9 27 ar 187 87 5 - 2
23 27 cl 170 70 2 - -

Noticias de Primera B Chile

Ver últimas noticias

El 'Chupete' Suazo logró a los 42 años el 'hat trick' más veterano del siglo

BeSoccer Pro - Lunes, 11 Marzo 2024
5 7.790

El chileno se convirtió en el más veterano en lograr 3 goles o más en una cita de una de las dos primeras categorías en el siglo XXI de aquellos jugadores que han conseguido al menos un 75 de ELO y han logrado como poco 50 goles en su carrera. Lo logró para San Luis de Quillota contra Unión San Felipe (3-1) en la Primera B de Chile.

Actualidad del día en el fútbol chileno a 4 de junio de 2023

BeSoccer - Domingo, 04 Junio 2023
0 157

Estas son las noticias más destacadas de la jornada.

Actualidad del día en el fútbol chileno a 3 de junio de 2023

BeSoccer - Sábado, 03 Junio 2023
0 31

Estas son las noticias más destacadas del día 3 de junio de 2023 en lo que concierne al fútbol chileno.

Actualidad del día en el fútbol chileno a 2 de junio de 2023

BeSoccer - Viernes, 02 Junio 2023
0 22

Estas son las noticias más destacadas en el fútbol chileno a 2 de junio de 2023.

Iker Hernández, canterano y ex de la Real, ficha por Wanderers

BeSoccer - Viernes, 24 Junio 2022
1 2.292

Santiago Wanderers anunció este jueves el fichaje de Iker Hernández, jugador de 28 años y canterano de la Real Sociedad, con la que debutó en el primer equipo en la temporada 13-14.

Ver más noticias del equipo»



  USO DE MEMORIA  
5,224,488 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.4793
Total Execution Time  0.4812
  CADENA URL  
/Deportes-Limache/
  GET DATOS  
$_GET['/Deportes-Limache/']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (23)  
0.0144  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=64864 AND type_rel = 2
0.0144  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1970 AND type_rel = 3
0.0147  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 1970 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0147  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 (1305868,1259297,1259030,1258797,1154529) ORDER BY n.cover_points DESC, update_date DESC
0.0147  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 = '64864' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0146  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.0147  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=64864 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0145  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 (75087,71182,71103) 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.0147  SELECT count(id) as num_players from rel_players WHERE league_id = 75087 AND teamId = 64864
0.0146  SELECT count(id) as num_players from rel_players WHERE league_id = 71103 AND teamId = 64864
0.0147  SELECT count(id) as num_players from rel_players WHERE league_id = 71182 AND teamId = 64864
0.0148  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM `tables2024` 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 = 75087 AND t.round = 10 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0161  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 = 64864 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.0154  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 = 64864 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0149  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 = 64864 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0147  SELECT rp.team_id as teamId FROM rel_players AS rp inner join datateams as dt on rp.teamId=dt.id and rp.in_squad=1 INNER JOIN leagues as l ON l.id = rp.league_id WHERE dt.id = 64864 AND rp.league_id = 75087 AND l.year= 2024 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0149  SELECT dp.id, dp.nick, dp.name, dp.last_name, dp.alias, dp.role, dp.height,dp.weight,dp.foot,dp.side,dp.birthdate,IF(dp.birthdate != '0000-00-00 00:00:00', YEAR(CURDATE())-YEAR(dp.birthdate) + IF(DATE_FORMAT(CURDATE(),'%m-%d') > DATE_FORMAT(dp.birthdate,'%m-%d'), 0, -1) , NULL) as age,rp.squadNumber,rp.captain,IF(dp.CountryCode IS NULL,'',dp.CountryCode) AS CountryCode,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id and rp.in_squad=1 WHERE rp.team_id=6626747 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC, dp.id
0.0146  SELECT rp.player_id, rp.pj, rp.lineup FROM rel_players AS rp WHERE rp.team_id=6626747
0.0150  SELECT dp.id,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id INNER JOIN events2024 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6626747 and (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY dp.id ORDER BY cuenta DESC
0.0150  SELECT dp.id,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id INNER JOIN events2024 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6626747 and (e.action = 4 or e.action = 5) GROUP BY dp.id ORDER BY cuenta DESC
0.0148  SELECT dp.id,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id INNER JOIN events2024 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6626747 and (e.action = 3 or e.action = 4) GROUP BY dp.id ORDER BY cuenta DESC
0.0148   SELECT dp.id,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id INNER JOIN events2024 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6626747 AND (e.action = 22) GROUP BY dp.id ORDER BY cuenta DESC
0.0150  SELECT dp.id,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id INNER JOIN events2024 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6626747 and (e.action = 19) GROUP BY dp.id ORDER BY cuenta DESC