4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Información
  • Nombre del equipo Magallanes
  • Nombre completo Club Deportivo Magallanes
  • Nombre corto MAG
  • País Chile
  • Ciudad Santiago de Chile, Región Metropolitana
  • URL del equipo en RF //m.resultados-futbol.com/Magallanes
Otros Datos
  • Año de Fundación 1897
  • Patrocinador Besalco
  • Patrocinador Secundario Entel
  • Marca de Ropa Dalponte
  • Lugar de entrenamiento Complejo Deportivo Club Magallanes, Malloco
Internet

Información sobre el estadio

  • Nombre del estadio Municipal de San Bernardo
  • Capacidad 3500
  • Dirección O´ Higgins 370
  • Año de construcción 1985
Municipal de San Bernardo

Partidos del Magallanes

Ir al LIVESCORE
11 Ago 24  en 3 meses Magallanes
-
Santiago Wanderers 0
04 Ago 24  en 3 meses Santiago Morning
-
Magallanes 0
31 Jul 24  en 3 meses Magallanes
-
Univ. Concepción 0
28 Jul 24  en 3 meses Deportes Temuco
-
Magallanes 0
21 Jul 24  en 3 meses Magallanes
-
La Serena 0
14 Jul 24  en 2 meses Rangers Talca
-
Magallanes 0
03 Jun 24  en 1 mes San Luis de Quillota
02:00
Magallanes 1
25 May 24  en 1 mes Magallanes
21:00
Unión San Felipe 0
19 May 24  en 1 mes Antofagasta
18:30
Magallanes 0
11 May 24  en 22 días Magallanes
21:00
Deportes Limache 0
07 May 24  en 17 días Barnechea
02:30
Magallanes 0
28 Abr 24  en 9 días Recoleta
18:30
Magallanes 0
20 Abr 24  en 1 día Magallanes
18:30
San Marcos Arica 0
16 Abr 24  Finalizado Tarjeta RojaCuricó Unido
0 - 0
Magallanes 77
07 Abr 24  Finalizado Magallanes
4 - 1
Deportes Santa CruzTarjeta Roja 3
31 Mar 24  Finalizado Santiago Wanderers
2 - 3
Magallanes 8
24 Mar 24  Finalizado Magallanes
2 - 1
Santiago Morning 18
19 Mar 24  Finalizado Tarjeta RojaUniv. Concepción
2 - 1
Magallanes 104
09 Mar 24  Finalizado Magallanes
3 - 1
Deportes Temuco 10
02 Mar 24  Finalizado La Serena
1 - 0
Magallanes 2
24 Feb 24  Finalizado Magallanes
0 - 1
Rangers TalcaTarjeta Roja 7

Plantilla del Magallanes Temporada 2023/2024

Jugador Edad Origen Altura Peso Goles Tarjetas rojas Tarjetas amarillas
Portero
25 27 cl 185 82 - - -
1 39 cl 183 80 - - -
23 uy 187 80 - - -
Defensa
18 33 uy 189 89 - - 2
29 19 cl - - 1 - 3
22 cl - - - - -
14 24 cl 178 74 - - 1
2 28 py 178 68 - - -
4 21 cl 180 81 - - 2
5 30 cl 182 70 - - 2
22 cl - - - - -
24 28 cl 170 72 1 - 2
Centrocampista
26 20 cl - - - - -
23 35 cl 174 69 2 - 1
6 25 cl 175 - - - 3
20 26 cl 171 70 - - 2
20 cl - - - - -
11 28 uy 175 68 - - 1
21 23 cl 170 68 1 - 2
10 27 cl 175 78 - - 2
22 26 cl 171 68 1 - 1
Delantero
28 19 cl 180 - - - -
22 cl - - - - -
30 20 cl - - - - -
7 22 cl 176 63 - - -
9 39 ar 186 82 7 - 3
8 24 cl 167 64 - - -
17 25 cl 162 - - - -
16 21 cl - - - - -

Noticias del Magallanes

Ver últimas noticias

"Ahora soy un león herido; en Audax parecía un viejo lisiado"

Sebastián Abreu fue presentado oficialmente como jugador de Magallanes, club de la Primera B Chilena, que será el 27º equipo en el que milite el atacante.

Abreu agrandará su leyenda jugando en su club número 27

Acabó su etapa en Audax Italiano, donde se le reconoció como el futbolista profesional que ha militado en más clubes de la historia, con 26, pero 'el Loco' está lejos de retirarse. Magallanes, de la Primera B chilena, será su próximo destino.

Unión Española refuerza su portería con Quezada

El guardameta José Antonio Quezada es el nuevo portero de Unión Española. Formado deportivamente en Palestino, firmó ya su vínculo con el club.

Magallanes empata 'in extremis' a Unión San Felipe

El conjunto 'albirrojo' se dejó sorprender por los 'albicelestes' en el último minuto del choque merced al tanto de Cisternas (1-1). En la clasificación se sitúan en sexta y octava posición, respectivamente.

Un futbolista chileno se tatúa los escudos de sus 16 ex equipos

Leo Monje es un trotamundos del fútbol chileno. En 16 años de carrera profesional ha militado en otros tantos equipos. Y ha decidido grabárselos todos sobre su piel.




  USO DE MEMORIA  
5,456,808 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.4020
Total Execution Time  0.4040
  CADENA URL  
/magallanes
  GET DATOS  
$_GET['/magallanes']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (24)  
0.0155  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 = '9138' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0125  (SELECT cat.id as category_id, cat.logo, l.id,cat.alias,cat.name,l.group_code,l.total_group,cat.CountryCode,max(c.shedule) ult_partido,min(c.shedule) ini_partido,cat.coefficient FROM leagues l INNER JOIN categories as cat ON cat.id = l.categoryId INNER JOIN calendars2024 as c ON c.league_id = l.id WHERE (c.datateam1 = 9138 or c.datateam2 = 9138) AND ABS(UNIX_TIMESTAMP(c.shedule)-UNIX_TIMESTAMP())<120*3600*24 AND l.year = 2024 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0144  (SELECT cat.id as category_id, l.year,cat.coefficient,c.extra,c.datateam1,c.datateam2,c.id as mid,c.r1,c.r2,c.shedule,c.team1,c.team2,l.id,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1,dt2.basealias as basealias2,c.comments as totalcomments FROM leagues l INNER JOIN categories as cat ON cat.id = l.categoryId INNER JOIN calendars2024 as c ON c.league_id = l.id INNER JOIN teams t1 ON t1.id = c.team1 INNER JOIN teams t2 ON t2.id = c.team2 INNER JOIN datateams dt1 ON dt1.id = t1.teamId INNER JOIN datateams dt2 ON dt2.id = t2.teamId WHERE (c.datateam1 = 9138 or c.datateam2 = 9138) AND ABS(UNIX_TIMESTAMP(c.shedule)-UNIX_TIMESTAMP())<120*3600*24 AND l.year = 2024 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0129  (SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars2024 as c ON c.league_id = l.id INNER JOIN events2024 as e ON e.team1id = c.team1 AND e.team2id = c.team2 AND (e.action = 3 OR e.action = 4) INNER JOIN rel_players rel ON rel.player_id = e.player_id AND rel.in_squad = 1 AND rel.league_id = e.league_id AND rel.in_squad = 1 WHERE (c.datateam1 = 9138 or c.datateam2 = 9138) AND ABS(UNIX_TIMESTAMP(c.shedule)-UNIX_TIMESTAMP())<120*3600*24 AND l.year = 2024)
0.0126  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=9138 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0108  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,71432,71366,71182,71148,70762,70690) 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.0110  SELECT count(id) as num_players from rel_players WHERE league_id = 70762 AND teamId = 9138
0.0108  SELECT count(id) as num_players from rel_players WHERE league_id = 75087 AND teamId = 9138
0.0108  SELECT count(id) as num_players from rel_players WHERE league_id = 71148 AND teamId = 9138
0.0107  SELECT count(id) as num_players from rel_players WHERE league_id = 71366 AND teamId = 9138
0.0110  SELECT count(id) as num_players from rel_players WHERE league_id = 71182 AND teamId = 9138
0.0109  SELECT count(id) as num_players from rel_players WHERE league_id = 70690 AND teamId = 9138
0.0111  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 9138
0.0116  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 = 9138 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.0114  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 = 9138 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0112  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 = 9138 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0110  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 = 9138 AND rp.league_id = 75087 AND l.year= 2024 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0111  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=6626748 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC, dp.id
0.0105  SELECT rp.player_id, rp.pj, rp.lineup FROM rel_players AS rp WHERE rp.team_id=6626748
0.0111  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=6626748 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.0110  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=6626748 and (e.action = 4 or e.action = 5) GROUP BY dp.id ORDER BY cuenta DESC
0.0109  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=6626748 and (e.action = 3 or e.action = 4) GROUP BY dp.id ORDER BY cuenta DESC
0.0108   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=6626748 AND (e.action = 22) GROUP BY dp.id ORDER BY cuenta DESC
0.0110  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=6626748 and (e.action = 19) GROUP BY dp.id ORDER BY cuenta DESC