4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Newells Old Boys II
Información
Internet

Histórico de participación

Partidos del Newells Old Boys II

Ir al LIVESCORE
15 May 18  Finalizado Gimnasia La Plata II
0 - 2
Newells Old Boys II 0
07 May 18  Finalizado Newells Old Boys II
2 - 0
Defensa y Justicia II 0
30 Abr 18  Finalizado Newells Old Boys II
1 - 2
Independiente II 0
22 Abr 18  Finalizado Boca Juniors II
3 - 1
Newells Old Boys II 0
16 Abr 18  Finalizado Newells Old Boys II
1 - 2
Talleres Córdoba II 0
09 Abr 18  Finalizado Atl. Tucumán II
2 - 2
Newells Old Boys II 0
31 Mar 18  Finalizado Newells Old Boys II
0 - 0
Tigre II 0
19 Mar 18  Finalizado Argentinos Juniors II
4 - 2
Newells Old Boys II 0
12 Mar 18  Finalizado Newells Old Boys II
2 - 2
San Martín San Juan II 7
02 Mar 18  Finalizado Banfield II
2 - 1
Newells Old Boys II 0
24 Feb 18  Finalizado Newells Old Boys II
1 - 1
Temperley II 0
16 Feb 18  Finalizado San Lorenzo II
3 - 1
Newells Old Boys II 1
09 Feb 18  Finalizado Newells Old Boys II
0 - 1
Colón II 0
03 Feb 18  Finalizado Estudiantes La Plata II
1 - 4
Newells Old Boys II 0
29 Ene 18  Finalizado Newells Old Boys II
1 - 1
Arsenal de Sarandí II 0
11 Dic 17  Finalizado Rosario Central II
2 - 2
Newells Old Boys II 0
02 Dic 17  Finalizado Newells Old Boys II
0 - 1
Racing Club II 1
27 Nov 17  Finalizado Newells Old Boys II
1 - 1
River Plate II 0
17 Nov 17  Finalizado Newells Old Boys II
1 - 1
Belgrano II 0
10 Nov 17  Finalizado Patronato II
2 - 4
Newells Old Boys II 1
31 Oct 17  Finalizado Newells Old Boys II
3 - 3
Chacarita Juniors II 0
24 Oct 17  Finalizado Vélez Sarsfield II
1 - 1
Newells Old Boys II 0
02 Oct 17  Finalizado Newells Old Boys II
1 - 0
Godoy Cruz II 0
25 Sep 17  Finalizado Lanús II
2 - 1
Newells Old Boys II 0
16 Sep 17  Finalizado Newells Old Boys II
2 - 1
Olimpo II 0
13 Sep 17  Finalizado CA Huracán II
0 - 1
Newells Old Boys II 0
28 Ago 17  Finalizado Newells Old Boys II
1 - 0
Unión Santa Fe II 0

Noticias del Newells Old Boys II

Ver últimas noticias

VÍDEO: el sorprendente golazo de Julián Aquino desde el medio del campo

Julián Aquino anotó este increíble gol lejano con la reserva de Newell's Old Boys en el triunfo por 1-2 ante Defensa y Justicia en julio del 2022.

¡'Otro Messi' jugará la Libertadores Sub 20 con Newell's!

No se trata del famoso Leo Messi, sino de Joaquín, jugador del juvenil de Newell's, que causa tendencia en Argentina por su apellido. El joven de apenas 19 años también lleva el '10' en la camiseta, aunque no es familia cercana del capitán de la 'Albiceleste'.

¡Golazo de tijera del primo de Maxi Rodríguez!

Alexis Rodríguez, primo de Maxi Rodríguez 'La Fiera', deleitó a los presentes del estadio Marcelo Bielsa con un auténtico golazo de tijera ante la reserva de Godoy Cruz.




  USO DE MEMORIA  
4,988,648 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0022
Controller Execution Time ( Home / Category )  0.4147
Total Execution Time  0.4170
  CADENA URL  
/Newells-Old-Boys-Ii/2018
  GET DATOS  
$_GET['/Newells-Old-Boys-Ii/2018']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (19)  
0.0291  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 = 39734
0.0146  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=97918 AND type_rel = 2
0.0149  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 97918 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0149  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 (305033,1100387,1165954) ORDER BY n.cover_points DESC, update_date DESC
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 = '97918' 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 = 39734 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0149  (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 calendars2018 as c ON c.league_id = l.id WHERE (c.datateam1 = 97918 or c.datateam2 = 97918) AND l.year = 2018 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 calendars2018 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 = 97918 or c.datateam2 = 97918) AND l.year = 2018 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0148  (SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars2018 as c ON c.league_id = l.id INNER JOIN events2018 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 = 97918 or c.datateam2 = 97918) AND l.year = 2018)
0.0148  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=97918 AND l.year in (2017,2018,2019) 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 (51579,44792) 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.0146  SELECT count(id) as num_players from rel_players WHERE league_id = 44792 AND teamId = 97918
0.0144  SELECT count(id) as num_players from rel_players WHERE league_id = 51579 AND teamId = 97918
0.0152  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM `tables2018` 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 = 39734 AND t.round = 27 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0148  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 events2018 e ON e.player_id = p.id AND e.league_id = 39734 WHERE rp.league_id = 39734 AND rp.teamId = 97918 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.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 events2018 e ON e.player_id = p.id AND e.league_id = 39734 WHERE rp.league_id = 39734 AND rp.teamId = 97918 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0153  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 events2018 e ON e.player_id = p.id AND e.league_id = 39734 WHERE rp.league_id = 39734 AND rp.teamId = 97918 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0153  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 = 97918 AND rp.league_id = 39734 AND l.year= 2018 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0154  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 = 39734 ORDER BY nameShow LIMIT 100