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

El Porvenir

Entrenador: Horacio Fabregat

Información
Otros Datos
  • Año de Fundación 1915
Internet

Información sobre el estadio

  • Nombre del estadio Gildo Francisco Ghersinich
  • Capacidad 14000
  • Dirección Blanco Encalada 400, Gerli
  • Teléfono +54 (11) 4225 42
  • Año de construcción 1971
Gildo Francisco Ghersinich

Partidos del El Porvenir

Ir al LIVESCORE
05 Jun 04  Finalizado El Porvenir
0 - 1
Unión Santa Fe 0
29 May 04  Finalizado Instituto
1 - 1
El Porvenir 0
20 May 04  Finalizado El Porvenir
0 - 1
Godoy Cruz 0
15 May 04  Finalizado San Martín San Juan
2 - 0
El Porvenir 0
06 May 04  Finalizado El Porvenir
3 - 1
Gimnasia Concepción 0
30 Abr 04  Finalizado Almagro
1 - 1
El Porvenir 0
22 Abr 04  Finalizado El Porvenir
2 - 1
CA Huracán 0
17 Abr 04  Finalizado Argentinos Juniors
1 - 0
El Porvenir 0
10 Abr 04  Finalizado El Porvenir
2 - 0
Gimnasia Jujuy 0
04 Abr 04  Finalizado Los Andes
1 - 1
El Porvenir 0
29 Mar 04  Finalizado El Porvenir
2 - 1
Belgrano 0
21 Mar 04  Finalizado San Martín Mendoza
1 - 3
El Porvenir 0
11 Mar 04  Finalizado El Porvenir
1 - 1
Huracán Tres Arroyos 0
06 Mar 04  Finalizado Tiro Federal Rosario
2 - 1
El Porvenir 0
28 Feb 04  Finalizado El Porvenir
4 - 0
Defensa y Justicia 0
21 Feb 04  Finalizado Def. Belgrano
0 - 1
El Porvenir 0
14 Feb 04  Finalizado El Porvenir
3 - 0
Ferro Carril Oeste 0
08 Feb 04  Finalizado Juventud Antoniana
1 - 0
El Porvenir 0
31 Ene 04  Finalizado El Porvenir
1 - 0
CAI 0
13 Dic 03  Finalizado Unión Santa Fe
2 - 1
El Porvenir 0
06 Dic 03  Finalizado El Porvenir
0 - 2
Instituto 0
02 Dic 03  Finalizado Godoy Cruz
0 - 2
El Porvenir 0
29 Nov 03  Finalizado El Porvenir
1 - 1
San Martín San Juan 0
20 Nov 03  Finalizado Gimnasia Concepción
2 - 0
El Porvenir 0
16 Nov 03  Finalizado El Porvenir
1 - 4
Almagro 0
12 Nov 03  Finalizado CA Huracán
1 - 0
El Porvenir 0
08 Nov 03  Finalizado El Porvenir
1 - 1
Argentinos Juniors 0
02 Nov 03  Finalizado Gimnasia Jujuy
0 - 0
El Porvenir 0
27 Oct 03  Finalizado El Porvenir
1 - 0
Los Andes 0
21 Oct 03  Finalizado El Porvenir
2 - 0
Juventud Antoniana 0
16 Oct 03  Finalizado Belgrano
2 - 2
El Porvenir 0
11 Oct 03  Finalizado El Porvenir
1 - 0
San Martín Mendoza 0
08 Oct 03  Finalizado C.A.I
3 - 2
El Porvenir 0
04 Oct 03  Finalizado Huracán Tres Arroyos
3 - 1
El Porvenir 0
29 Sep 03  Finalizado El Porvenir
1 - 1
Tiro Federal Rosario 0
07 Sep 03  Finalizado Defensa y Justicia
3 - 0
El Porvenir 0
30 Ago 03  Finalizado El Porvenir
1 - 0
Defensores Belgrano VR 0
22 Ago 03  Finalizado Ferro Carril Oeste
1 - 1
El Porvenir 0

Noticias del El Porvenir

Ver últimas noticias

Un técnico argentino, en estado grave por un disparo

Damián Malandra se encuentra hospitalizado tras ser intervenido después de haber recibido un disparo en el estómago el pasado jueves por la tarde.

Una 'Academia' de lo más solidaria

Racing Club tuvo un hermoso gesto con El Porvenir, equipo que milita en la C y que sufrió un robo que le dejó sin la gran mayoría de su material deportivo.

Detenidos dos 'barras bravas' por agredir y amenazar a varios jugadores

Leandro Meza, líder de la 'barra brava' de El Porvenir, y Jona fueron detenidos por agredir y amenazar a algunos jugadores del conjunto local. El motivo, el mal rendimiento del equipo.

El fútbol argentino le da el último adiós a Ricardo Calabria

El ex árbitro y ex entrenador de la Primera División Argentina, que se encontraba en coma desde hace dos años, falleció el sábado a los 73 años de edad.




  USO DE MEMORIA  
5,396,128 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.4126
Total Execution Time  0.4145
  CADENA URL  
/Porvenir/2004
  GET DATOS  
$_GET['/Porvenir/2004']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (18)  
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=6598 AND type_rel = 2
0.0147  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 6598 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0147  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 (241056,325204,564945,846193) ORDER BY n.cover_points DESC, update_date DESC
0.0150  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 = '6598' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0151  (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 calendars2004 as c ON c.league_id = l.id WHERE (c.datateam1 = 6598 or c.datateam2 = 6598) AND l.year = 2004 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0159  (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 calendars2004 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 = 6598 or c.datateam2 = 6598) AND l.year = 2004 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0149  (SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars2004 as c ON c.league_id = l.id INNER JOIN events2004 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 = 6598 or c.datateam2 = 6598) AND l.year = 2004)
0.0156  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=6598 AND l.year in (2003,2004,2005) 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 (33475,27710,27499,27497) 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.0145  SELECT count(id) as num_players from rel_players WHERE league_id = 33475 AND teamId = 6598
0.0146  SELECT count(id) as num_players from rel_players WHERE league_id = 27497 AND teamId = 6598
0.0145  SELECT count(id) as num_players from rel_players WHERE league_id = 27499 AND teamId = 6598
0.0145  SELECT count(id) as num_players from rel_players WHERE league_id = 27710 AND teamId = 6598
0.0146  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 events2004 e ON e.player_id = p.id AND e.league_id = 12948 WHERE rp.league_id = 12948 AND rp.teamId = 6598 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.0146  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 events2004 e ON e.player_id = p.id AND e.league_id = 12948 WHERE rp.league_id = 12948 AND rp.teamId = 6598 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0146  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 events2004 e ON e.player_id = p.id AND e.league_id = 12948 WHERE rp.league_id = 12948 AND rp.teamId = 6598 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0145  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 = 6598 AND rp.league_id = 12948 AND l.year= 2004 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
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 = 6598 AND rp.league_id = 12948 AND l.year= 2004 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1