4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
23 jugadores
Sevilla Sevilla
M. Dmitrović M. Dmitrović 32 años 189cm 81kg POR
Bono Bono 33 años 192cm 78kg POR
G. Montiel G. Montiel 27 años 175cm 65kg DEF
F. Gattoni F. Gattoni 25 años 183cm 79kg DEF
Adrià Pedrosa Adrià Pedrosa 25 años 172cm 69kg DEF
Marcos Acuña Marcos Acuña 32 años 172cm 72kg DEF
N. Gudelj N. Gudelj 32 años 187cm 77kg DEF
Kike Salas Kike Salas 22 años 188cm DEF
Juanlu Sánchez Juanlu Sánchez 20 años 186cm 68kg DEF
Loïc Badé Loïc Badé 24 años 191cm 89kg DEF
Jesús Navas Jesús Navas 38 años 170cm 60kg DEF
Óliver Torres Óliver Torres 29 años 175cm 70kg MED
Djibril Sow Djibril Sow 27 años 184cm 77kg MED
Joan Jordán Joan Jordán 29 años 185cm 74kg MED
Ivan Rakitić Ivan Rakitić 36 años 184cm 79kg MED
Manu Bueno Manu Bueno 19 años 178cm MED
Y. En-Nesyri Y. En-Nesyri 26 años 192cm 73kg DEL
Lucas Ocampos Lucas Ocampos 29 años 187cm 82kg DEL
Rafa Mir Rafa Mir 26 años 191cm 75kg DEL
Suso Suso 30 años 177cm 72kg DEL
Papu Gómez Papu Gómez 36 años 167cm 68kg DEL
Tecatito Tecatito 31 años 173cm 62kg DEL
Erik Lamela Erik Lamela 32 años 184cm 74kg DEL
23 jugadores
Manchester City Manchester City
Scott Carson Scott Carson 38 años 188cm 85kg POR
Ederson Ederson 30 años 188cm 89kg POR
Stefan Ortega Stefan Ortega 31 años 185cm 86kg POR
Rico Lewis Rico Lewis 19 años 169cm 64kg DEF
John Stones John Stones 29 años 188cm 70kg DEF
Kyle Walker Kyle Walker 33 años 183cm 83kg DEF
Joško Gvardiol Joško Gvardiol 22 años 185cm 80kg DEF
A. Laporte A. Laporte 29 años 191cm 85kg DEF
Rúben Dias Rúben Dias 26 años 187cm 83kg DEF
Nathan Aké Nathan Aké 29 años 180cm 75kg DEF
Sergio Gómez Sergio Gómez 23 años 171cm 62kg DEF
M. Akanji M. Akanji 28 años 188cm 91kg DEF
Kalvin Phillips Kalvin Phillips 28 años 179cm 72kg MED
James Mcatee James Mcatee 21 años 180cm 70kg MED
Cole Palmer Cole Palmer 21 años 189cm 74kg MED
Rodri Rodri 27 años 191cm 82kg MED
M. Perrone M. Perrone 21 años 177cm 70kg MED
Mateo Kovačić Mateo Kovačić 29 años 177cm 75kg MED
E. Haaland E. Haaland 23 años 195cm 88kg DEL
Phil Foden Phil Foden 23 años 171cm 64kg DEL
Jack Grealish Jack Grealish 28 años 180cm 74kg DEL
Julián Álvarez Julián Álvarez 24 años 170cm 68kg DEL
Oscar Bobb Oscar Bobb 20 años 175cm DEL

Equipos de esta liga

2

  USO DE MEMORIA  
4,393,904 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0033
Controller Execution Time ( Home / Category )  0.3749
Total Execution Time  0.3783
  CADENA URL  
/supercopa_europa2024/grupo0/jugadores
  GET DATOS  
$_GET['/supercopa_europa2024/grupo0/jugadores']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (21)  
0.0140  SELECT type FROM routes WHERE alias = 'supercopa_europa2024'
0.0254  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'supercopa_europa' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2024 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=133 AND type_rel = 3
0.0135  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 133 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0128  SELECT /*53 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 (1301072,1297561,230216,1281325,1273932) ORDER BY n.cover_points DESC, update_date DESC
0.0125  SELECT id,name,alias,stepParent FROM categories WHERE parentId=133 ORDER BY order_id ASC
0.0126  SELECT dt.nameShow,dt.basealias,t.id,t.teamId FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 72034 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0126  SELECT dt.id FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 72034 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 36
0.0131  SELECT dp.nick,dp.alias,dp.role,p.id,p.teamId,dp.height,dp.weight,p.team_id,p.player_id,p.squadNumber,dp.CountryCode,dp.age FROM rel_players p INNER JOIN dataplayers dp ON dp.id = p.player_id INNER JOIN datateams dt ON dt.id = p.teamId WHERE p.league_id = 72034 AND dt.id IN (1633,1102) ORDER BY dt.relations DESC,dp.role ASC
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 17:57:47' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-27 17:57:47' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 17:57:47' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-27 17:57:47' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0126  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 133 AND l.year = 2024
0.0125  SELECT e.action, count(e.action) as total, e.player_id FROM events2024 e WHERE e.league_id IN (72034) AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0128  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (72034) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (323688,675016) ORDER BY rp.in_squad = 1 DESC
0.0127  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 133 AND l.year = 2024
0.0126  SELECT e.action, count(e.action) as total, e.player_id FROM events2024 e WHERE e.league_id IN (72034) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0127  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (72034) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (52052,573136,875356) ORDER BY rp.in_squad = 1 DESC
0.0126  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 133 AND l.year = 2024
0.0125  SELECT e.action, count(e.action) as total, e.player_id FROM events2024 e WHERE e.league_id IN (72034) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10