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

Macarthur FC

Entrenador: Mile Sterjovski

Información
  • Nombre del equipo Macarthur FC
  • Nombre completo Macarthur South West Sydney
  • Nombre corto MFC
  • País Australia
  • Entrenador Mile Sterjovski
  • URL del equipo en RF //m.resultados-futbol.com/Macarthur-Fc
Internet

Información sobre el estadio

  • Nombre del estadio Campbelltown Stadium
  • Capacidad 20
Campbelltown Stadium

Histórico de participación

Partidos del Macarthur FC

Ir al LIVESCORE
20 Jun 21  Finalizado Melbourne City
2 - 0
Macarthur FC 13
12 Jun 21  Finalizado Central Coast Mariners
0 - 2
Macarthur FCTarjeta Roja 15
04 Jun 21  Finalizado Tarjeta RojaMacarthur FC
0 - 3
Wellington PhoenixTarjeta Roja 95
31 May 21  Finalizado Western United FC
1 - 2
Macarthur FC 73
27 May 21  Finalizado Macarthur FC
1 - 2
Central Coast Mariners 68
23 May 21  Finalizado Perth Glory
1 - 1
Macarthur FC 9
14 May 21  Finalizado Macarthur FC
3 - 1
Melbourne Victory 45
06 May 21  Finalizado Melbourne Victory
1 - 2
Macarthur FC 38
01 May 21  Finalizado Perth Glory
0 - 0
Macarthur FC 14
24 Abr 21  Finalizado Macarthur FC
1 - 1
Melbourne City 34
18 Abr 21  Finalizado Macarthur FC
2 - 2
Newcastle Jets 19
14 Abr 21  Finalizado Adelaide United
3 - 1
Macarthur FC 41
09 Abr 21  Finalizado Macarthur FC
1 - 2
Brisbane Roar 7
02 Abr 21  Finalizado Macarthur FC
2 - 0
Perth Glory 27
28 Mar 21  Finalizado Wellington Phoenix
0 - 1
Macarthur FC 9
20 Mar 21  Finalizado Macarthur FC
2 - 1
Western United FC 7
12 Mar 21  Finalizado Melbourne City
3 - 0
Macarthur FC 22
08 Mar 21  Finalizado Central Coast Mariners
2 - 0
Macarthur FC 13
28 Feb 21  Finalizado Tarjeta RojaSydney FC
0 - 1
Macarthur FC 6
20 Feb 21  Finalizado Western United FC
4 - 1
Macarthur FC 25
12 Feb 21  Finalizado Macarthur FC
4 - 0
Adelaide United 12
09 Feb 21  Finalizado Brisbane Roar
0 - 2
Macarthur FC 50
06 Feb 21  Finalizado Macarthur FC
2 - 2
Western Sydney Wanderers 28
30 Ene 21  Finalizado Tarjeta RojaMacarthur FC
0 - 3
Sydney FC 26
17 Ene 21  Finalizado Newcastle Jets
1 - 2
Macarthur FC 2
09 Ene 21  Finalizado Tarjeta RojaMacarthur FC
1 - 1
Wellington PhoenixTarjeta Roja 5
03 Ene 21  Finalizado Macarthur FC
0 - 2
Central Coast Mariners 13
30 Dic 20  Finalizado Western Sydney Wanderers
0 - 1
Macarthur FC 51
08 Dic 21  Finalizado Sydney FC
2 - 0
Macarthur FCTarjeta Roja 6
13 Nov 21  Finalizado Newcastle Olympic
0 - 3
Macarthur FC 0

Plantilla del Macarthur FC Temporada 2020/2021

Jugador Edad Origen Altura Peso Goles Tarjetas rojas Tarjetas amarillas
Portero
1 39 au 188 90 - - 1
16 24 au 197 77 - - -
20 23 au - - - - -
Defensa
3 33 au 188 88 - - 3
6 34 au 196 85 1 - 2
15 28 au 192 81 1 - 7
7 36 au 180 77 - - 3
2 29 au 184 73 - - -
12 36 au 185 73 2 - -
31 24 au - - - - -
23 24 au 176 70 - - -
Centrocampista
29 23 cy 169 - - - 4
4 37 es 179 72 1 - 2
24 26 tz 174 - 1 - 2
8 24 au 175 75 2 - 6
21 22 au 180 67 - - 3
10 35 fr 181 73 2 1 1
22 27 au 175 73 - - 2
5 38 au 180 80 2 1 4
33 36 es 179 68 5 - 1
Delantero
17 25 au 182 70 - - -
31 24 au 170 - 1 - 1
27 38 gb 180 72 14 - 7
9 27 au 190 - - - 1
19 21 au 180 - 1 - 3
14 23 au 185 - - - 1
11 32 au 170 64 - - -

Noticias de Liga Australiana

Ver últimas noticias

Josh Cavallo le pide matrimonio a su novio en el estadio del Adelaide

Joshua Cavallo, que, hace dos años, anunció en público su homosexualidad, le pidió matrimonio a su novio esta semana en el estadio del Adelaide United. Desde que dio a conocer que es gay, ha recibido infinidad de insultos y amenazas, pero también el apoyo de su club y de infinidad de referentes del deporte rey. De hecho, su propio club colaboró en el enlace con su pareja, que, ahora, se afianza.

El Istanbul Basaksehir se une al City Football Group

El Istanbul Basaksehir anunció que ha llegado a un acuerdo con el City Football Group, que opera con clubes como el Manchester City o el Girona bajo su propiedad, en calidad de socio para "estrategia futbolística, planificación y sostenibilidad a largo plazo". La plataforma, de dueños emiratíes, enjuaga así sus relaciones institucionales con Turquía en un nivel diplomático para sus magnates y a uno deportivo para los integrantes de su estructura futbolística.

Cavallo, amenazado de muerte dos años después de anunciar su homosexualidad

Josh Cavallo se convirtió en el primer futbolista profesional en anunciar su homosexualidad. Lo hizo hace casi dos años y, en la actualidad, aún recibe insultos y amenazas de muerte de manera continuada. "No es aceptable, es algo desagradable, pero al mismo tiempo sé que he abierto el camino para muchos otros", afirmó.

La historia de Rahmat Akbari: de refugiado en Pakistán a triunfar en Australia

Rahmat Akbari, jugador del Brisbane Roar, concedió una entrevista a 'A-Leagues All Access' para hablar de su complicada infancia hasta convertirse futbolista profesional. "Emigré a Pakistán por la guerra y llegué a Australia sin nada", afirmó.

La escalofriante lesión de Juande en la Liga Australiana

El centrocampista español del Adelaide United Juan de Dios Prados sufrió una desagradable lesión en el encuentro contra el Melbourne City en la jornada 14 de la Liga Australiana. El futbolista tuvo que ser trasladado en ambulancia después de romperse la tibia en un lance del juego.




  USO DE MEMORIA  
5,517,984 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0029
Controller Execution Time ( Home / Category )  3.4975
Total Execution Time  3.5003
  CADENA URL  
/macarthur-fc/2021
  GET DATOS  
$_GET['/macarthur-fc/2021']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (38)  
0.0018  SELECT type FROM routes WHERE alias = 'macarthur-fc'
0.1202  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 = 'macarthur-fc' AND l.year = 2021 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.0018  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=137995 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=137995 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=137995 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=137995 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0342  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 60104
0.0422  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 63005
0.0067  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 63101
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=137995 AND type_rel = 2
0.1213  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 = '137995' AND l.year = 2021 ORDER BY l.year DESC,cat.coefficient DESC
0.0940  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 = '137995' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0164  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 = 63101 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0578  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 = 60104 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0043  (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 calendars2021 as c ON c.league_id = l.id WHERE (c.datateam1 = 137995 or c.datateam2 = 137995) AND l.year = 2021 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.3606  (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 calendars2021 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 = 137995 or c.datateam2 = 137995) AND l.year = 2021 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0641  (SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars2021 as c ON c.league_id = l.id INNER JOIN events2021 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 = 137995 or c.datateam2 = 137995) AND l.year = 2021)
0.0816  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=137995 AND l.year in (2020,2021,2022) ORDER BY l.id DESC, l.year DESC ;
0.0019  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 (67537,63330,62807) 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.0923  SELECT count(id) as num_players from rel_players WHERE league_id = 63330 AND teamId = 137995
0.2066  SELECT count(id) as num_players from rel_players WHERE league_id = 67537 AND teamId = 137995
0.1381  SELECT count(id) as num_players from rel_players WHERE league_id = 62807 AND teamId = 137995
0.0659  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 60104 AND t.round = 24 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0056  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 = '137995' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0256  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '137995' and rp.type = 4
0.0097  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 = '137995' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.3323  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 events2021 e ON e.player_id = p.id AND e.league_id = 60104 WHERE rp.league_id = 60104 AND rp.teamId = 137995 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.1757  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 events2021 e ON e.player_id = p.id AND e.league_id = 60104 WHERE rp.league_id = 60104 AND rp.teamId = 137995 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.1427  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 events2021 e ON e.player_id = p.id AND e.league_id = 60104 WHERE rp.league_id = 60104 AND rp.teamId = 137995 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.1619  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 = 137995 AND rp.league_id = 60104 AND l.year= 2021 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.2638  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=6412660 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC, dp.id
0.0603  SELECT rp.player_id, rp.pj, rp.lineup FROM rel_players AS rp WHERE rp.team_id=6412660
0.1937  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 events2021 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6412660 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.2029  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 events2021 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6412660 and (e.action = 4 or e.action = 5) GROUP BY dp.id ORDER BY cuenta DESC
0.0226  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 events2021 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6412660 and (e.action = 3 or e.action = 4) GROUP BY dp.id ORDER BY cuenta DESC
0.1079   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 events2021 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6412660 AND (e.action = 22) GROUP BY dp.id ORDER BY cuenta DESC
0.0934  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 events2021 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6412660 and (e.action = 19) GROUP BY dp.id ORDER BY cuenta DESC
0.0762  SELECT dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 60104 ORDER BY nameShow LIMIT 100