4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Legia Warszawa Sub 19

¿Falta algún dato de este equipo?

Si tienes datos del equipo que no se encuentran en la página nos encantaría que los compartas con nosotros. Un editor de la página validará los datos y en el plazo de tiempo más breve posible completarán los datos actuales con los enviados.

Información sobre Legia Warszawa Sub 19

Enviar Datos
Información

Plantilla del Legia Warszawa Sub 19 Temporada 2023/2024

Jugador Edad Origen Altura Peso Goles Tarjetas rojas Tarjetas amarillas
Portero
22 19 pl 195 81 - - -
12 17 pl 188 - - - -
1 16 pl 192 - - - -
12 16 pl 186 72 - - -
12 16 pl - - - - -
17 pl 191 72 - - -
Defensa
14 18 pl 189 87 1 1 5
14 18 pl 175 65 - - 1
18 pl 183 74 - - -
13 17 pl 173 62 2 - 2
15 17 pl - - 1 - 1
14 17 pl - - - - -
16 18 pl 171 64 - - 3
14 17 pl 185 68 - - 3
19 18 ee 178 - - - -
14 17 pl 182 - 2 - 1
Centrocampista
17 pl 180 68 1 - 1
18 pl 179 73 1 - 1
16 18 pl 179 62 - - 3
17 17 pl - - 4 - 1
17 16 pl - - 6 - 1
6 16 pl 182 71 2 - 1
21 18 pl 176 61 4 - -
20 17 pl 182 65 5 - 2
16 17 pl - - 1 - 2
17 18 pl 175 69 1 1 3
15 18 pl - - 3 - -
18 18 pl 175 63 - - -
13 19 pl 172 65 1 - 3
17 17 pl - - 1 - 4
17 17 pl 177 65 1 - -
16 18 pl 175 60 1 - 2
16 15 pl - - - - -
18 sk 165 - 2 - 1
13 19 pl 160 50 1 - -
21 18 pl 188 76 5 - -
20 19 pl 184 75 - - -
21 19 pl 180 70 - - 1
Delantero
16 17 pl - - - - -
18 19 gr 181 - - - -
19 18 pl 181 71 9 - -
17 16 sk - - 1 - -
19 17 pl - - 5 - 1

Noticias del Legia Warszawa Sub 19

Ver últimas noticias

El día que la Youth League movió más gente que la Champions

BeSoccer - Miércoles, 02 Noviembre 2016
7 9.646

Hoy vamos a vivir un hecho insólito. El Legia-Real Madrid de la Youth League ha tenido más espectadores que su equivalente de Champions, por razones obvias.

El Real Madrid juvenil salva la papeleta de Varsovia

BeSoccer - Miércoles, 02 Noviembre 2016
1 1.289

El equipo de Guti cimentó su triunfo en los minutos finales de la primera mitad. Perdonó la goleada y encajó un tanto absurdo en la última jugada del partido.

El Real Madrid juvenil sufre para derrotar al Legia

BeSoccer - Martes, 18 Octubre 2016
0 2.763

El conjunto blanco consolidó su primera posición en el grupo tras derrotar en casa a un equipo polaco que le puso las cosas muy difíciles.

Ver más noticias del equipo»



  USO DE MEMORIA  
5,310,208 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.0611
Total Execution Time  0.0630
  CADENA URL  
/Legia-Warszawa-Sub19/2024
  GET DATOS  
$_GET['/Legia-Warszawa-Sub19/2024']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (11)  
0.0042  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 = 72876
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=66239 AND type_rel = 2
0.0020  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 66239 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0023  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 (122914,128637,128663) ORDER BY n.cover_points DESC, update_date DESC
0.0021  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 = '66239' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0019  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 = 72876 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021  (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 = 66239 or c.datateam2 = 66239) 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.0030  (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 = 66239 or c.datateam2 = 66239) 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.0022  (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 = 66239 or c.datateam2 = 66239) AND ABS(UNIX_TIMESTAMP(c.shedule)-UNIX_TIMESTAMP())<120*3600*24 AND l.year = 2024)
0.0026  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM `tables2024` 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 = 72876 AND t.round = 25 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0019  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 = 72876 ORDER BY nameShow LIMIT 100