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

Wellington Phoenix

Entrenador: Giancarlo Italiano

Información
  • Nombre del equipo Wellington Phoenix
  • Nombre completo Wellington Phoenix Football Club
  • Nombre corto WPH
  • País Nueva Zelanda
  • Ciudad Wellington, Nueva Zelanda
  • Entrenador Giancarlo Italiano
  • URL del equipo en RF //m.resultados-futbol.com/Wellington-Phoenix
Otros Datos
  • Año de Fundación 2007
Internet

Información sobre el estadio

  • Nombre del estadio Westpac Stadium
  • Capacidad 34500
  • Dirección 105 Waterloo Quay, Wellington 6140
  • Teléfono +64 4-473 3881
  • Fax +64 (4) 801 8473
  • Año de construcción 2000
Westpac Stadium

Partidos del Wellington Phoenix

Ir al LIVESCORE
14 May 22  Finalizado Western United FC
1 - 0
Wellington Phoenix 28
09 May 22  Finalizado Melbourne City
2 - 1
Wellington Phoenix 21
05 May 22  Finalizado Western Sydney Wanderers
1 - 2
Wellington Phoenix 7
29 Abr 22  Finalizado Melbourne Victory
3 - 1
Wellington Phoenix 24
24 Abr 22  Finalizado Wellington Phoenix
1 - 0
Western Sydney Wanderers 32
17 Abr 22  Finalizado Wellington Phoenix
0 - 4
Central Coast Mariners 26
13 Abr 22  Finalizado Perth Glory
0 - 1
Wellington Phoenix 14
09 Abr 22  Finalizado Western United FC
1 - 4
Wellington Phoenix 49
05 Abr 22  Finalizado Central Coast Mariners
5 - 0
Wellington Phoenix 31
02 Abr 22  Finalizado Wellington Phoenix
0 - 6
Melbourne City 23
30 Mar 22  Finalizado Brisbane Roar
0 - 3
Wellington Phoenix 26
26 Mar 22  Finalizado Wellington Phoenix
2 - 1
Perth GloryTarjeta Roja 15
18 Mar 22  Finalizado Newcastle Jets
4 - 0
Wellington Phoenix 46
12 Mar 22  Finalizado Brisbane Roar
2 - 1
Wellington Phoenix 10
09 Mar 22  Finalizado Wellington Phoenix
3 - 2
Newcastle Jets 34
19 Feb 22  Finalizado Wellington Phoenix
1 - 1
Sydney FC 11
16 Feb 22  Finalizado Wellington Phoenix
3 - 0
Brisbane Roar 18
12 Feb 22  Finalizado Wellington Phoenix
1 - 1
Adelaide United 15
09 Feb 22  Finalizado Wellington Phoenix
1 - 0
Melbourne Victory 36
06 Feb 22  Finalizado Wellington Phoenix
3 - 1
Macarthur FC 6
21 Ene 22  Finalizado Wellington Phoenix
2 - 1
Western United FCTarjeta Roja 10
01 Ene 22  Finalizado Adelaide United
4 - 0
Wellington Phoenix 21
19 Dic 21  Finalizado Sydney FC
2 - 1
Wellington Phoenix 14
10 Dic 21  Finalizado Newcastle Jets
4 - 0
Wellington Phoenix 33
03 Dic 21  Finalizado Wellington Phoenix
0 - 2
Western Sydney Wanderers 46
27 Nov 21  Finalizado Wellington Phoenix
2 - 1
Central Coast Mariners 22
21 Nov 21  Finalizado Macarthur FC
1 - 1
Wellington Phoenix 9

Plantilla del Wellington Phoenix Temporada 2021/2022

Jugador Edad Origen Altura Peso Goles Tarjetas rojas Tarjetas amarillas
Portero
40 21 nz 183 76 - - -
30 19 nz 193 - - - -
20 28 nz 197 79 - - 2
Defensa
17 24 nz 175 64 - - 3
33 20 nz 190 - - - 1
5 26 nz 180 72 - - 1
21 26 au 185 83 - - 3
31 22 gb - - - - -
34 au 186 79 - - -
16 31 nz 174 70 - - 3
25 au - - - - -
3 23 mk 195 - - - -
4 32 gb 188 78 2 - 2
19 22 nz 175 71 1 - 2
38 gb 188 81 - - -
6 30 nz 179 73 - - 2
Centrocampista
14 27 nz 184 75 - - 3
23 27 nz 173 72 - - 2
34 21 nz 178 - - - -
12 23 au 191 - - - -
38 22 nz - - - - -
13 25 au 182 - 1 - 6
Delantero
18 22 nz 179 75 6 - 2
8 21 nz 172 - 1 - -
9 34 gb 183 75 2 - 7
88 36 gb 177 71 4 - 1
32 22 nz - - - - -
11 28 au 175 71 6 - 1
43 22 nz 183 - - - 1
10 25 au 170 69 4 - 2
36 22 nz - - - - -
7 28 mx 170 66 6 - 2

Noticias del Wellington Phoenix

Ver últimas noticias

Daniel Mullen, nuevo fichaje del Wellington Phoenix

Ya es oficial. Mullen será el nuevo refuerzo en la zaga del Wellington Phoenix la próxima temporada en el campeonato australiano. El defensor pasó las dos últimas temporadas y media en las filas del Newcastle Jets.

El Wellington Phoenix presenta a Vidosic

El equipo australiano ha presentado a su nuevo refuerzo. Se trata del delantero Dario Vidosic que llega después de miliar en el Seongnam.

Alex Gorrín firma por el Boavista

El jugador tinerfeño del Wellington Phoenix de Australia, Alex Gorrín, ha fichado por el club portugués del Boavista, que milita en la máxima categoría lusa.

El fútbol de Australia llama a un ex seleccionador de Inglaterra

La Liga de Australia podría tener a un nuevo entrenador, puesto que el Wellington Phoenix ha contactado con un técnico que perteneció al combinado de Inglaterra.

Regalo por Navidad en forma de cantada bajo la portería

Glen Moss, arquero del Wellington Phoenix, realizó la cantadita de la Navidad, al comerse un fácil balón que terminó entrando en el fondo de su portería.




  USO DE MEMORIA  
5,580,224 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.6909
Total Execution Time  0.6928
  CADENA URL  
/wellington-phoenix/2022
  GET DATOS  
$_GET['/wellington-phoenix/2022']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (36)  
0.0144  SELECT type FROM routes WHERE alias = 'wellington-phoenix'
0.0158  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 = 'wellington-phoenix' AND l.year = 2022 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.0145  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=2744 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  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=2744 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  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=2744 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  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=2744 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0146  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2744 AND type_rel = 2
0.0147  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 2744 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0148  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 (31324,214863,238574,271179,273333) ORDER BY n.cover_points DESC, update_date DESC
0.0149  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 = '2744' AND l.year = 2022 ORDER BY l.year DESC,cat.coefficient DESC
0.0149  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 = '2744' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0149  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 = 67537 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
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 = 63330 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0148  (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 calendars2022 as c ON c.league_id = l.id WHERE (c.datateam1 = 2744 or c.datateam2 = 2744) AND l.year = 2022 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0152  (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 calendars2022 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 = 2744 or c.datateam2 = 2744) AND l.year = 2022 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0150  (SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars2022 as c ON c.league_id = l.id INNER JOIN events2022 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 = 2744 or c.datateam2 = 2744) AND l.year = 2022)
0.0150  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=2744 AND l.year in (2021,2022,2023) ORDER BY l.id DESC, l.year DESC ;
0.0147  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 (72120,71581) 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.0149  SELECT count(id) as num_players from rel_players WHERE league_id = 71581 AND teamId = 2744
0.0148  SELECT count(id) as num_players from rel_players WHERE league_id = 72120 AND teamId = 2744
0.0149  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 63330 AND t.round = 26 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0147  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 = '2744' 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 = '2744' and rp.type = 4
0.0146  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 = '2744' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0157  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 events2022 e ON e.player_id = p.id AND e.league_id = 63330 WHERE rp.league_id = 63330 AND rp.teamId = 2744 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.0157  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 events2022 e ON e.player_id = p.id AND e.league_id = 63330 WHERE rp.league_id = 63330 AND rp.teamId = 2744 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0152  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 events2022 e ON e.player_id = p.id AND e.league_id = 63330 WHERE rp.league_id = 63330 AND rp.teamId = 2744 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0148  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 = 2744 AND rp.league_id = 63330 AND l.year= 2022 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0154  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=6451798 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=6451798
0.0155  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 events2022 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6451798 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.0151  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 events2022 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6451798 and (e.action = 4 or e.action = 5) GROUP BY dp.id ORDER BY cuenta DESC
0.0149  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 events2022 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6451798 and (e.action = 3 or e.action = 4) GROUP BY dp.id ORDER BY cuenta DESC
0.0151   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 events2022 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6451798 AND (e.action = 22) GROUP BY dp.id ORDER BY cuenta DESC
0.0151  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 events2022 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6451798 and (e.action = 19) GROUP BY dp.id ORDER BY cuenta DESC
0.0146  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 = 63330 ORDER BY nameShow LIMIT 100